Querying Microsoft SQL Server 2019

Querying Microsoft SQL Server 2019

English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 2h 41m | 397 MB

Discover how to query data from SQL Server tables. In this course, Adam Wilbert covers how to retrieve information stored in a Microsoft SQL Server database using the Transact-SQL (T-SQL) language. Learn the fundamental structure of a query and see how to manipulate data through the use of built-in functions, operators, filters, and other language features to return a dataset that’s formatted to meet a wide variety of needs and perspectives. Upon wrapping up this course, you’ll be equipped with the commands and keywords you need to know to effectively analyze your data.

Topics include:

  • Writing SELECT queries
  • Removing duplicates with DISTINCT
  • Matching text with LIKE and wildcards
  • Retrieving records from multiple tables
  • Grouping records
  • Using functions in T-SQL
  • Writing SQL scripts
  • Using subqueries
  • Creating and using variables in a query
Table of Contents

1 Turn data into information with queries
2 What you should know
3 Download the sample database
4 What is Transact SQL
5 The SQL querying environment
6 Return records with SELECT and FROM
7 Filter records with WHERE
8 Sort records with ORDER BY
9 Column aliases
10 Create values with constants
11 Limit results with TOP
12 Remove duplicates with DISTINCT
13 Comparison operators
14 Understand NULL values
15 Match text with LIKE and wildcards
16 Table joins and relationships
17 Inner joins
18 Left, right, and full outer joins
19 Cross joins
20 Understand record grouping
21 Use GROUP BY and COUNT
22 Aggregate functions
23 Explore data with SUM
24 Filter groups with HAVING
25 Use functions in T-SQL
26 String functions
27 Text concatenation
28 Round with mathematical functions
29 Work with date functions
30 FORMAT date and times
31 Return random records with NEWID
32 The IIF logical function
33 Change database context with USE
34 Add comments to a script
35 When to use square brackets
36 What is a subquery
37 Use a subquery in a WHERE clause
38 Correlated subqueries
39 PIVOT the result set
40 Create and use variables in a query
41 Create a counter for a looping statement
42 Combine results with UNION
43 Return distinct rows with EXCEPT
44 Return common rows with INTERSECT
45 Next steps