Database
Sessions

Comprehensive database training covering SQL, NoSQL, and graph databases. Master data modeling, querying, and real-world database applications.

19
Sessions
3
Database Types
∞
Data
Commencer
Défiler

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

Guide

General Teaching Guide

Comprehensive overview and pedagogical strategies for the course

 Lecture 1

Lecture 1 Guide

Teaching resources for Introduction to Databases

 Lecture 2

Lecture 2 Guide

Teaching resources for SQL and Queries

 Lecture 3

Lecture 3 Guide

Teaching resources for MongoDB

 Lecture 4

Lecture 4 Guide

Teaching resources for Graph Databases

 Lecture 5

Lecture 5 Guide

Teaching resources for Advanced Topics

Practice Exercises & Solutions

Real-world database design exercises with complete solutions

Exercise

Bookstore Database

Design a complete database schema for a bookstore management system

 Exercise

E-commerce System

Build an e-commerce database with products, orders, and customers

 Exercise

University Database

Create a university management database with students, courses, and enrollments

 Exercise

Social Media Platform

Design a social network database with users, posts, and relationships

 Exercise

Normalization Exercise

Practice database normalization techniques from 1NF to 3NF

 Exercise

Referential Integrity

Master foreign keys and referential integrity constraints