Autoplay
Autocomplete
Speed
Previous Lecture
Complete and Continue
Practical MySQL
Preliminaries
00-00 Download the Working Files
00-01 System requirements (4:19)
00-02 Introduction (4:42)
01 MySQL Queries and Built-in Functions
01-01 Create database, create table (7:45)
01-02 Insert data (6:53)
01-03 Coding style and convention (5:53)
01-04 Import data from SQL file (2:18)
01-05 Select all records from a table, order and limit results (6:06)
01-06 Select records matching search criteria (6:21)
01-07 Revision - Create new table and insert data with SQL query (7:29)
01-08 Numerical comparison operators (5:48)
01-09 MySQL aggregate functions (4:30)
01-10 MySQL ROUND function (5:22)
01-11 MySQL string functions (8:07)
01-12 MySQL Aliases (3:49)
01-13 Functions within functions (4:10)
01-14 Update existing records (1:34)
01-15 Update part of existing records (4:07)
01-16 Alter table structure - Add columns (3:06)
01-17 Alter table structure - Change datatype (1:16)
01-18 Export data to SQL file (3:55)
01-19 Delete selected records (1:43)
01-20 Delete (drop) columns (1:04)
01-21 Delete all records from a table (2:45)
01-22 Delete (drop) table and database (1:53)
02 Users and Privileges
02-01 Create new MySQL user and assign privileges - localhost (4:53)
02-02 Create new MySQL user and assign privileges - cPanel (4:36)
03 MySQL on the Command Line
03-01 Connecting to MySQL at the Windows Command Prompt (7:43)
03-02 Revision - MySQL queries on the command line (4:27)
03-03 Import and Export Data on the MySQL Command Line (3:01)
03-04 Automation of database maintenance tasks in cPanel (11:08)
04 Relational Database Design
04-01 The problem with flat files (4:51)
04-02 The solution - linking tables (2:35)
04-03 Assignment 1 - Create linking sales table (0:43)
04-04 Solution to Assignment 1 - Linking sales table (2:46)
04-05 Assignment 2 - Insert data into sales table (1:06)
04-06 Solution to Assignment 2 - Insert sales data (2:21)
04-07 Selecting matching records from multiple tables with WHERE AND (4:06)
04-08 Selecting matching records from multiple tables with INNER JOIN (6:22)
04-09 JOIN query syntax with table aliases (4:20)
04-10 Selecting matching records with IN (4:00)
04-11 Creating relationships between tables Primary Key and Foreign Key Constraints (8:46)
04-12 Assignment 3 - Create constraint between sales and items tables (0:48)
04-13 Solution to Assignment 3 - Sales items item_id constraint (1:58)
04-14 Constraint action SET NULL (7:52)
04-15 Constraint action RESTRICT or NO ACTION (5:05)
04-16 Set constraint when creating table (4:54)
05 Stored Procedures
05-01 Introduction to MySQL stored procedures (4:15)
05-02 Create MySQL stored procedure in SQL input box (4:52)
05-03 Security settings for stored procedures (8:47)
05-04 IN parameters in stored procedures (5:57)
05-05 SQL wildcards in stored procedures (2:24)
05-06 OUT parameters in stored procedures (5:31)
05-07 INOUT parameters in stored procedures (2:43)
05-08 Assignment 4 - Insert, update and delete in stored procedures (1:22)
05-09 Solutions to Assignment 4 - Insert (2:34)
05-10 Solutions to assignment 4 - Update (2:22)
05-11 Solutions to Assignment 4 - Delete (0:55)
06 Automation with MySQL Triggers
06-01 Introduction to MySQL triggers (3:33)
06-02 Trigger after insert (6:17)
06-03 Assignment 5 - Trigger after delete (1:16)
06-04 Solution to Assignment 5 (2:17)
07 User-defined Functions
07-01 Introduction to user-defined functions (6:49)
07-02 Assignment 6 - Create a User-Defined Function (0:49)
07-03 Solution to Assignment 6 - Create a user-defined function (7:49)
08 MySQL Views
08-01-Introduction to MySQL Views (2:46)
08-02 Assignment 7 - Create view to display price with tax (0:18)
08-03 Solution to Assignment 7 – Create view to display price with tax (1:00)
08-04 Create view in dialog box (2:59)
09 Automation with Events
09-01 Introduction to events (3:28)
09-02 Events on the command line (3:14)
09-03 Assignment 8 - Create an event on the command line (0:14)
09-04 Solution to Assignment 8 - Create an event on the command line (1:32)
10 MySQL in PHP
10-01 Create project directory (3:06)
10-02 Database connection script with PDO (5:03)
10-03 Controlling error messages with try – catch (2:04)
10-04 Displaying all records in the browser (5:28)
10-05 Create path to include files (3:23)
10-06 Coding a simple search form (3:25)
10-07 Returning the results of a search (4:49)
10-08 Assignment 9 - Search with partial matching (0:29)
10-09 Solution to Assignment 9 - Search with partial matching (2:03)
10-10 Delete data via the browser (6:22)
10-11 Assignment 10 - Insert new record via the browser (0:56)
10-12 Solution to Assignment 10 - Insert new record (2:09)
10-13 Update existing data via the browser (1) (5:39)
10-14 Update existing data via the browser (2) (3:38)
10-15 Update existing data via the browser (3) (4:33)
10-16 Assignment 11 - Update existing data via the browser in one file (1:06)
10-17 Solution to Assignment 11 - Updating data via the browser in one file (3:20)
10-18 Update multiple fields via the browser (6:06)
10-19 Update multiple fields and multiple records (1) (5:19)
10-20 Update multiple fields and multiple records (2) (6:57)
11 Course Conclusion
11-01 Course conclusion (2:14)
Appendix 01 Install & Configure XAMPP
Apx 01-01 Download & Install XAMPP (10:21)
Apx 01-02 Troubleshooting XAMPP installation (1) (2:54)
Apx 01-03 Troubleshooting XAMPP installation (2) (7:50)
Appendix 02 Download & Install Komodo Edit
Download and install Komodo Edit (2:51)
01-17 Alter table structure - Change datatype
Discussion
0
comments
Load more
0 comments