The Complete SQL Server 2019 Database Administration Course

If you are looking to become a pro in SQL Server database administration, you’ve landed on the right course. This course is designed to make you a SQL server expert, starting from the basics all the way to advanced level topics.

Why learn SQL server database administration?

DBA SQL server is nowadays a full time assured job, it is an extremely sought after job in the working world. With the knowledge of SQL server, you can build a robust, secure and reliable database server, thereby making you an asset to your workplace.

This course is structured into ten chapters, each covering a different topic, with demo videos lasting no longer than 10 minutes.

Chapter-wise breakdown

Chapter 1: Let’s talk about performance by discussing indexing and its implementation

In this chapter, you will learn everything about indexing and how to implement it effectively to improve database performance.

Chapter 2: Learn all the intricacies of BACKUP and RESTORE on SQL Server

In this chapter, you will learn all about backup and restore operations in SQL Server. You will gain a deeper understanding of backups, restores and recovery models.

Chapter 3: Let’s approach TSQL at a slightly more advanced level, through partitioning functions

In this chapter, you will explore advanced TSQL concepts and learn about partitioning functions like ROW NUMBER, etc.

Chapter 4: Find out how to easily and automatically detect corruption , with minimum data loss

In this chapter, you will discover how to detect corruption in your databases and learn how to minimize data loss.

Chapter 5: Discover all the subtleties and pitfalls to avoid when creating and configuring a database

In this chapter, you will learn everything you need to know about creating and configuring a database. You will explore the subtleties and pitfalls that come with designing a database.

Chapter 6: We will discuss the utility of System DBs, as well as the creation and utility of constraints

In this chapter, you will explore system databases and learn how to create and utilize constraints like PK, FK, etc.

Chapter 7: We will see the different modes of isolation (READ COMMITED, UNCOMMITED, SERIALIZABLE…) that can be set up on a BDD

In this chapter, you will dive deeper into database isolation modes like READ COMMITTED, UNCOMMITTED, SERIALIZABLE, etc., and learn how to set these up on a BDD.

Chapter 8: Discover triggers, synonyms, sequences and the IDENTITY on your tables

In this chapter, you will explore triggers, synonyms, sequences and the IDENTITY feature on your tables to optimize database operations.

Chapter 9: A big chapter on what’s new in SQL Server 2016, including RLS, DDM, and temporal data

In this chapter, you will discover the new features of SQL Server 2016, including RLS, DDM and temporal data, and learn how to implement them.

Chapter 10: Administration rhymes with precaution, and therefore of course with security. We will discuss security and privilege management during 2 hours

In this final chapter, you will learn how to set up a robust and secure SQL server by discussing security and privilege management.

Bonus content

• Virtual interview to prepare for your future SQL interview
• Overview of theoretical interview questions commonly asked during SQL interviews.
• Courses arriving in 2021: Let’s go together on SQL Azure!!!, How to improve your performance on your stored procedures? and How to set up security on a SQL Server. (2 hr course)

Important aspects of the course

• This course covers all SQL Server versions, including SQL Server 2019.
• This online course is 17 hours and 30 minutes of videos and 30 minutes of theory.
• The course is structured in bite-sized videos of no more than 10 minutes.
• Taking this course will greatly aid you in passing Microsoft certifications.
• Look at the average ratings of my other courses (4.4/5), and you will see that my courses are quality courses.

Enroll in this comprehensive SQL Server course today and invest in your future as a database administration pro.