Introduction to SQL

Introduction to SQL:
Instructor Facilitated On-line Course

	Home		Online Continuing Education Courses
	SQL Simplified: Book		Top News Stories and Research Links
	SQL for Microsoft Access: Book

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.

Click here to register for "Introduction to SQL" through Boise State University ($89).

Note: Registration through Boise State University is open to anyone. There are no admission requirements for this course.
Contact Information: Boise State University

Click here to locate and contact a school offering "Introduction to SQL" near you.

Click here to read actual comments submitted by students when they evaluated this course.

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: Cecelia L. Allison wrote, developed, and facilitates Introduction to SQL. She is an experienced software tester and technical support specialist with many years of hands-on experience using and teaching SQL. She is also a freelance Webmaster and the author of the book entitled, SQL Simplified: Learn to Read and Write Structured Query Language. She also writes books for Wordware Publishing and teaches on-line technical courses for ITT Technical Institute and Park University. Mrs. Allison holds a Bachelor of Science in Finance and a Master of Science in Computer Information Systems.

Top