Resources

Online Editor

• PostgreSQL Online Editor
• SQL Online Compiler - Next gen SQL Editor
• Online SQL Editor

Cheat Sheet

• SQL Cheat Sheet
• SQL Commands Cheat Sheet
• SQL Cheat Sheet
• SQL Basics Cheat Sheet
• SQL for Data Analysis Cheat Sheet
• SQL Window Functions Cheat Sheet
• SQL JOIN Cheat Sheet
• PostgreSQL Cheat Sheet
• PostgreSQL command line cheatsheet
• PostgreSQL cheatsheet

SQL & Data Interview Questions

• Practice the most common SQL, Statistics, ML, and Python questions asked in FAANG Data Science & Data Analyst interviews!

SQL Projects for Beginners with Solutions and Explanation

Online resources related to PostgreSQL

• PostgreSQL vs SQL Server (MSSQL): Detailed Comparison
• PostgreSQL Tutorial
• Tutorials Point PostgreSQL
• Understanding Postgres Full Text Search: 10 Critical Aspects
• PostgreSQL Query Optimization: 10 Best Tricks & Techniques (Explained with Code)
• Top 10 PostgreSQL Extensions (With Code + Example)
• PostgreSQL SELECT Statement: Syntax, Parameters & Examples
• How to Use the PostgreSQL UNION & UNION ALL Operators: Easy Steps and Examples Explained
• Working with PostgreSQL Subquery
• Build your first REST API with Flask and PostgreSQL
• Making a Flask app using a PostgreSQL database
• Flask Postgres basic setup

Online resources related to Relational Algebra

• Relational Algebra Introduction (cs186berkeley)
• RelaX - relational algebra calculator - link 1
• RelaX - relational algebra calculator - link 2

Online resources related to NoSQL

• NoSQL (cs186berkeley)
• MongoDB Tutorial
• MongoDB Tutorial

Online resources to learn DuckDB

• DuckDB Tutorial For Beginners
• How DuckDB transformed my data science workflow
• Basic tutorial and example scenario for using DuckDB
• all about DuckDB
• SQL for data analysis - sql + pandas + duckdb
• Practical SQL for Data Analysis

Online resources to learn Pandas

• 10 minutes to pandas
• Complete Pandas Tutorial
• Practice your pandas skills!
• Quick tutorial to show SQL using duckdb and Pandas
• the tutorial about how to use pandas, including its sql equivalent statements

Online resources related to Database Management Systems

• SQL Part - Basic Queries (cs186berkeley)
• SQL Part 2 - Joins & Subqueries (cs186berkeley)
• SQL Tutorial (sqltutorial)
• SQL Tutorial
• SQL Tutorial for Data Scientists & Data Analysts
• SQLBolt Learn SQL with simple, interactive exercises