Introduction to Microsoft T-SQL
Live Instructor-Led Classroom Training
Writing SQL Queries

In this 3-day workshop you will understand how to write SQL Server 2005 queries efficiently and accurately. You will learn how to write queries using 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 to build database objects. This class includes many hands-on exercises to internalize the concepts.

SQL Server 2005 includes a rich set of tools that go beyond the basics of querying and manipulating data. The final two modules are important for developers to go beyond simply writing queries as they will require stored procedures at some point.

Who Should Attend

The workshop material is aimed for those who require a knowledge in writing queries against an SQL Server relational database.

Workshop Objectives
  • Understand basic database design principles and how to implement them in SQL Server.
  • How to create complex inner and outer joins, summary queries, and subqueries that do more of the database processing for you so that your applications can do less?
  • What the different data types are and how to handle the common problems you run into with various types of data?
  • How to take advantage of powerful backend database features like views, scripts, stored procedures, and triggers?
  • Understand the differences between view, stored procedures, triggers, and user-defined functions.Utilize SQL Server transactions to insure data integrity.
  • The basics of database design and implementation using SQL DDL statements or the new Management Studio.

Request Comprehensive Course Outline

About Us

A leader in live technical training since 1978

For many years New Instruction, LLC had been known as an innovative provider of training, consulting and software development services, and clients have often asked us to share our software quality methodologies with them. Those requests led to the development of our longest running workshop, "Testing and Quality Assurance Techniques", now in it's 11th edition.
Read more

Certifications

New Instruction is an SBA certified Woman-owned small business

New Instruction is an SBA certified Woman-owned small business

New Instruction is an IIBA endorsed education provider

Drop Us a Line

615 Valley Road
Montclair, NJ 07043

(973) 746-7010