Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Learning Microsoft SQL Server 2022

via LinkedIn Learning

Write review

Details

Provider

LinkedIn Learning
Pricing

Free Trial Available
Languages

English
Certificate

Certificate Available
Effort

1 hour 36 minutes
Sessions

Self-Paced
Level

Beginner

Found in

Coursera

Learn AI, Data Science & Business — Earn Certificates That Get You Hired

Scrimba

Free courses from frontend to fullstack and AI

Overview

Google, IBM & Meta Certificates – 40% Off

One Coursera Plus subscription covers most Professional Certificates on Coursera.

Unlock All Certificates

Get an overview of how Microsoft SQL Server 2022 works, so that you can dig into its powerful capabilities.

Syllabus

Introduction

Get to know SQL Server 2022
What you should know
Explore the code challenge environment

1. Getting Started

What is SQL Server?
Understand the editions of SQL Server
Installing SQL Server

2. Working with the Server

Configure and start the server
Log into the server
Enable the system administrator (SA) account

3. 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
Import data from a file

4. Write Transact-SQL Commands

Create a SELECT statement
Use functions to calculate values
Join data from multiple tables
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

Taught by

Adam Wilbert

Reviews

4.8 rating at LinkedIn Learning based on 635 ratings

Start your review of Learning Microsoft SQL Server 2022