PHP/SQL 1: Introduction to Database Programming

 

Course Details and Syllabus

 Enroll
Course: PHP/SQL 1: Introduction to Database Programming
Tuition: $338.3
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 MySQL Cookbook, Second Edition as a complimentary reference from O'Reilly.
Certificates: Completion of this course counts toward the Open Source 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
Enroll
Learn and Achieve - Enroll Now

Earn a Certificate

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

Illinois