Sign In Start Learning

Systems, Databases & Cloud

Module 1

Operating Systems

Processes & Threads

Memory Management & Virtual Memory

File Systems & I/O

Concurrency & Synchronization

Module 1 Quiz

Module 2

Database Engineering

Relational Database Design & Normalization

Advanced SQL: Window Functions, CTEs, Indexing

NoSQL Databases: MongoDB, Redis, Cassandra

Database Transactions & ACID Properties

Module 2 Quiz

Module 3

Distributed Systems

CAP Theorem & Consistency Models

Microservices Architecture

Message Queues & Event-Driven Systems

Consensus Algorithms: Paxos & Raft

Module 3 Quiz

Module 4

Cloud & Infrastructure

Cloud Computing Models: IaaS, PaaS, SaaS

AWS Core Services: EC2, S3, RDS, Lambda

Infrastructure as Code with Terraform

Kubernetes & Container Orchestration

Module 4 Quiz

Module 5

AI & Machine Learning Engineering

Machine Learning Pipeline

Neural Networks & Deep Learning

Model Deployment & MLOps

LLMs & Prompt Engineering

Design a Scalable Distributed System

Module 5 Quiz

Back to course overview

TEC 301Database EngineeringAdvanced SQL: Window Functions, CTEs, Indexing

Lesson· 35 min

Advanced SQL: Window Functions, CTEs, Indexing

Writing on the board…

Previous

Relational Database Design & Normalization

Next

NoSQL Databases: MongoDB, Redis, Cassandra