- Overview
- Transcript
- View Offline
Author
Gerry O'Brien
Released
3/31/2014- Writing SELECT queries
- Querying multiple tables
- Filtering text and duplicates
- Sorting and grouping query results
- Using SQL Server's built-in functions
- Writing subqueries
- Using common table expressions
- Programming with T-SQL
- Interpreting query performance data
Skill Level Beginner
Duration
Views
-
-
- [Voiceover] Hi, I'm Gerry O'Brien, and welcome to Querying SQL Server 2012. In this course, I'm going to introduce you to using SQL Server's data manipulation language statements focused on querying data from tables. We'll begin by looking at a history of SQL Server and relational theory to form a foundation of your SQL knowledge. Next, we'll focus on the core concepts of selecting data from single and multiple tables with a select statement and using available filters to fine tune your queries.
We'll then see examples of grouping and sorting your results, as well as working with different data types such as date and time, and then we'll focus on built-in functions for manipulating those data types. We'll follow up with some more advanced topics on writing subqueries and common table expressions, and then finish up with a look at Transact-SQL programming constructs and performance analyses of the queries that we write. So let's get started Querying SQL Server.
-
-
-
-
-
-
-
-
-
-
-
-
Introduction
-
Welcome1m 3s
-
-
1. SQL Query Fundamentals
-
A history of SQL and T-SQL3m 13s
-
To use standards or not2m 49s
-
Understand processing stages7m 38s
-
-
2. Query the Database
-
Query a table with SELECT12m 59s
-
Using string concatenation8m 59s
-
Using CASE expressions5m 33s
-
-
3. Filtering Results
-
Introducing the WHERE clause10m 2s
-
Filtering text9m 44s
-
Working with NULL8m 49s
-
4. Query Multiple Tables
-
Understanding normalization10m 1s
-
Understanding JOINs6m 2s
-
Using JOINs in a query9m 37s
-
-
5. Grouping and Sorting
-
Understanding order5m 14s
-
Sorting results with ORDER BY10m 49s
-
Using the TOP option10m 47s
-
Using aggregates9m 47s
-
-
6. Querying with Data-Type Considerations
-
Queries using date and time15m 48s
-
-
7. Subqueries and Table Expressions
-
Writing subqueries9m 58s
-
Using EXISTS6m 10s
-
Introducing views13m 28s
-
-
8. Programming with T-SQL
-
Understanding stored procedures14m 35s
-
Implement transactions7m 16s
-
Handling errors15m 19s
-
-
9. Query Performance
-
Interpret performance data13m 34s
-
Conclusion
-
Goodbye34s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Welcome