User name:
Password:
 

 

Copyright © 2006.
cisco-certificatiom.co.uk
All Rights Reserved
SQL for the Windows Environment Series: Data and Tables
Product Code: sqlw07 Time: 3.0 hour(s) CEUs: Available

Summary:

This course explains how to insert data into existing database tables and then modify or delete that data. It also explains how to create new database tables and modify or delete existing tables.

Objectives:

  • Insert rows of data into a database table
  • Copy data from one table to another
  • Update and delete data from a database table
  • Create database tables
  • Modify and delete database tables


Topics:

  • Inserting Data
  • Inserting Partial Rows and Retrieved Data
  • Copying from One Table to Another
  • Updating Data
  • Deleting Data
  • Guidelines for Updating and Deleting Data
  • Creating Tables
  • Working with NULL and Default Values
  • Modifying Tables

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

Copyright � 2006 Webteks. All rights reserved.