SQL Server: Microsoft Transact-SQL for Beginners
| Course Code: | SQSTSQ |
| Duration: | 4 days |
| Level: | Basic to intermediate |
| Currency: | SQL Server 2005, 2008 and 2008 R2 |
| Audience: | Developers: SQL and Transact-SQL, database administrators, analysts and report authors. |
| Prerequisites: | Windows operating system literacy. A working knowledge of data processing terms and concepts useful. |
| Summary: | After detailing the theory behind T-SQL, including ANSI-SQL,
the course emphasises the practical application and use of T-SQL to query and modify data. The workshop incorporates significant learn-by-doing exercises including but not limited to:
|
| Objectives: | Upon completion of this course, the delegate should be able to code T-SQL to retrieve and/or update data stored in SQL Server tables. |
| Format: | Hands-on 70%, lecture 30% |
|
|
|
