Fundamentals of
SQL^®

About · FAQ · Tell a Friend  · Comments  · Course Home Page  ·  IT Learning Center

About this Course

This course is intended for serious computer hobbyists, IT students, and IT professionals.

The free online textbook for this course is Sams Teach Yourself SQL® in 24 Hours, Third Edition. Read the Introduction.

Indicates links that take you away from the Free-Ed.Net site. Use the links on these offsite pages carefully, and use the Back function on your browser to return to the assigments.

Join a Study Group

Learning experiences are always enhanced and enriched by interacting with others in the same "class." Now you can join a virtual classroom where you can share your experiences, answer questions, and find answers to your own questions.

Go to the SQL study group

Online Study Aids

Common SQL Commands
Glossary

Lesson 3. Managing Database Objects

In this lesson you will learn about:

• An introduction to database objects
• An introduction to the schema
• An introduction to the table
• A discussion of the nature and attributes of tables
• Examples for the creation and manipulation of tables
• A discussion of table storage options
• Concepts on referential integrity and data consistency

Reading Assignments

Read the following sections from your free online textbook:

What Are Database Objects?

What Is a Schema?

A Table: The Primary Storage for Data

Integrity Constraints

 

Learning Activities

1. Use this search box to refine and expand your understanding of new terms and concepts in the reading assignments.

2. Read the Summary   of the lesson.
3. Test you understanding with the Q&A.
4. Visit the online Workshop.

   Return here after completing your Workshop session.

Copyright © 2005 SweetHaven Publishing Services
All Rights Reserved