Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS AWS Certified Developer - Associate CompTIA Security+
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2021-01-02 15:42:25
30-Day Money-Back Guarantee

This course includes:

  • 3.5 hours on-demand video
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
Development Web Development PHP

PHP & MySQL - Certification Course for Beginners

Learn to Build Database Driven Web Applications using PHP & MySQL
Rating: 4.2 out of 54.2 (2,055 ratings)
138,994 students
Created by YouAccel Training
Last updated 7/2019
English
English [Auto]
30-Day Money-Back Guarantee

What you'll 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

Course content

2 sections • 57 lectures • 3h 15m total length

  • Preview03:03
  • Preview02:55
  • Preview02:20
  • Preview05:37
  • PHP Variables
    03:46
  • PHP Variable Scope
    03:15
  • PHP Global Keyword
    02:03
  • PHP Static Keyword
    01:45
  • PHP Echo vs Print
    04:01
  • PHP Data Types
    05:46
  • PHP Objects
    02:58
  • PHP Strings
    01:50
  • PHP Constants
    03:04
  • PHP Operators
    08:52
  • PHP Conditional Statements
    02:32
  • PHP ElseIf Statement
    03:11
  • PHP Switch Statement
    01:45
  • PHP While Loops
    04:34
  • PHP For Loops
    01:40
  • PHP Functions
    03:29
  • PHP Functions Continued
    01:49
  • PHP Arrays
    04:51
  • PHP Multidimensional Arrays
    01:59
  • PHP Sorting Arrays
    02:51
  • PHP Superglobal Variables
    02:10
  • PHP Forms Introduction
    04:06
  • PHP POST vs GET Basics
    05:24
  • PHP Form Output and Validation
    09:36
  • PHP Form Required Fields
    04:40
  • PHP Validation Continued
    01:45

  • Introduction to MySQL Databases
    02:40
  • Introduction PhpMyAdmin
    02:35
  • PhpMyAdmin Interface Overview
    01:12
  • MySQL Security and Root Superuser
    05:02
  • MySQL Creating a Database and Table
    05:24
  • MySQL Creating a New User
    05:33
  • MySQL Database and Table Specific Privileges
    03:05
  • MySQL Modifying and Deleting a Table
    04:30
  • MySQL Modifying and Deleting a Database
    04:07
  • Introduction to SQL
    01:35
  • SQL Statements in PhpMyAdmin
    04:05
  • Connect to MySQL Database using PHP
    05:02
  • MySQL Database - Import Data
    01:43
  • SQL Select
    02:27
  • SQL Distinct Keyword
    01:45
  • SQL Where Clause
    01:40
  • SQL And Operator
    01:42
  • SQL Or Operator
    01:01
  • SQL Order By
    01:36
  • MySQL Insert Into
    06:29
  • MySQL Get Last ID
    01:27
  • MySQL Insert Multiple Records
    01:44
  • MySQL Prepared Statements
    02:45
  • MySQL Delete Records
    07:49
  • PHP Header Function
    01:17
  • PHP Isset
    02:35
  • MySQL Update Records
    07:07

Requirements

  • Basic Computer Skills

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.

Who this course is for:

  • Beginner developers who are interested in learning the foundations of PHP.
  • Students who want to integrate MySQL Databases into their PHP Web Applications.
  • Students who want to learn to code in PHP.
  • Students who want to learn how to execute SQL Statements, directly from PHP.

Featured review

Dan Okenka
Dan Okenka
80 courses
10 reviews
Rating: 5.0 out of 5a year ago
This course has good information that wasn't covered in other courses I looked at. The course goes over using similar concepts that all of php courses contain but is done differently using unique examples. It is cut and dry and too the point so if you looking to get really in-depth this isn't the course for you.

Instructor

YouAccel Training
Start learning and acquire the skills you need!
YouAccel Training
  • 4.2 Instructor Rating
  • 35,241 Reviews
  • 854,199 Students
  • 31 Courses

YouAccel is a leading provider in online training, offering courses across numerous industries from IT and Development to Business, Marketing, Design, and Productivity.

The e-learning experience provided by YouAccel is Dynamic. Each course is streamed in High Definition with corresponding assignments, quizzes, and exams that are delivered and graded electronically. All YouAccel courses are taught by certified educators that have numerous years of work experience in the field for which they provide instruction.

The courses can be taken at one's own pace and are offered at several levels including beginner, intermediate and advanced. Online courses are also compatible with any mobile device for the ultimate in convenience.

Taking the experience to a new personalized level, live communication with instructors is available through Udemy's online messaging console. All courses come with a certificate of completion and no age restrictions apply.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.