Querying Microsoft SQL Server 2019
Querying Microsoft SQL Server 2019
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 2h 41m | 394 MB
Instructor: Adam Wilbert
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 2h 41m | 394 MB
Instructor: Adam Wilbert
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
Querying Microsoft SQL Server 2019
