70-462: SQL Server Database Administration (DBA)
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! ▼
ADVERTISEMENT
Course Feature
Cost:
Paid
Provider:
Udemy
Certificate:
Paid Certification
Language:
English
Start Date:
2023-12-05
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
Course Provider
Provider Udemy's Stats at AZClass
Discussion and Reviews
0.0 (Based on 0 reviews)
Start your review of 70-462: SQL Server Database Administration (DBA)