SQL Server Database Administrator Part-1

Learn SQL Server Admin basics: Installation, configuration, databases, security, backups and restores concepts

What you'll learn
Learn SQL Server database administration step by step. Installation, Configuration, Working with databases, Security, Database Backups and Restores, DB Mail.
Installing and Configuration SQL Server
Working with Databases and database architecture and common database issues
Working with Security, Backups and automation, Database Mail

Description
SQL Server Database Administration Part-1 covers all necessary topics to enter as a DBA. This course covers the administration basics including the following concepts.

This course is the startup course to become SQL Server Database Administrator. You can opt for Part-2 to become complete SQL Server DBA. In Part-2 I will discuss all high availability concepts including Log Shipping, Database Mirroring, Always On, Replication, Clustering and Performance Tuning concepts along with troubleshooting common issues.

Introduction to SQL Server

Application Architecture

DBA - Roles and Responsibilities

Introduction to SQL Server

Introduction to SQL

SQL Server Tools

SQL Server Services

How to Start/Stop Services

SQL Server Instances

Default and Named Instances

Instance Summary

Installation Pre-Requisites

SQL Server Installation

Installing using Configuration File

Working with Configurations

Verifying Installation using summary.txt file

Configuring Data and Log File Locations

Configuring ErrorLogs

Using Trace Flags

Configuring Backup Folder Paths

Patching SQL Server

How to rollback the patches

Configuring Memory

Configuring CPU

Configuring Remote Connections

Basic Query Life Cycle Stages

Configuring DAC

Working with Databases both System and User Defined

System Databases

Moving master, msdb and TempDB databases

Database Architecture

Log File Architecture- VLFs, Blocks, LSN

Data File Architecture - Extents, Pages

Page Architecture

Types of Pages

Database States

Database Suspect Mode scenarios

Errors 17207, 17204

Rebuilding master database

Troubleshooting common database issues

Working with Transaction Log file and its common issues

Working with Security Features

Users, Permissions and Role management

Server Roles

Database Roles

Orphan users, how to resolve orphan users

Creating users with passwords from SQL Server 2012

Encryptions

Recovery Models

Checkpoints

Types of Checkpoints

Backups and Restores

Different Types of Backups

Full, Differential, T.Log backups

File, Filegroup Backups

Copy-only backups

Backup Compression

Restoring databases

Database Recovery States

How to take tail log backup

checksum and SQL Server Backups

checksum and restores

common backup and restore issues

Who this course is for:
Freshers, SQL Server developers, Oracle DBAs, any student who wants to become SQL DBA