SQL Practice

Some SQL Exercises

Note: The comments made in _extra files are not mine and I did not proof read them so take them 
    with a grain of salt.
  
Each Database folder contains these folders
  _scripts      #Contains scripts for setting up the db and filling it with base data.
  Exercises     #Contains sql files with comments describing the excercise.
  Solutions     #Contains the solution to said exercise files.
Optional
  _extra        #Extra information that can be handy. (I couldn't be arsed transforming it to an exercise)
    

Prerequisites

1. Have MS SQL Management Studio (SSMS)

'Manual'

1. Fork or download this repo.
2. Choose a database you want to work in.
3. Navigate to _scripts
4. Double click on the sql file Create_{db_name}.sql or drag it in SSMS.
5. If the folder contains a .csv file(s), set the @InitialPath variable in the sql script. The value should be the path of _scripts.

I got these create/insert scripts from school but they are shit performance wise. (u press execute and takes 2 mins to insert 300k+- rows) To combat this I've transformed it so it makes use of bulk inserts, yes I know that bulk inserts ignore constraints but you dont really need them at initialization with proper data.

6. Press F5 or press the execute button.

7. Navigate to Exercises and pick a file you want to solve.
   Note: dont forget to switch databases by either using the 'use' command or by using the dropdown list.

Me