Search
Results
frectonz/sql-studio: SQL Database Explorer [SQLite, libSQL, PostgreSQL, MySQL/MariaDB, DuckDB, ClickHouse]
Screwtape / sqlite-schema-diagram · GitLab
A complete book dedicated to database indexes
sqlite-utils - utils to work with sqlite from command line
DB Browser for SQLite
GitHub - AlaSQL/alasql: AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.
SQLforDevs.com - Next-Level Database Techniques for Developers Ebook
GitHub - surrealdb/surrealdb: A scalable, distributed, collaborative, document-graph database, for the realtime web
YDB — an open-source Distributed SQL Database
SQLPad | Ace Your Next SQL Interview
Automate Database Restore for SQL Server
In this article we look at how to automate a SQL Server database restore using a PowerShell script.
Arctype SQL Client - Free SQL Editor for Developers
TaKO8Ki/gobang at v0.1.0-alpha.3
Terminal based mysql sql workbench
q - Text as Data
SQL Query Optimization: Understanding Key Principle
Vitess | A database clustering system for horizontal scaling of MySQL
veeQuery | veeQuery Free Version
GitHub - dbgate/dbgate: Database manager for MySQL, PostgreSQL, SQL Server and MongoDB. Runs under Windows, Linux, Mac or as web application
Logica | Modern Logic Programming
sq: swiss-army knife for data
SQLPad
GitHub - sql-js/sql.js: A javascript library to run SQLite on the web.
mlin/GenomicSQLite: Genomics Extension for SQLite
SQL style guide by Simon Holywell
SQL OnLine IDE
Celko on SQL: Natural, Artificial and Surrogate Keys Explained - InformationWeek
SQL programming guru Joe Celko offers a classification scheme and advice on using the right keys.
The Curse and Blessings of Dynamic SQL
This is a text about dynamic SQL. Used in the right place, dynamic SQL is a tremendous asset, but dynamic SQL is also one of the most abused features in SQL Server.
Free Programming Books – GoalKicker.com
Free Programming Books on Android development, C, C#, CSS, HTML5, iOS development, Java, JavaScript, PowerShell, PHP, Python, SQL Sever and more
Free Computer books Download | Online computer ebooks | online free computer science ebooks
Free Computer Science ebooks,Free Computer Science ebooks download,computer science online, microsoft windows programming, Cisco certification books
A Visual Explanation of SQL Joins
I thought Ligaya Turmelle's post on SQL joins was a great primer for novice developers. Since SQL joins appear to be set-based, the use of Venn diagrams to explain them seems, at first blush, to be a natural fit. However, like the commenters to her post, I found that the Venn diagrams didn't quite match the SQL join syntax reality in my testing.
Export SQL to Excel
How to export a SQL table to an Excel spreadsheet using the SQL Server Import and Export Wizard.
Quip - Interview questions of SQL
Beekeeper Studio | Free & Open Source SQL editor and database manager for MySQL, Postgres, SQLite, SQL Server, and more. Available for Windows, Mac, and Linux.
MySQL :: MySQL Community Downloads
Get Started Learning SQL Server - EssentialSQL Online Courses
Learn to use SQL Server Management Studio to create and run queries.
Find Courses by Topic | MIT OpenCourseWare | Free Online Course Materials
MIT OpenCourseWare makes the materials used in the teaching of almost all of MIT's subjects available on the Web, free of charge. With more than 2,400 courses available, OCW is delivering on the promise of open sharing of knowledge.
Bytepawn – How I write SQL code
Easy Fixes For SQL Queries - Towards Data Science
Client-Side SQL Query Parsing with ANTLR
A Guide to SQL Naming Conventions
SQL queries don't start with SELECT
Illuminated Computing | Too Many Outer Joins
Advanced SQL - window frames
sql exercises
How Modern SQL Databases Come up with Algorithms that You Would Have Never Dreamed Of by Lukas Eder - YouTube
SQL is the only ever successful, mainstream, and general-purpose 4GL (Fourth Generation Programming Language) and it is awesome! With modern cost based optim...
How Does a Database Work? | Let’s Build a Simple Database
Client side JavaScript database sql
Transact-SQL Reference (Database Engine) | Microsoft Docs
This topic gives the basics about how to find and use the Microsoft Transact-SQL (T-SQL) reference topics. T-SQL is central to using Microsoft SQL products and services. All tools and applications that communicate with a SQL database do so by sending T-SQL commands.
Poor SQL - Instant Free and Open-Source T-SQL Formatting
PoorSQL.com is a free online T-SQL formatting service using the open-source .Net 2.0 Poor Man's T-SQL Formatter library.