Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Microsoft SQL Server 2016: Query Data

via LinkedIn Learning

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Discover how to query tables in Microsoft SQL Server 2016. Learn how to use SELECT statements, filter, group, and sort results, and more.

Syllabus

Introduction
  • Welcome
  • What you should know
  • Using the exercise files
1. SQL Query Fundamentals
  • A history of SQL and T-SQL
  • An introduction to relational theory
  • To use standards or not
  • Understanding processing stages
2. Query the Database
  • Querying a table with SELECT
  • Using aliases in your SELECT statements
  • Using string concatenation
  • Using CASE expressions
3. Filtering Results
  • Filtering duplicates with DISTINCT
  • Introducing the WHERE clause
  • WHERE clause relational operators
  • Filtering text
  • Working with NULL
4. Querying Multiple Tables
  • Understanding normalization
  • Understanding table relationships
  • Understanding joins
  • Using joins in a query
5. Grouping and Sorting
  • Understanding order
  • Sorting results with ORDER BY
  • Grouping results with GROUP BY
  • Using the TOP option
  • Using aggregates
6. Querying with Data Type Considerations
  • Queries using date and time
  • Queries using character data types
  • Queries using character functions
7. Subqueries and Table Expressions
  • Writing subqueries
  • Using EXISTS
  • Introducing views
  • Introducing common table expressions
8. Programming with T-SQL
  • Understanding stored procedures
  • Understanding T-SQL programming elements
  • Implementing transactions
  • Error handling
9. Query Performance
  • Introducing query execution plans
  • Viewing index usage and statistics
Conclusion
  • Next steps

Taught by

Gerry O'Brien

Reviews

4.7 rating at LinkedIn Learning based on 163 ratings

Start your review of Microsoft SQL Server 2016: Query Data

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.