Beginning T-SQL Querying with Microsoft SQL Server 2005/2008

The following is a list of available Beginning T-SQL Querying with Microsoft SQL Server 2005/2008 classes at ISInc. If you do not see the course you are interested in, please contact us. We can setup dedicated, online and onsite classes too!


The selected course is not currently active. Please contact an ISInc representative if you are interested in more information about this course.

Course Number: ISI-1236

This course introduces the T-SQL language & its many uses

Description

If you are familiar with relational database concepts but are new to Microsoft SQL Server or the T-SQL language, this course will teach you the basics from the ground up. If you?re familiar with earlier versions of SQL Server, it will get you up-to-speed on the newest features. And if you know SQL Server 2005, you?ll learn about some exciting new capabilities in SQL Server 2008. This course will help you build a solid foundation of understanding, beginning with core relational database concepts and continuing to reinforce those concepts with real-world T-SQL query applications.
Information Technology professionals in many different roles use T-SQL. Our goal is to provide a guide and a reference for IT pros across the spectrum of operational database solution design, database application development, and reporting and business intelligence solutions.
Database solution designers will find this course to be a thorough introduction and comprehensive reference for all aspects of database modeling, design, object management, query design, and advanced query concepts.
Application developers who write code to manage and consume SQL Server data will benefit from the thorough coverage of basic data management and simple and advanced query design. Several examples of ready-to-use code are provided to get you started and to continue to support applications with embedded T-SQL queries.
Report designers will build on a thorough introduction to basic query concepts and learn to write efficient queries to support business reports and advanced analytics.
Finally, database administrators who are new to SQL Server will find this course to be an all-inclusive introduction and reference of mainstream topics. This can assist you as you support the efforts of other team members.

Prerequisites

Before attending this course, students must have:
Experience using a Microsoft Windows operating system
An understanding of basic relational database concepts

This SQL class for people with some querying experience who want to expand their knowledge of the SQL language. This course provides an explanation of the underlying performance or engine specifics. Students with no experience and who will not be doing anything beyond light querying should consider Course No. SQL, SQL Fundamentals of Querying.

List Price

$1595.00