PROJECT ORIENTED TRAINING ON SQL Server 2012 DBA – CLASSROOM @ SQL School

Post# A470819 · Posted by: contact

SQL School is one of the pioneers IT Institutions providing specialized in SQL Server 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 DBA COURSE DETAILS FOR CLASSROOM TRAINING (contents at glance):
SQL Server Basics & T-SQL Programming

SQL Server 2008 & 2012 Installation
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
New Features in DENALI (SQL Server 2012)


Basic SQL Server Administration (SQL 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 & 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


Advanced SQL Server Administration (SQL DBA)

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
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


For free Demo and further training details, please visit www.sqlschool.com or contact us.

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



related

Institute of Good Clinical Practice :- Institute of Good Clinical Practice provides internship for aspiring professionals willing to pursue career in Clinical Researc

Training Clinical Data management on Electronic Data Capture Tool EDC

SQL School provides Interactive and Practical Classroom Trainings on T-SQL, SQL DBA and MSBI (SSIS, SSAS, SSRS). All sessions are completely PRACTICAL. No PPTs nor Screenshots

Classroom Training on Microsoft Reporting Services (SSRS) (MSBI) @ SQL School

GRT Consulting is a premier niche project management consulting company. We offer information system design, development, and technical consulting.GRT is one of the leading busine

Project Management Certification in Bangalore

Salvation Tree school has been built while keeping the vision of passionately transforming lives. Our first school branch has been setup in Greater Noida. http://www.salvationtr

Schools in Greater Noida

The Asian School is among the top schools in India for co-educational Boarding .The Asian School offers co-educational education from Nursery to XII and is affiliated to the CBSE

Schools in India
Fee
INR : 10000.00
Ad Type
I am offering a class
I am:
An Individual
Contact Name
SQL School
Phone Number
04064577244
Address1
X road ,SR Nagar,Hyderabad

Contact this User

It is NOT ok to contact this poster with commercial interests.
Reply to
[email protected]