The Complete SQL Server 2019 Database Administration Course

Partner: Udemy
Affiliate Name:
Area:
Description: 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.10th chapter : Administration rhymes with precaution, and therefore of course with security. We will discuss security and privilege management during 2 hours. We will learn how to set up a robust and secure SQL server.******* And at the end of the course take a virtual interview to prepare for your future
Category: Development > Database Design & Development > SQL
Partner ID:
Price: 99.99
Commission:
Source: Impact
Go to Course