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

Discover how to query tables in Microsoft SQL Server 2016. Learn how to use SELECT statements, filter, group, and sort results, and more.

Many of the world's most powerful programs and websites use SQL to manage the incredible amount of data they work with on a daily basis. As a result, understanding how to query data from platforms like Microsoft SQL Server 2016 is a highly valuable skill. In this course, Gerry O'Brien reviews the history of SQL and relational theory to help you understand exactly where this data manipulation language and the Microsoft seminal database program got their starts. Next, he shows how to query one or many different tables using SELECT statements, as well as how to filter, group, and sort the results. Then, he demonstrates how to work with special data types like dates, times, and characters. Gerry also covers advanced topics like subqueries, programming with Transact-SQL, and improving query performance.

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

Related Courses

Reviews

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.

Sign up for free