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…

Learning SQL the Hard Way - MLWhiz

This post is about installing SQL, explaining SQL and running SQL.

SQL Query Cheatsheet for Postgres

The SQL queries I use as a data scientist and software engineer

6 SQL Tricks Every Data Scientist Should Know

How to Install and Configure MySQL in Ubuntu 18.04 LTS

Mysql 5.7.29 installation on Ubuntu Linux 18.04 LTS - Stack Overflow

I'm re-installing MySQL (5.7.29) for Ubuntu Linux 18.04 LTS. I installed the package using apt & started the service without issue. I was not asked for a root password during the install and am...

Doing a SQL join with CSV files with xsv

How to combine data spread over two CSV files, like separate tables in a normalized relational database.

Working with the SQL Server command line (sqlcmd)

In this new chapter, we are going to show the following examples in a local SQL Server using SQL Server command line (sqlcmd).

mssql-cli/usage_guide.md at master · dbcli/mssql-cli

A command-line client for SQL Server with auto-completion and syntax highlighting - dbcli/mssql-cli