Course Hive
Search

Welcome

Sign in or create your account

Continue with Google
or
SQL Full Course for Beginners (30 Hours) – From Zero to Hero
Play lesson

SQL Full Course for Beginners (30 Hours) – From Zero to Hero - SQL Full Course for Beginners (30 Hours) – From Zero to Hero

Master SQL from Scratch: Become a Data Hero in 30 Hours!

4.0 (0)
19 learners

What you'll learn

Understand the fundamentals of SQL and database management
Develop skills to create and manipulate database tables
Learn to construct complex SQL queries for data analysis
Gain ability to optimize database performance and efficiency

This course includes

  • 29.5 hours of video
  • Certificate of completion
  • Access on mobile and TV

Summary

Keywords

Full Transcript

I’ve spent 2 years creating this *high-quality SQL course* so you can master SQL for data analysis & data engineering. The best part? It’s 100% free Want More? 👇 - *Free Download Materials* https://www.datawithbaraa.com/wiki/sql#sql-welcome - *Full Package* (projects, quizzes, structure, certificate) https://www.datawithbaraa.com/course/sql-full-course-for-beginners - *Subscribe* for more Free Data content: https://www.youtube.com/channel/UC8_RSKwbU1OmZWNEoLV1tQg?sub_confirmation=1 *🏆 DATA ACADEMY* - *SQL* https://www.datawithbaraa.com/course/sql-full-course-for-beginners - *Python* https://www.datawithbaraa.com/course/the-ultimate-python-mastery - *Python Handbook* (sketches, notes, code) https://academy.datawithbaraa.com/l/digital_download/998313/the-python-handbook - *Tableau* https://www.datawithbaraa.com/course/tableau-ultimate-full-course-for-beginners *🎓UDEMY* - *SQL* https://www.udemy.com/course/the-complete-sql-bootcamp-30-hours-go-from-zero-to-hero/?referralCode=D20781228C2EB8B98339 - *Python* https://www.udemy.com/course/the-complete-python-bootcamp-13hours-go-from-zero-to-hero/?referralCode=776491A4119FF8AF41CA - *Tableau* https://www.udemy.com/course/the-tableau-ultimate-course-from-zero-to-hero/?referralCode=6544726FDC491A6B25EC ━━━━━ *CONNECT WITH ME* 📬 Newsletter https://www.blog.datawithbaraa.com 👨‍💻 LinkedIn https://www.linkedin.com/in/baraa-khatib-salkini/ 📸 Instagram https://www.instagram.com/datawithbaraa/ 🎥 TikTok https://www.tiktok.com/@datawithbaraa 🌍 Website https://datawithbaraa.com/ 💬 Discord https://discord.gg/gsVJbMxKcA 🧭 Notion Roadmaps https://www.notion.com/@datawithbaraa ⭐ Favorite Books/Gear https://candle-gosling-511.notion.site/My-Favorite-Books-Gear-Apps-28334b251f1281e58a52cf7aa594e0e9?source=copy_link 📩 Sponsorships [email protected] ━━━━━ *Get 25%* OFF DataCamp's Here https://datacamp.pxf.io/bOEe66 ━━━━━ *MY FREE COURSES* - *SQL* https://youtu.be/SSKVgrwhzus - *Python* https://youtu.be/Rq5gJVxz55Q - *Tableau* https://youtu.be/UcGF09Awm4Y - *Databricks* https://www.youtube.com/playlist?list=PLNcg_FV9n7qZoxVkw-KPhcmgLWjHWVUc9 - *Power BI* https://www.youtube.com/playlist?list=PLNcg_FV9n7qZge4KDGqGtqgiuVuhVZWzu - *Data Projects* https://www.youtube.com/playlist?list=PLNcg_FV9n7qZ4Ym8ZriYT6WF8TaC2e_R7 - *Data Careers* https://www.youtube.com/playlist?list=PLNcg_FV9n7qah95jp-aPtysu7kFCbg7hd ━━━━━ 📖 *Table of Content* ___🟢Beginner Level___ 00:00 Intro 07:38 Introduction to SQL 22:33 Setup Your Environment 34:01 Query Data (SELECT) 01:32:31 DDL Commands 01:43:44 DML Commands ___🟡Intermediate Level___ 02:08:03 Filtering Data 02:47:57 SQL Joins (Basics) 03:27:29 SQL Joins (Advanced) 04:02:09 Set Operators 04:47:41 SQL Functions 04:52:58 String Functions 05:18:44 Numeric Functions 05:22:48 Date and Time Functions 06:59:06 NULL Functions 08:07:50 Case Statement 08:43:36 Aggregate Functions 08:50:11 Window Functions Basics 09:47:00 Window Aggregate 10:53:09 Window Ranking 11:56:05 Window Value ___🔴Advanced Level___ 12:40:34 Advanced SQL Techniques 12:58:04 Subqueries 14:18:08 Common Table Expressions (CTE) 15:35:02 Views 16:36:40 CTAS and Temp Tables 17:17:31 Compare Advanced Techniques 17:27:04 Stored Procedures 18:12:58 Triggers 18:23:42 Indexes 20:20:31 Execution Plan 21:11:03 Partitions 21:43:39 30x Performance Tips 22:24:25 AI and SQL ___🧪Projects___ 23:21:04 Project: SQL Data Warehouse 24:32:54 Project DWH | Bronze 25:10:09 Project DWH | Silver 26:47:46 Project DWH | Gold 27:41:51 Project: Exploratory Data Analysis (EDA) 28:30:38 Project: Advanced Data Analytics 29:47:24 Thank You This course is perfect for data analysts, data engineers, data scientists, software developers, and students—covering everything from the basics to advanced SQL topics. #sql #sqlserver #data #analytics #dataanalysis #datascience

Course Hive

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Related Courses

FAQs

Course Hive
Download CourseHive
Keep learning anywhere