Explore a comprehensive web development course covering PHP, SQL, and JavaScript. Begin with PHP and SQL installation, then delve into structured query language basics and database design. Progress through dynamic web content creation, PHP fundamentals, arrays, functions, forms, and object-oriented programming. Learn to connect PHP with MySQL using PDO, manage sessions, and build a complete CRUD application. Transition to JavaScript, exploring its object-oriented features and the jQuery library. Examine JSON for data exchange and Handlebars for client-side templating. Conclude with advanced SQL topics and transactions, equipping you with essential skills for modern web application development.
Overview
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
Related Courses
Related articles
Reviews
4.9 rating, based on 8 Class Central reviews
-
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! -
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,…
-
Easy-to-understand explanations, quizzes, and practical exercises create a robust combination for building a solid foundation in web application development.
-
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.
-
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.
-
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!
-
Pacifique NEZERWAThis is the great course for beginning to advanced in Web Development. I liked the course so much...Still learning, still improving.
Thank you! -
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
