This training in Web Application Development with PHP and MySQL It immerses you in the exciting world of dynamic web programming and database management with MySQL. As the demand for interactive and functional web applications continues to grow, master these technologies becomes a valuable asset in the world of work. You will learn how to design efficient database structures, run complex queries and use graphical user interface tools to manage your databases effectively. You will explore the basics of PHP and how to connect your web application to a MySQL database. You will also learn how to handle forms, sessions and common techniques in web development.
Sector-specific
Programme
25 hours
Web Application Development with PHP and MySQL
Programme
25 hours
Introduction
Objectives
-
Understanding the MySQL basics and its importance in web development.
-
Learn how to design and manage MySQL databases efficiently.
-
Mastering the creating and editing tables and data in MySQL.
-
Develop dynamic web applications using PHP and MySQL effectively.
Table of Contents
TEACHING UNIT 1. BASICS OF MYSQL
1. Introduction to MySQL
2. MySQL Server and Client
3. Fundamentals of databases
4. Fundamentals of database design
5. Table data types
6. Creating databases and tables
7. Fundamentals of consultations
8. Maintenance of databases and tables
9. Working with tables
10. Functions
11. Exporting and importing data
12. Joining tables
13. Sub-queries
14. Graphical user interface tools
15. Further information
TEACHING UNIT 2. DEVELOPING DYNAMIC WEB APPLICATIONS USING MYSQL AND PHP
1. LAMP
2. The basics of PHP
3. PHP connections to MySQL
4. Links between tables
5. SQL DML
6. Forms
7. Joints
8. Session management
9. Common techniques
TEACHING UNIT 3. MySQL FOR DEVELOPERS
1. Client-server concepts
2. MySQL Clients
3. MySQL connectors and APIs
4. Data types
5. SQL expressions
6. Retrieve Metadata
7. Databases
8. Tables
9. Manipulating data in tables
10. Transactions
11. Joint tables
12. Sub-queries
13. Views
14. Judgements
15. Storage procedures
16. Triggers
17. Error and alert management
18. Optimisation
More related courses
Sector-specific
Sector-specific
Sector-specific