MySQL – what it is, why web developers use it, and what this tutorial series covers.
Most dynamic websites need a database behind them. MySQL is the most widely used open-source option. It handles blogs, shops, CRMs, and social apps without much fuss.
This series starts from the basics and works up. I use Visual Studio Code (VSCode) for SQL work – use whatever editor you prefer, but the examples assume VSCode.
We will cover database design, creating and changing databases, SQL queries, and how to use MySQL in real web projects.
Start here: Getting Started with MySQL: Installation and Setup in VSCode
20 tutorials in this topic
- Getting Started with MySQL: Installation and Setup in VSCode
- Understanding MySQL Basics: Databases and Tables
- Your First MySQL Query: Writing and Executing in VSCode
- Exploring Data Types in MySQL: A Comprehensive Guide
- Mastering CRUD Operations: Create, Read, Update, Delete in MySQL
- Efficient Data Retrieval: Introduction to SELECT Queries
- Sorting and Filtering Data in MySQL: A Practical Approach
- Advanced Selection Techniques: Using WHERE and JOIN Clauses
- Manipulating Data: INSERT, UPDATE, and DELETE Commands
- MySQL Functions and Operators: Enhancing Data Manipulation
- Designing Efficient Databases: Keys and Indexes Explained
- Understanding Relationships in MySQL: Primary and Foreign Keys
- Grouping Data: Using GROUP BY and HAVING Clauses
- Subqueries in MySQL: A Powerful Tool for Complex Queries
- Managing Database Users and Permissions in MySQL
- Storing Large Data: BLOBs and TEXT in MySQL
- Optimizing Queries: Tips for Faster MySQL Performance
- Automating Tasks with Stored Procedures and Triggers
- Backing Up and Restoring MySQL Databases
- Exploring MySQL Advanced Features and Best Practices