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
Beg/Int SpreadsheetCabrillo College via California Community Colleges System Analyzing Big Data with SQL
Cloudera via Coursera Excel Basics
Codecademy SQL Fundamentals for Data Analysts
Corporate Finance Institute via Coursera Create Customer Support Data with Microsoft Excel
Coursera Project Network via Coursera