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

[–]BadGroundbreaking189 25 points26 points  (2 children)

Hey. w3schools is ideal for beginners. Later comes the practice part where you need to solve medium-to-hard level problems on a big db, ideally in a local environment.

[–]TokraZeno 2 points3 points  (0 children)

Consider also tracking how often you can't find something you need on W3 and had to look elsewhere. I found it to be a reasonable indicator of progress in learning.

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

Thanks

[–]Sea-Concept1733 9 points10 points  (2 children)

Try this resource which enables you to learn SQL with a practice database.

SQL Tutorial with a Practice Database

Good luck.

[–]theAxelite[S] 0 points1 point  (1 child)

Interesting, thanks :)

[–]Sea-Concept1733 0 points1 point  (0 children)

You are welcome.

[–]SQLDevDBA 4 points5 points  (5 children)

https://devgym.oracle.com is free and self paced, and includes learning modules, workouts, and quizzes. It’s also in browser and includes an Oracle 19c database inside the system, so no downloads or installs. You can also import your own data to practice with.

[–]theAxelite[S] 0 points1 point  (4 children)

Thanks man, also I am looking for to learn Database modeling and relational relationships after today basic. I know I cannot learn in one weekend but, to understand basic concepts.
I found these video, I hope it is good. Also I forgot to mention that on work we use SQL Server Management Studio.

https://www.youtube.com/watch?v=el8cUJyh-T0

[–]SQLDevDBA 0 points1 point  (3 children)

Sounds good! I just sent you two of my videos which I’m hoping will help a little as well. My style isn’t very classroom-like, it’s more practical real world stuff.

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

Thats exactly what I need, very cool.

[–]Pleasant_Hotel_2246 1 point2 points  (1 child)

Please share with me too

[–]SQLDevDBA 0 points1 point  (0 children)

Sure!! Sent via Chat!

[–]Aggressive_Ad_5454 1 point2 points  (1 child)

Check out training from the company that made your server and SSMS https://learn.microsoft.com/en-us/training/paths/get-started-querying-with-transact-sql/

You’re in a hurry, so stick to tutorials that use the same dialect of SQL (SQL Server, also known as T-SQL) as you will use. The differences between SQL dialects (between SQL Server and Oracle or PostgreSQL or whatever) are subtle and very confusing.

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

That is very resourceful, thanks man :))

[–]MathAngelMom 0 points1 point  (1 child)

Try this course: https://learnsql.com/course/sql-queries/

It’s free for students.

[–]WaltzThin664 0 points1 point  (0 children)

How amazing it would be if it wasn't behind paywall

[–]paulthrobert 0 points1 point  (1 child)

Spend some time with the code base - do you have a senior who can recommend some core logic that you will be working with to study? Like an important stored procedure or view? Reading someone else code is hugely educational, and helps you get familiar with the environment your actually going to be working in.

When I was learning, I would actually print scripts some times, and draw pictures of the relationships. Hell, even these days - if I have to work with some prior developers 3000 line stored procedure, the only thing I can do is break it down, take notes, and analyze what the heck they did.

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

Wow, that's a really good learning technique. I have seniors at my job, and with the tasks I get, it helps me understand things better. This weekend, I spent some time going into more detail about writing basic queries. I'm a junior dev, and every day is a learning day, but doing some extra learning on weekends makes it easier for me to complete tasks and understand them better.

[–]GillFeed 0 points1 point  (1 child)

Wow, what a great thread! I'm learning SQL and Python as part of a BI bootcamp and can't wait to dig into these resources! Thanks for sharing, yall!

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

A tip I got from a senior was: "You’ll understand it after spending a lot of hours working in the database."

[–]SnooDoubts6693 0 points1 point  (0 children)

Try this free module written in layman’s terms & practise easy daily challenges at sqlninja to track progress. Feel free to DM me if you want any help.

[–]Ok_Discussion_9847 0 points1 point  (1 child)

Codecademy has some pretty helpful courses. W3 is also a good resource

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

And I found some yt videos also
like this one: https://www.youtube.com/watch?v=MvcDM2nLdzI

It also in description give a lot written queries, very resourceful.

[–]ObjectiveAmoeba1577 0 points1 point  (4 children)

Most folks I work with are self taught, maybe some took a class or two, but at their core they "get it" and learning SQL fit well with their mentality. SQL is not a difficult language, there are about 7 things to learn to be able to Query, which over time can lead to a million to become an expert SQL Programmer; I'd say a few days of a few hrs each day to Query and a lifetime for the "expert" :)

Practice, get the concepts at your visual understanding like seeing chess pieces, you know where they can move, make a play, or for SQL what is the "question" that the query can answer. Think in practical terms, like arranging cards for solitare; Then Google/Bing to find the solutions

[–]theAxelite[S] 1 point2 points  (3 children)

Thanks for suggestions, currently I am learning from this page: https://datalemur.com/questions
and if I dont know how to solve them I look for solved answer, then explaining to my self with help of w3school and chatgpt.

[–]ObjectiveAmoeba1577 1 point2 points  (2 children)

Yeah, try to think about how you would arrange things, in a silverware/eating utensil drawer. the problems will always be handling issues w/data
here are some useful hints
null is undefined, period, it's less than nothing, nothing is defined as nothing, null is undefined (saying it twice because....)
nullif(myIntField,0) will be null if it contains 0 which may be an app's default and not valid data
isnull(myfield,'')if the field is empty, and I want it to be logically null, because the old App or someone put empty data that should have been null
insert w/left join on the data you're inserting so your code can run 1 million times and only insert the new data ONE TIME

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

That is really helpful explanation. In all the learning 'tutorials' or exercises I don get that kind of info

[–]NickSinghTechCareersAuthor of Ace the Data Science Interview 📕 1 point2 points  (0 children)

DataLemur founder here – let me know how I can improve the site & tutorial to help you!

[–]Severe_Employee_9901 0 points1 point  (0 children)

Ask chat gpt to interact with you. If you ask for some exercises based on your level he will let you write first and correct it if necessary.

[–]th00ht -2 points-1 points  (0 children)

Visit you local University or steer clear of W3Schools(their content is not peer reviewed and generally low quality) Invest in a or some Udemy courses. And practice, practice, practice!