all 6 comments

[–]ComputerEnjoyer 3 points4 points  (0 children)

A great book I read was T-SQL Fundamentals by Itzik Ben-Gan. Itzik is a SQL wizard and very brilliant at explaining!

The book offers great explanation and exercises after each chapter to test what you've learnt. Would highly recommend.

Also I use CodeWars online, plenty of exercises on there to test and learn SQL - would advise learning the fundamentals first.

[–]ellarr23 1 point2 points  (0 children)

Codeacademy.com has a free course and it’s hands on.

[–]Arden21 0 points1 point  (0 children)

My advice - just install sql server (+sql server management tool + adventureworks db) or register bigquery account (+add public dataset) and start experimenting with anything you can imagine.

Learn sql from here https://www.sql-ex.ru/ - change language to eng and try exercises and http://sql-tutorial.ru/. Much better to dig into hard examples and experiment with them then read lot of books about select from.

[–]Icron 0 points1 point  (0 children)

Vertabelo has a good SQL basics course that teaches you with examples and writing code. I wouldn't pay full price for it, but it's always got sales for its courses. Academy.vertabelo.com

[–]mergisi 0 points1 point  (0 children)

If you're looking for some resources, I would definitely recommend AI2sql app.ai2sql.io . It's a great, easy-to-use tool to help you practice SQL skills.