- View Offline
- 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
- [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.