70-433 SQL Server Administration

Page 1 of 6First   Previous   [1]  2  3  4  5  6  Next   Last   


Video #1 - Intro to 70-433 SQL Server 2008 R2 Database Development

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.  

  View Video...


Video #2 - SQL Server 2008 Query Fundamentals- Part I

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.  

  View Video...


Video #3  - SQL Server 2008 R2 Query Fundamentals Part II

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.  

  View Video...


Video #4 - SQL Server 2008 Query Fundamentals Part III

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.  

  View Video...


Video #5 - SQL Server 2008 Query Fundamentals Part IV

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.  

  View Video...


Copyright 2007-2013 by dotnetvideos.net   |  Privacy Statement  |  Terms of Use