SQL Server Crash Course

1:24:00

Connect:

C:\>sqlcmd -S <instance>\<username>

Basic Commands

* sp = stored procedure

> sp_databases
> go

Backup Files

C:/Program Files/Microsoft SQL Server/MSSQL15.../MSSQL/Backup

Restore Backup File

1. SSMS > Databases (rclick) > Restore Database…
2. Source = Device [elipse menu]
3. Select backup devices
   1. Backup media type: File
   2. Backup media: [Add]
   3. Select .bak file

Query Order

1. SELECT
2. FROM
3. WHERE
4. GROUP BY
5. HAVING
6. ORDER BY

Processing Order:

FROM > WHERE > GROUP BY > HAVING >SELECT > ORDER BY