Autoplay
Autocomplete
Previous Lesson
Complete and Continue
The SQL Server Bootcamp Course
Introduction to the SQL Server Bootcamp
Introduction (0:46)
Database Design
What is a database (1:31)
What is a table (1:02)
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
Installing Power BI
Connecting to SQL Server (4:39)
Visualizations (2:49)
Formatting Dates (2:28)
Formatting Columns and Conditional Formatting (2:29)
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
Creating Indexes - Part 1 (2:28)
Creating Indexes - Part 2 (3:39)
When not to use an Index
Fragmentation - Rebuilding Indexes (4:13)
SQL Server DBA - GDPR
Data Discovery and Classification (6:13)
Logins and Roles (3:45)
Object-level permissions (4:44)
Row-Level Security (4:07)
Dynamic Data Masking (DDM) (4:18)
Transparent Data Encryption (TDE) (5:41)
SQL Audit (4:45)
SQL Vulnerability Assessment (2:53)
Temporal Tables (4:03)
Extended Events (5:13)
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
Support
Certificate of Completion
Teach online with
Installing AWS CLI for using SQL Server RDS from the command prompt.
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock