PHP/SQL 1: Introduction to Database Programming

For a limited time, save 25% on this course

* This offer expires June 15, 2015 at 11:59pm PT and cannot be combined with any other discounts.

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 Back-End Web Development Certificate SeriesOpen 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

 $398.00   $298.50 (plus fees)

Enroll in Course

Course Details and Syllabus

Course: PHP/SQL 1: Introduction to Database Programming
Tuition:  $398.00   $298.50 (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.
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 Back-End Web Development Certificate SeriesOpen 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:
  • PHP/SQL 1: Lesson 1 — Introduction
    • How to Learn using Useractive Courses
    • Understanding the Learning Sandbox
    • MySQL Syntax
    • Databases and Permissions
    • The Command Line
  • PHP/SQL 1:  Lesson 2 — Creating Tables
    • Creating and Checking Tables
    • Inserting Values into Tables
    • Retrieving Data from Tables
  • PHP/SQL 1: Lesson 3 — Searching Through Tables
    • Exploring the “where” Keyword
    • The “like” Selector
    • Updating and Deleting Data
  • PHP/SQL 1: Lesson 4 — Managing Tables
    • Altering Tables
    • Renaming Tables
    • Deleting Tables
  • PHP/SQL 1: Lesson 5 — Managing Table Entries
    • Optimizing with Indexes and Keys
    • Auto_increment and Primary Keys
  • PHP/SQL 1: Lesson 6 — Relational Databases
    • What is a Relational Database?
    • Inner Joins
    • Outer Joins
    • Aliases
  • PHP/SQL 1: Lesson 7 — Managing Query Results
    • Group By
    • Preventing Duplicate Results
    • Searching and Counting Within Groups
    • Renaming Results
    • Ordering Results
    • Limiting Results
  • PHP/SQL 1: Lesson 8 — Database Programming with PHP
    • The PHP/MySQL Relationship
    • Connecting to a Database in PHP
    • Executing SQL Commands
    • Delimiting Queries
  • PHP/SQL 1: Lesson 9 — Project Address/Phone Book, Part 1
    • Project Description
    • Table Layout
    • Table Creation
  • PHP/SQL 1: Lesson 10 — Project Address/Phone Book, Part 2
    • Starting with the HTML Form
    • Storing the Data into SQL through PHP
    • Breaking Down addentry.php
  • PHP/SQL 1: Lesson 11 — Project Address/Phone Book, Part 3
    • Construction of viewbook.php
  • PHP/SQL 1: Lesson 12 — Advanced SQL Syntax, Part 1
    • Date and Time Functions
  • PHP/SQL 1: Lesson 13 — Advanced SQL Syntax, Part 2
    • Math Functions
  • PHP/SQL 1: Lesson 14 — Advanced SQL Syntax, Part 3
    • String and Character Functions
  • PHP/SQL 1: Lesson 15 — FINAL PROJECT

On your way to a Certificate of Professional Development:


Back-End Web Development Certificate

Introduction to PHP $398.00   $298.50 (plus fees)

 

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

 

Introduction to Web Application Security

 $398.00   $298.50 (plus fees)

 

 $1,194.00   $895.50 (plus fees)

Enroll in Certificate


PHP/SQL Programming Certificate

Introduction to PHP  $398.00   $298.50 (plus fees)

 

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

 

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

 

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

 

 $1,592.00   $1,194.00 (plus fees)

Enroll in Certificate


Open Source Programming Certificate

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

 

Python 1: Beginning Python  $548.00   $411.00 (plus fees)

 

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

 

Introduction to PHP  $398.00   $298.50 (plus fees)

 

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

 

 $2,190.00   $1,642.50 (plus fees)

Enroll in Certificate