HTTP/2 302 server: nginx date: Sat, 02 Aug 2025 22:58:08 GMT content-type: text/plain; charset=utf-8 content-length: 0 x-archive-redirect-reason: found capture at 20100115041340 location: https://web.archive.org/web/20100115041340/https://www.oreillyschool.com/courses/phpsql1/ server-timing: captures_list;dur=0.714105, exclusion.robots;dur=0.025857, exclusion.robots.policy;dur=0.012305, esindex;dur=0.012927, cdx.remote;dur=38.701542, LoadShardBlock;dur=257.575186, PetaboxLoader3.datanode;dur=59.094615, PetaboxLoader3.resolve;dur=117.663981 x-app-server: wwwb-app214 x-ts: 302 x-tr: 333 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: Sat, 02 Aug 2025 22:58:09 GMT content-type: text/html; charset=UTF-8 x-archive-orig-date: Fri, 15 Jan 2010 04:13:39 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: Fri, 15 Jan 2010 04:13:40 GMT link: ; rel="original", ; rel="timemap"; type="application/link-format", ; rel="timegate", ; rel="first memento"; datetime="Wed, 28 Mar 2007 14:37:26 GMT", ; rel="prev memento"; datetime="Fri, 25 Dec 2009 01:36:26 GMT", ; rel="memento"; datetime="Fri, 15 Jan 2010 04:13:40 GMT", ; rel="next memento"; datetime="Mon, 25 Jan 2010 01:25:37 GMT", ; rel="last memento"; datetime="Wed, 12 Jun 2024 16:41:41 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_13_20100115034129_crawl102_IndexOnly-c/51_13_20100115041300_crawl102.arc.gz server-timing: captures_list;dur=1.418492, exclusion.robots;dur=0.028549, exclusion.robots.policy;dur=0.010936, esindex;dur=0.014575, cdx.remote;dur=8.784691, LoadShardBlock;dur=321.234215, PetaboxLoader3.datanode;dur=100.393059, PetaboxLoader3.resolve;dur=401.532060, load_resource;dur=195.477227 x-app-server: wwwb-app214 x-ts: 200 x-tr: 658 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
• Your Career Education
• Why O'Reilly
• Certificate Programs
• Online Courses
• Enroll

• Online Courses
• For Managers
• Enroll Today

$100 for Every Referral!

Translate your enthusiasm for OST into cash or tuition credit, through the new OST Referral Program.

Learn More

Save 40% on Certificate Series!

Until 1/31, OST is offering an incredible 40% discount when you enroll in all courses within ANY Certificate series. Take advantage of this rare discount today! Not valid with any other offer.

> Read more

PHP/SQL 1: Introduction to Database Programming

 

Learn PHP and SQL Programming, for the Beginning or Intermediate Student

SQL(Structured Query Language) is the language for databases such as Oracle, MySQL, MS Access, etc. Knowing SQL is paramount to using these databases. In this course, you will learn basic SQL database creation and manipulation, as well as how to search databases and how to incorporate them into PHP-based programs and applications.

Upon completion of the course, you 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 PHP/SQL Programming Certificate series.

From beginning to end, you will learn by doing their own SQL-based projects using PHP, and then handing them in for instructor feedback. These projects, as well as the final project, will add to your 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 ebooks & 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.

 

PHP/SQL 1: Introduction to Database Programming	398.00
Course Details and Syllabus
Course Details and Syllabus Course: PHP/SQL 1: Introduction to 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 ebook MySQL Cookbook, Second Edition as a complimentary reference from O'Reilly. Certificates: Completion of this course counts toward the Open Source Programming Certificate Series and the PHP/SQL Programming Certificate Series. Prerequisites: Introduction to HTML and CSS and Introduction to PHP, or equivalent skills in HTML and PHP. This course is meant for the beginning or intermediate programmer. Topics: Creating Databases and Tables, Inserting Information, Retrieving Information, Searching, Summarizing, Application Development using PHP, etc. Syllabus: SQL Lab 1 -- Introduction How to Learn using Useractive Courses Understanding the Learning Sandbox MySQL Syntax Databases and Permissions The Command Line SQL Lab 2 -- Creating Tables Creating and Checking Tables Inserting Values into Tables Retrieving Data from Tables SQL Lab 3 -- Searching Through Tables Exploring the "where" Keyword The "like" Selector Updating and Deleting Data SQL Lab 4 -- Managing Tables Altering Tables Renaming Tables Deleting Tables SQL Lab 5 -- Managing Table Entries Optimizing with Indexes and Keys Auto_increment and Primary Keys SQL Lab 6 -- Relational Databases What is a Relational Database? Inner Joins Outer Joins Aliases SQL Lab 7 -- Managing Query Results Group By Preventing Duplicate Results Searching and Counting Within Groups Renaming Results Ordering Results Limiting Results SQL Lab 8 -- Database Programming with PHP The PHP/MySQL Relationship Connecting to a Database in PHP Executing SQL Commands Delimiting Queries SQL Lab 9 -- Project Address/Phone Book, Part 1 Project Description Table Layout Table Creation SQL Lab 10 -- Project Address/Phone Book, Part 2 Starting with the HTML Form Storing the Data into SQL through PHP Breaking Down addentry.php SQL Lab 11 -- Project Address/Phone Book, Part 3 Construction of viewbook.php SQL Lab 12 -- Advanced SQL Syntax, Part 1 Date and Time Functions SQL Lab 13 -- Advanced SQL Syntax, Part 2 Math Functions SQL Lab 14 -- Advanced SQL Syntax, Part 3 String and Character Functions SQL Lab 15 -- FINAL PROJECT

 

On your way to Certification:

 

New OST Courses!

Perl 1: Beginning Perl	398.00 199.00
Python 1: Beginning Python	398.00 199.00

 

Database Administration Certificate Series

DBA 1: Introduction to Database Administration	398.00
DBA 2: Administering MySQL	398.00
DBA 3: Creating a Data Warehouse	448.00
DBA 4: Analyzing Data	448.00

 

Enroll in all four Database Administration courses and get a 40% discount! (-$677)Expires 01/31/10

 

Java Programming Certificate Series

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

 

Enroll in all four Java Programming courses and get a 40% discount! (-$717)Expires 01/31/10

 

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 a 40% discount! (-$637)Expires 01/31/10

 

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 a 40% discount! (-$438)Expires 01/31/10

 

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 a 40% discount! (-$637)Expires 01/31/10

 

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 a 40% discount! (-$875)Expires 01/31/10

 

.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 a 40% discount! (-$518)Expires 01/31/10

 

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 a 40% discount! (-$796)Expires 01/31/10

 

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

 

Georgia M. wants to talk to you!

"Wow, Georgia, I wish that everyone could be as friendly and efficient as you!"
-- Amanda S.

Call 800-998-9938 x.7187
M-F between 9am and 6pm PST

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.