Comprehensive SQL Server Administration Part 2
 

Database Design, Migration, Patching, Upgrade, Concurrency, Transparent Data Encryption, and Dynamic Data Masking

What you'll learn
Database Migration Methodologies and Suitability for Business Requirements
Database Refresh, SQL Server Patching, SQL Server Upgrade, and Move Database Files
Database Security Technologies such as Transparent Data Encryption and Dynamic Data Masking
Database and Datawarehouse Design Architecture (Normalization, Denormalization, Data Types, and Constraints)
Concurrency in SQL Server (ACID Principle and Isolation Levels)
Indexes, their Structure, Components and Maintenance (Reorganize/Rebuild)

Requirements
Completed Comprehensive SQL Server Administration Part 1 Or Have Prior Knowledge of the Concepts
Windows Personal Computer (Laptop or Desktop)
Reliable Internet Connection
Great Passion to Learn
Existing Virtual Lab Environment for Technical Hands-on Practices

Description
Dive into the world of SQL Server with our comprehensive course designed for existing and prospective Microsoft SQL Server Database Administrators. Whether you're a beginner, junior, or intermediate-level Database Administrator, this course equips you with essential skills and knowledge to excel in the field. You'll gain a solid foundation in SQL Server architecture and functionality, and learn critical topics such as database design, migration, patching, upgrade, concurrency, isolation levels, transparent data encryption (TDE), and dynamic data masking.This course is rich in technical hands-on demonstrations to enhance your comprehension of the material, and it includes numerous practice exercises to reinforce your learning. You'll also find a wealth of typical interview questions to help you prepare for job interviews and knowledge checks. Designed to help you break into the IT field or switch roles within the industry, this course ensures you are well-prepared for your career.This engaging course is perfect for those with a passion for technical hands-on activities and aims to provide a solid foundation in SQL Server administration. Prerequisite to this course is a virtual lab, with setup videos available in my first course (Comprehensive SQL Server Administration Lab Setup). Trainees with an existing lab can skip the first course and proceed with this course.

Who this course is for
Individuals with Technical Hands-On Abilities (Prospective Microsoft SQL Server Database Administrators)
Beginner/Junior Microsoft SQL Server Database Administrators
Mid-Level/ Intermediate Microsoft SQL Server Database Administrators
Homepage