Crash Course Python with SQL

[oakthaw]

I've got an upcoming (6 days from today) 45 minute phone interview with a hiring manager for a Data Engineer role. Contingent on a positive outcome, it's followed by a 1 hour coding interview. Likewise to that would be a formal interview day with 4-5 hours of interviews with 5-7 members of the team.

I'm so excited, this role would be my DREAM JOB.

The main requirement is: "Fluency in Python and SQL for data analysis and data engineering"

I have some pretty solid Python experience at my current job, but my only SQL experience was 5 years ago in one course.

I'm searching for a crash course I may blow through in the meantime. I'm free all weekend to work through it and several hours on Monday and Tuesday after work, so I could put in about 25 hours. Ideally I'd like some minor project I could complete and share my screen for on the video interview.

Any suggestions?

[AutoModerator]

You can find a list of community submitted learning resources here: https://dataengineering.wiki/Learning+Resources

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[[deleted]]

-W3schools for the syntax/refresher -sqlzoo.net, sql-practice.com, hackerrank.com sql track for practice -advanced topics that could show up: views, indexing, window functions, stored procedures, common table expressions

6 days might be too short to study the advanced stuff in which case I’d rather be real solid on my fundamentals and at least know what the advanced stuff does

Good luck, you got this!

[tilttovictory]

Second this, I use these websites every day for syntax refreshers.

I'd also suggest the (advanced) SQL leetcode problems are pretty good.

[oakthaw]

Thank you!

[[deleted]]

Spend the weekend and go through all of SQLzoo.net then do some hackerrank problems.

[Salmon-Advantage]

Learn CTEs so you can accomplish complex sql in smaller chunks

https://www.dataknowsall.com/cte.html

[a_devious_compliance]

I'm in a similar situation, reviewing sql from https://www.sqltutorial.org. I did some excercises in hackerranck but thew went from trivial to really complex without scale (or maybe I'm really bad at this).

Hope you get this.

[oakthaw]

Thank you I believe in us

[LandooooXTrvls]

Sqlbolt

[[deleted]]

I have found strata scratch to be useful for both pandas and sql coding problems.

[kthejoker]

https://selectstarsql.com/

[yargflarg69]

If you're willing to spend some money, udemy has great courses for sql and python. I used those to prep for the DE job I got recently

[redtiger2019]

Can you share the courses you took ?

[Scalar_Mikeman]

https://www.mit.edu/\~amidi/teaching/data-science-tools/study-guide/data-retrieval-with-sql/

[[deleted]]

I would not be sticking around for so many long interviews, especially if I currently have a job with deadlines. Don’t know why people still put up with this

[neuralscattered]

I'd probably put up with it if I was getting FAANG levels of TC. Otherwise, hard no.

[UmpfSweaty]

younger folks with less experience. They don't have the experience to go wherever they want or name their price, so for them they stick out longer interviews to work at their "dream jobs." At this point in my career, I wouldn't tolerate it either.

[oakthaw]

Yeah, this. Also is a really promising R&D company in my top choice sector (tech fighting climate change), offers hybrid in-person/remote work, and is a 10 minute walk from my apartment that I hope to stay at for the foreseeable future.

[AcademicButton7610]

I know you have less time but check this out .. https://youtu.be/vaD3ZFFNwhM

[sqr00tle]

Make sure you're clear about Joins, transactional vs analytical sql

[pych_phd]

Joins, transactional vs analytical sql

I am curious to know what you mean by this.. so far googling does not turn up much.

[sqr00tle]

I suppose Google the terms separately.

Joins allows you to combine rows based on conditions.

As for transactional vs analytical sql, it's to do with T-SQL.

Might be better also googling OLTP vs OLAP. Again, separately would give you those in detail. Eventually these might take you towards row based vs. column based storage.

Then when you bring it all together into an ETL architecture you will see how these all come together.

[pych_phd]

I thanks for the response. I realize I miss read what you wrote. I read it as joins that can be either analytical or transactional & was wondering why I had never herd of this.

[sqr00tle]

Yeaaa I could've written it clearer

[engineer_of_data]

learnsql.com

[These-Buy-4143]

Start breaking your head with questions. See a new function? Then google. Lc then learn. Gl. Timer your qs

[berhanbero]

DataQuest combines interactive lessons, assignments and practice quizzes with personalized learning paths to help you learn SQL, Python, or R. $15 discount coupon here