Training Classes | Learning and Development Resources | Training Directory | New Training Programs | New Training Providers | Site Map | Promote Training | Training Keywords | Training Programs | Training Providers | Regions | Training Search | Advertise Training Programs | Login
Provided by: Serebra Learning Corporation

Basic SQL Programming

Click here for more information or to take this course
Serebra Learning Corporation


  home  : Computer  : Databases and SQL  : SQL

Get More Information
Search for Training
Find Your Genius!
What do you want to learn about?

Training Provided by Serebra Learning Corporation

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.

Training Avaliability and Delivery

This is primarily online training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
Contact Serebra Learning Corporation for more information
Schedule:3 hours
Training Presented in:English

Related Keywords:  sql   basic   sql   programming 

Training Program Details


Course Outline - IP0250 - SQL Server 7.0 - Basic Programming

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


click to enlarge

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

Serebra Learning Corporation, 600 - 1188 West Georgia, Vancouver, BC    V6E 4A2 Canada
Tel: (604) 676-5480 or 1-800-567-7766 - Fax: (604) 676-5490
E-Mail: sales@serebra.com - Web Site: www.serebra.com

About Serebra Learning Corporation - Training Provider

Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1,825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...

More Training from Serebra Learning Corporation

Click here for more information or to take this course

Training Directory | New Training Programs | New Training Providers | Search | Site Map | Promote Training | Login | Links


Connecting people who want to learn with people who love to teach
 Are you a Sql training provider?
You could be on this page today - for FREE!