Database Administrator (DBA) | Developer- MS SQL Server,TSQL

Course Curriculum

Chapter 1: Microsoft SQL Server Setup

Lecture 1: Introduction

Lecture 2: What is SQL Server

Lecture 3: What is a DBA

Lecture 4: SQL Server Editions

Lecture 5: Hardware | Software Requirements

Lecture 6: Download SQL server

Lecture 7: Install SQL Server

Lecture 8: Install SSMS

Lecture 9: SQL Server Configuration Manager

Lecture 10: SQLCMD Utility

Lecture 11: Schema

Lecture 12: Connecting SSMS to SQL Server

Lecture 13: Please Note

Chapter 2: Installing Sample Databases

Lecture 1: Database Concepts

Lecture 2: Install Adventureworks 2014

Lecture 3: Install Adventureworks 2016

Lecture 4: Install AdventureworksDW 2016

Lecture 5: Install World Wide Importers Database

Lecture 6: Install World Wide ImportersDW Database

Chapter 3: Creating Database Objects

Lecture 1: Create and configure a new database

Lecture 2: Create a new table

Lecture 3: Edit Table Structure

Lecture 4: Manually Inserting Data into database

Lecture 5: Import data from csv file

Lecture 6: Create a table from a flat file

Lecture 7: SQL Server Data Files

Chapter 4: Database Table Design Properties

Lecture 1: Creating an identity column

Lecture 2: Primary keys

Lecture 3: Setting default values

Lecture 4: Check constraints

Lecture 5: Unique Constraints

Lecture 6: Foreign Keys

Lecture 7: Creating relationships between tables

Chapter 5: SQL Server Profiler – DBA Tool

Lecture 1: What is SQL Server Profiler

Lecture 2: How SQL Server Profiler can help DBA's

Lecture 3: SQL Server Profiler Architecture

Lecture 4: SQL Server Profiler Terminology

Lecture 5: Permissions required to access SQL Server Profiler

Lecture 6: How to start SQL Server Profiler

Lecture 7: Stimulating database activity

Lecture 8: How to start a trace

Lecture 9: How to load a saved trace

Lecture 10: Exploring events selection

Lecture 11: Creating a custom trace from scratch – part 1

Lecture 12: Creating a custom trace from scratch – part 2

Lecture 13: Creating a custom trace from scratch – part 3

Chapter 6: Creating CRUD Stored Procedures

Lecture 1: What is CRUD

Lecture 2: What are stored procedures

Lecture 3: Basic Application Stucture

Lecture 4: Permission required to create stored procedures

Lecture 5: Ways to create stored procedures

Lecture 6: Creating CRUD Stored Procedures

Lecture 7: Naming Convention for CRUD Stored Procedures

Lecture 8: Stored Procedures for CREATE CRUD Operation

Lecture 9: Stored Procedures for READ CRUD Operation

Lecture 10: Stored Procedures for UPDATE CRUD Operation

Lecture 11: Stored Procedures for DELETE CRUD Operation

Chapter 7: Database Backup & Recovery

Lecture 1: Please Note

Lecture 2: Enabling Log Shipping

Lecture 3: Copy database

Lecture 4: Performing Full SQL Server Database Backup

Lecture 5: Performing Differential SQL Server Backup

Lecture 6: Performing Transactional Log Backup

Lecture 7: Performing Database Recovery

Lecture 8: Lab Exercise 1

Lecture 9: Lab Exercise 2

Chapter 8: Monitoring SQL Server Performance

Lecture 1: Please Note

Lecture 2: Introduction

Lecture 3: Activity Monitor

Lecture 4: Collecting data

Lecture 5: Performance Monitor

Lecture 6: Extended Events

Lecture 7: Using Indexes

Chapter 9: Database Security & user accounts

Lecture 1: Creating a new user account

Lecture 2: Resetting System Admin Account

Lecture 3: Enforcing Authentication

Lecture 4: Applying permission level access

Lecture 5: Checking database integrity with audits

Chapter 10: Querying Data with Transact-SQL

Lecture 1: What is SQL

Lecture 2: What is Transact-SQL ( T-SQL)

Lecture 3: Creating database with T-SQL

Lecture 4: Creating table with T-SQL

Lecture 5: Inserting data with T-SQL

Lecture 6: Querying data

Lecture 7: Views

Lecture 8: Updating Data

Lecture 9: Backing up data with T-SQL

Lecture 10: Deleting Data

Lecture 11: Truncating Table

Lecture 12: Dropping Table