SQL Basics Cheat Sheet
This 2-page SQL Basics Cheat Sheet will be a great value for beginners as well as for professionals. Download it in PDF or PNG format.
databases
10 Essential Psql Commands For Data Engineers
Learn how to interact with PostgreSQL databases through the command line using PSQL.
Advanced SQL operations
Reviewing more advanced SQL operations to extract additional data insights from the Irish Weather dataset.
7 Lessons From 10 Outages – The Downtime Project
Ask HN: What is the SQLite of nosql databases?
Tricks for Advanced SQL Querying
One of the most valuable technical skills I use working on a data science team in the retail space is SQL…
Datasets should behave like git repositories | by Simon Lousky | Towards Da
Create, maintain, and contribute to a long-living dataset that will update itself automatically across projects.
How to Use SQL RANK and DENSE_RANK Functions
If you’ve been practicing your SQL religiously, like I suggested in Top Skills to Ace Every SQL Interview Question, then you’ve probably…
SQLite the only database you will ever need in most cases
PostGIS – Spatial and Geographic Objects for PostgreSQL
Beginner’s Guide to Querying Data Using SQL on GPUs in Python
Historically speaking, processing large amounts of structured data has been the domain of relational databases. Databases, consisting of tables that can be joined together or aggregated…
Baserow: Open source online database tool
Discover Baserow, the open-source no-code platform for building databases and applications. No code or technical skills needed. Start creating for free today!
7 Must-Know Ideas about NoSQL
How to avoid those dreaded pitfalls and “gotcha” moments when selecting databases for your next application?
dolthub/dolt: Dolt – It's Git for Data
Dolt – Git for Data.
Why Uber Engineering Switched from Postgres to MySQL
What is a graph database?
The graph database is popular with social networks, but there's no reason to limit it to tracking people and their friendships.
8 Examples to Query a NoSQL Database
A practical guide with MongoDB
Setup Ruby on Rails 6 App with MongoDB under 5 Minutes — Aarvy | by Aarvy |
In this article, I will be discussing how to quickly setup a NoSQL database MongoDB with your brand new Rails 6 app. I am using Ubuntu…
reddit: the front page of the internet
Rails 6.1 has added support for switching connections for one database instead of all databases
Python Pandas and SQLite
Using SQLite to store your Pandas dataframes gives you a persistent store and a way of easily selecting and filtering your data
Manage Files and Database Connections in Python Like a Pro
How to manage external resources in Python with your custom context managers
Database of Databases - Leaderboards
Encyclopedia of databases systems from Carnegie Mellon University. Curated by @andy_pavlo
MongoDB Vs SQL
MongoDB and SQL databases are two polar opposite sides of the backend world. The former deals with chaotic unstructured data, while the…
How GIN Indices Can Make Your Postgres Queries 15x Faster
With query examples you can run on your laptop
Why databases use ordered indexes but programming uses hash tables (evanjones.ca)
On Sharding
Understanding Database Sharding | DigitalOcean
Sharded databases have been receiving lots of attention in recent years, but many don’t have a clear understanding of what they are or the scenarios in which…
HDFS vs. HBase : All you need to know - DataScienceCentral.com
The sudden increase in the volume of data from the order of gigabytes to zettabytes has created the need for a more organized file system for storage and processing of data. The demand stemming from the data market has brought Hadoop in the limelight making it one of biggest…