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).