Course Length: 10 Online, On-Demand Sessions
On-Demand Dates: Opens December 4th, 2012 and Closes After January 2nd, 2013
In a partnership agreement with SolidQ, SSWUG.ORG's virtual class will provide you with the skills to work with SQL Server and write queries using Transact-SQL (T-SQL) — SQL Server’s dialect of the standard SQL language.
Itzik Ben-Gan, who is a SQL Server MVP and the acclaimed author of several books on T-SQL querying and programming, will help students understand the logic behind T-SQL and thinking in terms of sets. He will also explain how to write T-SQL code to create tables and define data integrity, as well as how to write queries against single and multiple tables, and how to write T-SQL statements that modify data.
The T-SQL Querying Fundamentals course is not version specific; it does, however, cover language elements that were introduced in recent versions of SQL Server such as SQL Server 2012 and SQL Server 2008. Throughout the course, Itzik will specify the version in which the elements were introduced.
The course is not merely a step-by-step course. It doesn’t just focus on syntactical elements of T-SQL, but rather, explains the logic behind the language and its elements.
Target Audiences and Prerequisites
This course is intended for SQL Server developers, database administrators, BI professionals, architects, report writers, analysts and power users who need to write or review code in SQL Server 2005, 2008, 2012 and SQL Azure.
If you are self-taught, and gained your knowledge “by the seat of your pants,” this course can fill the gaps in your knowledge and teach you how to think correctly in SQL terms. However, the course is intended for people who just started working with SQL Server, as well as those with some experience.
If you are a very experienced T-SQL practitioner and are looking for an Advanced T-SQL course that dives deeply into the complexities of T-SQL Querying and Programming including coverage of query and index tuning, please see the course "Advanced T-SQL Querying Programming and Tuning for SQL Server" by SolidQ.
Course Structure and Costs
Upon registration and payment, you will receive an email with instructions on how to test your system in order to view the sessions, as well as a link that will remain active for the 30 day on-demand period.
The course cost is $169 for full SSWUG.ORG members and $199 for non-members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads, office hours and the ability to email questions to the instructor are included with course purchase only.
Once you have completed the course, you will have the opportunity to take a course quiz and receive a course certificate. After passing the quiz, please allow up to five business days after the course is finalized to receive your certificate (Download link via e-mail).