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

Provider Logo

Querying Microsoft SQL Server 2012

via LinkedIn Learning

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.

Syllabus

Introduction
  • Welcome
  • What you should know before viewing this course
  • 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
  • Understand processing stages
2. Query the Database
  • Query a table with SELECT
  • Using aliases in your SELECT statement
  • Using string concatenation
  • Using CASE expressions
3. Filtering Results
  • Filter duplicates with DISTINCT
  • Introducing the WHERE clause
  • WHERE clause relational operators
  • Filtering text
  • Working with NULL
4. Query 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
  • Implement transactions
  • Handling errors
9. Query Performance
  • Introducing query execution plans
  • Interpret performance data
Conclusion
  • Goodbye

Taught by

Gerry O'Brien

Related Courses

Reviews

0.0 rating, based on 0 reviews

Start your review of Querying Microsoft SQL Server 2012

Never stop learning Never Stop Learning!

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

Sign up for free