Every folder have two files: 1) *.docx with exercises 2) *.sql with solutions. Main query language is T-SQL. My database tool is SQL Server Management Studio 19 and MS Word (2021) for description on exercises.
| id | Name |
|---|---|
| 4. | Data definition and data types |
| 5. | Basic CRUD |
| 6. | Built-in functions |
| 7. | Data aggregation |
| 8. | Table relations |
| 9. | Joins subqueries |
Installed SQL Server 2022, database tool like SQL Server Management Studio 19 and application who can open *.docx files.
- Clone the repo.
- Open *.docx file for current exercises, then open *.sql file and paste this content into your database tool.