[SQL] Day 0: Setup

이번 포스트부터 매일 조금씩 SQL을 공부하는 프로젝트를 시작합니다. 

 

Relational Database Management System (RDBMS) software that manages and stores data in a structured format, using tables with rows and columns, and allows users to interact with the data using a structured query language (SQL). 

We will studying with MySQL, one of the most popular RDMBS used worldwide. 

 

Why We Use MySQL?

✅ Structured Data Storage – MySQL is great for storing, managing, and querying structured data (tables, rows, and columns).

✅ Relational Database – It follows a relational model, meaning data is stored in tables with defined relationships.

✅ Fast & Scalable – MySQL is optimized for fast queries, making it useful for both small projects and enterprise applications.

✅ Widely Used in Data Science & Web Development – MySQL is commonly used in data analytics, web applications, and cloud databases.

 

We will need to install (in Mac OS): 

MySQL Community Server (The Database Engine)

This is the core MySQL database system where data is stored, managed, and processed.

Runs in the background as a server, processing SQL queries.

 

MySQL Workbench (Official GUI Tool for MySQL)

Lets you view tables, databases, and query results visually.

Provides an ERD (Entity-Relationship Diagram) tool for designing database structures.

 

여기서부턴 Optional Softwares 입니다

DBeaver (Universal SQL Client)

DBeaver is a third-party SQL client that works with MySQL and other databases (PostgreSQL, SQLite, etc.).

- Provides a better UI for writing SQL queries.

- Allows you to explore database schema, tables, and relationships visually.

- Includes extra features like data export/import, query history, and SQL debugging.

 

VSCode (SQL & Code Editor)

VSCode is a lightweight code editor that allows you to write and manage SQL scripts more efficiently.

- Lets you write SQL queries in files instead of just typing them into a terminal.

- Integrates with SQLTools to connect and run queries directly from VSCode.

- Useful for writing SQL scripts in an organized way.