MySQL Tutorial Series

Overview

Starting a MySQL tutorial series, divided into three parts:
- Beginner
- Intermediate
- Advanced
This lesson covers the basics and setup of MySQL.

Three full MySQL courses on analystbuilder.com:
- Crash Course for technical interviews
- Full course from basics to intermediate level
- Advanced course for analysts
Courses include in-depth material and practice questions.

Download MySQL
- Visit: dev.mysql.com/downloads/installer
- Select your operating system (Windows, Mac, Linux)
- Choose between:
  - MySQL Installer Community
  - MySQL Installer Web Community
- Download the installer and save it.
Installation Steps
- Open the downloaded installer.
- Choose Developer Default setup type.
- Address any requirement prompts (e.g., install Microsoft Visual C++ redistributable package).
- Select components to install: server, workbench, connectors.
- Execute the installation.
Configuring MySQL
- Most critical configuration is for the server.
- Set up authentication method (password recommended).
- Choose to configure MySQL server as a Windows service and start it automatically.
- Execute the configuration.
Completing Installation
- Finish configuration for server and sample databases.
- Start MySQL Workbench and connect to the local instance.

Open a SQL script file (e.g., parks and rec create_db.sql) to create a database.
Execute the script to create tables and insert data:
- Use the lightning button to run the code.
- Check output for confirmation (e.g., "six rows affected").
- Refresh the schema to see the new database.
Navigate to created tables, e.g., employee demographics.
- Right-click to view rows.

Execute queries using:
- Lightning bolt for all highlighted queries.
- Lightning bolt with eye for single highlighted query.
View results in the output window, which displays the data in tables.