Database Management Systems
Draft Version 1.9, Date 31 Dec 2023
Draft Version 1.9, Date 31 Dec 2023
10 Day(s)
🎯 LEARNING OBJECTIVES
By the end of this course, learners will be able to:
Understand DBMS concepts and compare relational and NoSQL database types.
Create databases, tables, relationships, constraints, and views.
Write SQL queries to retrieve, manipulate, and analyze data.
Develop functions, stored procedures, triggers, and dynamic SQL.
Apply transaction management, database normalization, and data integrity principles.
Design structured databases that support reliable and maintainable applications.
🧠 PREREQUISITES
Basic computer science and programming knowledge.
Understanding of data types, variables, and basic data structures.
Familiarity with application development concepts.
No prior database administration experience is required.
Relational
Analytical
Column Family
Graph
Document
Key-Value
Realtime database
Coming Soon
Coming Soon
Coming Soon
Coming Soon
Coming Soon
Coming Soon
Coming Soon
Coming Soon
Coming Soon
Coming Soon
Coming Soon
Coming Soon
Coming Soon
Coming Soon
Coming Soon
Coming Soon
Coming Soon
Coming Soon
Informal Design
Semantic
Anomalies
Null Values
Spurious tuples
Formal Design
First Normalization form
Second Normalization form
Third Normalization form
Boyce-Codd
Fourth Normalization form
Fifth normalization form
Dr. Ghoniem Lawaty
Tech Evangelist