VERSION 2020-2021
In this repository all the workshops of Databases II are provided, simply follow the links below to start a workshop.
To start any workshop, install the required software and databases by following the installation guide
| Workshop | Topics | Notebook |
|---|---|---|
| 01 - Basics Revisited | Revisit your SQL Basics. | Notebook |
| 02 - Subqueries | Usage of subqueries in the main query. | Notebook |
| 03 - Views | Re-using a query using a view. | Notebook |
| 04 - CTE | Learn to use Common Table Expressions | Notebook |
| 05 - DDL | Define your database and tables using the Data Definition Language. | |
| 06 - Data Warehousing | Learn about ETL and data warehousing. | None |
| 07 - Window Functions | Learn about partitioning data | Notebook |
| 08 - Stored Procedures | Learn about re-using code with Stored Procedures. | Notebook |
| 09 - Triggers | Learn about cascading actions with triggers. | Notebook |
| 10 - Cursors | Learn about navigating through data with cursors. | Notebook |
| 11 - Temporary Tables | Learn about storing temp. data. | Notebook |
| 12 - Dynamic SQL | Learn about writing flexible SQL statements. | None |
| 13 - Performance | Learn about writing performant queries using Indices. | None |
| 14 - Data Formatting | Learn about formatting and transforming your data structure using XML | Notebook |
| 15 - Transactions | Learn about isolation levels and transactions. | None |
| 16 - PowerBI | Find and collect data from different sources and create visual reports. | None |
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