Course Overview

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

Course Circullum

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

Adam Wilbert

out of 5.0

5 Star 85%

4 Star 75%

3 Star 53%

1 Star 20%

Item Reviews - 3

Submit Reviews

5 stars 4 stars 3 stars 2 stars 1 star

Name

Review

Free Trial Available

Enroll Now

This Course Include: