SQL & Database Design

SQL & Database Design

A complete track on SQL and database design: queries, joins, aggregations, subqueries, window functions, modeling, indexes, transactions and optimization

This track is designed for anyone who wants to acquire or consolidate solid skills in SQL and relational database design, useful for development, data analyst, data engineer and DBA roles, as well as for technical interviews. The track covers basic queries (SELECT, WHERE, ORDER BY), joins in all their forms, aggregate functions and grouping, subqueries and Common Table Expressions, window functions, data modeling and normalization, indexes and query optimization, transactions with the ACID properties and isolation levels, the DDL language with constraints and keys, and advanced objects such as views, stored procedures and triggers. The questions are multiple choice with progressive difficulty and are based on standard SQL, with notes on the main dialects (PostgreSQL, MySQL, SQL Server) where relevant. The track does not replace hands-on practice on a database but is useful to verify the mastery of fundamental and advanced concepts.

Quiz del percorso

Totale: 10

SQL Basics & Queries

SQL Joins

SQL Aggregation & Grouping

SQL Subqueries & CTEs

SQL Window Functions

Data Modeling & Normalization

Indexes & Query Performance

Transactions & Concurrency

DDL, Constraints & Keys

Views, Stored Procedures & Advanced SQL