Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Independent

Web Applications for Everybody

via Independent

Overview

This course covers the fundamentals of web applications, including installing PHP and SQL, learning SQL syntax, database design, dynamic web content, PHP basics, arrays, functions, forms, objects, connecting PHP to MySQL, sessions, building a CRUD application, basic JavaScript, JavaScript objects, JQuery, JSON, Handlebars UI templates, advanced SQL, and SQL transactions. The course aims to teach students how to create interactive web applications using PHP, SQL, and JavaScript, targeting individuals interested in web development and programming.

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.

Taught by

Charles Severance from University of Michigan

Reviews

4.9 rating, based on 8 Class Central reviews

Start your review of Web Applications for Everybody

  • Anonymous
    Easy-to-understand explanations, quizzes, and practical exercises create a robust combination for building a solid foundation in web application development.
  • Anonymous
    Love it. The course guides you step by step through the basis of web development. Each section includes an assignment which uses tools that have been studied up to that point. Dr chuck is one of the best teacher I've even had. He explain the code,…
  • Anonymous
    Great explanation, easy to follow! It also helps to repeat Python language and simultaneously prepping to the Javascript language.

    Many thanks to Dr. Chuck for making courses available for everyone!
  • Anonymous
    I just completed this course and it's outstanding! It strikes just the right balance between manageable and challenging (and there are stretch goals if you want to take it to the next level). Assignments are well thought out so that you progress systematically from beginner topics to pretty sophisticated coding. Taught by the great Dr. Chuck, this course has empowered me to continue on my coding journey.
  • Anonymous
    I have been working on a couple of Dr. Chuck's courses, on Python and web applications (PHP, SQL). I had only a few tidbits of knowledge, but a lot of curiosity, when I came across Professor Severance's courses in the 4everybody series, on Coursera via UMichigan. His video walk-throughs are excellent: He has a clear knack for understanding the most confusing parts. I do wish the images with text would magnify the areas of text being discussed, but that's more of a device thing, perhaps. Anyway, thank you for contributing such a treasure trove of guided knowledge! I'm a fan.
  • Anonymous
    Great course! Great introduction to web applications development. Dr. Chuck not only teaches the basic content of the subject, but also shares some of his practical knowledge developing web applications at production level. Again, this is a great course completely recommended!
  • Profile image for Pacifique NEZERWA
    Pacifique NEZERWA
    This is the great course for beginning to advanced in Web Development. I liked the course so much...Still learning, still improving.

    Thank you!
  • Anonymous
    In from Mexico im a junior developer and this course is really helpufull thanks Mr chuck to all explications, i keep it going wth css to go to the next level

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.