Learning TSQL

The question of learning T-SQL comes up all the time with ConfigMgr/SMS/MOM/OpsMgr Admins, here are some resources to help you out.

 

Part of this are taken for a previous article I wrote on the subject and it still applies, today.

http://www.myitforum.com/articles/18/view.asp?id=5694

 

Here are two free website to help you learn TSQL.

http://sqlcourse.com/

http://sqlcourse2.com/

 

These two web sites are really two articles or two complete interactive Online SQL training sessions. When I first saw these, I liked their setup.

 

The first site starts off with the basics. From a SMS perspective, here are some of the topics covered:

 

·         Table Basic

·         Selecting Data

·         Deleting Record

·         Deleting Tables

 

 

The second course is an advance course; it covers:

 

·         Selecting Data

·         Function (Min, Max, Count, etc.)

·         Group by

·         Having

·         Order By

·         Where

·         Between

·         Mathematical Operators ( =, >, <, etc)

·         Joins

·         Other Database Site Links

 

 

I have also been using the MS e-learning myself for my 70-649 exam prep, there have a collection of 9 course that you might find interesting, “Writing Queries Using Microsoft® SQL Server™ 2005 Transact-SQL”  all of them for less than $300, you can’t go wrong with that!

 

Course 4326: Getting Started with Databases and Transact-SQL in Microsoft® SQL Server™ 2005

Course 4327: Performing Basic Queries in Microsoft® SQL Server™ 2005

Course 4328: Grouping and Summarizing Data in Microsoft® SQL Server™ 2005

Course 4329: Joining Data from Multiple Tables in Microsoft® SQL Server™ 2005

Course 4330: Working with Subqueries in Microsoft® SQL Server™ 2005

Course 4331: Modifying Data in Microsoft® SQL Server™ 2005

Course 4332: Querying Metadata, XML, and Full-Text Indexes in Microsoft® SQL Server™ 2005

Course 4333: Using Programming Objects for Data Retrieval in Microsoft® SQL Server™ 2005

Course 4334: Using Advanced Querying Techniques in Microsoft® SQL Server™ 2005

 

 

So the next time your boss ask you for a report, ask them to shell out the $300 and some time for you to learn T-SQL, both of you will be happy that you did. Plus if you play your cards right you can also use these course to help you pass an exam such as the 70-431 “Microsoft SQL Server 2005 – Implementation and Maintenance” this exam is useful to all System Center Admins!

Leave a Reply

Your email address will not be published. Required fields are marked *