Database Sessions

Comprehensive database training covering relational databases, NoSQL, and graph databases

Relational Databases (SQL)

Core lectures covering database fundamentals, modeling, and SQL querying

Lecture 1

Introduction to Databases

Understanding data organization, database concepts, and relational database fundamentals

Lecture 2

Database Modeling

Entity-relationship diagrams, normalization, and designing effective database schemas

Lecture 3

Querying with SQL

MySQL DML operations: INSERT, SELECT, UPDATE, DELETE, and JOIN queries

Lecture 4

Advanced Aggregations

GROUP BY, HAVING, window functions, partitions, RANK, and SUM OVER

Lecture 5

Real-world Practice

Querying the Northwind database, optimization techniques, and best practices

Special Topic

Directory Servers

LDAP, directory services, and specialized database applications

MongoDB (NoSQL)

Document-oriented database fundamentals and practical NoSQL implementation

Part 1

MongoDB Fundamentals

Introduction to NoSQL databases and MongoDB basics

Part 2

MongoDB Operations

CRUD operations, queries, and document manipulation

Part 3

Advanced Queries

Complex querying patterns and aggregation pipelines

Part 4

Data Modeling

Schema design patterns for document databases

Part 5

Scaling & Performance

Replication, sharding, and performance optimization

Neo4j (Graph Databases)

Graph database concepts and Cypher query language

Part 1

Graph Database Fundamentals

Introduction to graph databases, nodes, relationships, and Neo4j basics

Part 2

Cypher Query Language

Advanced querying with Cypher, patterns, and graph traversal

Part 3

Advanced Topics

Complex graph patterns and real-world applications

Teacher Resources

Comprehensive teaching guides for each lecture session

General Teaching Guide Lecture 1 Guide Lecture 2 Guide Lecture 3 Guide Lecture 4 Guide Lecture 5 Guide

Practice Exercises & Solutions

Real-world database design exercises with complete solutions

Bookstore Database E-commerce System University Database Social Media Platform Normalization Exercise Referential Integrity