A2Z ONLINE TRAINING ( SINCE 2005 ) : Call US: +1 339 368 6489 (USA) | +91 88013 86489 (INDIA)
SQL DBA Online Training Course Content: Course content of SQL Server 2012 administration: This course aims to provide participants with the solid experience and know-how to do SQL Server 2005 & 2008,R2,2012 Administration. This course has been developed for real-world scenarios, for Production Server and Development environments with explaining real time issues. 1)Introduction SQL Server 2012. SQL-Architecture. GAM, SGAM, Pages, Extents. Database engine, Service Broker, Multiple instances, Sql server2012 editions, SQL Server 2012 databases and Objects, Database Storage (Data Files and File groups, Log Files) Sql Server Physical Structure. What is new for DBAs in SQL Server 2012? 2)Installing SQL-Server 2012. Hardware Requirements. System Configuration Checker (SSC). Installation Methods, Installation Options, Installation issues. Instances. 3)SQL Server 2012Databases. System Databases, User Databases, Database Planning, Creating databases with multiple files. 4)Security. Assigning Permissions. SQL Server Authentication Modes, Principals, Permissions, Credentials. TDE (Transparent Data Encryption) Symmetric keys, asymmetric keys Master Key Encryption & Decryption, Algorithms Certificates 5)Index maintenance Index Architecture, Types of Indexes, Creating Altering, and droping indexes, Index maintenance. Index Fragmentation & Defragmentation Rebuilding & Reorganizing. 6)Disaster Prevention and Recovery Recovery Models, Backup Types, Backup Options, Backup Strategies, Restoring Databases, Mirrored backup, Database Snapshots. 7)High Availability Introduction to High Availability Failover Clustering, Log Shipping, Database Mirroring Logshipping Logshipping configuration Log shipping maintenance Mirroring Mirroring configuration Mirroring Modes Mirroring maintenance 8)Replication Replication Basics, Replication Agents, Types, Replication Models, Replication Topology, Planning for Replication, Setting Up Replication in Management Studio, Replication Management Objects (RMO). 9)Performance tuning and monitoring. Tools: SQL Server management Studio, Log file Viewer, Sql Server Profiler, Database Engine Advisorís Server Cofiguration Manager. Command Line Tools (SQL CMD, BCP) Activity Monitor. DBCC. Capacity planning, Policy based management Resource governor AWE Auditing, Service broker Lock and Deadlocks 10)Automating Administrative tasks. Database Mails, Server Agent (creating, schedules, operators, Alerts) Maintenance Plans. 11)BI tools. SSIS,SSRS,SSAS Course Highlights 1. FAQ s according to industry level on each and every topic. 2. CV Building according to USA,UK or Indian Industry Standards. 3. Project assistance. 4. Flexible timings. 5. Certification Guidance. 6. Notes .