MS SQL Server 2008: Writing Queries Using Transact-SQL

Formation MS SQL Server - MS SQL Server 2008: Writing Queries Using Transact-SQL in Geneva, Zurich, Huston, San-Antonio, Dallas, Los Angeles, San Diego, New York, Washington, Chicago, San Francisco and anywhere in Switzerland, USA, Great Britain and Germany.

1500.-/d

ID : 727

Goal : This provides the technical skills required to write basic Transact-SQL queries for MS SQL Server 2008.

Audience : This training is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries.

Prerequisites : Before attending this training, students must have knowledge of data integrity concepts, core Windows Server, relational database design and programming skills.

Goals :

- Introduction

- Getting Started with Databases and Transact-SQL

- Using SQL Server Management Studio and SQLCMD

- Querying and Filtering Data

- Grouping and Summarizing Data

- Joining Data from Multiple Tables

- Working with Subqueries

- Modifying Data in Tables

- Querying Metadata, XML, and Full-Text Indexes

- Using Programming Objects for Data Retrieval

- Using Advanced Querying Techniques

- Training Conclusion

Pedagogical method : This training is based on official MS examples and slides.

Suggested duration for presentiel training (days) : 3

Suggested duration for on-line training (days) : 3.6

Daily price in face-to-face : 1500 CHF

Daily price in remote : 720 CHF

Daily price in remote for students : contact us (only if student card!)

Daily price in remote (with recording) : 7500 CHF

Prices are per day per trainee without course material, without certificate, without evaluation, without exam, without training room or computer (these are each optional and must be requested in addition in the contact form for the establishment of the quote).

Tags : transact sql training, transact sql course, sql training, sql course, ms sql server, transact-sql, xml.

Contents