PHP & MySQL - Certification Course for Beginners

Learn to Build Database Driven Web Applications using PHP & MySQL

4.32 (4108 reviews)
Udemy
platform
English
language
Web Development
category
PHP & MySQL - Certification Course for Beginners
273,424
students
3.5 hours
content
Jul 2019
last update
$54.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

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

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

Reviews

Abdulrazaq
July 8, 2023
I've had only one issue so far and that it didn't provide some important steps in order to be able to understand the course which is about installing the MAMP/WAMP testing server and just mentioned that if you were enrolled in another course you'll find how to do it and that was something annoying for me because I had to go find the way of installation somewhere else which took time. Otherwise great course so far!
David
April 8, 2023
too short not enough detail on key parts. at beginning of Mysql section it was stated that this would be using Mysqli interface .. not PDO. But everything was in PDO. I guess it was good I had to change everything with correct commands for Mysqli
Uday
February 21, 2023
There should be a test at the end of every chapter so that learner can check his skill progress. At the the end of the course there must be a project which conclude the entire course.
Haesser
January 4, 2023
Very easy to understand and a good refresher for non-beginners in PHP and MySQL like me. There are some things that aren't taught in my university, I'm glad I enrolled in this course.
Desti
January 2, 2023
For Beginners, this course give explaination with easy example and this modul and video help me to understand
Mayasa
December 7, 2022
I like the course so much, explanation of teacher is very clear , with great exercises included. I really appreciate your work with such effort.
Dushyant
October 26, 2022
so far the course is really great . Educator has explained things very clearly and its totally worth to pursue this course.
Alfredo
October 23, 2022
This course was amazing ! I'm just earning more money to buy new ones ! the instructor was very clear and the lessons were pretty good !!! Five Stars !!!
Wolfgang
October 17, 2022
Good starting point for further learning PHP and good explanations. Some topics are not covered and the source code for lection 57 is missed.
Andrew
August 6, 2022
Good job but it would be useful if you also provide us the codes in updating records.. Anyway, thanks!
Rohit
August 2, 2022
It should cover in all the aspects from form controls, how to design the form, datasheet controls and many more.
Kudave
July 19, 2022
Great!! Nice instructor also precious information about PHP and MYSQL. Again course overall length is average. Course was too short in my opinion. Overall best, quite beginner friendly, and thank you instructor to teach me , great work !!!
Moses
July 7, 2022
Php is explained very well, but some of the codes which relates php and MySQL is not explained well. Other than that, this course is very well organized and knowledgeable course.
David
June 28, 2022
Expected me to have access to the WAMP download and set up tutorial that is in a different class entirely. This was not stated in the pre requisites. I was able to find the WAMP download video as a preview, and am hoping the server setup video doesn't have vital information that will block me from completing the course later.
Pranav
May 16, 2022
In lecture 28, I'm getting the error - Parse error: syntax error, unexpected token "if" on line 24. But the code runs fine in the video. Can you help me? I've checked multiple times for missing ; and {,(, etc. I cannot continue unless this form runs.

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
1/30/2022100% OFF
expired
2/13/2022100% OFF
expired
2/17/2022100% OFF
expired
2/22/2022100% OFF
expired
3/8/2022100% OFF
expired
3/16/2022100% OFF
expired
3/25/2022100% OFF
expired
4/9/2022100% OFF
expired
4/18/2022100% OFF
expired
4/30/2022100% OFF
expired
5/11/2022100% OFF
expired
5/22/2022100% OFF
expired
6/13/2022100% OFF
expired
6/29/2022100% OFF
expired
7/6/2022100% OFF
expired
7/10/2022100% OFF
expired
7/28/2022100% OFF
expired
8/25/2022100% OFF
expired
8/27/2022100% OFF
expired
8/30/2022100% OFF
expired
9/15/2022100% OFF
expired
9/20/2022100% OFF
expired
9/22/2022100% OFF
expired
10/6/2022100% OFF
expired
10/13/2022100% OFF
expired
10/20/2022100% OFF
expired
11/8/2022100% OFF
expired
11/15/2022100% OFF
expired
11/25/2022100% OFF
expired
12/6/2022100% OFF
expired
12/14/2022100% OFF
expired
12/27/2022100% OFF
expired
1/5/2023100% OFF
expired
1/11/2023100% OFF
expired
1/20/2023100% OFF
expired
2/7/2023100% OFF
expired
2/21/2023100% OFF
expired
3/16/2023100% OFF
expired
3/17/2023100% OFF
expired
4/7/2023100% OFF
expired
4/14/2023100% OFF
expired
4/22/2023100% OFF
expired
5/9/2023100% OFF
expired
5/17/2023100% OFF
expired
5/27/2023100% OFF
expired
6/8/2023100% OFF
expired
6/17/2023100% OFF
expired
6/29/2023100% OFF
expired
7/11/2023100% OFF
expired
7/22/2023100% OFF
expired
7/27/2023100% OFF
expired
8/11/2023100% OFF
expired
9/14/2023100% OFF
expired
9/20/2023100% OFF
expired

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

Related Topics

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