SQL Database Design Tutorial for Beginners | Data Analyst Portfolio Project (1/3)
👀 WATCH PART 2 HERE: • Custom SQL Query Tutorial For Beginners | ... 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 Project - SQL | Ste... ) 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

Custom SQL Query Tutorial For Beginners | Data Analyst Portfolio Project (Part 2/3)

Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3
![Beginner to T-SQL [Full Course]](https://i.ytimg.com/vi/cACat4KNncg/hq720.jpg?sqp=-oaymwEbCNAFEJQDSFryq4qpAw0IARUAAIhCGAG4AvcY&rs=AOn4CLBfffpmAfIoTBqgdPSBqxH7_LVDOg&usqp=CCc)
Beginner to T-SQL [Full Course]

Learn Database Normalization - 1NF, 2NF, 3NF, 4NF, 5NF
![SQL Course for Beginners [Full Course]](https://i.ytimg.com/vi/7S_tz1z_5bA/hq720.jpg?sqp=-oaymwEbCNAFEJQDSFryq4qpAw0IARUAAIhCGAG4AvcY&rs=AOn4CLCV4Cima1nx19tBObVX3l1NeRMD5g&usqp=CCc)
SQL Course for Beginners [Full Course]

Power BI Data Modeling Crash Course Learn Fast and Build Smarter Models! Full Course

Learn SQL Beginner to Advanced in Under 4 Hours

How to Become a Data Analyst in 2026 (starting from 0)

SQL Tutorial - Full Database Course for Beginners

System Design Explained: APIs, Databases, Caching, CDNs, Load Balancing & Production Infra

Brain Focus Music ~ No Lyrics Work Playlist for Mental Clarity & Deep Work

JavaScript Tutorial For Beginners | JavaScript Training | JavaScript Course | Intellipaat

SQL Tutorial for Beginners

Learn SQL in 1 Hour - SQL Basics for Beginners
![Data Modeling for Power BI [Full Course] 📊](https://i.ytimg.com/vi/MrLnibFTtbA/hq720.jpg?sqp=-oaymwEbCNAFEJQDSFryq4qpAw0IARUAAIhCGAG4AvcY&rs=AOn4CLA1wjM4aOBBlxn0kKUZFt5h6ZsTLA&usqp=CCc)
Data Modeling for Power BI [Full Course] 📊

Learn Power BI in Under 3 Hours | Formatting, Visualizations, Dashboards + Full Project

SQL Full Course for free 🐬

Excel 2021 Full Course Tutorial (3+ Hours)

Data Analyst Portfolio Project - SQL | Step-by-Step Guide From SQL Database to Interactive Dashboard

