README.md

SQL Fundamentals for Beginners

Welcome to the SQL Fundamentals for Beginners, a complete hands-on interactive experience to learn the basics of SQL, focusing on the practical and different flavors of SQL.

This site is curated for the SQL Fundamentals for Beginnners 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.

As of August 2024, I have added several changes to the workshop, including:

• include additional SQL flavors such as DuckDB, PostgreSQL, MySQL, SQLite, and MongoDB (this is NoSQL)
• include additional Graphical User Interface (GUI) tools such as pgAdmin, SQL Server Management Studio (SSMS), MongoDB Compass, DBeaver, and SQLiteStudio

The following are the popular databases based on SQL flavors:

• SQL Server T-SQL: AdventureWorks
• PostgreSQL: DVDrental
• MySQL: Sakila
• DuckDB: DuckDB
• SQLite: Chinook
• MongoDB: Sample Dataset

Motivation to share

I have been using SQL for over 3 years, and I still learn something new every day. I remember for every new concept and tools, I need to spend hours to understand the concept and how it works across different SQL flavors. I love to share my knowledge with others, and I hope you find this repository helpful.

Prerequisites

• Ensure your personal laptop is ready for 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)

Repository Stats