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.
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
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 |
These additional resources have been added after student queries on additional topics.
| Resource | Source |
|---|---|
| MySQL Replace | W3 Schools |
| MySQL String Replace Function | MySQL Tutorial |
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 |
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent