|
SQL DBA Online Training @ SQL School
Posted Date:
28 Jun 2011
|
Posted By: sai
Member Level: Silver
|
| Name: |
SQL DBA Online Training @ SQL School |
| Address: |
Madhura nagar, Hyderabad |
| City: |
Hyderabad |
| State: |
Andhra Pradesh |
| Telephone Number: |
09666440801 |
| Email: |
contact@sqldbatraining.com |
| Official website: |
www.sqldbatraining.com |
|
Realtime SQL Server and DBA Online Training is provided with LIVE databases and Case Studies.
SQL SERVER Administration [SQL DBA] Course Contents:
SQL Server basics and T-SQL:
SQL Server Design Architecture
Database Design and Table Design Principles
Compression Techniques and Capacity Planning
Data Integrity & Consistency
Views and Data Security
JOINS and Sub Queries and Query Tuning
Indexes and Performance Tuning
Procedures & Functions
DDL and DML Triggers
Cursors, Schemas and Synonyms
Transactions Concepts, Locking Hints and Locking Problems
TEMPDB Usage and Issues
SQL Server Administration - Junior DBA Tasks:
Blocking & Deadlocks - Detection and Prevention
Partitioning Techniques for better performance
DB Snapshots and Usage
Backup & Restore Techniques
Replication Techniques & Peer-Peer Replication
Log Shipping
DB Mirroring
Security Management
Performance Tuning & Troubleshooting Issues
Import -Export Techniques
Clustering Configuration and Issues
SQL Server Administration - Production DBA Tasks:
Cryptography, Certificates and Signatures
Service Broker and Message Communication
Query Troubleshooting
SQL Server Profiler
DB Engine Tuning Advisor
SQL CMD , BCP and SMO
Maintenance Plans and Security
Database Mail and Alert Management
Clustering Procedures and management
Server and Database Upgrades
Server adn Database Migrations
Client Level Statistics and optimizations
DB Report Design and DBA Dashboards
ALL CONCEPTS WILL BE DISCUSSED PRACTICALLY.
No Screenshots not PPTs during the sessions.
We assure you technical quality of our sesssions. Job Support is also provided.
For more details, please contact us:
contact@sqldbatraining.com
SQL School
M: 09666440801
O: 040-6457 7244 (Hyderabad, India)
US: 214-628-5666
|
Training Courses
|
Add Course to this Training Center
|
Add Course to this training Center |
|
|
|
Follow us on Twitter: https://twitter.com/dotnetspider
|
|