Overview

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. 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. In this course you will learn how to plan and implement enterprise database infrastructure solutions by using SQL Server 2012 and other Microsoft technologies. This course will teach you how to consolidate SQL Server workloads, work with both on-premises and Microsoft Azure cloud-based solutions, and how to plan and implement high availability and disaster recovery solutions. You will learn how to create plans and designs for database structure, storage, objects, and servers. 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! In this Microsoft 70-487 course you will learn how to access data, query and manipulate data by using the entity framework, create and consume web API-based services, design and implement web services, and deploy in Microsoft Azure and Web Services. You should Learn Java as it is a must-have technology for a range of applications and websites, including business solutions, data centers, game consoles, utilities, desktop computers (as well as laptops and smartphones). That’s why this online training course explores the whole spectrum of Java Programming from beginner to advanced. With it you can confidently tackle any challenge that comes your way!

Your Training Instructor

Chrys Thorsen

Education and Technology Expert

Chrys 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 35 IT Certifications including Cisco CCSI/CCNP, CISSP, CISA, MCSE/MCITP, and many more. She has also authored 40 published certification textbooks and is currently working on the new CompTIA PenTest+ courseware.

  • 8 Traning Hours
  • 62 Videos
  • 13 Topics
  • 45 Practice Questions

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!

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.

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.

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

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