Microsoft Ms Sql DBA Online Training

MSSQL Implementation & DBA

SQL DBA CONTENT

  • Module 1
    • Starting with SQL Server
    • DBA Responsibilities
    • History of SQL Server -Versions
    • SQL Server 2005/2008/2008 R2/2012 Service Packs
    • Editions of SQL Server
    • Tools of SQL Server
    • Hardware/Software Requirements
    • Instances
    • Case studies in Real-time
  • Module 2
    • Installing and Configurations
    • Installing SQL Server 2005/2008/2012
    • Pre -Installations steps
    • Post-Installations steps
    • Installing Service packs
    • Configuring Various Services
    • Startup Parameters
    • Case studies in Real-time
  • Module 3
    • Working With Data Bases
    • Working With Data Bases
    • Database Architecture
    • Creating Databases
    • Adding Files and File groups
    • Case studies in Real-time
  • Module 4
    • Implementing Security
    • Security In SQL Server 2008/2012
    • Types of Authentications
    • Understanding Server Roles/ Data Base Roles
    • Working with Users
    • Resolving Orphan users
    • Case studies in Real-time
  • Module 5
    • Backup and Restoration
    • Backup Types
    • Why we need backups
    • Setting Recovery Model
    • Understandings T-log architecture
    • Truncating Log file
    • Backup System databases
    • Backup Devices
    • Performing Restoration
    • Case studies in Real-time
  • Module 6
    • Automating Administrative Tasks
    • Working With database mails
    • Configuring Linked Servers
    • Creating SQL Server Jobs
    • Maintenance Plans
    • Case studies in Real-time
  • Module 7
    • High Availability
    • Working with Log shipping
    • Features of Log shipping
    • Configuring Log shipping
    • Monitoring Log shipping
    • Jobs
    • Log shipping Tables and Stored Procedures
    • Working with Replication
    • Configuring Replication
    • Types of replications
    • Replication agents
    • Managing Replication
    • Monitoring Replication
    • Working with Mirroring
    • Requirements of Mirroring
    • Configuring
    • Monitoring
    • Servers Involved in Mirroring
    • Modes of Mirroring
    • Mirroring failover
    • Case studies in Real-time
  • Module 8
    • Advanced administrations Concepts
    • Maintenance Plans
    • Monitoring Tools
    • Trouble Shooting
    • Monitoring and Tuning SQL Server
    • SQL Server Architecture
    • Managing Data bases
    • SQL Server Up gradations
    • Using DBCC Commands
    • Case studies in Real-time
  • Module 9
    • Clustering SQL Server
    • Introduction to Cluster Environment
    • Overview Of windows clustering
    • Requirements
    • Installing and configuring
    • Applying Service packs and Hot fixes
    • Patching clustered Instances
    • Case studies in Real-time
  • Module 10
    • SQL Server 2012 DBA Concepts
    • Introduction to SQL server 2012
    • Always on (HA/DR) Features
    • Contained databases
    • New Updated DMVs
    • Case studies in Real-time