SPOTO trainer Trevor Sullivan teaches you how to create, configure and maintain MySQL databases for web applications in this 106-video training.
This is a new SQL training.
MySQL is the most widely used relational database in the entire world. MySQL databases are open-source, free and easy to maintain. MySQL is an essential component of the archetypal LAMP stack (Linux Apache MySQL PHP), which has been used for years to refer to the fundamental building blocks needed to host and create websites. MySQL is often the first relational database that web developers learn.
MySQL is a stable, mature technology that is popular in addition to its popularity. MySQL is more robust than serverless alternatives like SQLite and easier to set up and maintain than other relational database options. This makes it an excellent first database to learn.
This series of 20 parts covers topics like creating tables in MySQL databases and understanding different MySQL storage engines. It also covers automating MySQL databases using triggers.
You can watch a video from the series here:
This series includes the following skills:
Introduction to MySQL
phpMyAdmin allows you to manage MySQL databases
MySQL Databases: Create tables
Understanding MySQL Storage Engines
MySQL Triggers to Automate Database Activities
MySQL Database Management with Python
Learn MySQL Database User Configuration
MySQL Databases: Working with Date and Times
Learn MySQL Database Privileges
MySQL Views
This training covers the following topics:
Specify Resource Controls to MySQL Users
MySQL Table for Employees
Use Function Expressions in MySQL SQL SELECT Statments
Review the Default MySQL Storage Engine by InnoDB
MySQL Users can be granted privileges at the table
This training includes:
15 hours of training
106 videos
Learn SQL today!
Download
Are you not a SPOTO subscriber yet? Start your week-long free trial now.
SPOTO offers everything you need to improve your IT skills and advance in your career: unlimited video training and Practice exams, Virtual Labs and validated learning with in–video Quizzes, Accountability coaching, and access to our exclusive IT professionals community.