Solving LeetCode SQL Interview Questions | Part 1/3
LeetCode is a great place to practice some technical questions before you interview. I used it a few years ago and I really liked how easy it was to practice these questions as well as learn from it. You can actually see what the answer is as well as get community feedback so you can practice it yourself.
Link to LeetCode: https://leetcode.com/problemset/database/
Question 1: https://leetcode.com/problems/swap-salary/solution/
Question 2: https://leetcode.com/problems/not-boring-movies/solution/
Question 3: https://leetcode.com/problems/employees-earning-more-than-their-managers/solution/
Question 4: https://leetcode.com/problems/duplicate-emails/solution/
Question 5: https://leetcode.com/problems/combine-two-tables/solution/
0:00 Intro
3:12 Swap Salary Question
7:53 Not Boring Movies Question
11:50 Employees Earning More Question
17:30 Duplicate Emails Question
21:11 Combine Two Tables Question
____________________________________________
SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________
RESOURCES:
Udemy Courses:
Python for Data Analysis and Visualization- https://bit.ly/3hhX4LX
Statistics for Data Science - https://bit.ly/37jqDbq
SQL for Data Analysts (SSMS) - https://bit.ly/3fkqEij
NLP - Natural Language Processing with Python - https://bit.ly/30w7iCB
Coursera Courses:
Database and SQL for Data Science - https://bit.ly/2zUk0zL
Data Analysis with Python - https://bit.ly/3geiVDG
Data Analysis Specialization - https://bit.ly/3dYJ6w0
Tableau Data Visualization - https://bit.ly/2AHCNPd
Favorite Books:
Python for Data Analysis Book - https://amzn.to/3dDneGq
SQL Beginner's Guide to Managing and Analyzing With SQL Book - https://amzn.to/2X5341B
*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____________________________________________
SUPPORT MY CHANNEL - PATREON
Patreon Page - https://www.patreon.com/AlexTheAnalyst
Every dollar donated is put back into my channel to make my videos even better. Thank you all so much for your support!
____________________________________________
Websites:
GitHub: https://github.com/AlexTheAnalyst
____________________________________________
*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*
Видео Solving LeetCode SQL Interview Questions | Part 1/3 канала Alex The Analyst
Link to LeetCode: https://leetcode.com/problemset/database/
Question 1: https://leetcode.com/problems/swap-salary/solution/
Question 2: https://leetcode.com/problems/not-boring-movies/solution/
Question 3: https://leetcode.com/problems/employees-earning-more-than-their-managers/solution/
Question 4: https://leetcode.com/problems/duplicate-emails/solution/
Question 5: https://leetcode.com/problems/combine-two-tables/solution/
0:00 Intro
3:12 Swap Salary Question
7:53 Not Boring Movies Question
11:50 Employees Earning More Question
17:30 Duplicate Emails Question
21:11 Combine Two Tables Question
____________________________________________
SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________
RESOURCES:
Udemy Courses:
Python for Data Analysis and Visualization- https://bit.ly/3hhX4LX
Statistics for Data Science - https://bit.ly/37jqDbq
SQL for Data Analysts (SSMS) - https://bit.ly/3fkqEij
NLP - Natural Language Processing with Python - https://bit.ly/30w7iCB
Coursera Courses:
Database and SQL for Data Science - https://bit.ly/2zUk0zL
Data Analysis with Python - https://bit.ly/3geiVDG
Data Analysis Specialization - https://bit.ly/3dYJ6w0
Tableau Data Visualization - https://bit.ly/2AHCNPd
Favorite Books:
Python for Data Analysis Book - https://amzn.to/3dDneGq
SQL Beginner's Guide to Managing and Analyzing With SQL Book - https://amzn.to/2X5341B
*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____________________________________________
SUPPORT MY CHANNEL - PATREON
Patreon Page - https://www.patreon.com/AlexTheAnalyst
Every dollar donated is put back into my channel to make my videos even better. Thank you all so much for your support!
____________________________________________
Websites:
GitHub: https://github.com/AlexTheAnalyst
____________________________________________
*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*
Видео Solving LeetCode SQL Interview Questions | Part 1/3 канала Alex The Analyst
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Solving Medium Level SQL LeetCode Questions | Part 2/3MySQL Tutorial for Beginners [Full Course]How to use Leetcode EFFECTIVELY… and STOP grindingData Scientist vs Data Analyst | Which Is Right For You?Is AlgoExpert Worth It? FAANG Engineer’s ReviewSQL Coding Interview Question Using A Window Function (PARTITION BY) | Data Science InterviewsData Analyst Certifications | Are They Worth It? | Alex The Analyst Show | Episode 7SQL Server interview question :- Explain RowNumber,Partition,Rank and DenseRank ?Real SQL Interviews: Amazon's 2020 MOST ASKED questionCompletely REALISTIC Jobs on LinkedIn | Alex The Analyst Show | Episode 11Intermediate SQL Tutorial | Inner/Outer Joins | Use CasesLeetCode 177: Nth Highest Salary [SQL]Data Analyst Portfolio - GREAT Portfolio Examples!SQL Window Functions on Data Science Interviews in 2021 | Asked By Airbnb, Netflix, Twitter, UberSQL Joins Explained |¦| Joins in SQL |¦| SQL TutorialHow to use LeetCode effectivelyReal SQL Interviews: Amazon's TOP 2021 question REVEALED?Top 5 Data Analyst Interview MistakesAmazon Business Intelligence Mock Interview: Duplicate Products