Querying Microsoft SQL Server 2012
Overview
Learn how to query data from SQL Server tables.
Learn how to query data from SQL Server tables. Microsoft Certified Trainer Gerry O'Brien reviews the history of SQL and relational theory, so you'll understand exactly where this data manipulation language, and Microsoft's seminal database program, got their starts. Then he shows how to query one or many different tables using SELECT statements, and filter, group, and sort the results. Next, learn how to work with special data types like dates, times, and characters. Gerry also covers advanced topics like subqueries, programming with T-SQL (Microsoft's proprietary extension for SQL), and improving query performance.
Learn how to query data from SQL Server tables. Microsoft Certified Trainer Gerry O'Brien reviews the history of SQL and relational theory, so you'll understand exactly where this data manipulation language, and Microsoft's seminal database program, got their starts. Then he shows how to query one or many different tables using SELECT statements, and filter, group, and sort the results. Next, learn how to work with special data types like dates, times, and characters. Gerry also covers advanced topics like subqueries, programming with T-SQL (Microsoft's proprietary extension for SQL), and improving query performance.
Syllabus
Introduction
- Welcome
- What you should know before viewing this course
- Using the exercise files
- A history of SQL and T-SQL
- An introduction to relational theory
- To use standards or not
- Understand processing stages
- Query a table with SELECT
- Using aliases in your SELECT statement
- Using string concatenation
- Using CASE expressions
- Filter 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
- Implement transactions
- Handling errors
- Introducing query execution plans
- Interpret performance data
- Goodbye
Taught by
Gerry O'Brien
Never Stop Learning!
