SQL Server 2022 Administration

Focused View

Eric Johnson and Microsoft Press

12:22:28

86 View

01 - Introduction

01 - Introduction.mp4

02:42

02 - Lesson 1 Installing and Using SQL Server Administration and Development Tools

01 - Module 1 introduction.mp4

00:24

02 - Learning objectives.mp4

00:39

03 - Understand the installation center.mp4

05:58

04 - Find the tools installed with the SQL Server.mp4

08:19

05 - Use the performance and reliability monitoring tools.mp4

19:42

06 - Understand SQL Server Management Studio.mp4

08:13

03 - Lesson 2 Introducing Database Server Components

01 - Learning objectives.mp4

00:33

02 - Configure server memory.mp4

08:43

03 - Setup database files.mp4

15:36

04 - Configure network settings.mp4

17:10

05 - Setup SQL Server security.mp4

13:09

04 - Lesson 3 Provisioning SQL Server SQL Databases

01 - Module 2 introduction.mp4

00:21

02 - Learning objectives.mp4

00:35

03 - Install a new instance.mp4

19:39

04 - Make post-installation server configuration changes.mp4

17:17

05 - Install and configure database features.mp4

20:33

06 - Create SQL Server databases.mp4

12:28

05 - Lesson 4 Provisioning Azure SQL Database

01 - Learning objectives.mp4

00:40

02 - Understand Microsoft Azure and database-as-a-service concepts.mp4

08:13

03 - Provision a logical SQL Server.mp4

14:10

04 - Provision a database.mp4

11:15

05 - Setup security in Azure SQL databases.mp4

11:45

06 - Lesson 5 Implementing and Managing SQL Server User Security and Permissions

01 - Module 3 introduction.mp4

00:21

02 - Learning objectives.mp4

00:47

03 - Understand logins and users.mp4

11:11

04 - Setup permissions in SQL Server.mp4

34:19

05 - Migrate SQL Server logins and permissions.mp4

12:39

07 - Lesson 6 Securing the Server and Data

01 - Learning objectives.mp4

00:41

02 - Handle encryption in SQL Server.mp4

10:20

03 - Setup row level security.mp4

11:34

04 - Understand data masking.mp4

08:24

05 - Configure SQL Server audits.mp4

12:49

08 - Lesson 7 Understanding and Designing SQL Server Tables

01 - Module 4 introduction.mp4

00:25

02 - Learning objectives.mp4

00:37

03 - Review table design.mp4

12:38

04 - Understand special table types.mp4

07:23

05 - Create views.mp4

12:06

06 - Use change tracking.mp4

12:02

07 - Understand change data capture.mp4

10:44

09 - Lesson 8 Performance Tuning and Optimizing SQL

01 - Learning objectives.mp4

00:39

02 - Understand isolation levels.mp4

24:53

03 - Use execution plans.mp4

10:37

04 - Configure clustered indexes.mp4

17:35

05 - Configure non-clustered indexes.mp4

23:46

06 - Use index statistics.mp4

10:02

10 - Lesson 9 Developing, Deploying, and Managing Data Recovery

01 - Module 5 introduction.mp4

00:31

02 - Learning objectives.mp4

00:53

03 - Understand data recovery fundamentals.mp4

02:18

04 - Understand backup devices.mp4

06:27

05 - Understand different types of backups.mp4

10:41

06 - Create and verify backups.mp4

21:51

07 - Restore a database.mp4

18:31

08 - Define a backup and recovery strategy.mp4

11:01

11 - Lesson 10 Implementing SQL Server High Availability and Disaster Recovery

01 - Learning objectives.mp4

00:46

02 - Review high availability and disaster recovery technologies.mp4

04:43

03 - Setup SQL Server Log shipping.mp4

27:03

04 - Replication for high availability.mp4

35:43

05 - Read secondary database copies.mp4

10:03

12 - Lesson 11 Managing and Monitoring SQL Server Databases

01 - Module 6 Introduction.mp4

00:28

02 - Learning objectives.mp4

00:40

03 - Schedule and monitor database backups.mp4

12:07

04 - Deal with database corruption.mp4

04:09

05 - Setup index maintenance.mp4

14:51

06 - Cleanup history.mp4

08:38

07 - Shrink databases.mp4

11:36

08 - Monitor database activity.mp4

09:44

09 - Use performance monitor.mp4

05:57

10 - Monitor database logs.mp4

05:08

11 - Use resource governor.mp4

10:37

13 - Lesson 12 Automating SQL Server Administration

01 - Learning objectives.mp4

00:38

02 - Understand the components of SQL Server automated administration.mp4

20:26

03 - Setup database maintenance plans.mp4

14:56

04 - Use PowerShell to automate SQL Server administration.mp4

05:00

14 - Summary

01 - Summary.mp4

02:26

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Database Programming

Microsoft SQL

Eric Johnson and Microsoft Press

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.