NamasteSQL (Public)

Hello everyone, today we are going to solve a tricky problem using 10 methods using SQL. In this process we will cover almost all the SQL topics so watch this video till end and enjoy the show.

Here is the script:
create table students (
student_id int…

4.6K views07:59

NamasteSQL (Public)

https://youtu.be/5K7x946qvgA

YouTube

Independent vs Correlated Subquery | Advanced SQL Tutorial For Beginners

In this video we are going to discuss the difference between independent and correlated subquery. This is a advanced SQL topic. We are going to solve a problem using both the methods. Here is the script:
create table emp(
emp_id int,
emp_name varchar(20)…

3.6K views13:24

NamasteSQL (Public)

Hello Everyone,

I am excited to share that I am launching the Python For Data Analytics course that will help you learn Python from basics to advanced level data libraries, ETL and data pipelines .

This pre-launch offer is only for my Telegram community only.

* Course Key Highlights*

✅ 14+ Live sessions with lifetime access to recordings.
✅ No pre-requisite required ( Learn From Absolute Scratch)
✅ Learn Functional programming
✅ Includes 2 portfolio projects on real datasets
✅ Live Doubts sessions
✅ Learn Advanced Data Analysis libraries like Numpy and Pandas

✅Learn ETL (Extract , Transform ,Load) with Python

👉 Enroll here: https://www.namastesql.com/courses/Namaste-Python-Zero-to-hero---Jan-654f1c5fe4b0a57624c36e31

👉 Actual Course Price: ₹4999/-
👉 Grab now: ₹3350/- [ 33% Discount Valid for FEW PEOPLE ONLY ]

*Use CODE: EARLY33( Valid till 12th DECEMBER)*

The course starts on Jan 6th. Check out the course page for a detailed curriculum.

Classes will be on weekends 11am.

Note: Official Launch of this course will be happening later this week at a higher price. So Hurry up!

4.9K views09:43

NamasteSQL (Public)

A gentle reminder tomorrow is the last day to avail 33 percent discount

4.4K views15:03

NamasteSQL (Public)

https://youtu.be/rTLWoTYqC-U

YouTube

SQL Interview Question Asked in Google for Data Analyst Position | Data Analytics

In this video we will discuss a SQL question asked in Google interview for a data analyst position. Here is the script :
create table namaste_python (
file_name varchar(25),
content varchar(200)
);

delete from namaste_python;
insert into namaste_python values…

4.2K views15:55

NamasteSQL (Public)

https://youtu.be/SRXogHD2btg

YouTube

Solving a Namaste SQL Assignment Question | SQL For Analytics

In this video we are solving a assignment from namaste sql zero to hero course . You can register for the course from below link:

https://www.namastesql.com/

Here is the script:
create table namaste_orders
(
order_id int,
city varchar(10),
sales int
)
…

4.2K views14:21

NamasteSQL (Public)

Hi All, Announcing the weekend LIVE batch of Namaste SQL (zero to hero) . It starts on March 2nd 2024.

Early bird discount of 20 percent .

Code : EARLY20

All the details of the course on the website :

https://www.namastesql.com/courses/Think-SQL-Go-from-Zero-to-Hero-March-2024-65cb5288e4b023c32fe9d70b

3.7K views10:30

NamasteSQL (Public)

https://youtu.be/vsFPq-NPDxg

YouTube

Why I left Amazon.

In this video I will be sharing my journey at Amazon and why I am leaving it.

Data Analytics courses :
https://www.namastesql.com/

#amazon #dataengineer

3.6K views15:43

NamasteSQL (Public)

It is a great question to solve
https://youtu.be/tVQUsozKkyI

YouTube

Famous SQL Interview Question | First Name , Middle Name and Last Name of a Customer

In this video we will discuss a famous SQL interview problem where we need to segregate first name , middle name and last name from the customer name. I am going to explain the solution in a step by step manner.

script:
create table customers (customer_name…

3.1K views06:27

NamasteSQL (Public)

https://youtu.be/EgW3fHqeBNM

YouTube

Top 5 Advanced SQL Interview Questions and Answers | Frequently Asked SQL interview questions

In this video we will discuss most frequently asked top 5 Advanced SQL interview questions for experienced. We will also cover different variations of each questions. If you have any interview I am sure 2-3 questions will be from this list.

Kick off your…

2.9K views14:01

NamasteSQL (Public)

https://youtu.be/1QyRVV7Rdy8

YouTube

SQL QUALIFY Keyword | Reduce Your Sub Queries and CTEs

In this video we will learn about SQL Qualify clause which can really reduce your sub queries and CTEs. It makes your code much cleaner and easy to read. Qualify clause is used to filter the data based on window functions.

Zero to hero(Advance) SQL Aggregation:…

2.9K views12:16

NamasteSQL (Public)

https://youtu.be/McFK_Hv8JRM

YouTube

SQL Merge Statement Tutorial A-Z | How to use Merge in SQL step by step

In this video we will understand the SQL merge statement. Using merge statement we can insert , update and delete data in a single statement.

script:
CREATE TABLE SourceProducts(
ProductID INT,
ProductName VARCHAR(50),
Price DECIMAL(9,2)…

3.0K views05:43

NamasteSQL (Public)

https://youtu.be/kii_Kukh4po

YouTube

SCD Type 1 and Type 2 using SQL | Implementation of Slowly Changing Dimensions

In this video we will learn how to implement scd type 1 and type 2 using SQL. This will help you build logics using update and insert statement.
script:
CREATE TABLE product_stg(
Product_id INT,
Product_Name VARCHAR(50),
Price DECIMAL(9,2)…

2.9K views13:24

NamasteSQL (Public)

https://youtu.be/uL0-6kfiH3g

YouTube

End to End Data Analytics Project (Python + SQL)

In this video we will do an end to end data analytics project using python and SQL. We will use Kaggle API to download the dataset and to data processing and cleaning using pandas and load the data into sql server. Lastly we will answer some interesting questions…

3.3K views04:06

NamasteSQL (Public)

https://youtu.be/6Er_xfW61z4

YouTube

Cracked Myntra as Data Analyst with 1 Year Experience

This podcast is with Saurabh who recently cracked data analyst interview for Myntra . We will discuss following points :

1- How to get calls from product based companies.
2- Resources he used for preparations.
3- Interview questions
4- Resume preparation…

2.5K views07:22

NamasteSQL (Public)

https://youtu.be/CYjyjQGjX7A

YouTube

Honeywell SQL Interview Question | Print Movie Stars (⭐ ⭐ ⭐ ⭐⭐) For best movie in each Genre

In this video we will discuss solution of a SQL interview problem asked in Honeywell interview. Here is the script:

CREATE TABLE movies (
id INT PRIMARY KEY,
genre VARCHAR(50),
title VARCHAR(100)
);

-- Create reviews table
CREATE TABLE reviews…

2.5K views04:34

NamasteSQL (Public)

Announcing the launch of Tableau for data analytics LIVE bootcamp (zero to hero) .

In this bootcamp Anuj will be joining me. He was my colleague at Amazon and has exceptional Tableau Skills.
He joined my team as a Senior BI Engineer and then was promoted to Analytics Manager.
You will get the best of both : My in-depth knowledge for Tableau calculations and his in-depth knowledge of advanced chart and dashboard building.
Use code EARLYBIRD for 15 percent discount. Valid for limited time.

Link to register
https://www.namastesql.com/courses/Tableau-for-data-analytics-6613d9b141b25a442cd26607

2.6K views10:15

NamasteSQL (Public)

https://youtu.be/ORA3hvcPgTo

YouTube

IBM Data Engineer SQL Interview Question (Hacker Rank Online Test)

In this video we are going to discuss a SQL interview question asked in IBM for a data engineer position. It was part of a hacker rank test. We are also going to tweak the question a bit and try to solve it.

Kick off Your Data Analytics Journey: https:…

2.7K views03:47

NamasteSQL (Public)

https://youtu.be/l72hohmWA68

YouTube

Swiggy Data Analyst SQL Interview Question and Answer

In this video we will discuss a sql interview question asked in Swiggy for a Data Analyst Position. Here is the script:

-- Create the table
CREATE TABLE stock (
supplier_id INT,
product_id INT,
stock_quantity INT,
record_date DATE
);

--…