https://i124.fastpic.org/big/2024/1216/f4/46bc352f73547c4c742bf863c32311f4.jpg
Comprehensive Sql Server Administration Part 1
Published 11/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 5.29 GB | Duration: 11h 48m
Introduction to SQL Server, Authentications, RBAC, Database Maintenance, Disaster Recovery, and High Availability
What you'll learn
Microsoft SQL Server, Versions, Editions, Database Types, Configuration Manager and Management Studio
Authentication Types, Role-Based Access Control (Server and Database Roles) and the Principle of Least Privilege
Industry Standard Disaster Recovery Strategies Using RPO, RTO and SLA
Database Maintenance Tasks (Database Backup, Index Maintenance, Statistics Update and Database Integrity Check)
High Availability Solutions such as Log Shipping, Mirroring, AlwaysOn Availability Group and Replication
Requirements
No Prior Information Technology (I.T) Experience Is Required
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 authentications, database maintenance, disaster recovery, and high availability (Log Shipping, Mirroring, AlwaysOn Availability Group, and Replication).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.
Overview
Section 1: Introduction to Microsoft SQL Server
Lecture 1 What is SQL Server?
Lecture 2 The Evolution (Versions) of SQL Server
Lecture 3 The Editions of SQL Server
Lecture 4 The SQL Server Configuration Manager
Lecture 5 The SQL Server Management Studio
Lecture 6 Demo: SQL Server Configuration Manager
Lecture 7 Demo: SQL Server Management Studio Part 1
Lecture 8 Demo: SQL Server Management Studio Part 2
Lecture 9 SQL Server Databases
Lecture 10 Database Types
Lecture 11 System Databases (Deep Dive)
Lecture 12 Database Server Environments
Lecture 13 Demo: Database Types Part 1
Lecture 14 Demo: Database Types Part 2
Lecture 15 Demo: Database Types Part 3
Section 2: Authentications, Role-Based Access Control and Permissions
Lecture 16 Logins and Users
Lecture 17 Server Roles
Lecture 18 Database Roles
Lecture 19 Permissions
Lecture 20 Demo: Windows Login
Lecture 21 Demo: Database Roles
Lecture 22 Demo: Login Failed Error Troubleshooting
Lecture 23 Demo: Roles and Permissions
Lecture 24 Demo: Windows Active Directory Group
Lecture 25 Demo: SQL Login
Section 3: Disaster Recovery
Lecture 26 What is a Disaster?
Lecture 27 Disaster Recovery Terminologies
Lecture 28 Database Recovery Models
Lecture 29 Database Backup Part 1
Lecture 30 Database Backup Part 2
Lecture 31 Database Restore
Lecture 32 Demo: Disaster Recovery Strategies Part 1
Lecture 33 Demo: Disaster Recovery Strategies Part 2
Lecture 34 Demo: Database Backup Part 1
Lecture 35 Demo: Database Backup Part 2
Lecture 36 Demo: Database Restore Part 1
Lecture 37 Demo: Database Restore Part 2
Lecture 38 Demo: Database Restore Part 3
Lecture 39 Disaster Recovery Exercises
Section 4: Database Maintenance
Lecture 40 Database Maintenance Tasks
Lecture 41 Demo: Database Maintenance Tasks Using GUI Part 1
Lecture 42 Demo: Database Maintenance Tasks Using GUI Part 2
Lecture 43 Demo: Database Maintenance Tasks Using GUI Part 3
Lecture 44 Demo: Database Maintenance Tasks Using Ola Hallengren Part 1
Lecture 45 Demo: Database Maintenance Tasks Using Ola Hallengren Part 2
Lecture 46 Knowledge Check Exercises
Section 5: Log Shipping
Lecture 47 Introduction to High Availability
Lecture 48 Introduction to Log Shipping
Lecture 49 Log Shipping Pros and Cons
Lecture 50 Demo: Log Shipping Configuration Part 1
Lecture 51 Demo: Log Shipping Configuration Part 2
Lecture 52 Demo: Log Shipping Configuration Part 3
Lecture 53 Demo: Failover in Log Shipping Part 1
Lecture 54 Demo: Failover in Log Shipping Part 2
Section 6: Mirroring
Lecture 55 Introduction to Database Mirroring
Lecture 56 Synchronous vs Asynchronous Commit Modes
Lecture 57 Database Mirroring Pros and Cons
Lecture 58 Demo: Database Mirroring Configuration Part 1
Lecture 59 Demo: Database Mirroring Configuration Part 2
Lecture 60 Demo: Database Mirroring Configuration Part 3
Section 7: AlwaysOn Availability Group
Lecture 61 Introduction to AlwaysOn Availability Group
Lecture 62 AlwaysOn Availability Group Pros and Cons Part 1
Lecture 63 AlwaysOn Availability Group Pros and Cons Part 2
Lecture 64 AlwaysOn Availability Group Configuration Steps Part 1
Lecture 65 AlwaysOn Availability Group Configuration Steps Part 2
Lecture 66 Demo: AlwaysOn Availability Group Configuration Part 1
Lecture 67 Demo: AlwaysOn Availability Group Configuration Part 2
Lecture 68 Demo: AlwaysOn Availability Group Configuration Part 3
Lecture 69 Demo: AlwaysOn Availability Group Configuration Part 4
Lecture 70 Demo: AlwaysOn Availability Group Cluster Permission
Lecture 71 Demo: AlwaysOn Availability Group Quorum Configuration
Section 8: Replication
Lecture 72 Introduction to Replication
Lecture 73 Replication Topology
Lecture 74 Replication Backward Compatibility
Lecture 75 Replication Types
Lecture 76 Replication Agents
Lecture 77 Transactional vs Snapshot Replication
Lecture 78 Replication Pros and Cons
Lecture 79 Demo: Transactional Replication Configuration Part 1
Lecture 80 Demo: Transactional Replication Configuration Part 2
Lecture 81 Demo: Transactional Replication Configuration Part 3
Lecture 82 Demo: Transactional Replication Configuration Part 4
Lecture 83 Demo: Transactional Replication Configuration Part 5
Lecture 84 Demo: Snapshot Replication Configuration
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
https://images2.imgbox.com/4b/89/kk62QmXU_o.jpg
https://filecrypt.cc/Container/BD5959755B.html
https://fikper.com/UlH59mdRoF/Udemy_Comprehensive_SQL_Server_Administration_Part_1_2024-10.part1.rar.html
https://fikper.com/B8wyAmOZRM/Udemy_Comprehensive_SQL_Server_Administration_Part_1_2024-10.part2.rar.html
https://fikper.com/e3jm2b0K4L/Udemy_Comprehensive_SQL_Server_Administration_Part_1_2024-10.part3.rar.html
https://fikper.com/DNuGei9Rbp/Udemy_Comprehensive_SQL_Server_Administration_Part_1_2024-10.part4.rar.html
https://filecrypt.cc/Container/79D359082B.html
https://filecrypt.cc/Container/6C2D8F10AC.html
Видео
