TamilNadu / Trichy Classifieds / Education / Others: Education

Warning: Avoid Scams and Fraud. Unless you are sure about the other party do not get involved in financial transactions
SQL Server 2014 &2016 DBA PRACTICAL CLASSROOM TRAINING &JOB SUPPORT (Banglore)

Reply to: contact@sqlschool.com
(Please mention TamilnaduClassic.com when contacting)
**SQL School Training Institute** is one of the best training organizations providing specialized in SQL Server 2014 and 2016 DBA Training. We have been providing PRACTICAL SQL 2014 and 2016 DBA CLASSROOM TRAINING , Online Training and Video Training for the last nine years .

**All our sessions are completely Practical and Real-time.**

**PRACTICAL SQL 2014 & 2016 DBA CLASSROOM TRAINING COURSE DETAILS :**

***SQL Server Basics & T-SQL Queries***

• SQL Server Design Architecture – 2014 & 2016

• SQL Server Database Design & Planning

• SQL Server Table Design & Pages

• Table Compression Techniques

• Data Integrity & Consistency

• SQL Server Views and Schemes

• 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 2014 & 2016
***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 Encryption 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 Temp-db Issues

• Pro-filer & Activity Monitor and Network Issues

• Partitioning Techniques, DB Snapshots and Usage

• Certificates, Signatures, Cryptography, Keys and TDE
Implementation

• DB Engine Tuning Adviser and Client Statistics

• Optimizing SSIS Packages

• Database Maintenance Plans

• DB Mail & Alert System with Notifications

• Upgrades, Migrations and Service Pack Installations

• SQL Server Fail over 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: 6 weeks, every day for 1.5 hours and all sessions are completely practical. One Real-time Project included in the course, with 24x7 LIVE Server (Online Lab) for practice.

***For free SQL-DBA CLASSROOM Demo, please visit :***

http://sqlschool.com/SQLDBA-Classroom-Training.html

***Schedules for PRACTICAL SQL 2014 & 2016 DBA CLASSROOM TRAINING :***

http://sqlschool.com/register.html

Contact us today for practical SQL 2016 DBA Classroom training

**SQL School Training Institute**

**Office 1:**

108/2RT, Street No 2, Road No 1, Landmark : Beside SR Nagar Bus Stop

SR Nagar, Hyderabad - 38, India.

**Office 2:**
Sai Anu Avenue, Street no 3, Pathrika Nagar, HI-TECH City, Hyderabad -81,india.

**Call us :**

**India**

Office : +91 (0) 40 64577244

Mobile : +91 (0) 9666440801

Toll Free 24/7 : +91 (0) 90 1434 1434

**USA:**

Office: +1 (510) 400-4845


**Website :**

http://sqlschool.com/

**Follow us :**

https://www.facebook.com/sequelschool

https://www.linkedin.com/company/sql-school

https://twitter.com/sequelschool



Trichy Classifieds - SQL_Server_2014_amp_2016_DBA_PRACTICAL_CLASSROOM_TRAINING_amp_JOB_SUPPORT




Posted on: Saturday, 30 December, 2017  10:16
Expires On: Monday, 09 April, 2018  04:46

Your most reliable resource for Jobs, Cars, plots, ads, Houses, Flats, Builders, Trichy Real Estate, Services...

TamilNadu Classifieds - The Number 1 Trichy Classified Ads Portal for Trichy Others: Education Education