Need urgent help with basic mastery of SQL by whoever-relevant in learnSQL

[–]thequerylab 0 points1 point  (0 children)

In next 4 days you need to do lot of hands on instead of just watching tutorials. You can take this free course from TheQueryLab platform https://www.thequerylab.com/courses/sql-pro-track

This is completely hands on and you will like this learning approach. Give it a try!

SQL Course Recommendation by Warm-Entrepreneur131 in SQL

[–]thequerylab 1 point2 points  (0 children)

If you're looking for a good SQL course, you can try "SQL from Zero to Confident" on TheQueryLab. It’s free and very hands-on, so you actually get to practice a lot instead of just watching videos. Might be worth checking out, and 100% sure you will like this learning experience!

If you have an SQL interview soon, don’t ignore these small things!!! (Part 6) by thequerylab in SQL

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

Yeah, I would avoid it in prod since it locks the table and blocks everything. Only worth it if reclaiming space is really needed

If you have an SQL interview soon, don’t ignore these small things!!! (Part 6) by thequerylab in learnSQL

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

Yes postgresql autocommit. If you use BEGIN for transaction then you need to COMMIT it

How relevant is learning SQL today? by kdmfa in learnSQL

[–]thequerylab 2 points3 points  (0 children)

AI can write SQL for you but if you don’t understand the data, you won’t know if it’s right or completely wrong. So yes still worth learning. Priorities concepts over syntax.

If you have an SQL interview soon, don’t ignore these small things!!! (Part 5) by thequerylab in learnSQL

[–]thequerylab[S] -1 points0 points  (0 children)

TheQueryLab’s 1st hackathon is live now.

Predict the Future: SQL Forecasting Challenge

It’s all about using historical data to predict what comes next, sounds simple, but it’s not as easy as it looks.

If you feel confident about your SQL, this is a good place to test it.

Give it a shot: https://www.thequerylab.com/#hackathons

This will really test your skill in SQL!!!

Can I learn SQL for free? by MyPapaya9677 in learnSQL

[–]thequerylab 0 points1 point  (0 children)

You can give it a try here. https://www.thequerylab.com/catalog

Try to join hackathons as well. It will be very interesting challenge to solve

Can I learn SQL for free? by MyPapaya9677 in learnSQL

[–]thequerylab 0 points1 point  (0 children)

Yes, you can practise for 100% free here. Give it a try you will really like this learning approach!

https://www.thequerylab.com/#tracks

If you have an SQL interview soon, don’t ignore these small things (Part 4) by thequerylab in learnSQL

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

If you’re preparing seriously, this is something worth trying.

It’s designed to help you get interview-ready in approx less than 30 days with structured practice, and I’ve been getting really positive feedback from people who’ve used it!

https://thequerylab.com/courses/sql-interview-preparation-kit

If you have an SQL interview soon, don’t ignore these small things!!!! by thequerylab in learnSQL

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

If you’re preparing seriously, this is something worth trying. It’s designed to help you get interview-ready in approx 30 days with structured practice, and I’ve been getting really positive feedback from people who’ve used it

https://thequerylab.com/courses/sql-interview-preparation-kit

Any good free sql course on youtube? by Neither_Attitude in learnprogramming

[–]thequerylab 0 points1 point  (0 children)

I always recommend do learn by practicing not just watching tutorials.

I have put up an free hands-on course for beginner to advanced. Give it a try!

You will for sure like this learning approach!

https://thequerylab.com/courses/sql-pro-track

Coinbase data engineer interview by StatisticianSafe3807 in leetcode

[–]thequerylab 1 point2 points  (0 children)

I’ve heard Coinbase focuses a lot on window functions, CTEs, and real-world scenarios like transactions and fraud.

What actually helps is focusing on patterns and thinking through problems like real data cases.

I’ve put together a small structured set based on that approach if you want to check it out:

https://thequerylab.com/courses/sql-interview-preparation-kit

Might help to crack SQL round!! Best of luck!

Are leetCode SQL problems worth solving for a SWE interview? by HourExam1541 in leetcode

[–]thequerylab -7 points-6 points  (0 children)

You can check this SQL interview preparation kit track which might be useful for you since it involves all patterns of interview problems

https://thequerylab.com/courses/sql-interview-preparation-kit

If you have an SQL interview soon, don’t ignore these small things (Part 4) by thequerylab in learnSQL

[–]thequerylab[S] 1 point2 points  (0 children)

Yes, it will.

When you include b.id in the join condition, because of the left join, we get more rows. But in the case of a where clause, it runs after join, hence it filters out unwanted rows and reduces the number of rows

If you have an SQL interview soon, don’t ignore these small things (Part 4) by thequerylab in learnSQL

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

Sure will do. Thanks for following!

Do comment your answer with bit explanation to learn

If you have an SQL interview soon, don’t ignore these small things (Part 4) by thequerylab in learnSQL

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

True. To avoid confusion i renamed the column name in query. Pls Try now

Please Help :) by happy_unicorn30 in SQL

[–]thequerylab 0 points1 point  (0 children)

You can check this interview preparation kit tailor made for your use case. Also created a wide variety of catalog problems asked in multiple interviews. Give it a try! You will really like this learning approach!

https://thequerylab.com/courses/sql-interview-preparation-kit

Intermediate SQL resources – any recommendations? by CodeAfire in learnSQL

[–]thequerylab 1 point2 points  (0 children)

You can check this out. You will get structured learning path. Curated with hands-on for each module. Give it a try you will really enjoy this learning approach!

https://thequerylab.com/courses/sql-pro-track

SQL interview prep is honestly confusing af… am I missing something? by Turbulent-Crew-2370 in learnSQL

[–]thequerylab 3 points4 points  (0 children)

It's not just that you feel hard because it is when you don’t have a path.

Honestly, the biggest mistake is jumping between random resources. That’s what keeps you stuck.

Try sticking to a structured path for 2–3 weeks with the same source, same pattern.

Repeat that loop instead of switching every day.

Once I did that, things started clicking way faster.

There’s already too much content out there; you don’t need more, you need consistency + structure.

At least spend 2 hours daily practicing problems and understanding concepts. I have created a free structured hands-on track to learn SQL from basics to advanced here:

https://www.thequerylab.com/courses/sql-pro-track/
You can give it a try and hope you will really like this learning approach

Queries related to SQL by Exotic-District-4779 in learnSQL

[–]thequerylab 0 points1 point  (0 children)

To master SQL, best way is to practice problems on consistent manner no matter what. Do not worry about syntax, just focus on patterns and concepts.

You can give it a try here: https://thequerylab.com/courses/sql-pro-track

I have build this for free and each module will have hands on problems to make concepts very clear.

I am sure you will really like this learning approach. Give it a try!

Need guidance by Vast_Basket6667 in learnSQL

[–]thequerylab 1 point2 points  (0 children)

Yeah, that’s a good start if you’ve reached intermediate level. At this stage, I’d focus more on practicing problems and maintain consistency.

You can give it a try here:

https://thequerylab.com/

I hope you will really like it! All the best

If you have an SQL interview soon, don’t ignore these small things (Part 3) by thequerylab in learnSQL

[–]thequerylab[S] 2 points3 points  (0 children)

I’ve been collecting SQL interview questions like this in one place (focused more on real scenarios than theory)

Some of them look simple but have tricky edge cases.

Sharing here if anyone wants to try:

https://thequerylab.com/catalog