The Complete SQL Server 2019 Database Administration Course

Learn in this course, how to build a robust, secure and reliable database server!

DBA SQL server is nowadays a full time assured job, it is an extremely sought after job in the working world.

************  This course is broken down into several chapters   *****************

1st chapter: Let’s talk about performance by discussing indexing and its implementation. (3 hrs of class).

2nd chapter: This 2:30 chapter will teach you all the intricacies of BACKUP and RESTORE on SQL Server.  (3 hrs of class).

3rd chapter: Let’s approach TSQL at a slightly more advanced level, through partitioning functions (ROW NUMBER etc…).

4th chapter: Find out how to easily and automatically detect corruption ,with minimum data loss. (3 hr course).

5th chapter : Discover all the subtleties and pitfalls to avoid, when creating and configuring a database. (3 h of class).

6th chapter: We will discuss the utility of System DBs, as well as the creation and utility of constraints (PK,FK etc…).

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

8th chapter: Discover triggers, synonyms, the sequences and the IDENTITY on your tables.

9th chapter: A big chapter on what’s new in SQL Server 2016. Such as RLS, DDM, and temporal data.