Description
Comprehensive SQL Server Administration Part 2. This course provides essential skills in database architecture, security, migration, and administration for administrators of all levels of experience. Designed to train Microsoft SQL Server database administrators, this course covers the fundamentals of its architecture and performance, along with critical topics such as design, migration, patching, upgrading, concurrency management, isolation levels, transparent data encryption, and dynamic data masking. The course content is enriched with practical and technical demonstrations and includes numerous practical exercises to consolidate learning. It also includes a set of common interview questions to prepare for job opportunities. This course provides a suitable path to enter the IT industry or to change specialization to the database administration field, and with an emphasis on practical activities, it creates a solid foundation for career advancement.
What you will learn
- Database migration methodologies and their suitability for business requirements.
- Database Refresh, SQL Server patching, SQL Server upgrades, and database file migration.
- Database security technologies such as Transparent Data Encryption and Dynamic Data Masking.
- Database and data warehouse 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).
This course is suitable for people who:
- People with practical technical abilities (future Microsoft SQL Server database administrators).
- Beginner/novice Microsoft SQL Server database administrators.
- Intermediate/Intermediate level Microsoft SQL Server database administrators.
Course details
- Publisher: Udemy
- Instructor: Adewale Adeniji
- Training level: Beginner to advanced
- Training duration: 12 hours and 6 minutes
- Number of lessons: 90
Course headings
Prerequisites for the Comprehensive SQL Server Administration Part 2 course
- 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
Course images
Sample course video
Installation Guide
After Extract, view with your favorite player.
Subtitles: None
Quality: 720p
Download link
Downloadly
Rapidgator link
File(s) password: www.downloadly.ir
File size
4.8 GB
