70-462: SQL Server Database Administration (DBA)

Course Feature

Cost

Paid
Provider

Udemy
Certificate

Paid Certification
Language

English
Start Date

2023-12-05
Learners

No Information
Duration

No Information
Instructor

Phillip Burton,I Do Data Limited

Add to Favorites

4.6

24,540 Ratings

This course is perfect for anyone looking to gain practical experience in Database Administration in SQL Server. Learn the skills that Microsoft wants you to know, and add another tool to your CV or resume. With 10 hours of content, you'll be able to manually backup a database, manage logins and server roles, implement and maintain indexes, import and export data, manage and configure databases, and much more. No knowledge of T-SQL is required, and you can download a certificate of completion at the end of the course. Get ready to take your Database Administration skills to the next level!

Show All

70-462: SQL Server Database Administration (DBA)

Go to class

Course Overview

❗The content presented here is sourced directly from Udemy platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.

Updated in [August 18th, 2023]

Skills and Knowledge:
By taking this course, learners will acquire the skills and knowledge necessary to perform Database Administration tasks in SQL Server. This includes downloading and installing SQL Server Developer, backing up and restoring databases, managing logins and server roles, implementing and maintaining indexes, importing and exporting data, managing SQL Server Agent, configuring databases, and compressing databases. Learners will also gain an understanding of T-SQL and the Graphical User Interface (GUI). Upon completion of the course, learners will be able to demonstrate their new-found skills with a certificate of completion.
Professional Growth:
This course provides a comprehensive introduction to Database Administration in SQL Server, giving learners the opportunity to gain practical experience in the field. Through the course, learners will be able to download and install SQL Server Developer, learn how to backup and restore databases, manage logins and server roles, implement and maintain indexes, import and export data, manage and configure databases, and look at compression. The course also provides learners with the opportunity to gain hands-on experience in the field, as well as the ability to go for the official Microsoft certification. By completing the course, learners will be able to demonstrate their knowledge and skills in Database Administration, and be better prepared for the job market.
Further Education:
This course is suitable for preparing further education in Database Administration in SQL Server. It provides hands-on experience in the skills that Microsoft wants you to know, and can help you gain the official Microsoft certification. The course covers topics such as backup and restore, logins and server roles, indexes, import and export data, managing SQL Server Agent, configuring databases, and more. It is recorded on SQL Server 2017, but will also work with other versions. The course is fairly relaxed and takes around 10 hours to complete. It is suitable for those with basic computer knowledge, and no knowledge of T-SQL is required. Upon completion, a certificate of completion can be downloaded.

Course Syllabus

Introduction

Backup and Restore - Part 1

Manage logins and server roles

Implement and maintain indexes

Import and export data

Manage SQL Server Agent - Part 1

Manage and configure databases

Compression

Identify and resolve concurrency problems

Collect and analyse troubleshooting data

Audit SQL Server Instances

Plan installation

Install SQL Server and related services

Implement a migration strategy

Install SQL Server, related services and additional SQL Server components

Well done

Show All

Recommended Courses

Complete Python Bootcamp! Build Practical Python Projects

4.0

Udemy 9,992 learners

Learn More

This Complete Python Bootcamp course is the perfect way to learn Python programming from the very basics to advanced topics. It covers topics such as introduction to Python programming, basics of Python programming, file handling, object-oriented programming, Python GUI development, building a message box, creating a digit counter, creating a color chooser, graphic designs, calculator development, database management system, e-learning application, image processing, movable text display, hotel management system and more. With experienced instructors and real-world projects, this course will help you gain the skills and knowledge to unlock exciting new career opportunities in the world of technology.

MySQL Course for Beginners with 100+ examples

3.8

Udemy 2,451 learners

Learn More

This MySQL Course for Beginners is the perfect way to learn the basics of the popular relational database management system. With over 100+ live running examples, you'll get a step-by-step tutorial-like format to understand the concepts of creating a new database and table, performing various operations, and more. Plus, you'll get 15 quizzes to test your skills and hands-on exercises to apply your knowledge in a real-world application. Get started today and become a MySQL expert!

Databases and SQL for Data Science with Python

3.0

Coursera 0 learners

Learn More

Data Scientists, Data Analysts and Data Engineers must have a working knowledge of SQL to effectively communicate with and extract data from databases. This course provides an introduction to databases and SQL for data science with Python.

SQL for Data Science

1.0

Edx 322 learners

Learn More

This IBM course provides learners with the skills to use SQL for data science. Upon successful completion, learners will receive a skill badge, a digital credential that verifies their knowledge and skills. Enroll now to learn more and gain the skills to use SQL for data science.