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 Hrs 24 Min
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.”
Subscribe To All-Access
Lock In $14.99 / Month Forever
Start this course for free with our 10-day trial of the all-access subscription providing access to over 2,600 hours of training.
$49.00 $14.99 Monthly
OR
$49.00
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 Microsoft Certified Database Designer! Learn Microsoft 70-465: Designing Database Solutions for SQL Server with ITU’s comprehensive online course.
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.
$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.
$49.00
Gain expertise in designing BI solutions with SQL Server with our Microsoft 70-467 training course. Become an expert in BI solutions design today!
In this online training course you will learn how to plan and design a business intelligence (BI) infrastructure by designing a reporting solution, designing BI data models and designing an ETL solution. This course will teach business intelligence (BI) architects the overall design of a BI infrastructure and how it relates to other data systems in use.
Mary Beth helped me. She was wonderful.