OUR VISION

To be the premier Information and Communications Technology (ICT) training and consulting services provider in the caribbean.

OUR MISSION

To improve the quality of knowledge and skills base of ICT professionals within the caribbean through the provision of competitive world-class ICT training and consulting services on current and emerging platforms.

MS 2778: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL

Duration: 4 Days, Instructor-Led

In this course, you’ll start by learning about the basic features that are available in SQL Server, including how to design and create a database and how to build 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 how programmers can now use .NET languages like C# and Visual Basic to build database objects. You’ll also learn about enhancements made to SQL Server 2005 for handling complex data structures, using partitioning, and working with XML.

Prerequisites
This course assumes that students have working experience with SQL Server 2000 or 2005; basic relational database concepts (e.g., tables, queries, and indexing); general knowledge of XML, Transact-SQL, and a fundamental understanding of networking and security concepts.

Course Objectives
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.
  • Discover partitioning with SQL Server.
  • Examine new RANKing functions, Common Table Expressions, and learn techniques for dealing with complex queries.
  • Explore advanced techniques for working with complex data.
  • Discover new XML capabilities in SQL Server 2005.

Course Outline

  • A Tour of SQL Server 2005

  • Designing and Creating a Database
  • Data Selection Queries
  • Modifying Data
  • Working with SQL Server Management Studio
  • Transact-SQL Programming
  • Transactions and Error Handling
  • Creating Views
  • Creating Stored Procedures and Triggers
  • Creating User-Defined Functions
  • Using .NET Code in SQL Server 2005
  • Advanced Query Techniques
  • Implementing SQL Server Partitions
  • Complex Querying
  • Advanced Techniques
  • Working with XML

Print this page Print this page