Understanding T-SQL using SQL Server Class

Post on October 5th, 2009

I created a class focusing on T-SQL class called Understanding T-SQL using Microsoft SQL Server at LVSOnline.com. This class is for web administrators, web developers, analysts, or anybody else wanting to learn how to write simple to complex queries to retrieve and manipulate data from a SQL Server database.

SQL stands for Structured Query Language. SQL is a standard language that was designed to query and manage data in relational database management systems (RDBMS). An RDBMS is a database management system that is used today in every type of desktop or web-based application. Microsoft provides T-SQL (Transact SQL) as a dialect of, or extension to, SQL in Microsoft SQL Server, its RDBMS

Microsoft SQL Server is one of the most popular RDBMS used today and a solid understanding of T-SQL is critical if you want to have a successful career in Microsoft application development (desktop or web).

The class is only $30 and there are no other materials or software needed to purchase.

Topics covered:

Week 1: Setting up SQL Server 2008 Express & Management Studio
Week 2: SELECT statements; Predicates and Operators, Case Expressions
Week 3: Joins: Cross, Outer and Inner
Week 4: Subqueries
Week 5: Data Modification: Inserting, Updating, Deleting and Merging
Week 6: Programmable Objects: Variables, Routines and Functions

To give you an idea of how each lesson looks, here is the first lesson (.pdf).

When Does Class Start?

The class runs five times a year for six weeks in January, March, May, August and October. To learn more view the course description page and contact me to find out the exact date on when you can register

1 Comment
  1. Patti permalink

    Hi,

    I’m a web designer who wanted to learn more about working with a database using Microsoft SQL Server. I noticed a lot of job classifieds that I would like to apply for are mentioning SQL Server knowledge. I took this course at lvsonline.com. The course taught me a lot in a short amount of time. From setting things up so I can view a database and work with it to complex retrieving of information from the database.

    I recommend this course to those wanting to learn about how a database works and the power behind it. Frank is a good teacher. He is always available to walk you through any bumps you might have when trying to do the lesson assignments.

    Patti B
    Web Designer

Leave a Reply

Note: XHTML is allowed. Your email address will never be published.