Learning Microsoft SQL Server 2022

Focused View

1:36:37

406 View

01 - Introduction

01 - Get to know SQL Server 2022.mp4

00:35

02 - What you should know.mp4

00:36

02 - 1. Getting Started

03 - What is SQL Server.mp4

05:38

04 - Understand the editions of SQL Server.mp4

05:30

05 - Installing SQL Server.mp4

05:18

03 - 2. Working with the Server

06 - Configure and start the server.mp4

03:57

07 - Log into the server.mp4

03:48

08 - Enable the system administrator (SA) account.mp4

04:08

04 - 3. SQL Server Management Studio

09 - Tour the SSMS interface.mp4

07:53

10 - Install a sample database.mp4

04:47

11 - Create a new database on the server.mp4

03:40

12 - Understand SQL data types.mp4

03:19

13 - Create a data table.mp4

07:06

14 - Import data from a file.mp4

03:42

05 - 4. Write Transact-SQL Commands

15 - Create a SELECT statement.mp4

06:15

16 - Use functions to calculate values.mp4

07:16

17 - Join data from multiple tables.mp4

04:54

18 - Write an UPDATE statement.mp4

04:37

19 - Add data with an INSERT statement.mp4

04:51

20 - Create a view of the data.mp4

07:42

06 - Conclusion

21 - Next steps.mp4

01:05

Description

In this course, database expert Adam Wilbert introduces you to the newest version of SQL Server 2022 and SQL Server Management Studio. No prior SQL database experience is expected. Learn how to set up your own database server and begin creating databases for your valuable data. Adam explains Microsoft SQL Server 2022 as a relational database management system (RDBMS) and shows you how to get it installed and configured. He goes over working with the server, then gives you a tour of SQL Server Management Studio, including creating a new database, creating a data table, importing data from a file, and more. Adam guides you through writing several types of Transact SQL commands. Plus, he recommends additional courses to help you continue learning more about Microsoft SQL Server 2022.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft SQL

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.