Learning Microsoft SQL Server 2022

سرفصل های دوره

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.

01 - Introduction

01 - Get to know SQL Server 2022

02 - What you should know

02 - 1. Getting Started

03 - What is SQL Server

04 - Understand the editions of SQL Server

05 - Installing SQL Server

03 - 2. Working with the Server

06 - Configure and start the server

07 - Log into the server

08 - Enable the system administrator (SA) account

04 - 3. SQL Server Management Studio

09 - Tour the SSMS interface

10 - Install a sample database

11 - Create a new database on the server

12 - Understand SQL data types

13 - Create a data table

14 - Import data from a file

05 - 4. Write Transact-SQL Commands

15 - Create a SELECT statement

16 - Use functions to calculate values

17 - Join data from multiple tables

18 - Write an UPDATE statement

19 - Add data with an INSERT statement

20 - Create a view of the data

06 - Conclusion

21 - Next steps

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: LinkedIn Learning (Lynda)