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
