HTTP/2 302 server: nginx date: Sun, 03 Aug 2025 14:38:38 GMT content-type: text/plain; charset=utf-8 content-length: 0 x-archive-redirect-reason: found capture at 20090418195327 location: https://web.archive.org/web/20090418195327/https://www.oreillyschool.com/courses/sql/ server-timing: captures_list;dur=0.595829, exclusion.robots;dur=0.021752, exclusion.robots.policy;dur=0.010535, esindex;dur=0.015300, cdx.remote;dur=56.936588, LoadShardBlock;dur=138.557043, PetaboxLoader3.datanode;dur=76.193230 x-app-server: wwwb-app214 x-ts: 302 x-tr: 217 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 set-cookie: wb-p-SERVER=wwwb-app214; path=/ x-location: All x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() HTTP/2 200 server: nginx date: Sun, 03 Aug 2025 14:38:39 GMT content-type: text/html; charset=UTF-8 x-archive-orig-date: Sat, 18 Apr 2009 19:53:25 GMT x-archive-orig-server: Apache/2.0.59 (CentOS) x-archive-orig-x-powered-by: PHP/5.1.6 x-archive-orig-connection: close x-archive-guessed-content-type: text/html x-archive-guessed-charset: windows-1252 memento-datetime: Sat, 18 Apr 2009 19:53:27 GMT link: ; rel="original", ; rel="timemap"; type="application/link-format", ; rel="timegate", ; rel="first memento"; datetime="Mon, 26 Mar 2007 17:03:09 GMT", ; rel="prev memento"; datetime="Thu, 26 Mar 2009 09:09:44 GMT", ; rel="memento"; datetime="Sat, 18 Apr 2009 19:53:27 GMT", ; rel="next memento"; datetime="Sat, 25 Apr 2009 18:14:04 GMT", ; rel="last memento"; datetime="Fri, 20 Oct 2023 12:46:24 GMT" content-security-policy: default-src 'self' 'unsafe-eval' 'unsafe-inline' data: blob: archive.org web.archive.org web-static.archive.org wayback-api.archive.org athena.archive.org analytics.archive.org pragma.archivelab.org wwwb-events.archive.org x-archive-src: 51_9_20090418195221_crawl101-c/51_9_20090418195300_crawl102.arc.gz server-timing: captures_list;dur=0.825929, exclusion.robots;dur=0.017609, exclusion.robots.policy;dur=0.008592, esindex;dur=0.010673, cdx.remote;dur=43.286545, LoadShardBlock;dur=603.464294, PetaboxLoader3.resolve;dur=564.849803, PetaboxLoader3.datanode;dur=216.684507, load_resource;dur=245.588411 x-app-server: wwwb-app214 x-ts: 200 x-tr: 1046 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 x-location: All x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() content-encoding: gzip

• Sign In
• FAQs
• Search
• Contact

• Home
• Career Training
  • Ask Trish
  • Job Market Snapshot
  • How to Choose the Right School
  • For Managers
• Why O'Reilly
  • Our Methods
  • What Our Students Say
  • University of Illinois Affiliation
  • For Managers
• Certificate Programs
  • Database Administration
  • Java Programming
  • Client-Side Programming
  • Linux/Unix Administration
  • PHP/SQL Programming
  • Web Programming
  • Open Source Programming
  • .NET Programming
  • Upcoming Courses
  • Enroll Today
• Online Courses
  • For the Complete I.T. Beginner +
    • Introduction to HTML and CSS
    • Introduction to Object-Oriented Programming
    • Linux/Unix Sysadmin I: The Basics of System Administration
    • Learn C Programming, Part 1
  • For the Beginner/Intermediate +
    • Java Programming 1: Intro to Java and the Eclipse Development Environment
    • Introduction to PHP
    • JavaScript 1: Client-Side Programming
    • Learn Perl for CGI Programming
    • PHP/SQL 1: Introduction to Database Programming
    • Learn SQL for Database Programming
    • DBA 1: Introduction to Database Administration
    • Learn C Programming, Part 2
    • Learn VBScript
    • Learn Unix for Web Programming
    • Linux/Unix Sysadmin II: Netowrking and DNS
    • Learn XML
    • Java Programming 2: The Java Programming Language
    • DBA 2: Administering MySQL
  • For the Intermediate/Advanced +
    • JavaScipt 2: AJAX
    • Linux/Unix Sysadmin III: Unix Services (including email and web servers)
    • Linux/Unix Sysadmin IV: Script for Administrators, Sed, Awk, and Perl
    • PHP/SQL 2: Relational Theory and Logical Design
    • Learn Visual Basic .NET
    • Learn C# .NET
    • Java Programming 3: Java Programming Foundations
    • PHP/SQL 3: Seamless Web 2.0 Integration
    • DBA 3: Creating a Data Warehouse
    • Java Programming 4: Java Application Building
    • DBA 4: Analyzing Data
  • For Managers
  • Enroll Today
• Enroll

• Online Courses
• For Managers
• Enroll Today

Get a Free Course!

Enroll in all courses within ANY Certificate series, and get a free course. Not valid with any other promotion.

"Ultimately, what I realized is that in losing my job, the O'Reilly certificates have become even more valuable to me than when I was just trying to enhance my skills." — Michael Jarosik

Learn SQL for Database Programming

 

Perl Programming and SQL Database Training for Beginners or Intermediate Students

In this course, students will learn basic database creation and manipulation, as well as how to search databases and how to incorporate them into Perl-based programs and applications.

Upon completion of the course, students will earn 4 CEUs (Continuing Education Units) and a CEU letter from the University of Illinois Office of Continuing Education. This course counts toward both the Open Source Programming Certificate series and the Web Programming Certificate series.

From beginning to end, participants will learn by doing their own SQL-based projects using Perl. These projects, as well as the final project, will add to the student's portfolio and will contribute to certificate completion. Besides a browser and internet connection, all software is provided online by the O'Reilly School of Technology.

 

Free books & software included. Click for info on Lab Fees

Our unique learning methods allow you to have 24-hour access to your lab account, including all coursework, files, development tools, online portfolio, and your Instructor's feedback, for as long as you need. This way, your courses are completely self-paced for your busy schedule. You can freeze and unfreeze your lab account when necessary, and you can even keep the account when you've finished your courses -- to have a portfolio for your resume, to keep practicing your skills, or to create prototypes on a safe system.

Base lab fee is a flat $9.95/month, no matter how many courses you are in.

 

Learn SQL for Database Programming	398.00
Course Details and Syllabus
Course Details and Syllabus Course: Learn SQL for Database Programming Tuition: $398 Time Frame: Due to our monthly lab fee system, this course is completely self-paced. You can expect to work approximately 40 hours on this course. Technical Requirements: As long as you have a web browser and internet connection, you can take this course from anywhere in the world. CEUs: 4 Continuing Education Units with official letter from the University of Illinois Office of Continuing Education. Software: The web-based Learning Sandbox® provided for you will contain all your lessons, projects, quizzes, account files, editors, and programming tools necessary to build your skills from beginning to end, even beyond coursework. In addition, you'll be provided with a mySQL account that can be accessed through the Sandbox or, if you prefer, any normal SSH program. No other software is needed. Instructor: You will have one instructor throughout the course who will evaluate your projects and quizzes, hand them back for improvement when necessary, and coach you throughout your skills advancement. Book: All required course materials and software are included online within the Learning Sandbox®. However, within a few weeks of enrolling, you'll receive the free book SQL in a Nutshell, Second Edition as a complimentary reference from O'Reilly. Certificates: Completion of this course counts toward both the Web Programming Certificate Series and the Open Source Programming Certificate Series. Prerequisites: Introduction to HTML and CSS and Learn Perl for CGI Programming, or equivalent skills in HTML and Perl. This course is meant for the beginning or intermediate programmer. Topics: Creating Databases and Tables, Inserting Information, Retrieving Information, PERL DBI, Searching, Application Development, etc. Syllabus: SQL Lab 1 -- Introduction Brief Introduction to SQL SQL Lab 2 -- A Quick Overview of MySQL Getting Familiar with MySQL Environment Alternative Method of Logging In MySQL Syntax SQL Lab 3 -- Creating a Database Structure of SQL Creating Databases and Tables Checking Tables Inserting Values into Tables Retrieving Data from Tables SQL Lab 4 -- Searching Through Tables Further Study on Insert Exploring the Select Keyword SQL Lab 5 -- More SQL Syntax Dealing with Time and Date Date Manipulation SQL Lab 6 -- Managing Tables Deleting Tables Altering Tables Renaming Tables Deleting Table Entries SQL Lab 7 -- Getting Familiar with DBI What is DBI? Exploring DBI Changing single quotes to \' SQL Lab 8 -- Project Address/Phone Book, Part 1 Project Description Database Layout Setting Up Database: SQL Lab 9 -- Project Address/Phone Book, Part 2 Starting with the HTML Form Storing the Data into SQL through PERL/DBI Breaking Down addentry.cgi SQL Lab 10 -- Project Address/Phone Book, Part 3 Construction of viewbook.cgi SQL Lab 11 -- Advanced SQL Syntax, Part 1 Date and Time Functions SQL Lab 12 -- Advanced SQL Syntax, Part 2 Math Functions SQL Lab 13 -- Advanced SQL Syntax, Part 3 String and Character Functions SQL Lab 14 -- Relational Databasing Quick Overview of Relational Databasing Setup for Relational Databasing Inner Joins Aliases Natural Join Left Outer Join/Right Outer Join SQL Lab 15 -- Refining SQL Syntax Preparation Group By Order By General SQL Syntax

 

On your way to Certification:

 

Database Administration Certificate Series

DBA 1: Introduction to Database Administration	398.00
DBA 2: Administering MySQL	398.00
DBA 3: Creating a Data Warehouse Estimated Release: 04/30/2009	448.00
DBA 4: Analyzing Data Estimated Release: 04/30/2009	448.00

 

Enroll in all four Database Administration courses, and get DBA 4, FREE! (-$448)Expires 04/30/09

 

Java Programming Certificate Series

Java Programming 1: Introduction to Java and the Eclipse Development Environment	448.00
Java Programming 2: The Java Programming Language	448.00
Java Programming 3: Java Programming Foundations	448.00
Java Programming 4: Java Application Building	448.00

 

Enroll in all four Java Programming courses, and get Java Programming 4, FREE! (-$448)Expires 04/30/09

 

System Administration Certificate

Linux/Unix 1: The Unix file system	398.00
Linux/Unix 2: Networking and DNS	398.00
Linux/Unix 3: Unix Services	398.00
Linux/Unix 4: Scripting for Administrators Sed, Awk, and Perl	398.00

 

Enroll in all four System Administration courses, and get Linux/Unix 4, FREE! (-$398)Expires 04/30/09

 

Client-Side Web Programming Certificate

Introduction to HTML and CSS	298.00
JavaScript 1: Introduction to JavaScript	398.00
JavaScript 2: AJAX	398.00

 

Enroll in all three Client Side Programming courses, and get HTML and CSS, FREE! (-$298)Expires 04/30/09

 

PHP/SQL Programming Certificate

Introduction to PHP	398.00
PHP/SQL 1: Introduction to Database Programming	398.00
PHP/SQL 2: Relational Theory and Logical Design	398.00
PHP/SQL 3: Seamless Web 2.0 Integration	398.00

 

Enroll in all four PHP/SQL Programming courses, and get PHP/SQL 3, FREE! (-$398)Expires 04/30/09

 

Web Programming Certificate

Learn Perl for CGI Programming	398.00
Unix for Web Programming	298.00
Learn SQL for Database Programming	398.00
Introduction to HTML and CSS	298.00
JavaScript 1: Introduction to JavaScript	398.00
Introduction to XML	398.00

 

Enroll in all six Web Programming courses, and get Learn SQL, FREE! (-$398)Expires 04/30/09

 

.NET Certificate

Introduction to XML	398.00
Introduction to Object-Oriented Programming	398.00
Learn C#.NET	498.00

 

Enroll in all three .NET Programming courses, and get Learn XML, FREE! (-$398)Expires 04/30/09

 

Open Source Programming Certificate

Learn Perl for CGI Programming	398.00
Linux/Unix 1: The Unix file system	398.00
Introduction to Object-Oriented Programming	398.00
PHP/SQL 1: Introduction to Database Programming	398.00
Introduction to PHP	398.00

 

Enroll in all five Open Source Programming courses, and get Object-Oriented Programming, FREE! (-$398)Expires 04/30/09

 

Other Courses

Learn C Programming, Part 1	298.00
Learn C Programming, Part 2	298.00
Learn VBScript	298.00
Visual Basic .NET	498.00

 

Earn a Certificate

for Professional Development from the University of Illinois' Office of Continuing Education upon completion of a selected series of courses.

© 2009, O'Reilly Media, Inc. All rights reserved.