Aliens School
Cinematic Knowledge Experience
0%
Aliens School
Now Playing
Aliens School ยท HIEN
โŒจ๏ธ Keyboard Shortcuts
โ†’Next slide โ†Previous slide SpacePlay / Pause MNarration on/off FFullscreen ?Show/hide this
Press any key to close
Skill Topic ยท Cinematic

๐Ÿ—„๏ธ Topic 59: SQL for Data Science โ€” Database Ka Foundation!

โฎ๏ธ Previous: 58-Geospatial-Analysis | โญ๏ธ Next: 60-Advanced-SQL ๐Ÿ“‚ Section 8: Big Data & Databasesโ€ฆ

Topic 1
๐Ÿ“Š

๐ŸŽฏ Is Topic Me Kya Sikhenge?

๐Ÿ“Š ` โ•”โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•— โ•‘ ๐Ÿ—„๏ธ SQL FOR DATAโ€ฆ
Topic 2
๐Ÿ’พ

๐Ÿ“Œ SQL Basics โ€” Data Query Language

๐Ÿ’พ ` โ”Œโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ” โ”‚ SQL QUERY EXECUTION ORDER โ”‚โ€ฆ
Topic 3
๐Ÿ”’

1๏ธโƒฃ SELECT, WHERE, ORDER BY

๐Ÿ—„๏ธ `sql -- โ•โ•โ• BASIC SELECT โ•โ•โ• SELECT name, age, salary FROM employees; -- โ•โ•โ• WHERE withโ€ฆ
Topic 4
๐Ÿ“ˆ

2๏ธโƒฃ JOINs โ€” Tables Connect Karo

๐Ÿ“ˆ ` โ”Œโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ” โ”‚ JOIN TYPES EXPLAINED โ”‚โ€ฆ
Topic 5
๐Ÿ“ฅ ๐Ÿ“ฅ ๐Ÿง  ๐Ÿ”ฌ ๐Ÿ’ก ๐ŸŽฏ

3๏ธโƒฃ Aggregations & GROUP BY

๐Ÿ” `sql -- โ•โ•โ• Basic Aggregations โ•โ•โ• SELECT COUNT(*) AS total_employees, AVG(salary) ASโ€ฆ
Topic 6
๐Ÿ“‰ ๐Ÿ“Š ๐Ÿ”ฌ

4๏ธโƒฃ Subqueries

๐Ÿ“‰ `sql -- โ•โ•โ• Subquery in WHERE โ•โ•โ• -- Average se zyada salary wale employees SELECT name,โ€ฆ
Topic 7
๐Ÿ”’

5๏ธโƒฃ CASE WHEN โ€” Conditional Logic

๐Ÿงฎ `sql SELECT name, salary, CASE WHEN salary >= 100000 THEN 'Senior' WHEN salary >= 60000โ€ฆ
Topic 8
๐ŸŒ

๐Ÿ Full Python Class โ€” SQLEngine

๐Ÿ’ก

Create & populate database

๐Ÿ”‘

CRUD operations

โšก

JOINs (INNER, LEFT, RIGHT, FULL)

๐ŸŽฏ

Aggregations & GROUP BY

Topic 9
โœจ

๐Ÿ“Š SQL vs pandas Comparison

๐Ÿ“Š ` โ”Œโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”ฌโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”ฌโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ” โ”‚ Operation โ”‚ SQL โ”‚โ€ฆ
Topic 10
๐Ÿ’พ

โ“ Quiz Time! (5 MCQs)

๐Ÿ’ก

a) SELECT

๐Ÿ”‘

b) FROM โœ…

โšก

c) WHERE

๐ŸŽฏ

d) ORDER BY

Quick Quiz
๐Ÿง  QUIZ TIME

Quiz โ€” Question 1

๐Ÿ—„๏ธ Topic 59: SQL for Data Science โ€” Database Ka Foundation! ka sabse sahi definition kya hai?

Complete! ๐ŸŽ‰
COMPLETE

๐Ÿ—„๏ธ Topic 59: SQL for Data Science โ€” Database Ka Foundation! Complete!

Aliens School ยท HIEN ยท Cinematic Knowledge

โœ…

๐Ÿ—„๏ธ Topic 59: SQL for Data Science โ€” Database Ka Foundation! Complete

1/13
0:00
REC 00:00ESC=Cancel
Aliens School
3
Recording shuru hone wali hai...
โœ…
Recording Complete
Video process ho rahi hai...
Live Class
Slide 1 / 7
Timer
00:00
๐Ÿ“ Speaker Notes
โ€”
โญ๏ธ Up Next
โ€”
โ€”
๐Ÿ—‚๏ธ All Slides