Relational Databases and Datawarehousing verbetersleutel

Alle oplossingen per oefeningenreeks die op Chamilo staat, dus NIET de oefeningen van op de Powerpoints.

Inhoudstafel

Northwind

• Excercises Northwind 1b. SQL Review GROUP BY and Statistical Functions Northwind
• Excercises Northwind 1c. SQL Review JOIN Northwind
• Excercises Northwind 2a. SQL Advanced Subqueries Northwind
• Excercises Northwind 2c. SQL Advanced Views Northwind
• Excercises Northwind 2d. SQL Advanced CTE Northwind
• Excercises Northwind 3. SQL Window Functions Northwind
• Excercises Northwind 4ac. SQL Stored Procedures Northwind
• Excercises Northwind 4b. SQL Cursors Northwind
• Excercises Northwind 4c. SQL Triggers Northwind
• Excercises Northwind 4d. SQL Tables and User Defined Types Northwind
• Excercises Northwind 5. SQL Indexen Northwind

Corona

• Excercises Corona 1. SQL Review Corona
• Excercises Corona 2a. SQL Advanced Subqueries Corona
• Excercises Corona 2d. SQL CTE Corona
• Excercises Corona 3. SQL Window Functions Corona
• Excercises Corona 4a. SQL Stored Procedures Corona
• Excercises Corona 4b. SQL Cursors Corona
• Excercises Corona 4c. SQL Triggers Corona