Ga naar inhoud
SQL training
Solutions
English
Nederlands
Zoeken initialiseren
SQL training
Solutions
Theory
SQL training
SQL training
Solutions
Solutions
Solutions
2. Retrieve data
2. Retrieve data
2.1.2. Retrieving data with SELECT Assignments
2.2.2. Data types and functions Assignments
2.3.2. Filtering with WHERE Assignments
2.4.2. Sorting with ORDER BY Assignments
2.5.2. Apply Logic with CASE Assignments
3. Grouping and aggregating
3. Grouping and aggregating
3.1.2. Grouping with GROUP BY Assignments
3.3.2. Aggregating Assignments
4. Make adjustments
4. Make adjustments
4.2.2. Add and Edit Data Assignments
5. Data models
5. Data models
5.1.2. Primary and foreign keys Assignments
5.2.2. Types of relationships Assignments
6. Combine tables
6. Combine tables
6.2.2. LEFT JOIN Assignments
6.3.2. RIGHT INNER FULL Assignments
6.4.2. UNION Assignments
7. (Extra) Reuse queries
7. (Extra) Reuse queries
7.1.2. Subqueries introduction Assignments
7.2.2. Subqueries with EXISTS Assignments
7.4.2. Common table expressions Assignments
8. (Extra) In depth material
8. (Extra) In depth material
8.3.1. Quiz Assignments
Theory
Theory
SQL training
1. Introduction
1. Introduction
1.1.1. Introduction training
1.2.1. Introduction SQL
1.3.1. Introduction DbGate
2. Retrieve data
2. Retrieve data
2.1.1. Retrieve data with SELECT
2.1.2. Retrieve Data with SELECT Assignments
2.2.1. Data types and functions
2.2.2. Data types and functions Assignments
2.3.1. Filtering with WHERE
2.3.2. Filtering with WHERE Assignments
2.4.1. Sorting with ORDER BY
2.4.2. Sorting with ORDER BY Assignments
2.5.1. Apply logic with CASE
2.5.2. Apply Logic with CASE Assignments
2.6.1. Comments
2.7.1. Interim summary
3. Grouping and aggregating
3. Grouping and aggregating
3.1.1. Grouping with GROUP BY
3.1.2. Grouping with GROUP BY Assignments
3.2.1. Output order statements
3.3.1. Aggregate
3.3.2. Aggregating Assignments
3.4.1. Interim summary
4. Make adjustments
4. Make adjustments
4.1.1. Adding and removing tables
4.2.1. Add and modify data
4.2.2. Add and modify data Assignments
4.3.1. Interim summary
5. Data models
5. Data models
5.1.1. Primary and foreign keys
5.1.2. Primary and foreign keys Assignments
5.2.1. Types of relationships
5.2.2. Types of relationships Assignments
5.3.1. Interim summary
6. Combining tables
6. Combining tables
6.1.1. Introduction
6.2.1. LEFT JOIN
6.2.2. LEFT JOIN Assignments
6.3.1. RIGHT INNER FULL
6.3.2. RIGHT INNER FULL Assignments
6.4.1. UNION
6.4.2. UNION Assignments
6.5.1. Interim summary
7. (Extra) Reuse queries
7. (Extra) Reuse queries
7.1.1. Subqueries introduction
7.1.2. Subqueries introduction Assignments
7.2.1. Subqueries with EXISTS
7.2.2. Subqueries with EXISTS Assignments
7.3.1. Subqueries with IN, ANY and ALL
7.4.1. Common table expressions
7.4.2. Common table expressions Assignments
7.5.1. Views
7.6.1. Variables
8. (Extra) In depth material
8. (Extra) In depth material
8.1.1. Indexing
8.2.1. Styling conventions
8.3.1. Quiz Assignments
9. Conclusion
9. Conclusion
9.1.1. Conclusion
Solutions
Here you will find the solutions to the exercises.