If you are looking to become an expert in SQL Server then join this bootcamp course.
You will learn
- How to use TSQL
- How to become a DBA (Database Administrator)
- How to use SQL Server on AWS
- How to use SQL Server on Azure
- How to use SSIS (SQL Server Integration Services)
- How to use Power BI with SQL Server
Course Curriculum
Introduction to the SQL Server Bootcamp
Available in
days
days
after you enroll
Database Design
Available in
days
days
after you enroll
Getting Started with SQL Server
Available in
days
days
after you enroll
- 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)
Available in
days
days
after you enroll
- 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)
Available in
days
days
after you enroll
- 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
Available in
days
days
after you enroll
SQL Server DBA - Introduction
Available in
days
days
after you enroll
- 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
Available in
days
days
after you enroll
SQL Server DBA - GDPR
Available in
days
days
after you enroll
SQL Server DBA - CWR Tool Kit
Available in
days
days
after you enroll
- 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
Available in
days
days
after you enroll
- 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
Available in
days
days
after you enroll
- 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
Available in
days
days
after you enroll
- 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
Available in
days
days
after you enroll