Solving LeetCode SQL Interview Questions | Part 1/3
Channel: Alex The Analyst
Date: 10/11/2020

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:

Coursera Courses:
Google Data Analyst Certification: https://coursera.pxf.io/5bBd62
Data Analysis with Python - https://coursera.pxf.io/BXY3Wy
IBM Data Analysis Specialization - https://coursera.pxf.io/AoYOdR
Tableau Data Visualization - https://coursera.pxf.io/MXYqaN

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
Tableau A-Z - http://bit.ly/385lYvN

*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*