Microsoft 70-462: Administering SQL Server Databases - ITU Online

Your Last Chance for Lifetime Learning!  Elevate your skills forever with our All-Access Lifetime Training. 
Only $249! Our Lowest Price Ever!

Days
Hours
Minutes
Seconds

Microsoft 70-462: Administering SQL Server Databases

In this Microsoft 70-462: Administering SQL Server Databases course you will learn how to perform installation, maintenance, and configuration tasks. This course will also teach you other responsibilities including setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access. This course will provide students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database and focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database.

Included In This Course

Included In This Course

Total Hours
8  Training Hours
Microsoft 70-462: Administering SQL Server Databases
62 On-demand Videos
Closed Caption

Closed Captions

Course Topics
13  Topics
Prep Questions
45 Prep Questions
Microsoft 70-462: Administering SQL Server Databases

Certificate of Completion

Course Description

Note: Although the associated examination for this course has been retired, it is a good resource for online IT training.

In this course you will learn how to perform installation, maintenance, and configuration tasks. This course will also teach you other responsibilities including setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access. This course will provide students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database and focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database.

About Microsoft 70-462: Administering SQL Server Databases online learning course

This course is preparation for the 70-462 Administering SQL Server 2012 exam. This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database and focuses on teaching students how to use SQL Server 2012 product features and tools related to maintaining a database.

Who is this course for 

Built for database professionals, this SQL 2012 training course is perfect for those responsible for installing, maintaining and configuring databases. Those wanting to learn how to set up database systems and ensure efficient system operations can also take advantage of this exciting program! It covers topics such as regular backups stored securely, data protection from unauthorized access, and more – all designed to help you become a proficient user of the platform.

Exam objectives and following is a segment of job duties eligible for this training:

  • Ensuring the proper auditing and backup of SQL Server instances is essential to keep your databases secure and reliable.
  • Empowering your business with a SQL Server and setting up extra components, Instances and Services to maximize its potential.
  • Strategically utilizing column stores, implementing high-availability and disaster recovery solutions to bolster reliability.
  • Importing/exporting
  • Effectively managing and maintaining user access, configurations, permissions, alerts, logins and roles can be a tedious task. Fortunately with the right tools this time-consuming job is made easier than ever before!
  • Streamline your computing operations with an installation of SQL Server and its accompanying services. Equip yourself to make the most out of optimization processes with a top-notch set up!

To see more Microsoft related training, Visit the Microsoft Website.

Frequently Asked Questions About Microsoft 70-462: Administering SQL Server Databases

What will I learn in the Microsoft 70-462: Administering SQL Server Databases course?

You’ll learn how to install, maintain, and configure SQL Server databases. The course covers topics like setting up database systems, ensuring they operate efficiently, and regularly storing, backing up, and securing data from unauthorized access. You’ll also learn how to use SQL Server 2012 product features and tools related to maintaining a database​.

I’ve heard the associated exam for this course has been retired. Is the course still relevant?

Yes, absolutely! While the exam itself may have been retired, the course remains a valuable resource for online IT training. It provides fundamental knowledge and skills that are applicable to SQL Server database administration.

How is the course content delivered?

The course is delivered through 62 instructional videos that cover 13 topics. There are also 45 practice questions to help reinforce your learning. In total, you’ll receive 8 hours of training.

Can I access other courses with this one?

Yes, you can! By subscribing to the All Access Monthly Subscription, you get access to this course as well as over 2,500 hours of on-demand content. Plus, you can start with 7 free days with no obligation and you can cancel anytime.

Is this course good preparation for the 70-462 Administering SQL Server 2012 exam?

Even though the 70-462 Administering SQL Server 2012 exam has been retired, this course was designed with that exam in mind. It’s a comprehensive resource that provides the knowledge and skills you would have needed for the exam, and it focuses on teaching students how to maintain a Microsoft SQL Server 2012 database.

Is this course suitable for beginners?

The course is designed for anyone interested in learning about SQL Server database administration. However, it would be helpful to have a basic understanding of databases and SQL beforehand to get the most out of the course. If you’re a beginner, don’t worry – you can still learn a lot from the course, but be prepared for a steep learning curve.

Proudly Display
Your Achievement

Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.
Example Certificate

Course Outline

Microsoft 70-462: Administering SQL Server 2012 Databases Course Content

Lesson 1: Identifying the SQL Server Platform

  •    Overview

  •    DataStorage-Part 1

  •    DataStorage-Part 2

Lesson 2: Deploying SQL Server

  •    Install-Part 1

  •    Install-Part 2

Lesson 3: Configuring SQL Server

  •    Configuring-Part 1

  •    Configuring-Part 2

  •    Changing Memory-Part 1

  •    Changing Memory-Part 2

  •    Email-Part 1

  •    Email-Part 2

Lesson 4: Managing Databases in SQL Server 2012

  •    User Databases-Part 1

  •    User Databases-Part 2

  •    User Databases-Part 3

  •    User Databases-Part 4

  •    User Databases-Part 5

Lesson 5: Managing SQL Server Security

  •    Setting Security-Part 1

  •    Setting Security-Part 2

  •    Server Roles-Part 1

  •    Server Roles-Part 2

  •    Setting Permissions-Part 1

  •    Setting Permissions-Part 2

Lesson 6: Implementing Advanced Security Settings

  •    Querying Data From Multiple Tables-Part 1

  •    Querying Data From Multiple Tables-Part 2

  •    Querying Data From Multiple Tables-Part 3

  •    Querying Data From Multiple Tables-Part 4

  •    Querying Data From Multiple Tables-Part 5

Lesson 7: Applying Encryption and Compression

  •    Encrypting And Compressing-Part 1

  •    Encrypting And Compressing-Part 2

  •    Encrypting And Compressing-Part 3

Lesson 8: Working with Indexes and Log Files

  •    Functions-Part 1

  •    Functions-Part 2

  •    Functions-Part 3

  •    Functions-Part 4

  •    Functions-Part 5

  •    Functions-Part 6

Lesson 9: Working with Backup and Restore

  •    Managing Backups-Part 1

  •    Managing Backups-Part 2

  •    Managing Backups-Part 3

  •    Managing Backups-Part 4

  •    Managing Backups-Part 5

  •    Managing Backups-Part 6

  •    Managing Backups-Part 7

Lesson 10: Implementing High Availability

  •    Stored Procedures-Part 1

  •    Stored Procedures-Part 2

  •    Stored Procedures-Part 3

  •    Stored Procedures-Part 4

Lesson 11: Optimizing Server Performance

  •    Managing SQL Performance-Part 1

  •    Managing SQL Performance-Part 2

  •    Managing SQL Performance-Part 3

  •    Managing SQL Performance-Part 4

  •    Managing SQL Performance-Part 5

  •    Managing SQL Performance-Part 6

  •    Managing SQL Performance-Part 7

Lesson 12: Troubleshooting Issues and Recovering Databases

  •    Set Operators-Part 1

  •    Set Operators-Part 2

  •    Set Operators-Part 3

  •    Set Operators-Part 4

  •    Set Operators-Part 5

Lesson 13: Performing Advanced Database Management Tasks

  •    Managing Database Infrastructures-Part 1

  •    Managing Database Infrastructures-Part 2

  •    Managing Database Infrastructures-Part 3

Add a review
Currently, we are not accepting new reviews
4.8
Based on 67 reviews
1-5 of 67 reviews
  1. MaryBeth is an awesome Rep!

Your Training Instructor

Chrys Thorsen

Chrys Thorsen

Education and Technology Expert

Chrys Thorsen is an education and technology expert who specializes in enterprise-level IT infrastructure consulting and certified training-of-trainers. In her career, she has garnered over 50 IT Certifications including CISSP, CISA, CEHv12, PenTest+, CompTIA CNVP, Cisco CCSI/CCNP, Microsoft Cloud and on-premises technologies, VMware vSphere, and many more. She has also authored 40 published certification textbooks, and over 35 full-length IT certification video courses.

When not working in the United States, Chrys spends her time abroad capacity-building IT literacy in developing nations in Sub-Saharan Africa. Her client list has included: the US Federal Government, the Republic of Zambia Ministry of Health, Cavendish University Zambia, Accenture, JP Morgan Chase, the US Centers for Disease Control and Prevention, the Elizabeth Glaser Pediatric AIDS Foundation (EGPAF), Hughes Aircraft, Microsoft, and many more.

Chrys lives by, and is fond of repeating, her professional creed:

“The only true measure of success for any project or training is results on the ground. Everything else is just noise.” “I teach what I deploy; I deploy what I teach.”

Microsoft 70-462: Administering SQL Server Databases
 

$49.00

OR

Subscribe To All-Access
Lock In $14.99 / Month Forever

Gain access to this training and all our other courses, offering over 2,500 hours of content, with our cost-effective monthly subscription. No obligations. Cancel anytime.

$49.00 $14.99 Monthly

Microsoft 70-462: Administering SQL Server Databases

Microsoft 70-462: Administering SQL Server Databases
Microsoft 70-462: Administering SQL Server Databases
Additional Options to Access This Training
This training is also part of our extensive training library containing over 225 courses, 12,000+ videos and over 19,000 practice test questions.

Monthly All-Access Subscription
7 Days Free - $39.00 / month

A great option at an affordable monthly price.

Annual All-Access Subscription
$229 / year

A discounted price when paying for your All Access library on an annual basis.

Lifetime All-Access Library
$379 One time payment

Exceptional Value. Pay once, never have to buy IT training again.

Related Courses

$49.00

Learn Python programming with ITU Online. Get hands-on experience with real-world projects and become proficient in Python. Enroll now!

Python, which has been around for nearly three decades, is one of the most widely used programming languages in existence. This Python programming course is particularly helpful to data scientists and machine learning professionals, Python stands out due to its ease-of-use – it’s no wonder that universities now make it their go-to language when teaching coding.

Add To Cart

$49.00

Take the Microsoft 70-480: Programming in HTML5, JavaScript and CSS3 course and become a skilled web developer. Enroll now!

In this Microsoft 70-480 course you will learn how to implement and manipulate document structures and objects, implement program flow, access and secure data, and use CSS3 in applications. This course will teach you HTML5, CSS3, Javascript and jQuery.

Add To Cart

$49.00

Master JavaScript Fundamentals and build powerful web applications with our comprehensive online training. Start now!

If you’re ready to dive into Java Programming, this JavaScript Fundamentals online training course is for you! You’ll start with the basics and work your way up to advanced levels. Not only will you get a comprehensive introduction to object-oriented programming, but also learn many other core Java features in detail. Don’t miss out on this opportunity – sign up now and make strides in mastering Java today!

Add To Cart