Learn PHP and MySQL for Beginners the Easy Way - 13 Hours
3.3 (21 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
3,907 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn PHP and MySQL for Beginners the Easy Way - 13 Hours to your Wishlist.

Add to Wishlist

Learn PHP and MySQL for Beginners the Easy Way - 13 Hours

Learn PHP and MySQL and get ready to take your web development skills to the next level!
3.3 (21 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
3,907 students enrolled
Created by Simon Sez IT
Last updated 1/2017
English
English [Auto-generated]
Current price: $10 Original price: $150 Discount: 93% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 12 hours on-demand video
  • 3 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • By the end of the course, you will have a foundation of PHP and MySQL knowledge
  • Discover how to use PHP variables
  • How to debug PHP code
  • Learn how to read a configuration file
  • Discover the basics of using a PHP library
  • Common security threats
  • Understanding MySQL architecture and installation of MySQL
  • Learning database design
  • Administration of a database
  • Using indexing for database performance
  • Discover SQL for Developers
  • Understanding query analysis and optimization
  • Setting up replication in MySQL
View Curriculum
Requirements
  • A text editor and a passion for learning.
Description

Discover how to use PHP and MySQL, a popular choice for developing powerful web applications!

These days, you’re nowhere without a website, so there’s a huge value to web development skills. PHP is one of the most widely-used scripting languages around, and this course will help you master the basics of the language so that you can build your own website, or help refine your company’s. Discover the power of PHP as you take your website development skills to the next level.

During the 6.5 hour PHP beginner course, discover the fundamental concepts beginner PHP developers need to master. Your professional instructor combines practical lectures that ensure you have a solid grasp of the basics with coding examples that include exercise files so you get real hands-on practice.

Follow along as you learn the PHP syntax, development environment, and other basic concepts. Discover more advanced topics including database storage, object oriented development, using the standard PHP library, and basic SQL language commands.

This course includes exercise example files, certificate of completion, and quiz.

During the 5.5-hour MySQL beginner course, discover the fundamental concepts beginner MySQL administrators need to master. Your professional instructor combines practical lectures that ensure you have a solid grasp of the basics with practical examples that include exercise files so you get real hands on practice.

Follow along as you learn how to install MySQL for the first time. Discover critical concepts for designing a database. Explore how to administrate a MySQL database including limiting access, creating users, database backup and performance monitoring. Then get ready to take your MySQL skills to the next level as you learn SQL for developers, database replication, data encryption and more.

This course includes a certificate of completion, and quiz.

*Updated July 2017: Close captions in English added.

Who is the target audience?
  • Anyone new to PHP
  • Anyone new to databases
  • Web developers
Students Who Viewed This Course Also Viewed
Curriculum For This Course
85 Lectures
12:09:26
+
PHP Programming Training Course
44 Lectures 06:31:23

Essential Information for a Successful Training Experience
01:36

PHP course exercise files
00:25


Variables; Exercise 2
11:00


Operators
11:28

Controlling the Flow of Execution; Exercise 3
11:18

Repeating Codes; Exercise 4
11:42


Arrays; Exercise 5
10:55

Functions - Part 1
11:39

Functions - Part 2; Exercise 6
13:52


Runtime Error Handling
10:34

Reading and Writing to a File
11:53

Reading a Configuration File; Exercise 7
08:07

Form Processing; Cookies and Sessions Superglobals; Exercise 8
10:04

Database Storage - Part 1
05:04

Database Storage - Part 2
12:33

Object-Oriented Development - Part 1
13:01

Object-Oriented Development - Part 2
13:02

Object-Oriented Development - Part 3
04:37

Inheritance Demo
13:38

Exercise 9
01:59

Common Threats
02:44

Security Demo and Exercise 10
12:53

PHP Built-in Constants and Standard PHP Library
12:34

Standard PHP Library Demo - Part 1
10:13

Standard PHP Library Demo - Part 2
07:10

SPL Data Structures and Exception Types
08:44

SPL Data Structures Demo
14:57

SPL Exception Types Demo; Exercise 11
08:06

Relational Database Management Systems and SQL Language
05:50

SQL Statement
07:48

Select Statement Demo - Part 1
14:13

Table Joins and Union
05:36

Select Statement Demo - Part 2
14:47

Joins Demo
04:08

Insert, Update and Delete Commands; Aggregate Functions
08:01

Queries and Store Procedure
05:58

Design Pattern Categories
06:12

Singleton Pattern Demo
08:52

Observer Pattern Demo
06:52

PHP Programming Quiz
40 questions
+
MySQL Training Course
41 Lectures 05:38:13

Essential Information for a Successful Training Experience
01:17

Course Review
00:43



Installation Demo - Part 2
09:37

Database Design
08:46

MySQL Workbench Download
07:34

Database Table and Constraints
09:39

Database Designing and Normalization - Part 1
11:51

Database Designing and Normalization - Part 2
08:10

Storage and Data Types
05:25

Data Types Demo
11:20

ACID and Transactions
09:44

Locks, Deadlocks, Isolation Levels and Logging
07:16

Isolation Levels and Locking Demo
12:43

Locking Mechanism Demo and MySQL ACID Support
06:22

Responsibilities of a Database Administrator
03:41

Creating a User and Limiting Access to a Database; Basic Maintainance Function
10:34

Protecting your Database; How to Perform Database Backup
07:44

Performance Monitoring
10:49

InnoDB Indexing and Clustered vs. Unclustered Index
14:17

Query and Where Clause
05:28

Impact of Indexing on Database Performance
10:33

Performance Optimization
07:49

Char vs. Varchar Data Types; Create, Alter and Drop Keywords; Views and Triggers
13:16

Data Definition Language; How to Create Database Objects
12:27


SQL Select Statements Demo
10:19

Joins
05:36

Combining Related Table Using Joins
16:06

Insert, Update and Delete Commands
06:08

Insert, Update, and Delete Commands Demo
08:47

Query Optimization
03:40

Query Optimization Demo
06:39

Database Replication
06:39

Setting Up Replication in MySQL
04:57

Data Encryption
05:13

High Availability
10:43

Course Wrap-up
04:08

Column-Level Database Encryption Demo
04:44

MySQL Quiz
40 questions
About the Instructor
Simon Sez IT
4.4 Average rating
12,238 Reviews
307,200 Students
117 Courses
300,000+ Students | Wordwide Use 180 Countries |120+ Courses

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With 80+ courses and 4,500+ video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 300,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.