What you’ll learn
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
