1
Database Fundamentals
Introduction to databases and database management systems. Learn what data and databases are, understand different types of databases, and explore DBMS functions and popular tools.
Locked
Please enroll in this course to access the modules.
Learning objectives:
• Understand what data and databases are
• Learn about different types of databases (RDBMS, NoSQL)
• Understand Database Management System (DBMS) functions
• Explore popular DBMS tools (MySQL, PostgreSQL, MariaDB, Oracle)
• Compare file systems vs databases
2
Relational Database Concepts
Learn fundamental relational database concepts including terminology, relational model basics, and data types used in databases.
Locked
Please enroll in this course to access the modules.
Learning objectives:
• Understand basic database terminology (Table, Row, Column, Record, Field, Schema)
• Learn about Primary Key and Foreign Key
• Understand the relational model
• Learn about tables and relationships
• Understand ER diagrams (basic idea)
• Master different data types (Numeric, String, Date & Time, Boolean, NULL)
3
SQL Basics
Master the fundamentals of SQL. Learn about SQL categories (DDL, DML, DCL, TCL), create databases and tables, perform basic data manipulation, and write simple queries.
Locked
Please enroll in this course to access the modules.
Learning objectives:
• Understand what SQL is and its categories
• Master Data Definition Language (DDL): CREATE, DROP, ALTER, TRUNCATE
• Master Data Manipulation Language (DML): INSERT, SELECT, UPDATE, DELETE
• Write basic SQL queries with WHERE clause
• Use AND/OR/NOT operators
• Apply DISTINCT and LIMIT clauses
4
SQL Intermediate Concepts
Learn intermediate SQL concepts including constraints, advanced filtering, aggregate functions, and joins. Master sorting, grouping, and combining data from multiple tables.
Locked
Please enroll in this course to access the modules.
Learning objectives:
• Understand and apply constraints (NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK, DEFAULT)
• Master sorting and filtering with ORDER BY, BETWEEN, IN, LIKE, IS NULL
• Use aggregate functions (COUNT, SUM, AVG, MIN, MAX)
• Apply GROUP BY and HAVING clauses
• Master different types of joins (INNER, LEFT, RIGHT, FULL, Self, Cross)
5
Database Design
Learn database design principles, normalization forms, and Entity-Relationship diagrams. Understand how to design efficient and normalized databases.
Locked
Please enroll in this course to access the modules.
Learning objectives:
• Understand why database design matters
• Learn about problems with poor design
• Master normalization (1NF, 2NF, 3NF, BCNF)
• Understand when and why to denormalize
• Create ER diagrams
• Understand entities, attributes, relationships, and cardinality
• Learn about weak entities
6
Transactions & Indexing
Master database transactions and indexing. Learn about ACID properties, transaction control, and how indexes improve query performance.
Locked
Please enroll in this course to access the modules.
Learning objectives:
• Understand what transactions are
• Master ACID properties (Atomicity, Consistency, Isolation, Durability)
• Use COMMIT, ROLLBACK, and SAVEPOINT
• Understand what indexing is and its types
• Learn advantages and disadvantages of indexes
• Know when not to use indexes
7
Advanced SQL
Explore advanced SQL features including subqueries, views, stored procedures, functions, and triggers. Learn to write complex queries and automate database operations.
Locked
Please enroll in this course to access the modules.
Learning objectives:
• Master subqueries (single-row, multi-row, correlated)
• Create and use views
• Understand updatable views and views vs tables
• Create stored procedures with parameters
• Understand benefits and use cases of stored procedures
• Use built-in and user-defined functions
• Create triggers (BEFORE/AFTER, INSERT/UPDATE/DELETE)
8
Performance & Optimization
Learn to optimize database performance. Understand query execution, explain plans, index optimization, and database tuning techniques.
Locked
Please enroll in this course to access the modules.
Learning objectives:
• Understand how SQL queries are executed
• Use EXPLAIN plan to analyze queries
• Identify common performance mistakes
• Optimize indexes (composite indexes, index selectivity)
• Understand index vs full table scan
• Learn database performance tuning techniques
• Use slow query logs
• Understand caching basics
• Learn about connection pooling
9
Security & Backup
Master database security and backup strategies. Learn about user management, access control, SQL injection prevention, and disaster recovery.
Locked
Please enroll in this course to access the modules.
Learning objectives:
• Understand database security principles
• Manage users and roles
• Use GRANT and REVOKE for access control
• Understand SQL injection concepts and prevention
• Learn best security practices
• Understand types of backups
• Use mysqldump for backups
• Learn restore processes
• Understand disaster recovery basics
10
NoSQL & Modern Databases
Explore NoSQL databases and modern database technologies. Learn about different NoSQL types, CAP theorem, and when to use SQL vs NoSQL.
Locked
Please enroll in this course to access the modules.
Learning objectives:
• Understand why NoSQL databases exist
• Learn about CAP theorem
• Compare SQL vs NoSQL
• Understand different types of NoSQL databases
• Learn about Document-based databases (MongoDB)
• Understand Key-Value stores
• Learn about Column-based databases
• Explore Graph databases