Database Sessions
Comprehensive database training covering relational databases, NoSQL, and graph databases
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
Practice Exercises & Solutions
Real-world database design exercises with complete solutions