SQL SERVER DBA COURSE DETAILS FOR ONLINE TRAINING <br /> <br />SQL Server Design Architecture <br />SQL Server 2008 R2 - Installation <br />SQL Server 2012 – Installation <br />SQL Server Service Accounts and Configurations <br />TCP/IP and Named Pipes Configurations <br />Authentication Modes and Authorization Techniques <br />Collation and File Stream Settings <br />SQL Server Database Design & Planning <br />SQL Database: FileGroups and Files <br />Log File Sizing and Placement <br />SQL Server Table Design & Pages <br />INSERT, UPDATE and DELETE <br />SELECT and Inner Queries <br />DELETE versus TRUNCATE <br />SELECT INTO and INSERT..SELECT statements <br />Table Compression Techniques <br />Data Integrity & Consistency <br />SQL Server Views and Schemas <br />Schema Binding and Encryptions <br />JOINS and Sub Queries <br />Nested Queries and Linking Tables <br />Uses of Indexes and Performance <br />Stored Procedures and User Defined Functions <br />DDL Triggers and DML Triggers <br />Cursors Usage and Limitations <br />Table Variables and Temporary Tables <br />T-SQL Transactions Concepts & Types <br />Locks and Memory Concepts & Locking Hints <br />Blocking Issues and Open Transactions <br />New Features in SQL Server 2012 <br /> <br />Choosing the best Isolation Level <br />Lock Hints and Administration <br />Blocking & Deadlocks Issues <br />Backup Strategies & Backup Types <br />Backup Options and Audits <br />Point-In-Time, Partial and Piecemeal Restores <br />Restore Audits and MSDB <br />Backup Jobs and Schedules <br />Replication Techniques and Types <br />Replication Monitor and Warnings <br />Peer – Peer Replication Topology and Limitations <br />Log Shipping Modes and Issues <br />Manual Failover Process and Syncup Issues <br />DB Mirroring and Encryption <br />Automatic Fail over and EndPoint Security <br />SQL Server Security & Client Security <br />Database & Object Security <br />Security Issues and Audits <br />Data Level Encryption and Data Security <br />Credentials, Proxies and Job Security <br />Import -Export Techniques <br />Tuning & Troubleshooting <br />Performance Tuning & Tips <br />Security Audits in DENALI <br />DBCC Commands and Management <br />Server Level Audits and Monitoring <br /> <br />Advanced SQL DB Administration Checklist <br />Solutions for Log Space Issues and Tempdb Issues <br />Solutions for Memory Issue and Network Issues <br />Solutions for Long Running Queries and Frequent Queries <br />DBCC and Dynamic Management Views <br />Profiler & Activity Monitor and Network Issues <br />Partitioning Techniques and Compression Techniques <br />Database Snapshots and Usage <br />Certificates, Signatures, Cryptography <br />DB Engine Tuning Advisor and Client Statistics <br />Optimizing SSIS Packages <br />Database Maintenance Plans using SSIS <br />History Maintenance and Database Shrinking Operations <br />Backup Strategies, Healthcheck Commands for Routine Backups <br />Recovery Path and Failover Options <br />DB Mail & Alert System with Notifications <br />Upgrades, Migrations and Service Pack Installations <br />SQL Server Failover Cluster Configuration <br />Active/Active and Active/Passive Cluster Configuration Issues <br />SQL Server Cluster Management Operations <br />MSDTC and Resource Governor Importance and Usage <br />Contained Databases and Always-On Availability Groups <br /> <br /> <br />*ALL OUR SESSIONS ARE COMPLETELY PRACTICAL* <br /> <br />http://sqlschool.com
