Essential SQL Server Administration Tips (Hands-On Guides)

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

WHAT OTHER STUDENTS SAY ABOUT THE COURSE:

• "A very interesting and useful course for database professionals. I can directly apply it at my work and believe it will resolve difficulties regarding the administration of our SQL server."

• "Interesting course, with many tips and trick about SQL Server. Some complex topics (as for me TDE) are explained very well and very clearly."

• "This course is helpful to the persons who are looking for the career in SQL server. It is helpful to the beginners up to middle level."

• "Very useful and well organized course. The knowledge gained will be actively used in practice."

  
  

THE BENEFITS OF THIS COURSE:

Microsoft 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.

By the time you complete this course, you will be able to administer SQL Server more efficiently, in the areas of:

• Maintenance

• Performance

• Security

• Integration

• Error Handling

Moreover, you will have a deeper understanding on many SQL Server administration topics that fall under the above knowledge areas and you will be able to get a rich set of downloadable resources, mainly T-SQL scripts, that will help you better understand all tips provided via the course.

MAJOR LEARNING OBJECTIVES:

Throughout the course, I will take you through many important SQL Server administration tips and techniques.

First, you will learn many SQL Server maintenance tips and techniques in the areas of: patching, high availability and more.

After that, you will learn useful performance optimization tips that have to with indexes, the tempdb system database in SQL Server, In-Memory OLTP, RAM and CPU monitoring, and other SQL Server performance-related tips.

Then, we will be discussing about many important SQL Server security-related topics, where among other, you will learn how you can secure your SQL Server instances, how to encrypt your SQL Server databases and backups with Transparent Data Encryption (TDE), how to use the Dynamic Data Masking feature, how to handle orphaned users and more.

After that, we will be discussing about interesting integration-related topics, such as: using Unicode in SQL Server, how to work with linked servers and more.

Then, we will be discussing about, how you can easily troubleshoot common errors that you might get, under certain conditions, when implementing data processes in SQL Server.

Finally, we’ll go over different special topics, via which you will learn how to perform special SQL Server administration tasks.

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:

• 6.5+ 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

• A practice test in the end of the course

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

• Certificate on course completion