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.
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.
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