Installation & Setup
Before writing SQL queries, we need a database system where our data can be stored and managed. In this course, we will primarily use MySQL, one of the most widely used relational database systems.
What is MySQL?
MySQL is an open-source relational database management system (RDBMS) that stores data in structured tables and allows us to interact with that data using SQL queries.
MySQL is commonly used in:
- Web applications
- Backend systems
- Enterprise software
- Data analytics projects
Tools Required
To work with MySQL efficiently, you need the following tools:
- MySQL Server – runs the database engine
- MySQL Workbench – graphical interface to run queries
MySQL Server works in the background, while MySQL Workbench allows you to visually create databases, write queries, and view results.
Download MySQL (Official)
Always download MySQL from the official website to ensure security and stability.
On the download page:
- Select your operating system
- Choose the MySQL Installer (recommended)
- Follow the default installation steps
Installing MySQL
During installation, you will be asked to configure a few settings. For beginners, the default options are sufficient.
- Set a strong root password
- Use the default port number (3306)
- Enable MySQL Server to start automatically
Make sure you remember the root password, as it will be required to log in to MySQL.
Opening MySQL Workbench
After installation, open MySQL Workbench. You will see a home screen showing database connections.
Create a new connection using:
- Hostname:
localhost - Username:
root - Password: the one you created
Testing the Installation
Once connected, you will see the SQL editor window. Run the following command to confirm that MySQL is working correctly:
SELECT VERSION();
If MySQL returns a version number, your installation is successful.
Alternative: Online SQL Practice
If you cannot install MySQL locally, you may use online SQL editors for practice. However, for real-world projects and advanced lessons, a local MySQL setup is strongly recommended.
What’s Next?
In the next lesson, we will learn the basic building blocks of SQL, including tables, rows, columns, and simple query structure.