Scripting School Provides Ant Online Training , AngularJS Online Training, Backbone js Online Training , Node.Js Online Training , JavaScript Online Training, LUA Online Training, Groovy Scripts Online Training , Groovy on Grails Online Training , HTML5 Online Training , Maven Online Training , Perl Script Online Training , PowerShell Online Training , Python Online Training , PHP Online Training , Ruby Script Online Training , Ruby on Rails Online Training , R Scripts Online Training , TCL Script Online Training , Unix Shell Script Online Training , VBScript Online Training ,Hadoop Online Training, Advanced Java Online Training, Core Java Online Training, Hibernate Online Training, J2EE Online Training, Spring Online Training, .NET Online Training, Microsoft BI Online Training, Microsoft SSAS Online Training, Microsoft SSIS Online Training, Microsoft SSRS Online Training, SharePoint BI Online Training, SharePoint Online Training, Windows Server 2008 Admin Online Training, Cognos Online Training, Datastage Online Training, Informatica Online Training, OBIA Online Training, OBIEE Online Training, Teradata Online Training, Advanced Perl Online Training, Android Online Training, Drupal Online Training, Joomla Online Training, PHP Online Training, Python Online Training, Salesforce Online Training, SAS Clinical Online Training, SEO Online Training, Veritas Volume Manager Online Training, Web Designing Online Training.

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



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