🏠

1

2

3

4

5

6

7

8

I am using MySQL on Windows for the majority of these notes.

key = {db='database', df =’dataframe’, pd = ‘pandas’, np =‘numpy’, plt =‘matplot’, sns='seaborn', < >= add your code, value = anything}

SQL Resources

Python SQL

HOT Keys

Useful Queries

Common Errors

SQL order of operations

Database Design

DDL and DML

The Big 6 - primary commands

Data types

Basic SQL

JOIN and Set Operations

Date Functions

String Functions

Numeric Functions

Comparison Functions