Learn SQL Server 2022 Administration - Full Course

Learn about SQL Server 2022 Administration in this full course for beginners. This course 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.

What you will learn:

• 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

• Introducing Database Server Components

   01 - Learning objectives
   02 - Configure server memory
   03 - Setup database files
   04 - Configure network settings
   05 - Setup SQL Server security

• 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

• Provisioning Azure SQL Databases

   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

• Securing the Server and Data

   01 - Learning objectives
   02 - Handle encryption in SQL Serverconcepts
   03 - Setup row level security
   04 - Understand data masking
   05 - Configure SQL Server audits

• 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

• 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

• 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

• 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

• 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

• 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

And More

SQL Server 2022 - Full Course for Beginners (Part 1/2)

SQL Server 2022 - Full Course for Beginners (Part 2/2)

#sqlserver #sql