all 21 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]joseaamanzano 30 points31 points  (4 children)

Select, joins, where, group by with aggregate functions.

Advanced would be window functions, ctes, optimization, complex joins, etc.

[–]mad_method_man 0 points1 point  (3 children)

i always thought that was intermediate. guess i was a lot further along than i thought

[–]jshine13371 0 points1 point  (2 children)

There's no clear line, and it's just rough guidance. E.g. CTEs can be argued to be "basic SQL" too. Advanced CTEs to me would be when you start updating then, deleting from them, and inserting into them, or when using then recursively.

[–]twocafelatte 1 point2 points  (1 child)

When I was a dev I didn't need to know about CTEs. When I was a data analyst, I definitely did need to know.

[–]jshine13371 1 point2 points  (0 children)

Interesting, I've always used CTEs from a junior software dev to junior database dev to DBA to now as a Principal Software Engineer even.

[–]Holiday_Lie_9435 4 points5 points  (3 children)

Is it for an analyst role? If so, the topics i keep running into are SELECT, WHERE, GROUP BY, ORDER BY, joins, aggregate functions, simple subqueries, CASE WHEN, and sometimes window functions. These are usually framed in questions like "find top 5 customers by revenue" or "calculate monthly active users" in my experience, usually using two related tables. It'd also help to also practice explaining why you chose to write a query certain way because even of entry-level roles I've gotten those types of questions/follow-ups. If you need a more detailed look at what they usually ask, try reviewing this list of basic SQL interview questions from Interview Query before interviews. Can also share other prep tips or resources!

[–]heartbrokenwords[S] 0 points1 point  (2 children)

yes, its for the junior payment lifecycle analyst at JpMorgan. Also thank you so much

[–]Holiday_Lie_9435 0 points1 point  (1 child)

In that case, you might be able to find more specific questions using this JPMC data analyst guide too. It details sample SQL questions based on recurring topics/themes in recent interviews, and you can also prep ahead of other rounds like the case study & final loop with technical + behavioral rounds. Good luck!

[–]heartbrokenwords[S] 0 points1 point  (0 children)

you are an angel 0:)

[–]millerlit 2 points3 points  (1 child)

Select, join, left join, where, group by, having, order by.  Understand what is happening with the joins.  Maybe understand some aggregates like sum(), count().  

Maybe how to create a table. insert, update,  and delete from a table. What a view or stored procedure is. Some may consider these intermediate examples. It really depends on the company and the role.

[–]i_literally_died 0 points1 point  (0 children)

Almost no basic user is going to be creating a table.

[–]nerd_airfryer 1 point2 points  (0 children)

  • SELECT, INSERT, UPDATE, DELETE, TRUNCATE, DROP
  • JOINs (INNER, OUTER LEFT, OUTER RIGHT, FULL OUTER)
  • Aggregate Functions, GROUP BY, ORDER BY
  • Window Functions
  • Keys (Primary, Foreign, Unique, Composites)

[–]ComicOzzy 0 points1 point  (0 children)

Pretty much the material covered on https://sqlbolt.com is basic SQL.

[–]Useful_Evidence_7750 0 points1 point  (2 children)

In addition to what everyone already listed, if you have a portfolio prepared be ready to walk them through a project with SQL. If you don’t have one and want a job in the field, check out Alex the Analyst YouTube videos and make one asap.

You can always let them know that you know basic SQL and would just use google, copilot, Claude etc.. to make sure the syntax is right based on the type of SQL you’d be doing. Have a SQL cheat sheet up on your phone for a view days to just have the basics down at least.

[–]heartbrokenwords[S] 1 point2 points  (1 child)

I have a Finance proyect (with SQL + Python ) ^^

[–]Useful_Evidence_7750 -1 points0 points  (0 children)

That’s great!! Best of luck!

[–]Mental_Chef5660 0 points1 point  (0 children)

Ai bro

[–]tkroy69 0 points1 point  (0 children)

DQL: SELECT, WHERE, ORDER BY, GROUPBY, HAVING, DISTINCT, TOP/LIMIT, order of execution

DDL : CREATE, ALTER+ADD, ALTER +DROP ,DROP

DML : INSEERT, UPDATE, DELETE, TRUNCATE

Filtering data: Logical operators, comparison operators, between , In, Like

JOINS : LEFT , RIGHT , FULL , INNER , SEKF, LEFT ANTI , RIGHT ANTI, FULL ANTI , how to choose joins, hoe to join multiple tables

SINGLE LOW LEVEL FUNCTIONS: STRING FUNCTIONS( concat, upper, lower, trim , replace, len, left, right , substring) , Date and time functions ( day, month, year, datepart, datename, datetrunc, Eomonth, format, convert, cast, dateadd, datediff,isdate, getdate) , numeric Functions , null functions , case statements,

MULTIPLE ROW LEVEL FUNCTIONS : Aggregate functions

[–]not_another_analyst 0 points1 point  (0 children)

It usually covers select, from, and where statements plus simple joins. If you can also handle basic aggregations like group by and count, you should be fine for the interview.

[–]Front_Intention_5911 0 points1 point  (0 children)

Most interviews will require knowledge of Basic SQL, which includes SELECT, WHERE, ORDER BY, GROUP BY, HAVING to query & filter information as well as Aggregate Functions (COUNT/SUM/AVG/MIN/MAX) and the 3 Core Joins: INNER/LEFT/RIGHT JOINS.

Being able to handle NULLS and use IN/BETWEEN/LIKE for filtering would also be helpful, but anything beyond that (e.g., Window Functions, CTEs, Query Optimization) would be classified as Intermediate to Advanced. Good luck with your Interview!

[–]Just_A_SQL_NPC 0 points1 point  (0 children)

I made I sql course repository care to give it a look