TamilNadu / Salem Classifieds / Education / Others: Education

Warning: Avoid Scams and Fraud. Unless you are sure about the other party do not get involved in financial transactions
Complete Practical Training on MS SQL Server DBA with T-SQL 2016 Online Course (Hyderabad)

Reply to: contact@sqlschool.com
(Please mention TamilnaduClassic.com when contacting)
SQL School Training Institute is an ISO Certified Organization and Microsoft Learning Partner offering real-time, practical trainings exclusively on SQL Server Technologies - SQL Server Development (SQL Dev), SQL Database Administration (SQL DBA), Microsoft Business Intelligence and Data Warehouse (MSBI / DWH) Training. We also provide trainings on Microsoft SQL Azure and Power BI courses.

We offer Instructor-Led LIVE Online Training, Classroom Training and On-demand Video Training with COMPLETE REAL-TIME and INTERACTIVE Practical Sessions. All our training courses include Real-time Projects, Certifications, Weekly Mock Interviews, Placement, and Assistance and free 24x7 LIVE Online Lab.

SQL DBA (with Server, T-SQL, Azure SQL DBA):

SQL Server Basics & T-SQL Queries

• SQL Server Design Architecture – 2014 & 2016,2017

• 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,2017

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

SQL Azure (Azure SQL Dev, Azure SQL DBA) :

Module I: AZURE SQL DATABASE

• Azure Cloud Integrtion

• Azure Cloud Configurations

• Azure SQL Database Configuration

• Develop Azure SQL Database

• Azure SQL Database Migrations

• INtegrating with Azure SQL Database

• MCSA Certifications

Module II: AZURE SQL DBA

• Automated DB Recovery, GEO Replicatton

• Security Managment- Azure SQL DB

• Audits and Threat Detection

• Performance Tuning in Azure SQL DB

• Database Synchronization

• Azure Virtual machine, Other Clouds

• MCSA Certifications

Duration For SQLDBA(with sever,T-SQL Azure): 8.5 Weeks

For free SQL-DBA Online Demo, please visit :

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

Schedules for PRACTICAL SQL 2014 & 2016,2017 DBA ONLINE TRAINING :

http://sqlschool.com/register.html

Office:

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

SR Nagar, Hyderabad - 38, India.

Contact us:

SQL School Training Institute

ISO 9001:2008 Certified Organization for Training

Authorized Microsoft Partner (ID# 4338151)

Regd: Sequel gate Innovative Technologies Pvt. Ltd.

India:

Toll free (24x7): +91 (0) 9014341434

Office: +91 (0) 40 64577244 Mobile: +91 (0) 9666440801

USA: +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





Salem Classifieds - Complete_Practical_Training_on_MS_SQL_Server_DBA_with_T_SQL_2016_Online_Course

Salem Classifieds - Complete_Practical_Training_on_MS_SQL_Server_DBA_with_T_SQL_2016_Online_Course




Posted on: Wednesday, 10 January, 2018  18:38
Expires On: Friday, 20 April, 2018  13:08

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

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