SQL Server Database Administrator Part-1

Learn SQL Server Administration step by: Installation, configuration, databases, security, backups and restores concepts

Ratings: 4.31 / 5.00




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

What You Will 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

Who Should Attend!

  • Freshers, SQL Server developers, Oracle DBAs, any student who wants to become SQL DBA