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.
Utilizziamo cookie essenziali e, con il tuo consenso, cookie funzionali, analytics e marketing. Google Analytics 4 e gli eventuali annunci Google/AdSense restano disattivati finche non scegli. Consulta Privacy Policy e Cookie Policy.
Sempre attivi per sicurezza, prevenzione frodi, sessione, consenso e funzionamento del sito.
Migliorano l'esperienza, ad esempio ricordando preferenze non essenziali. Non usati per profilazione pubblicitaria.
Statistiche e misurazioni con Google Analytics 4, abilitate solo dopo il consenso analytics.
Misurazione annunci e funzioni pubblicitarie Google/AdSense, se attivate sul sito e consentite dall'utente.
Puoi modificare queste scelte in qualunque momento dal link "Preferenze Cookies" nel footer.