Richard Stibbard's "Practical MySQL"

Discover MySQL with our practical course designed for web developers! Master the essentials and get up to speed in just 12 hours.

  • Overview
  • Curriculum
  • Instructor
  • Review

Brief Summary

This course is your ticket to mastering MySQL! Cover everything from the basics of querying to advanced database design. Perfect for web developers looking to level up their skills, whether you're just starting out or have some experience.

Key Points

  • Hands-on approach to learning MySQL.
  • Suitable for all skill levels.
  • Wide range of topics covered from basics to advanced.

Learning Outcomes

  • Gain practical skills in MySQL and database management.
  • Understand relational database design and user privileges.
  • Be able to implement automation and custom functions in MySQL.

About This Course

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

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!

  • 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

Course Curriculum

1 Lectures

1 Lectures

Instructor

Profile photo of Richard Stibbard
Richard Stibbard

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...

More Courses By Richard Stibbard
Review
4.9 course rating
4K ratings
ui-avatar of Christer Lofving
Christer L.
5.0
1 year ago

Yes, I needed a "refresh" of MySQL. This one is perfect.

  • Helpful
  • Not helpful
ui-avatar of Ivan Krowl
Ivan K.
4.5
2 years ago

Juat what I needed to get started.

  • Helpful
  • Not helpful
ui-avatar of Stacy Gingerich
Stacy G.
5.0
6 years ago

This is exactly what I was looking for! I had ordered MySQL for Beginners and it was pretty much anything but! This gets course gets you writing and practicing from the get "GO". Thank you so much!

  • Helpful
  • Not helpful
ui-avatar of Maesai Prabhasavat
Maesai P.
5.0
6 years ago

The instructor explain all important points. I has some experience working with MySQL but I still learn a lot from this course.

  • Helpful
  • Not helpful
ui-avatar of Diyar Bozkurt
Diyar B.
5.0
6 years ago

The instructor is extremely clear with his explanations.

  • Helpful
  • Not helpful
ui-avatar of Steven Taylor
Steven T.
5.0
7 years ago

This was a very thorough course. I had already been using MySQL but I learned a lot of new things about it.

  • Helpful
  • Not helpful
ui-avatar of Graham Elam
Graham E.
5.0
7 years ago

Excelllent

  • Helpful
  • Not helpful
ui-avatar of Bill Desjarlais
Bill D.
5.0
7 years ago

Very thorough coverage of MySQL. The instructor gave lots of examples and assignments that reinforced the content.

  • Helpful
  • Not helpful
ui-avatar of Mohammed ali
Mohammed A.
5.0
7 years ago

he make sure to explain it step slowly and helps a lot

  • Helpful
  • Not helpful
ui-avatar of Mirko Cukich
Mirko C.
5.0
7 years ago

Excellent class. The instructor does a great job of explaining everything in detail and going through the work with you too. A++

  • Helpful
  • Not helpful
Leave A Reply

Your email address will not be published. Required fields are marked *

Ratings

Courses You May Like

Lorem ipsum dolor sit amet elit
Show More Courses