Querying Microsoft SQL Server 2022
Offered By: LinkedIn Learning
Course Description
Overview
Learn how to retrieve information stored in a Microsoft SQL Server database using the Transact-SQL (T-SQL) language and the latest features of SQL Server 2022.
Syllabus
Introduction
- Turn data into information with queries
- What you should know
- Download the sample database
- 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 and math
- Challenge: Write a SELECT query
- Solution: Write a SELECT query
- Limit results with TOP
- Remove duplicates with DISTINCT
- Comparison operators
- Understand NULL values
- Match text with LIKE and wildcards
- Challenge: Retrieve matching text strings
- Solution: Retrieve matching text strings
- Table joins and relationships
- Inner joins
- Left, right, and full outer joins
- Cross joins
- Challenge: Return data from multiple tables
- Solution: Return data from multiple tables
- Understand record grouping
- Use GROUP BY and COUNT
- Aggregate functions
- Explore data with SUM
- Filter groups with HAVING
- Challenge: Obtain order summaries
- Solution: Obtain order summaries
- Use functions in T-SQL
- String functions
- Text concatenation
- Round with mathematical functions
- Find the GREATEST or LEAST value
- Work with date functions
- FORMAT date and times
- Group dates into buckets
- Return random records with NEWID
- Create a series of values
- The IIF logical function
- Write a CASE statement
- Challenge: Use functions in a SQL query
- Solution: Use functions in a SQL query
- Change database context with USE
- Add comments to a script
- When to use square brackets
- What is a subquery?
- Use a subquery in a HAVING clause
- Correlated subqueries
- PIVOT the result set
- Challenge: Write a query with a subquery
- Solution: Write a query with a subquery
- Create and use variables in a query
- Create a counter for a looping statement
- Challenge: Use variables in a query
- Solution: Use variables in a query
- Combine results with UNION
- Return distinct rows with EXCEPT
- Return common rows with INTERSECT
- Next steps
Taught by
Adam Wilbert
Related Courses
Developing Scalable Apps in PythonGoogle via Udacity Capstone: Retrieving, Processing, and Visualizing Data with Python
University of Michigan via Coursera Teaching Impacts of Technology: Workplace of the Future
University of California, San Diego via Coursera Build Native Mobile Apps with Flutter
Google via Udacity Health Informatics and Technology in Decision Making
Doane University via edX