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.

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.

Miscellaneous

Other awesome links & resources!

• W3Schools - SQL Tutorial with W3Schools.
• Pluralsight - Pluralsight (Code School: Try SQL).
• CodecAcademy - CodecAcademy (Learn SQL).
• SQLZoo - SQL Tutorial.

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