The SQL Server DBA Bootcamp: Beginner To Expert (Part 2)
Getting Started
-
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
-
What is a database (1:31)
-
What is a table (1:02)
-
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)
-
Quick Quiz
SQL Server DBA - 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 DBA - 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)
SQL Server DBA - 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)
Support
