Introduction to SQL
& Intermediate SQL:
Instructor Facilitated On-line Courses




Structured 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 is open to anyone. There are no admission requirements for this course.

Locate and Contact a school offering "Introduction to SQL" near you.


Read Actual Comments submitted by students when they evaluated this course.


Register for "Intermediate SQL"
Register for "SQL Series"


Course Requirements
: 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.


Course Syllabus
:


Lesson 1 - Database Basics, and Structured Query Language
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 Data
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

Course Instructor: Dr. Cecelia L. Allison wrote and facilitates Introduction to SQL. She is an experienced software tester and technical specialist with many years of hands-on experience using and teaching SQL. Dr. Allison is the author of SQL Simplified: Learn to Read and Write Structured Query Language and SQL for Microsoft Access. She also teaches on-line technical courses for Park University. Dr. Allison holds a Bachelor of Science in finance, a Master of Science in information systems, and a Doctor of Business Administration in management information systems.

Register for Intermediate SQL

Top