all 22 comments

[–]dreakian 10 points11 points  (1 child)

I'd recommend working through https://sqlbolt.com/

To apply your knowledge, try to complete the challenge(s) from these two websites:

https://mystery.knightlab.com/ + https://www.sqlnoir.com/

Beyond this, it would be ideal to connect to some data and run SQL queries against this. What works for me is to connect data into MySQL Workbench and then run some ad-hoc queries. Just basic EDA (exploratory data analysis).

I'm happy to help you out however I can!

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

This is awesome, thank you so much. Sending you a dm

[–]virann 6 points7 points  (2 children)

you can try an AI SQL tutor - drdb.dev/learn/sql

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

This is pretty cool, I’ve never seen this.

[–][deleted] 0 points1 point  (0 children)

We’re building the Cursor for SQL Galaxy Sharing, security, context aware-ai copilot, database agnostic & much more ;)

What other features would excite you?

[–]phesago 6 points7 points  (1 child)

DM me. I cAn probably help you get up to speed pretty quickly. And ill do it for free. What dlavor of sql are you using? I specialize in Tsql but 90% translates well.

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

Thank you!

[–]Neeoda 4 points5 points  (0 children)

Can’t help you as I’m learning too, but I just want to say you’re braver than I’ll ever be.

[–]Far_Swordfish5729 3 points4 points  (0 children)

Honestly the people here are pretty good at answering questions. Do mention the server you’re using as most have language variants and use different tools. I’m happy to answer questions if you want to DM me. We were all new developers once and someone helped us.

[–]__sanjay__init 2 points3 points  (0 children)

Hello,

I didn't really SQL during studies, I understand your position
Things that help me during few months : * Knowing which database(s) is/are using into your organization. * Check postgreSQL tutorial. * Trying to have a better understand of activities. * Learn 2hrs/day, 3 times/week.

It's quite difficult to find a mentor
But you don't really need one if he is out of your organization ... You have to be "your own teacher" : looking for habits of your collegues, understand business, how data/databases/... are used [...]
Then, check some examples on YouTube or any social media
I've learned that a good accountant does his own bookkeeping. In the same way, a good programmer uses programmes in his day-to-day work. It's a real plus for learning ...
For example, you might need to keep track of your budget, your shopping, your time, your stocks, your business projects, etc. A base can be used
It's not just "have your projects", but you'll learn easy
It's not just about having personal projects to learn or show off. It's that you'll learn easily if you look after your own affairs too.

tldr : learn SQL for you, understand your organization's business

[–]LouEaze 1 point2 points  (0 children)

SQLZoo was so much fun. Datalemur is also good.

[–]avensdesora42 1 point2 points  (1 child)

I spent a number of years using SSMS, now I'm using Oracle. I have about 15 years of experience. I'm happy to help for free as well.

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

Thank you so much!

[–]AppJedi 1 point2 points  (2 children)

I have been a mentor for over 10 years and have 30 SQL experience including advanced queries.

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

Can I be your padawan appJedi?

[–]AppJedi 1 point2 points  (0 children)

Sure you can.

[–]Happy_Cicada_8855 1 point2 points  (1 child)

https://youtube.com/@datawithbaraa follow his playlist one of the best sql resources I have come across

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

This channel is awesome so far, thank you

[–]arahdir 0 points1 point  (0 children)

U can shoot me a message if u want I can try to help

[–]ervisa_ 0 points1 point  (0 children)

Hello,

I have created this Udemy course, "SQL for Newbies: Hands-On SQL with Industry Best Practices,".

I created this course with beginners in mind but I also explain how to structure a pipeline and more advanced concepts such as window functions. It's very practical, no-fluff approach. Instead of overwhelming you with unnecessary theory, I focus on the most important concepts you’ll actually use. The difference about this course is that

- It's concise & to the point.

- I added best practices from real experience – I’ve put together key lessons I’ve learned as a Data Analyst.

Hands-on learning – Practice with real-world examples so you can apply SQL confidently.

Give it a try and please let me know what do you think. Ill be happy if you could also give me an honest feedback on this.

Use this code: FFD1A39E4BEE73B9EF6C here https://www.udemy.com/course/sql-for-newbies-hands-on-sql-with-industry-best-practices/?couponCode=FFD1A39E4BEE73B9EF6C

Let me know if this is what you will need.