❗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