Microsoft SQL Server 2016: Query Data
Offered By: LinkedIn Learning
Course Description
Overview
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
- A history of SQL and T-SQL
- An introduction to relational theory
- To use standards or not
- Understanding processing stages
- Querying a table with SELECT
- Using aliases in your SELECT statements
- Using string concatenation
- Using CASE expressions
- Filtering duplicates with DISTINCT
- Introducing the WHERE clause
- WHERE clause relational operators
- Filtering text
- Working with NULL
- Understanding normalization
- Understanding table relationships
- Understanding joins
- Using joins in a query
- Understanding order
- Sorting results with ORDER BY
- Grouping results with GROUP BY
- Using the TOP option
- Using aggregates
- Queries using date and time
- Queries using character data types
- Queries using character functions
- Writing subqueries
- Using EXISTS
- Introducing views
- Introducing common table expressions
- Understanding stored procedures
- Understanding T-SQL programming elements
- Implementing transactions
- Error handling
- Introducing query execution plans
- Viewing index usage and statistics
- Next steps
Taught by
Gerry O'Brien
Related Courses
Introduction to DatabasesMeta via Coursera Analyzing Big Data with SQL
Cloudera via Coursera Managing Google Workspace 日本語版
Google Cloud via Coursera Creating Advanced Reports with SAS Visual Analytics
SAS via Coursera Query Client Data with LibreOffice Base
Coursera Project Network via Coursera