Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Life Purpose Meditation Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Development Web Development Web Design

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.
Rating: 4.0 out of 54.0 (511 ratings)
48,599 students
Created by Infinite Skills
Last updated 1/2017
English
English
30-Day Money-Back Guarantee

Course content

11 sections • 125 lectures • 12h 26m total length

  • Working Files - Download These First
    00:01
  • Preview04:33
  • What Is MySQL?
    02:39
  • Simple PHP Program
    06:27
  • The Example Web Site - King Real Estate
    03:54

  • 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

  • Using PHP Script Tags
    04:01
  • Displaying HTML To Your Browser Window
    07:47
  • HTML Forms
    10:13
  • Preview06: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

  • String Delimiters
    07:47
  • Simple Math
    05:29
  • Preview07:53
  • Using IF Statements
    04:15
  • The ELSE Clause
    04:44
  • Nested IFs
    05:40
  • Preview05: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

  • The FOR Loop
    07:35
  • The WHILE Loop
    09:02
  • Reading A File
    08:29
  • Writing To A File
    07:44
  • Preview12:55
  • Debugging Techniques - Part 3
    07:58
  • Assignment 3
    05:33
  • Assignment 3 - Solution
    08:56

  • Simple Function
    02:38
  • Preview03: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
  • Preview02: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

  • Introduction To SQL
    09:46
  • The Example Database
    06:50
  • Interactive MySQL
    07:20
  • Creating Tables
    08:19
  • Simple SELECT Statement
    05:38
  • Preview05: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

  • 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

  • Date Functions
    04:24
  • Using Indexes
    06:58
  • Grouping Data
    06:59
  • HAVING Clause
    04:45
  • Preview06:45
  • Joining Tables - Part 2
    07:27
  • Joining Tables - Part 3
    04:05
  • Subqueries - Part 1
    08:15
  • Subqueries - Part 2
    05:24
  • Assignment 7
    02:07
  • Assignment 7 - Solution
    04:15

  • Basic JavaScript Syntax
    09:43
  • Validating A Form Field With JavaScript
    08:13
  • Positioning A DIV With JavaScript
    07:49
  • 1004 Parsing Multiple Values With Java Script
    05:35
  • Preview09:14
  • Using Ajax To Update A Form In Place
    04:57
  • Using Ajax To Show SQL Results In Place
    06:44
  • Using Ajax To Update The Database
    05:32
  • Debugging Techniques - Part 8
    09:31
  • Assignment 8
    05:18
  • Assignment 8 - Solution - Part 1
    07:40
  • Assignment 8 - Solution - Part 2
    07:16
  • Assignment 8 - Solution - Part 3
    05:44

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

Instructor

Infinite Skills
High Quality Training
Infinite Skills
  • 4.3 Instructor Rating
  • 117,331 Reviews
  • 1,231,095 Students
  • 327 Courses

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.