SQL SERVER DBA Online Training Course Content

Module1:  Starting with SQL Server

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

Module2:  Installing SQL Server

  • 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
  • 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

  • Working with SQL SERVER 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

Module 5: Always On

  • What is availability group
  • Advantages of HADRON(Always on)

 DIFFERENCES BETWEEN ABOVE HIGH AVAILABILTY CONCEPTS and ADVANCED CONCEPTS

Module1:  Monitoring Tools

  • System Monitor
  • SQL Server Profiler
  • SQL Server 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 and Databases

  • Starting SQL Server 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

 

* Windows and SQL cluster configuration
* SQL2012 new feature (Always On) Configuration