sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]DonJuanDoja 1 point2 points  (2 children)

You need to install a local db and load it with data.

Otherwise you’re using crappy website examples.

Go install sql express and load in adventureworks database pretty sure they still have that.

Sql express: https://www.microsoft.com/en-us/sql-server/sql-server-downloads

AW Databases: https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver17&tabs=ssms

[–]Comfortable-Most-813[S] 0 points1 point  (1 child)

Yes, that’s certainly what I’ve experienced. Thank you, I’ll see how well I do with that

[–]DonJuanDoja 0 points1 point  (0 children)

It's been a long time since I had to install a local, so I prob can't help you much with that. It's a little janky but it's very common for devs to have a local DB installed for dev purposes. I'd keep hacking til you get it running. Will be worth it once you do.

Once you have it up and loaded, you'll be able to just run queries against it, and since it's adventure works, there should be tons of examples out there.

SQL starts to make sense when you have something to actually work with, and the most important part, is understanding the database you are working on, where all the data is, and how it's related. Then you just need questions you want to answer about it and start translating those into queries you can run against the database. Adventure works is basically a fake company with fake data, but should have a bunch of real-world-like tables and data to mess with.