India-flagINDIA : +91-8099902123   usa-flagUSA : 201-710-8393
Call Me Back

training courses

MS sql server dba Training

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
  1. Default Instance
  2. Named Instance
  • SQL Server Services
  1. Instance aware services
  2. Instance unaware services
Installing SQL Server
  • Pre-requisites
  • Installation
  • Post Installation verification Session
Functioning of Databases
  • Database
  • Types of Database and Brief explanation
  1. System Databases
  2. User Database
  • Database Architecture
  1. Pages
  2. Extents
  3. File groups
  4. Database
  • Transaction Architecture
  • Creating Database
  • Modifying Database
  1. Adding Files
  2. Moving and renaming of Database files
  • Database modes
  • Real time Scenario
Security
  • Authentication Types in SQL Server
  • Types of Login
  1. Windows Login
  2. SQL Login
  • Creating Users and Logins
  1. Server roles
  2. Password policy
  3. Understanding Database and Server Roles
  4. Permissions
  5. Working on access level issues
  6. Orphan users Finding and Fixing
  7. Important Queries
Database Backups and Restoration
  • Database Backups
  1. Why we need backups
  • Types of Backup
  1. Full Backup
  2. Differential Backup
  3. 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
  1. Types of Restoration
  2. Attach and Detach
  3. Shrinking files
Recovery Models of Database
  • Types of Recovery Models
  1. Full
  2. Bulk Logged
  3. Simple
  • Differences between Recovery Models
  • Setting Recovery Models according to the Scenarios with examples
Automation of SQL SERVER
  • Working with SQL SERVER Agent
  1. Creating Jobs
  2. Managing Jobs and Resolving issues
  3. Monitoring Jobs
  4. Monitoring Tables
  • Log Shipping
  • Mirroring
  • Replication
  • Clustering
HIGH AVAILABILTY CONCEPTS
Log Shipping
  • Log Shipping
  1. Working with Log Shipping
  2. Terminology
  3. Pre-requisites to implement Log Shipping
  4. Different modes of Log Shipping
  5. Configuring Log Shipping
  6. Monitoring
  7. Manually Performing Failover
  8. Log Shipping Tables
  • Discussing Real Time Scenarios
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
Replication
  • Working with Replication
  1. Terminology
  2. Pre-requisites to implement to Replication
  3. Types of Replications
  4. DISTRIBUTOR Database
  5. Agents involved in Replication
  6. Configuring Replication
  7. Resolving Issues
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
Monitoring Tools
  • System Monitor
  • SQL Server Profiler
  • SQL Server and Windows Error Logs
Database Performance Tanning
  • Indexes
  • Types of indexes
  • Fragmentation in Indexes
  • Types of Fragmentations
  • Database Tuning Advisor
  • Dead Locks
  • Blockings
  • Terminating Processes
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
  • Resume Preparations
  • Providing material

If you want to know more about MS SQL Server DBA Training do not hesitate to call +91-9393 002 123 or mail us on info@unitedglobalsoft.com