syarmine / sql-masterclass

A repository for SQL Masterclass

SQL Fundamentals for Analyst and Data Analyst

Welcome to the SQL Fundamentals for Analyst and Data Analyst Workshop, a complete hands-on interactive experience to learn the basics of SQL Server Management Studio.

This site is curated for my SQL Fundamentals for Analyst and Data Analyst sharing session. It contains several references that I find useful across over the internet, and would love to share it with other learners. While it is not an exhaustive list, this is a repository with high-yield links sites that will help beginners in learning SQL.

Prerequisites - Before you attend the workshop, download the files and the scripts for hands-on exercises with one of the following methods:

• Clone the workshop repo with git clone https://github.com/Syarmine/SQL-Masterclass.git. Using this method, the scripts will be under folders by module inside sqlworkshops-sql2022workshop\sql2022workshop. You can download git for windows from https://gitforwindows.org or using Github for Dekstop.
• or download the files and scripts one by one from this page. You will need to expand the zip file after downloading.
• A virtual machine or computer running Windows 10, Windows 11, with at least 4 CPUs and 8Gb RAM. You will need Administrator rights on the virtual machine or computer. It is recommended to use your own personal laptop, do not use company laptop or owned by others.

🎯 What'll you get from this session:

• Learn how to install SQL Server Management Studio and SQL Server
  • Install SQL Server 2022: https://go.microsoft.com/fwlink/p/?linkid=2215158&clcid=0x4409&culture=en-my&country=my
    • Choose basic installation
  • Install SQL Server Management Studio: https://aka.ms/ssmsfullsetup
    • Connecting to your database engine
  • Tools: SQL Server Management Studio, SQL Server 2022, Excel, PowerBI (optional)
  • PC Requirement: https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16
  • Video installation instruction:
    • Install SQL Server 2022 and SSMS 20: https://www.youtube.com/watch?v=25r0w86YPwY
    • Connect to SQL Server using SSMS: https://www.youtube.com/watch?v=FB7vfufL4gE
• How to create a table: learning the logic - things are more similar than they are different (Excel, PowerBI, SQL)
  • Create a table using Excel
  • Create a table using PowerBI
  • Create a table using SQL Server
• Understanding scripts for database creation and administration
  • Download popular databases used in most MOOCs/courses - Adventureworks, Contosso, Northwind and Wide World Importers
  • Download AdventureWorks-oltp-install-script.zip and extract the zip file to your folder (i.e: C:\Samples\AdventureWorks) folder.
• Connect SQL Server to Excel and PowerBI
  • Connect your SQL Server data to Excel and PowerBI
  • Basic SQL Query
• Expand learning curve using MOOCs and Github for learning

  • Documentation:

    • SQL Server Management Studio Documentation
    • Microsoft SQL Documentation
    • Educational SQL Resources
    • Microsoft Tutorial

  • Query Cheatsheet:

    • SQL Basic Cheatsheet (Datacamp)
    • SQL Quick Access (W3 Schools)
    • SQL Cheatsheet Basic and Intermediate (Dataquest)
    • A collection of SQL Cheatsheet (Github)

  • Free high quality MOOC for SQL learning

    • Database design course (8 hours) - (freecodecamp) MUST WATCH !!
    • Full SQL Tutorial - MySQL (4 hours) - (freecodecamp)
    • SQL Server Performance Essential - SQL Server (4 hours) - (freecodecamp)
    • SQL Tutorial for beginners - MySQL (5 hours) - (freecodecamp)
    • Google Data Analytics Certificate - Process Data from Dirty to Clean

  • Certifications (optional)

    • Microsoft Azure Data Fundamentals
    • Microsoft Azure Database Administrator Associate
    • Google Data Analytics Certificate - Process Data from Dirty to Clean
    • Oracle Database Certification

  • Practice Your SQL

    • W3 Schools: https://w3schools.com/sql/default.asp
    • SQLZoo: https://sqlzoo.net/wiki/SQL_Tutorial
    • SQLBolt: https://sqlbolt.com
    • Stratascratch: https://platform.stratascratch.com/coding?code_type=5
    • Leetcode: https://leetcode.com/studyplan/top-sql-50/ (need sign in)