Section 1 : Preliminaries
1
Download the Working Files
2
Intro Preview
3
System requirements
4
Introduction

  Section 2 : MySQL Queries and Built-in Functions
5
Create database create table
6
Insert data Preview
7
Coding style and convention
8
Import data from SQL file
9
Select all records from a table order and limit results Preview
10
Select records matching search criteria
11
Revision - Create new table and insert data with SQL query
12
Numerical comparison operators Preview
13
MySQL aggregate functions
14
MySQL ROUND function
15
MySQL string functions
16
MySQL Aliases
17
Functions within functions Preview
18
Update existing records
19
Update part of existing records
20
Alter table structure - Add columns
21
Alter table structure - Change datatype
22
Export data to SQL file
23
Delete selected records
24
Delete (drop) columns
25
Delete all records from a table Preview
26
Delete (drop) table and database

  Section 3 : Users and Privileges
27
Create new MySQL user and assign privileges - localhost
28
Create new MySQL user and assign privileges - cPane

  Section 4 : MySQL on the Command Line
29
Connecting to MySQL at the Windows Command Prompt
30
Revision - MySQL queries on the command line
31
Import and Export Data on the MySQL Command Line
32
Automation of database maintenance tasks in cPanel

  Section 5 : Relational Database Design
33
The problem with flat files
34
The solution - linking tables
35
Assignment 1 - Create linking sales table
36
Solution to Assignment 1 - Linking sales table
37
Assignment 2 - Insert data into sales table
38
Solution to Assignment 2 - Insert sales data
39
Selecting matching records from multiple tables with WHERE AND
40
Selecting matching records from multiple tables with INNER JOIN
41
JOIN query syntax with table aliases
42
Selecting matching records with IN
43
Creating relationships between tables Primary Key and Foreign Key Constraints
44
Assignment 3 - Create constraint between sales and items tables
45
Solution to Assignment 3 - Sales items item_id constraint
46
Constraint action SET NULL
47
Constraint action RESTRICT or NO ACTION
48
Set constraint when creating table

  Section 6 : Stored Procedures
49
Introduction to MySQL stored procedures
50
Create MySQL stored procedure in SQL input box
51
Security settings for stored procedures
52
IN parameters in stored procedures
53
SQL wildcards in stored procedures
54
OUT parameters in stored procedures
55
INOUT parameters in stored procedures
56
Assignment 4 - Insert, update and delete in stored procedures
57
Solutions to Assignment 4 - Insert
58
Solutions to assignment 4 - Update
59
Solutions to Assignment 4 - Delete

  Section 7 : Automation with MySQL Triggers
60
Introduction to MySQL triggers
61
Trigger after insert
62
Assignment 5 - Trigger after delete
63
Solution to Assignment 5

  Section 8 : User-defined Functions
64
Introduction to user-defined functions
65
Assignment 6 - Create a User-Defined Function
66
Solution to Assignment 6 - Create a user-defined function

  Section 9 : MySQL Views
67
Introduction to MySQL Views
68
Assignment 7 - Create view to display price with tax
69
Solution to Assignment 7 Create view to display price with tax
70
Create view in dialog box

  Section 10 : Automation with Events
71
Introduction to events
72
Events on the command line
73
Assignment 8 - Create an event on the command line
74
Solution to Assignment 8 - Create an event on the command line

  Section 11 : MySQL in PHP
75
Create project directory
76
Database connection script with PDO
77
Controlling error messages with try catch
78
Displaying all records in the browser
79
Create path to include files
80
Coding a simple search form
81
Returning the results of a search
82
Assignment 9 - Search with partial matching
83
Solution to Assignment 9 - Search with partial matching
84
Delete data via the browser
85
Assignment 10 - Insert new record via the browser
86
Solution to Assignment 10 - Insert new record
87
Update existing data via the browser (1)
88
Update existing data via the browser (2)
89
Update existing data via the browser (3)
90
Assignment 11 - Update existing data via the browser in one file 1
91
Assignment 11 - Update existing data via the browser in one file 2
92
Solution to Assignment 11 - Updating data via the browser in one file
93
Update multiple fields via the browser
94
Update multiple fields and multiple records (1)
95
Update multiple fields and multiple records (2)

  Section 12 : Course Conclusion
96
Course conclusion

  Section 13 : Appendix 01 Install & Configure XAMPP
97
Apx 01-01 Download & Install XAMPP
98
Apx 01-02 Troubleshooting XAMPP installation (1)
99
Apx 01-03 Troubleshooting XAMPP installation (2)

  Section 14 : Appendix 02 Download & Install Komodo Edit
100
Download and install Komodo Edit