Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Richard Stibbard’s “Practical MySQL”

All the MySQL you need to get you going with working with the database behind a dynamic website.
5.0
5.0/5
(25 reviews)
285 students
Created by

7.8

CourseMarks Score®

4.1

Freshness

9.5

Feedback

9.3

Content

Platform: Udemy
Video: 6h 22m
Language: English
Next start: On Demand

Table of contents

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 PHPThe 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!

You will 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

This course is for

• 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
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. 
Browse all courses by on Coursemarks.
Platform: Udemy
Video: 6h 22m
Language: English
Next start: On Demand

Students are also interested in