Learn at Knowstar

@UCZAyzJefV9LFIIqRe7pe8Yw - 48.4K subscribers

Data and Analytics videos for all learners. SQL, Python, Spark, Artificial Intelligence, Machine Leaning Collab and Sponsorships - Please contact at [email protected] Want more guided learning, practice packs, and deep-dive SQL content? You’ll find all of that in our premium courses here - knowstar.gumroad.com/ You can connect with us here - Website - knowstar.gumroad.com/ Instagram - www.instagram.com/learn.knowstar/ Blog - know-star.blogspot.com/ Linkedin - www.linkedin.com/company/learn-at-knowstar/ Instructor’s LinkedIn - www.linkedin.com/in/kriti-c-a83503145/ Email - [email protected] Happy Learning with Learn at KnowStar!

Home Videos Live Playlists

Write SQL Like a Senior Data Engineer (Amazon Scheduling Problem)

Write SQL Like a Senior Data Engineer (Amazon Scheduling Problem) Learn at Knowstar

430 views - 1 week ago

This SQL Trick Powers Netflix-Scale Load Balancing

This SQL Trick Powers Netflix-Scale Load Balancing Learn at Knowstar

624 views - 2 weeks ago

Only 1 in 10 Gets This FAANG SQL Question Right | LinkedIn | Abnormal Spike Detection |

Only 1 in 10 Gets This FAANG SQL Question Right | LinkedIn | Abnormal Spike Detection | Learn at Knowstar

396 views - 3 weeks ago

SQL(Hard) | Negative Stock | Amazon Inventory Drift Explained

SQL(Hard) | Negative Stock | Amazon Inventory Drift Explained Learn at Knowstar

417 views - 4 weeks ago

Netflix SQL Interview Question (Advanced): Detect Multi-Device Login Overlaps

Netflix SQL Interview Question (Advanced): Detect Multi-Device Login Overlaps Learn at Knowstar

638 views - 1 month ago

Advanced SQL: Detect Missing & Out-of-Order Payment Events (FAANG Style)

Advanced SQL: Detect Missing & Out-of-Order Payment Events (FAANG Style) Learn at Knowstar

651 views - 1 month ago

This “Easy” SQL Question Still Fails Google Interviews

This “Easy” SQL Question Still Fails Google Interviews Learn at Knowstar

637 views - 1 month ago

Crack Google SQL: Detect Increasing Trend (Most Candidates Fail!)

Crack Google SQL: Detect Increasing Trend (Most Candidates Fail!) Learn at Knowstar

944 views - 1 month ago

SQL Mistakes We All Made In 2025 !

SQL Mistakes We All Made In 2025 ! Learn at Knowstar

308 views - 1 month ago

SQL Tricks | Pivot and Unpivot | Rows To Columns | Columns To Rows

SQL Tricks | Pivot and Unpivot | Rows To Columns | Columns To Rows Learn at Knowstar

305 views - 2 months ago

SQL Tricks | How To Rename a Table / Column names ?

SQL Tricks | How To Rename a Table / Column names ? Learn at Knowstar

240 views - 2 months ago

SQL Tricks | Find table names, schemas, and structure info | Information Schema | Metadata

SQL Tricks | Find table names, schemas, and structure info | Information Schema | Metadata Learn at Knowstar

233 views - 2 months ago

SQL Trick | How To Find Next Occurrence Of Any Weekday ?

SQL Trick | How To Find Next Occurrence Of Any Weekday ? Learn at Knowstar

363 views - 2 months ago

SQL | Generate Series in SQL: 3 Ways for Numbers & Dates

SQL | Generate Series in SQL: 3 Ways for Numbers & Dates Learn at Knowstar

369 views - 2 months ago

SQL Tricks | How To FORMAT Data ?

SQL Tricks | How To FORMAT Data ? Learn at Knowstar

245 views - 2 months ago

SQL Tricks | The Cleanest Way to Concatenate Rows | STRING_AGG

SQL Tricks | The Cleanest Way to Concatenate Rows | STRING_AGG Learn at Knowstar

328 views - 2 months ago

SQL | OUTPUT Clause | Most SQL Devs Don’t Know This Trick

SQL | OUTPUT Clause | Most SQL Devs Don’t Know This Trick Learn at Knowstar

309 views - 2 months ago

SQL | The Hidden Problem With SQL Concatenation

SQL | The Hidden Problem With SQL Concatenation Learn at Knowstar

253 views - 2 months ago

SQL Tricks | REPLACE vs TRANSLATE | Don't Misuse Them !

SQL Tricks | REPLACE vs TRANSLATE | Don't Misuse Them ! Learn at Knowstar

259 views - 2 months ago

SQL | ROUND() Tricks That Fool Even Pros !

SQL | ROUND() Tricks That Fool Even Pros ! Learn at Knowstar

278 views - 2 months ago

SQL | Why Your LEFT JOIN Acts Like an INNER JOIN! SQL Tricks and Traps

SQL | Why Your LEFT JOIN Acts Like an INNER JOIN! SQL Tricks and Traps Learn at Knowstar

427 views - 2 months ago

SQL Tricks | SQL LIKE Patterns: Wildcards Made Easy!

SQL Tricks | SQL LIKE Patterns: Wildcards Made Easy! Learn at Knowstar

233 views - 2 months ago

SQL Tricks | COUNT() Tricks Every Analyst Should Know!

SQL Tricks | COUNT() Tricks Every Analyst Should Know! Learn at Knowstar

534 views - 2 months ago

SQL Tricks - ROW_NUMBER vs RANK vs DENSE_RANK — When to Use What?

SQL Tricks - ROW_NUMBER vs RANK vs DENSE_RANK — When to Use What? Learn at Knowstar

404 views - 2 months ago

SQL Interview Question | How Netflix Tracks Your Watch Time - Advanced SQL| FAANG|Playback Analytics

SQL Interview Question | How Netflix Tracks Your Watch Time - Advanced SQL| FAANG|Playback Analytics Learn at Knowstar

882 views - 2 months ago

SQL Interview Question | Shortest Possible Route | FAANG | Recursive CTE

SQL Interview Question | Shortest Possible Route | FAANG | Recursive CTE Learn at Knowstar

631 views - 2 months ago

SQL Interview Question | FAANG | Record Breaker | Data Engineer | Window Functions | Data Analyst

SQL Interview Question | FAANG | Record Breaker | Data Engineer | Window Functions | Data Analyst Learn at Knowstar

439 views - 2 months ago

SQL Data Engineer Interview Question | FAANG | Extract Hashtags

SQL Data Engineer Interview Question | FAANG | Extract Hashtags Learn at Knowstar

525 views - 2 months ago

SQL Interview Question | META Data Engineer Interview | Closest Preceding Session

SQL Interview Question | META Data Engineer Interview | Closest Preceding Session Learn at Knowstar

455 views - 2 months ago

FAANG SQL Interview Problem EVERYONE Gets Wrong !

FAANG SQL Interview Problem EVERYONE Gets Wrong ! Learn at Knowstar

818 views - 2 months ago

Pandas Tutorial | Pivot | Melt | Rows To Columns | Columns To Rows | Transpose Data

Pandas Tutorial | Pivot | Melt | Rows To Columns | Columns To Rows | Transpose Data Learn at Knowstar

222 views - 3 months ago

SQL Interview Question | How To Find Consecutive Occurrences of a Number? Leetcode

SQL Interview Question | How To Find Consecutive Occurrences of a Number? Leetcode Learn at Knowstar

520 views - 3 months ago

SQL Interview Question | Leetcode | Trips and Users | SQL Advanced Query

SQL Interview Question | Leetcode | Trips and Users | SQL Advanced Query Learn at Knowstar

567 views - 3 months ago

SQL Interview Question | Biggest Window Between User Visits | Leetcode

SQL Interview Question | Biggest Window Between User Visits | Leetcode Learn at Knowstar

589 views - 4 months ago

Amazon SQL Interview - 10 Scenario-Based SQL Questions For Data Analysts and Data Engineers !

Amazon SQL Interview - 10 Scenario-Based SQL Questions For Data Analysts and Data Engineers ! Learn at Knowstar

1.8K views - 4 months ago

SQL Window Functions In Less Than 60 Seconds #sql

SQL Window Functions In Less Than 60 Seconds #sql Learn at Knowstar

571 views - 5 months ago

SQL Interview Question - Start And End Of Continuous Range | Leetcode | SQL Advanced Query

SQL Interview Question - Start And End Of Continuous Range | Leetcode | SQL Advanced Query Learn at Knowstar

481 views - 5 months ago

SQL Interview Question - Last Person To Board The Bus

SQL Interview Question - Last Person To Board The Bus Learn at Knowstar

623 views - 5 months ago

SQL Interview Question | Climbing Stairs | Recursion | Dynamic Programming | Leetcode | Fibonacci

SQL Interview Question | Climbing Stairs | Recursion | Dynamic Programming | Leetcode | Fibonacci Learn at Knowstar

537 views - 5 months ago

SQL Interview Question | Exchange Seats | Leetcode #sqlinterview

SQL Interview Question | Exchange Seats | Leetcode #sqlinterview Learn at Knowstar

581 views - 6 months ago

SQL Interview Question | How To Find Product Price On a Specific Date ? Leetcode | Advanced SQL

SQL Interview Question | How To Find Product Price On a Specific Date ? Leetcode | Advanced SQL Learn at Knowstar

588 views - 6 months ago

SQL Interview Question | How To Find Consecutive Empty Seats ? Leetcode | SQL Advanced Query

SQL Interview Question | How To Find Consecutive Empty Seats ? Leetcode | SQL Advanced Query Learn at Knowstar

1.7K views - 7 months ago

SQL Interview Question | How To Identify Repeated Credit Card Payments ? Stripe | Window Functions

SQL Interview Question | How To Identify Repeated Credit Card Payments ? Stripe | Window Functions Learn at Knowstar

888 views - 7 months ago

SQL | How To Calculate Mean, Mode and Median of Data ? Statistical Analysis | Data Analyst

SQL | How To Calculate Mean, Mode and Median of Data ? Statistical Analysis | Data Analyst Learn at Knowstar

620 views - 9 months ago

Google SQL Interview Question | Median Google Search Frequency

Google SQL Interview Question | Median Google Search Frequency Learn at Knowstar

769 views - 9 months ago

Regular Expressions in Oracle | SQL Tutorial | SQL Pattern Matching

Regular Expressions in Oracle | SQL Tutorial | SQL Pattern Matching Learn at Knowstar

841 views - 1 year ago

How Many Of These SQL Tricks Do You Actually Know ?

How Many Of These SQL Tricks Do You Actually Know ? Learn at Knowstar

2.6K views - 1 year ago

SQL | How To Find Invalid Characters In Your Data?

SQL | How To Find Invalid Characters In Your Data? Learn at Knowstar

1.8K views - 1 year ago

SQL | How To Find The Most Frequent Value ? Mode

SQL | How To Find The Most Frequent Value ? Mode Learn at Knowstar

1.5K views - 1 year ago

Can You Fix This SQL Query ? Window Functions | Debug SQL Query

Can You Fix This SQL Query ? Window Functions | Debug SQL Query Learn at Knowstar

1.2K views - 1 year ago

Python | How to Send Email ? Pandas

Python | How to Send Email ? Pandas Learn at Knowstar

587 views - 1 year ago

SQL Trick | How to Custom Sort Data | String_Split

SQL Trick | How to Custom Sort Data | String_Split Learn at Knowstar

1.3K views - 1 year ago

SQL | Credit Card Validation | Luhn Algorithm | Mod 10 Algorithm | Data Analyst Portfolio Project

SQL | Credit Card Validation | Luhn Algorithm | Mod 10 Algorithm | Data Analyst Portfolio Project Learn at Knowstar

1.2K views - 1 year ago

Can You Find 5 Errors in This SQL Query? | SQL Debugging

Can You Find 5 Errors in This SQL Query? | SQL Debugging Learn at Knowstar

1.6K views - 1 year ago

Save Hours Writing SQL Code With These SQL Functions | SQL Server 2022

Save Hours Writing SQL Code With These SQL Functions | SQL Server 2022 Learn at Knowstar

2.7K views - 1 year ago

SQL | How to Merge Overlapping Date Ranges | SQL Interview Questions And Answers

SQL | How to Merge Overlapping Date Ranges | SQL Interview Questions And Answers Learn at Knowstar

2.2K views - 1 year ago

SQL | Pivot Multiple Columns | Rows to Columns | Transpose

SQL | Pivot Multiple Columns | Rows to Columns | Transpose Learn at Knowstar

3.7K views - 1 year ago

SQL | How to Calculate Running Totals and Cumulative Sum | Windows Function

SQL | How to Calculate Running Totals and Cumulative Sum | Windows Function Learn at Knowstar

2.1K views - 1 year ago

SQL | You Don't Need Multiple Lines Of Code | Last NOT NULL | Forward Fill | IGNORE NULLS

SQL | You Don't Need Multiple Lines Of Code | Last NOT NULL | Forward Fill | IGNORE NULLS Learn at Knowstar

2.1K views - 1 year ago

SQL | STRING_SPLIT | Split Delimited String into Rows

SQL | STRING_SPLIT | Split Delimited String into Rows Learn at Knowstar

4.4K views - 1 year ago