SQL Database Design Tutorial for Beginners | Data Analyst Portfolio Project (1/3)

👀 WATCH PART 2 HERE:    • Custom SQL Query Tutorial For Beginners | ...  

In this video, I show you how you’d go about designing and building a relational database from scratch. I take you step-by-step through the process and show you a cool tool you can use to make your job a lot easier.

This is part 1 of a 3 part series (WATCH THE FULL PROJECT HERE IN A SINGLE VIDEO:    • Data Analyst Portfolio Project - SQL | Ste...  ) that will show you how to build an awesome project for your data analyst portfolio. It’s a project that will demonstrate to any potential employers a load of different skills that you’d be required to have for working with SQL databases. In this video, we concentrate on building a relational database in MySQL and then in the next videos we’ll concentrate on writing SQL queries to create views of the database and then build out the dashboards.

Timestamps
00:00 Intro
01:12 Project brief
02:10 Orders data
08:37 Placing fake orders
09:30 Stock control data
11:13 Staff data
12:56 Export SQL code
13:42 Creating the database
14:05 Creating the tables
15:11 Outro

🛠 TOOLS USED IN THIS VIDEO
Quick Database Diagrams - geni.us/quickdbd
Navicat - navicat.com/

🎯 Want to become a Business Intelligence Analyst or level up your data skills?
Explore practical tools, real-world projects, and expert-led courses to boost your BI career.

=============================
🎯 LEARNING PATHS
=============================
BI Analyst Starter Program – geni.us/lbia_biasp
BI Consultant Masterclass – geni.us/lbia_bicm

=============================
🛠️ LEARN BI TOOLS
=============================
Excel – geni.us/lbia_excel
SQL – geni.us/lbia_sql
Power BI – geni.us/lbia_powerbi
Tableau – geni.us/lbia_tableau
Looker Studio – geni.us/lbia_lookerstudio

=============================
📊 PRACTICE PROJECTS
=============================
All Projects – geni.us/lbia_projects
Ben’s Pizzeria – geni.us/pizzaproject
Hotel Reservations – geni.us/hotelproject
Multi-Channel Marketing – geni.us/multichannelproject
Call Centre – geni.us/callcentreproject

=============================
🔧 BI TOOLS (Free & Paid)
=============================
RFM Tool (Paid) – rfm-tool.com/
Market Basket Tool (Paid) – marketbasket.io/
File Combiner (Free) – filecombiner.online/
Data Cloaker (Free) – datacloaker.com/
Dataset Scout (Free) – datasetscout.com/

=============================
🎥 RECOMMENDED VIDEOS
=============================
7 Steps to Your 1st BI Job – geni.us/7stepstobivid
Learn Basic SQL (15 min) – geni.us/learnbasicsql15-1
BI For Beginners Playlist – geni.us/biforbeginners-play

=============================
📚 FREE EBOOKS
=============================
Dashboard Design Tips – geni.us/dashdes-ebook
Skills for BI Success – geni.us/biskills-ebook
7 Steps to Your 1st BI Job – geni.us/7stepstobi-ebook
100 BI Analyst Interview Questions – geni.us/100-bi-questions

=============================
📈 DATA SOURCES & TOOLS
=============================
Power My Analytics – geni.us/YLc9Re
Windsor.ai – geni.us/windsorai
Kaggle – www.kaggle.com/
Statista – www.statista.com/
Data World – data.world/

=============================
📬 CONNECT WITH ME
=============================
LinkedIn – geni.us/adamfiner-linkedin
Contact – learnbi.online/contact
Book a Call – geni.us/bookacall-adamfiner
Join My Mailing List – geni.us/PSgRsF

---

Some links are affiliate links, which means I may earn a small commission if you make a purchase—at no extra cost to you. Thanks for your support! 🙏


#databasedesign #sqltutorial #businessintelligence #dataanalyst