In this video we will introduce our video series, and discuss prerequisites and general setup information to kick off the series. We will also discuss the content topics to be covered on the exam and in the video series.  

In this video we will introduce querying SQL Server 2008 R2 Data. Much of the exam content is focused on various querying techniques, and you should become familiar with the concepts and techniques involved in querying data. This video will begin by introducing the SELECT statement and associated operators and clauses.  

In this video we will continue working with various SQL querying fundamentals that you must understand for the exam. We will introduce the JOIN operator, discuss INNER, OUTER, and CROSS JOINs. You should be able to query and work with multiple tables effectively after this video.  

In this video we will continue working with various SQL querying fundamentals that you must understand for the exam. We will introduce the UNION operator as well as the EXCEPT and INTERSECT commands.  

In this video we will introduce working with Aggregate functions which allow you to apply calculations on a column. You should have firm understanding of the variety of built in functions available for the exam. We will also introduce the GROUP BY clause to define subtotals for the aggregate data.