وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

Comprehensive SQL Server Administration Part 1

سرفصل های دوره

Introduction to SQL Server, Authentications, RBAC, Database Maintenance, Disaster Recovery, and High Availability


1 - Introduction to Microsoft SQL Server
  • 1 -Section 01 - Introduction to SQL Server.pdf
  • 1 -What is SQL Server
  • 2 -The Evolution (Versions) of SQL Server
  • 3 -The Editions of SQL Server
  • 4 -The SQL Server Configuration Manager
  • 5 -The SQL Server Management Studio
  • 6 -Demo SQL Server Configuration Manager
  • 7 -Demo SQL Server Management Studio Part 1
  • 8 -Demo SQL Server Management Studio Part 2
  • 9 -SQL Server Databases
  • 10 -Database Types
  • 11 -System Databases (Deep Dive)
  • 12 -Database Server Environments
  • 13 -Demo Database Types Part 1
  • 14 -Demo Database Types Part 2
  • 15 -Demo Database Types Part 3

  • 2 - Authentications, Role-Based Access Control and Permissions
  • 1 -Logins and Users
  • 1 -Section 02 - Authentications, Role-Based Access Control and Permissions.pdf
  • 2 -Server Roles
  • 3 -Database Roles
  • 4 -Permissions
  • 5 -Demo Windows Login
  • 6 -Demo Database Roles
  • 7 -Demo Login Failed Error Troubleshooting
  • 8 -Demo Roles and Permissions
  • 9 -Demo Windows Active Directory Group
  • 10 -Demo SQL Login

  • 3 - Disaster Recovery
  • 1 -Section 03 - Disaster Recovery Strategies and Database Maintenance.pdf
  • 1 -What is a Disaster
  • 2 -Disaster Recovery Terminologies
  • 3 -Database Recovery Models
  • 4 -Database Backup Part 1
  • 5 -Database Backup Part 2
  • 6 -Database Restore
  • 7 -Demo Disaster Recovery Strategies Part 1
  • 8 -Demo Disaster Recovery Strategies Part 2
  • 9 -Demo Database Backup Part 1
  • 10 -Demo Database Backup Part 2
  • 11 -Demo Database Restore Part 1
  • 12 -Demo Database Restore Part 2
  • 13 -Demo Database Restore Part 3
  • 14 -Disaster Recovery Exercises

  • 4 - Database Maintenance
  • 1 -Database Maintenance Tasks
  • 2 -Demo Database Maintenance Tasks Using GUI Part 1
  • 3 -Demo Database Maintenance Tasks Using GUI Part 2
  • 4 -Demo Database Maintenance Tasks Using GUI Part 3
  • 5 -Demo Database Maintenance Tasks Using Ola Hallengren Part 1
  • 6 -Demo Database Maintenance Tasks Using Ola Hallengren Part 2
  • 7 -Knowledge Check Exercises

  • 5 - Log Shipping
  • 1 -Introduction to High Availability
  • 2 -Introduction to Log Shipping
  • 3 -Log Shipping Pros and Cons
  • 4 -Demo Log Shipping Configuration Part 1
  • 5 -Demo Log Shipping Configuration Part 2
  • 6 -Demo Log Shipping Configuration Part 3
  • 7 -Demo Failover in Log Shipping Part 1

  • 6 - Mirroring
  • 1 -Introduction to Database Mirroring
  • 2 -Synchronous vs Asynchronous Commit Modes
  • 3 -Database Mirroring Pros and Cons
  • 4 -Demo Database Mirroring Configuration Part 1
  • 5 -Demo Database Mirroring Configuration Part 2
  • 6 -Demo Database Mirroring Configuration Part 3

  • 7 - AlwaysOn Availability Group
  • 1 -Introduction to AlwaysOn Availability Group
  • 2 -AlwaysOn Availability Group Pros and Cons Part 1
  • 3 -AlwaysOn Availability Group Pros and Cons Part 2
  • 4 -AlwaysOn Availability Group Configuration Steps Part 1
  • 5 -AlwaysOn Availability Group Configuration Steps Part 2
  • 6 -Demo AlwaysOn Availability Group Configuration Part 1
  • 7 -Demo AlwaysOn Availability Group Configuration Part 2
  • 8 -Demo AlwaysOn Availability Group Configuration Part 3
  • 9 -Demo AlwaysOn Availability Group Configuration Part 4
  • 10 -Demo AlwaysOn Availability Group Cluster Permission
  • 11 -Demo AlwaysOn Availability Group Quorum Configuration

  • 8 - Replication
  • 1 -Introduction to Replication
  • 2 -Replication Topology
  • 3 -Replication Backward Compatibility
  • 4 -Replication Types
  • 5 -Replication Agents
  • 6 -Transactional vs Snapshot Replication
  • 7 -Replication Pros and Cons
  • 8 -Demo Transactional Replication Configuration Part 1
  • 9 -Demo Transactional Replication Configuration Part 2
  • 10 -Demo Transactional Replication Configuration Part 3
  • 11 -Demo Transactional Replication Configuration Part 4
  • 12 -Demo Transactional Replication Configuration Part 5
  • 13 -Demo Snapshot Replication Configuration
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 44312
    حجم: 5183 مگابایت
    مدت زمان: 708 دقیقه
    تاریخ انتشار: ۲۰ اردیبهشت ۱۴۰۴
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید