Practical MySQL - MySQL skills from beginner to advanced
5.0 (3 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
103 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Practical MySQL - MySQL skills from beginner to advanced to your Wishlist.

Add to Wishlist

Practical MySQL - MySQL skills from beginner to advanced

All the MySQL you need to get you going with working with the database behind a dynamic website.
5.0 (3 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
103 students enrolled
Created by Richard Stibbard
Last updated 7/2017
English
Current price: $12 Original price: $50 Discount: 75% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 6.5 hours on-demand video
  • 12 Articles
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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 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

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!

Who is the target audience?
  • 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
99 Lectures
06:22:21
+
Preliminaries
3 Lectures 09:15
Download the Working Files
00:14


00-02 Introduction
04:42
+
MySQL Queries and Built-in Functions
22 Lectures 01:35:36










01-11 MySQL string functions
08:05

01-12 MySQL aliases
03:49

01-13 Functions within functions
04:08

01-14 Update existing records
01:34

01-15 Update part of existing records
04:07

01-16 Alter table structure - Add columns
03:06

01-17 Alter table structure - Change datatype
01:16

01-18 Export data to SQL file
03:54

01-19 Delete selected records
01:43

01-20 Delete (drop) columns
01:04

01-21 Delete all records from a table
02:45

01-22 Delete (drop) table and database
01:53
+
Users and Privileges
2 Lectures 09:29
02-01 Create new MySQL user and assign privileges - localhost
04:53

02-02 Create new MySQL user and assign privileges - cPanel
04:36
+
MySQL on the Command Line
4 Lectures 26:19
03-01 Connecting to MySQL at the Windows Command Prompt
07:43

03-02 Revision - MySQL queries on the command line
04:27

03-03 Import and Export Data on the MySQL Command Line
03:01

03-04 Automation of database maintenance tasks in cPanel
11:08
+
Relational Database Design
16 Lectures 59:57
04-01 The problem with flat files
04:51

04-02 The solution - linking tables
02:35

04-03 Assignment 1 - Create linking sales table
00:00

04-04 Solution to Assignment 1 - Linking sales table
02:46

04-05 Assignment 2 - Insert data into sales table
00:00

04-06 Solution to Assignment 2 - Insert sales data
02:21

04-07 Selecting matching records from multiple tables with WHERE ... AND ,..
04:06

04-08 Selecting matching records from multiple tables with INNER JOIN
06:22

04-09 JOIN query syntax with table aliases
04:20

04-10 Selecting matching records with IN
04:00

04-11 Creating relationships between tables Primary Key/Foreign Key Constraints
08:46

04-12 Assignment 3 - Create constraint between sales and items tables
00:00

04-13 Solution to Assignment 3 - Sales items item_id constraint
01:58

04-14 Constraint action SET NULL
07:52

04-15 Constraint action RESTRICT or NO ACTION
05:05

04-16 Set constraint when creating table
04:54
+
Stored Procedures
11 Lectures 40:18
05-01 Introduction to MySQL stored procedures
04:13

05-02 Create MySQL stored procedure in SQL input box
04:52

05-03 Security settings for stored procedures
08:47

05-04 IN parameters in stored procedures
05:57

05-05 SQL wildcards in stored procedures
02:24

05-06 OUT parameters in stored procedures
05:31

05-07 INOUT parameters in stored procedures
02:43

05-08 Assignment 4 - Insert, update and delete records in stored procedures
00:00

05-09 Solutions to Assignment 4 - Insert
02:34

05-10 Solutions to assignment 4 - Update
02:22

05-11 Solutions to Assignment 4 - Delete
00:55
+
Automation with MySQL Triggers
4 Lectures 12:05
06-01 Introduction to MySQL triggers
03:33

06-02 Trigger after insert
06:15

06-03 Assignment 5 - Trigger after delete
00:00

06-04 Solution to Assignment 5
02:17
+
User-defined Functions
3 Lectures 14:38
07-01 Introduction to user-defined functions
06:49

07-02 Assignment 6 - Create a User-Defined Function
00:00

07-03 Solution to Assignment 6 - Create a user-defined function
07:49
+
MySQL Views
4 Lectures 06:45
08-01-Introduction to MySQL Views
02:46

08-02 Assignment 7 - Create view to display price with tax
00:00

08-03 Solution to Assignment 7 – Create view to display price with tax
01:00

08-04 Create view in dialog box
02:59
+
Automation with MySQL Events
4 Lectures 08:14
09-01 Introduction to events
03:28

09-02 Events on the command line
03:14

09-03 Assignment 8 - Create an event on the command line
00:00

09-04 Solution to Assignment 8 - Create an event on the command line
01:32
4 More Sections
About the Instructor
Richard Stibbard
4.5 Average rating
336 Reviews
9,890 Students
2 Courses
Web Developer and Online Educator

I have been working in 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 specialized in distance education through the online learning platform WebCT Vista (later Blackboard).

I thus bring to my work in web development instruction a wealth of expertise not just in the technical aspects of the course, but also the educational side of online learning. My aim is to deliver courses of supreme clarity which are suitable for a range of learners, and which make learning a pleasure for all my students.

* Please note discounts may be slightly higher than advertised amount due to rounding and currency conversion.