DBMS

Inroduction

• Difference between Data and information

• What is Database?

• Why do we use database rather than files?

• What is Database Management System (DBMS)?

• What is Application Program?

• What is user Interface (UI)?

• What is Database Schema?

• What is Database instance?

• Database Administrators and Database Users

• What is single-tier, Two-tier and Three-tier Architecture of Software?

• What do you mean by Data Model?

Structural Query Language (SQL)

• Some Questions

• Some question for Database design and SQL

• Write SQL to create the database and tables.

• Aggregate Functions

• Use of Procedure in Mysql

• Simple Example of MySQL Procedure

• Calculation of CGPA using Procedure

• Trigger example using MySQL database

• How to create user in MySQL?

Data Model

• What is Data Model?

• What is Entity Relationship Model?

• What is Relational Data Model?

• What is Hierarchical Data Model of database?

• What is Network Data Model?

• What is Object-Oriented Data Model?

• What is Object-Relational Data Model?

• What is associative data model?

Entity Relationship Model (ER Model)

• Drawing ER model from Real Life Problem

Relational Algebra

• What is relational Algebra?

ABOUT

Statlearner

Statlearner STUDY

Statlearner