Lifetime
An ITU Online Training exclusive. The only Buy Once, Never Pay for IT training again program available. Plus, get all new and updated content for life.
- +1 855.488.5327
- customerservice@ituonline.com
- Mon - Fri: 9:00am - 5:00pm ET
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
8 Training Hours
62 On-demand Videos
Closed Captions
13 Topics
45 Prep Questions
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 DisplayYour Achievement
Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.
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
Your Training Instructor
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.”
$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
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
Become a Certified Kubernetes Application Developer (CKAD). Enroll now and learn how to build, deploy, and manage Kubernetes applications.
If you’re looking to ace the Certified Kubernetes Application Developer (CKAD) exam, this is the video IT course for you! Through its comprehensive instruction materials, and lectures, it will teach you all that there is to know about Kubernetes – an open-source system designed by Google but now maintained by The Cloud Native Computing Foundation and pass the certification program.
$49.00
Learn how to handle Big Data with Microsoft SQL 2019. Master the art of data analysis & management with our online training course. Enroll now!
Dive into the depths of SQL Server with this Microsoft SQL – SQL Big Data course and discover one of its most invaluable tools, SQL Big Data Clusters. Here, you will fully explore data virtualization and lakes in order to build a complete artificial intelligence (AI) and machine learning (ML) platform directly within the SQL Server database engine.
$49.00
Enhance your career as a SQL Server administrator with our Microsoft SQL Server Administration training series. Enroll today and become an expert!
This sql server administration course offers students a comprehensive understanding of how to maintain and optimize a Microsoft SQL Server database. It is specifically tailored towards individuals who want to gain knowledge features in numerous versions of SQL server as well as learn about essential capabilities throughout the entire data platform. Students will emerge from this training with an extensive set of skills for managing their own MS SQL Server environment along with its databases!
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.