Becoming a Production SQL Server DBA

Becoming a Production SQL Server DBA, available at Free, has an average rating of 4.2, with 16 lectures, based on 167 reviews, and has 5837 subscribers.

Free Enroll Now

You will learn about How to efficiently administer SQL Server instances and databases in many aspects How to perform essential SQL Server maintenance tasks How to perform essential SQL Server performance tasks How to handle common errors you might get in SQL Server Get deeper understanding about key SQL Server topics and concepts How to perform different SQL Server integration tasks This course is ideal for individuals who are SQL Server Developers who want to learn more about SQL Server Administration or SQL Server Administrators (DBAs) or Those with little work experience It is particularly useful for SQL Server Developers who want to learn more about SQL Server Administration or SQL Server Administrators (DBAs) or Those with little work experience.

Enroll now: Becoming a Production SQL Server DBA

Summary

Title: Becoming a Production SQL Server DBA

Price: Free

Average Rating: 4.2

Number of Lectures: 16

Number of Published Lectures: 16

Number of Curriculum Items: 16

Number of Published Curriculum Objects: 16

Original Price: Free

Quality Status: approved

Status: Live

What You Will Learn

How to efficiently administer SQL Server instances and databases in many aspects

How to perform essential SQL Server maintenance tasks

How to perform essential SQL Server performance tasks

How to handle common errors you might get in SQL Server

Get deeper understanding about key SQL Server topics and concepts

How to perform different SQL Server integration tasks

Who Should Attend

SQL Server Developers who want to learn more about SQL Server Administration

SQL Server Administrators (DBAs)

Those with little work experience

Target Audiences

SQL Server Developers who want to learn more about SQL Server Administration

SQL Server Administrators (DBAs)

Those with little work experience

In this course, you will learn many SQL Server administration hands-on tips, that will help you efficiently administer SQL Server within the context of SQL Server maintenance, performance, security, integration and error handling.

SQL Server is one of the world’s leading Data Platforms. It is full of features that enable you to store, organize, retrieve and transform your data into useful business insights and knowledge. Like in all Database Management Systems, in order for your SQL Server instances to operate to the best possible level in terms of stability and performance, you need to properly administer and maintain them.

I have carefully designed this course, in order to help you with your SQL Server journey. With many live demonstrations and step by step guides, via my course, I will help you learn how to perform many SQL Server administration tasks, as well as, get a deeper understanding about critical SQL Server topics that all modern SQL Server Administrators, Engineers and Architects needs to know.

In my course, you will learn how to patch standalone and failover cluster SQL Server instances, how to enable Transparent Data Encryption (TDE) for data at rest and encrypt database backups, how to enable SSL encryption for data in motion, how to tune SQL Server instances via indexes, CPU, RAM and storage monitoring, how to protect your data with Dynamic Data Masking and Row Level Security, how to use Unicode, how to troubleshoot common error messages in SQL Server and much more.

AFTER THE COURSE:

You will know how to efficiently perform different SQL Server administration tasks on the below SQL Server knowledge areas:

Maintenance

Performance

Security

Integration

Error Handling

You will have a deeper understanding on many SQL Server administration topics that fall under the above knowledge areas

You will be able to download a rich set of downloadable resources, mainly T-SQL scripts, that will help you better understand all tips provided via the course.

I WILL KEEP UPDATING THIS COURSE!!!

PREREQUISITES:

At least basic knowledge of SQL Server is required.

It would be helpful to know some basic database-related concepts (i.e. what is a database, a table, etc.) but is not a prerequisite, since we will talk about it as well.

Willingness and excitement to learn!

THIS COURSE CONTAINS/OFFERS:

2 hours of high-quality video

Live demonstrations and hands-on guides that will help you perform many essential SQL Server administration tasks

Useful quizzes for testing your knowledge on each section

Many downloadable resources such as T-SQL scripts and links

Ability to ask the instructor questions via the Q&A section

Certificate on course completion

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Installing SQL server in a domain production Enviroment

Lecture 3: Software Download and VMware Installation

Lecture 4: Domain controller installation

Lecture 5: Promote Server to a Domain Controller

Lecture 6: Create Service Accounts

Lecture 7: Setup a Static IP Address

Lecture 8: Create another Virtual Machine

Lecture 9: Create Additional Virtual Drives

Lecture 10: Join Server to a Domain

Lecture 11: SQL Server installation

Lecture 12: How to create a database for a complete begineer

Lecture 13: How to Backup a database for a complete beginner

Lecture 14: How to Restore a database for a complete beginner

Lecture 15: How to take a Database offline and bring it back online

Lecture 16: How to create a database SnapShot for a complete beginner

Instructors

Paul Obalonye
MCSE|MCSA|Azure Administrator |Azure DevOps Engineer

Rating Distribution

1 stars: 5 votes

2 stars: 5 votes

3 stars: 22 votes

4 stars: 47 votes

5 stars: 88 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!