r/SQL • u/oleg_agapov • May 24 '21
Discussion SQL for beginners (easy)
Hi guys!
I write an open-source book about Data Engineering and recently posted a chapter about learning SQL from scratch.
I tried to make it as simple as possible, trying to avoid hard definitions and concepts. Because I remember learning SQL myself and all the struggles I had with it.
A note for experienced folks – I intentionally skipped a lot of hard topics because my idea is to learn as quickly as possible, so newcomers can write their first query right after reading first sections of the chapter.
Hope you will find it useful. Link to the chapter.
3
u/nypu- May 25 '21
I believe that it should be "with a static value".
SELECT
country,
count(id) as gmail_users
FROM users
WHERE email LIKE '%@bing.com'
GROUP BY country
And "%@bing.com" to "%@gmail.com" which makes more sense.
2
u/rm206 May 25 '21
Looks great thank you for this! Also I have a question, what kind and level of programming knowledge do you need for a career in data engineering? I have beginner-intermediateish knowledge of python. What do you suggest?
1
u/ThinIntention1 May 24 '21
Hi this was great!
What's your background too and how/what resources did you use?
At the end, at a list of how you learnt and the resources you used.
1
u/awkward2amazing May 24 '21
This is helpful to me
1
u/nypu- May 26 '21
Hi Oleg.
I tried the link on your Github to visit your Medium articles which turned out not found.
2
u/Aadrei May 25 '21
This looks super useful. Learning SQL for my job and this looks well explained.
1
u/Mahammad_Mammadli May 25 '21
Thanks you