SQL & Enterprise Databases

Full Roadmap67 TopicsInterview Prep18 BattlecardsProjects & Labs8 CapstonesCheatsheetSQL & DDL
Enterprise SQL & Relational Databases · Database Architect

SQL & Enterprise Databases Roadmap

A definitive, step-by-step enterprise curriculum taking you from SQL fundamentals to Enterprise Database Architect: 67 topics, 16 modules, and 8 production capstones.

67
Topics
16
Modules
22
Labs
33h
Study Time
Overall Track Mastery0 of 67 Completed
0%
x
Preview Topic (Content Locked)· Beginner
Relational Database Management Systems (RDBMS) Architecture
Introduction to Databases & SQL
Inspect Topic (Locked)
Curriculum Outline Mode · Content LockedAdmin Approval Required

Complete UiPath Lessons & Code Locked Until Admin Approval

You can preview the complete syllabus outline and curriculum breakdown. Full lesson guides, production architecture patterns, and hands-on exercises unlock once your enrollment is verified.

See what is included
Showing 67 topics · 0 completed (0%)
01
Foundation Tier·Target: Junior Database Developer0/16 Completed

Beginner

RDBMS Architecture, DDL/DML Fundamentals, SARGable Filtering & Referential Integrity

Tier Mastery0%
x
16 topics remaining
Master relational engine vs storage engine architecture and buffer pool caching
Write production DDL schemas, constraints, and data-modifying DML statements
Filter and sort datasets using comparison operators, wildcards, and null handling

  • 01
    Relational Database Management Systems (RDBMS) Architecture
    Understand client-server architecture, relational engines, storage engines, buffer pools, and write-ahead transaction logs.
    Locked25 minInspect
  • 02
    Installation & Setup (MS SQL Server & SSMS / MySQL / PostgreSQL)
    Install and configure Microsoft SQL Server Developer Edition, SQL Server Management Studio (SSMS), MySQL, or PostgreSQL.
    Locked30 minInspect
  • 03
    Database Schemas, Tables, Rows & Columns Overview
    Master database container hierarchies: Catalogs, Schemas (dbo, sales, audit), physical Tables, Rows, and Columns.
    Locked25 minInspect
  • 04
    Understanding Data Types (Numeric, String/Varchar, Date/Time, Boolean, JSON)
    Deep dive into storage footprint and performance: INT vs BIGINT, CHAR vs VARCHAR vs NVARCHAR, DATETIME2, BIT, and JSON.
    Locked30 minInspect

  • 01
    DDL (Data Definition Language): CREATE, ALTER, DROP, TRUNCATE, RENAME
    Master structural schema definition commands to build, modify, drop, truncate, and rename database objects safely.
    Locked25 minInspect
  • 02
    DML (Data Manipulation Language): INSERT, UPDATE, DELETE
    Master row manipulation commands: INSERT INTO ... VALUES, INSERT INTO ... SELECT, UPDATE with WHERE, and safe DELETE.
    Locked30 minInspect
  • 03
    DQL (Data Query Language): SELECT Statement, Aliases (AS), and DISTINCT
    Construct foundational queries using SELECT column projections, column/table aliases (`AS`), and deduplication (`DISTINCT`).
    Locked25 minInspect

  • 01
    WHERE Clause & Comparison Operators (=, !=, >, <, >=, <=)
    Filter row sets with high precision using comparison operators against numerical, date, and text columns.
    Locked25 minInspect
  • 02
    Logical Operators (AND, OR, NOT)
    Combine multiple conditional expressions using boolean logic: operator precedence, short-circuit evaluation, and parenthesis grouping.
    Locked25 minInspect
  • 03
    Range & Set Filtering (BETWEEN, IN, NOT IN)
    Filter data across continuous numeric/date ranges and discrete value sets using BETWEEN, IN, and NOT IN.
    Locked25 minInspect
  • 04
    Pattern Matching with Wildcards (LIKE, %, _)
    Search text columns using pattern matching: percent wildcard (`%`), underscore wildcard (`_`), and character brackets.
    Locked25 minInspect
  • 05
    Sorting Data (ORDER BY ASC/DESC) & Limiting Results (TOP, LIMIT, OFFSET-FETCH)
    Sort output datasets deterministically and paginate results using ORDER BY, TOP / LIMIT, and ANSI OFFSET-FETCH.
    Locked30 minInspect
  • 06
    Handling Missing Data (IS NULL, IS NOT NULL)
    Understand three-valued SQL logic: NULL representation (absence of value, not zero or blank) and proper testing.
    Locked25 minInspect

  • 01
    PRIMARY KEY & FOREIGN KEY Relationships
    Architect relational foundations: Unique entity identification, referential integrity enforcement, and cascade actions.
    Locked30 minInspect
  • 02
    UNIQUE, NOT NULL, CHECK & DEFAULT Constraints
    Enforce domain integrity at the database layer using UNIQUE indexes, mandatory NOT NULL, CHECK expressions, and DEFAULT values.
    Locked25 minInspect
  • 03
    Auto-Increment / IDENTITY Columns
    Generate sequential numerical keys using SQL Server IDENTITY, MySQL AUTO_INCREMENT, and PostgreSQL GENERATED ALWAYS AS IDENTITY.
    Locked25 minInspect
02
Specialist Tier·Target: SQL Data Specialist0/18 Completed

Intermediate

Multi-Table JOINs, Set Operators, Aggregations, Scalar Functions & Database Views

Tier Mastery0%
x
18 topics remaining
Construct high-performance multi-table JOINs across normalized schemas
Perform multi-column GROUP BY and HAVING aggregations with zero Cartesian bugs
Master string, date/time, and conversion functions alongside standard and indexed views

18 lessons in this tier are reserved for enrolled students. Module names are shown below — enroll to unlock every topic, code example, and Studio exercise inside them.

1
Aggregations & Data Grouping
3 topics locked
Locked
2
SQL Joins & Set Operations (In-Depth)
5 topics locked
Locked
3
Built-In Scalar Functions & Conditional Logic
6 topics locked
Locked
4
Subqueries & Views
4 topics locked
Locked
03
Architect Tier·Target: Senior SQL Developer / Database Engineer0/21 Completed

Advanced

Analytic Window Functions, Recursive CTEs, Stored Procedures, ACID Transactions & MERGE

Tier Mastery0%
x
21 topics remaining
Calculate running balances, moving averages, and rankings with OVER() window functions
Traverse complex graph hierarchies and org trees using recursive CTEs
Enforce transaction durability, isolation levels, deadlock resolution, and native JSON

21 lessons in this tier are reserved for enrolled students. Module names are shown below — enroll to unlock every topic, code example, and Studio exercise inside them.

1
Window / Analytical Functions
4 topics locked
Locked
2
CTEs & Temporary Structures
4 topics locked
Locked
3
T-SQL / PL-SQL Programmability
5 topics locked
Locked
4
Triggers, Transactions & Error Handling
5 topics locked
Locked
5
Advanced Data Manipulation
3 topics locked
Locked
04
Master Tier·Target: Enterprise Database Architect0/12 Completed

Job-Ready & Enterprise Mastery

3NF Normalization, Covering Indexes, Execution Plan Tuning, Security & Automation ETLs

Tier Mastery0%
x
12 topics remaining
Design normalized 3NF schemas, covering B-Tree indexes, and table partitions
Diagnose graphical execution plans to eliminate table scans and key lookups
Integrate SQL with UiPath, Power Automate, n8n, and FastMCP AI agent pipelines

12 lessons in this tier are reserved for enrolled students. Module names are shown below — enroll to unlock every topic, code example, and Studio exercise inside them.

1
Database Design, Normalization & Performance Tuning
6 topics locked
Locked
2
Security, Administration & Automation Integration
5 topics locked
Locked
3
Projects & Practical Mastery
1 topic locked
Locked
FlowCadax
Enterprise Automation & AI
RoadmapsPricing
Log InGet All-Access Pass