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 CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js 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 Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2021-01-20 05:37:15
30-Day Money-Back Guarantee
Development Web Development PHP

PHP and MySQL Expert Certification

Get certified as a PHP/MySQL developer and learn about Hashing, MVC, CRUD operations and how to avoid MySQL Injection.
Rating: 4.1 out of 54.1 (108 ratings)
17,155 students
Created by Karl G. Zafiris
Last updated 9/2020
English
30-Day Money-Back Guarantee

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

6 sections • 14 lectures • 2h 15m total length

  • Preview05:46
  • Quiz on Variables
    2 questions
  • Preview09: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

  • 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 - Introduction
    07:00
  • Object Oriented Programming - Setters/Getters & Inheritance
    10:08
  • Object Oriented Programming - Product Scenario
    13:26
  • Quiz on OOP
    3 questions

  • Login & Sign Up System Part One
    19:21
  • Login & Sign Up System Part Two
    12:24
  • Bonus - 3XD (Developer's Design Doc)
    05:27

  • Understand the MVC (Simplistic Review)
    05:45
  • Quiz on the MVC Design Pattern
    5 questions

  • 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.



Copywriter & Content Supervisor: Katerina Christopoulou

Image credit - Instagram: @chrichridraws

#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

Instructor

Karl G. Zafiris
Web Developer
Karl G. Zafiris
  • 4.1 Instructor Rating
  • 108 Reviews
  • 17,155 Students
  • 1 Course

I'm a professional full stack developer passionate about web technologies, game development, python and differential calculus. I've worked as an independent contractor and a freelancer, completing various niches and large sized projects. I specialize on web development and machine learning, applying various mathematical models to solve real life magnitude problems. I'm also a firm believer of online learning and a veteran student on edX.

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