Learning Microsoft SQL Server 2019

Course details

Never worked with a database before? In this course, Adam Wilbert goes over the most important features of working with SQL Server 2019, providing brand-new users with a first look at how the server operates. Instructor Adam Wilbert introduces the main working environment, SQL Server Management Studio, and walks you through how to create tables, define relationships, and write and run queries with Transact-SQL commands. Upon wrapping up this course, you’ll know everything you need to accomplish to create your first database. Start watching to quickly get up and running with this professional-grade database management system.

Learning objectives
What is SQL Server?
Configuring the server
Creating a new database and data tables
Joining tables with keys
Creating a SELECT statement
Writing an UPDATE statement
Adding data with the INSERT statement

Concepts

0. Introduction

01 - Transform your powerful data with SQL Server 2019
02 - What you should know
03 - Explore the code challenge environment

1. Get Started with SQL Server

04 - What is SQL Server
05 - Understand the editions of SQL Server
06 - Install SQL Server

2. Work with the Server

07 - Configure and start the server
08 - Log into the server
09 - Locate SQL Server documentation

3. SQL Server Management Studio

10 - Tour the SSMS interface
11 - Install a sample database
12 - Create a new database on the server
13 - Understand SQL data types
14 - Create a data table
15 - Join tables together with keys

4. Write Transact-SQL Commands

16 - Create a SELECT statement
17 - Use functions to calculate values
18 - Write an UPDATE statement
19 - Add data with an INSERT statement
20 - Create a view of the data
21 - Solution - Select data from a table
22 - Solution - Join related tables with a query
23 - Solution - Use functions to calculate values
24 - Solution - Update the data stored in a table

Conclusion

25 - Next steps

Learning Microsoft SQL Server 2019

Authors

Adam Wilbert