PHP/SQL 1: Introduction to Database Programming

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.  SQL (Structured Query Language) is the language for databases such as Oracle, MySQL, MS Access, etc.  Knowing SQL is paramount in using these databases.

Upon completion of this course, you will be able to:

  • Create, search, and manage SQL tables and entries.
  • Perform basic SQL queries and joins, and manage the results.
  • Demonstrate understanding of advanced SQL syntax for date, time, math, and string functions.
  • Implement SQL database programming into a PHP-based  web application.
  • Build a full-fledged online address/phone book using PHP and MySQL.

From beginning to end, you will learn by doing SQL-based projects and submitting them for instructor feedback.  These projects, as well as the final project, will add to your portfolio and contribute to certificate completion. Besides a browser and internet connection, all software is provided online by the O’Reilly School of Technology.

This course counts toward the Web Programming Certificate Series, 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.  This course is meant for the beginning or intermediate programmer.

90 Clock-hours, 6 CEUs, $398.00 (plus fees)

Enroll in Course

Course Details and Syllabus

Course: PHP/SQL 1: Introduction to Database Programming
Tuition: $398.00 (plus fees)
Time Frame: This course is online and self-paced. You can expect to work approximately 90 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: 6 Continuing Education Units with official letter from O’Reilly Media.
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 e-book Learning PHP, MySQL, JavaScript, & CSS as a reference resource 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 a Certificate of Professional Development:


PHP/SQL Programming Certificate

Introduction to PHP $398.00 (plus fees)

 

PHP/SQL 1: Introduction to Database Programming $398.00 (plus fees)

 

PHP/SQL 2: Relational Theory and Logical Design $398.00 (plus fees)

 

PHP/SQL 3: Seamless Web 2.0 Integration $398.00 (plus fees)

 
 

$1,592.00 (plus fees)

Enroll in Certificate


Open Source Programming Certificate

Perl 1: Introduction to Perl $448.00 (plus fees)

 

Python 1: Beginning Python $498.00 (plus fees)

 

Linux Systems Administration: The Command Line $398.00 (plus fees)

 

Introduction to PHP $398.00 (plus fees)

 

PHP/SQL 1: Introduction to Database Programming $398.00 (plus fees)

 

$2,140.00 (plus fees)

Enroll in Certificate


Web Programming Certificate

Introduction to HTML and CSS $448.00 (plus fees)

 

Modern JavaScript: An Introduction $448.00 (plus fees)

 

Introduction to XML $398.00 (plus fees)

 

Introduction to PHP $398.00 (plus fees)

 

PHP/SQL 1: Introduction to Database Programming $398.00 (plus fees)

 

Unix for Web Programming $198.00 (plus fees)

 

$2,288.00 (plus fees)

Enroll in Certificate