Instructor Facilitated On-line
Query Language (SQL) is the industry standard database programming
language. It is used to create databases, manipulate and retrieve data,
and to provide security for
relational databases. Some of the
more popular Database Management Systems (DBMSs) that implement SQL include
Microsoft Access, Microsoft
SQL Server, Oracle and MySQL. If you
work in a field
managing data or you plan to work
in a field managing data, you should make learning SQL a priority.
Introduction to SQL
is a low cost instructor facilitated on-line course that
covers much more than most introductory SQL courses. Learn the key concepts
of SQL and gain a solid working knowledge of this powerful and universal
database programming language. You'll learn the basic structure of relational
databases, how to read and write simple and complex SQL statements, and
advanced data manipulation techniques.
Introduction to SQL is offered at many accredited colleges, universities,
and other accredited educational facilities around the world. Because
it is a non-credit continuing education course, there are no admission
requirements at the colleges or universities.This course is six weeks
long and consists of 12 lessons. Two lessons are released each week. The
lessons are supplemented by interactive quizzes, assignments, and online
discussion areas available via the World Wide Web. Read your lessons and
ask questions of your instructor at the times most convenient to you.
||Register for "Introduction to SQL"
Note: Registration through
all colleges and nniversities is open to anyone. There are no admission
requirements for this course.
here to locate and contact a school offering "Introduction
to SQL" near you.
here to read actual comments submitted by students
when they evaluated this course.
Internet access, e-mail, Netscape or Internet Explorer Web browser. Any
desktop (standalone, not required to run over a network) Database
Management System (DBMS) that supports the execution of Structured Query
Language (SQL). Examples include Microsoft Access, SQL Server 2000 Personal
Edition2, SQL Server 2000 Desktop Engine (MSDE), SQL Server 2000 Evaluation
Edition and Developer Edition, Oracle8i Personal Edition. Or any client/server
(required to run over a network) database management system that is connected
to a server and supports the execution of Structured Query Language. Examples
include MySQL, Sybase, Microsoft SQL Server 6 or 7, SQL Server 2000 Enterprise
Edition and Standard Edition.
Lesson 1 - Database Basics, and Structured
Lesson 2 - Sorting and Retrieving Data
Lesson 3 - Filtering Data
Lesson 4 - Calculated Fields and Functions
Lesson 5 - Summarizing and Grouping Data
Lesson 6 - Working with Subqueries
Lesson 7 - Creating and Using Table Joins
Lesson 8 - Inserting, Updating, and Deleting
Lesson 9 - Table Creation and Maintenance
Lesson 10 - Creating and Understanding Views
Lesson 11 - Understanding Transaction Processing,
Constraints, and Indexes
Lesson 12 - Understanding Stored Procedures,
Triggers, and Cursors
JAFFA INC. Computer Learning Center
2609 Colfax Loop
Holloman, NM 88330
Copyright © 1999 Jaffa Inc.