BI Analyst Projects - 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 ============================= 🚀 WORK WITH ME (BI CONSULTING & AI SOLUTIONS) ============================= If you're struggling to make sense of your data, I help businesses: • Connect and structure their data • Eliminate manual reporting and messy spreadsheets • Build dashboards and AI-powered insight systems • Turn raw data into clear, actionable decisions 👉 Book a call: https://geni.us/dataconsultcall Need guidance instead? 👉 1-to-1 Coaching: https://geni.us/coaching-adamfiner ============================= 🎯 LEARN BUSINESS INTELLIGENCE ============================= Become a BI Analyst – 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 ============================= 🎥 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 RESOURCES ============================= 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 (10% off) – https://geni.us/windsorai Kaggle – https://www.kaggle.com/ Statista – https://www.statista.com/ Data World – https://data.world/ ============================= 📬 CONNECT ============================= LinkedIn – https://geni.us/adamfiner-linkedin Contact – https://learnbi.online/contact Join My Mailing List – https://geni.us/PSgRsF --- *Some links are affiliate links...* #databasedesign #sqltutorial #businessintelligence #dataanalyst