Learning Dynamic Website Design - PHP MySQL and JavaScript

Learn Dynamic Web Design with PHP / MySQL, AJAX, JavaScript and CSS. Course comes with Certificate of Completion.
  • Lectures 126
  • Video 13 Hours
  • Skill level all level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

Course Description

A Verifiable Certificate of Completion is presented to all students who undertake this course.

This Dynamic Web Design with PHP and MySQL training course will give you a working understanding of these important technologies and show you how to use them to create your own impressive websites. When used in combination, there simply isn't a better way to construct sites that involve complexity, large volumes of data, and the flexibility to make adjustments and changes over time. This course goes step by step through the basics of each technology, and then gradually shows you how to build the necessary components and underlying framework of your site. It goes through installation of PHP and MySQL technologies on your local machine as well as hosted servers, explains basic tags, commands and constructs, and helps you build and work within a solid back-end database. One you have the basics of PHP and MySQL covered, you'll also learn how to use CSS, JavaScript and AJAX to create the visual style and added functionality your pages deserve.

 

What You Will Learn

- How to build functional, full-featured websites that utilize MySQL, PHP and other current web development technologies.

- How to install, configure and modify functional PHP constructs and MySQL databases for the web.

- How to pair a secure PHP / MySQL backend of a website with a compelling visual interface made with CSS, AJAX, and JavaScript code.

- The basic principles and best practices of PHP and MySQL in a relevant, real world project.

 

Who Should Take This Course

- Individuals and small business owners interested in creating their own fully featured websites with total control over data management, functionality and visual appearance.

- Web developers and programmers looking to learn a new language and set of standards.

- Anyone who has used basic CMS or templates to create basic websites in the past but want much more control.

- Anyone who has tried to learn PHP or MySQL in the past but found it difficult due to a lack of practical examples.

 

What People Are Saying

"Have to say I was nervous at first, but the authors explanations were very well laid out and crystal clear. The site is coming together nicely."

-Ben Jeffries


"A PHP tutorial that is up to date with current standards...very easy to follow."

-Breck Defontes


"I come from a design background but I wanted to beef up my knowledge of basic code. This was a nice and easy primer, thanks."

-Angela Redberg

What am I going to get from this course?

  • Over 126 lectures and 12.5 hours of content!

Curriculum

Section 1: Introduction
Working Files - Download These First
Text
0101 What is PHP
Preview
04:33
What Is MySQL?
02:39
Simple PHP Program
06:27
The Example Web Site - King Real Estate
03:54
Text
Instructions on how to obtain your Certificate of Completion for this Infinite Skills course. All Users of this course are eligible for a Certificate of Completion. Each certificate is issued with a unique number which allows verification that the user has undertaken the course listed. In order to o…
Section 2: Interface
Setting Up Your Computer For PHP And MySQL
04:01
Installing WAMP For Windows
07:03
Installing MAMP For Macintosh - Part 1
03:57
Installing MAMP For Macintosh - Part 2
02:28
Using A Hosting Service
06:38
Section 3: PHP Basics
Using PHP Script Tags
04:01
Displaying HTML To Your Browser Window
07:47
HTML Forms
10:13
Using The SELECT Tag
Preview
06:19
Using The TEXTAREA Tag
06:47
Using The RADIOBUTTON Tag
04:09
Using The CHECKBOX Tag
05:36
Assigning Values To Variables
04:49
Appending Text
04:12
Debugging Techniques - Part 1
07:21
Assignment 1
04:12
Assignment 1 - Solution
05:49
Section 4: PHP Programming Fundamentals
String Delimiters
07:47
Simple Math
05:29
HTML Tables
Preview
07:53
Using IF Statements
04:15
The ELSE Clause
04:44
Nested IFs
05:40
Code Formatting Rules
Preview
05:24
Comparison Operators
08:18
Using AND
04:38
Using OR
04:26
Using NOT
05:39
Field Validations
06:52
Using DIVs
08:31
Using DIVs And Forms
03:17
Debugging Techniques - Part 2
10:00
Assignment 2
04:39
Assignment 2 - Solution
10:16
Section 5: Advanced PHP Constructs
The FOR Loop
07:35
The WHILE Loop
09:02
Reading A File
08:29
Writing To A File
07:44
Displaying A Data From A File Into An HTML Table
Preview
12:55
Debugging Techniques - Part 3
07:58
Assignment 3
05:33
Assignment 3 - Solution
08:56
Section 6: Functions, Arrays, And Strings
Simple Function
02:38
Functions That Receives Data
Preview
03:30
Functions That Returns A Value
02:28
Functions That Receives Data And Returns A Value
06:20
Variable Scope
07:19
Functions That Returns Multiple Values
06:49
Using Include Files
04:16
Array Basics
07:52
Sorting Arrays
06:14
Loading An Array From A File
Preview
02:10
Loading An Array From A Directory
06:19
Recursive Programming
08:57
Finding Text
06:47
Finding Text With Regular Expressions
05:11
Finding Simple Patterns Using Regular Expressions
07:59
Debugging Techniques - Part 4
08:03
Assignment 4
05:40
Assignment 4 - Solution
09:18
Section 7: Introduction To MySQL
Introduction To SQL
09:46
The Example Database
06:50
Interactive MySQL
07:20
Creating Tables
08:19
Simple SELECT Statement
05:38
Comparison Operators
Preview
05:40
Logical Operators
05:56
Selecting Nulls
02:05
Sorting Results
05:46
Aggregate Functions
06:37
Pattern Matching
05:14
Inserting Rows
04:05
Updating Table Data
02:43
Deleting Rows
01:56
SQL Debugging Techniques - Part 5
05:38
Assignment 5
02:54
Assignment 5 - Solution
03:19
Section 8: PHP With MySQL
0801 Connecting To MySQL Within A PHP Program
08:29
0802 Pass Data To A Select
03:26
0803 Adding Rows To A Table
06:43
0804 Deleting Rows From A Table
03:55
0805 Updating Data In A Table
04:27
0806 Populating A Select-Option List
03:09
0807 Login Validation
04:00
Relative Referencing
04:38
Creating Tables With phpMyAdmin
07:07
Inserting Data With phpMyAdmin
07:46
0811 Common Database Functions
06:38
0812 Debugging Techniques - Part 6
07:24
Assignment 6
03:42
Assignment 6 - Solution - Part 1
06:33
Assignment 6 - Solution - Part 2
07:48
Section 9: PHP With Advanced MySQL
Date Functions
04:24
Using Indexes
06:58

Instructor Biography

O'Reilly Media , High Quality Training

O'Reilly spreads the knowledge of innovators through its technology books, online services, magazines, research, and tech conferences. Since 1978, O'Reilly has been a chronicler and catalyst of leading-edge development, homing in on the technology trends that really matter and galvanizing their adoption by amplifying "faint signals" from the alpha geeks who are creating the future. An active participant in the technology community, O'Reilly has a long history of advocacy, meme-making, and evangelism.

Reviews

Average Rating
4.4
Details
  1. 5 Stars
    20
  2. 4 Stars
    5
  3. 3 Stars
    2
  4. 2 Stars
    1
  5. 1 Stars
    1
    • Timothy Moore

    Great instructors, great content!

    The instructors are very experienced and knowledgeable... not like some of the other IT courses on Udemy.

    • Rick Roberts

    Nice Coverage

    Hit a wide array of topics, and provided a great foundation for further advanced development. loved it!

    • Michael Krasilinec

    very impressed

    I have always been interested in dynamic website design but have been hesitant to move forward due to my lack of SQL experience. Though I haven't completed this course yet, I have already learned a lot and definitely have confidence that I will finish this course and be able to implement what I learn at work. This is my first course at udemy, and I very highly recommend this method of learning. It's like having a private tutor that is always accessible!

    • Leonardo Banderali

    Simple but Thorough

    In this course, you won't learn to make a pretty website but you will learn all the fundamental principles of dynamic web design. The videos are a bit dull but they cover everything you need to know to get started with php, mySQL, and AJAX.

    • Arturo Gomez

    Muy bueno por ahora... ;) Perfect!

    Enseña rapido y muy bien... como a mi me gusta. No hace videos largos explicando nada! Voy por la unidad 30 and it is perfect! :D

Show more reviews

What you get with this course

30 day money back guarantee

Lifetime access

Available on desktop, iOS and Android

Certificate of completion

Join the biggest student community

5,400,000

Hours of video content

21,000,000

Course enrollment

6,300,000

Students

Ready to start learning?
Preview this course