Web Applications for Everybody

via (2)

  • Provider
  • Cost
  • Session
  • Language

Overview

Learn to build database-backed web sites using PHP, MySQL, JQuery, and Handlebars.

Syllabus

1: Installing PHP and SQL

The first task is to work through the installation steps including installing a text editor, install ...

2: Introduction to Structured Query Language (SQL)

We learn about single table queries and the basic syntax of the SQL language.

3: Database Design

Covering database design with multiple tables, foreign keys, and the JOIN operation..

4: Introduction to Dynamic Web Content

We look at the basic structure of a web application and how a web browser interacts with a web serve ...

5: Introduction to PHP

We begin learning PHP.

6: Overview of PHP Language

We begin the syntax of the PHP language, control structures, and expressions.

7: PHP Arrays

We look at arrays and superglobals like $_GET in PHP language.

8: PHP Functions

We look at functions in PHP language.

9: PHP Forms

We look at how HTML forms are created and processed in the PHP language.

10: PHP Objects

We look at the object oriented pattern in the PHP language.

11: PHP and MySQL

We look at how we connect to a MySQL using the Portable Data Objects (PDO) library and issue SQL com ...

12: PHP Sessions

We look at how PHP uses cookies and manages session data. We also look at how we properly handle PO ...

13: Building a CRUD Application

Now we buid our first 'complete' application that has multiple screens to Create, Read, Update and D ...

14: Basic JavaScript

We talk a quick look at the JavaScript language. We assume that you already know PHP - so it is a p ...

15: JavaScript Objects

We do a quick look at how the JavaScript language supports the Object-Oriented pattern.

16: JQuery

This is a brief introduction to the JQuery library which is widely used to do in-browser manipulatio ...

17: JSON - JavaScipt Object Notation

In this section we look at JavaScript Object Notation (JSON). JSON is commonly used as a syntax to ...

18: Handlebars UI Templates

In this section we look at moving the templates to build HTML fragments from the server (PHP) in to ...

19: Advanced SQL

This section covers some advanced SQL topics.

20: SQL Transactions

This section covers SQL transactions.