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 - SQL Server Tutorial
From the course: Querying Microsoft SQL Server 2012
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.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.