👀 WATCH PART 2 HERE: • Custom SQL Query Tutor...
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... ) 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
🏠 JOIN THE LEARN BI ACADEMY - geni.us/lbi_academy
🚀 BECOME A BI ANALYST - geni.us/lbia_biasp
🏆 TAKE THE BI CONSULTANT MASTERCLASS - geni.us/lbia_bicm
🧰 TOOLS & SKILLS
Excel For BI Analysts - geni.us/lbia_excel
SQL For BI Analysts - geni.us/lbia_sql
Power BI For BI Analysts - geni.us/lbia_powerbi
Tableau For BI Analysts - geni.us/lbia_tableau
Looker Studio For BI Analysts - geni.us/lbia_lookerstudio
📊 DATA ANALYST 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
🎥 RECOMMENDED VIEWING
7 Steps to Your 1st BI Analyst Job - geni.us/7stepstobivid
Learn Basic SQL in 15 Minutes - geni.us/learnbasicsql15-1
BI For Beginners Playlist - geni.us/biforbeginners-play
📕 FREE EBOOKS
7 Top Tips For Better Dashboard Design - geni.us/dashdes-ebook
Skills You Need To Succeed In BI - geni.us/biskills-ebook
7 Steps to Your 1st BI Job - geni.us/7stepstobi-ebook
📊 DATA HUBS & WEBSITES:
Power My Analytics - geni.us/YLc9Re
Windsor.ai - geni.us/windsorai
Kaggle - www.kaggle.com/
Statista - www.statista.com/
Data World - 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 - learnbi.online/contact
CONSULTING CALL WITH ADAM - geni.us/bookacall-adamfiner
JOIN MY MAILING LIST - geni.us/PSgRsF
FACEBOOK GROUP - geni.us/learnbi-fbg
#databasedesign #sqltutorial #businessintelligence #dataanalyst
Негізгі бет SQL Database Design Tutorial for Beginners | Data Analyst Portfolio Project (1/3)
Пікірлер: 124