SQL DBA online training in hyderabad

MINDQ SYSTEMS:

SQL SERVER 2012 DBA COURSE DETAILS

SQL Server Basics

SQL Server 2012 Design Architecture
SQL Server Database Design & Planning
SQL Server Table Design & Page
Table Compression Techniques
Data Integrity & Consistency
SQL Server Views and Schemas
JOINS and Sub Queries
Uses of Indexes and Performance
Stored Procedures  and User Defined Functions
DDL Triggers and DML Triggers
Cursors Usage and Limitations
T-SQL Transactions Concepts & Types
Locks and Memory Concepts & Locking Hints
New Features in DENALI (SQL Server  2012)


Basic SQL Server Administration (DBA)


Blocking & Deadlocks Issues
Backup Strategies & Backup Options
Point-In-Time, Partial  and  Piecemeal Restores
Replication Techniques and Monitoring
Peer – Peer Replication Topology and Limitations
Log Shipping Modes and Issues
DB Mirroring and Encryption
SQL Server  Security & Client Security
Database & Object Security
Security Issues and Audits
Data Level Encryptions and Data Security
Performance Tuning & Tips
Import -Export Techniques
Tuning & Troubleshooting
Security Audits in DENALI
DBCC Commands and Management
Server Level Audits


Advanced SQL Administration


Log Space Issues and Tempdb Issues
Profiler & Activity Monitor and Network Issues
Partitioning Techniques,  DB Snapshots and Usage
Certificates,  Signatures, Cryptography,  Keys and  TDE Implementation
DB Engine Tuning Advisor and Client Statistics
Optimizing SSIS Packages
Database Maintenance Plans
DB Mail & Alert System with Notifications
Upgrades, Migrations and Service Pack Installations
SQL Server Failover Cluster  Configuration
Active Directory Configurations and Storage (SAN) Management
Active/Active and Active/Passive Cluster Configuration Issues
SQL Server Cluster Management Operations
MSDTC and Resource Governor Importance and Usage
Contained Databases and Always-On Availability Groups

* Resume preparation and Interview assistance will be provided.
For any further details please contact +91-9502991277 or visit
www.mindqonline.com

please mail us all queries to online@mindqsystems.com