SQL Coding Interview Guide
Crack the Software Developer Interview with SQL Questions
What you'll learn
- Land a high paying role as a software developer/programmer.
- Refresh your SQL questions with the most common database topics asked at the coding interview
- Learn the most commonly asked questions by the likes of Facebook, Google, Amazon and Netflix for beginners.
- Learn not only concepts but also be able to articulate your thought process as you plan and execute a solution.
- Learn how to recognize patterns for solutions to coding interview questions.
- Learn the best way to answer an interview question
- Learn through hands-on coding examples and learn to solve problems quickly
- Write a SQL query to find all products that are never sold.
- Write a SQL query to find the name of the winning candidate
- Write a query to find the names (first_name, last_name) of the employees who are supervisors.
- Write an SQL query that reports all product names of the products in the Sales table along with their selling year and price.
- Write an SQL query to report the Capital gain/loss for each stock.
- Write a query to list the first name, last name, and hire date of the employees who were hired after 'Lang'.
- Write a query to list the titles, number of yearly streams, and number of monthly streams (1/12 of yearly streams) of all movies
- Write a SQL query to find all numbers that appear at least three times consecutively.
- And much more.
Requirements
- No IDE necessary. We will run SQL in the browser with Repl.
Refresh your SQL knowledge and solve new problems with the most common beginner interview questions asked by FANG companies.
Ultimate Coding Interview Prep
Learn the most commonly asked questions by the likes of Facebook, Google, Amazon and Spotify for beginners.
Preparing for the SQL portion of the interview is hard. You need to understand not only concepts but also be able to articulate your thought process as you plan and execute a solution.
A SCHOOL YOU CAN TRUST
- Lifetime access that never expires
- Project-based curriculum to superboost your portfolio
- Graduation certificate for every course
- Absolute beginner-friendly
- New courses every month
- Efficient lectures with step by step explanations
- Relevant industry topics 8 years of award-winning course delivery
- 800,000 students in 186 countries
- Learn with free tools and affordable courses
REVIEWS OF MAMMOTH COURSES
Captivating voice, easy to follow at a rapid pace, get some paper and fasten your seat-belts. I'm enjoying every second of this.
— PHILIP MURRAY
I have completed many Udemy tutorials. This one is the most outstanding one that I have seen thus far. It is doubtful that it could be topped. This is a superior tutorial. Amazing.
— JOSEPH APPLEGARTH
COURSE AUTHOR
Alexandra Kropova, Software Developer at Mammoth Interactive INC.
Alexandra Kropova is a software developer specializing in OOP and JavaScript, with extensive experience in full-stack web development and app development. She has helped produce courses for Mammoth Interactive INC. since 2016, including the Coding Interview series in Java, JavaScript, C++, C#, Python and Swift.
- You have a software developer interview coming up and need to learn how to answer questions properly
- You need to learn the most popular questions that you might be asked
- Anyone learning SQL
- You haven't used SQL in a while and want to refresh your knowledge
Your Instructor
Alexandra Kropf is Mammoth Interactive's CLO and a software developer with extensive experience in full-stack web development, app development and game development. She has helped produce courses for Mammoth Interactive since 2016, including the Coding Interview series in Java, JavaScript, C++, C#, Python and Swift.
Mammoth Interactive is a leading online course provider in everything from learning to code to becoming a YouTube star. Mammoth Interactive courses have been featured on Harvard’s edX, Business Insider and more.
Over 12 years, Mammoth Interactive has built a global student community with 4 million courses sold. Mammoth Interactive has released over 350 courses and 3,500 hours of video content.
Founder and CEO John Bura has been programming since 1997 and teaching
since 2002. John has created top-selling applications for iOS, Xbox and
more. John also runs SaaS company Devonian Apps, building
efficiency-minded software for technology workers like you.
Course Curriculum
-
Start00 Build A Table And Display All Records (10:26)
-
Start01 List Alphabetically (4:12)
-
Start02 List All Not In Specified Range (4:03)
-
Start03 List All In Range By Multiple Properties (7:39)
-
Start04 Display All With Characters In Property (6:09)
-
Start05 Select From Where In This And Not In That (6:09)
-
Start06 List All With Exact Number Of Characters (5:44)
-
Start07 List All With Specific Second Character (5:11)
-
Start08 List All Distinct Ids Available (3:36)
-
Start09 Calculate Percentage (4:45)
-
Start10 Consecutive Numbers (9:03)
-
StartSource Code
-
Start01 List Streams With Viewer Information (9:33)
-
Start02 Join Two Tables (5:18)
-
Start03 Find Same Value In Another Property (8:08)
-
Start04 List Values Across Tables (6:34)
-
Start05 Join Three Tables (6:44)
-
Start06 Find Average Across Tables (6:59)
-
Start07 Display Difference Across Tables (6:27)
-
Start08 Find More Than Value Across Tables (6:11)
-
Start09 Product Sales Analysis (6:50)
-
Start10 List All After A Certain Date (6:33)
-
Start11 Capital Gain Loss (6:33)
-
StartSource Code