• Overview
• Outline
• Schedule

About This Course

This two-day instructor-led course provides students with the knowledge and skills to query data using Microsoft SQL Server. The course will introduce the concepts of relation databases and how to retrieve, modify, and use SQL Server data.

Audience Profile

This course is intended for Information Workers who need to use SQL Server data for client applications such as reporting.

Prerequites

Before attending this course, students must have:

• Basic knowledge of Windows operating Systems.
• Understand the concepts of storing data on a network.
• Basic understanding of Microsoft Office Applications.

At Course Completion

After completing this course, students will be able to:

• Understand the purpose and benefit of relational data storage.
• Retrieve data using SELECT statements.
• Summarize data using GROUP BY and aggregate functions.
• Modify data using INSERT, UPDATE, and DELETE statements.
• Incorporate SQL Server data into Microsoft Office 2007 Applications.