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 - https://geni.us/quickdbd
Navicat - https://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 – https://geni.us/lbia_biasp
BI Consultant Masterclass – https://geni.us/lbia_bicm

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

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

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

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

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

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

=============================
📬 CONNECT WITH ME
=============================
LinkedIn – https://geni.us/adamfiner-linkedin
Contact – https://learnbi.online/contact
Book a Call – https://geni.us/bookacall-adamfiner
Join My Mailing List – https://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