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

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

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 ...  ) 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

=============================
CHOOSE A LEARNING PATH
=============================
🚀 BECOME A BI ANALYST - https://geni.us/lbia_biasp
🏆 TAKE THE BI CONSULTANT MASTERCLASS - https://geni.us/lbia_bicm
🎓 LEARN BUSINESS INTELLIGENCE - https://geni.us/lbi_academy

=============================
🧰 LEARN TOOLS & SKILLS
=============================
Excel For BI Analysts - https://geni.us/lbia_excel
SQL For BI Analysts - https://geni.us/lbia_sql
Power BI For BI Analysts - https://geni.us/lbia_powerbi
Tableau For BI Analysts - https://geni.us/lbia_tableau
Ultimate Guide To Looker Studio - https://geni.us/lbia_lookerstudio

=============================
📊 DATA 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

=============================
🎥 RECOMMENDED VIEWING
=============================
7 Steps to Your 1st BI Analyst Job - https://geni.us/7stepstobivid
Learn Basic SQL in 15 Minutes - https://geni.us/learnbasicsql15-1
BI For Beginners Playlist - https://geni.us/biforbeginners-play

=============================
📕 FREE EBOOKS
=============================
7 Top Tips For Better Dashboard Design - https://geni.us/dashdes-ebook
Skills You Need To Succeed In BI - https://geni.us/biskills-ebook
7 Steps to Your 1st BI Job - https://geni.us/7stepstobi-ebook

=============================
📊 DATA HUBS & WEBSITES
=============================
⭐️ 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/

DISCLAIMER: Some of the above links are affiliate links where I'll earn a small commission if you make a purchase using them, at no additional cost to you. It really helps support the channel so thanks in advance if you do use them 🙏

=============================
✅ LET'S CONNECT!
=============================
BUSINESS INQUIRIES - https://learnbi.online/contact
CONSULTING CALL WITH ADAM - https://geni.us/bookacall-adamfiner
JOIN MY MAILING LIST - https://geni.us/PSgRsF


#databasedesign #sqltutorial #businessintelligence #dataanalyst