Duration
2 days
1. Introduction
- Welcome
- What is a Database
- Overview Of MySQL
- Intro to Storage Engines
- Intro Data Types
- 2. Getting Started With MySQL
- Windows Installation
- Linux Installation
- Environment Setup With XAMPP
- Getting started With PHPMyAdmin
- MySQL Workbench
- 3. Planning & Design
- Normalization
- DB Process
- Map Out Structure
- 4. Creating A Database
- Create Tables & Columns
- Importing & Exporting
- Relations & Foriegn Keys
- Junction Tables
- 5. SQL Fundamentals
- Command Line & Inserting Data
- Basic Select Queries
- Updating & Deleting Data
- Aliases & Joins
- 6. Advanced SQL
- Union, Concat & Count
- Using The IN Clause
- Math & Subqueries
- Using Group By
- 7. Views and Stored Programs
- Creating a view
- Editing a view
- Creating a stored procedure
- Creating a stored function
- Creating a trigger
- Scheduling events
- 8. PHP & MySQL
- PHP Fundamentals
- Template & MySQL Connect
- Select & Display With PHP
- Insert Data With PHP
- Update & Delete With PHP
- 9. Conclusion
- QA
- Useful Security Resources
Programme scope, delivery arrangements and suitability are confirmed during enquiry.