PHP & MySQL - Certification Course for Beginners

Learn to Build Database Driven Web Applications using PHP & MySQL

4.38 (2881 reviews)
Udemy
platform
English
language
Web Development
category
students
3.5 hours
content
Jul 2019
last update
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 BeginnersPHP & MySQL - Certification Course for BeginnersPHP & MySQL - Certification Course for BeginnersPHP & MySQL - Certification Course for Beginners

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

Micaela
27 August 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
16 August 2021
I love how he is explaining the concepts step by step. Really good for a beginner of either php or programming. thanks
Luca
28 July 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
18 May 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
13 May 2021
This lesson is from 2016, and while mostly relevant, is somewhat dated. It also ended quite abruptly, without really bringing everything together.
Miguel
12 April 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
6 April 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
6 April 2021
Saya sudah expert saya hanya membutuhkan sertifikatnya saja. Tapi kursus ini membantu untuk pemula seperti teman saya.
Kaitlyn
24 March 2021
it's early in the course and everything so far is simple and straight forward. a very good couple of lessons to brush up on the basics with.
Alan
22 March 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.
Carto
25 February 2021
materi yang sangat bagus, dan juga bisa dipahami sekalipun seseorang yang baru memulai belajar programming
Benattia
23 February 2021
Very Good explanation thank u so much, the only thing i not prefered the note++ coz the font is so small, if u use VScode or Php Storm that be better
Keir
11 February 2021
The videos are short which helps take better notes and gives a basic understanding of PHP which is what I was looking for.
Malior
10 February 2021
Image were so tine. why dividing the display when most people will either view with handset or laptop.
Kajal
30 January 2021
Yes, it is very useful for me to create the beautiful website with using php with database connectivity. Thanks sir for this free course.

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

Related Topics

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