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
Migrating a SQL Server database to Azure SQL Database using SSMS
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock