Data & SQL: Useful Resource Links Repo

Useful resource links to supplement Data & SQL learning - I have curated this list of useful resource links during my time as an Instructor teaching Data & SQL. I decided to save the list to a repo, so students can continue to access them following completion of the courses and for fellow instructors to use. Hope it helps.

You can 'Star' to save the repo or just bookmark the link for future easy access to the resources if you have found this list useful. Please do report any broken links and I shall fix or add a suitable alternative as soon as possible.

Introduction to SQL & Data Science

Resource	Source
How to Install MySQL (Windows 11)	YouTube
MySQL Basics	MySQL Tutorial
What is a Relational Database Management System?	CodeCademy
SQL Data Types	W3 Schools
MySQL Basics	MySQL Tutorial
Coderpad Sandbox Link	CoderPad

SQL Coding & Database Management (inc. Normalisation)

Resource	Source
Database Normalisation	ComplexSQL
What is Normalization in DBMS?	Guru99
Decomplexify: Learn Database Normalization	YouTube
SQL Command Types	JavaTpoint
MySQL Primary Keys	MySQL Tutorial
MySQL Foreign Keys	MySQL Tutorial
MySQL Constraints	W3 Schools
MySQL Constraints with Examples	JavaTpoint
Bro Code: MySQL Unions	YouTube
MySQL Union Operator	W3 Schools
MySQL Union All	Tech on the Net

Data Analysis

Resource	Source
MySQL Comparison Operators	Tech on the Net
MySQL LIKE Operator	W3 Schools
MySQL LIKE Tutorial w. Examples	MySQL Tutorial
MySQL Aggregate Functions	MySQL Tutorial
MySQL Group By Clause	MySQL Tutorial
MySQL Order By Clause	MySQL Tutorial
MySQL DISTINCT Clause	MySQL Tutorial

Data Analysis (Joins & Subqueries)

Resource	Source
MySQL Joins Poster	Steve Stedman
MySQL Joins Tutorial	MySQL Tutorial
MySQL Joins	Guru99
MySQL Joins w. Visual Examples	Tech on the Net
Bro Code: MySQL Joins	YouTube
MySQL Inner Join	MySQL Tutorial
MySQL Cross Join	MySQL Tutorial
MySQL Self Join	MySQL Tutorial
Bro Code: MySQL Self Joins	YouTube
MySQL Subquery Tutorial	MySQL Tutorial
MySQL Subqueries	Tech on the Net
Bro Code: MySQL Subqueries	YouTube

Data Mainpulation

Resource	Source
MySQL Functions List	W3 Schools
MySQL Functions	Guru99
MySQL Docs: Built-In Function and Operator Reference - Adv	MySQL 8.0 Reference Manual
How to Use MySQL Transactions	FreeCodeCamp
MySQL Transactions	MySQL Tutorial
MySQL Docs Transactions - Adv	MySQL 8.0 Reference Manual
MySQL Docs Table Locking - Adv	MySQL 8.0 Reference Manual
MySQL Table Locking Tutorial	MySQL Tutorial

Data Management

Resource	Source
MySQL Views Tutorial	MySQL Tutorial
MySQL Views	Guru99
MySQL Views Syntax Examples	W3 Schools
MySQL Views with Check Option	MySQL Tutorial
MySQL Triggers	MySQL Tutorial
MySQL Delimiter	MySQL Tutorial
MySQL Stored Procedure Tutorial	MySQL Tutorial
MySQL Stored Function Tutorial	MySQL Tutorial
Difference between Stored Procedure and Function Article	Medium
Bro Code: MySQL Views	YouTube
Bro Code: Stored Procedures	YouTube

Database Design & Data Visualisation

Resource	Source
Backup & Restore MySQL databases using mysqldump	SQL Shack
Mysqldump Docs	MySQL 8.0 Reference Manual
Create a DB backup for Windows	Youtube
Create a DB backup for Mac	YouTube
Get started with Power BI	Microsoft Learn
Build Power BI visuals and reports	Microsoft Learn
Create and use analytics reports with Power BI	Microsoft Learn
Tableau Free E-Learning Modules	Tableau
Tableau Public Learn Resources	Tableau

Portfolio Project Resources

Disclaimer: please note the example project was completed by an instructor with the use case of being a demo 'student' portfolio project in mind - remember we all have different starting points and your project does not have to meet all of these requirements!

Resource	Source
Example Project: Zoo Database	H. O'Connor
Example Project Demo/Presentation: Workbench	H. O'Connor
Kaggle Public Datasets	Kaggle
Tableau Sample Data	Tableau

Additional Resources

These additional resources have been added after student queries on additional topics.

Resource	Source
MySQL Replace	W3 Schools
MySQL String Replace Function	MySQL Tutorial

Next Steps / Career

Here are some useful resources for after you have completed your Data & SQL course.

Resource	Source
Microsoft Azure Data Fundamentals - Learn Pathways are Free	Microsoft Learn
Career Foundry: Building Your First Data Analytics Portfolio 2023	Youtube
Data Analytics Portfolio Examples - 2023	Career Foundry