462 SQL DBA Training 30 March – 2 April

462 SQL DBA Training

 

Forms part of the MCSA syllabus

Administering Microsoft SQL Server 2012 Databases 70-462

Prerequisites

Course Content:

Day 1.

Planning and Installing SQL Server 2012

  • Planning your installation
  • Installing SQL Server and Related Services

Configuring and Managing SQL Server Instances

  • Configuring SQL Server  Instances
  • Managing SQL Server Instances

Day 2

Configuring SQL Server 2012 Components

  • Configuring Additional SQL Server Components
  • Managing and Configuring Databases

Migrating, Importing and Exporting

  • Migrating to SQL Server 2012
  • Exporting and Importing Data

SQL Server Logins, Roles and Users

  • Managing Logins and Server Roles
  • Managing Users and Database Roles

Day 3

Securing SQL Server 2012

  • Managing Database Permissions’
  • Troubleshooting SQL ServerSecurity
  • Auditing SQLServer Instances

Mirroring and Replication

  • Mirroring and Databases
  • Database Replication

Clustering and AlwaysOn

  • Clustering SQL Server 2012
  • AlwaysOn availability groups

Day 4

 Troubleshooting SQL Server 2012

  • Working with Performance Monitor
  • Working with SQL Server Profiler
  • Monitoring SQL Server
  • Using the Data Collector Tool
  • Identifying Bottlenecks

Day 5

Indexes and Concurrency

  • Implementing and Maintaining Indexes
  • Identifying and Resolving Concurrency Problems

SQL Server Agent,  Backup and Restore

  • Managing SQL Server Agent
  • Configuring and Maintaining a Backup Strategy
  • Restoring SQL Server Database

Prices

  • Full-time over 5 days (R7995 )
  • Part-time over 4 weeks (2 nights per week, 3 hour sessions) (R10995 )
  • Part-time over 8 Saturdays, 3 hour sessions (R10995 )
  • Distance-learning over up to 3 months (R6995)
  • Prices exclude Vat for Vat-registered companies

Certificate

1. Upon completion of this course you will be issue with an attendance certificate to certify your attendance and / or completion of the prescribed minimum examples.
2. The Microsoft exam can be booked online and written at any Pearson VUE Exam Centre.

Bookings

  • To book any of our training courses, please click here .

Questions

Please email us

Schedules

image_pdfDownload as pdfimage_printPrint this page