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

🚨 WANT MORE? GET MY FULL SQL COURSE HERE: https://geni.us/lbia_sql 👀 WATCH PART 2 HERE:    • Custom SQL Query Tutorial For Beginners | ...   🎥 WATCH THE COMPLETE SQL PORTFOLIO PROJECT:    • Data Analyst Portfolio Project - SQL | Ste...   In this video, I show you how to design and build a relational database from scratch. You’ll learn how to plan the database structure, define the tables and relationships, generate SQL code and create the finished database in MySQL. This is Part 1 of a three-part data analyst portfolio project designed to demonstrate practical skills in database design, SQL querying and dashboard development. ============================= 🎯 LEARN BUSINESS INTELLIGENCE ============================= BI Analyst Starter Program – https://geni.us/lbia_biasp BI Consultant Masterclass – https://geni.us/lbia_bicm Applied AI Systems for BI – https://geni.us/applied-ai-bi-ga ============================= ⏱️ CHAPTERS ============================= 00:00 Introduction 01:12 Project brief 02:10 Orders data 08:37 Placing fake orders 09:30 Stock control data 11:13 Staff data 12:56 Exporting the SQL code 13:42 Creating the database 14:05 Creating the tables 15:11 Outro ============================= 📊 RESOURCES FOR THIS VIDEO ============================= SQL for BI Analysts – https://geni.us/lbia_sql Ben’s Pizzeria SQL Project – https://geni.us/pizzaproject Quick Database Diagrams – https://geni.us/quickdbd Watch Part 2 –    • Custom SQL Query Tutorial For Beginners | ...   Watch the complete SQL portfolio project –    • Data Analyst Portfolio Project - SQL | Ste...   ============================= 📚 FREE BI RESOURCES ============================= Dashboard Design Tips – https://geni.us/dashdes-ebook Skills for BI Success – https://geni.us/biskills-ebook 7 Steps to Your First BI Job – https://geni.us/7stepstobi-ebook 100 BI Analyst Interview Questions – https://geni.us/100-bi-questions What Is Business Intelligence? – https://geni.us/whatisbi How to Build a BI Portfolio That Gets You Hired – https://geni.us/biportfolio How to Get a BI Job Without Experience – https://geni.us/bijobnoexperience ============================= 📈 RECOMMENDED TOOLS ============================= Power My Analytics – https://geni.us/YLc9Re Navicat Tutorial –    • My Favourite SQL Tool - Navicat Tutorial   ============================= 💼 CONSULTING AND COACHING ============================= BI consulting for businesses – https://geni.us/vitaminbi Book a one-to-one BI coaching session – https://geni.us/bookacall-adamfiner ============================= 🔗 CONNECT WITH ME ============================= LinkedIn – https://geni.us/adamfiner-linkedin Join My Mailing List – https://geni.us/PSgRsF #DatabaseDesign #SQLTutorial #BusinessIntelligence #DataAnalyst Some links are affiliate links, which means I may earn a small commission if you make a purchase at no additional cost to you. Thanks for your support! ```