Total Time: 2 hour(s)

Summary: 
This course shows users how to create and maintain tables in SQL. Users will learn basic concepts and terms related to database and table design, and will become familiar with the various SQL statements used to format tables and manipulate table data.

Ojectives: 
After completing this course, students will be able to:
Describe how data is stored in a relational database
Explain the concepts of primary and foreign keys, and parent/dependent relationships
Create a new table in a database
Use the INSERT statement to add data to a table
Manage and delete SQL tables and table data

Topics: 
SQL Overview
Designing Tables
Creating Tables
Inserting Rows
Updating and Deleting Row

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.