Existing User Login

New User? Create An Account

Request new password

We Are All About You

XpertSkills - the parent company under which iCollege operates - was established in South Africa in 2003 and since then, we have grown globally in leaps and bounds with customers and partners in more than 120 countries. With employees on 3 continents and as a next-generation, virtual organization we are unconstrained by the limits that are usually associated with traditional “brick & mortar” companies.

This allows us to focus, without distraction, on reaching our ultimate goal – ensuring your ongoing success – by providing affordable, reliable, high quality and relevant learning products whilst remaining innovative and agile.

Contact Details:

Web: www.xpertskills.com
Skype: xpertskills
Mail: info@xpertskills.com
Phone: +27 10 020 2067

Physical Address:

Head Office - South Africa
16 Monte Carlo Crescent
Kyalami business Park
Johannesburg
South Africa 1684

You are here

Microsoft 70-462: Administering SQL Server 2012 Databases

E-COURSE:

Microsoft 70-462: Administering SQL Server 2012 Databases

Instructor-led video course with presentations, workbooks, games, flashcards and quizzes.
Overview

The 70-462: Administering Microsoft SQL Server 2012 online training course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database. The course focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database.

Objectives
  • Installation Planning
  • Installing SQL Server and related services
  • Implementation of a migration strategy
  • How to configure additional SQL Server components
  • Managing the SQL Server Agent
  • Database management and configuration
  • How to configure SQL Server instances
  • Implementing a SQL Server clustered instance
  • SQL Server instances management
  • How to properly Identify and resolve concurrency problems
  • The collection of and how to analyze troubleshooting data
  • Auditing SQL Server instances
  • Configure and maintain a backup strategy
  • Database restoration
  • Implementing and maintaining indexes
  • Importing and exporting data
  • Managing logins and server roles
  • Managing database permissions
  • Managing users and database roles
  • Troubleshooting security
  • Implementing AlwaysOn, database mirroring and replication
Prerequisites
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of Transact-SQL.
  • Working knowledge of relational databases.
  • Some experience with database design.
Target Audience
  • Database Professionals
  • IT Professionals

Lesson 1: Identifying the SQL Server Platform

Lesson 2: Deploying SQL Server

Lesson 3: Configuring SQL Server

Lesson 4: Managing Databases in SQL Server 2012

Lesson 5: Managing SQL Server Security

Lesson 6: Implementing Advanced Security Settings

Lesson 7: Applying Encryption and Compression

Lesson 8: Working with Indexes and Log Files

Lesson 9: Working with Backup and Restore

Lesson 10: Implementing High Availability

Lesson 11: Optimizing Server Performance

Lesson 12: Troubleshooting Issues and Recovering Databases Lesson 13: Performing Advanced Database Management Tasks

E-COURSE E-Learning Expert-led video course with presentations, workbooks, quizzes, games and flashcards.
USD 195 USD 95 51% OFF
  • 06:57:14
    + Hours Of learning
  • Includes video, presentations, workbooks, quizzes, flashcards & games
  • Receive a Certificate of Excellence on successful completion
  • Presented by highly qualified, industry leading experts
  • 12 Months access (Unless indicated otherwise)
  • 10-Day money-back guarantee
Back to Top