Sql Problem Solving For Interviews

Sql Problem Solving For Interviews
Published 10/2024
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz

Best way to prepare for a technical SQL Interview

What you’ll learn

Real-World Application: Learn to apply SQL knowledge to solve actual business problems using practical scenarios.

Diverse Problem Set: Tackle 50 questions, covering a range from easy to hard to challenge your skills.

Hands-On Learning: Engage in practical exercises that emphasize building working solutions over optimization.

Step-by-Step Guidance: Receive clear, structured instruction to help you navigate complex SQL problems effectively.

Requirements

Students should have basic SQL knowledge, and access to a SQL environment.

Description

Overview

Section 1: Introduction

Lecture 1 Who this course is for and what to expect

Section 2: SELECT

Lecture 2 Recyclable and Low Fat Products

Lecture 3 Find Customer Referee

Lecture 4 Big Countries

Lecture 6 Invalid Tweets

Section 3: Basic Joins

Lecture 7 Replace Employee ID With The Unique Identifier

Lecture 8 Product Sales Analysis I

Lecture 9 Customer Who Visited but Did Not Make Any Transactions
Lecture 10 Rising Temperature

Lecture 11 Average Time of Process per Machine

Lecture 12 Employee Bonus

Lecture 13 Students and Examinations

Lecture 14 Managers with at Least 5 Direct Reports

Lecture 15 Confirmation Rate

Section 4: Basic Aggregate Functions

Lecture 16 Not Boring Movies

Lecture 17 Average Selling Price

Lecture 18 Project Employees

Lecture 19 Percentage of Users Attended a Contest

Lecture 20 Queries Quality and Percentage

Lecture 21 Monthly Transactions
Lecture 22 Immediate Food Delivery

Lecture 23 Game Play Analysis

Section 5: Sorting and Grouping

Lecture 24 Number of Unique Subjects Taught by Each Teacher

Lecture 25 User Activity for the Past 30 Days I

Lecture 26 Product Sales Analysis III

Lecture 27 Classes More Than 5 Students

Lecture 28 Find Followers Count

Lecture 29 Biggest Single Number

Lecture 30 Customers Who Bought All Products

Section 6: Advanced Select and Joins

Lecture 31 The Number of Employees Which Report to Each Employee

Lecture 33 Triangle Judgement

Lecture 34 Consecutive Numbers

Lecture 35 Product Price at a Given Date

Lecture 36 Last Person to Fit in the Bus

Lecture 37 Count Salary Categories

Section 7: Subqueries

Lecture 38 Employees Whose Manager Left the Company

Lecture 39 Exchange Seats

Lecture 40 Movie Rating

Lecture 41 Restaurant Growth

Lecture 42 Friend Requests II: Who Has the Most Friends

Lecture 43 Investments in 2016

Section 8: Advanced String Functions / Regex / Clause

Lecture 45 Fix Names in a Table

Lecture 46 Patients With a Condition

Lecture 47 Delete Duplicate Emails

Lecture 48 Second Highest Salary

Lecture 49 Group Sold Products By The Date

Lecture 50 List the Products Ordered in a Period

Lecture 51 Find Users With Valid E-Mails

Section 9: Outro

Lecture 52 Outro

Individuals with a foundational understanding of SQL who are looking to enhance their problem-solving skills and apply their knowledge to real-world business scenarios, such as aspiring data analysts, software developers, and IT professionals.