Microsoft 20462 Certification Training Course

Microsoft 20462 Administering Microsoft SQL Server Databases Course

Overview

This instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server database.

The course focuses on teaching individuals how to use SQL Server product features and tools related to maintaining a database.

Why

Training: get practical technical skills
Receive a certificate of course attendance
Small class size: increased instructor interaction
Authorised test center: exams taken at our premises
More hands-on: 6 weeks remote lab access included
Expert trainers: imparting real world experience

Pre-requisites

Student Prerequisites

This course requires that you meet the following 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.

Students who attend this training can meet the prerequisites by attending the following courses, or obtaining equivalent knowledge and skills:

20461C: Querying Microsoft SQL Server

Exam

There is no certification exam associated with this training course.

Skills Gained

Describe core database administration tasks and tools
Install and configure SQL Server
Configure SQL Server databases and storage
Plan and implement a backup strategy
Restore databases from backups
Import and export data
Monitor SQL Server
Trace SQL Server activity
Manage SQL Server security
Audit data access and encrypt data
Perform ongoing database maintenance
Automate SQL Server maintenance with SQL Server Agent Jobs
Configure Database Mail, alerts and notifications

This course is likely to add to the employment-related skills of the participants. The skills developed are likely to be used in the course of being an employee or working in a business.

Outline

Database Administration Overview
Introduction to the SQL Server Platform
Database Management Tools and Techniques
Planning SQL Server Installation
Installing SQL Server
Post-Installation Configuration
Introduction to Data Storage with SQL Server
Managing Storage for System Databases
Managing Storage for User Databases
Moving Database Files
Configuring the Buffer Pool Extension
Understanding SQL Server Recovery Models
Planning a Backup Strategy
Backing up Databases and Transaction Logs
Using Backup Options
Ensuring Backup Reliability
Understanding the Restore Process
Restoring Databases
Advanced Restore Scenarios
Working with Point-in-Time Recovery
Introduction to Transferring Data
Importing and Exporting Table Data
Copying or Moving a Database
Introduction to Monitoring SQL Server
Dynamic Management Views and Functions
Performance Monitor
Tracing SQL Server Workload Activity
Using Traces
Introduction to SQL Server Security
Managing Server-Level Security
Managing Database-Level Principals
Managing Database Permissions
Auditing Data Access in SQL Server
Implementing SQL Server Audit
Encrypting Databases
Ensuring Database Integrity
Maintaining Indexes
Automating Routine Database Maintenance
Automating SQL Server Management
Implementing SQL Server Agent Jobs
Managing SQL Server Agent Jobs
Managing Job Step Security Contexts
Managing Jobs on Multiple Servers
Monitoring SQL Server Errors
Configuring Database Mail
Configuring Operators, Alerts, and Notifications

What is included with the Microsoft 20462 Administering Microsoft SQL Server Databases Course?

Certificate of Attendance

Get a Certificate of Attendance to prove your commitment to learning

Our Price Beat Guarantee

Relax, we will beat competitor’s advertised price. Our course has no extra costs

Includes Course Material

Course material in digital format is included for flexibility and ease of use

Includes Mock & Test Questions

Mock test is included in the full-time courses to assist with your preparation

Highly Skilled Trainers

Our trainers are highly skilled with expertise and extensive hands-on experience

Authorised Test Centre

Take the official certification exam at Logitrain, a local VUE test centre or online

Proposed Dates, Locations & Prices

Location	Type	Duration	Price	Dates
Location	Type	Duration	Price	Dates

The supply of this course/package/program is governed by our terms and conditions. Please read them carefully before enrolling, as enrolment is conditional on acceptance of these terms and conditions. Courses run subject to availability and minimum registrations.

OUR ACCREDITATIONS

Find out why we are the leading choice to help boost your career in Australia

Prepare to get IT job ready in 8 weeks

Trained 15,000+ professionals and counting

Experienced Provider: Operating Since 2004

Trained staff from 1200+ Australian Businesses

We Have Placed Candidates In

SATISFIED CUSTOMERS

“The trainer explained everything very well. Logitrain was very helpful for me in getting a better overall understanding of CCNA. I previously had studied it 2 years earlier but required revision.”
– Felice Amenta, Senior Service Management Officer at Optus, Rating: 4.8/5

“I recently followed the ITIL Foundation course at Logitrain. The training, materials and facilities were excellent and I would not hesitate to train with Logitrain again.”
– Rob Stockey, Senior Engineer at APAC, Rating: 4.8/5

“Had a blast! Great course, will be back soon to do another.”
– Justin Blackford, Systems Administrator at Gloria Jean’s Coffee, Rating: 4.8/5

“The trainer was very patient and gave everybody the opportunity to participate.”
– Tim Symonds, Solutions Architect at MSC Mobility Solutions, Rating: 4.8/5