SQL Server 2025 Administration (Video Course)

Description

• Copyright 2027
• Edition: 1st

• Online Video
• ISBN-10: 0-13-592022-1
• ISBN-13: 978-0-13-592022-0

Master SQL Server 2025 administration with practical guidance for securing, tuning, recovering, monitoring, and automating hybrid database environments.

Microsoft SQL Server is an enterprise-grade relational database platform used to store, query, secure, and analyze business-critical data across on-premises, cloud, and hybrid environments. SQL Server 2025 introduces updates for modern data workloads, including AI-ready capabilities, enhanced T-SQL and performance features, stronger security, and closer integration with Azure services.

This hands-on course gives database professionals practical experience with the tools and daily tasks involved in administering SQL Server 2025. Instructor Scott Klein demonstrates how to install and configure SQL Server, provision SQL Server and Azure SQL databases, manage users and permissions, secure data, design and tune databases, plan backup and recovery, implement high availability, monitor environments, and automate administration with PowerShell. The course also covers hybrid management with Azure Arc and newer capabilities such as regular expressions, fuzzy string matching, PolyBase, intelligent query processing, and new data types.

Skill Level:

• Beginner
• Intermediate

Learn How To:

• Install and use SQL Server administration and development tools
• Configure SQL Server components, memory, database files, networking, and security
• Provision and configure SQL Server instances, databases, and Azure SQL databases
• Manage logins, users, permissions, encryption, row-level security, data masking, and audits
• Design tables and use views, change tracking, Change Data Capture, PolyBase, regular expressions, fuzzy matching, and new data types
• Tune performance with execution plans, indexes, statistics, Query Store, intelligent query processing, and TempDB configuration
• Create backup and recovery strategies and implement high availability and disaster recovery
• Monitor database activity, logs, maintenance, and performance, including management with Azure Arc
• Automate SQL Server administration with maintenance plans and PowerShell

Course Requirements:

• Basic knowledge of SQL Server
• Fundamental understanding of T-SQL
• Basic understanding of data concepts
• Familiarity with Microsoft Azure services and hybrid cloud architecture

Who Should Take This Course:

• SQL Server database administrators and data management specialists
• IT professionals who work with on-premises SQL Server and Azure database services
• Data platform engineers, DevOps engineers, data architects, and solution architects
• Developers who need to understand SQL Server administration for on-premises and hybrid solutions
• Students and early-career professionals building practical database administration skills

About Pearson Video Training:

Pearson publishes expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. These professional and personal technology videos feature world-leading author- instructors from trusted technology brands, including Addison-Wesley, Cisco Press, Pearson IT Certification, Prentice Hall, Sams, and Que. Topics include IT certification, network security, Cisco technology, programming, web development, mobile development, and more. Learn more about Pearson Video Training at http://www.informit.com/video.

Video lessons are available for download and offline viewing within the streaming format. Look for the green arrow in each lesson.



Sample Content

Table of Contents

Introduction

Module 1: Introducing SQL Server 2025 Tools and Components

Lesson 1: Installing and Using SQL Server Administration and Development Tools

1.1 Understand the Installation Center

1.2 Find the tools installed with SQL Server

1.3 Use the performance and reliability monitoring tools

1.4 Understand SQL Server Management Studio

Lesson 2: Introducing Database Server Components

2.1 Configure server memory

2.2 Set up database files

2.3 Configure network settings

2.4 Set up SQL Server security

Module 2: Provisioning SQL Server and Azure SQL Databases

Lesson 3: Provisioning SQL Server Databases

3.1 Install a new instance

3.2 Make post-installation SQL Server instance configuration changes

3.3 Create SQL Server databases

3.4 Make database configuration changes

3.5 Add SQL Server features to an existing instance

Lesson 4: Provisioning Azure SQL Databases

4.1 Understand Microsoft Azure and Database-as-a-Service

4.2 Provision a logical SQL Server

4.3 Provision a database

4.4 Set up security in Azure SQL databases

Module 3: Securing SQL Server

Lesson 5: Implementing and Managing SQL Server User Security and Permissions

5.1 Understand logins and users

5.2 Set up permissions in SQL Server

5.3 Migrate SQL Server logins and permissions

Lesson 6: Securing the Server and Data

6.1 Handle encryption in SQL Server

6.2 Set up row-level security

6.3 Understand data masking

6.4 Configure SQL Server audits

Module 4: Designing, Tuning, and Optimizing SQL Server

Lesson 7: Understanding and Designing SQL Server Tables

7.1 Review table design

7.2 Understand special table types

7.3 Create views

7.4 Use change tracking

7.5 Understand Change Data Capture

7.6 Use regular expressions and fuzzy string matching

7.7 Use PolyBase

7.8 Understand new data types

Lesson 8: Performance Tuning and Optimizing SQL

8.1 Understand isolation levels

8.2 Use execution plans

8.3 Configure clustered indexes

8.4 Configure nonclustered indexes

8.5 Use index statistics

8.6 Understand the Query Store

8.7 Understand intelligent query processing

8.8 Configure TempDB

Module 5: Managing Data Recovery and Implementing SQL Server High Availability

Lesson 9: Developing, Deploying, and Managing Data Recovery

9.1 Understand data recovery fundamentals

9.2 Understand backup devices

9.3 Understand different types of backups

9.4 Create and verify backups

9.5 Restore a database

9.6 Define a backup and recovery strategy

Lesson 10: Implementing SQL Server High Availability and Disaster Recovery

10.1 Review high availability and disaster recovery technologies

10.2 Set up SQL Server log Shipping

10.3 Replication for high availability

10.4 Always On availability groups

10.5 Read secondary database copies

Module 6: Managing, Monitoring, and Automating SQL Server

Lesson 11: Managing and Monitoring SQL Server Databases

11.1 Schedule and monitor database backups

11.2 Deal with database corruption

11.3 Set up index maintenance

11.4 Clean up job history

11.5 Shrink databases

11.6 Monitor database activity

11.7 Use Performance Monitor

11.8 Monitor database logs

11.9 Use Resource Governor

11.10 Manage SQL Server with Azure Arc

Lesson 12: Automating SQL Server Administration

12.1 Understand the components of SQL Server automated administration

12.2 Set up database maintenance plans

12.3 Use PowerShell to automate SQL Server administration

Summary



Updates

Submit Errata

