Cours MS E2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
Objectif
This 3-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.
This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries.
Pré-requis
Before attending this course, students must have:
- Knowledge of data integrity concepts.
- Core Windows Server skills.
- Relational database design skills.
- Programming skills.
Contenu
- Getting Started with Databases and Transact-SQL in SQL Server 2008
- 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
Langue du cours
FR
Support de cours
Official Microsoft MOC 2778 Coursebook
200.- CHF
Durée
3 jour(s)
Prix
2100.- CHF
