Description
This course will provide the student with an overview of database objects, such as tables, indexes, views and triggers. Additionally, the students will be able to query and update tables using SQL statements.
Audience
End Users
Prerequisites
A familiarity with the fundamentals of relational databases, and any programming. language.
Objective
Upon completion of this course, the student will be able to:
- create and maintain tables
- query and update databases using SQL statements
- decide when, where, and how to use SQL statements
Topics Include
Getting Started
- Overview of Relational Databases
- An Introduction to SQL
- Sample Database Design
- Quiz
Making Basic Queries
- Building Queries
- Restricting Query Results
- Manipulating Query Results
- Quiz
Making Complex Queries
- Formatting Query Results
- Querying Multiple Tables
- Making Nested Queries
- Quiz
Manipulating Data
- Adding Data
- Modifying Existing Data
- Deleting Data
- Quiz
Organizing Data
- Creating and Maintaining Tables
- Working with Indexes
- Working with Views
- Quiz
Using Advanced Features
- Working with Cursors
- Using Stored Procedures
- Using Triggers
- Managing Transactions
- Quiz
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
|