Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Software Developer Interview Guide: Must Know SQL Questions
Rating: 4.5 out of 5(8 ratings)
107 students

Software Developer Interview Guide: Must Know SQL Questions

Crack the Software Developer Interview with SQL Questions
Created byMammoth Interactive, John Bura
Last updated 7/2020
English

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.

Course content

4 sections • 58 lectures • 5h 6m total length

  • Course Overview4:21
  • Build A Table And Display All Records10:26

    Build a table of movies and display all its records

  • List Alphabetically4:13

    List all movies in alphabetical order

  • List All Not In Specified Range4:03

    -- Write a query to list all movie titles that have been streamed not in the range 0 to 100,000 times


  • List All In Range By Multiple Properties7:39

    -- Write a query to list all movie titles that have been streamed not in the range 0 to 100,000 times


  • Display All With Characters In Property6:10

    -- Write a query to list the titles of all movies that have both an "a" and "o" in their title.


  • Select From Where In This And Not In That6:09

    -- Write a query to list the title, genre, and number of streams for all movies whose genre is that of Science Fiction or Fantasy, and whose number of streams is not equal to 0 or 1


  • List All With Exact Number Of Characters5:44

    -- Write a query to list the movie titles, genre and number of streams that have exactly 7 characters in the title


  • List All With Specific Second Character5:11

    -- Write a query to list the movie titles, genre and number of streams that have ‘e’ as the second character in the title


  • List All Distinct Ids Available3:36

    -- Write a query to list the genres available in the Movies table.


  • Calculate Percentage4:45

    -- Write a query to list the titles, number of yearly streams, and number of monthly streams (1/12 of yearly streams) of all movies


  • Consecutive Numbers9:03

    -- Write a SQL query to find all numbers that appear at least three times consecutively.


  • Source Code

Requirements

  • No IDE necessary. We will run SQL in the browser with Repl.

Description

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.

Who this course is for:

  • 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

Report abuse