LIVE ONLINE TRAINING ON SQL Admin PRODUCTION ACTIVITIES

Published date: June 28, 2016 | 7:59 am | Posted by: SQLSchool
  • Location: Hyderabad, Delhi City, Delhi, India

SQL School is one of the training organizations providing specialized in SQL Server 2012 DBA Training. We have been providing Online Training, Classroom Training and Corporate Training for the last SEVEN years. All our sessions are completely Practical and Real-time.



SQL SERVER DBA COURSE DETAILS FOR ONLINE TRAINING



SQL Server Basics & T-SQL Queries



SQL Server Design Architecture – 2008 R2 & 2012

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



All Sessions are Completely Practical and Realtime.



For free demo, please visit http://sqlschool.com/SQLDBA-Online-Training.html

SQL School Training Institute

contact@sqlschool.com



Office: (+91) 040 64577244

Mobile: (+91) 0 9666440801





Address: 108/2RT, Road No 1, SR Nagar, Land Mark: Beside Bus Stop, Hyderabad, India.

http://www.sqlschool.com


Ad ID: 25978


Share by email Share on Facebook Share on Twitter Share on Google+ Share on LinkedIn Pin on Pinterest

Contact seller Share

Useful information

  • Avoid scams by acting locally or paying with PayPal
  • Never pay with Western Union, Moneygram or other anonymous payment services
  • Don't buy or sell outside of your country. Don't accept cashier cheques from outside your country
  • This site is never involved in any transaction, and does not handle payments, shipping, guarantee transactions, provide escrow services, or offer "buyer protection" or "seller certification"

Related listings