Transact-SQL Programming: SQL Server 2008

  • ·Skill level: 100-300
  • ·CourseId: 161
  • ·Status: In Development


This course is an online SQL Server programming course for Microsoft SQL Server versions 2008 and 2008 R2. This course features comprehensive coverage of nearly all things SQL programming related including stored procedures, data types, variables, triggers, views, and functions. We also cover hot topics like object-relational modeling (ORM), common database design issues, and working with .NET and the CLR. 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. The first chapters being released in April/May, 2010 and the final chapters released throughout May/June, 2010.

Note: This course is not yet available for purchase (but soon will be). We will announce more details in our newsletter.

To subscribe to our newsletter, create a free account now:


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 SQL and SELECT statements. This course will help you gain a solid understanding of when to use SQL Server Analysis Services as well as a solid foundation on how to get your first cubes and databases created. 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 a solid understanding of the SELECT statement prior to taking this course. If you have taken LearnItFirst's Course 160: 'Writing Queries for SQL Server', you are set!
  • Are there any sample videos from this course? Not for this course but this instructor has several free videos for other courses. Click here to view this instructor'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
  • 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

^ Back to top