SQL

chopperrus

chopperrus

Midfield
Morning all

I need to start teaching myself how to query a SQL database for my role at work. I don't need to be advanced straight away but to be able to query a few tables and lookup tables between 2 dates etc. Can anyone recommend a decent book to get me started please?

Cheers
 


chopperrus said:
Morning all

I need to start teaching myself how to query a SQL database for my role at work. I don't need to be advanced straight away but to be able to query a few tables and lookup tables between 2 dates etc. Can anyone recommend a decent book to get me started please?

Cheers
Click to expand...

you’ll get more value from online resources - have a look on coursera or udemy for freebies
 
chopperrus said:
Morning all

I need to start teaching myself how to query a SQL database for my role at work. I don't need to be advanced straight away but to be able to query a few tables and lookup tables between 2 dates etc. Can anyone recommend a decent book to get me started please?

Cheers
Click to expand...
These were always great books to learn from back in the day (I'm talking close to 20 years ago when I learned) but I would agree with the above poster suggesting online is the better option now.

SQL For Dummies By Allen G. Taylor | Used | 9780470046524 | World of Books

Buy SQL For Dummies By Allen G. Taylor. Available in used condition with free delivery in the UK. ISBN: 9780470046524. ISBN-10: 047004652X
www.worldofbooks.com www.worldofbooks.com
Kborom said:
SQL for dummies will have the basics in the first few pages I would think, how to use it rather than just listing commands. I found that a basic level is easy peasy
Click to expand...
:lol: Seconds before me.
 
Years ago when I got chucked in at the deep end, I cheated a bit. Linked the tables to an Access database and created the queries in there. You are better off learning it properly though.
 
I learned it from a course on Udemy. The complete SQL bootcamp, but that was PostgreSQL. The types of SQL are mostly similar with some syntax differences. This was about 5 years ago mind. Plenty of resources on YouTube though. It can be possible to learn the basics in a few hours. Download SQL Express and away you go.
 
Little trick I learned AFTER dropping a pricing table on a live db once, start a query with begin trans and end with rollback, or something like that. Lucky for me no-one realised what had happened so we only lost a couple of hours transactions
 
Bog standard stuff where the syntax will be the same across all flavours of SQL. Just search for a basic primer.

W3schools is a good place to start.
 
Last edited:
chopperrus said:
Morning all

I need to start teaching myself how to query a SQL database for my role at work. I don't need to be advanced straight away but to be able to query a few tables and lookup tables between 2 dates etc. Can anyone recommend a decent book to get me started please?

Cheers
Click to expand...
Does your employer not offer an opportunity to do some training on SQL?
 
Do you actually need to know sql? There are loads of querying tools you could use that would generate the data ,and the actual sql, for you. Anyway, just google learn sql.
 
chopperrus said:
Morning all

I need to start teaching myself how to query a SQL database for my role at work. I don't need to be advanced straight away but to be able to query a few tables and lookup tables between 2 dates etc. Can anyone recommend a decent book to get me started please?

Cheers
Click to expand...
Anything that you need to do simple or advanced just google it, loads and loads of examples. Easy.
 

Back
Top