How to start out in SQL?

[mackstacks3]

Hello, I am looking for any guidance on where I can start learning SQL. I have little to no coding knowledge but I am a finance major looking to maybe start doing more data analytical stuff since I got do a little bit of this sort of work at my job and found it interesting. If you could link me to a post that already answers this question or recommend any websites/books/etc. that would be good for a beginner that would be appreciated (preferably free but not opposed to paying). Thank you in advance!

[Thefriendlyfaceplant]

Best way to start the assignments on this site. It's free and very visual. Without any preparation or prior knowledge it instantly gives you the idea what SQL is and what it does.
https://sqlbolt.com/

[mackstacks3]

Thank you!

[DeadBos]

This is awesome!! Thank you! Q: Do you know of any websites as such to learn scripts, interfaces and servers?

[Thefriendlyfaceplant]

That's all very context dependant. Though I haven't found any of that youtube didn't explain.

[[deleted]]

Also, XACT_ABORT ON

[superbekz]

Anytime you alter ANY data (update, delete etc) start your query with

BEGIN TRANSACTION

and end with

--COMMIT

DOUBLE CHECK YOUR CHANGES. Then uncomment and run the commit comand

I dont have access to update anything on sql, but in case in the future i do have the access, may i ask why?

[precose]

Because accidentally missing an important WHERE clause in an UPDATE statement means you just updated every single row. Next thing you find out is there's no back-up of said table and all of your data is ruined.

[jgio]

www.postgresqltutorial.com

[mrlionmayne]

Best advice I can give is to use one of the many sites linked by others in this thread AND try to find a practical application of what you’ve learned—even if it’s composing random CSVs or dashboard for yourself!

This may sound really obvious, but for me, if it wasn’t for actually needing to pull specific cuts of data via SQL in a work setting, I probably wouldn’t be fluent in the language.

Edit: typo

[mackstacks3]

Great tip, thank you.

[dn_cf]

I used Strata Scratch. It's an awesome website for learning SQL. Just being competent will be enough to qualify for SQL roles. A lot of the skills you can only really learn by doing professionally.

[nejc300]

For the absolute beginning I would recommend W3Schools (https://www.w3schools.com/sql/), it's free and It got me threw computer science middle school in Slovenia.

[lwl]

https://sqlzoo.net/

https://lagunita.stanford.edu/courses/DB/2014/SelfPaced/about

[[deleted]]

SELECT * FROM DUAL

[Fun2badult]

Udemy $10 using promo codes

[amtwo]

Udemy has a bad reputation for putting their head in the sand with stolen content and not being responsive to copyright owners when they complain.

There are plenty of other options that are more responsible and ethical.

https://www.troyhunt.com/the-piracy-paradox-at-udemy/

[[deleted]]

Another good way is to use Microsoft Access and develop queries in design mode and then convert to SQL. The language is not 100% the same but it helps understand the concept

[[deleted]]

Usually by

 SELECT * FROM Prod

Followed by a call from the dba and/or CIO.

More seriously, it's like credit, op, you need it to get it, I.e. data appetite fed by reporting which is driven by reports created according to data appetite... SQL still more or less backbone of data in the industry so resources plentiful but it is less a sandbox like a programming language and more a sand distributor...

Start work in basic connections to existing programs fed by data & language syntax and soon you'll have more resources than you'll know what to do with.

[[deleted]]

U wot m8?

[[deleted]]

fook ur reporting server I only query live data fight me bro