Online Course: T-SQL Querying Fundamentals
This course is no longer taking registrations
10 Sessions brought to you by SSWUG.ORG
Course Overview
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/Cost
Once registered, you'll have instant access to all 10 sessions for a full 30 days. Watch as often as you like, re-watch sessions, download supporting materials, ask questions of the instructor... you'll have full access during the course!
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, and the ability to email questions to the instructor are included with course purchase only. If you are unable to view all the sessions in the alotted time, we can offer you a 30 day course extension for only $79.00.
Once you have completed the course, you will have the opportunity to take a quiz and receive a course certificate. After passing the quiz, please allow five business days to receive the certificate via e-mail download link.
Event Registration
Confirm Conference Registration Selection
Please Confirm Your Information
|
*
|
*
|
*
*
|
|
*
|
|
*
|
|
*
|
*
|
*
|
|
*
|
*
|
|
|
*
|
*
Note: no dashes or spaces
|
*
We'll email a copy of the receipt to this address.
|
Card Security Code:
*
What's This?
|
Expiration Date:
|
|
|
