In this video, I show you how to design and build a relational database from scratch. I walk you through the process step by step and show you a cool tool you can use to make it easier.

This is the first part of a 3-part series (WATCH THE FULL PROJECT HERE IN ONE VIDEO: https://youtu.be/0rB_memC-dA ) that will show you how to create an awesome project for your data analyst portfolio. This is a project that will demonstrate to any potential employer a different skill set that you will need to have to work with SQL databases. In this video, we focus on creating a relational database in MySQL, then in the following videos, we will focus on writing SQL queries to create views of the database, and then creating the dashboards.

Timestamps
00:00 Introduction
01:12 Project Summary
02:10 Order data
08:37 Placing fake orders
09:30 Inventory control data
11:13 Staff data
12:56 Export SQL code
13:42 Creating the database
14:05 Creating tables
15:11 End

TOOLS USED IN THIS VIDEO
Quick Database Diagrams – https://geni.us/quickdbd
Navicat – https://navicat.com

JOIN THE LEARN BI ACADEMY – https://geni.us/lbi_academy
BECOME A BI ANALYST – https://geni.us/lbia_biasp
TAKE THE BI CONSULTANT MASTERCLASS – https://geni.us/lbia_bicm

TOOLS AND 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
Looker Studio for BI Analysts – https://geni.us/lbia_lookerstudio

DATA ANALYST PROJECTS
All projects – https://geni.us/lbia_projects
Ben's Pizzeria – https://geni.us/pizzaproject
Hotel Reservations – https://geni.us/hotelproject
Multichannel Marketing – https://geni.us/multichannelproject
Call Center – https://geni.us/callcentreproject

RECOMMENDED VIEWING
7 Steps to Getting Your First BI Analyst Job – https://geni.us/7stepstobivid
Learn SQL Basics in 15 Minutes – https://geni.us/learnbasicsql15-1
BI Playlist for Beginners – https://geni.us/biforbeginners-play

FREE EBOOKS
7 Best Tips for Better Dashboard Design – https://geni.us/dashdes-ebook
The Skills You Need to Succeed in BI – https://geni.us/biskills-ebook
7 Steps to Your First BI Job – https://geni.us/7stepstobi-ebook

DATA CENTERS AND WEBSITES:
Feed 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 links above are affiliate links that I will earn a small commission for if you make a purchase using them, at no extra cost to you. This really helps support the channel, so thanks in advance if you use them

LET'S CONNECT!
BUSINESS INQUIRIES – https://learnbi.online/contact
TELECOUNCH WITH ADAM – https://geni.us/bookacall-adamfiner
JOIN MY MAILING LIST – https://geni.us/PSgRsF
FACEBOOK GROUP – https://geni.us/learnbi-fbg

#database design #sql tutorial #business intelligence #data analyst

Please feel free to connect and share this video with your friends and family if you find it useful.