From the course: SQL Server 2022 Administration

Introduction - SQL Server Tutorial

From the course: SQL Server 2022 Administration

Start my 1-month free trial Buy for my team

Introduction

“

Welcome to SQL Server 2022 Administration Inside Out. My name is Eric Johnson, and I'm here to help give you the knowledge and tools you need to correctly and effectively manage SQL Server in your environment. By the end of this course, I hope you'll have a newfound appreciation for SQL Server and a better idea of how to manage it. Over the years I've worked with SQL Server in many different capacities. As a developer, I've written applications that utilize SQL Server databases. As a database architect, I have designed databases that SQL Server hosts. And I've also supported third party applications that use SQL Server as a backend. In addition, I've spent my fair share of time working as an actual Database Administrator, and I'm here to teach you what I can about administering SQL Server. Let's talk about the game plan. We start by introducing SQL Server, its tools, its components, how to install it, and we talk about SQL Server instances, database tools, and we look at database server components, including common configuration options for the database engine, and we'll take our first look at security and high availability. Next, we look at provisioning SQL Server and Azure SQL Databases. We'll give you everything you need to know about setting up and configuring your SQL Servers, plus the basics of working with setting up Azure Databases. Securing SQL Server is absolutely critical, so we'll look at implementing and managing SQL Server user security and permissions, and how to secure the server itself, and we'll take a peek at data encryption and data masking. Next, we cover designing, tuning, and optimizing SQL Server. We'll look at database design, performance tuning, including indexes, statistics, and look a little bit at isolation levels and execution plans. We then move on to managing data recovery and implementing SQL Server high availability. You'll learn to develop, deploy, and manage data recovery strategies to ensure high availability of your servers, as well as how to recover when disaster strikes. Finally, we cover managing, monitoring, and automating SQL Server. You'll learn to manage your databases day to day and monitor activity to keep your servers performing in peak condition. We'll also look at ways to automate SQL administration, including through the use of PowerShell. Now, I know that's a lot of ground to cover, but remember, just go at your own pace and work along with me. I'm excited to get started, but before we do, I want to say thank you for choosing this Inside Out series and for choosing to learn from me. I hope you gain the knowledge you're looking for on which you can form a foundation to build over the years. With that, let's dive in.

Contents