SQL Server 7.0 - Basic Programming

Course Code IP0250

Contents

1. Contents
2. Description
3. Audience
4. Prerequisites
5. Objectives
6. Topics Include
7. Duration
8. Minimum Requirements
9. Media

Screenshot

Description

This course introduces the student to the basics of T-SQL.  It also covers the skills required to retrieve and modify data using T-SQL.  The Implementing SQL Server curriculum prepares the student for the Microsoft Exam 70-029.

Audience

This course is intended for technical managers and application developers who implement a database solution with Microsoft SQL Server client/server database management system.

Prerequisites

An understanding of Windows NT 4.0 Server and Windows 95/98.

Objective

Upon completion of this course, the student will be able to:

• retrieve data using the SELECT statement
• retrieve selective data using the WHERE clause
• sort and store the query output using the SELECT statement
• summarize data using the GROUP BY clause
• display detailed and summarized data in a report using the COMPUTE and COMPUTE BY clauses
• add rows using the INSERT statement
• update data using the UPDATE statement
• delete rows using the DELETE statement
• retrieve data from tables using the JOIN statement
• retrieve data using subqueries
• update data through views
• modify views in the database using ALTER VIEW statement
• define the types of cursors
• declare a cursor
• manage data using cursors

Topics Include

Access Data using T SQL

• Retrieve Data
• Summarize Data

Managing Data in T SQL

• Data Manipulation Statements
• Advanced Data Retrieval Techniques

Query Data using Views and Cursors

• Views
• Cursors

Duration

4 hrs

Minimum Requirements

Netscape or Internet Explorer (versions 4.0 or higher). Browsers should be capable of accepting cookies; SVGA Hi-color mode 800x600 resolution display. Macromedia Shockwave 6.02 or higher.

Media

Web Based Training