PHP & MySQL - Learn The Easy Way. Master PHP & MySQL Quickly
4.3 (96 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
5,561 students enrolled
Wishlisted Wishlist

Please confirm that you want to add PHP & MySQL - Learn The Easy Way. Master PHP & MySQL Quickly to your Wishlist.

Add to Wishlist

PHP & MySQL - Learn The Easy Way. Master PHP & MySQL Quickly

Learn To Build Robust PHP / MySQL Web Applications, Taught By Leading Zend Certified PHP Trainer. Learn To Code PHP Fast
4.3 (96 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
5,561 students enrolled
Created by Infinite Skills
Last updated 1/2017
English
English [Auto-generated]
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 15.5 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • How to download and install PHP and MySQL tools and frameworks onto a server and home machine.
  • How to configure relevant setting to match the needs of your project.
  • How to work between a user interface and a database back-end that stores critical information.
  • How to plan and apply PHP and MySQL to specific examples and finally your own real world projects.
View Curriculum
Requirements
  • The Desire To Create Cool Web Applications In PHP And MySQL
Description

A 15 hour PHP & MySQL Training Course Taught By A Zend Certified PHP Trainer, This PHP with MySQL Essential Training Teaches You All You Need To Know.

In this PHP / MySQL training title from InfiniteSkills, you will learn PHP and MySQL and its fundamentals. These two platforms have been virtually inseparable for many years, and major groundbreaking websites such as WordPress, Wikipedia, and Facebook use PHP and MySQL technologies.

This PHP with MySQL Essential Training is designed for the beginner; no previous programming or database experience is required. Your training begins with the absolute basics, covering topics such as creating variables, working with data types and outputting them to a web page. You will learn how to work with arrays, how to use loops and control structures such as for each, while and if. You will learn about functions and creating classes for object-oriented programming. You will master interacting with MySQL and using SQL functions to store and retrieve data. Doug also provides in-depth lessons on how PHP and MySQL can be used to send email, work with date and time functions, use cookies and sessions, building web forms, and much more.

Throughout this PHP with MySQL Essential Training course you will complete labs that re-enforce the concepts you have learnt. Once you have completed this video tutorial you will be well versed in the fundamentals of creating web applications using PHP and MySQL. Working files are included, allowing you to follow along with the author throughout the lessons.

</p>
Who is the target audience?
  • Anyone who wants to build a website that goes beyond the requirements of basic HTML and CSS.
  • Anyone who wants to learn how to build an app that can handle data and interface with end users at the same time.
  • Anyone who wants to learn how MySQL can function as a database solution.
  • Anyone who wants to learn basic programming and development skills without days of digging through technical books.
Compare to Other MySQL Courses
Curriculum For This Course
143 Lectures
15:20:21
+
Getting Started
15 Lectures 01:33:56


0102 Course Setup Using XAMPP
07:00

0103 Installing XAMPP On Windows
06:50

0104 Installing MAMP On The Mac
05:05

0105 Installing XAMPP On Linux
04:52

0106 Configuring PHP And MySQL
11:59

0107 Configuring Apache
09:34

0108 Using Editors And IDEs
06:58

0109 Saving Your Code
02:37

0110 Searching PHP And MySQL Documentation
07:55

0111 Getting Help And Verifying XAMPP Status
07:05

0112 Setup And Finding Course Files:
05:11

0113 Lab: Building A New Website
03:55

0114 Solution: Building A New Website
03:32
+
Understanding The Basics
11 Lectures 59:58
0201 Creating Variables In PHP
05:32

0202 Assigning Different Data Types
09:20

0203 Performing Arithmetic Operations
05:43

0204 Adding Comments To The Code
02:30

0205 Assigning Constant Values In PHP
04:09

0206 Using The printf Command To Format A String
04:26

0207 Understanding The substr Command
04:41

0208 Working With Strings
08:11

0209 Debugging An Application
07:39

0210 Lab: Mixing HTML And PHP
03:04

0211 Solution: Mixing HTML And PHP
04:43
+
Working With Arrays
11 Lectures 44:32
0301 Working With Numeric Keys
03:24

0302 Working With Associative Arrays
02:01

0303 Assigning Values To Arrays
05:13

0304 Creating A Multidimensional Array
05:31

0305 Searching Arrays
05:08

0306 Sorting Arrays
07:32

0307 Removing Values From Arrays
04:21

0308 Measuring Array Differences
03:27

0309 Merging Arrays
01:27

0310 Lab: Using An Array To Generate A Drop Down Menu
02:09

0311 Solution: Using An Array To Generate A Drop Down Menu
04:19
+
Creating Control Structures: Looping And Branching
9 Lectures 42:53
0401 Comparing Values
05:21

0402 Using if, else, And elseif
07:12

0403 Using switch
03:16

0404 Setting Up A for Loop
04:34

0405 Configuring while And do while Loops
05:34

0406 Using A foreach Loop
05:58

0407 Branching With continue, break, And goto
05:19

0408 Lab: Using Loops To Display Rows Of Data On A Web Page
02:16

0409 Solution: Using Loops To Display Rows Of Data On A Web Page
03:23
+
Managing The Code: Functions
9 Lectures 47:56
0501 Using Built-In Functions
05:36

0502 Creating Your Own Functions
06:29

0503 Returning Values
03:53

0504 Defining Mandatory And Optional Parameters
04:11

0505 Using Parameters By Reference
05:32

0506 Handling A Variable Number Of Parameters
04:11

0507 Understanding Global Variables In PHP
06:40

0508 Lab: Creating A Function Which Paginates Rows Of Data
02:51

0509 Solution: Creating A Function Which Paginates Rows Of Data
08:33
+
Managing The Code: Object-Oriented Programming
9 Lectures 53:34
0601 Defining Classes
09:45

0602 Adding Properties
04:56

0603 Creating Methods
07:54

0604 Determining The Visibility Level
07:58

0605 Building Classes By Inheritance
05:14

0606 Handling Exceptions
07:18

0607 Introducing The MVC (Model-View-Controller) Design Pattern
05:27

0608 Lab: Building An MVC Website Using OOP
01:54

0609 Solution: Building An MVC Website Using OOP
03:08
+
Managing The Code: External Libraries
7 Lectures 28:08
0701 Loading Code With include
02:47

0702 Loading Code With require
04:34

0703 Loading Code Once Only
04:05

0704 PHP Extensions And PECL
06:16

0705 PHP Libraries And PEAR
04:31

0706 Lab: Downloading An External Library
02:19

0707 Solution: Downloading An External Library
03:36
+
Managing Files
7 Lectures 41:49
0801 Using The f* Family
07:16

0802 Using The *file* Family
05:09

0803 Understanding Streams
07:21

0804 Updating The Error_Log
05:41

0805 Parsing Directory Structures
04:15

0806 Lab: Reading A CSV File
03:30

0807 Solution: Reading A CSV File
08:37
+
Managing A MySQL Database
11 Lectures 01:26:01
0901 Understanding RDBMS Terminology
05:52

0902 Command Line Access
04:24

0903 Using phpMyAdmin
09:56

0904 Configuration
12:16

0905 Creating A Database
08:47

0906 Managing Tables - Part 1
07:57

0907 Managing Tables - Part 2
07:08

0908 Understanding Indexes And Relationships
06:48

0909 Establishing Relationships And Constraints
09:34

0910 Lab: Defining Tables And Relationships For A Website
04:32

0911 Solution: Defining Tables And Relationships For A Website
08:47
+
Understanding Structured Query Language (SQL)
7 Lectures 57:51
1001 Retrieving Data Using SELECT
10:46

1002 Adding Data Using INSERT
08:42

1003 Editing Data Using UPDATE
07:57

1004 Removing Data Using DELETE
05:30

1005 Performing Advanced Queries Using JOIN
11:51

1006 Lab: Creating Select, Insert, Update, And Delete SQL Statements
02:24

1007 Solution: Creating Select, Insert, Update, And Delete SQL Statements
10:41
6 More Sections
About the Instructor
Infinite Skills
4.4 Average rating
49,464 Reviews
751,410 Students
331 Courses
High Quality Training

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.