CEIT390 Database Management Systems
This course delves into the core principles of database management systems, focusing on conceptual modeling, relational database design, and advanced database techniques. Students will explore theoretical foundations and practical implementations to master the art of managing and designing efficient databases.
- Understand the theoretical foundations and architectures of database systems.
- Develop practical skills in conceptual modeling and relational database design.
- Master SQL, including advanced features for database programming.
- Analyze and optimize database performance using normalization techniques.
- Apply concurrency control and transaction management principles in database systems.
Course Objectives
Learning Materials
Resources
- W3Schools: SQL Basics
- Basic SQL Tutorials
- YouTube: "SQL Course for Beginners" Playlist
- Intro to SQL: Querying and Managing Data
- YouTube: "Database Management Systems" Playlist
📍 Beginner
Roadmaps
Skills to Learn
- Understanding database fundamentals and basic SQL commands.
- Creating simple ER diagrams and relational schemas.
- Writing advanced SQL queries with triggers and constraints.
- Performing database normalization and analyzing dependencies.
- Work with joins, subqueries, and indexing
- Understanding transaction processing and concurrency control mechanisms
- Designing and implementing robust relational database systems.
- Work with stored procedures and functions
- Use constraints and transactions for data integrity
- Learn about NoSQL and distributed databases