Free SQL Cheat Sheets

Hey friends,

If I had to choose 1 data analyst MUST-KNOW skill, it would be SQL (structured query language). SQL is a language used by data analysts to talk to databases and it allows them to pull, manipulate, and analyze data. You don’t have to memorize or know EVERYTHING about SQL to become a data analyst. It’s actually common to google and look up SQL functions on the job. To make it easier, here are 3 SQL cheat sheets I found that you can save and refer to as you do your data analysis:

SQL Basics: Explore querying a table, filtering data, utilizing JOINs to query multiple tables, employing aggregate functions, incorporating subqueries, and more through sample queries. Access a downloadable format for printing.

Essential SQL Commands for Beginners: Dictionary-style lists of commands in SQL.

SQL Technical Concepts for the Job Interview: Explores JOINs, time and date functions, aggregate functions, window functions, and set operators with concise explanations and visual aids. Also contains interview questions and interactive solutions.

Talk soon,

Agatha

🎬 My New Video

How much I got paid in my first year as a data analyst many of you ask what is a realistic data analyst salary? Data analytics is always listed as a top career but how much you can make from a data job? This video covers all the factors that impact a data analyst salary and how much I made in my first job as a healthcare data analyst. Check out the Data Professional Certificates with DataCamp to learn more about how to become a data analyst. I’m currently taking their AI fundamentals certification to learn AI and grow my data career.

✍️ Quote of the Week

“Opportunities don’t happen, you create them.” —Chris Grosser

Want to learn more from me? Check out 👇

• 📚 Resources → Data roadmap and helpful links

• 📄 Data Analyst Resume → Free ATS friendly resume template (make a copy in google docs to edit)