The Complete SQL Server 2019 Database Administration Course
Become SQL database certified (MCSA and MTA certification 2019)
3.65 (27 reviews)
127
students
18 hours
content
May 2022
last update
$54.99
regular price
What you will learn
Build a robust, reliable, secure, and powerful SQL server.
Approach and deepen the BACKUP and RESTORE (2 hours of lessons)
Address security and privileges (2 hours of lessons)
Detect and resolve corruption on a database (2 hour course).
Learn the intricacies and pitfalls to avoid when creating a database (2 hour course)
We will see the different isolation modes (READ UNCOMMITED,SNAPSHOT,READ COMMITED...)
Learn the constraints on tables (CHECK, UNIQUE, PK, FK, DEFAULT)
Learn SEQUENCES and IDENTITY
Address the functionalities of the Systems Database (Master, TEMPDB, Msbd, resource)
A big chapter on new SQL Server 2016 features. Like RLS, DDM, and temporal data.
Let's talk about performance by discussing indexing and its implementation (3 hours of lessons)
Improve the performance of your stored procedures
Let's tackle TSQL at a slightly more advanced level, through the partitioning functions (ROW_NUMBER etc ...)
Screenshots
Related Topics
3901106
udemy ID
3/9/2021
course created date
3/30/2021
course indexed date
Bot
course submited by