Querying Microsoft SQL Server 2022

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

Want to learn more about how to query data from SQL Server tables? In this course, instructor Adam Wilbert covers how to retrieve information stored in a Microsoft SQL Server database using the Transact-SQL (T-SQL) language and the updated features of SQL Server 2022.

Learn the fundamental structure of a successful query, from ideation to execution. Find out how to manipulate data through the use of built-in functions, operators, filters, and other language features to return a data set, ensuring that it’s properly formatted and applicable to a wide variety of needs and perspectives. Along the way, Adam gives you tips and pointers on how to get the most out of your queries. Upon completing this course, you'll be equipped with the commands and keywords you need to know to analyze your data more effectively.

01 - Introduction

01 - Turn data into information with queries

02 - What you should know

03 - Download the sample database

02 - 1. Introduction to T-SQL Queries

01 - What is Transact SQL

02 - The SQL querying environment

03 - Return records with SELECT and FROM

04 - Filter records with WHERE

05 - Sort records with ORDER BY

06 - Column aliases

07 - Create values with constants and math

08 - Challenge Write a SELECT query

09 - Solution Write a SELECT query

03 - 2. Additional Filter Techniques

01 - Limit results with TOP

02 - Remove duplicates with DISTINCT

03 - Comparison operators

04 - Understand NULL values

05 - Match text with LIKE and wildcards

06 - Challenge Retrieve matching text strings

07 - Solution Retrieve matching text strings

04 - 3. Retrieve Records from Multiple Tables

01 - Table joins and relationships

02 - Inner joins

03 - Left, right, and full outer joins

04 - Cross joins

05 - Challenge Return data from multiple tables

06 - Solution Return data from multiple tables

05 - 4. Group Records

01 - Understand record grouping

02 - Use GROUP BY and COUNT

03 - Aggregate functions

04 - Explore data with SUM

05 - Filter groups with HAVING

06 - Challenge Obtain order summaries

07 - Solution Obtain order summaries

06 - 5. Manipulate Data with Functions

01 - Use functions in T-SQL

02 - String functions

03 - Text concatenation

04 - Round with mathematical functions

05 - Find the GREATEST or LEAST value

06 - Work with date functions

07 - FORMAT date and times

08 - Group dates into buckets

09 - Return random records with NEWID

10 - Create a series of values

11 - The IIF logical function

12 - Write a CASE statement

13 - Challenge Use functions in a SQL query

14 - Solution Use functions in a SQL query

07 - 6. Writing SQL Scripts

01 - Change database context with USE

02 - Add comments to a script

03 - When to use square brackets

08 - 7. SQL Subqueries

01 - What is a subquery

02 - Use a subquery in a HAVING clause

03 - Correlated subqueries

04 - PIVOT the result set

05 - Challenge Write a query with a subquery

06 - Solution Write a query with a subquery

09 - 8. Work with Variables

01 - Create and use variables in a query

02 - Create a counter for a looping statement

03 - Challenge Use variables in a query

04 - Solution Use variables in a query

10 - 9. Result Set Operators

01 - Combine results with UNION

02 - Return distinct rows with EXCEPT

03 - Return common rows with INTERSECT

11 - Conclusion

01 - Next steps

189,000 تومان

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

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

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

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