Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: PHP Programming Training Course|
Course Objectives; PHP Definition, Syntax, Key Words and TagsPreview
IMPORTANT - Read this to ensure the best video quality!
PHP Development Environment; Whitespace and CommentPreview
PHP course exercise files
Variables; Exercise 2
Echo vs. Print; Single vs. Double QuotesPreview
Controlling the Flow of Execution; Exercise 3
Repeating Codes; Exercise 4
Debugging PHP; Scaffolding CodePreview
Arrays; Exercise 5
Functions - Part 1
Functions - Part 2; Exercise 6
Runtime Error Handling
Reading and Writing to a File
Reading a Configuration File; Exercise 7
Form Processing; Cookies and Sessions Superglobals; Exercise 8
Database Storage - Part 1
Database Storage - Part 2
Object-Oriented Development - Part 1
Object-Oriented Development - Part 2
Object-Oriented Development - Part 3
Security Demo and Exercise 10
PHP Built-in Constants and Standard PHP Library
Standard PHP Library Demo - Part 1
Standard PHP Library Demo - Part 2
SPL Data Structures and Exception Types
SPL Data Structures Demo
SPL Exception Types Demo; Exercise 11
Relational Database Management Systems and SQL Language
Select Statement Demo - Part 1
Table Joins and Union
Select Statement Demo - Part 2
Insert, Update and Delete Commands; Aggregate Functions
Queries and Store Procedure
Design Pattern Categories
Singleton Pattern Demo
Observer Pattern Demo
PHP Programming Quiz
|Section 2: MySQL Training Course|
Course Outline and Intro to MySQL and DatabasePreview
MySQL Architecture and Installation of MySQLPreview
Installation Demo - Part 1Preview
Installation Demo - Part 2
MySQL Workbench Download
Database Table and Constraints
Database Designing and Normalization - Part 1
Database Designing and Normalization - Part 2
Storage and Data Types
Data Types Demo
ACID and Transactions
Locks, Deadlocks, Isolation Levels and Logging
Isolation Levels and Locking Demo
Locking Mechanism Demo and MySQL ACID Support
Responsibilities of a Database Administrator
Creating a User and Limiting Access to a Database; Basic Maintainance Function
Protecting your Database; How to Perform Database Backup
InnoDB Indexing and Clustered vs. Unclustered Index
Query and Where Clause
Impact of Indexing on Database Performance
Char vs. Varchar Data Types; Create, Alter and Drop Keywords; Views and Triggers
Data Definition Language; How to Create Database Objects
SQL Select StatementsPreview
SQL Select Statements Demo
Combining Related Table Using Joins
Insert, Update and Delete Commands
Insert, Update, and Delete Commands Demo
Query Optimization Demo
Setting Up Replication in MySQL
Column-Level Database Encryption Demo
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,000+ 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 250,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.