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

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 78 reviews
1-5 of 78 reviews
  1. Smooth delivery and easy access to LMS. Good to see that the LMS offers progress tracking. Would be great if badges were offered on completion of courses to share via Credly to future employers.

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

Take your SQL Server skills to the next level with ITU Online’s Microsoft 70-466 course on implementing data models and reports. Enroll now!

In this course you will learn how to create managed enterprise BI solutions. You will learn how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining. This course will also teach you how to create BI solutions that require implementing multi-dimensional data models, implementing and maintaining OLAP cubes, and creating information displays used in business decision making.

Add To Cart

$49.00

Learn how to develop scalable and secure web applications with Microsoft ASP .NET MVC in our comprehensive online course.

In this Microsoft ASP .NET MVC online training course you will learn a powerful, patterns-based way to build dynamic websites that gives you full control over markup for enjoyable, agile development. You will learn ASP.NET MVC and its many features that enable fast, TDD-friendly development for creating sophisticated applications that use the latest web standards.

Add To Cart

$49.00

Boost your web development skills with ITU’s HTML5 CSS3 online course and stay ahead of the curve

Elevate your web development programming skills in this HTML5 and CSS3 training course. HTML5 and CSS3 are key web technologies that allow you to build up content for the internet. This training program showcases how to use innovative HTML5 multimedia features such as video, audio, and animation. With this course, you can unlock more creative possibilities with your digital media!

Add To Cart