You can learn anything on Udemy. Start today with one of our 10,000+ online courses

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.
26 reviews
WHAT'S INSIDE
  • Lifetime access to 126 lectures
  • 12+ hours of high quality content
  • Closed captioning enabled
  • A community of 30800+ students learning together!
  • 180+ discussions
TAUGHT BY
  • Infinite Skills High Quality Training

    InfiniteSkills is a Canadian based company that offers an ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples. The emphasis is on teaching real life skills that are essential in today's commercial environment. All InfiniteSkills courses are taught by experts who have a true passion for teaching.

SHARE

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.
26 reviews
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

    • Over 126 lectures and 12.5 hours of content!

CURRICULUM

  • SECTION 1:
    Introduction
  • 1
    Working Files - Download These First
    Text
  • 2
    0101 What is PHP
    04:33
  • 3
    What Is MySQL?
    02:39
  • 4
    Simple PHP Program
    06:27
  • 5
    The Example Web Site - King Real Estate
    03:54
  • 6
    How to obtain your Certificate of Completion for this Infinite Skills course.
    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
  • 7
    Setting Up Your Computer For PHP And MySQL
    04:01
  • 8
    Installing WAMP For Windows
    07:03
  • 9
    Installing MAMP For Macintosh - Part 1
    03:57
  • 10
    Installing MAMP For Macintosh - Part 2
    02:28
  • 11
    Using A Hosting Service
    06:38
  • SECTION 3:
    PHP Basics
  • 12
    Using PHP Script Tags
    04:01
  • 13
    Displaying HTML To Your Browser Window
    07:47
  • 14
    HTML Forms
    10:13
  • 15
    Using The SELECT Tag
    06:19
  • 16
    Using The TEXTAREA Tag
    06:47
  • 17
    Using The RADIOBUTTON Tag
    04:09
  • 18
    Using The CHECKBOX Tag
    05:36
  • 19
    Assigning Values To Variables
    04:49
  • 20
    Appending Text
    04:12
  • 21
    Debugging Techniques - Part 1
    07:21
  • 22
    Assignment 1
    04:12
  • 23
    Assignment 1 - Solution
    05:49
  • SECTION 4:
    PHP Programming Fundamentals
  • 24
    String Delimiters
    07:47
  • 25
    Simple Math
    05:29
  • 26
    HTML Tables
    07:53
  • 27
    Using IF Statements
    04:15
  • 28
    The ELSE Clause
    04:44
  • 29
    Nested IFs
    05:40
  • 30
    Code Formatting Rules
    05:24
  • 31
    Comparison Operators
    08:18
  • 32
    Using AND
    04:38
  • 33
    Using OR
    04:26
  • 34
    Using NOT
    05:39
  • 35
    Field Validations
    06:52
  • 36
    Using DIVs
    08:31
  • 37
    Using DIVs And Forms
    03:17
  • 38
    Debugging Techniques - Part 2
    10:00
  • 39
    Assignment 2
    04:39
  • 40
    Assignment 2 - Solution
    10:16
  • SECTION 5:
    Advanced PHP Constructs
  • 41
    The FOR Loop
    07:35
  • 42
    The WHILE Loop
    09:02
  • 43
    Reading A File
    08:29
  • 44
    Writing To A File
    07:44
  • 45
    Displaying A Data From A File Into An HTML Table
    12:55
  • 46
    Debugging Techniques - Part 3
    07:58
  • 47
    Assignment 3
    05:33
  • 48
    Assignment 3 - Solution
    08:56
  • SECTION 6:
    Functions, Arrays, And Strings
  • 49
    Simple Function
    02:38
  • 50
    Functions That Receives Data
    03:30
  • 51
    Functions That Returns A Value
    02:28
  • 52
    Functions That Receives Data And Returns A Value
    06:20
  • 53
    Variable Scope
    07:19
  • 54
    Functions That Returns Multiple Values
    06:49
  • 55
    Using Include Files
    04:16
  • 56
    Array Basics
    07:52
  • 57
    Sorting Arrays
    06:14
  • 58
    Loading An Array From A File
    02:10
  • 59
    Loading An Array From A Directory
    06:19
  • 60
    Recursive Programming
    08:57
  • 61
    Finding Text
    06:47
  • 62
    Finding Text With Regular Expressions
    05:11
  • 63
    Finding Simple Patterns Using Regular Expressions
    07:59
  • 64
    Debugging Techniques - Part 4
    08:03
  • 65
    Assignment 4
    05:40
  • 66
    Assignment 4 - Solution
    09:18
  • SECTION 7:
    Introduction To MySQL
  • 67
    Introduction To SQL
    09:46
  • 68
    The Example Database
    06:50
  • 69
    Interactive MySQL
    07:20
  • 70
    Creating Tables
    08:19
  • 71
    Simple SELECT Statement
    05:38
  • 72
    Comparison Operators
    05:40
  • 73
    Logical Operators
    05:56
  • 74
    Selecting Nulls
    02:05
  • 75
    Sorting Results
    05:46
  • 76
    Aggregate Functions
    06:37
  • 77
    Pattern Matching
    05:14
  • 78
    Inserting Rows
    04:05
  • 79
    Updating Table Data
    02:43
  • 80
    Deleting Rows
    01:56
  • 81
    SQL Debugging Techniques - Part 5
    05:38
  • 82
    Assignment 5
    02:54
  • 83
    Assignment 5 - Solution
    03:19
  • SECTION 8:
    PHP With MySQL
  • 84
    0801 Connecting To MySQL Within A PHP Program
    08:29
  • 85
    0802 Pass Data To A Select
    03:26
  • 86
    0803 Adding Rows To A Table
    06:43
  • 87
    0804 Deleting Rows From A Table
    03:55
  • 88
    0805 Updating Data In A Table
    04:27
  • 89
    0806 Populating A Select-Option List
    03:09
  • 90
    0807 Login Validation
    04:00
  • 91
    Relative Referencing
    04:38
  • 92
    Creating Tables With phpMyAdmin
    07:07
  • 93
    Inserting Data With phpMyAdmin
    07:46
  • 94
    0811 Common Database Functions
    06:38
  • 95
    0812 Debugging Techniques - Part 6
    07:24
  • 96
    Assignment 6
    03:42
  • 97
    Assignment 6 - Solution - Part 1
    06:33
  • 98
    Assignment 6 - Solution - Part 2
    07:48
  • SECTION 9:
    PHP With Advanced MySQL
  • 99
    Date Functions
    04:24
  • 100
    Using Indexes
    06:58

RATING

  • 18
  • 4
  • 2
  • 1
  • 1
AVERAGE RATING
NUMBER OF RATINGS
26

REVIEWS

  • 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

  • Gergely Szabó
    These are lesson for newcomers - the title is confusing

    You can learn the basics (php, mysql), not the "dynamic website design"

  • Ela Danieli
    Very good!

    Easy to follow, covers everything I need right from the very begining.

  • 30 day money back guarantee!
  • Lifetime Access. No Limits!
  • Mobile Accessibility
  • Certificate of Completion
STUDENTS WHO VIEWED THIS COURSE ALSO VIEWED: