2778A - Writing Queries using Microsoft SQL Server 2008 Transact-SQL

AUD$ 2,400
*
*
Academy IT strive to provide you with the training you need when you need it most. If you require a course and can’t attend on the dates provided or if they are not suitable to your staffing or project timelines – please call PH: (08) 7324 9800 to negotiate an alternative booking time.

About this course

This 3-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.

Audience

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

At Course Completion

After completing this course, students will be able to:

  • Describe the uses of and ways to execute the Transact-SQL language.
  • Use querying tool.
  • Write SELECT queries to retrieve data.
  • Group and summarize data by using Transact-SQL.
  • Join data from multiple tables.
  • Write queries that retrieve and modify data by using sub queries.
  • Modify data in tables.
  • Query text fields with full-text search.
  • Describe how to create programming objects.
  • Use various techniques when working with complex queries.

Pre-requisites

Before attending this course, students must satisfy the following pre-requisites:

  • Knowledge of data integrity concepts.
  • Core Windows Server skills.
  • Relational database design skills.
  • Programming skills

To view the course outline please ensure you have Adobe Reader installed.

Get Adobe Reader

Download 2778A - Writing Queries using Microsoft SQL Server 2008 Transact-SQL (PDF)

Location:

Related Courses
Course Name
Price
< 
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
> 
6231B - Maintaining a Microsoft SQL Server 2008 R2 Database
AUD$ 4,000
 
 
11 -15
 
5 -9
 
9 -13
 
18 -22
 
 
 
 
6232B - Implementing a Microsoft SQL Server 2008 R2 Database
AUD$ 4,000
 
 
 
15 -19
 
19 -23
 
7 -11
 
 
 
 
 
6234A - Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
AUD$ 2,400
 
 
 
29 -31
 
26 -28
 
14 -16
 
 
 
 
 
6235A - Implementing and Maintaining Microsoft SQL Server
AUD$ 2,400
 
 
18 -20
 
21 -23
 
18 -20
 
13 -15
 
 
 
 
6236A - Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services
AUD$ 2,400
 
30
 
22 -24
 
19 -21
 
28 -30
 
 
 
 
 
| Powered by nopCommerce