SQL Server 2012 DBA training Bangalore| MS SQL Server DBA Institute


SQL Server DBA Advanced training Bangalore

MICROSOFT SQL SERVER 2012 DBA ADVANCED

(Clustering, High Availability, SQL AlwaysON)

sql server 2012 training bangalore, sql server 2012 class bangalore, sql server 2012 training institute bangalore, ms sql server training 2012 course, best sql server 2012 training institute in bangalore

 

Course Description

SQL Server 2012 DBA training provides knowledge and skills to maintain a Microsoft SQL Server 2012 database. The course focuses on teaching individuals to use SQL Server 2012 product features and tools related to maintaining a database. You will be confident to perform SQL Server database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.

SQL Server 2012 DBA Training in Bangalore Syllabus

SQL Server 2012 DBA Training Course pre-requisites:

Basic knowledge of SQL Server or any DBMS is recommended

SQL Server 2012 DBA Training Duration:

Weekend Batches: 20 hours/ 3 hours per day
Weekday Batches: 20 hours/ 2 hours per day

SQL Server 2012 DBA Training Timings:

Weekend Batches: 8AM or 11 AM or 2 PM
Weekday Batches: 8 AM

SQL Server 2012 DBA Course Trainer Profile:

Certified & Well experienced real time SQL server professional working with leading MNC.

sql server 2012 dba training institute bangalore, ms sql server 2012 dba training course, best sql server 2012 dba training institute in bangalore, sql server 2012  dba training bangalore, sql server 2012 dba training bangalore, microsoft sql server 2012

Availability:

Weekend & Weekday trainings available

SQL Server 2012 DBA TrainingLab & Practice:

High End Servers & Setups available for Lab practice

SQL Server 2012 DBA Training Course Topics:

SQL Server 2012 Log Shipping
(1) Overview of Log shipping
(2) Pre-requisites of Log shipping
(3) Configure Log shipping
(4) Log shipping and other High Availability Features described.
(5) Standby Mode in Log shipping
(6) Monitoring and basic troubleshooting of Log shipping

LAB MODULE:
Implementing and Configuring Log shipping using GUI and T-SQL Scripts between two databases

SQL Server 2012 Database Mirroring
(1) Mirroring Overview
(2) Pre-requisites of Mirroring
(3) Configure Mirroring with Windows Authentication
(4) Changing Operating modes with description
(5) Role switching in Mirroring
(6) Automatic and Forceful Failover techniques
(7) Monitoring Mirrored databases
(8) Performance in Mirroring -Techniques and Scenario’s

LAB MODULE:
Implementing and Configuring Database Mirroring
Configuring using Windows Authentication.
Failover (manual and automatic)

SQL Server 2012 Replication
(1) Types of replication
(2) Benefits of each replication types
(3) Replication Architecture
(4) Replication Objects – Articles, Publications, Subscriptions
(5) Basic overview of Replications in Industry
(6) Snapshot Replication
(7) Transactional Replication
(8) Merge Replication
(9) Peer-to-Peer Transactional replication
(10) Push and Pull subscription
(11) Replication Monitoring and its Usage
(12) Implementing Snapshot replication
(13) Implementing and Configuring Transactional Replication
(14) Implementing Merge replication
(15) Configuring Distribution database
(16) Understanding various components of replication Objects
(17) Basic Troubleshooting in replication
(18) Jobs related to Replication

LAB MODULE:
Implementing and Configuring Snapshot Replication

Implementing and Configuring Transactional Replication
Implementing and Configuring Merge Replication
Configuring Distribution
Troubleshooting Scenario in Transactional replication

Windows and SQL Clustering in SQL Server 2012 
(1) Overview of Windows Clustering
(2) What’s all about WSFC ?
(3) Windows Cluster Pre-requirements
(4) Windows Cluster Components
(5) Windows Clusters Resources
(6) Cluster Groups
(7) Most frequent Terminologies used in WSFC
(8) Possible and Preferred Owners
(9) Cluster Failover
(10) Health Check
(11) Roles and Service Applications in WSFC
(12) Resource Dependency
(13) Overview of Quorum
(14) Types of Quorum
(15) Pre-requisites of installing SQL Cluster
(16) Installing SQL Server as a Cluster
(17) Adding SQL Cluster to another Node
(18) SQL Server Resources
(19) Monitoring Cluster components
(20) Failover Cluster and its resources
(21) Troubleshooting Cluster failovers (Approach only)
(22) Troubleshooting SQL Installation failures (Approach only)
(23) Best Practices for Windows and SQL Cluster Failover

LAB MODULE:
Implementing SQL Clustering

SQL Server Clustering and Always On
(1) Overview of Windows Clustering
(2) What’s all about WSFC ?
(3) Windows Cluster Pre-requirements
(4) Windows Cluster Components
(5) Windows Clusters Resources
(6) Cluster Groups
(7) Most frequent Terminologies used in WSFC
(8) Possible and Preferred Owners
(9) Cluster Failover
(10) Health Check
(11) Roles and Service Applications in WSFC
(12) Resource Dependency
(13) Overview of Quorum
(14) Types of Quorum
(15) Pre-requisites of installing SQL Always On
(16) Always On Availability Groups
(17) Configuring Availability Modes
(18) Selecting Failover Modes
(19) Configuring Readable Secondary replicas
(20) Configuring Listener’s in Always On
(21) Managing Always On using SSMS
(22) Failover Always On Availability Groups
(23) Adding Databases to Availability Groups
(24) Backup database in Replicas
(25) Synchronous/Asynchronous modes in Always On

Troubleshooting and Monitoring in SQL Server 2012

(1) Performance Monitoring Tools and Concepts DBAs Need to Be Familiar With
(2) Performance Monitor Counters for SQL Server
(3) Using PAL to Automatically Create Reports for SQL Server
(4) Using SSMS to Monitor Performance
(5) SQL Server Set tings: Optimize for Ad-Hoc Workloads and Forced Parameterization
(6) Using the Database Engine Tuning Advisor to Diagnose Performance Issues
(7) DMVs (Dynamic Management Views) and DMFs (Dynamic Management Functions)
(8) Common DMVs/DMFs for Monitoring
(9) Identifying performance issues Using DMVs and DMFs
(10) DMVs/DMFs for Monitoring Users and Database Activity
(11) Locking and Blocking
(12) Waits and Queues
(13) Using SQL Server Profiler
(14) Extended Events
(15) Default Performance dashboards and Reports
(16) Find High CPU queries
(17) Understanding SQL Error Logs
(18) Blocking and Deadlocks

LAB MODULE:
Troubleshooting High CPU (Approach Only)
Creating Blocking and Deadlock Scenarios and troubleshooting.
Configuring Extended Events
Configuring SQL Profiler trace
PAL Implementation
Glance of other tools

Click here to download SQL Server 2012 DBA Training Syllabus

Call us for batch details: 08041501359, 9741431318

 <--PREV: Sql Server Advanced DBA Training