SQL Basics for people with no prior knowledge šŸ¤·ā€ā™€ļøšŸ¤·ā€ā™‚ļø

172,203
0
Published 2022-08-09
SQL!!! If you work as a data engineer, scientist or analyst, then learning SQL is going to change how you view and handle data. SQL stands for Structured Query Language. In this easy to understand tutorial, let me give you all the basics of SQL. Right from SELECT to WHERE clause to Multiple conditions (AND / OR / NOT) to ORDER and GROUP BY.

WANT MORE?

Watch my detailed SQL Video with more than 50 example queries, full sample dataset and practical tips. šŸ‘‰ Ā Ā Ā ā€¢Ā LearnĀ SQLĀ forĀ DataĀ AnalysisĀ inĀ oneĀ ho...Ā Ā 


ā± IN THIS VIDEO šŸ‘‡
=================
0:00 - What is SQL?
0:58 - SQL Select Examples
1:39 - WHERE clause
2:11 - OR operator
2:55 - AND operator
3:26 - IN operator (vs. OR operator)
4:31 - * vs. specific columns
5:03 - ORDER BY
6:24 - NOT operator
7:12 - GROUP BY
8:58 - Wait, there is more!!!


LEARN MORE šŸ“ššŸ’»
================

šŸ’„DETAILED SQL Video - Ā Ā Ā ā€¢Ā LearnĀ SQLĀ forĀ DataĀ AnalysisĀ inĀ oneĀ ho...Ā Ā 


Meanwhile, also check out below videos:
Data Analysis with Excel (full course + examples) - Ā Ā Ā ā€¢Ā BeginnerĀ toĀ ProĀ FREEĀ ExcelĀ DataĀ Analy...Ā Ā 
Power Query (it is like SQL, but you can use it from Excel or Power BI) - Ā Ā Ā ā€¢Ā PowerĀ QueryĀ TutorialĀ -Ā WhatĀ isĀ it,Ā ho...Ā Ā 
Database vs. Data Warehouse vs. Data lake - Ā Ā Ā ā€¢Ā KNOWĀ theĀ differenceĀ betweenĀ DataĀ Base...Ā Ā 
Data Cleaning in Excel - 10 PRO tricks - Ā Ā Ā ā€¢Ā DataĀ cleaningĀ inĀ ExcelĀ -Ā 10Ā tricksĀ *P...Ā Ā 
5 skills you need to be a GREAT data analyst - Ā Ā Ā ā€¢Ā 5Ā keyĀ skillsĀ youĀ needĀ toĀ becomeĀ aĀ GRE...Ā Ā 


šŸ˜Ž SAY HELLO šŸ‘‹
===============

Apart from YouTube, I frequently post on,
my blog - chandoo.org/wp/
twitter - twitter.com/r1c1/
Instagram - www.instagram.com/chandoo.xlsx

~

The waiter: "What is your order sir?"
The SQL developer: "Desc of course" šŸ¤£

#SQL #database

All Comments (21)
  • @HananelGez
    WOW! Finally someone explains SQL in a way that humans can understand it!!!! Thank you so much!!!!!
  • @gameon550
    this is one of the best introductions I have ever seen for SQL , thank you
  • @nwosulucy8889
    I must say you are the best tutor ever. You always create ways of simplifying your teaching. Thank you for all you do.
  • Honestly speaking I haven't seen like this informative video in such simply manner.
  • @sasha1364
    Thanks alot sir!!šŸ™ I have attended many other videos of SQL but the way you explain the concepts in such a simplified and interactive manner is outstanding šŸ˜€šŸ˜€šŸ˜€ Keenly waiting for the advance SQL videos šŸ˜€
  • @PaulasPicks
    I learned the SQL fundamentals & still found this video useful. Thank you, Chandoo, for always teaching!
  • @kjot73
    Chandoo sir you're a genius. I went thru your SQL courses and I feel so confident. Thank you for making it so simple. šŸ˜‡
  • @concon264
    Great work Chandoo! Love the no BS approach and the visualisation with lego works really well!
  • Consistently outstanding videos. The content, pace,and the tone are pitch perfect for learning. Thanks. I am new and now a big fan.
  • Thank you so much, I used to think it is not for me as it seemed complex. You made it so easy to understand. Great job on presentation and simplifed teaching with a great example. šŸ‘
  • @labiii9968
    This is the best and simplest tutorial I have seen.Very beginner friendly
  • Very innovative way to teach "SQL"! Thank you Chandoo, you always succeed with a surprise approach to teach concepts! Keep them coming! šŸ™‚
  • Well done - You made this simple to understand. Looking forward to seeing the next video.
  • @namanjain5763
    As a backend Developer working with sql all day the simple explanation is just so good will definitely share this with some of my junior who are just starting with SQL
  • @JJ_TheGreat
    Thank you for the video! Even though I learned SQL before, this is a good summary and review video. I look forward to your next video on the topic!
  • Sir your ideas are mind-blowing. I believe teaching expertise is in your DNA, probably you would have a self-motivated teacher in your parents.
  • Very out of the box demonstration! I'm a big fan of your videos. šŸ˜ŠšŸ¤—šŸ‘