From the course: Querying Microsoft SQL Server 2012

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Welcome

Welcome - SQL Server Tutorial

From the course: Querying Microsoft SQL Server 2012

Start my 1-month free trial

Welcome

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

Contents