Course Highlights
MySQL is the world’s most popular open-source relational database management system (RDBMS). It is used by millions of websites and applications, including WordPress, Drupal, and Joomla. This MySql Masterclass course is for you if you want to learn how to use MySQL like a pro. In this course, you will learn everything you need about MySQL, from the basics of database design to advanced topics like stored routines and full-text search.
This course is designed for beginners and experienced users alike. If you are new to MySQL, you will start with the basics of database design and SQL. If you are already familiar with MySQL, you can skip to the more advanced modules.
As we progress, the tempo increases, challenging your newfound skills with intricate topics. From mastering the delicate dance of Joins to the artistry behind handling NULL, LIMIT, OFFSET, and creating databases, we leave no stone unturned. But, as every symphony has its crescendo, we peak with advanced themes—traversing the realms of VIEWS, Regular Expressions, and venturing into the vast universe of JSON operations, MySQL Admin, and Configuration techniques.
So, whether you’re a fledgling eager to soar in the skies of database mastery or a seasoned professional aiming for the stars, this masterclass is your rocket ship. With a total of 41 meticulously designed modules, we assure a learning experience that’s nothing short of cosmic.
Enrol in our MySql Masterclass course and redefine your database destiny.
Learning outcome
- Understand the foundational principles of MySQL.
- Create and manage MySQL databases
- Write SQL queries to select, insert, update, and delete data
- Use joins to combine data from multiple tables
- Create and use stored routines and functions
Course media
Why should I take this course?
- Comprehensive coverage of MySQL, ensuring proficiency from basic to advanced modules.
- Aids in enhancing your database management and administration capabilities.
- Stays updated with the latest MySQL techniques and operations.
- Learn the most popular open-source RDBMS in the world
- Gain the skills you need to build and manage powerful web applications
Career Path
- Database Administrator (DBA)
- MySQL Developer
- Data Analyst
- Backend Developer
- Database Solutions Architect
Requirements
- Basic understanding of relational databases.
- Basic computer skills
- No prior knowledge of MySQL required
Course Curriculum
-
Module 1: Introduction on MySQL
01:00:00 -
Module 2: Data Types
00:51:00
-
Module 3: SELECT Statements
00:59:00
-
Module 4: Backticks
00:15:00
-
Module 5: NULL
00:18:00
-
Module 6: Limit and Offset
00:13:00
-
Module 7: Creating databases
00:18:00
-
Module 8: Using Variables
00:25:00
-
Module 9: Comment MySQL
00:14:00
-
Module 10: INSERT Statements
00:29:00
-
Module 11: DELETE Statements
00:21:00
-
Module 12: UPDATE Statements
00:20:00
-
Module 13: ORDER BY Clause
00:08:00
-
Module 14: Group By
00:18:00
-
Module 15: Errors in MySQL
00:10:00
-
Module 16: Joins
00:37:00
-
Module 17: Joins continued
00:11:00
-
Module 18: UNION
00:18:00
-
Module 19: Arithmetic
00:20:00
-
Module 20: String operations
00:33:00
-
Module 21: Date and Time Operations
00:08:00
-
Module 22: Handling Time Zones
00:07:00
-
Module 23: Regular Expressions
00:19:00
-
Module 24: VIEWS
00:20:00
-
Module 25: Table Creation
00:23:00
-
Module 26: ALTER TABLE
00:23:00
-
Module 27: Drop Table
00:05:00
-
Module 28: MySQL LOCK TABLE
00:10:00
-
Module 29: Error codes
00:08:00
-
Module 30: Stored routines (procedures and functions)
00:29:00
-
Module 31: Indexes and Keys
00:24:00
-
Module 32: Full-Text search
00:18:00
-
Module 33: PREPARE Statements
00:09:00
-
Module 34: JSON
00:11:00
-
Module 35: Extract values from JSON type
00:05:00
-
Module 36: MySQL Admin
00:08:00
-
Module 37: TRIGGERS
00:12:00
-
Module 38: Configuration and tuning
00:07:00
-
Module 39: Events
00:08:00
-
Module 40: ENUM
00:09:00
-
Module 41: Collations, Transactions, Log files, Replication, Backup
00:41:00
-
Assignment – MySql Masterclass
-
Duration:13 hours, 22 minutes
-
Access:1 Year
-
Units:42
Want to get everything for £149
Take Lifetime Pack
