Top SQL Resources

Resources in SQL…can I not just run the queries and see what happens?
Well, one usually say that you can learn a lot of SQL on your work place while doing projects.
But there are two main reasons why resources in SQL then becomes even more important:

  1. To learn at your job you probably google the answer most of the times.
    If you know some good really good resources you will find the answer to your answers quicker, and/or better described.

  2. After a certain time you will need to understand the theory better
    You can make it work for the first couple of month if you just do normal querying to databases.
    But, both for the performance of your queries, and the possibility to take your SQL-game one step further (Maybe
    with DDL), good resources will really help you to bridge this gap.

Below are the the resources that I recommend, drop a comment if you have any more that you really recommend.

 

SQLZoo

SQLZoo - most popular website learning SQL, learn SQL with Examples

If you want to learn SQL

 

Books - Get away from the computer and learn SQL with physical books

To the left are the physical books that I have bought for learning SQL.
I will go through them one by one and show the different use cases for the different books.

SQL Cookbook

  • My favorite book to have when looking up queries “offline”. A lot of the most common patterns in SQL in different SQL languages.

SQL in 10 Minutes a Day

  • I read this book as a summer read, perfect for a beginner. Going through SELECT, WHERE, JOIN, GROUP BY , ORDER BY, etc. with great examples and result from the output.

T-SQL Window Functions

  • Advance book about how to utilize Window Functions in different ways. Going through the theory behind the different parts of Window functions, most used Window functions, as well as how to use Window Functions to Optimize.

T-SQL Fundamentals

  • Great book, quite advanced, about how T-SQL works and the theory behind it. Similar to “Definite Guide to DAX” in Power BI, as I would almost call it “The Bible of SQL” and great book to come back to time to time.

T-SQL Querying

  • Advanced book on how to use SQL-querying in T-SQL. Going through the different parts quickly and then dives into performance and more advanced version of querying.

Online Courses is another great way to learn SQL

  • Udacity is my favorite online provider of courses.
    The positive thing is that you have assignments to do with quite advanced SQL queries, and will get real human feedback if you pass or not the assignments.

  • Udemy is also one of the online provider of courses that I use a lot.
    There are several Udemy courses in SQL.

  • Codeacademy

  • W3Schools

  • Coursera