Microsoft SQL Server DBA Online Training @ SequelGate
All our training sessions are COMPLETELY PRACTICAL.
SQL SERVER DBA COURSE DETAILS - FOR ONLINE TRAINING:
SQL Server Basics & T-SQL Queries
§ SQL Server Design Architecture – 2012 & 2014
§ SQL Server Database Design & Planning
§ SQL Server Table Design & Pages
§ 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
§ Dynamic SQL and TEMP Tables
§ DDL Triggers and DML Triggers
§ Memory Usage with Triggers
§ Cursors Usage and Limitations
§ T-SQL Transactions Concepts & Types
§ Locks and Memory Concepts & Locking Hints
§ New Features in 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
Duration: 7 weeks, every day for 1.5 hours and all sessions are completely practical. One Real-time Project included in the course.
All Sessions are Completely Practical and Realtime.
For free SQL Server DBA ONLINE Demo, please visit :
Schedules for PRACTICAL SQL 2012 & 2014 DBA Online TRAINING :
Contact us today for practical SQL 2012 & 2014 DBA Online training
SequelGate Training Institute
contact@sequelgate.com
Office: (+91) 040 65358866
Mobile: (+91) 0 9030040801
Sai Anu Avenue, Street Number 3, Patrika Nagar, HITEC City, Hyderabad - 81 (India).
http://www.sequelgate.com/
No comments:
Post a Comment