PHP & MySQL - Certification Course for Beginners

Learn to Build Database Driven Web Applications using PHP & MySQL

4.33 (3107 reviews)
Udemy
platform
English
language
Web Development
category
215,934
students
3.5 hours
content
Jul 2019
last update
$199.99
regular price

What you will learn

PHP Variables, Syntax, Variable Scope, Keywords

Echo vs. Print and Data Output

PHP Strings, Constants, Operators

PHP Conditional Statements

PHP Elseif, Switch, Statements

PHP Loops - While, For

PHP Functions

PHP Arrays, Multidimensional Arrays, Sorting Arrays

Working with Forms - Post vs. Get

PHP Server Side - Form Validation

Creating MySQL Databases

Database Administration with PhpMyAdmin

Administering Database Users, and Defining User Roles

SQL Statements - Select, Where, And, Or, Insert, Get Last ID

MySQL Prepared Statements and Multiple Record Insertion

PHP Isset

MySQL - Updating Records

Description

Welcome to the PHP & MySQL Certification Course for Beginners.

This course offers a comprehensive guide to learning how to code in PHP. We also explore integrating MySQL Databases into your PHP Projects for dynamic, user driven functionality.

We start with PHP basics, including variable declaration and data output. The lessons then transition into working with objects, conditional statements, loops, functions, arrays, form validation, sorting, and much more.

After the PHP Section, students learn to unleash the true power of dynamic page development with MySQL database integration. We start with table creation and user management. From there we progress into commonly used SQL statements for database administration. Students are also taught how to create database connections and to execute SQL statements directly from PHP scripts. Our coding style keeps script security, and execution efficiency in mind at all times.

If you are interested in embarking into the world of PHP Development with Database integration, don’t wait another second. Enrol today in this exciting new course.

What you'll learn - Overview:

  • PHP Variables, Syntax, Variable Scope, Keywords

  • Echo vs. Print and Data Output

  • PHP Strings, Constants, Operators

  • PHP Conditional Statements

  • PHP Elseif, Switch, Statements

  • PHP Loops - While, For

  • PHP Functions

  • PHP Arrays, Multidimensional Arrays, Sorting Arrays

  • Working with Forms - Post vs. Get

  • PHP Server Side - Form Validation

  • Creating MySQL Databases

  • Database Administration with PhpMyAdmin

  • Administering Database Users, and Defining User Roles

  • SQL Statements - Select, Where, And, Or, Insert, Get Last ID

  • MySQL Prepared Statements and Multiple Record Insertion

  • PHP Isset

  • MySQL - Updating Records

Screenshots

PHP & MySQL - Certification Course for Beginners - Screenshot_01PHP & MySQL - Certification Course for Beginners - Screenshot_02PHP & MySQL - Certification Course for Beginners - Screenshot_03PHP & MySQL - Certification Course for Beginners - Screenshot_04

Content

PHP Development

PHP Introduction
PHP Preparation
PHP File Test
PHP Syntax
PHP Variables
PHP Variable Scope
PHP Global Keyword
PHP Static Keyword
PHP Echo vs Print
PHP Data Types
PHP Objects
PHP Strings
PHP Constants
PHP Operators
PHP Conditional Statements
PHP ElseIf Statement
PHP Switch Statement
PHP While Loops
PHP For Loops
PHP Functions
PHP Functions Continued
PHP Arrays
PHP Multidimensional Arrays
PHP Sorting Arrays
PHP Superglobal Variables
PHP Forms Introduction
PHP POST vs GET Basics
PHP Form Output and Validation
PHP Form Required Fields
PHP Validation Continued

MySQL Database Integration

Introduction to MySQL Databases
Introduction PhpMyAdmin
PhpMyAdmin Interface Overview
MySQL Security and Root Superuser
MySQL Creating a Database and Table
MySQL Creating a New User
MySQL Database and Table Specific Privileges
MySQL Modifying and Deleting a Table
MySQL Modifying and Deleting a Database
Introduction to SQL
SQL Statements in PhpMyAdmin
Connect to MySQL Database using PHP
MySQL Database - Import Data
SQL Select
SQL Distinct Keyword
SQL Where Clause
SQL And Operator
SQL Or Operator
SQL Order By
MySQL Insert Into
MySQL Get Last ID
MySQL Insert Multiple Records
MySQL Prepared Statements
MySQL Delete Records
PHP Header Function
PHP Isset
MySQL Update Records

Reviews

Amey
December 3, 2021
Perfect crash course for beginners in PHP & MySQL. However the basics and PhP tags are not fully explained which I expected. Overall great learning experience with simple tools in Web Development
Vladimir
November 21, 2021
Very little information. No information about COOKIES, SESSIONS and other important features for a beginner programmer.
Ravihara
November 2, 2021
Basic knowledge of php and mysql was quickly and easily updated. I wish YouAccel Training to continue to bring such valuable lessons.
Sheila
October 15, 2021
for those of us that aren't taking this as part of a master course, better instruction on installing wamp please
Sylvester
October 14, 2021
Great course but the slides are a bit fuzzy so making out exact symbols when typing code sometimes created difficulty.
Oisin
October 1, 2021
Nice overview, especially if you're already familiar with another programming language. Not sure if newbies to coding will grasp the depth and complexities of object-oriented programming in a 3 min segment tho. ? Got WAMP up and running and got to play with some PHP and MySQL. I had fun making interactive webpages and learned a lot so 5/5 stars. ⭐⭐⭐⭐⭐ Pros: - The course is great as a short introduction to PHP and MySQL. - Clear audio - Exercise files Cons: - Resolution is less than 1080p and the text used on screen is quite small causing it to become a little bit pixelated. Still readable though you may need to maximize on screen. Might not be clear on mobile. - Highlight color around cursor is too opaque and somewhat blocks what is beneath. This is especially noticeable when the lecturer uses the cursor to point at specific areas of text.
Micaela
August 27, 2021
Todo okey, sin embargo algunas clases comienzan suponiendo un conocimiento de otro curso. Igualmente esto no impide ente der el contenido de este curso. Falta la explicacion de cómo instalar los programas, a la cual el profesor se hace referencia en la primera lección.
Stanley
August 16, 2021
I love how he is explaining the concepts step by step. Really good for a beginner of either php or programming. thanks
Luca
July 28, 2021
Good course to start learning PHP and MySQL, I'm a little disappointed because the course didn't show how to use MySQL from a terminal, still good though.
Michael
May 18, 2021
No instructions on setting up the WAMP server. Only "we did this on a previous course:. There was no indication when I purchased that prerequisites were required. Anyway, I worked it out. It would be very easy to provide a link to the download for WAMP on this course. The fontsize is too small. Very difficult to read in the code area. Also, you should make available two versions of the scripts where they have been changed so the full version is also available. Example, Lecture 28.
John
May 13, 2021
This lesson is from 2016, and while mostly relevant, is somewhat dated. It also ended quite abruptly, without really bringing everything together.
Miguel
April 12, 2021
For the moment (lecture 28), the learning process has been quite complete. It would have been great if, instead of using a "template", he would write the code to show how it behaves live in the videos, glitches and all.
Automated
April 6, 2021
The instructor doesn't provide base knowledge and explanations of the course content. As soemone brand new to php and html this instructor leaves a lot out that should be explained. I had to go research and take time to find things outside of the course which I shouldn't need to at a price over $100.
Mochamad
April 6, 2021
Saya sudah expert saya hanya membutuhkan sertifikatnya saja. Tapi kursus ini membantu untuk pemula seperti teman saya.
Alan
March 22, 2021
I was disappointed that installation of MAMP wasn't covered but that passed when the installation went well, without help. Then I found that the document root information was wrong, and mine uses something different and then I found that setting PHP preferences to see the error messages is completely different and currently impossible. I am not so disappointed now that I've solved the problems. I like the way each tiny element is introduced in detail and some practice is included. I am enjoying the progress.

Charts

Price

PHP & MySQL - Certification Course for Beginners - Price chart

Rating

PHP & MySQL - Certification Course for Beginners - Ratings chart

Enrollment distribution

PHP & MySQL - Certification Course for Beginners - Distribution chart

Coupons

DateDiscountStatus
9/26/2019100% OFF
expired
10/14/2019100% OFF
expired
11/13/2019100% OFF
expired
12/13/2019100% OFF
expired
1/6/2020100% OFF
expired
1/31/2020100% OFF
expired
2/12/2020100% OFF
expired
3/12/2020100% OFF
expired
3/25/2020100% OFF
expired
4/4/2020100% OFF
expired
4/11/2020100% OFF
expired
4/23/2020100% OFF
expired
5/5/2020100% OFF
expired
5/16/2020100% OFF
expired
6/2/2020100% OFF
expired
6/17/2020100% OFF
expired
7/6/2020100% OFF
expired
7/10/2020100% OFF
expired
8/6/2020100% OFF
expired
8/26/2020100% OFF
expired
9/5/2020100% OFF
expired
9/18/2020100% OFF
expired
9/21/2020100% OFF
expired
10/5/2020100% OFF
expired
10/20/2020100% OFF
expired
10/23/2020100% OFF
expired
11/6/2020100% OFF
expired
11/21/2020100% OFF
expired
11/26/2020100% OFF
expired
12/19/2020100% OFF
expired
12/24/2020100% OFF
expired
12/28/2020100% OFF
expired
1/22/2021100% OFF
expired
1/27/2021100% OFF
expired
2/19/2021100% OFF
expired
2/25/2021100% OFF
expired
3/19/2021100% OFF
expired
3/22/2021100% OFF
expired
3/30/2021100% OFF
expired
4/8/2021100% OFF
expired
4/23/2021100% OFF
expired
5/10/2021100% OFF
expired
5/28/2021100% OFF
expired
6/19/2021100% OFF
expired
6/30/2021100% OFF
expired
7/11/2021100% OFF
expired
7/20/2021100% OFF
expired
8/2/2021100% OFF
expired
8/21/2021100% OFF
expired
9/2/2021100% OFF
expired
9/28/2021100% OFF
expired
9/30/2021100% OFF
expired
10/10/2021100% OFF
expired
10/27/2021100% OFF
expired
10/30/2021100% OFF
expired
11/21/2021100% OFF
expired
11/26/2021100% OFF
expired
1/9/2022100% OFF
expired

Related Topics

2390114
udemy ID
5/29/2019
course created date
6/19/2019
course indexed date
Bot
course submited by