REAL WORLD SQL PROJECTS & INTERVIEW SERIES

Name: REAL WORLD SQL PROJECTS & INTERVIEW SERIES
Rating: 4.3 (29 reviews)

Created byHarshit Bhadiyadra

Last updated 5/2025

English

English [Auto],

What you'll learn

REAL TIME SQL PROJECT
SQL CONCEPTS
ADVANCED SQL CONCEPTS
PRACTICAL APPROACH

Course content

2 sections • 12 lectures • 3h 19m total length

REAL TIME PROJECT IN SQL_PROJECT - 1- PART_126:07
Part of real world sql projects & interview series, clean and normalize a messy sql dataset with temporary tables and null handling, then answer ten pizza-order queries.
REAL TIME PROJECT IN SQL_PROJECT - 1 - PART_221:38
Learn to run real-world sql projects by joining cleaned orders data, find max pizzas per order, analyze changes versus no changes, and aggregate by hour and day.
REAL TIME PROJECT IN SQL_PROJECT - 2 - BASIC STORED PROCEDURES WITH JOINS26:23
Demonstrates a library management SQL project using seven related tables with foreign keys and cascade, populating data, and using stored procedures with joins to answer copies, loans, and borrowers queries.
REAL TIME PROJECT IN SQL_PROJECT - 3_PART-118:24
Explore a real world SQL project with four tables: record label, artist, album, and song, and learn to join them to run five queries, including counting songs per artist.
REAL TIME PROJECT IN SQL_PROJECT - 3_PART-218:46
Explore real time sql project part two by joining record label, artist, album, and song tables to answer queries six to ten and learn derived tables and row_number usage.
REAL TIME PROJECT IN SQL_PROJECT-4_DATA CLEANING PROJECT IN SQL19:54
Learn SQL data cleaning for data migration by removing duplicates, handling nulls, correcting wrong categories, and converting data types to enable accurate sums and averages.

1_DIFFERENCE BETWEEN DELETE AND TRUNCATE3:44
Delete removes rows with a where clause (dml) and requires manual commit, while truncate purges all rows (ddl) with automatic commit, cannot use where, and resets identity.
2_DIFFERENCE BETWEEN UNION AND UNION ALL6:55
Explore the difference between union and union all, including distinct vs all results, performance, and column alignment rules for two queries (same number, types, and order).
3_STORED PROCEDURE AND FUNCTIONS DIFFERENCE12:23
Compare stored procedures and functions in sql, detailing return values, allowable statements (select vs dml), parameters, transactions, exceptions, and when to use each in real world scenarios.
4_IDENTIFY AND DELETE DUPLICATE DATA15:34
Identify and delete duplicate data in SQL by comparing all columns or by grouping name, salary, and department; keep one record using minimum id or ranking with partition by.
5_DEPARTMENT_WISE_NTH_HIGHEST_SALARY19:53
Explore department-wise nth highest salary queries using rank and dense_rank with a join of employees and departments, and use derived tables or common table expressions for the third highest salary.
6_DEPT WISE TOP 3 HIGHEST SALARY9:56
Learn to compute top three salaries across all departments in SQL using partition by with dense_rank, then switch to rank with <= 3 to include ranks 1–3.

Requirements

BASIC SQL KNOWLEDGE

Description

An SQL project typically involves creating or working with a database using SQL (Structured Query Language). Here’s a breakdown of what an SQL project might entail:

1. Project Scope:

Objective: Define what you want to achieve with your SQL project. This could be anything from creating a new database to analyzing existing data.
Requirements: Identify the specific requirements or goals. For example, are you building a database for a new application, or are you analyzing data for insights?

2. Database Design:

Schema Design: Create a schema that defines how data will be structured. This includes designing tables, defining relationships, and choosing appropriate data types.
Normalization: Ensure your database design is normalized to eliminate redundancy and ensure data integrity.

3. SQL Queries:

CRUD Operations: Implement basic SQL queries for Create, Read, Update, and Delete operations.
Complex Queries: Write more complex queries involving joins, subqueries, and aggregations to analyze and manipulate the data.

4. Implementation:

Database Creation: Use SQL statements to create the database schema and tables.
Data Insertion: Populate your database with sample or real data using INSERT statements.

5. Testing:

Query Testing: Test your SQL queries to ensure they return the expected results.
Performance Testing: Optimize queries for performance if working with large datasets.

6. Documentation:

Project Documentation: Document your database design, queries, and any specific features or constraints.
User Guide: Create a guide for users on how to interact with the database or how to run specific queries.

7. Deployment:

Deployment Strategy: Plan how you will deploy the database in a production environment, if applicable.
Backup and Recovery: Implement strategies for data backup and recovery.

8. Presentation:

Report: Prepare a report or presentation summarizing your project, including objectives, design decisions, and outcomes.

In some videos I have used Hindi as well. So this course will be in Hindi and English Mixed language.

Will be adding more videos very soon...

Who this course is for:

DATA ASPIRANTS

REAL WORLD SQL PROJECTS & INTERVIEW SERIES

What you'll learn

Explore related topics

Course content

REAL WORLD SQL PROJECT6 lectures • 2hr 11min

REAL WORLD SQL INTERVIEW SERIES6 lectures • 1hr 8min

Requirements

Description

Who this course is for: