YoVDO

Querying Microsoft SQL Server 2019

Offered By: LinkedIn Learning

Tags

Microsoft SQL Server Courses Data Manipulation Courses Subqueries Courses Table Joins Courses

Course Description

Overview

Learn how to retrieve information stored in a Microsoft SQL Server database using the Transact-SQL (T-SQL) language.

Syllabus

Introduction
  • Turn data into information with queries
  • What you should know
  • Download the sample database
1. Introduction to T-SQL Queries
  • What is Transact SQL?
  • The SQL querying environment
  • Return records with SELECT and FROM
  • Filter records with WHERE
  • Sort records with ORDER BY
  • Column aliases
  • Create values with constants
2. Additional Filter Techniques
  • Limit results with TOP
  • Remove duplicates with DISTINCT
  • Comparison operators
  • Understand NULL values
  • Match text with LIKE and wildcards
3. Retrieve Records from Multiple Tables
  • Table joins and relationships
  • Inner joins
  • Left, right, and full outer joins
  • Cross joins
4. Grouping Records
  • Understand record grouping
  • Use GROUP BY and COUNT
  • Aggregate functions
  • Explore data with SUM
  • Filter groups with HAVING
5. Manipulate Data with Functions
  • Use functions in T-SQL
  • String functions
  • Text concatenation
  • Round with mathematical functions
  • Work with date functions
  • FORMAT date and times
  • Return random records with NEWID
  • The IIF logical function
6. Writing SQL Scripts
  • Change database context with USE
  • Add comments to a script
  • When to use square brackets
7. SQL Subqueries
  • What is a subquery?
  • Use a subquery in a WHERE clause
  • Correlated subqueries
  • PIVOT the result set
8. Work with Variables
  • Create and use variables in a query
  • Create a counter for a looping statement
9. Result Set Operators
  • Combine results with UNION
  • Return distinct rows with EXCEPT
  • Return common rows with INTERSECT
Conclusion
  • Next steps

Taught by

Adam Wilbert

Related Courses

Advanced SQL Retrieval Queries in SQLiteStudio
Coursera Project Network via Coursera
Data Manipulation and Management using MYSQL Workbench
Coursera Project Network via Coursera
SQL Database App with Windows GUI – Project Tutorial
freeCodeCamp
Introduction to SQL Using Google BigQuery
LinkedIn Learning
Learning Microsoft SQL Server 2019
LinkedIn Learning