Brian Graves Profile picture
Sep 7, 2022 9 tweets 5 min read Read on X
When you're just starting with #DataAnalytics, it's impossible to remember everything you need to know about #SQL.

Fortunately, there are amazing #cheatsheets so that you don't have to memorize the basic syntax and commands

Here are 7 SQL cheatsheets for handy reference:👇
1) SQL Cheatsheet by @swapnakpanda

This cheat sheet covers the basics like querying and joins, but also includes some data modeling and data definition commands as well.

Definitely worth checking out: SQL Cheatsheet by @swapnakp...
2) MySQL JOIN Types by @SqlEmt

Trying to keep all of the different JOINs in mind, is pretty challenging. Especially after the coffee wears off for the day! ☕

Use Steve Stedman's MySQL JOIN Types cheat sheet to save time and avoid confusion on your next #MySQL project: Trying to keep all of the d...
3) SQL Cheatsheet by @AbzAaron

This one-pager cheat sheet has a good set of examples of SQL syntax and commands: This one-pager cheat sheet ...
4) SQL Cheatsheet by @yosracodes

This cheat sheet shows slightly more advanced SQL syntax, covering topics like set operations, working with duplicates, triggers, and more: This cheat sheet shows slig...
5) SQL Cheat Sheet by sqltutorial.org

This SQL cheat sheet provides you with the most commonly used SQL statements for quick reference: This SQL cheat sheet provid...
6) SQL Basics Cheat Sheet by @LearnSQLcom

The SQL Basics Cheat Sheet provides you with the syntax of basic clauses, different conditions, and examples so you can follow along: The SQL Basics Cheat Sheet ...
7) SQL Commands Cheat Sheet by @Intellipaat

This cheat sheet will guide you through the common SQL commands, plus syntax examples and a clear description of each one. This cheat sheet will guide...
That's it!

If you found this list of #SQL cheatsheets useful, share the full list with others and show some 💚 to each of the creators.

• • •

Missing some Tweet in this thread? You can try to force a refresh
 

Keep Current with Brian Graves

Brian Graves Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @NewPrediction

Jul 20, 2023
Data analytics is the ultimate career choice if you want to earn a high salary and work from anywhere.

I thank my lucky stars that I made the jump 15+ years ago and have stuck with it for all these years.

4 simple steps I'd take if I were starting today: ⤵️
🟢 Step 1: Start with SQL

Learning everything you need to know about data analytics all at once is impossible.

Instead, start with SQL.

Head over to (it’s free) and start working on practice problems.

Start at 30 minutes and commit to daily practice.sqlbolt.com
If you want to master the fundamentals of SQL in 30 days, check out Solving with SQL.

• Live group coaching sessions
• Mentorship and accountability
• Real-world business problems with SQL

Join the October cohort waitlist:

solvingwithsql.com
Read 18 tweets
Mar 4, 2023
Online Data Analytics Portfolio Hosting 101:

The step-by-step process to creating an awesome portfolio website in 60 minutes or less: ⤵️
Many beginner data analysts waste a lot of time trying to get their portfolios online:

• Using amateur-looking platforms like Google Sites
• Using clunky sites like Kaggle and GitHub
• Procrastinating because it’s too hard
But, your online data analytics portfolio sends a signal: "I can solve problems with data."

And recruiters and hiring managers know what they need:
• Professionals that can work with data
• Analysts that know how to think
• Sample work to show skills
Read 18 tweets
Mar 2, 2023
Data analytics is a great career choice.

I’m so happy I made the jump 15+ years ago and have stuck with it for all these years.

Here are the exact steps I would take if I were starting over in data analytics today: ⤵️
🟢 Step 1: Start with SQL

Learning everything you need to know about data analytics all at once is impossible.

Don’t even try.

Instead, start with SQL. Head over to sqlbolt.com (it’s free) and start working on practice problems.

Start at 30 minutes. Repeat daily.
Unfortunately, many analysts won’t bother learning SQL first.

Instead, they:
• procrastinate.
• get distracted
• aim for perfection
• switch to something else

Don't let impostor syndrome set in and rob you of your future as a data analyst. Avoid it like the plague.
Read 16 tweets
Feb 28, 2023
Learning SQL is an absolute must for aspiring data analysts.

Fortunately, there are places online where you can learn this invaluable skill – without paying a penny.

Here are 8 free websites to sharpen your SQL skills:⤵️
1) KDNuggets

Learn how to create a table, insert values, and use SQL commands to solve this case study.

Learn more: t.ly/sql-case-study
2) InterviewQuery

Work through example business issues, define metrics, and write the SQL to solve each problem.

Learn more: interviewquery.com/p/sql-case-stu…
Read 11 tweets
Feb 26, 2023
The step-by-step process to find awesome datasets for your next data analytics portfolio project: ⤵️
Many beginner data analysts have trouble finding a usable data set for their portfolio.

The problem?

There are 86 zillion "free" data sets online, but 99% of them suck.

And if you think just Googling will help, you're dead wrong.

Here's how to find the best ones (for you):
🟢 Step 1: Find a data set that interests you

By finding a data set that’s interesting to you, you’ll actually be excited to include it in your project.

Where to look:
• Real World Fake Data
• Data Is Plural

Here are some portfolio-ready examples from each one:
Read 16 tweets
Feb 9, 2023
Data Analytics Portfolio Project Writing 101:

How to write about your data projects without being boring – even if you feel like you have nothing to say:
Writing well about your projects has long-term benefits:

It shows you know how to:
• think through problems
• explain your work with ease
• structure projects from start to finish

The problem?
Most beginner data analysts don't realize the power of writing and miss out on the benefits.

Fortunately, you can crack the code on your project write-ups so that you never have to stare at the blank page again.

It's called the STAR Method.

And here's the step-by-step process:
Read 14 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us!

:(