Database Administrator – MS SQL/T-SQL/Azure SQL/SSMS

Course Curriculum

Chapter 1: Microsoft SQL Database Server Setup

Lecture 1: Introduction

Lecture 2: What is SQL Server

Lecture 3: Hardware and Software Requirements

Lecture 4: SQL Server Editions

Lecture 5: SQL Server Download

Lecture 6: SQL Server Installation

Lecture 7: SQL Server Configuration Manager

Lecture 8: SQLCMD Utility

Lecture 9: Installing SSMS

Lecture 10: Connecting to SQL Server with SSMS

Lecture 11: Creating a new user account in SQL Server

Lecture 12: Resetting SA Account

Lecture 13: Install Sample adventureWorks Database

Lecture 14: Install Sample adventureWorksDW Database

Lecture 15: Install Worldwide Importers Database

Lecture 16: Install Worldwide ImportersDW Database

Lecture 17: SQL Server Data Files

Chapter 2: Creating Databases and Tables with SSMS

Lecture 1: Create and configure a new database

Lecture 2: Create a new table

Lecture 3: Editing table structure

Lecture 4: Inserting data into table

Lecture 5: Importing data from CSV File

Lecture 6: Create a table from a flat file

Chapter 3: Database Tables Design Properties

Lecture 1: Column Properties

Lecture 2: Creating identity column

Lecture 3: Primary keys

Lecture 4: Setting default values

Lecture 5: Check constraints

Lecture 6: Unique Constraints

Lecture 7: Foreign Keys

Lecture 8: Creating relationships between tables

Chapter 4: MS SQL CRUD Operations | Database Backup & Restore

Lecture 1: What is CRUD

Lecture 2: What is SQL

Lecture 3: What is T-SQL

Lecture 4: Creating a new database

Lecture 5: Creating a new table

Lecture 6: Inserting records

Lecture 7: Retrieving data from database

Lecture 8: Table Views

Lecture 9: Updating Records

Lecture 10: Deleting Records

Lecture 11: Truncating table

Lecture 12: Stored Procedures

Lecture 13: Dropping a table

Lecture 14: Dropping a database

Lecture 15: Backing up a database

Lecture 16: Restoring a database

Chapter 5: Some MS SQL (T-SQL Commands)

Lecture 1: TOP Command

Lecture 2: GO Command

Lecture 3: USE Command

Lecture 4: DISTINCT Command

Chapter 6: Filtering Data with MS SQL (T-SQL | SQL )

Lecture 1: Introduction

Lecture 2: Filtering data with equality filters

Lecture 3: Filtering data with comparison filters

Lecture 4: Filtering data with logical comparison

Lecture 5: Filtering data with String comparison

Lecture 6: Filtering data with NULL Values

Chapter 7: Sorting Data

Lecture 1: Introduction

Lecture 2: Order By Clause

Lecture 3: Sorting by ascending

Lecture 4: Sorting by descending

Lecture 5: Sorting by multiple columns

Chapter 8: Extracting data from multiple tables

Lecture 1: Introduction

Lecture 2: Why Table joins are useful

Lecture 3: INNER Join

Lecture 4: LEFT OUTER Join

Lecture 5: RIGHT OUTER JOIN

Chapter 9: Aggregating Data

Lecture 1: Introduction

Lecture 2: COUNT Aggregate Function

Lecture 3: AVG Aggregate Function

Lecture 4: MAX Aggregate Function

Lecture 5: MIN Aggregate Function

Lecture 6: SUM Aggregate Function

Lecture 7: Grouping Data

Chapter 10: Database Performance Monitoring

Lecture 1: Introduction

Lecture 2: Using the activity monitor

Lecture 3: Collecting data

Lecture 4: Using performance monitor

Lecture 5: Using extended events

Lecture 6: Using indexes

Chapter 11: Database Security

Lecture 1: Enforcing Authentication

Lecture 2: Applying Permission level access

Lecture 3: Using Audits to check database integrity

Chapter 12: Azure Setup

Lecture 1: What is Azure

Lecture 2: What is Azure SQL

Lecture 3: Create an Azure account

Lecture 4: Accessing Azure Services

Lecture 5: Create a database in Azure