Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
100 Videos (6h 38m)
    • Promo Video

      4:27
    • System requirements

      4:19
    • Introduction

      4:42
    • Create database, create table

      7:43
    • Insert data

      6:51
    • Coding style and convention

      5:51
    • Import data from SQL file

      2:17
    • Select all records from a table, order and limit results

      6:04
    • Select records matching search criteria

      6:19
    • Revision Create new table and insert data with SQL query

      7:27
    • Numerical comparison operators

      5:48
    • MySQL aggregate functions

      4:30
    • MySQL ROUND function

      5:22
    • MySQL string functions

      8:05
    • MySQL Aliases

      3:49
    • Functions within functions

      4:08
    • Update existing records

      1:34
    • Update part of existing records

      4:07
    • Alter table structure Add columns

      3:06
    • Alter table structure Change datatype

      1:16
    • Export data to SQL file

      3:54
    • Delete selected records

      1:43
    • Delete (drop) columns

      1:04
    • Delete all records from a table

      2:45
    • Delete (drop) table and database Youtube

      2:38
    • Delete (drop) table and database

      1:53
    • Create new MySQL user and assign privileges localhost

      4:53
    • Create new MySQL user and assign privileges cPanel

      4:36
    • Connecting to MySQL at the Windows Command Prompt

      7:43
    • Revision MySQL queries on the command line

      4:27
    • Import and Export Data on the MySQL Command Line

      3:01
    • Automation of database maintenance tasks in cPanel

      11:08
    • The problem with flat files

      4:51
    • The solution - Linking tables

      2:35
    • Assignment 1 - Create linking sales table

      0:43
    • Solution to Assignment 1 - Linking sales table

      2:46
    • Assignment 2 - Insert data into sales table

      1:06
    • Solution to Assignment 2 - Insert sales data

      2:21
    • Selecting matching records from multiple tables with WHERE AND

      4:06
    • Selecting matching records from multiple tables with INNER JOIN

      6:22
    • JOIN query syntax with table aliases

      4:20
    • Selecting matching records with IN

      4:00
    • Creating relationships between tables Primary Key and Foreign Key Constraints

      8:46
    • Assignment 3 - Create constraint between sales and items tables

      0:24
    • Solution to Assignment 3 - Sales items item id constraint

      1:58
    • Constraint action SET NULL

      7:52
    • Constraint action RESTRICT or NO ACTION

      5:05
    • Set constraint when creating table

      4:54
    • Introduction to MySQL stored procedures

      4:13
    • Create MySQL stored procedure in SQL input box

      4:52
    • Security settings for stored procedures

      8:47
    • IN parameters in stored procedures

      5:57
    • SQL wildcards in stored procedures

      2:24
    • OUT parameters in stored procedures

      5:31
    • INOUT parameters in stored procedures

      2:43
    • Assignment 4 - Insert, update and delete in stored procedures

      1:22
    • Solutions to Assignment 4 Insert

      2:34
    • Solutions to assignment 4 Update

      2:22
    • Solutions to Assignment 4 Delete

      0:55
    • Introduction to MySQL triggers

      3:33
    • Trigger after insert

      6:15
    • Assignment 5 - Trigger after delete

      1:16
    • Solution to Assignment 5

      2:17
    • Introduction to user defined functions

      6:49
    • Assignment 6 - Create a User Defined Function

      0:49
    • Solution to Assignment 6 Create a user defined function

      7:49
    • Introduction to MySQL Views

      2:46
    • Assignment 7 - Create view to display price with tax

      0:18
    • Solution to Assignment 7 – Create view to display price with tax

      1:00
    • Create view in dialog box

      2:59
    • Introduction to events

      3:28
    • Events on the command line

      3:14
    • Assignment 8 - Create an event on the command line

      0:14
    • Solution to Assignment 8 Create an event on the command line

      1:32
    • Create project directory

      3:06
    • Database connection script with PDO

      5:01
    • Controlling error messages with try – catch

      2:03
    • Displaying all records in the browser

      5:28
    • Create path to include files

      3:23
    • Coding a simple search form

      3:25
    • Returning the results of a search

      4:47
    • Assignment 9 - Search with partial matching

      0:29
    • Solution to Assignment 9 Search with partial matching

      2:03
    • Delete data via the browser

      6:20
    • Assignment 10 - Insert new record via the browser

      0:56
    • Solution to Assignment 10 Insert new record

      2:09
    • Update existing data via the browser (1)

      5:39
    • Update existing data via the browser (2)

      3:37
    • Update existing data via the browser (3)

      4:33
    • Assignment 11 - Update existing data via the browser in one file

      0:38
    • Assignment 11 - Demonstration

      0:28
    • Solution to Assignment 11 Updating data via the browser in one file

      3:20
    • Update multiple fields via the browser

      6:06
    • Update multiple fields and multiple records (1)

      5:19
    • Update multiple fields and multiple records (2)

      6:57
    • Course conclusion

      2:14
    • Download & Install XAMPP

      10:21
    • Troubleshooting XAMPP installation (1)

      2:53
    • Troubleshooting XAMPP installation (2)

      7:50
    • Download and install Komodo Edit

      2:51

About This Class

MySQL is the most widely used open source database system in the world, making a thorough knowledge of MySQL a vital skill for every web developer.

This is a highly practical course, which concentrates on teaching you exactly what you need to know, first to get up and running and then to master MySQL in action. The course moves from simple queries to much more advanced topics - more advanced than many MySQL administrators need to do their job!

Topics include:

  • MySQL in phpMyAdmin, on the command line, and in PHP scripts
  • MySQL queries
  • built-in MySQL functions
  • users and privileges
  • relational database design
  • preserving data integrity with constraints
  • automation with stored procedures, triggers and scheduled events
  • customisation with user-defined functions (UDFs) and views
  • MySQL in PHP with PDO and named parameters
  • a variety of create-read-update-delete (CRUD) projects in PHP

You can see the full curriculum below.

The course is flexibly designed, with Working Files which make it suitable for learners with a range of existing knowledge or for complete beginners – if you do not need to start at the beginning of the course then it is easy to look through the code and dive straight in at any point to speed things up.

4

Students

--

Projects

0

Reviews (0)

Richard Stibbard

Clarity and quality in online education

My name is Dr Richard Stibbard and I have been working in back-end web development since 2006, building custom database-driven websites from scratch, as well as customizing Moodle sites. Before that, I was a lecturer at the University of Surrey, where I pioneered the use of the online learning platform WebCT Vista (later Blackboard) in my department's distance education programme.

I thus bring to my courses a wealth of expertise not just in the technical aspects of the subjects I teach...

See full profile