Module1:  Starting with SQL Server DBA

• Responsibilities of Database Administrator
• Types of DBAs
• History of SQL Server DBA
• Editions of SQL Server DBA
• Tools of SQL Server DBA
• Differences between Standard and Enterprise editions
• Instances types in SQL Server DBA
  • Default Instance
  • Named Instance
• SQL Server DBA Services
• Instance aware services
• Instance unaware services

Module2:  Installing SQL Server DBA

• Pre-requisites
• Installation
• Post Installation verification Session

Module3:  Functioning of Databases

•  Database
• Types of Database and Brief explanation
  • System Databases
  • User Database
• Database Architecture
  • Pages
  • Extents
  • File groups
  • Database
• Transaction Architecture
• Creating Database
• Modifying Database
  • Adding Files
  • Moving and renaming  of Database files
• Database modes
• Real time Scenario

Module4:  Security

• Authentication Types in SQL Server DBA
• Types of Login
  • Windows Login
  • SQL Login
• Creating Users and Logins
  • Server roles
  • Password policy
  • Understanding Database and Server Roles
  • Permissions
  • Working on access level issues
  • Orphan users Finding and Fixing
  • Important Queries

Module5:  Database Backups and Restoration

• Database Backups
  • Why we need backups
• Types of Backup
  • Full Backup
  • Differential Backup
  • Transaction Log Backup
• Copy-only, Mirrored, Split and Tail log Backups
• Differences between backups
• Backup Strategy
• Understanding how the data moving from Log to Data File, CHECKPOINT
• Monitoring the space usage of Log File and fixing
• Checking the backup files VALID or CORRUPTED
• Backup storage tables
• Important Queries
• Performing  Restorations
  • Types of Restoration
  • Attach and Detach
  • Shrinking files

Module6:  Recovery Models of Database

• Types of Recovery Models
  • Full
  • Bulk Logged
  • Simple
• Differences between Recovery Models
• Setting Recovery Models according to the Scenarios with examples

Module7:  Automation of SQL Server DBA

• Working with SQL Server DBA Agent
• Creating Jobs
• Managing Jobs and Resolving issues
• Monitoring Jobs
• Monitoring Tables
• Log Shipping
• Mirroring
• Replication
• Clustering

                                             HIGH AVAILABILTY CONCEPTS

Module1:  Log Shipping

• Log Shipping
  • Working with Log Shipping
  • Terminology
  • Pre-requisites to implement Log Shipping
  • Different modes of Log Shipping
  • Configuring Log Shipping
  • Monitoring
  • Manually Performing Failover
  • Log Shipping Tables
• Discussing Real Time Scenarios

Module2:  Database Mirroring

• Working with Database Mirroring
  • Terminology
  • Pre-requisites to implement Mirroring
  • Pre check mirroring ports ENABLED or DISABLED
  • Architecture
  • Operating Modes
  • Differences between Modes
  • Port numbers involved in Mirroring
  • Requirements for Mirroring
  • Configuring Mirroring
  • Mirroring failover
  • Issues on Mirroring

Module3:  Replication

• Working with Replication
• Terminology
• Pre-requisites to implement to Replication
• Types of Replications
• DISTRIBUTOR Database
• Agents involved in Replication
• Configuring Replication
• Resolving Issues

Module4: Clustering

• Introduction about clustering
• Clustering Architecture
• Importance of IP’s involved in Clustering
• SAN importance
• Drive dependency
• Nodes in Clustering
• Important commands

                ** DIFFERENCES BETWEEN ABOVE HIGH AVAILABILTY CONCEPTS**

ADVANCED CONCEPTS

Module1:  Monitoring Tools

• System Monitor
• SQL Server DBA Profiler
• SQL Server DBA and Windows Error Logs

Module2:  Database Performance Tanning

• Indexes
• Types of indexes
• Fragmentation in Indexes
• Types of Fragmentations
• Database Tuning Advisor
• Dead Locks
• Blockings
• Terminating Processes

Module3:  Managing the SQL Server DBA and Databases

• Starting SQL Server DBA in Single user mode
• Changing the Default path of Database files
• Modifying the Logical and Physical names of database files

High Lights:

• Discussions on Real time scenarios
  
• Replying to Questioner mails on subject doubts
  
• Resume Preparations
  
• Providing material