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

? WATCH PART 2 HERE: https://youtu.be/Yw3oqqkhohY

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: https://youtu.be/0rB_memC-dA) 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

START YOUR BI JOURNEY! - https://learnbi.online

? 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

? RECOMMENDED COURSES
Power BI For Business Intelligence - https://geni.us/powerbi-udemy
Ultimate Guide to Google Data Studio - https://geni.us/vbi-edu
Google Data Analytics Course - https://geni.us/coursera_analytics
Learn SQL - https://geni.us/learnsql

SKILLSHARE - 30-day free trial! - https://geni.us/skillshare30day
UDEMY - https://geni.us/udemy_vb

? FREE EBOOKS TO DOWNLOAD
7 Top Tips For Better Dashboard Design
https://geni.us/dashdes-ebook
The Skills You Need To Succeed In Business Intelligence
https://geni.us/biskills-ebook

? BI TOOLS
Power BI - https://powerbi.microsoft.com/
Tableau - https://www.tableau.com/
Data Studio - https://datastudio.google.com/

? 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/

?THE DATA VISUALISATION BIBLE - https://geni.us/iJTa8

? MY YOUTUBE GEAR
My Camera - https://amzn.to/3J5lbeo
Most Used Lens - https://amzn.to/3hXoE2Q
Main Key Light - https://amzn.to/366KaPI
Softbox - https://amzn.to/35HrR46
LED Panel Kit - https://amzn.to/35K3Lpf
Teleprompter - https://amzn.to/3hWGT8p
Main Mic - https://amzn.to/3t1n1aK
Lavalier Mic - https://amzn.to/3vVUi8V

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
FACEBOOK GROUP - https://geni.us/learnbi-fbg

#databasedesign #sqltutorial #businessintelligence #dataanalyst