Autoplay
Autocomplete
Previous Lesson
Complete and Continue
The SQL Server DBA Bootcamp: Beginner To Expert (Part 2)
The SQL Server DBA Bootcamp: Beginner To Expert (Part 2)
Introduction
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
Support
Certificate of Completion
Teach online with
Configuring 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