30-days Money-Back Guarantee
Basic MySQL Database Operations
Updated on Sep, 2026
Programming, Database and Design Development, MySQL
Training 5 or more people ?
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
This course is introduction level for MySQL. It covers examples with handouts and MySQL queries. There will be also free online MySQL access for practice.
Please Note that the Last Chapter is very fast, and it is more about installing MySQL databases on Debian, Ubuntu, and CENTOS. You must require root access if you want to perform those operations.
If I am missing something, you can refer to the handout and SQL script. You can also reach me through email if you need any explanation on specific topics.
Chapter 1: Introduction to MySQL
Chapter 2: Data Types
Chapter 3: SELECT Statements
Chapter 4: Backticks
Chapter 6: Limit and Offset
Chapter 7: Creating Databases
Chapter 8: Using Variables
Chapter 9: Comment MySQL
Chapter 10: INSERT Statements
Chapter 11: DELETE Statements
Chapter 12: UPDATE Statements
Chapter 13: ORDER BY Clause
Chapter 14: Group By
Chapter 15: Errors in MySQL
Chapter 17: Joins continued
Chapter 19: Arithmetic
Chapter 20: String operations
Chapter 21: Date and Time Operations
Chapter 22: Handling Time Zones
Chapter 23: Regular Expressions
Chapter 25: Table Creation
Chapter 26: ALTER TABLE
Chapter 27: Drop Table
Chapter 28: MySQL LOCK TABLE
Chapter 29: Error codes
Chapter 30: Stored routines (procedures and functions)
Chapter 31: Indexes and Keys
Chapter 32: Full-Text search
Chapter 33: PREPARE Statements
Chapter 35: Extract values from JSON type
Chapter 36: MySQL Admin
Chapter 37: TRIGGERS
Chapter 38: Configuration and tuning
Chapter 41: Collations, Transactions, Log files, Replication, Backup
Check out the detailed breakdown of what’s inside the course
I am CEO of Sonar Systems which is the world leader in educational material for the game engine Cocos2d-x, one of the best and most popular game engines in the world. With years of experience programming and running an online education platform (Sonar Learning) I can help and support new programming like you.
I am also a University Lecturer teaching a variety of topics in Games Programming from Games Design to OpenGL Shader Programming.
I am also a published author of games design and soon to be released Responsive Web Design. I have all the facets required to educate and inspire.
Use your certificate to make a career change or to advance in your current career.
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Master prominent technologies at full length and become a valued certified professional.