Self-paced

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.

With internship

$674

$1199

or

Without internship

$79

$499

this course includes

8 Training Hours

62 On-demand Videos

Closed Captions

13 Topics

45 Prep Questions

Certificate of Completion

What you’ll
learn

01

Identifying the SQL Server Platform

02

Deploying SQL Server

03

Configuring SQL Server

04

Managing Databases in SQL Server 2012

05

Managing SQL Server Security

06

Implementing Advanced Security Settings

07

Applying Encryption and Compression

08

Working with Indexes and Log Files

09

Working with Backup and Restore

10

Implementing High Availability

11

Optimizing Server Performance

12

Troubleshooting Issues and Recovering Databases

13

Performing Advanced Database Management Tasks

In this course you will learn how to perform installation, maintenance, and configuration tasks.

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.

course CURRICULUM

Identifying the SQL Server Platform

Overview
DataStorage-Part 1
DataStorage-Part 2

Deploying SQL Server

Install-Part 1
Install-Part 2

Configuring SQL Server

Configuring-Part 1
Configuring-Part 2
Changing Memory-Part 1
Changing Memory-Part 2
Email-Part 1
Email-Part 2

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

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

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

Applying Encryption and Compression

Encrypting And Compressing-Part 1
Encrypting And Compressing-Part 2
Encrypting And Compressing-Part 3

Working with Indexes and Log Files

Functions-Part 1
Functions-Part 2
Functions-Part 3
Functions-Part 4
Functions-Part 5
Functions-Part 6

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

Implementing High Availability

Stored Procedures-Part 1
Stored Procedures-Part 2
Stored Procedures-Part 3
Stored Procedures-Part 4

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

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

Performing Advanced Database Management Tasks

Managing Database Infrastructures-Part 1
Managing Database Infrastructures-Part 2
Managing Database Infrastructures-Part 3

Why become a Cybersecurity Engineer?

Growing Demand for Cybersecurity Professionals

The field of cybersecurity is experiencing rapid growth, driven by the escalating number and complexity of cyber threats. Both public and private sectors are investing heavily in cybersecurity measures to protect sensitive information and secure critical infrastructure. This increased investment has created a substantial demand for cybersecurity professionals, and the job market is teeming with opportunities. By becoming a cybersecurity engineer, you position yourself at the forefront of a booming industry with a multitude of career prospects.

Lucrative Salaries and Career Advancement

Cybersecurity professionals are highly sought after, and as a result, they enjoy attractive salaries and excellent benefits. The specialized skills and expertise required in this field command a premium in the job market. Furthermore, as you gain experience and demonstrate your capabilities, the potential for career advancement becomes significant. Cybersecurity engineers can progress to leadership positions, such as Chief Information Security Officer (CISO), and take on strategic roles in shaping an organization's security posture.

Global Relevance and Job Security

Cybersecurity is a global concern affecting organizations of all sizes and industries worldwide. The need for cybersecurity professionals extends beyond borders, making it a globally relevant field. By becoming a cybersecurity engineer, you equip yourself with skills that are in demand not only locally but also internationally. Job security in the field of cybersecurity is robust, as the increasing threat landscape ensures a constant need for skilled professionals to protect against attacks and mitigate risks.

Continuous Learning and Growth

The field of UX/UI design is dynamic and ever-evolving. To stay competitive, designers need to keep learning and adapting to new technologies and design trends. This continuous learning keeps the work interesting and provides opportunities for personal and professional growth.

Opportunities for growth

As software testers gain experience and develop their skills, they can take on more challenging roles and responsibilities. This can lead to promotions and career advancement opportunities. Most Manual testers progress to QA automation, Software development, DevOps, or Cloud Engineering.

Our Talents Work Here

Our talentstories

We connect learners with peers and experts from around the world, facilitating networking and collaboration opportunities.

"I joined IBT Learning with a dream to become a software developer. The hub's diverse courses and talented instructors provided me with a world of learning opportunities. They don't just teach; they inspire.

Tomiwa Adeleke (Data Scientist at Google)

"I joined IBT Learning with a dream to become a software developer. The hub's diverse courses and talented instructors provided me with a world of learning opportunities. They don't just teach; they inspire.

Tomiwa Adeleke (Data Scientist at Google)

WHY IBT learning

We connect learners with peers and experts from around the world, facilitating networking and collaboration opportunities.

World-Class
Instructors

We take pride in the quality of highly sought-after instructors at IBT Learning. Our up-to-date curriculum is designed and taught by the best-in-class IT professionals.

Global Networking

We take pride in the quality of highly sought-after instructors at IBT Learning. Our up-to-date curriculum is designed and taught by the best-in-class IT professionals.

95% Chances Of Getting
Hired By Top Companies

Our track record speaks for itself. We have a high placement rate, and our graduates have gone on to work at some of the most prestigious tech companies worldwide. We don't just aim to prepare you for the tech world—we guarantee your success.

YOUR QUESTIONS ANSWERED

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.