PHP & MySQL - Certification Course for Beginners

Learn to Build Database Driven Web Applications using PHP & MySQL

Beginner 4.2(1,013 Ratings) 72,749 Students enrolled
Created by YouAccel Training Last updated 07/2019 English ["English [Auto-generated]"]
What will i 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

Curriculum for this course
57 Lectures 03:15:34
PHP Development
30 Lectures 01:47:37
  • PHP Introduction 00:03:03
  • PHP Preparation 00:02:55
  • PHP File Test 00:02:20
  • PHP Syntax 00:05:37
  • PHP Variables 00:03:46
  • PHP Variable Scope 00:03:15
  • PHP Global Keyword 00:02:03
  • PHP Static Keyword 00:01:45
  • PHP Echo vs Print 00:04:01
  • PHP Data Types 00:05:46
  • PHP Objects 00:02:58
  • PHP Strings 00:01:50
  • PHP Constants 00:03:04
  • PHP Operators 00:08:52
  • PHP Conditional Statements 00:02:32
  • PHP ElseIf Statement 00:03:11
  • PHP Switch Statement 00:01:45
  • PHP While Loops 00:04:34
  • PHP For Loops 00:01:40
  • PHP Functions 00:03:29
  • PHP Functions Continued 00:01:49
  • PHP Arrays 00:04:51
  • PHP Multidimensional Arrays 00:01:59
  • PHP Sorting Arrays 00:02:51
  • PHP Superglobal Variables 00:02:10
  • PHP Forms Introduction 00:04:06
  • PHP POST vs GET Basics 00:05:24
  • PHP Form Output and Validation 00:09:36
  • PHP Form Required Fields 00:04:40
  • PHP Validation Continued 00:01:45
  • Introduction to MySQL Databases 00:02:40
  • Introduction PhpMyAdmin 00:02:35
  • PhpMyAdmin Interface Overview 00:01:12
  • MySQL Security and Root Superuser 00:05:02
  • MySQL Creating a Database and Table 00:05:24
  • MySQL Creating a New User 00:05:33
  • MySQL Database and Table Specific Privileges 00:03:05
  • MySQL Modifying and Deleting a Table 00:04:30
  • MySQL Modifying and Deleting a Database 00:04:07
  • Introduction to SQL 00:01:35
  • SQL Statements in PhpMyAdmin 00:04:05
  • Connect to MySQL Database using PHP 00:05:02
  • MySQL Database - Import Data 00:01:43
  • SQL Select 00:02:27
  • SQL Distinct Keyword 00:01:45
  • SQL Where Clause 00:01:40
  • SQL And Operator 00:01:42
  • SQL Or Operator 00:01:01
  • SQL Order By 00:01:36
  • MySQL Insert Into 00:06:29
  • MySQL Get Last ID 00:01:27
  • MySQL Insert Multiple Records 00:01:44
  • MySQL Prepared Statements 00:02:45
  • MySQL Delete Records 00:07:49
  • PHP Header Function 00:01:17
  • PHP Isset 00:02:35
  • MySQL Update Records 00:07:07
Requirements
  • Basic Computer Skills
+ View more
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.

+ View more
Other related courses
02:38:43
4 82 $149.99 Free
08:53:47
3.7 55 Free
01:31:27
Updated Thu, 21-Nov-2019
4.1 39 $149.99 Free
01:45:50
4 30 $94.99 Free
04:45:08
4.1 30 Free
01:04:45
4.1 21 Free
03:48:48
4.4 15 $19.99 Free
05:25:07
4.4 23 Free
01:10:37
4.1 10 Free
03:52:13
Updated Tue, 03-Sep-2019
4.1 19 $99.99 Free
04:28:09
4.3 22 $19.99 Free
06:19:49
4.4 18 Free
01:52:35
4 24 $74.99 Free
01:39:41
3.7 17 $79.99 Free
02:09:40
4 15 Free
01:01:33
4 14 Free
51:12:35
4.2 23 $199.99 Free
02:23:35
Updated Wed, 10-Jul-2019
4 11 $99.99 Free
01:13:12
4.2 21 $139.99 Free
01:31:26
4.3 18 $139.99 Free
00:58:35
4.2 16 $94.99 Free
12:15:26
4.5 18 $99.99 Free
03:41:58
4.2 0 $39.99 Free
01:15:31
4.1 6 Free
00:44:15
4.7 6 $199.99 Free
03:36:22
4.1 2 Free
16:47:11
3.4 14 Free
03:09:33
Updated Mon, 04-Sep-2017
3.8 18 Free
02:07:36
4.2 1 Free
04:37:27
3.9 2 Free
02:14:18
Updated Sat, 24-Mar-2018
3.8 8 Free
02:23:03
4.3 6 Free
06:22:46
Updated Thu, 24-Mar-2016
4.1 1 Free
04:17:53
4.4 14 Free
00:57:12
3.5 12 Free
02:13:31
4.1 8 Free
12:52:08
3.8 10 Free
01:00:01
Updated Sun, 05-Apr-2020
3.3 4 Free
04:32:16
4.1 3 Free
03:41:40
4.2 5 Free
04:23:54
4 1 Free
02:12:25
3.9 0 Free
01:03:10
Updated Sat, 07-Dec-2019
3.9 2 Free
03:33:25
4 9 Free
02:43:49
4.5 0 Free
02:00:25
4.4 0 Free
01:10:58
3.8 8 Free
02:55:06
4.1 5 Free
00:36:19
Updated Wed, 29-Mar-2017
3.5 1 Free
02:18:52
4.1 13 Free
00:31:06
Updated Tue, 14-Nov-2017
3.7 6 Free
00:50:23
4 2 Free
02:27:52
Updated Thu, 08-Aug-2019
4.2 8 Free
00:50:19
4 4 $129.99 Free
01:49:58
3.9 13 $139.99 Free
01:17:39
Updated Fri, 27-Dec-2019
4.3 3 $99.99 Free
03:42:56
4 14 $199.99 Free
02:01:15
Updated Sun, 05-Apr-2020
3.7 4 $199.99 Free
01:40:29
Updated Sun, 05-Apr-2020
3.6 6 $199.99 Free
02:15:39
Updated Sun, 05-Apr-2020
3.3 11 $199.99 Free
01:37:27
Updated Sun, 05-Apr-2020
3.6 0 $199.99 Free
02:18:14
3.9 5 $129.99 Free
01:31:32
Updated Sun, 05-Apr-2020
3.8 3 $199.99 Free
01:24:32
Updated Sun, 05-Apr-2020
3.7 2 $199.99 Free
01:30:20
Updated Sun, 05-Apr-2020
3.6 6 $199.99 Free
01:19:56
Updated Sun, 05-Apr-2020
3.7 6 $199.99 Free
00:59:13
Updated Sun, 05-Apr-2020
3.3 5 $199.99 Free
01:01:52
Updated Sun, 05-Apr-2020
3.2 7 $199.99 Free
01:53:25
Updated Sun, 05-Apr-2020
3.8 9 $199.99 Free
02:17:41
Updated Sun, 05-Apr-2020
3.8 9 $199.99 Free
00:47:39
Updated Tue, 21-Apr-2020
3.5 6 $199.99 Free
00:41:25
Updated Sun, 05-Apr-2020
3.7 5 $199.99 Free
01:00:48
Updated Sun, 05-Apr-2020
3.2 8 $199.99 Free
00:33:47
Updated Sun, 05-Apr-2020
3.5 4 $199.99 Free
01:09:52
Updated Sun, 05-Apr-2020
3.4 7 $199.99 Free
00:40:16
Updated Sun, 05-Apr-2020
3.3 7 $199.99 Free
00:49:55
Updated Sun, 05-Apr-2020
3.8 4 $199.99 Free
02:34:03
4 5 $24.99 Free
24:16:36
4.2 41 $199.99 Free
00:37:00
3.7 2 $99.99 Free
07:52:29
4.2 15 $114.99 Free
05:38:23
Updated Sun, 18-Aug-2019
4.4 4 $34.99 Free
01:20:14
Updated Wed, 15-May-2013
4 0 Free
05:57:07
4.1 12 $159.99 Free
05:26:39
4.3 21 $39.99 Free
00:37:17
4 5 $99.99 Free
06:23:22
4 17 $99.99 Free
05:13:16
Updated Fri, 03-Jan-2020
3.6 0 $99.99 Free
08:33:58
3.9 13 $19.99 Free
27:55:46
4.5 9 $199.99 Free
47:29:47
Updated Wed, 01-Jan-2020
4.6 117 $179.99 Free
03:32:49
Updated Sun, 29-Sep-2019
4.6 20 $49.99 Free
14:59:04
4.7 12 $199.99 Free
13:30:15
Updated Fri, 27-Dec-2019
4.5 25 $149.99 Free
28:04:40
4.7 47 $199.99 Free
10:22:00
4.6 18 $119.99 Free
14:51:23
4.2 81 $194.99 Free
46:24:20
Updated Fri, 13-Dec-2019
4.6 225 $199.99 Free
05:30:27
4.1 19 $159.99 Free
04:17:37
4.5 2 Free
03:59:09
4.4 3 Free
03:41:47
3.2 14 Free
04:00:56
4.2 2 $149.99 Free
03:35:47
4.1 8 $199.99 Free
22:12:56
4.1 11 $199.99 Free
08:03:16
4.6 11 Free
10:51:38
3.8 3 $199.99 Free
14:41:03
4.2 10 Free
04:35:13
3.8 3 Free
39:30:00
4 15 Free
04:32:42
3.8 12 $19.99 Free
05:32:51
4.4 1 Free
06:43:19
Updated Mon, 05-Aug-2019
4.2 2 Free
03:20:40
4.2 7 $199.99 Free
05:51:57
Updated Sun, 17-Nov-2019
4.1 19 Free
18:45:45
Updated Mon, 27-Apr-2020
4.5 4 Free
04:47:30
4.2 14 Free
02:39:55
3.7 16 Free
13:17:19
3.8 16 $124.99 Free
01:18:41
Updated Tue, 24-Dec-2019
0 9 $19.99 Free
14:40:08
4.1 14 Free
01:18:30
Updated Mon, 13-Jan-2020
0 4 Free
03:09:37
3.9 12 Free
08:12:53
4.7 7 $39.99 Free
21:42:23
Updated Mon, 09-Dec-2019
4.6 19 $174.99 Free
02:18:00
4.3 7 $129.99 Free
14:34:08
4.6 17 $149.99 Free
17:04:39
Updated Fri, 27-Dec-2019
4.5 19 $109.99 Free
23:53:13
4.5 11 $94.99 Free
11:00:44
4.5 9 $149.99 Free
12:36:12
4.6 23 $149.99 Free
05:49:54
Updated Mon, 04-Nov-2019
4.6 13 $109.99 Free
10:11:39
4 11 $49.99 Free
02:52:39
Updated Sat, 11-Jan-2020
3 6 Free
01:06:37
Updated Mon, 20-Jan-2020
4.1 6 $19.99 Free
00:55:55
4.9 4 Free
01:57:08
4.3 8 $199.99 Free
05:05:38
Updated Mon, 11-Aug-2014
4 1 Free
00:58:40
Updated Thu, 21-Nov-2019
4.2 7 Free
06:20:09
4.2 5 Free
29:24:58
4.1 15 Free
01:19:25
3.2 6 Free
00:45:46
Updated Thu, 07-Nov-2019
2 2 $19.99 Free
09:10:22
4.4 16 Free
01:20:24
4 4 Free
03:51:23
3.8 2 Free
00:40:21
Updated Fri, 23-Aug-2019
3.2 3 Free
02:07:04
Updated Wed, 15-Aug-2018
0 6 Free
02:19:58
Updated Mon, 03-Jun-2019
3.2 3 Free
01:51:26
Updated Tue, 14-Jan-2020
0 13 $99.99 Free
03:04:46
Updated Thu, 23-Jan-2020
4.3 8 Free
01:57:15
Updated Sat, 30-Sep-2017
4.3 3 Free
08:16:39
4.3 13 $174.99 Free
06:41:57
4.1 11 $174.99 Free
07:58:41
4.4 4 $194.99 Free
01:08:54
4 2 Free
01:25:26
4 3 Free
00:31:50
Updated Wed, 08-Jan-2020
3.8 1 Free
02:21:42
0 3 $179.99 Free
02:51:06
3.5 3 Free
02:26:30
Updated Sun, 26-Jan-2020
3.6 2 $99.99 Free
00:36:04
3.4 1 Free
03:10:29
4 9 Free
42:10:51
4.7 29 $199.99 Free
01:55:44
4.3 8 $99.99 Free
01:15:58
3.3 13 $199.99 Free
05:50:21
4.3 118 Free
11:51:39
4.5 110 $199.99 Free
04:00:57
3.9 6 $199.99 Free
27:49:26
4.5 192 $199.99 Free
07:33:47
4.1 6 $19.99 Free
06:20:15
Updated Fri, 05-Oct-2018
3.8 8 $99.99 Free
02:21:45
4.2 4 $199.99 Free
14:28:07
3.9 5 $199.99 Free
02:41:06
4.2 4 $104.99 Free
02:05:43
Updated Mon, 30-Oct-2017
3.7 6 Free
02:34:40
Updated Wed, 06-Dec-2017
4.1 6 $19.99 Free
35:24:16
4.5 181 $189.99 Free
00:00:00
Updated Thu, 25-Apr-2019
4.1 0 $99.99 Free
00:00:00
Updated Sun, 10-May-2020
4.3 0 $19.99 Free
00:00:00
Updated Sun, 26-Apr-2020
4.3 0 Free
00:00:00
4.1 0 Free
00:00:00
4 0 Free
00:00:00
3.7 0 $149.99 Free
00:00:00
3.6 0 $19.99 Free
00:00:00
4.6 0 $29.99 Free
00:00:00
4 0 $194.99 Free
00:00:00
3.9 0 $24.99 Free
00:00:00
4 0 $194.99 Free
00:00:00
4.1 0 $99.99 Free
00:00:00
Updated Thu, 25-Apr-2019
3.9 0 $99.99 Free
00:00:00
Updated Thu, 25-Apr-2019
4 0 $99.99 Free
00:00:00
3.9 0 $24.99 Free
00:00:00
Updated Wed, 19-Feb-2020
4.3 0 $159.99 Free
00:00:00
3.8 0 $19.99 Free
00:00:00
4.2 0 Free
00:00:00
4.6 0 $24.99 Free
00:00:00
4.4 0 $19.99 Free
00:00:00
4 0 $19.99 Free
00:00:00
4.2 0 Free
00:00:00
Updated Thu, 30-May-2019
4.3 0 Free
00:00:00
4.2 0 Free
00:00:00
4.2 0 Free
00:00:00
Updated Tue, 29-Aug-2017
4.4 0 Free
00:00:00
4 0 Free
00:00:00
Updated Mon, 03-Jun-2019
4.3 0 Free
00:00:00
Updated Mon, 16-Nov-2015
4 0 Free
00:00:00
3.5 0 Free
00:00:00
Updated Mon, 05-Jun-2017
4.2 0 Free
00:00:00
Updated Fri, 12-Jan-2018
4.1 0 $199.99 Free
00:00:00
4 0 Free
00:00:00
4.2 0 Free
00:00:00
4.2 0 Free
00:00:00
4 0 $19.99 Free
00:00:00
4 0 $199.99 Free
00:00:00
4.3 0 $199.99 Free
00:00:00
Updated Mon, 23-Dec-2019
3.6 0 $19.99 Free
00:00:00
3.1 0 $199.99 Free
00:00:00
4 0 $149.99 Free
00:00:00
4.1 0 $199.99 Free
00:00:00
4.1 0 Free
00:00:00
4.6 0 $199.99 Free
00:00:00
4.4 0 $199.99 Free
00:00:00
Updated Sat, 31-Mar-2018
4.2 0 $199.99 Free
00:00:00
4.1 0 Free
00:00:00
4 0 $49.99 Free
00:00:00
4 0 Free
00:00:00
4.5 0 $19.99 Free
00:00:00
4.2 0 $29.99 Free
00:00:00
4.2 0 Free
00:00:00
Updated Mon, 17-Dec-2018
4.2 0 Free
00:00:00
4.5 0 $199.99 Free
00:00:00
4.2 0 Free
00:00:00
4.2 0 Free
00:00:00
Updated Sat, 16-Apr-2016
4.4 0 Free
00:00:00
4.1 0 $129.99 Free
00:00:00
Updated Tue, 18-Jul-2017
3.9 0 Free
00:00:00
4 0 $49.99 Free
00:00:00
Updated Fri, 11-Aug-2017
3.9 0 $99.99 Free
00:00:00
4.2 0 Free
00:00:00
4.6 0 Free
00:00:00
4.6 0 $19.99 Free
00:00:00
Updated Mon, 12-Jun-2017
4.1 0 Free
00:00:00
3.7 0 $29.99 Free
00:00:00
Updated Sun, 26-Apr-2015
4 0 $19.99 Free
00:00:00
4.2 0 $194.99 Free
00:00:00
Updated Sun, 07-May-2017
4.3 0 Free
00:00:00
4.4 0 Free
00:00:00
Updated Mon, 09-Sep-2019
4.3 0 $74.99 Free
00:00:00
Updated Wed, 27-Nov-2019
4.1 0 $19.99 Free
00:00:00
4.3 0 Free
00:00:00
4.2 0 Free
00:00:00
4.4 0 $194.99 Free
00:00:00
4.4 0 $94.99 Free
00:00:00
4.3 0 $94.99 Free
00:00:00
4.2 0 Free
00:00:00
4.4 0 Free
00:00:00
Updated Tue, 17-Jan-2017
4.1 0 Free
00:00:00
3.3 0 Free
00:00:00
Updated Wed, 27-Dec-2017
4.4 0 Free
00:00:00
4.3 0 $19.99 Free
00:00:00
Updated Mon, 23-Jul-2018
4.2 0 Free
00:00:00
4.1 0 $144.99 Free
00:00:00
4.1 0 Free
00:00:00
4.1 0 Free
00:00:00
3.9 0 Free
00:00:00
4.1 0 Free
00:00:00
4.1 0 Free
00:00:00
4.3 0 Free
00:00:00
Updated Thu, 27-Jul-2017
4.4 0 Free
00:00:00
4.3 0 $194.99 Free
00:00:00
3.9 0 $19.99 Free
00:00:00
4 0 $19.99 Free
00:00:00
4.2 0 Free
00:00:00
Updated Mon, 10-Feb-2020
4.4 0 Free
00:00:00
3.9 0 Free
00:00:00
4.6 0 $19.99 Free
00:00:00
4.2 0 $154.99 Free
00:00:00
Updated Sat, 24-Feb-2018
4.4 0 $39.99 Free
00:00:00
4.5 0 $19.99 Free
00:00:00
4.3 1 Free
00:00:00
Updated Wed, 20-Dec-2017
4 0 $19.99 Free
00:00:00
Updated Sat, 26-Sep-2015
3.9 0 $19.99 Free
00:00:00
4.3 0 $199.99 Free
00:00:00
4.1 0 Free
00:00:00
Updated Wed, 04-Mar-2015
3.7 0 $19.99 Free
00:00:00
4.4 0 Free
00:00:00
4.1 0 $19.99 Free
00:00:00
Updated Sun, 03-Apr-2016
4.2 0 Free
00:00:00
3.8 0 $99.99 Free
00:00:00
Updated Mon, 07-Sep-2015
3.9 0 $19.99 Free
00:00:00
Updated Mon, 01-Aug-2016
4.3 0 Free
00:00:00
3.9 0 Free
00:00:00
Updated Mon, 06-Jun-2016
4 0 Free
About the instructor
  • 154 Students
  • 32 Courses
+ View more
Start learning and acquire the skills you need!
Student feedback
4.2
Average rating
  • 1%
  • 3%
  • 33%
  • 77%
  • 83%
Comments
Free $199.99
Includes:
  • 03:15:34 On demand videos
  • 57 Lessons
  • Full lifetime access
  • Access on mobile and tv