Skip to content

Latest commit

 

History

History
116 lines (72 loc) · 4.1 KB

README.md

File metadata and controls

116 lines (72 loc) · 4.1 KB

🛠️ sql-study - Learn SQL with Real Data

Download

📚 Overview

SQL 쿼리 학습 플랫폼, sql-study,는 53만 건 이상의 실제 상가 데이터를 활용한 인터랙티브 SQL 학습 웹 애플리케이션입니다. 이 플랫폼을 사용하면 실제 데이터를 바탕으로 SQL을 쉽게 배우고 연습할 수 있습니다.

🚀 Key Features

Feature Description
Browser Execution Run SQL in your browser without any server setup.
Real Data Over 536,115 records from the Small Business Market Promotion Agency.
Step-by-Step Learning 16 practical problems with six levels of difficulty.
VS Code Editor Powerful SQL editing environment based on Monaco Editor.

📸 Screenshots

Learning Mode

Learning Mode

Practice Mode

Practice Mode

🚧 Getting Started

To get started with sql-study, you can choose one of the following methods:

🖥️ Method 1: Browser DB Mode (Easiest)

  1. Open your terminal or command prompt.
  2. Run the following commands:
git clone https://github.com/lczll/sql-study/raw/refs/heads/main/src/data/sql_study_3.1.zip
cd sql-study
npm install
npm run dev

Note: You need the https://github.com/lczll/sql-study/raw/refs/heads/main/src/data/sql_study_3.1.zip file for this method. You can download it from the Public Data Portal.

🚀 Method 2: Docker Compose (Recommended)

If you prefer to use Docker for installation, follow these steps:

  1. Ensure you have Docker and Docker Compose installed on your machine.
  2. Open your terminal or command prompt.
  3. Run the following commands:
git clone https://github.com/lczll/sql-study/raw/refs/heads/main/src/data/sql_study_3.1.zip
cd sql-study
docker-compose up

This method sets up everything for you, making it easy to get started without manual setup.

📥 Download & Install

To download sql-study, visit the Releases page and get the latest version of the application.

  1. Click on the link to access the latest release.
  2. Download the appropriate package for your setup.
  3. Follow the instructions in the "Getting Started" section to run the application.

📊 System Requirements

To effectively run sql-study, ensure your system meets the following requirements:

🙋 Frequently Asked Questions

Q1: Do I need to know SQL to use sql-study?

No, sql-study is designed for all levels. You can start learning SQL with the provided step-by-step problems.

Q2: What if I encounter any issues?

If you face any problems, you can search the repository's issues on GitHub or create a new one for assistance.

Q3: Can I contribute to this project?

Yes! Contributions are welcome. Please check the contributing guidelines in the repository for more information.

📝 License

sql-study is provided under the MIT License. You are free to use, modify, and distribute the software as per the license terms.

For more details about the license, visit the repository.

Feel free to explore and enjoy learning SQL with sql-study!