PHP & MySQL Certification
4.3 (12 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
143 students enrolled

PHP & MySQL Certification

Get certified as a PHP/MySQL developer and learn about Hashing, MVC, CRUD operations and how to avoid MySQL Injection.
4.3 (12 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
143 students enrolled
Created by George Zafiris
Last updated 1/2020
English
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • 2 Practice Tests
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Learn or advance existing knowledge of PHP
  • Learn or advance MySQL query construction
  • Will engage and learn typical programming conventions
  • How to avoid MySQL Injection and shield your website from it
  • How to encrypt data and store it into a database
  • Learn about CRUD operations (Create, Read, Update, Delete)
  • Get familiar with basic OOP (Object Oriented Programming) concepts
  • Learn how to create a layout for your code logic
  • Design and Prototyping techniques
  • The MVC Design Pattern (Model-View-Controller)
  • How to scale up their existing PHP skills to become industry ready professionals
Course content
Expand all 14 lectures 02:15:25
+ PHP Basics
5 lectures 39:59

In this lecture I talk about how to use and define variables and arrays and how to display them properly inside html using php. This is a very basic yet completely necessary step for what will follow.

Preview 05:46
Quiz on Variables
2 questions

Complete introduction on how to use if statements to assign logic and control the flow of your applications.

Preview 09:20
Quiz on Conditionals
3 questions
Looping Intro & Scenario
09:26
Quiz on Looping
2 questions
Basic Functions & How To Display HTML Dynamically
10:29
Quiz on Functions
2 questions
How To Create & Use Your Own Library
04:58
Quiz on Libraries
2 questions
+ Database Interaction with MySQL
2 lectures 21:55
CRUD Operations - Part One (Insert)
13:11
Quiz on CRUD (I)
2 questions
CRUD Operations - Part Two (Select, Update, Delete)
08:44
Quiz on CRUD (II)
4 questions
+ Object Oriented Programming (OOP)
3 lectures 30:34
Object Oriented Programming - Introduction
07:00
Object Oriented Programming - Setters/Getters & Inheritance
10:08
Object Oriented Programming - Product Scenario
13:26
Quiz on OOP
3 questions
+ Outro - Log In/Sign Up System
3 lectures 37:12
Login & Sign Up System Part One
19:21
Login & Sign Up System Part Two
12:24
Bonus - 3XD (Developer's Design Doc)
05:27
+ The MVC Design Pattern (Model/View/Controller)
1 lecture 05:45

A simplistic review of the MVC design pattern with all the important details you should know.

Understand the MVC (Simplistic Review)
05:45
Quiz on the MVC Design Pattern
5 questions
+ Backend Certification - Exams
0 lectures 00:00

In this test you'll have to answer 20 questions within 5 minutes. Read carefully and choose the best possible answer. The time giver is more than enough for you to focus. You'll have to score above 65% to pass this test.

Backend Certification (PHP)
20 questions
Advanced PHP Certification Test
10 questions
Requirements
  • Some knowledge (but not required to have) of PHP and MySQL
  • A code editor of your choice (Sublime or Visual Studio Code recommended)
  • Eager to learn and advance your skills
  • Active Internet connection & a web server to work with (e.g. XAMMP, UwAmp, Uniform Server Zero)
Description

In this course you'll learn all the things you need know for you to become a great backend developer, operating with PHP & MySQL, the most commonly used yet fundamental technologies since the creation of the internet.

  • You'll understand programming concepts through actual lectured mini real life examples

  • You'll learn about MySQL injection and how to protect your website from it

  • How you should prepare you statements and your overall architecture

  • Design patterns and programming conventions that let you code clearly

  • How to setup DB interactions using OOP (Object Oriented Programming)

  • How to create a Login/Sign up system from scratch using the OOP model

  • Work with sessions to keep users active even when they're not present in the website

  • You'll learn about the Model - View - Controller design pattern via a rather unique and simplistic review

This course represents an abstract prototype of PHP web development methodologies, which you can use and build upon them once you've acquired the proper grasp. Once you learn about the basics, you can move forward to more intermediate concepts such as working and interacting with a basic MySQL database and performing the absolute necessary queries.

The moment you can do this, you can build your code logic to present the information to the user. You can build forms, subscription logic, login systems, fetch records and display them in any way you deem fit, building projects such as e-shops, blogs and even your own CMS systems. Because this is when you truly know how to use and create interactive content. Creating interactive content, it means the user can perform even more tasks and thus stay and interact with your application longer. Upside to this is that you can further build the user's experience (UX) by introducing new concepts when otherwise wouldn't be possible on a static web page.

The rule of thumb states that the websites you create should have ideal design and be articulate for the user, but even if a website is perfect to these aspects if you have a non-properly working backend, or poor server architecture, you'll going to hit the wall really soon and hard. So make sure you know your PHP back-bone and make proper implementations by always consulting your documentation and design document. This course is for beginners who are eager to move to the next level but they don't know how. The material is well organized and easy to follow, so don't be afraid to write code, make mistakes or ask questions. I'm always open and ready to answer anything you may wish to learn and offer the proper guidance so you can advance to the developer you wish to be!!

Best regards,

Your instructor.

#php_web_development #mysql_development #learn_php #learn_to_code_with_php #object_oriented_programming_php #crud_operations_php #php_login_system #php_mysql_login #mysql_injection #learn_mysql_injection #php_mysql_login #php_mysqli_sign_up #user_experience #ux #mvc #mvc_design_pattern #model_view_controller #themvc

Who this course is for:
  • Intermediate level developers with knowledge in a variety of web technologies
  • Ambitious new coders who want to dive into the world of PHP
  • Programming enthusiasts in web development