Work from home

SQL

Setting up SQL on your Windows laptop for practice

  • Download and install SQL Server by clicking on this link
    Stick with the default settings that are automatically chosen if this is your first time.
  • Download and install SQL Server Management Studio (SSMS) By clicking on this link

  • Download a sample database called AdventureWorks2022.bak (the OLTP version) by clicking on this link

  • Once you are ready, there are multiple easy-to-follow free guides on YouTube about how to install Adventureworks on an SQL server for you to access in SSMS. Have a search around and follow the instructions. an example video is below



W3 Schools SQL Course

https://www.w3schools.com/sql
Whenever I need to write any SQL script, I always have this page open, and I have been working with SQL for nearly 20 years. It is the standard “go-to” resource for all analysts and usually has enough information to resolve any issues related to SQL

SQL Zoo
https://sqlzoo.net/wiki/SQL_Tutorial

Similar to W3 Schools, this is an excellent resource to get to grips with the foundation level of SQL

LeetCode

https://leetcode.com/problemset/database
A good source of challenges which are often used by employers as part of technical tests


DataLemur
https://datalemur.com/
A collection of technical tests asked by major tech companies during the interview process

Hacker Rank

https://hackerrank.com

This is an excellent free resource to practice your SQL skills with increasingly difficult challenges.

SQL Games for further practice and learning