Database

1 Locked

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.

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 Locked

Relational Database Concepts

Learn fundamental relational database concepts including terminology, relational model basics, and data types used in databases.

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 Locked

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.

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 Locked

SQL Intermediate Concepts

Learn intermediate SQL concepts including constraints, advanced filtering, aggregate functions, and joins. Master sorting, grouping, and combining data from multiple tables.

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 Locked

Database Design

Learn database design principles, normalization forms, and Entity-Relationship diagrams. Understand how to design efficient and normalized databases.

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 Locked

Transactions & Indexing

Master database transactions and indexing. Learn about ACID properties, transaction control, and how indexes improve query performance.

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 Locked

Advanced SQL

Explore advanced SQL features including subqueries, views, stored procedures, functions, and triggers. Learn to write complex queries and automate database operations.

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 Locked

Performance & Optimization

Learn to optimize database performance. Understand query execution, explain plans, index optimization, and database tuning techniques.

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 Locked

Security & Backup

Master database security and backup strategies. Learn about user management, access control, SQL injection prevention, and disaster recovery.

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 Locked

NoSQL & Modern Databases

Explore NoSQL databases and modern database technologies. Learn about different NoSQL types, CAP theorem, and when to use SQL vs NoSQL.

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