Site Navigation:

Writing Queries Using Microsoft SQL Server 2005 T-SQL

View Chapters

Register For Class:

Please choose from the available dates...

... or customizable onsite training.

Price: $1495

Description:

In this course, you’ll learn how to build basic queries using Transact-SQL, the language of SQL Server. Then, you'll learn how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL. You'll learn about the new enhancements to the Transact-SQL programming language including improved support for error handling and hierarchical queries, and programmers can now use .NET languages like C# and Visual Basic to build database objects.

In this course, you will…

  • Understand basic database design principles and how to implement them in SQL Server.
  • Learn the fundamentals of writing Transact-SQL queries that retrieve or modify data.
  • Understand the differences between view, stored procedures, triggers, and user-defined functions.
  • Use the new Common Table Expressions for creating hierarchical queries.
  • Perform calculations with Visual Basic and Visual C# code rather than T-SQL.

    Prerequisites:

    This course is designed for database developers and SQL Server administrators who need to understand Transact-SQL. To get the most out of this course, you should have a solid understanding of relational databases. No particular programming experience is required, but the course is taught from a developer's perspective.

    • The DSW Group

    Consultants, Trainers and Content Producers. Learn more about us.

    Available Technologies

    Explore other training options...