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

Video Description

👀 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 🎯 Want to become a Business Intelligence Analyst or level up your data skills? Explore practical tools, real-world projects, and expert-led courses to boost your BI career. ============================= 🎯 LEARNING PATHS ============================= BI Analyst Starter Program – 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 ============================= 🔧 BI TOOLS (Free & Paid) ============================= RFM Tool (Paid) – https://rfm-tool.com Market Basket Tool (Paid) – https://marketbasket.io File Combiner (Free) – https://filecombiner.online Data Cloaker (Free) – https://datacloaker.com Dataset Scout (Free) – https://datasetscout.com ============================= 🎥 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 EBOOKS ============================= 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 – https://geni.us/windsorai Kaggle – https://www.kaggle.com/ Statista – https://www.statista.com/ Data World – https://data.world/ ============================= 📬 CONNECT WITH ME ============================= LinkedIn – https://geni.us/adamfiner-linkedin Contact – https://learnbi.online/contact Book a Call – https://geni.us/bookacall-adamfiner Join My Mailing List – https://geni.us/PSgRsF --- *Some links are affiliate links, which means I may earn a small commission if you make a purchase—at no extra cost to you. Thanks for your support!* 🙏 #databasedesign #sqltutorial #businessintelligence #dataanalyst