SQL Practice - Practical Exercises
SQL Practice Problems with prebuilt unit tests. Improve your SQL skills by solving 35 SQL questions categorized as Basic, Intermediate, and Advanced. Utilize Docker and docker-compose with Postgres to practice SQL. Each question provides a real-world problem to solve using SQL queries. Test your SQL solutions with prebuilt unit tests. Practice Docker skills along with SQL.
Listed in categories:
Data & AnalyticsEducationSoftware Engineering
Description
SQL Practice Problems is a Docker and docker-compose based codebase that uses Postgres within Docker to provide a set of 35 SQL questions. The questions are categorized into Basic, Intermediate, and Advanced levels, each with its own set of challenges. Users can practice their SQL skills by writing queries to solve these real-world problems. The codebase includes preconfigured data and prebuilt unit tests to validate the SQL answers.
How to use SQL Practice - Practical Exercises ?
1. Choose the level of difficulty: Basic, Intermediate, or Advanced 2. Build the Docker image in the selected directory using the command: docker build -t beginner (or intermediate/advanced) 3. Read the SQL questions and write your SQL queries in the testssqlhereyouhobbitsql files 4. Run the unit tests against your SQL queries by using the command: docker-compose up beginner (or intermediate/advanced) 5. Check the results of the unit tests to see if your SQL queries are correct
Core features of SQL Practice - Practical Exercises :
1️⃣
35 SQL questions
2️⃣
Categorized into Basic, Intermediate, and Advanced levels
3️⃣
Practice SQL skills with real-world problems
4️⃣
Utilize Docker and docker-compose
5️⃣
Preconfigured data and unit tests
Why could be used SQL Practice - Practical Exercises ?
| # | Use case | Status | |
|---|---|---|---|
| # 1 | Learning SQL skills | ✅ | |
| # 2 | Practicing SQL queries | ✅ | |
| # 3 | Improving SQL proficiency | ✅ | |
Who developed SQL Practice - Practical Exercises ?
Daniel