SQL_best_practices

SQLbestpractices

Here are some intermediate SQL techniques that will help you for your next data analytics and data science projects!

SQL Fundamentals

SQL Cheat Sheets

Nandita's advice fot how to attack SQL projects/questions

Checking Column Types

The Big 6 of SQL Querying

Joins - Go thru Danny's course to understand joining multiple tables

Changing one data type to another

REGEXPREPLACE

Window Functions

SQL Bits & Bytes- Best practices for efficient querying

Use temp tables for complex SQL queries.

Making Lines more readable

SQL Subqueries vs Temporary Tables vs CTEs

Query Processing Order

Exploring unfamilar Tables

Entity Relationship Diagrams Model aka Entity Relationship Diagrams

Maven Analytics post: https://www.linkedin.com/posts/maven-analyticsmavenquicktips-sql-data-activity-6855472532544352257-8IM

Helen Wall https://www.linkedin.com/posts/helenrmwallsql-datascience-datavisualizations-activity-6856952524394569728-M0RX

UNIQUE & DISTINCT