Skip to content

Latest commit

 

History

History
39 lines (28 loc) · 1.69 KB

README.md

File metadata and controls

39 lines (28 loc) · 1.69 KB

SQL Essential Skills

This repository showcases various SQL projects, focusing on essential skills such as querying, data analysis, and manipulation using real-world datasets. Each project is organized into separate folders and includes SQL scripts, datasets, and relevant documentation.

Projects

1. Analyzing WSDA Music Database

This project explores the WSDA Music Database, providing hands-on practice with SQL queries focused on:

  • Retrieving data using SELECT, WHERE, and filtering with LIKE.
  • Joins and subqueries for accessing data across multiple tables.
  • Summarizing data with aggregate functions (SUM, COUNT, AVG).
  • Managing and manipulating data (inserting, updating, and deleting records).

How to Use This Repository

  1. Clone the repository to your local machine: 
    git clone https://github.com/your-username/SQL-essential-skills.git
  2. Navigate into the project folders to explore the SQL queries and datasets.
  3. You can run the SQL queries in your preferred SQL environment (e.g., DB Browser for SQLite, MySQL, PostgreSQL, etc.).
  4. Review the README in each project folder for more detailed instructions and insights.

Technologies Used

  • SQL: Core language for querying and managing databases.
  • SQLite: Database engine used in some projects for lightweight database management.
  • GitHub: Version control and collaboration.

Contact

If you have any questions or suggestions, feel free to reach out by starting a conversation in the GitHub Discussions section of this repository.

Created By: Binita Chand

Thank you for visiting this repository! I hope you find these projects helpful in enhancing your SQL skills. Happy coding!