Course Hive
Search

Welcome

Sign in or create your account

Continue with Google
or
SQL Tutorial for Beginners [Ultimate Full Course] - From Zero to HERO
Play lesson

'SQL Tutorial - Full Database Course for Beginners' by freeCodeCamp.org and more - SQL Tutorial for Beginners [Ultimate Full Course] - From Zero to HERO

4.0 (1)
11 learners

What you'll learn

This course includes

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

Summary

Keywords

Full Transcript

In this 4-Hour SQL Course for Beginners, you'll learn everything you need to get started with SQL! Want More? 👇 - *Free Download Materials* https://www.datawithbaraa.com/wiki/sql#sql-welcome - *Free SQL Course* https://youtu.be/SSKVgrwhzus - *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* 00:00 Introduction to SQL Course 00:01:58 Course Curriculum Overview 00:03:41 Chapter1 - SQL Basics 00:03:50 #1 Introduction to SQL 00:10:20 #2 Why learn SQL? 00:14:29 #3 SQL Database Concepts 00:18:27 #4 SQL Table Concepts 00:21:13 #5 Main SQL Commands 00:25:35 #6 Elements of SQL Statements 00:29:48 Chapter2 - Prepare the Environment 00:30:04 #7 Download & Install MySQL 00:35:54 #8 Tour in MySQL Interface 00:41:26 #9 Install the Course Database 00:46:02 #10 Guide to SQL Coding Style 00:50:26 Chapter3 - Querying Data 00:50:44 #11 SQL SELECT 00:58:13 #12 SQL DISTINCT 01:01:33 #13 SQL ORDER BY 01:10:27 Chapter4 - Filtering Data 01:10:43 #14 SQL WHERE 01:17:05 #15 SQL Comparison Operators 01:24:11 #16 SQL Logical Operators AND, OR, NOT 01:35:41 #17 SQL BETWEEN 01:41:54 #18 SQL IN 01:46:36 #19 SQL LIKE 01:58:45 Chapter5 - Joining Data 01:59:00 #20 JOINS Concept 02:03:42 #21 SQL Alias - AS 02:07:28 #22 SQL INNER JOIN 02:15:49 #23 SQL LEFT JOIN 02:19:00 #24 SQL RIGHT JOIN 02:21:30 #25 SQL FULL JOIN 02:25:37 #26 SQL UNION & UNION ALL 02:35:35 Chapter6 - SQL Functions 02:35:47 #27 SQL Aggregate Functions 02:48:01 #28 SQL String Functions 03:00:39 Chapter7 - SQL Advanced Topics 03:00:51 #29 SQL GROUP BY 03:09:24 #30 SQL HAVING 03:15:09 #31 SQL Subquery: EXISTS vs IN 03:24:47 Chapter8 - Modifying Data 03:25:00 #32 SQL INSERT 03:39:53 #33 SQL UPDATE 03:45:47 #34 SQL DELETE & TRUNCATE 03:50:08 Chapter9 - Defining Data 03:50:24 #35 SQL CREATE Table 04:00:28 #36 SQL ALTER Table 04:02:18 #37 SQL DROP Table 04:03:05 Next SQL Course & 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 #database #mysql

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