Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Learn comprehensive database management systems concepts through this 15-hour video course covering fundamental DBMS principles, SQL programming, and advanced database topics. Master data modeling starting with basic database concepts and file system drawbacks, then progress through DBMS architecture, users, and applications. Install and configure Oracle 11g database software while exploring client-server architecture fundamentals. Develop proficiency in SQL through hands-on practice with DDL and DML commands, including data insertion, querying with WHERE clauses, operators, NULL handling, and data modification operations. Apply SQL constraints including NOT NULL, CHECK, UNIQUE, DEFAULT, PRIMARY KEY, and FOREIGN KEY constraints with cascading options. Design effective database schemas using Entity Relationship (ER) modeling techniques, cardinality ratios, and ER-to-relational mapping, plus Enhanced Entity Relationship (EER) modeling for complex scenarios. Understand three-schema architecture, data independence principles, and core DBMS components. Execute advanced SQL operations including GROUP BY, HAVING, ORDER BY clauses, and various join types such as equi-joins, non-equi joins, self-joins, natural joins, cross joins, and outer joins. Analyze database design quality through functional dependencies, inference rules, closure operations, and equivalence testing. Implement proper database normalization from first normal form through fifth normal form, including Boyce-Codd normal form and decomposition testing. Explore relational algebra operations and query optimization techniques using heuristic approaches. Manage concurrent database access through transaction processing, locking mechanisms, and two-phase locking protocols including strict and rigorous implementations. Handle system failures using recovery techniques such as deferred update, immediate update, and shadow paging methods. Evaluate schedule recoverability and test serializability using precedence graphs. Optimize database performance through indexing strategies including primary, secondary, dense, sparse, and multilevel indexes, plus B+ tree structures. Conclude with an introduction to NoSQL databases, exploring alternative data models, CAP theorem, and BASE properties for modern distributed systems.
