OD20761C – Querying Data with Transact-SQL

Database diagram used for some learning (Bikestore)

The rest is here:

In MSSM, on every object there it a property options, if you do some changes, you can press the script before the change is applied to get the SQL used.

Run just portions of the query, mark the section and execute:

docs microsoft sql server

https://docs.microsoft.com/nb-no/sql/?view=sql-server-ver15

CASE expression

https://github.com/spawnmarvel/t-sql/blob/master/module3.sql

Joins

https://github.com/spawnmarvel/t-sql/blob/master/module4_multiple_tables.sql

INNER JOIN (Get all that matches on both tables)

SELF JOIN, related to get the manger

Change schema:

Right-click on the specific table name and choose Design option
Right-click on the window->properties
And we are there (after the change, save solution and disconnect-connect.

Connected again:

View all functions made or present in database:

Then I am done (summer 2020):