Jump to content

SQL Server DBA Practical Classroom Training @ SequelGate


SequelGate

Recommended Posts

SequelGate is one of the best training institutes for SQL Server Developer Training, SQL DBA Training and MSBI Training. We have been providing Classroom and Classroom Trainings and Corporate training.

 

All our training sessions are COMPLETELY PRACTICAL.

 

SQL SERVER DBA COURSE DETAILS - FOR CLASSROOM 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 Classroom Demo, please visit :

http://www.sequelgate.com/SQLServerDBA-Training.html

 

Schedules for PRACTICAL SQL 2012 & 2014 DBA Classroom TRAINING :

 

http://www.sequelgate.com/contact-us.html

 

Contact us today for practical SQL 2012 & 2014 DBA Classroom 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/

 

https://www.facebook.com/SequelGateTechnologies/

 

https://plus.google.com/110497244809691297005?hl=en

 

https://twitter.com/SequelGate

 

linkedin.com/sequelgate

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...