Course: Database Basics MS SQL
SoftUni course Database Basics MS SQL - May 2018: All tasks with their solutions.
- Data Definition and Types
- Basic CRUD (Create, Read, Update and Delete)
- Built-In Functions
- Data Aggregation (Group By, Min, Max, Avg, Count, Sum)
- Table Relations (One to One, One to Many, Many ot Many)
- Joins, Subqueries and CTE Indices
- Database Programmability (Functions, Procedures and Triggers) and Transactions
Homeworks
| № | Tasks | Descriptions | Exercises | Progress |
|---|---|---|---|---|
| 1 | Databases Introduction | Description | Exercises | |
| 2 | Data Definition and Data Types | Description | Exercises | |
| 3 | Basic CRUD | Description | Exercises | |
| 4 | Built-In Functions | Description | Exercises | |
| 5 | Data Aggregation | Description | Exercises | |
| 6 | Table Relations | Description | Exercises | |
| 7 | Subqueries and Joins | Description | Exercises | |
| 8 | Database Programmability and Transactions | Description | Exercises | |
| 9 | Additional Exercises | Description | Exercises |
Exams
| Exams | Date | Descriptions | Solutions |
|---|---|---|---|
| Washing Machine Service | 24 April 2017 | Description | Solution |
| Report Service | 22 October 2017 | Description | Solution |
| Rent a Car | 3 January 2018 | Description | Solution |
| Trip Service | 24 June 2018 | Description | Solution |