Course 01
MongoDB
Covers MongoDB from document model fundamentals through to CRUD operations, indexing, aggregation pipelines, schema design patterns, replication, sharding, and integration with Node.js and Python. Ideal for developers working with modern, scalable, and flexible application architectures.
NoSQL Aggregation Indexing Sharding
Beginner to Advanced
Course 02
PostgreSQL
Covers PostgreSQL from relational fundamentals and SQL queries through to advanced features including window functions, CTEs, JSON support, full-text search, indexing strategies, stored procedures, and database administration. PostgreSQL is one of the most feature-rich and widely adopted open-source databases in production today.
SQL Window Functions JSON Support PL/pgSQL
Beginner to Advanced
Course 03
MySQL
Covers MySQL from database and table design through to complex queries, JOINs, subqueries, stored procedures, triggers, views, indexing, performance tuning, backup and recovery, and user management. MySQL powers a vast portion of the web and remains the most widely deployed relational database globally.
SQL Stored Procedures Indexing Performance Tuning
Beginner to Advanced
Course 04
Oracle DBA
Covers Oracle Database administration from installation and architecture through to tablespace and storage management, user security, backup and recovery with RMAN, performance tuning, Oracle Net Services, and an introduction to multitenant architecture. Oracle DBA skills are highly valued in banking, finance, and large enterprise environments.
Oracle DB RMAN PL/SQL Performance Tuning
Intermediate to Advanced
Course 05
SQL Server
Covers Microsoft SQL Server from T-SQL fundamentals and query writing through to database design, stored procedures, triggers, SQL Server Agent, backup and restore strategies, security management, and performance optimisation with execution plans. SQL Server is the standard database platform across Microsoft and .NET enterprise environments.
T-SQL SSMS SQL Agent Execution Plans
Beginner to Advanced