MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Learn PHP and MySQL for Beginners

Course Summary

Learn PHP and MySQL and get ready to take your web development skills to the next level!


  • +

    Course Syllabus

    • PHP Programming Training Course
      • Course Objectives; PHP Definition, Syntax, Key Words and Tags
      • PHP Development Environment; Whitespace and Comment
      • PHP course exercise files
      • Variables; Exercise 2
      • Echo vs. Print; Single vs. Double Quotes
      • Operators
      • Controlling the Flow of Execution; Exercise 3
      • Repeating Codes; Exercise 4
      • Debugging PHP; Scaffolding Code
      • Arrays; Exercise 5
      • Functions - Part 1
      • Functions - Part 2; Exercise 6
      • External PHP
      • 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
      • Inheritance Demo
      • Exercise 9
      • Common Threats
      • 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
      • SQL Statement
      • Select Statement Demo - Part 1
      • Table Joins and Union
      • Select Statement Demo - Part 2
      • Joins Demo
      • Insert, Update and Delete Commands; Aggregate Functions
      • Queries and Store Procedure
      • Design Pattern Categories
      • Singleton Pattern Demo
      • Observer Pattern Demo
      • PHP Programming Quiz
    • MySQL Training Course
      • Course Review
      • Course Outline and Intro to MySQL and Database
      • MySQL Architecture and Installation of MySQL
      • Installation Demo - Part 1
      • Installation Demo - Part 2
      • Database Design
      • 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
      • Performance Monitoring
      • InnoDB Indexing and Clustered vs. Unclustered Index
      • Query and Where Clause
      • Impact of Indexing on Database Performance
      • Performance Optimization
      • Char vs. Varchar Data Types; Create, Alter and Drop Keywords; Views and Triggers
      • Data Definition Language; How to Create Database Objects
      • SQL Select Statements
      • SQL Select Statements Demo
      • Joins
      • Combining Related Table Using Joins
      • Insert, Update and Delete Commands
      • Insert, Update, and Delete Commands Demo
      • Query Optimization
      • Query Optimization Demo
      • Database Replication
      • Setting Up Replication in MySQL
      • Data Encryption
      • High Availability
      • Course Wrap-up
      • Column-Level Database Encryption Demo
      • MySQL Quiz


Course Fee:
USD 97

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top