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

جمع جزء: 1,946,000 تومان

مشاهده سبد خریدتسویه حساب

رمز خود را فراموش کرده اید؟
وب سایت تخصصی شرکت فرین
14
خانه » فروشگاه » SQL Server 2022 Administration

SQL Server 2022 Administration

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

Looking to get up to speed with the latest features of SQL Server 2022? In this course, join database analyst and trainer Eric Johnson as he covers the fundamental skills, techniques, and tools required to manage SQL Server 2022 in any development environment, regardless of your current level of experience. Learn about the new features available in the latest version of SQL Server as well as how to provision and secure Azure databases, design SQL Server tables, and tune and optimize SQL to meet your own unique needs. Throughout the course, Eric explains the relevant concepts and methodologies of managing and automating SQL Server databases, showing you how to apply what you’ve learned in a series of ongoing visual demonstrations designed to help you get hands-on practice and start building more advanced skills.

Note: This course was created by Microsoft Press. We are pleased to host this training in our library.


01 - Introduction
  • 01 - Introduction

    • 02 - Lesson 1 Installing and Using SQL Server Administration and Development Tools
  • 01 - Module 1 introduction
  • 02 - Learning objectives
  • 03 - Understand the installation center
  • 04 - Find the tools installed with the SQL Server
  • 05 - Use the performance and reliability monitoring tools
  • 06 - Understand SQL Server Management Studio

    • 03 - Lesson 2 Introducing Database Server Components
  • 01 - Learning objectives
  • 02 - Configure server memory
  • 03 - Setup database files
  • 04 - Configure network settings
  • 05 - Setup SQL Server security

    • 04 - Lesson 3 Provisioning SQL Server SQL Databases
  • 01 - Module 2 introduction
  • 02 - Learning objectives
  • 03 - Install a new instance
  • 04 - Make post-installation server configuration changes
  • 05 - Install and configure database features
  • 06 - Create SQL Server databases

    • 05 - Lesson 4 Provisioning Azure SQL Database
  • 01 - Learning objectives
  • 02 - Understand Microsoft Azure and database-as-a-service concepts
  • 03 - Provision a logical SQL Server
  • 04 - Provision a database
  • 05 - Setup security in Azure SQL databases

    • 06 - Lesson 5 Implementing and Managing SQL Server User Security and Permissions
  • 01 - Module 3 introduction
  • 02 - Learning objectives
  • 03 - Understand logins and users
  • 04 - Setup permissions in SQL Server
  • 05 - Migrate SQL Server logins and permissions

    • 07 - Lesson 6 Securing the Server and Data
  • 01 - Learning objectives
  • 02 - Handle encryption in SQL Server
  • 03 - Setup row level security
  • 04 - Understand data masking
  • 05 - Configure SQL Server audits

    • 08 - Lesson 7 Understanding and Designing SQL Server Tables
  • 01 - Module 4 introduction
  • 02 - Learning objectives
  • 03 - Review table design
  • 04 - Understand special table types
  • 05 - Create views
  • 06 - Use change tracking
  • 07 - Understand change data capture

    • 09 - Lesson 8 Performance Tuning and Optimizing SQL
  • 01 - Learning objectives
  • 02 - Understand isolation levels
  • 03 - Use execution plans
  • 04 - Configure clustered indexes
  • 05 - Configure non-clustered indexes
  • 06 - Use index statistics

    • 10 - Lesson 9 Developing, Deploying, and Managing Data Recovery
  • 01 - Module 5 introduction
  • 02 - Learning objectives
  • 03 - Understand data recovery fundamentals
  • 04 - Understand backup devices
  • 05 - Understand different types of backups
  • 06 - Create and verify backups
  • 07 - Restore a database
  • 08 - Define a backup and recovery strategy

    • 11 - Lesson 10 Implementing SQL Server High Availability and Disaster Recovery
  • 01 - Learning objectives
  • 02 - Review high availability and disaster recovery technologies
  • 03 - Setup SQL Server Log shipping
  • 04 - Replication for high availability
  • 05 - Read secondary database copies

    • 12 - Lesson 11 Managing and Monitoring SQL Server Databases
  • 01 - Module 6 Introduction
  • 02 - Learning objectives
  • 03 - Schedule and monitor database backups
  • 04 - Deal with database corruption
  • 05 - Setup index maintenance
  • 06 - Cleanup history
  • 07 - Shrink databases
  • 08 - Monitor database activity
  • 09 - Use performance monitor
  • 10 - Monitor database logs
  • 11 - Use resource governor

    • 13 - Lesson 12 Automating SQL Server Administration
  • 01 - Learning objectives
  • 02 - Understand the components of SQL Server automated administration
  • 03 - Setup database maintenance plans
  • 04 - Use PowerShell to automate SQL Server administration

    • 14 - Summary
  • 01 - Summary
    • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 15891
    حجم: 1668 مگابایت
    مدت زمان: 743 دقیقه
    تاریخ انتشار: ۱۵ تیر ۱۴۰۲
    دسته بندی محصول
    LinkedIn Learning (Lynda)
    LinkedIn Learning (Lynda)
    مشاهده دوره های LinkedIn Learning (Lynda)
    طراحی سایت و خدمات سئو

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