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

Introduction

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

Get Started with SQL Server

What is SQL Server
Understand the editions of SQL Server
Install SQL Server

Work with the Server

Configure and start the server
Log into the server
Locate SQL Server documentation

SQL Server Management Studio

Tour the SSMS interface
Install a sample database
Create a new database on the server
Understand SQL data types
Create a data table
Join tables together with keys

Write Transact-SQL Commands

Create a SELECT statement
Use functions to calculate values
Write an UPDATE statement
Add data with an INSERT statement
Create a view of the data
Solution - Select data from a table
Solution - Join related tables with a query
Solution - Use functions to calculate values
Solution - Update the data stored in a table

Conclusion

Next steps