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
SQL Server Maximum Memory Setting
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock