MySQL Fundamentals: SQL, Joins and Transactions
Learn MySQL and SQL from tables and queries to joins, indexes and transactions. For beginners and developers who need to work with relational data.
Learn MySQL free, in English or Hindi, with lessons, shorts and interview questions.
Start course → · Interview questions
30 lessons · 12 modules · Free · Updated 1 Oct 2026
What you'll learn
- Create databases and tables with suitable data types and keys.
- Read and change data with SELECT, INSERT, UPDATE and DELETE.
- Combine and summarize data with joins, GROUP BY, subqueries and window functions.
- Protect integrity with constraints, transactions and least-privilege users.
- Improve performance with indexes and EXPLAIN, and back up with mysqldump.