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
Christer L.
Yes, I needed a "refresh" of MySQL. This one is perfect.