Database Track

Database Tutorials

SQL, NoSQL, database design, indexing, transactions and query optimisation.

80
Topics
15
Beginner
29
Intermediate
36
Advanced
SQL Basics
Introduction to SQL Beginner SQL CREATE TABLE and Data Types Beginner SQL INSERT UPDATE DELETE Beginner SQL SELECT Statement Beginner SQL WHERE Clause and Filtering Beginner SQL ORDER BY and LIMIT Beginner SQL JOINs Explained Intermediate SQL GROUP BY and HAVING Intermediate SQL Aggregate Functions Beginner SQL Subqueries Intermediate SQL UNION and INTERSECT Intermediate SQL NULL Handling Beginner SQL CASE Statement Intermediate SQL Date and Time Functions Intermediate SQL String Functions Beginner
SQL Advanced
SQL Indexes Intermediate SQL Views Intermediate SQL Stored Procedures Advanced SQL Triggers Advanced SQL Transactions and ACID Advanced SQL Window Functions Advanced SQL CTEs — Common Table Expressions Advanced SQL Query Optimisation Advanced SQL EXPLAIN and Execution Plans Advanced Full-Text Search in SQL Advanced Database Cursors Advanced Partitioning Tables in SQL Advanced Materialized Views Advanced Recursive SQL Queries Advanced Database Locking Mechanisms Advanced Multi-version Concurrency Control Advanced
NoSQL
Introduction to NoSQL Databases Intermediate MongoDB Basics Intermediate MongoDB CRUD Operations Intermediate MongoDB Aggregation Pipeline Advanced MongoDB Indexing Advanced Redis Basics Intermediate Redis Data Structures Intermediate Cassandra Basics Advanced SQL vs NoSQL — When to Use Which Intermediate Firebase Realtime Database Basics Intermediate DynamoDB Basics Intermediate Elasticsearch Basics Advanced Neo4j Graph Database Basics Advanced Apache Kafka Basics Advanced Apache HBase Basics Advanced
Database Design
Database Normalization Intermediate 1NF 2NF 3NF Explained Intermediate ER Diagrams Beginner Primary Key and Foreign Key Beginner Database Relationships Intermediate Database Sharding Advanced Database Replication Advanced CAP Theorem and Databases Advanced Partitioning in Databases Advanced Database Connection Pooling Intermediate Composite Keys in Databases Intermediate Denormalisation in Databases Advanced Event Sourcing with Databases Advanced CQRS with Databases Advanced Polyglot Persistence Advanced
ORM
What is an ORM Beginner Hibernate ORM Basics Intermediate JPA — Java Persistence API Intermediate Sequelize ORM for Node.js Intermediate Prisma ORM Basics Intermediate TypeORM Basics Intermediate ActiveRecord vs DataMapper Pattern Advanced
MySQL & PostgreSQL
MySQL vs PostgreSQL Beginner MySQL Installation and Setup Beginner PostgreSQL Installation and Setup Beginner MySQL Stored Functions Intermediate PostgreSQL JSON Support Advanced Database Backup and Restore Intermediate MySQL Performance Tuning Advanced PostgreSQL Extensions Advanced PostgreSQL Triggers Advanced MySQL Replication Setup Advanced Database Monitoring Tools Intermediate Read Replicas in PostgreSQL Advanced