How to Master SQL to Get Your First Job

Are you getting stuck in writing queries. Your are in the right place after reading this you will get relaxed and you will be confident to solve the problems.

Birappa Goudanavar
The Data Analyst Toolkit
2 min readJan 16, 2022

--

Nothing comes in handy until and unless you put efforts.

https://link.medium.com/pFdZTXpwMnb

I am share you the best resource and topics to master SQL

10 places to start your SQL journey, today:

  1. Zachary Thomas' SQL Questions https://lnkd.in/g-JJzuD
  2. Select * SQL: https://selectstarsql.com/
  3. Leetcode:https://lnkd.in / g3c5JGC
  4. LinkedIn Learning: https://lnkd.in/gQXFc4n
  5. Window Functions: https://lnkd.in/g3RtPCJ
  6. HackerRank: https://lnkd.in/grv_9sB
  7. W3 Schools: https://lnkd.in/gJPfrrv
  8. CodeAcademy: https://lnkd.in/gT5xmpN
  9. SQLZOO: https://sqlzoo.net/
  10. SQL Bolt: https://sqlbolt.com/

Want to upgrade your SQL skills for an interview or for your job? Here's how I'd break down your time:

Common topics (should master these):

  • SELECT and WHERE for filtering and selection 2. COUNT, SUM, MAX, GROUP BY, HAVING for aggregating data"
  • DISTINCT, COUNT DISTINCT for producing distinct lists and distinct aggregates
  • OUTER (e.g. LEFT) and INNER JOIN when/where to use them
  • Strings and time conversions
  • UNION and UNION ALL.

Topics that come up regularly (be familiar with them):

  • DML/DDL/DCL concepts
  • Handling NULLs creatively (e.g. with COALESCE)
  • Subqueries and the impact of subqueries on efficiency of the query
  • Temporary tables
  • Self joins
  • Window functions like PARTITION, LEAD, LAG, NTILE
  • UDFs (user defined functions)
  • Use of indexes in querying to make operations faster.

Important, but more rare topics (useful to know):

1. Recursive CTES

2. Dynamic SQL generation

3. Query optimization

4. Materialized views

This book will teach how to make your day and work productive in smart way using 80/20 rule .

Great insights in its books like about .Happy minds are around 31 % more productive compare to others. Doing analysis of your down time
Write down your random thoughts in your minds and compare it with past present or future.
There are so many facts and dots involved to make your mind productive machine
Must read for people interest building there hustle product.

--

--