Richard Stibbard'S "Practical Mysql"

All the MySQL you need to get you going with working with the database behind a dynamic website.

What you'll learn
Most MySQL queries and built-in functions
MySQL on the command line in Windows
Relational database design - what it is and why we need it
Customisation with user-defined functions and views
Automation with stored procedures and triggers
Connecting to MySQL using PHP/PDO
MySQL queries in PHP with prepared statements and named parameters
Building PHP CRUD (Create-Read-Update-Delete) interfaces to run in the browser
Requirements
No previous knowledge of MySQL required
You will need reasonable knowledge of how to work on a PC running Windows
A browser and an internet connection
You will need to have permission/the ability to download software onto your PC
Some prior experience of web development will be an asset but is not required
Description
ONLY 12 HOURS TO GO BEFORE THIS COURSE IS MADE PRIVATE - SO ENROL NOW TO LEARN MySQL AT THIS INCREDIBLE PRICE!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.

Topics include:
MySQL in phpMyAdmin, on the command line, and in PHP scriptsMySQL queriesbuilt-in MySQL functionsusers and privilegesrelational database designpreserving data integrity with constraintsautomation with stored procedures, triggers and scheduled eventscustomisation with user-defined functions (UDFs) and viewsMySQL in PHP with PDO and named parametersa variety of create-read-update-delete (CRUD) projects in PHP

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.ONLY 12 HOURS TO GO BEFORE THIS COURSE IS MADE PRIVATE - SO ENROL NOW TO LEARN MySQL AT THIS INCREDIBLE PRICE!

Overview

Section 1: Preliminaries

Lecture 1 Download the Working Files

Lecture 2 00-01 System requirements

Lecture 3 00-02 Introduction

Section 2: MySQL Queries and Built-in Functions

Lecture 4 01-01 Create database, create table

Lecture 5 01-02 Insert data

Lecture 6 01-03 Coding style and convention

Lecture 7 01-04 Import data from SQL file

Lecture 8 01-05 Select all records from a table, order and limit results

Lecture 9 01-06 Select records matching search criteria

Lecture 10 01-07 Revision - Create new table and insert data with SQL query

Lecture 11 01-08 Numerical comparison operators

Lecture 12 01-09 MySQL aggregate functions

Lecture 13 01-10 MySQL ROUND function

Lecture 14 01-11 MySQL string functions

Lecture 15 01-12 MySQL aliases

Lecture 16 01-13 Functions within functions

Lecture 17 01-14 Update existing records

Lecture 18 01-15 Update part of existing records

Lecture 19 01-16 Alter table structure - Add columns

Lecture 20 01-17 Alter table structure - Change datatype

Lecture 21 01-18 Export data to SQL file

Lecture 22 01-19 Delete selected records

Lecture 23 01-20 Delete (drop) columns

Lecture 24 01-21 Delete all records from a table

Lecture 25 01-22 Delete (drop) table and database

Section 3: Users and Privileges

Lecture 26 02-01 Create new MySQL user and assign privileges - localhost

Lecture 27 02-02 Create new MySQL user and assign privileges - cPanel

Section 4: MySQL on the Command Line

Lecture 28 03-01 Connecting to MySQL at the Windows Command Prompt

Lecture 29 03-02 Revision - MySQL queries on the command line

Lecture 30 03-03 Import and Export Data on the MySQL Command Line

Lecture 31 03-04 Automation of database maintenance tasks in cPanel

Section 5: Relational Database Design

Lecture 32 04-01 The problem with flat files

Lecture 33 04-02 The solution - linking tables

Lecture 34 04-03 Assignment 1 - Create linking sales table

Lecture 35 04-04 Solution to Assignment 1 - Linking sales table

Lecture 36 04-05 Assignment 2 - Insert data into sales table

Lecture 37 04-06 Solution to Assignment 2 - Insert sales data

Lecture 38 04-07 Selecting matching records from multiple tables with WHERE … AND ,..

Lecture 39 04-08 Selecting matching records from multiple tables with INNER JOIN

Lecture 40 04-09 JOIN query syntax with table aliases

Lecture 41 04-10 Selecting matching records with IN

Lecture 42 04-11 Creating relationships between tables Primary Key/Foreign Key Constraints

Lecture 43 04-12 Assignment 3 - Create constraint between sales and items tables

Lecture 44 04-13 Solution to Assignment 3 - Sales items item_id constraint

Lecture 45 04-14 Constraint action SET NULL

Lecture 46 04-15 Constraint action RESTRICT or NO ACTION

Lecture 47 04-16 Set constraint when creating table

Section 6: Stored Procedures

Lecture 48 05-01 Introduction to MySQL stored procedures

Lecture 49 05-02 Create MySQL stored procedure in SQL input box

Lecture 50 05-03 Security settings for stored procedures

Lecture 51 05-04 IN parameters in stored procedures

Lecture 52 05-05 SQL wildcards in stored procedures

Lecture 53 05-06 OUT parameters in stored procedures

Lecture 54 05-07 INOUT parameters in stored procedures

Lecture 55 05-08 Assignment 4 - Insert, update and delete records in stored procedures

Lecture 56 05-09 Solutions to Assignment 4 - Insert

Lecture 57 05-10 Solutions to assignment 4 - Update

Lecture 58 05-11 Solutions to Assignment 4 - Delete

Section 7: Automation with MySQL Triggers

Lecture 59 06-01 Introduction to MySQL triggers

Lecture 60 06-02 Trigger after insert

Lecture 61 06-03 Assignment 5 - Trigger after delete

Lecture 62 06-04 Solution to Assignment 5

Section 8: User-defined Functions

Lecture 63 07-01 Introduction to user-defined functions

Lecture 64 07-02 Assignment 6 - Create a User-Defined Function

Lecture 65 07-03 Solution to Assignment 6 - Create a user-defined function

Section 9: MySQL Views

Lecture 66 08-01-Introduction to MySQL Views

Lecture 67 08-02 Assignment 7 - Create view to display price with tax

Lecture 68 08-03 Solution to Assignment 7 – Create view to display price with tax

Lecture 69 08-04 Create view in dialog box

Section 10: Automation with MySQL Events

Lecture 70 09-01 Introduction to events

Lecture 71 09-02 Events on the command line

Lecture 72 09-03 Assignment 8 - Create an event on the command line

Lecture 73 09-04 Solution to Assignment 8 - Create an event on the command line

Section 11: MySQL in PHP

Lecture 74 10-01 Create project directory

Lecture 75 10-02 Database connection script with PDO

Lecture 76 10-03 Controlling error messages with try – catch

Lecture 77 10-04 Displaying all records in the browser

Lecture 78 10-05 Create path to include files

Lecture 79 10-06 Coding a simple search form

Lecture 80 10-07 Returning the results of a search

Lecture 81 10-08 Assignment 9 - Search with partial matching

Lecture 82 10-09 Solution to Assignment 9 - Search with partial matching

Lecture 83 10-10 Delete data via the browser

Lecture 84 10-11 Assignment 10 - Insert new record via the browser

Lecture 85 10-12 Solution to Assignment 10 - Insert new record

Lecture 86 10-13 Update existing data via the browser (1)

Lecture 87 10-14 Update existing data via the browser (2)

Lecture 88 10-15 Update existing data via the browser (3)

Lecture 89 10-16 Assignment 11 - Update existing data via the browser in one file

Lecture 90 10-16 Assignment 11 demonstration video

Lecture 91 10-17 Solution to Assignment 11 - Updating data via the browser in one file

Lecture 92 10-18 Update multiple fields via the browser

Lecture 93 10-19 Update multiple fields and multiple records (1)

Lecture 94 10-20 Update multiple fields and multiple records (2)

Section 12: Course Conclusion

Lecture 95 11-01 Course conclusion

Section 13: Appendix 01 Install & Configure XAMPP

Lecture 96 Appendix 01-01 Download & Install XAMPP

Lecture 97 Appendix 01-02 Troubleshooting XAMPP installation (1)

Lecture 98 Appendix 01-03 Troubleshooting XAMPP installation (2)

Section 14: Appendix 02 Download & Install Komodo Edit

Lecture 99 Appendix 02-01 Download and install Komodo Edit

Anyone who wants to learn to code dynamic websites using MySQL,Back-end web developers wishing to deepen an existing knowledge of MySQL,Anyone interested in starting out in a new career in web development