Udemy

Richard Stibbard's "Practical MySQL"

Enroll Now
  • 313 Students
  • Updated 4/2019
5.0
(33 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
6 Hour(s) 22 Minute(s)
Language
English
Taught by
Richard Stibbard
Rating
5.0
(33 Ratings)
1 views

Course Overview

Richard Stibbard's

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!

Course Content

  • 10 section(s)
  • 99 lecture(s)
  • Section 1 Preliminaries
  • Section 2 MySQL Queries and Built-in Functions
  • Section 3 Users and Privileges
  • Section 4 MySQL on the Command Line
  • Section 5 Relational Database Design
  • Section 6 Stored Procedures
  • Section 7 Automation with MySQL Triggers
  • Section 8 User-defined Functions
  • Section 9 MySQL Views
  • Section 10 Automation with MySQL Events

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


Reviews

  • C
    Christer Lofving
    5.0

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

  • I
    Ivan Krowl
    4.5

    Juat what I needed to get started.

  • S
    Stacy Gingerich
    5.0

    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!

  • M
    Maesai Prabhasavat
    5.0

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

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed