PHP & MySQL - Certification Course for Beginners

Learn to Build Database Driven Web Applications using PHP & MySQL

4.33 (4278 reviews)
Udemy
platform
English
language
Web Development
category
PHP & MySQL - Certification Course for Beginners
283,057
students
3.5 hours
content
Jul 2019
last update
$44.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

Why take this course?

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

Our review

πŸ“š **Overall Course Rating:** 4.33 **Pros:** - πŸŽ“ **Clear Explanations:** Many reviewers found the course's explanations to be clear, understandable, and well-structured for beginners in PHP and MySQL. - 🌍 **International Appeal:** A non-English speaker appreciated the course despite language barriers, indicating its potential appeal to a global audience. - πŸ› οΈ **Practical Content:** The basics of PHP and MySQL are well covered, providing a strong foundation for new programmers. - πŸ‘ **Beginner Friendly:** The course is praised for being suitable for those with no prior programming experience. - 🧠 **Direct and Straightforward:** The content is described as "grano" or straight to the point, which can be very beneficial for learners. - πŸ‘ **Engaging Instructor:** The instructor's performance is consistently highlighted as a positive aspect of the course. - πŸ’Ό **Real-World Application:** The course is considered practical and prepares students to apply their knowledge creatively in programming. - 🌟 **Positive Learning Experience:** Several reviewers expressed gratitude and appreciation for the course, indicating a favorable learning experience. **Cons:** - ⏰ **Outdated Content:** Some learners noted that the course content seems outdated, particularly regarding the order in which concepts are introduced. - πŸ“¬ **Lack of Visual Clarity:** The divided screen during lectures makes it difficult to see the code clearly. - πŸ”„ **Insufficient Detail:** Reviewers pointed out that the course is too brief and lacks depth, especially in PHP built-in functions and SQL specifics. - πŸ’² **Value for Money:** The course is perceived as too short for its price, offering poor value for money by some learners. - ❌ **Missing Exercises:** The absence of coding challenges or projects is seen as a significant drawback for practical learning. - πŸ› οΈ **Incorrect Tools Mentioned:** There was confusion regarding the use of Mysqli instead of PDO as advertised. - πŸ“ **Lack of Visual Aids:** Some reviewers expressed a desire for access to PowerPoint slides and larger text formats for improved readability. - πŸ”„ **Inconsistent Instruction:** The course initially promised Mysqli usage but primarily used PDO, which could lead to confusion if learners follow along without adjustments. - πŸ“ **Missing Documentation:** Source code for certain lectures was missing, causing disruption in the learning process. - πŸ› οΈ **Installation Guidance:** The course did not provide complete steps for installing MAMP/WAMP testing servers, requiring learners to seek information elsewhere. **Additional Notes:** - 🏫 **Suggested Improvements:** Reviewers suggest adding chapter tests to monitor skill progression and a final project at the end of the course for comprehensive learning. - πŸŽ“ **Accessibility:** Some learners appreciated the course enough to recommend it for free, indicating that it could be an excellent resource with certain improvements. **Summary:** This PHP and MySQL course is generally well-received for its clear explanations, practical content, and engaging instructor. However, it faces criticism for being too brief, lacking practical exercises, and having some inconsistencies in instruction. To enhance the learning experience, recommendations include adding more detailed content, visual aids, comprehensive guides for setup processes, and interactive elements like quizzes and a final project.

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
10/13/2023100% OFF
expired
10/18/2023100% OFF
expired
10/27/2023100% OFF
expired
11/8/2023100% OFF
expired
12/6/2023100% OFF
expired
1/14/2024100% OFF
expired
2/22/2024100% OFF
expired
3/14/2024100% OFF
expired
4/5/2024100% 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