Introduction to the SQL Server Bootcamp
Database Design
Getting Started with SQL Server
-
Download and Installing SQL Server on the Windows Server environment (9:02)
-
Using SQL Server Management Studio (5:01)
-
Named Instances (1:17)
-
Assignment : Install a 'Named Instance' SQL Server
-
Setup and creating test data - VERY IMPORTANT (1:09)
-
MDF vs LDF Files
-
Creating a database using SSMS (2:33)
-
Creating databases using TSQL (2:30)
-
Creating, deleting and altering a table using TSQL (7:40)
-
Creating, altering and deleting a table using SSMS (4:11)
-
Multiple File Groups - What they are (2:16)
-
Multiple File Groups - Practical (3:56)
-
Quick Quiz
SQL Server Developer - Using Microsoft SQL (TSQL)
-
SELECT Statement (4:04)
-
UNION Statement (1:28)
-
DATE Functions (5:08)
-
CASE Statements (3:10)
-
JOINS : INNER, LEFT AND RIGHT JOINS (11:36)
-
Which JOIN is better? PART 1 (4:20)
-
Which JOIN is better? PART 2
-
COUNT Statement (3:23)
-
SUM Statement (2:39)
-
AVG (Average) Statement (3:29)
-
GROUP BY Statement and Having Statement (4:19)
-
Insert Statements (2:57)
-
INSERT - Further Reading
-
Update Statements (2:52)
-
UPDATE - Further Reading
-
Delete Statements (2:26)
-
DELETE - Further Reading
-
IF / ELSE (4:53)
-
IF / ELSE Further Reading
-
Stored Procedures (3:35)
-
Views (2:29)
-
Assignment : Learn TSQL
-
SQL Quiz
SQL Server Developer - SQL Server Integration Services (SSIS)
-
Installing SQL Server Data Tools
-
Creating an SSIS Package (1:41)
-
Data Flow Task (10:05)
-
Data Viewer (1:13)
-
Execute SQL Task (2:10)
-
Variables (4:18)
-
For Loop Container (3:28)
-
Foreach Loop Container (5:36)
-
Debugging and Logging (2:23)
-
Deploying an SSIS Package (3:21)
-
Running a SSIS Package from SQL Server Agent (1:42)
SQL Server Developer - Introduction to Power BI
SQL Server DBA - Introduction
-
SQL Server Configuration Manager (3:23)
-
SA vs Windows Account (3:55)
-
SQL Server Maximum Memory Setting (2:17)
-
Database Default Locations (1:08)
-
SQL Server Agent (10:25)
-
Backing up and restoring a database - Overview (2:27)
-
Backing up and restoring a database using SSMS (1:56)
-
Backing up and restoring a database using TSQL (1:29)
-
Backing up and restoring - Further Reading
-
Assignment : Backing up and restoring
-
Detaching and Attaching Databases (2:26)
-
The System databases (1:47)
-
sp_cwr_what - What is running? (2:17)
-
'Killing' processes (1:59)
SQL Server DBA - Performance Tuning
SQL Server DBA - GDPR
SQL Server DBA - CWR Tool Kit
-
Download the toolkit
-
crw_what - This will show you what is happening on your server (2:14)
-
sp_cwr_databasestatus = This will find out the status of your databases (1:11)
-
sp_cwr_howlongnow = This will show you how long a backup,restore or an index rebuild will take (0:39)
-
sp_cwr_info = This will show you information about your server (1:10)
-
sp_cwr_findit.sql = This finds information that could be in and table within a database (1:26)
SQL Server Cloud - Amazon RDS
-
What will you need?
-
Why use a cloud based database system? (1:45)
-
Setting up billing alerts (4:34)
-
Creating a SQL Server Database on RDS using the AWS Console (19:56)
-
Installing AWS CLI for using SQL Server RDS from the command prompt. (2:03)
-
Configuring AWS CLI for using SQL Server RDS from the command prompt. (6:19)
-
Creating a SQL Server Database on RDS using AWS CLI (7:11)
-
Delete RDS Instance using AWS CLI (0:58)
-
Assignment : Create yourself an RDS Instance
-
Create a RDS SQL Server Database (2:28)
-
Creating a snapshot of a SQL Server RDS Database (7:54)
-
Assignment : Backup and restore from a snapshot
-
Performance monitoring (4:45)
-
Steps on backing up the database
-
Creating a S3 Bucket (1:32)
-
Creating Option Groups (3:43)
-
Migrate, backup and restore native SQL Server RDS Database to S3 (5:46)
SQL Server Cloud - Azure SQL Database
-
What is an Azure Database and what can you configure? (2:31)
-
What will you need?
-
Setting up billing alerts on Azure (4:41)
-
Creating a Azure SQL Database using the Azure Portal (8:43)
-
Assignment : Creating a database
-
Delete Resource Groups, save money!!!! (1:18)
-
Creating a Virtual Machine (VM) SQL Server Database on Azure (8:18)
-
Geo Replication - Replicating your database (8:26)
-
Performance monitoring a Azure SQL Database (2:39)
-
Restore a native SQL Server Azure Database (1:57)
-
Tags - what are they and how do you use them? (3:14)
-
Elastic Pool (3:32)
-
Dynamic Data Masking (6:00)
-
Stretching a local database and table to Azure SQL Database (8:56)
-
Checking your database before migration to Azure (5:17)
-
Migrating a SQL Server database to Azure SQL Database using SSMS (8:19)
-
Migrating a local Database to Azure SQL Database using Data Migration Assistant (6:08)
-
Migrating to a SQL Server Virtual Machine - Part 1
-
Migrating to a SQL Server Virtual Machine - Part 2 (7:43)
SQL Server Cloud - Azure Virtual Machines
-
Getting Started (2:57)
-
Regions and Availabilty Options (5:31)
-
Image (6:26)
-
Azure Spot Instance (4:59)
-
Virtual Machine Size (5:35)
-
Authentication Type and Inbound Port Rules (2:53)
-
Windows Licencing (1:57)
-
Disk Options (2:45)
-
Network Interface (3:10)
-
Load Balancing (2:36)
-
Configure monitoring and management options for your VM (2:28)
-
Extensions and Custom Data (2:00)
-
Hosts Proximity placement group and VM generation (3:32)
-
SQL Server Settings (3:25)
-
Tags (2:19)
-
Create a Virtual Machine with SQL Server (3:39)
-
Connect to the SQL Server Virtual Machine (4:51)
-
Delete Resources Reminder (1:29)
Support
