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:
  • Basic SELECTs
  • Joins
  • Subqueries
  • Table expressions
  • Set operations
  • Pivot/unpivot
  • Data modification
  • Locking and concurrency
  • Etc.
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%
View full outline in PDF formatDetailed Outline Bookmark and Share

print  |  top of page