Learning-SQL-Hacktoberfest24

Repository totally dedicated to Hacktober Fest 2023, feel free to use it. Topics hacktoberfest hacktoberfest-accepted hacktoberfest23

Welcome to Hacktoberfest #11 2024

⭐ This repository is made for beginners who are looking for a beginner-friendly repository to start open source contributions!

⭐ Feel free to use this project to make your first contribution to an open-source project on GitHub.

⭐ Star this repository for a better reach!

What is Hacktoberfest? 🤔

A month-long celebration from October 1st to October 31st presented by Digital Ocean and DEV Community collaborated with GitHub to get people involved in Open Source.

https://hacktoberfest.com/

Note 🔥

1. To qualify for digital rewards by Hacktoberfest, you must register for the event and make four Pull Requests (PRs) between October 1-31, 2023 (in any time zone).

2. Pull requests can be made in any GitHub or GitLab hosted project that’s participating in Hacktoberfest (look for the “hacktoberfest” topic).

3. The first 50,000 participants to have their first PR/MR accepted will have a tree planted in their name through Tree Nation

How to Contribute

To contribute to our Learning-SQL-Hacktoberfest23:

1. Fork the Repository: Click the "Fork" button at the top right of this repository to create a copy in your GitHub account. 🍴

2. Clone Your Fork: Clone the forked repository to your local machine using Git. 🖥️

   git clone https://github.com/yourusername/Learning-SQL-Hacktoberfest23.git
   

3. Create a Branch: Create a new branch for your contribution under the respective folder. 🌿

   git checkout -b <user-name>
   

Thanks to All Contributors💖 HF2024

Contribution Rules 🤍

⭐ Follow few steps while updating the file .

1. add any sql query or you can also contribute to write documentation related to different topic of databases (either relational or non-relational db) according to your choice. and also add reference link at the end (optional).

• secondly add your details into the contributor list folder just create a file conatains your name, institiute/company, github_url (the file name should be <your_username.md> ).

| Name             | Institution/Company                    | GitHub                                  |
| ---------------- | -------------------------------------  | --------------------------------------  |
| Aman ali         | Shri Ramdeobaba College of Engineering |[GitHub Profile](https://github.com/aman)|

4. save file & you all done!

5. Commit Your Changes: Commit your changes with a descriptive commit message. 💬

git commit -m "--add query or docs --"

6. Push to Your Fork: Push your changes to your GitHub fork. 🚀

   git push origin <your-branch>
   

⭐️You are done go aheaed and make your pull request.

7. Open a Pull Request: Submit a Pull Request (PR) to the main repository under the respective category. Include a clear title and description of your changes. 🎯

8. Review and Merge: We will review your PR, and if it meets our guidelines, it will be merged into the main repo. 🤝

Like the Repository! ⭐️

Happy contributing and all the best for hacktoberfest! 💻📚🚗

⭐️If you find any bug or have a feature suggestion, feel free to raise an issue.

Awesome SQL

SQL-related awesome list.

Contents

• Formatters
• Oracle
• SQL Server
• Tools
• Miscellaneous

Formatters

• PoorMansTSqlFormatter - A small free .NET and JS library.
• SQL Formatter - Instant SQL Formatter.

Oracle

• Alexandria-PLSQL-Utils - Oracle PL/SQL Utility Library.
• PLSQL-JSON - The JSON encode/decode library for Oracle PL/SQL.
• Oracle SQL Developer - A free, integrated development environment.
• SQL Tools for Oracle - A light weight and robust frontend for Oracle database development.
• Testing Framework for PL/SQL - An open-source testing framework for PL/SQL and SQL.
• Oracle Database 18c Express Edition - Free Oracle Database for everyone.
• Oracle Database Online Documentation 12c - Documentation, release 1 (12.1).

SQL Server

• SQL Server Data Tools - A modern development tool for building SQL Server relational databases, Azure SQL Databases, Analysis Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS) reports.
• SQL Server 2019 - SQL Server 2019 by Microsoft.
• Database Unit Testing for SQL Server - Unit testing framework for SQL Server.
• SQL Server Architecture - Detailed Explanation.
• Learn SQL Server - Detail information related to SQL Server.
• SQL Server Interview Questions - Prepare for SQL interview with these most asked real-world SQL interview questions.

Tools

• BigBash - A converter that generates a bash one-liner from an SQL Select query.
• ERAlchemy - Entity Relation Diagrams generation tool.
• Flyway - Version control for a database.
• Rumba RDBM - Database schema migration tool, plain-SQL, and declarative schema definition supported.
• Liquibase - Manage database changes with ease.
• PixQL - SQL for image processing.
• SQL Fiddle - A tool for easy online testing and sharing of database problems and their solution.
• SQLPad - A web app for writing and running SQL queries and visualizing the results.
• EverSQL - Automated query optimizer, performance monitor and analyser, powered by AI.

Miscellaneous

• Other awesome links & resources!

• W3Schools - SQL Tutorial with W3Schools.
• Pluralsight - Pluralsight (Code School: Try SQL).
• CodecAcademy - CodecAcademy (Learn SQL).
• SQLZoo - SQL Tutorial.
• Scaler Topics - Learn basic and advanced concepts of SQL.
• InetrviewBit - Learn SQL: Basic to Advanced Concepts.

_{Md Tajuddin}