Relational Databases (SQL)
Core lectures covering database fundamentals, modeling, and SQL querying
Introduction to Databases
Understanding data organization, database concepts, and relational database fundamentals
Lecture 2Database Modeling
Entity-relationship diagrams, normalization, and designing effective database schemas
Lecture 3Querying with SQL
MySQL DML operations: INSERT, SELECT, UPDATE, DELETE, and JOIN queries
Lecture 4Advanced Aggregations
GROUP BY, HAVING, window functions, partitions, RANK, and SUM OVER
Lecture 5Real-world Practice
Querying the Northwind database, optimization techniques, and best practices
Special TopicDirectory Servers
LDAP, directory services, and specialized database applications
MongoDB (NoSQL)
Document-oriented database fundamentals and practical NoSQL implementation
MongoDB Fundamentals
Introduction to NoSQL databases and MongoDB basics
Part 2MongoDB Operations
CRUD operations, queries, and document manipulation
Part 3Advanced Queries
Complex querying patterns and aggregation pipelines
Part 4Data Modeling
Schema design patterns for document databases
Part 5Scaling & Performance
Replication, sharding, and performance optimization
Neo4j (Graph Databases)
Graph database concepts and Cypher query language
Teacher Resources
Comprehensive teaching guides for each lecture session
General Teaching Guide
Comprehensive overview and pedagogical strategies for the course
Lecture 1Lecture 1 Guide
Teaching resources for Introduction to Databases
Lecture 2Lecture 2 Guide
Teaching resources for SQL and Queries
Lecture 3Lecture 3 Guide
Teaching resources for MongoDB
Lecture 4Lecture 4 Guide
Teaching resources for Graph Databases
Lecture 5Lecture 5 Guide
Teaching resources for Advanced Topics
Practice Exercises & Solutions
Real-world database design exercises with complete solutions
Bookstore Database
Design a complete database schema for a bookstore management system
ExerciseE-commerce System
Build an e-commerce database with products, orders, and customers
ExerciseUniversity Database
Create a university management database with students, courses, and enrollments
ExerciseSocial Media Platform
Design a social network database with users, posts, and relationships
ExerciseNormalization Exercise
Practice database normalization techniques from 1NF to 3NF
ExerciseReferential Integrity
Master foreign keys and referential integrity constraints