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

WHAT'S INSIDE
  • Lifetime access to 144 lectures
  • 15+ hours of high quality content
  • A community of 4600+ students learning together!
  • 90+ discussions
SHARE

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
20 reviews

HOW UDEMY WORKS?

Discover courses made by experts from around the world.

Take your courses with you and learn anytime, anywhere.

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

COURSE 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>
    • The Desire To Create Cool Web Applications In PHP And MySQL
    • Over 144 lectures and 15.5 hours of content!
    • 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.
    • 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.

THE UDEMY GUARANTEE

30 day money back guarantee
Lifetime access
Available on Desktop, iOs and Android
Certificate of completion

CURRICULUM

  • SECTION 1:
    Getting Started
  • 1
    PHP Working Files - Download These First
    Text
  • 2
    How to Obtain Certification for this Course
    Text
  • 3
    0101 What The Course Covers
    11:22
  • 4
    0102 Course Setup Using XAMPP
    07:00
  • 5
    0103 Installing XAMPP On Windows
    06:50
  • 6
    0104 Installing MAMP On The Mac
    05:05
  • 7
    0105 Installing XAMPP On Linux
    04:52
  • 8
    0106 Configuring PHP And MySQL
    11:59
  • 9
    0107 Configuring Apache
    09:34
  • 10
    0108 Using Editors And IDEs
    06:58
  • 11
    0109 Saving Your Code
    02:37
  • 12
    0110 Searching PHP And MySQL Documentation
    07:55
  • 13
    0111 Getting Help And Verifying XAMPP Status
    07:05
  • 14
    0112 Setup And Finding Course Files:
    05:11
  • 15
    0113 Lab: Building A New Website
    03:55
  • 16
    0114 Solution: Building A New Website
    03:32
  • SECTION 2:
    Understanding The Basics
  • 17
    0201 Creating Variables In PHP
    05:32
  • 18
    0202 Assigning Different Data Types
    09:20
  • 19
    0203 Performing Arithmetic Operations
    05:43
  • 20
    0204 Adding Comments To The Code
    02:30
  • 21
    0205 Assigning Constant Values In PHP
    04:09
  • 22
    0206 Using The printf Command To Format A String
    04:26
  • 23
    0207 Understanding The substr Command
    04:41
  • 24
    0208 Working With Strings
    08:11
  • 25
    0209 Debugging An Application
    07:39
  • 26
    0210 Lab: Mixing HTML And PHP
    03:04
  • 27
    0211 Solution: Mixing HTML And PHP
    04:43
  • SECTION 3:
    Working With Arrays
  • 28
    0301 Working With Numeric Keys
    03:24
  • 29
    0302 Working With Associative Arrays
    02:01
  • 30
    0303 Assigning Values To Arrays
    05:13
  • 31
    0304 Creating A Multidimensional Array
    05:31
  • 32
    0305 Searching Arrays
    05:08
  • 33
    0306 Sorting Arrays
    07:32
  • 34
    0307 Removing Values From Arrays
    04:21
  • 35
    0308 Measuring Array Differences
    03:27
  • 36
    0309 Merging Arrays
    01:27
  • 37
    0310 Lab: Using An Array To Generate A Drop Down Menu
    02:09
  • 38
    0311 Solution: Using An Array To Generate A Drop Down Menu
    04:19
  • SECTION 4:
    Creating Control Structures: Looping And Branching
  • 39
    0401 Comparing Values
    05:21
  • 40
    0402 Using if, else, And elseif
    07:12
  • 41
    0403 Using switch
    03:16
  • 42
    0404 Setting Up A for Loop
    04:34
  • 43
    0405 Configuring while And do while Loops
    05:34
  • 44
    0406 Using A foreach Loop
    05:58
  • 45
    0407 Branching With continue, break, And goto
    05:19
  • 46
    0408 Lab: Using Loops To Display Rows Of Data On A Web Page
    02:16
  • 47
    0409 Solution: Using Loops To Display Rows Of Data On A Web Page
    03:23
  • SECTION 5:
    Managing The Code: Functions
  • 48
    0501 Using Built-In Functions
    05:36
  • 49
    0502 Creating Your Own Functions
    06:29
  • 50
    0503 Returning Values
    03:53
  • 51
    0504 Defining Mandatory And Optional Parameters
    04:11
  • 52
    0505 Using Parameters By Reference
    05:32
  • 53
    0506 Handling A Variable Number Of Parameters
    04:11
  • 54
    0507 Understanding Global Variables In PHP
    06:40
  • 55
    0508 Lab: Creating A Function Which Paginates Rows Of Data
    02:51
  • 56
    0509 Solution: Creating A Function Which Paginates Rows Of Data
    08:33
  • SECTION 6:
    Managing The Code: Object-Oriented Programming
  • 57
    0601 Defining Classes
    09:45
  • 58
    0602 Adding Properties
    04:56
  • 59
    0603 Creating Methods
    07:54
  • 60
    0604 Determining The Visibility Level
    07:58
  • 61
    0605 Building Classes By Inheritance
    05:14
  • 62
    0606 Handling Exceptions
    07:18
  • 63
    0607 Introducing The MVC (Model-View-Controller) Design Pattern
    05:27
  • 64
    0608 Lab: Building An MVC Website Using OOP
    01:54
  • 65
    0609 Solution: Building An MVC Website Using OOP
    03:08
  • SECTION 7:
    Managing The Code: External Libraries
  • 66
    0701 Loading Code With include
    02:47
  • 67
    0702 Loading Code With require
    04:34
  • 68
    0703 Loading Code Once Only
    04:05
  • 69
    0704 PHP Extensions And PECL
    06:16
  • 70
    0705 PHP Libraries And PEAR
    04:31
  • 71
    0706 Lab: Downloading An External Library
    02:19
  • 72
    0707 Solution: Downloading An External Library
    03:36
  • SECTION 8:
    Managing Files
  • 73
    0801 Using The f* Family
    07:16
  • 74
    0802 Using The *file* Family
    05:09
  • 75
    0803 Understanding Streams
    07:21
  • 76
    0804 Updating The Error_Log
    05:41
  • 77
    0805 Parsing Directory Structures
    04:15
  • 78
    0806 Lab: Reading A CSV File
    03:30
  • 79
    0807 Solution: Reading A CSV File
    08:37
  • SECTION 9:
    Managing A MySQL Database
  • 80
    0901 Understanding RDBMS Terminology
    05:52
  • 81
    0902 Command Line Access
    04:24
  • 82
    0903 Using phpMyAdmin
    09:56
  • 83
    0904 Configuration
    12:16
  • 84
    0905 Creating A Database
    08:47
  • 85
    0906 Managing Tables - Part 1
    07:57
  • 86
    0907 Managing Tables - Part 2
    07:08
  • 87
    0908 Understanding Indexes And Relationships
    06:48
  • 88
    0909 Establishing Relationships And Constraints
    09:34
  • 89
    0910 Lab: Defining Tables And Relationships For A Website
    04:32
  • 90
    0911 Solution: Defining Tables And Relationships For A Website
    08:47
  • SECTION 10:
    Understanding Structured Query Language (SQL)
  • 91
    1001 Retrieving Data Using SELECT
    10:46
  • 92
    1002 Adding Data Using INSERT
    08:42
  • 93
    1003 Editing Data Using UPDATE
    07:57
  • 94
    1004 Removing Data Using DELETE
    05:30
  • 95
    1005 Performing Advanced Queries Using JOIN
    11:51
  • 96
    1006 Lab: Creating Select, Insert, Update, And Delete SQL Statements
    02:24
  • 97
    1007 Solution: Creating Select, Insert, Update, And Delete SQL Statements
    10:41
  • SECTION 11:
    Using PHP To Interact With A MySQL Database
  • 98
    1101 Understanding The Different MySQL Database Extensions
    10:38
  • 99
    1102 Reading Data From A Table
    09:57
  • 100
    1103 Writing Data To A Table
    11:32

UDEMY BY THE NUMBERS

5,200,000
Hours of video content
19,000,000
Course Enrollments
5,800,000
Students

RATING

  • 15
  • 3
  • 1
  • 0
  • 1
AVERAGE RATING
NUMBER OF RATINGS
20

REVIEWS

  • Raghav Gupta
    Waste Of Money!

    Sharing the Working Files and simply showing the simulation/results in the lecture videos isn't what we define development as!Waste of time and Money!

  • Jordan Max
    Very explanatory and really good website to work off of

    I am very happy to have done this course I feel like I can fully understand how backend database programming of a website works. Anyone who is interested in this should take this course you will see why after you complete it.

  • Grant Hynd
    Comprehensive and Well Structured Course

    Everything is explain in great detail from the basics to the more advanced parts of the course. I think transforming a standard html website to a dynamic php website driven by a database is a great way to show students how php/mysql works together. Yes, the tutor for the course does have quite a monotone voice, which makes some section quite hard to pay attention too. However, i do think the well structured material and interactive project makes up for that.

  • Jon Buckner
    Good, informative but...

    Hi folks, There are a lot of lessons here, and I am sure that they help out a lot. Certainly seem to be very comprehensive. A lot of files to work with but... a) the lessons start and you have to search around (all be it, not for very long) to find the file associated with the lesson, would have been better if the files were labelled 'lesson1', 'lesson2', or if more than one per lesson 'lesson2_1' etc.. b) The tutor is the worlds best cure for insomnia, sorry to be harsh, but it's true. It is really difficult to listen and be attentive against the monotone voice. I'm sure he is a nice guy and means well, but it just drains me... c) I had trouble accessing files through browser, I had to copy and relabel the files, might have been a problem my end, will never know as had no response... d) the vidoe is quite blurred but that might be a Udemy thing, it means you can listen fine, but when watching the screen it is like you have had half a bottle of whiskey. Apart form all that, you can probably learn a lot of what you need from this course

  • Chris Pollard
    Very thorough!

    Admittedly, I WAS tempted to just give this four stars, because the narrator is quite dry to listen to. But that would be a great injustice to an otherwise great course. Some parts, like setting up XAMPP/localhost won't apply to most people using a hosted server - BUT there is some great knowledge to be gained by following through with it anyway. I've been coding in one way or another since the Commodore64 back in the 80s, and with PHP since 2001. Essentially, I signed up for this course as a refresher, since a lot of the PHP I learned was back when PHP3 was current and a lot of things have changed. This was right on the money. Picked up a lot of useful new ideas, refreshed a lot of things I already knew but have changed/deprecated over the years, and there were some great, easy to follow videos on hard to grasp elements like regular expressions. So while I've been coding in php/mysql for 13 years, and have a site that does over 3 million page views and goes through almost 500GB of bandwidth a month, this helped bring my skills up to date - and is an EXCELLENT place for a beginner to start as well. Grab a pot of coffee and get learning!

  • 30 day money back guarantee!
  • Lifetime Access. No Limits!
  • Mobile Accessibility
  • Certificate of Completion
MORE FROM Infinite Skills