Beginner PHP and MySQL Tutorial free 100%

Beginner PHP and MySQL Tutorial

Take it now!

Learn PHP and MySQL and start developing web apps like a pro! This course also comes with a Certificate of Completion.

Price: Free
Save Off: 100%
Offer expires: Limited Time

---

Course Description

A Verifiable Certificate of Completion is presented to all students who undertake this course.

PHP and MySQL are incredibly powerful open source technologies that allow people to create functional websites and apps that go way beyond basic HTML. While it can seem intimidating to someone with no background in coding, working with PHP is much easier than many realize. With the right guidance and a desire to learn, most people can learn how to put together a functional web app in a few days!

This PHP / MySQL Tutorial Video Course is narrated by Robert Tucker, a long-time trainer, lecturer and consultant who specializes in helping people learn how to use technology to solve real world problems. In this high-impact course, Robert walks users through the creation of a functional PHP / MySQL interface from beginning to end, explaining where needed the important technical points without relying on excessive jargon. This is not an overview of complex theory, but a hands-on primer that will allow even beginners to create usable solutions quickly!

Robert shows you how to make the most from these free technologies used by everyone from small startups to the biggest technology companies in the world.

Full details

What am I going to get from this course?

• How to download and install PHP and MySQL tools and frameworks onto a server and home machine.
• How to configure relevant setting to match the needs of your project.
• How to work between a user interface and a database back-end that stores critical information.
• How to plan and apply PHP and MySQL to specific examples and finally your own real world projects.

What is the target audience?

• Anyone who wants to build a website that goes beyond the requirements of basic HTML and CSS.
• Anyone who wants to learn how to build an app that can handle data and interface with end users at the same time.
• Anyone who wants to learn how MySQL can function as a database solution.
• Anyone who wants to learn basic programming and development skills without days of digging through technical books.

Full details

Curriculum

Section 1: Intro to Beginners PHP
	Lecture 1	Working Files - Download These First	Article
	Lecture 2	Intro - What This Course Covers	01:42
	Lecture 3	What We Need	06:19
Section 2: Getting Started
	Lecture 4	Introducing XAMPP	00:39
	Lecture 5	Downloading XAMPP	00:59
	Lecture 6	XAMPP - Installing	01:55
	Lecture 7	XAMPP - Setting Up	02:19
	Lecture 8	Setting Up A PHP Editor - bluefish	02:34
	Lecture 9	Introduction To bluefish	02:49
	Lecture 10	The bluefish Interface	03:13
	Lecture 11	bluefish Summary	00:36
	Lecture 12	Downloading PHP Snippets	02:31
	Lecture 13	PHP Comments	04:19
	Lecture 14	Our First PHP Page	05:01
	Lecture 15	Using PHP Snippets	05:22
	Lecture 16	Intro To MySQL Databases	03:14
	Lecture 17	Into To phpMyAdmin	05:20
	Lecture 18	External Helpful Resources	00:42
	Lecture 19	Exercises	01:07
Section 3: Our First Look At MySQL And PHP
	Lecture 20	Connecting To A MySQL Database - Part 1	06:00
	Lecture 21	Connecting To A MySQL Database - Part 2	02:59
	Lecture 22	Our First MySQL Query - Part 1	06:21
	Lecture 23	Our First MySQL Query - Part 2	05:09
	Lecture 24	Creating A MySQL Database	04:08
	Lecture 25	Create MySQL Tables - Part 1	03:37
	Lecture 26	Create MySQL Tables - Part 2	05:16
	Lecture 27	Database Structure	05:40
	Lecture 28	Inserting Data in MySQL	05:46
	Lecture 29	Updating MySQL Tables	02:39
	Lecture 30	Updating MySQL Tables Example	03:04
	Lecture 31	MySQL Delete Command	06:44
	Lecture 32	Intro To Variables And Operators	04:05
	Lecture 33	Arithmetic Operators	03:38
	Lecture 34	Assignment Operators	05:24
	Lecture 35	Comparison Operators	04:14
	Lecture 36	Introduction To Arrays	03:18
	Lecture 37	Numeric Arrays	02:24
	Lecture 38	Associative Arrays	04:08
	Lecture 39	Multi-Dimensional Arrays	06:29
	Lecture 40	Creating And Working With Arrays	04:20
	Lecture 41	Creating Arrays From A Text File	07:18
	Lecture 42	Lesson Review	01:22
Section 4: Outputting And Processing Data
	Lecture 43	Hiding Sensitive Data	01:57
	Lecture 44	Including Sensitive Data	04:04
	Lecture 45	PHP Echo And Quotes - Part 1	05:13
	Lecture 46	PHP Echo And Quotes - Part 2	04:53
	Lecture 47	Formatting Using sprintf	05:49
	Lecture 48	Outputting Tabular Data	04:58
	Lecture 49	Outputting Data And Time	05:31
	Lecture 50	Introduction To Loops	02:21
	Lecture 51	do...while Loops	01:51
	Lecture 52	Repetition - for Loops	01:55
	Lecture 53	Repetition - foreach Loops	04:07
	Lecture 54	MySQL Select	04:31
	Lecture 55	Formatting Outputted MySQL Data	02:03
	Lecture 56	MySQL Joins - Overview	03:58
	Lecture 57	MySQL Joins	03:31
	Lecture 58	MySQL Where And Order By	06:55
Section 5: Dealing With Variables
	Lecture 59	Intro To Sending Variables	01:47
	Lecture 60	Using Variables With GET	07:57
	Lecture 61	Using Variables With POST	03:27
	Lecture 62	Inserting Sent Data In A Database	07:13
	Lecture 63	Updating A Database With Sent Data - Part 1	03:14
	Lecture 64	Updating A Database With Sent Data - Part 2	05:11
	Lecture 65	Redirection In PHP	04:02
	Lecture 66	Creating A List - Example	06:32
	Lecture 67	Styling The List - Example	04:48
	Lecture 68	What We Have Learned	01:08
Section 6: Inserting And Using Database Data
	Lecture 69	Using One Page To Process Forms - Part 1	02:07
	Lecture 70	Using One Page To Process Forms - Part 2	04:08
	Lecture 71	Multi Part Forms	03:58
	Lecture 72	Save And Return POST and GET	02:58
	Lecture 73	Save And Return INSERT	01:50
	Lecture 74	Save And Return UPDATE	03:02
	Lecture 75	Normalization	04:01
	Lecture 76	Simple Drop Downs	04:19
	Lecture 77	Complex Drop Downs	03:58
	Lecture 78	Revised Form - The Code	04:54
	Lecture 79	Revised Form - The Result	02:50
	Lecture 80	Lesson Review	00:55
Section 7: MySQL Joins
	Lecture 81	MySQL Join Types - Examples	05:57
	Lecture 82	MySQL Join Diagrams	01:44
	Lecture 83	Creating Nested Lists	04:34
	Lecture 84	MySQL Nested Processing	03:32
	Lecture 85	Styling Our Lists	05:11
	Lecture 86	Intro To Functions	07:34
	Lecture 87	Included Files	08:28
Section 8: PHP Errors And Security
	Lecture 88	Introduction To Security And Errors	01:25
	Lecture 89	Error Types - Databases	08:25
	Lecture 90	PHP Error Types	06:41
	Lecture 91	Custom Error Testing	03:26
	Lecture 92	Create A Login Page	08:12
Full Curriculum