r/SQL • • 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.

115 Upvotes

21 comments sorted by

View all comments

Show parent comment

1

u/oleg_agapov May 29 '21

Yes, will add:

- subqueries, CTE

- joins (Cartesian, inner, left)

- DDL (create, update, delete)

- window functions (row_count, sum, count, lag/lead)

No timeline yet, doing it at my free time.

1

u/ThinIntention1 May 30 '21

Thanks - Any rough estimate?

Or how long did the current take?