Homepage | Courses | Microsoft Infrastructure | SQL Server 2012 Administration  
Who we are…what do we do…how we do it  
and more...  




Microsoft Infrastructure

SQL Server 2012 Administration

Course Description
This training will teach you the Physical structure and configuration options for databases, Plan and install SQL Server, Import/Export wizards and how they relate to SSIS, Partial database containment option provided by SQL Server 2012, SQL Server security models, logins, users, and database containment with users authenticated at the database level, Assigning and using permissions, Fixed server roles, fixed database roles, user-defined server roles, and user-defined database roles and SQL Server Audit etc.

You will also gain the knowledge of Implement SQL Server Agent security, proxy accounts, and credentials, SQL Server Agent, jobs, and job history, How hot fixes, cumulative updates, and service packs are related and when to apply each type of update, Configure database mail, alerts, and notifications and also Troubleshoot SQL Server databases

Database professionals can attend this training.

Our goal is to make you a best Microsoft SQL Server 2012 Administrator in this competitive IT Industry. This Training helps you achieve SQL Server 2012 certification. 

  • Knowledge of Relational Databases
  • Basic knowledge of Microsoft Windows OS and its core functionality
  • Experience with SQL Server 2008 Administration part

Duration:  5 days Course


Module 1: SQL Server 2012 and Toolset

  • SQL Server Platform
  • Working with SQL Server Tools
  • Configuring SQL Server Services

Module 2: Preparing Systems for SQL Server 2012

  • SQL Server Architecture
  • Planning Server Resource Requirements
  • Pre-Installation Testing for SQL Server

Module 3: Installing and Configuring SQL Server 2012

  • Preparing to Install SQL Server
  • Installing SQL Server
  • Upgrading and Automating Installation

Module 4: Working with Databases

  • SQL Server Databases
  • Files and Filegroups
  • Moving Database Files

Module 5: SQL Server 2012 Recovery Models

  • Backup Strategies
  • SQL Server Transaction Logging
  • Planning a SQL Server Backup Strategy

Module 6: Backup of SQL Server 2012 Databases

  • Backing up Databases and Transaction Logs
  • Managing Database Backups
  • Working with Backup Options

Module 7: Restoring SQL Server 2012 Databases

  • Restore Process
  • Restoring Databases
  • Working with Point-in-Time Recovery
  • Restoring System Databases and Individual Files

Module 8: Importing and Exporting Data

  • Transferring Data to/from SQL Server
  • Importing and Exporting Table Data
  • Inserting Data in Bulk

Module 9: Assigning Server and Database Roles

  • Server Roles
  • Fixed Database Roles
  • Creating User-Defined Database Roles

Module 10: Authorizing Users to Access Resources

  • Authorizing User Access to Objects
  • Authorizing Users to Execute Code
  • Configuring Permissions at the Schema Level

Module 11: Authenticating and Authorizing Users

  • Authenticating Connections to SQL Server
  • Authorizing Logins to Access Databases
  • Authorizing Across Servers

Module 12: Auditing SQL Server Environments

  • Options for Auditing Data Access in SQL
  • Implementing SQL Server Audit
  • Managing SQL Server Audit

Module 13: Automating SQL Server 2012 Management

  • Automating SQL Server Management
  • SQL Server Agent
  • Managing SQL Server Agent Jobs

Module 14: Configuring Security for SQL Server Agent

  • SQL Server Agent Security
  • Configuring Credentials
  • Configuring Proxy Accounts

Module 15: Monitoring SQL Server 2012 with Alerts and Notifications

  • Configuration of Database Mail
  • Monitoring SQL Server Errors
  • Configuring Operators, Alerts, and Notifications

Module 16: Performing Ongoing Database Maintenance

  • Ensuring Database Integrity
  • Maintaining Indexes
  • Automating Routine Database Maintenance

Module 17: Tracing Access to SQL Server 2012

  • Capturing Activity Using SQL Server Profiler
  • Improving Performance with the Database Engine Tuning Advisor
  • Working with Tracing Options

Module 18: Managing Multiple Servers

  • Working with Multiple Servers
  • Virtualizing SQL Server
  • Deploying and Upgrading Data-Tiered Applications

Module 19: Monitoring SQL Server 2012

  • Monitoring Activity
  • Capturing and Managing Performance Data
  • Analyzing Collected Performance Data

Module 20: Troubleshooting Common SQL Server 2012 Administrative Issues

  • SQL Server Troubleshooting Methodology
  • Resolving Service Related Issues
  • Resolving Concurrency Issues
  • Resolving Login and Connectivity Issues


Copyright © 2006-2012 Transform IT. All Rights Reserved.
Terms of Use | Designed by Transform IT User Experience Practice
Connect With Us