MS-SQL-Exercises

These are exercises from SoftUni course - "MS-SQL".

Table for Contents

Lecture	Content	Exercises
01.Database-Introduction	Data Management Database Engines Data Types in SQL Server Database Modeling Basic SQL Queries	-
02.Databases Introduction - Exercise	-	Create Database Create Tables Alter Minions Table Insert Records in Both Tables Truncate Table Minions Drop All Tables Create Table People Create Table Users Change Primary Key Add Check Constraint Set Default Value of a Field Set Unique Field Movies Database Car Rental Database Hotel Database Create SoftUni Database Backup Database Basic Insert Basic Select All Fields Basic Select All Fields and Order Them Basic Select Some Fields Increase Employees Salary Decrease Tax Rate Delete All Records
03.CRUD		-
04.CRUD - Exercise	-
05.Table Relations		-
06.Table Relations - Exercise	-
07.Build-IN Functions		-
08.Build-IN Functions - Exercise	-
09.Subqueries and Joins		-
10.Subqueries and Joins - Exercise	-
11.Indices and Data Aggregation		-
12.Indices and Data Aggregation - Exercise	-
13.Functions and Stored Procedures		-
14.Functions and Stored Procedures - Exercise	-
15.Triggers and Transactions		-
16.Exam Preparation I	-
17.Exam Preparation II	-
18.Exam	-