Relational model
Relational model. Concepts and practical scenarios in SQL and Relational Databases.
Theme
SQL and Relational Databases
Portable relational concepts, data modeling, SQL queries, transactions, and query optimization.
480questions12 topics
Choose your next challenge
Explore the topics and choose a challenge to get started.
Data modeling and normalization
Data modeling and normalization. Concepts and practical scenarios in SQL and Relational Databases.
DDL and constraints
DDL and constraints. Concepts and practical scenarios in SQL and Relational Databases.
Queries and filters
Queries and filters. Concepts and practical scenarios in SQL and Relational Databases.
Joins
Joins. Concepts and practical scenarios in SQL and Relational Databases.
Aggregations
Aggregations. Concepts and practical scenarios in SQL and Relational Databases.
Subqueries and CTEs
Subqueries and CTEs. Concepts and practical scenarios in SQL and Relational Databases.
Window functions
Window functions. Concepts and practical scenarios in SQL and Relational Databases.
Transactions and isolation
Transactions and isolation. Concepts and practical scenarios in SQL and Relational Databases.
Indexes
Indexes. Concepts and practical scenarios in SQL and Relational Databases.
Execution plans
Execution plans. Concepts and practical scenarios in SQL and Relational Databases.
Schema migrations
Schema migrations. Concepts and practical scenarios in SQL and Relational Databases.