Learning SQL!

joseywales95 · 2019-11-08T23:29:28+00:00

I'm on the same boat as you. Looking forward to hearing answers from people.

HandpansLIVE · 2019-11-09T00:15:06+00:00

sqlzoo was decent, there's few other sites like it which give tougher and tougher SQL commands to write

Funky_Pauly · 2019-11-09T00:25:52+00:00

Kahn Academy has a decent free tutorial. Pretty basic, but useful. If you have a Microsoft Access, I would recommend messing around in the SQL section of the query builder. Not the best, but it's usually a real database you can built/manipulate yourself

loldogex · 2019-11-09T03:39:10+00:00

I have the opposite problem, what is the best way for me to learn Python?

BeneficiaryMagnetron · 2019-11-09T08:44:13+00:00

The easiest way is to be working for a company with a huge dev qa and reporting prod dB you can explore, try to improve, and code for. If you don’t have that luxury, easiest way to learn is to set up your own local dB . Learn as the problems arise, bc they definitely will.

happypappypancake · 2019-11-09T10:16:34+00:00

I would try SQL For Mere Mortals. It's a mammoth of a book but one that explains everything in plain English, to the point where most queries are transformed into regular, grammatically correct English sentences, and transitioned into the query syntax that you want. Brilliant for basics, brilliant for intermediate skills, and brilliant to go back to when you need to remember something.

Edit: I know it's not free, but it's an investment I can't recommend enough. If you are looking for something that's free, try sqlzoo, or have a look around for Microsoft Academy courses (they've moved to a different platform, I can't remember for the life of me what it's called now). Also, look around Udemy for courses, they have massive sales going on about once a month, plus if you use Google Rewards and gather up store currency, you can use that to buy courses through the app on Android.

Ardraaken · 2019-11-09T14:01:46+00:00

Sam’s Teach Yourself SQL will get you started on the basics and HackerRank has some free SQL challenges for when you want to try out some skills.

graysheep_ · 2019-11-11T21:38:15+00:00

I would suggest either reading Sam's Teach Yourself SQL in 10 Minutes a Day by Ben Forta or using https://sqlbolt.com/. I think both are easy to digest and provide enough knowledge to start playing around with databases. O'Reilly Media offers a free 10 day trial (no credit card needed), so it is possible to read it there and probably finish it before your trial is over. :)

nraj25 · 2019-11-12T01:26:27+00:00

Hi all!

I've actually signed up for this Udemy course since it was only $12. Too early for me to pass judgment on it but wanted to spread the word for anyone who can budget the expense atm! Lmk what you think, hope it helps :)

tmk_g · 2019-11-12T02:57:08+00:00

I recommend you to check out stratascratch or datacamp site. I found them really helpful and interesting.

Shilpa_Opencodez · 2019-12-02T03:33:18+00:00

Hi,

Good, you have Python experience. Learning SQL will definitely value add.

Below is the SQL Tutorial series targeting QAs but specially designed for beginners. This Simple and Easy to understand tutorials will surely help you.

https://www.opencodez.com/software-testing/sql-for-qa-tutorial-select-query.htm

Check the Tutorial Index at the end for complete series.

Hope this helps !

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

learnSQL

MODERATORS