SQL DBA TRAINING FROM SQL SCHOOL

SQL SERVER DBA COURSE DETAILS FOR ONLINE TRAINING

SQL Server Design Architecture
SQL Server 2008 R2 - Installation
SQL Server 2012 – Installation
SQL Server Service Accounts and Configurations
TCP/IP and Named Pipes Configurations
Authentication Modes and Authorization Techniques
Collation and File Stream Settings
SQL Server Database Design & Planning
SQL Database: FileGroups and Files
Log File Sizing and Placement
SQL Server Table Design & Pages
INSERT, UPDATE and DELETE
SELECT and Inner Queries
DELETE versus TRUNCATE
SELECT INTO and INSERT..SELECT statements
Table Compression Techniques
Data Integrity & Consistency
SQL Server Views and Schemas
Schema Binding and Encryptions
JOINS and Sub Queries
Nested Queries and Linking Tables
Uses of Indexes and Performance
Stored Procedures and User Defined Functions
DDL Triggers and DML Triggers
Cursors Usage and Limitations
Table Variables and Temporary Tables
T-SQL Transactions Concepts & Types
Locks and Memory Concepts & Locking Hints
Blocking Issues and Open Transactions
New Features in SQL Server 2012

Choosing the best Isolation Level
Lock Hints and Administration
Blocking & Deadlocks Issues
Backup Strategies & Backup Types
Backup Options and Audits
Point-In-Time, Partial and Piecemeal Restores
Restore Audits and MSDB
Backup Jobs and Schedules
Replication Techniques and Types
Replication Monitor and Warnings
Peer – Peer Replication Topology and Limitations
Log Shipping Modes and Issues
Manual Failover Process and Syncup Issues
DB Mirroring and Encryption
Automatic Fail over and EndPoint Security
SQL Server Security & Client Security
Database & Object Security
Security Issues and Audits
Data Level Encryption and Data Security
Credentials, Proxies and Job Security
Import -Export Techniques 
Tuning & Troubleshooting
Performance Tuning & Tips
Security Audits in DENALI
DBCC Commands and Management
Server Level Audits and Monitoring

Advanced SQL DB Administration Checklist
Solutions for Log Space Issues and Tempdb Issues
Solutions for Memory Issue and Network Issues
Solutions for Long Running Queries and Frequent Queries
DBCC and Dynamic Management Views
Profiler & Activity Monitor and Network Issues
Partitioning Techniques and Compression Techniques
Database Snapshots and Usage
Certificates, Signatures, Cryptography
DB Engine Tuning Advisor and Client Statistics
Optimizing SSIS Packages
Database Maintenance Plans using SSIS
History Maintenance and Database Shrinking Operations
Backup Strategies, Healthcheck Commands for Routine Backups
Recovery Path and Failover Options
DB Mail & Alert System with Notifications
Upgrades, Migrations and Service Pack Installations
SQL Server Failover Cluster Configuration
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 OUR SESSIONS ARE COMPLETELY PRACTICAL*

http://sqlschool.com