About this course
Write reliable queries and understand tables, joins, constraints, and indexes.
View category Curriculum
Each chapter contains short lessons and quizzes. Select a lesson to open its details, read the full content, and continue to the related assessment.
1Tables and Keys2 items
Tables and Keys
Structuring dataA table groups rows of the same kind. A primary key identifies each row and a foreign key expresses a verifiable relationship.11 min Practice: Structuring dataApply “Structuring data” in a short example, then verify the result and edge cases.14 min 2Queries and Joins3 items
Queries and Joins
Combining resultsWHERE filters rows and ORDER BY defines their order. A join combines rows connected by an explicit condition.11 min Practice: Combining resultsApply “Combining results” in a short example, then verify the result and edge cases.14 min Review: SQL Server pour développeurs — 2Check the concepts and practices covered in the course.3 question(s) 3Constraints and Indexes3 items
Constraints and Indexes
Protecting and improving accessConstraints prevent invalid values. An index can speed up a frequent read, but adds write cost and should address a measured need.11 min Practice: Protecting and improving accessApply “Protecting and improving access” in a short example, then verify the result and edge cases.14 min Review: SQL Server pour développeurs — 3Check the concepts and practices covered in the course.3 question(s)