Purchase this course now
  • Purchasing this course allows you access to view and download the videos
  • More product info
  • Looking for multi-user licensing info?
$99.95
Add to Cart

Currency conversions:

Writing Queries for SQL Server (2005/2008 Edition)

  • ·Skill level: 100-400
  • ·Run Time: 42+ hours (209 videos)
  • ·CourseId: 160


This course is a comprehensive query writing course for Microsoft SQL Server versions 2005, 2008, and 2008 R2. If you struggle with knowing the difference between an INNER and an OUTER JOIN, when to use a LEFT vs. a RIGHT JOIN, and things like the 'how and why' of subqueries then this is an ideal course for you. This is not a beginners course: this course is for someone with at least a basic understanding of the SELECT statement. This course also makes extensive use of LearnItFirst's video exercises which include complete walk-throughs of the solutions (and come with the .sql files containing both the problems and the solutions). NOTE: This course is being released as it is finished. All together it will have seven chapters with the first four chapters being released in February, 2010 and the final four chapters released throughout February, 2010.

Browse this course's videos now
  • Search for videos within this course

This course is featured in the following packages:


Scott Whigham

Scott Whigham is the founder of LearnItFirst.com, one of the web's most extensive video training libraries focusing on technical training. Scott is also an experienced consultant, trainer, and author with more than a decade of hands-on experience working with SQL Server databases, writing and debugging applications using Visual Studio, and performance tuning. Scott designed the architecture (websites, class libraries, and database) for the LearnItFirst.com websites and, most re... (Scott's full bio can be found here)
This course is designed for someone who has at least a basic understanding of SELECT statements and help them transition into an intermediate to intermediate-advanced query artist. Prior working experience with SQL Server 2000, SQL Server 2005, or SQL Server 2008 will help you get the most out of this course.
While a true beginner could take this course, it is actually recommended that you have at least 30 days experience working with the SELECT statement prior to taking this course.
  • Are there any sample videos from this course? Yes! Click here to view this course's free videos
  • Can I get a certificate saying I passed/took the course? Yes. Once you have downloaded all of the videos in the course, send us a request for a certificate through our contact us page. We'll send you a certificate that looks like this sample certificate.
  • What is included with this course? Our training courses come complete with the video files, PDFs of the course presentation (for lecture-based videos), and sample projects and files where appropriate. Most courses are a blend of demo and lecture but, depending on the topic, some courses are lecture-only while others are demo-only. Read more
  • Do you have something I can email to my boss? Yes, many customers ask for PDF copies of the material covered so that they can get reimbursed by their company for the cost of the course. Download a PDF of the videos in this course
  • Will this course help me pass a certification exam? Absolutely. We have a lot of members who have successfully earned Microsoft certifications with the help of our training materials. We do not, however, consider ourselves a "certification training company"; we are a "real world training company" and we think there is an important difference between the two. Read more

Table of Contents

This video training course is separated into chapters. If you'd like to view every video on a single page, you want The Big List.

Chapter 1 - An Introduction and History of the SQL Language

Abstract:

This chapter is an introduction to writing queries in SQL Server.  In this chapter you will learn what the course will cover, and who should take the course.  You will also be introduced to some common SQL and T SQL coding conventions, different operating systems, and using the SQL Server Management Studio.  This chapter will also introduce the exercise videos that you will see throughout the course.


Number of Videos: 22
Total Run Time: 3 hours and 32 minutes

Chapter 2 - Writing Single Table Queries - Building Your Foundation

Abstract:

In this chapter you will begin to build the foundation of query writing by writing single table queries.  Some topics covered in this chapter include database diagrams, the SELECT statement, the WHERE statement, predicates, conditional operators, NULLs, and much more!


Number of Videos: 40
Total Run Time: 7 hours and 7 minutes

Chapter 3 - Using and Understanding Scalar Functions and Data Types

Abstract:

This chapter will introduce you to scalar functions and different data types.  Topics covered in this chapter include an overview of scalar functions, the ISNULL, COALESCE, CAST, and CONVERT functions, working with strings, working with dates, the CASE statement, and much more!


Number of Videos: 27
Total Run Time: 6 hours and 0 minutes

Chapter 4 - Writing JOINs and UNIONs - The Tools of the Trade

Abstract: The topics covered Chapter 4 are extremely important in query writing.  This chapter includes information on UNION queries, EXCEPT and INTERSECT queries, JOINs (INNER, OUTER, RIGHT, and LEFT), syntax, and much, much more!

This is an important chapter so you don''t want to miss it! 

Number of Videos: 46
Total Run Time: 9 hours and 47 minutes

Chapter 5 - Writing Aggregate Queries, GROUP BY, and HAVING Clauses

Abstract:

Chapter 5 will cover writing aggregate queries, which is an important concept for query writers to grasp.  In this chapter Scott will cover the basics of aggregates, how aggregates handle NULLs, COUNTs, GROUP BY, JOIN, HAVING, pivot tables, crosstab queries, subtotals and grand totals with aggregates, and much more!


Number of Videos: 23
Total Run Time: 4 hours and 30 minutes

Chapter 6 - Complex SQL: Subqueries, CTEs, Derived Tables and More

Abstract:

This is last chapter in the course that will introduce new information.  In this chapter Scott will go deeper into more complex query writing.  Some topics covered in this chapter include simple subqueries, correlated subqueries, using EXISTS(), derived tables, common table expressions, and much more!


Number of Videos: 38
Total Run Time: 8 hours and 17 minutes

Chapter 7 - SQL Design Patterns

Abstract:

This chapter does not contain any new information.  All of the design patterns from videos in the first six chapters of this course are in this chapter.


Number of Videos: 13
Total Run Time: 2 hours and 53 minutes

Browse this course's videos now

^ Back to top

© Copyright 2004-2009 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation.