database-developer - Introduction to Modern Databases

Search⌘ K

Introduction to Modern Databases

0%

1.Introduction to Databases

About This Course What Is a Database?Evolution of Database Systems Types of Databases

2.Database Models and Architecture

Data Models Overview Schema and Instance Three-Level Architecture Components of a DBMS Practice Exercises on Database Architecture

3.Relational Model

Fundamentals of Relations Keys in Relational Schema Integrity Constraints Codd’s 12 Rules Practice Exercises on the Relational Model

4.Entity-Relationship Modeling

ER Modeling Basics ER Diagram Creation Relationships and Cardinality Advanced ER Concepts Practice Exercises on ER Modeling

5.SQL Fundamentals

Introduction to SQL Data Definition Language ER to Relational Mapping Data Manipulation Language (DML)SELECT Queries Basics Working with NULLs and Expressions Set Operations Practice Exercises on SQL

6.Relational Algebra and Relational Calculus

Introduction to Relational Algebra Join Operations Tuple Relational Calculus Domain Relational Calculus Practice Exercises on Relational Algebra and TRC

7.Advanced Database Concepts

Joining Tables Aggregate Functions and Grouping Subqueries and Nested SELECTs Window Functions Conditional Logic in SQL Practice Exercises on Advanced SQL

8.Schema Design and Normalization

The Database Design Process Functional Dependencies Normal Forms BCNF and Beyond Denormalization and Performance Practice Exercises on Normalization

9.Transactions and Concurrency Control

Transactions and ACID Transaction Control in SQL Isolation Levels Locking Mechanisms Deadlocks and Concurrency Strategies Practice Exercises on ACID

10.Indexing and Query Optimization

Indexing Fundamentals Using EXPLAIN Plans Query Optimization Techniques Materialized Views and Caching Partitioning and Sharding Practice Exercises on Indexing and Query Optimization

11.NoSQL Databases Overview

Relational vs. NoSQL: Why NoSQL?MongoDB Basics Modeling NoSQL Data Querying in NoSQL Systems Practice Exercises on NoSQL

12.Conclusion

Conclusion and Recap

Mock Interview

database-developer