Querying Microsoft SQL Server 2019

English | 2h 41m | Video 720p | Subtitles

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

 

Homepage:

https://www.lynda.com/SQL-Server-tutorials/Querying-Microsoft-SQL-Server-2019/2229238-2.html