 | » | |
|
| | | |
| » | |
| » | |
| » | |
| » | |
|
| |
|
| » | |
| » | |
| » | |
| » | |
|
| |
|
| » | |
|
| |
|
| » | |
| » | |
|
| |
|
| » | |
| » | |
| » | |
|
| |
|
| » | |
|
| |
|
|
|
|
|
|
| | |
|
| |
code:
|
title:
|
price:
|
duration:
|
|---|
HG794S
[MOC 2778]
|
Writing queries using Microsoft SQL Server 2008 Transact-SQL (MOC 2778)
|
SGD$ 1800
| 3 days
|
| |
|
|
|
| |
|
|  |
| Elements of this syllabus are subject to change. | |
|
|
|
|
| |
| | |
|
| This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries
| |
|
|
|
|
| |
|
| Before attending this course, students must have:
| • | Physical database design
|
| • | How data is stored in tables (rows and columns)
|
| • | Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, and many-to-many)
|
| • | Basic knowledge of the Microsoft Windows operating system and its core functionality. For example, how to use Windows Explorer, open and save files, and what a client/server application interaction means
|
It is recommended that students attend:
| • | Maintaining a Microsoft SQL Server 2008 Database (MOC 6231) HG792S
|
and
| • | Implementing a Microsoft SQL Server 2008 Database (MOC 6232) HG793S
|
prior to attending this course.
|
|
|
| |
|
|
| After completing this course, students will be able to: |
| • | Group and summarize data by using Transact-SQL |
| • | Write queries that retrieve and modify data by using subqueries |
| • | Query text fields with full-text search |
| • | Use various techniques when working with complex queries |
| |
| • | Describe the uses of and ways to execute the Transact-SQL language |
| • | Write SELECT queries to retrieve data |
| • | Join data from multiple tables |
| • | Describe how to create programming objects |
|
|
|
|
| |
|
|
| • | Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services (MOC6324) HG797S
|
and/or
| • | Implementing and Maintaining Microsoft SQL Server 2008 Integration Services (MOC 6235) HG795S
|
and/or
| • | Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services (MOC 6236) HG796S
|
|
|
|
|
|
There is currently no schedule information available for this course.
Please contact hp education services on 65 6824 3770 or click here if you would like us to contact you with the next availability. |
|
|
Printable version
