In this repository all the workshops of Databases II are provided, simply follow the links below to start a workshop.
| Workshop | Topics |
|---|---|
| 01 - Basics Revisited | Revisit your SQL Basics. |
| 02 - Subqueries | Usage of subqueries in the main query. |
| 03 - Views | Re-using a query using a view. |
| 04 - Common Table Expressions | Recursive querying using a CTE. |
| 05 - Stored Procedures | Learn about re-using code with Stored Procedures. |
| 06 - Triggers | Learn about cascading actions with triggers. |
| 07 - Cursors | Learn about navigating through data with cursors. |
| 08 - Temporary Tables | Learn about storing temp. data. |
| 09 - Dynamic SQL | Learn about writing flexible SQL statements. |
| 10 - Performance | Learn about writing performant queries using Indices. |
| 11 - Data Formatting | Learn about formatting and transforming your data structure using XML |
| 12 - Transactions | Learn about isolation levels and transactions. |
In certain workshops a .IPYNB file is provided, this file can be opened with Azure Data Studio and can give you some more insight. Basically it combines SQL statements which can be executed and some additional information how the statement works.
Please feel free to open issues, fix bugs/typo's or provide feedback. If you want to learn more about Pull Requests, Forks and why we use them in this repository, this Medium Article can provide some insight