DBMS LESSON 1:What is Data | What is Database |What is DBMS |What is Database Systems | Applications
This will be a playlist that will detail lesson by lesson the DATABASE SYSTEMS UNIT taught in the university and college settings using real world examples. The playlist will detail the following core topics that I teach in our university.
#introduction to dbms,#what is database
Overview of database Systems: Definition, types of database systems, advantages and disadvantages.
File system environment, Database System environment. Components of DBMS, typical DBMS functions,
Conceptual Data Model: Types of data models, Mapping cardinalities, relationship sets, types of relationships
Quiz
Drawing ERD
Data Normalization: Definition, Advantages and disadvantages, Normalization steps
Relational Algebra: union, projection, rename, intersection etc
Relational database systems: relational data structure, properties of a relation, structured query language components of SQL
DDL, DML and DCL sql statements, joins, aggregate functions etc
Quiz
Transaction Management and Concurrency control: properties of transactions, interference, deadlocks, deadlock control.
Database Recovery management: Causes of database failures, transaction and recovery, causes of failures. Recovery protocols
Overview of database Systems: Definition, types of database systems, advantages and disadvantages.
File system environment, Database System environment. Components of DBMS, typical DBMS functions,
Conceptual Data Model: Types of data models, Mapping cardinalities, relationship sets, types of relationships
Quiz
Drawing ERD
Data Normalization: Definition, Advantages and disadvantages, Normalization steps
Relational Algebra: union, projection, rename, intersection etc
Relational database systems: relational data structure, properties of a relation, structured query language components of SQL
DDL, DML and DCL sql statements, joins, aggregate functions etc
Quiz
Transaction Management and Concurrency control: properties of transactions, interference, deadlocks, deadlock control.
Database Recovery management: Causes of database failures, transaction and recovery, causes of failures. Recovery protocols