Awesome SQL

SQL-related awesome list.

Contents

• Formatters
• Oracle
• SQL Server
• Tools
• Miscellaneous
• Conferences
• Code of Conduct

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

• sqruff - A SQL linter and formatter written in Rust that supports various SQL dialects and integrates with VSCode through a plugin.
• sqlaxe - CLI tool for searching, filtering, formatting, and splitting SQL files. Supports 40+ dialects of SQL.
• 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.

Conferences

• SQL Server Virtual Conference - SQL Server Virtual Conference with C# Corner.
• SQL Day - SQLDay is the largest conference focused on Microsoft Data Platform – databases, Big Data, Business Intelligence and advanced data analysis.
• JOIN! DB Conference - JOIN! is a premium conference for all specialists using Microsoft SQL Server, featuring some of the best speakers in the industry.

Contributing

Warmly welcome! Kindly go through Contribution Guidelines first.

Code of Conduct

Examples of behavior that contributes to creating a positive environment include:

    Using welcoming and inclusive language
    Being respectful of differing viewpoints and experiences
    Gracefully accepting constructive criticism
    Focusing on what is best for the community
    Showing empathy towards other community members