/SelfLearningSQL

Welcome to our open source repository for self-learning SQL queries! Whether you're a beginner or looking to sharpen your skills, this repository offers a diverse collection of SQL queries, explanations, and exercises to help you master database querying.

Self-Learning SQL Queries Repository

Welcome to the Self-Learning SQL Queries Repository! This repository is designed to help you enhance your SQL querying skills through hands-on exercises and examples. Whether you're a beginner or an experienced SQL developer, you'll find valuable resources here to improve your proficiency.

Getting Started

To get started, follow these steps:

  1. Clone the Repository: Clone this repository to your local machine using git clone.

  2. Set Up the Database: Run the SQL script create_database_tables.sql to create the necessary database and tables.

  3. Populate Records: Run the SQL script insert_records.sql to populate the tables with sample records.

  4. Start Querying: Explore the provided exercises in the exercises directory to practice your SQL querying skills.

Contents

1. Database Setup

  • create_database_tables.sql: SQL script to create the database schema and tables.

2. Data Population

  • insert_records.sql: SQL script to insert sample records into the tables.
  • In case you find an error please use insert_records_capitalized.sql

3. Exercises

  • Beginning Level Exercises: Basic SQL queries for beginners to practice foundational concepts.
  • Intermediate Level Exercises: Intermediate SQL queries for those looking to expand their skills.
  • Advanced Level Exercises: Advanced SQL queries for experienced developers seeking challenges.

Each exercise file contains a set of SQL queries along with instructions and expected outputs. Feel free to modify and expand upon these exercises as you see fit.

Contributing

We welcome contributions from the community! If you have additional exercises, improvements, or corrections, please submit a pull request. Together, we can make this repository a valuable resource for SQL learners worldwide.

License

This repository is based on the book "SQL Practice Problems" by Sylvia Moestl Vasilik, published by Apress. Please respect the original author's work and use this repository for educational purposes only. For commercial use or distribution beyond the scope of personal learning, please refer to the book for proper licensing.

Acknowledgements

Special thanks to all contributors who have helped improve this repository and make it a valuable resource for SQL learners.

Happy querying!