Course Outline

Introduction

  • Overview of Microsoft SQL Server 2019
  • Features and tools of SQL Server 2019
  • Understanding SQL Server 2019 core concepts

Getting Started

  • Installing SQL Server
  • Installing Management studio
  • Enabling features using the configuration manager
  • Using Management Studio
  • Authenticating and granting user permissions
  • Creating a new user account

Creating Databases

  • Creating the first database
  • Configuring the database
  • Understanding table structures
  • Creating a simple table
  • Editing a table
  • Entering data
  • Importing data from csv files
  • Creating tables from flat files
  • Installing a sample database

Maintaining a Healthy Database

  • Understanding data types
  • Understanding table column properties
  • Using primary key fields
  • Establishing default values
  • Check and unique constraints
  • Using foreign keys
  • Creating a foreign key column
  • Creating relationships between tables

Using Structured Query Language

  • Understanding the role of T-SQL
  • Using the T-SQL editor
  • Creating a table with T-SQL
  • Adding data to a table
  • Retrieving records
  • Filtering returned results
  • Sorting and updating records
  • Deleting records from a table
  • Joining related tables
  • Removing a table from the database

Query Performance and Programmability

  • Creating a view of the data
  • Using data table indexes
  • Creating additional indexes on a table
  • Viewing execution plans
  • SQL Server's Query Store
  • Rebuilding indexes
  • Aggregating functions
  • Using built-in functions
  • User-defined scalar functions
  • Creating stored procedures
  • Using parameterized stored procedures

Backup and Restore

  • Creating a full backup of the database
  • Creating a differential backup
  • Restoring a backup
  • Automating backups
  • Using business continuity solutions

Security

  • Understanding user roles and permissions
  • Using database schemas
  • Dynamic data masking
  • Always On data encryption

Management and Monitoring

  • Exploring the role of system databases
  • Preventing excessive tempdb autogrowth
  • Reviewing the SQL Server error log
  • Using dynamic management views
  • Database Console Commands (DBCC)

Summary and Next Steps

Requirements

  • Basic knowledge of SQL

Audience

  • Database administrators
 14 Hours

Testimonials (5)