- Видео 88
- Просмотров 52 921
Xplore Data with Us
Индия
Добавлен 6 июл 2022
This Channel is handled by Durgesh Yadav - Senior Data Analyst @7-Eleven | Ex Data Analyst @Target 🔥 & Pragya Rathi - Data Specialist @Angel One |We Founders of Datacity Edtech | 65 K Linkedin | Cracked Multiple Tech Companies
Are you ready to embark on a transformative journey into the world of data? Look no further - DataCity is here to guide you through every step of your exploration into the dynamic realms of Data Analytics and Data Engineering.
🔥 What We Offer:
Free Playlists: Dive into our meticulously curated playlists that cater to all levels of expertise .
Step-by-Step Tutorials: Navigate the complexities of data tools, software, and programming languages with ease through our step-by-step tutorials.
Connect with Durgesh - www.linkedin.com/in/durgeshyadavdatacity/
Connect with Pragya Rathi - www.linkedin.com/in/pragya-rathi-8025b526a
Our Company Page - www.linkedin.com/company/the-data-community/
Website - datacityedtech.in/
Are you ready to embark on a transformative journey into the world of data? Look no further - DataCity is here to guide you through every step of your exploration into the dynamic realms of Data Analytics and Data Engineering.
🔥 What We Offer:
Free Playlists: Dive into our meticulously curated playlists that cater to all levels of expertise .
Step-by-Step Tutorials: Navigate the complexities of data tools, software, and programming languages with ease through our step-by-step tutorials.
Connect with Durgesh - www.linkedin.com/in/durgeshyadavdatacity/
Connect with Pragya Rathi - www.linkedin.com/in/pragya-rathi-8025b526a
Our Company Page - www.linkedin.com/company/the-data-community/
Website - datacityedtech.in/
Advance SQL Question | 10% Increment from Last Salary | Leetcode Problem Solving
Solve this Amazing Problem in SQL | Complete Solution by Pragya Rathi.
-- Creating the employees table
CREATE TABLE employees (
employee_id INT, -- Employee ID
name VARCHAR(50), -- Employee Name
salary DECIMAL(10, 2), -- Employee Salary
year INT, -- Year of Salary Record
PRIMARY KEY (employee_id, year) -- Composite primary key (employee_id, year)
);
-- Inserting data into the employees table
INSERT INTO employees (employee_id, name, salary, year) VALUES
(1, 'John Doe', 50000.00, 2022),
(1, 'John Doe', 55000.00, 2023),
(2, 'Jane Smith', 60000.00, 2022),
(2, 'Jane Smith', 65000.00, 2023),
(3, 'Emily Jones', 45000.00, 2022),
(3, 'Emily Jones', 48000.00, 2023),
(3, 'Emily Jones', 49000.00, 2024);
#sql #da...
-- Creating the employees table
CREATE TABLE employees (
employee_id INT, -- Employee ID
name VARCHAR(50), -- Employee Name
salary DECIMAL(10, 2), -- Employee Salary
year INT, -- Year of Salary Record
PRIMARY KEY (employee_id, year) -- Composite primary key (employee_id, year)
);
-- Inserting data into the employees table
INSERT INTO employees (employee_id, name, salary, year) VALUES
(1, 'John Doe', 50000.00, 2022),
(1, 'John Doe', 55000.00, 2023),
(2, 'Jane Smith', 60000.00, 2022),
(2, 'Jane Smith', 65000.00, 2023),
(3, 'Emily Jones', 45000.00, 2022),
(3, 'Emily Jones', 48000.00, 2023),
(3, 'Emily Jones', 49000.00, 2024);
#sql #da...
Просмотров: 215
Видео
Make Your Non-Tech Experience Count in Data Analytics | Proven Tips to Switch into Data Analytics !
Просмотров 476Месяц назад
Make Your Non-Tech Experience Count in Data Analytics | Proven Tips to Switch into Data Analytics! Are you looking to break into Data Analytics but worried that your non-tech background might hold you back? In this video, Durgesh Yadav, Senior Data Analyst at 7-11 and a Mentor at Geeks for Geeks, shares his proven tips on how to transform your non-technical experience into valuable skills for a...
How I switched from Service Based to Product Based as Data Analyst | Complete Journey
Просмотров 4,1 тыс.Месяц назад
First of all Thanks to @learnwithlokeshlalwani for this Amazing podcast shoot. In this Podcast my complete Journey is explained and I will surely say my Journey from Dotnet Developer to Data Analyst and then Senior Data Analyst at 7-11. I received a Overall Hike of 700% from my First Role. Do Watch Everything happened in 2 Years of Time. In my Journey I got Support from my Parents, Pragya she w...
Roadmap to Get into Data Analytics | How to get into Data Analytics Roadmap
Просмотров 278Месяц назад
Complete Roadmap on how to get into Data Analytics in 3 Months. I have given a Step by Step Roadmap for all of you ! #google #sqldevelopment #sqlupdate #datascience #dataanalyst #dataengineering #pythonlearning #python
SQL Optimisation Techniques | Most Asked Topic in #MAANG Companies
Просмотров 347Месяц назад
This SQL Optimisation Topic is First Video of my New Playlist Crack your Data Analytics Interview in 2024-2025. I Durgesh Yadav a Senior Data Analyst @7eleven is promising you that Series will benefit you in and out in your Data Analytics Journey. Crack your Product Based with me and go through all the Videos of the Series. Connect 1:1 with me on @topmate.io - topmate.io/durgesh_yadav and Get g...
Uber Asked SQL Interview Question | Scenario Based SQL Interview Question
Просмотров 3813 месяца назад
This Series is Created by Pragya Rathi & Durgesh Yadav and in this Series we will be dropping daily 1 Video on SQL Interview Questions asked in Product Based Companies. Connect 1:1 - topmate.io/durgesh_yadav Script- create table players (player_id int, group_id int) insert into players values (15,1); insert into players values (25,1); insert into players values (30,1); insert into players value...
Google Asked Scenario Based Question | Problem Solving SQL Series by Pragya Rathi
Просмотров 1563 месяца назад
This Series is Created by Pragya Rathi & Durgesh Yadav and in this Series we will be dropping daily 1 Video on SQL Interview Questions asked in Product Based Companies. Connect 1:1 - topmate.io/durgesh_yadav Script- Create table Trips (id int, client_id int, driver_id int, city_id int, status varchar(50), request_at varchar(50)); insert into Trips (id, client_id, driver_id, city_id, status, req...
Pareto Rule ( 80% Sale from 20 % Products ) | Important SQL Interview Question
Просмотров 1,2 тыс.3 месяца назад
This Series is for most Asked SQL Interview question in Data Analytics Role. We have made this series for all Aspiring Data Analyst for their Journey to secure a Data Analyst Job. Dataset Used in the Class - docs.google.com/spreadsheets/d/1odeGD6uBCRC2pFQ7HrKJm4gTRZ57Msis/edit?usp=sharing&ouid=106128983412816589197&rtpof=true&sd=true Connect with us on @LinkedIn - www.linkedin.com/in/durgeshyad...
Date for Nth Occurrence of Sunday in Future | Most Asked SQL Interview Question
Просмотров 3133 месяца назад
This Series is for most Asked SQL Interview question in Data Analytics Role. We have made this series for all Aspiring Data Analyst for their Journey to secure a Data Analyst Job. Connect with us on @LinkedIn - www.linkedin.com/in/durgeshyadavdatacity/ Pragya's Linkedin - www.linkedin.com/in/pragya-rathi-8025b526a/ Connect 1:1 for Job Guidance and to secure a Data Analyst Job in 2024 - topmate....
Problem 2 - Repeated Customers | 99% Product Based Companies Ask this | Scenario Based SQL
Просмотров 2943 месяца назад
This Series is Created by Pragya Rathi & Durgesh Yadav and in this Series we will be dropping daily 1 Video on SQL Interview Questions asked in Product Based Companies. create table customer_orders ( order_id integer, customer_id integer, order_date date, order_amount integer ); select * from customer_orders insert into customer_orders values(1,100,cast('2022-01-01' as date),2000),(2,200,cast('...
Team Wins SQL Problem | Asked in Product Based |Problem 1- Scenario Based SQL Series
Просмотров 2253 месяца назад
This Series is Created by Pragya Rathi & Durgesh Yadav and in this Series we will be dropping daily 1 Video on SQL Interview Questions asked in Product Based Companies. Create Tables Script - create table icc_world_cup ( Team_1 Varchar(20), Team_2 Varchar(20), Winner Varchar(20) ); INSERT INTO icc_world_cup values('India','SL','India'); INSERT INTO icc_world_cup values('SL','Aus','Aus'); INSERT...
Strings in Python | Most Asked Concept in Data Analytics & Engineering
Просмотров 1243 месяца назад
Welcome to Durgesh Yadav's comprehensive tutorial on Python strings! In this video, you'll dive deep into the world of strings in Python, learning everything from the basics to advanced string manipulation techniques. Whether you're a beginner or looking to refresh your knowledge, this tutorial has got you covered. Connect with Durgesh Yadav: 1:1 Mentorship Sessions: topmate.io/durgesh_yadav @L...
Window Functions in SQL | Most Asked Topic in Data Analytics
Просмотров 3493 месяца назад
Window Functions in SQL | Most Asked Topic in Data Analytics
Interview Questions on Window Functions | Introduction to W-Frames | Preceding & Following
Просмотров 1855 месяцев назад
Interview Questions on Window Functions | Introduction to W-Frames | Preceding & Following
Introduction to SQL | Understand why SQL is Important & What SQL Is ?
Просмотров 2085 месяцев назад
Introduction to SQL | Understand why SQL is Important & What SQL Is ?
CTE in SQL | By Pragya Rathi | Crack Product Based
Просмотров 6695 месяцев назад
CTE in SQL | By Pragya Rathi | Crack Product Based
Sub Query in SQL | By @Pragya Rathi | Crack Product Based
Просмотров 7835 месяцев назад
Sub Query in SQL | By @Pragya Rathi | Crack Product Based
Set Operators i n SQL | By Pragya Rathi
Просмотров 1755 месяцев назад
Set Operators i n SQL | By Pragya Rathi
SELF JOIN IN SQL BY @Pragya Rathi | Advance SQL
Просмотров 1285 месяцев назад
SELF JOIN IN SQL BY @Pragya Rathi | Advance SQL
Inbuilt Functions in SQL | Best Explanatory Video for Beginners
Просмотров 1376 месяцев назад
Inbuilt Functions in SQL | Best Explanatory Video for Beginners
SQL Understanding in 15 Minutes | Analytics in 15 | Data Science Roadmap
Просмотров 2377 месяцев назад
SQL Understanding in 15 Minutes | Analytics in 15 | Data Science Roadmap
I love your content! Could you create more Excel tutorials that break down concepts with real-world examples? It would really help me better understand data analysis and reporting techniques in Excel. Thanks for the great work!
Sir i am not able download data set from below link ..Please reshare the link to download the data file..
How can i contact with you
How can i contact with you
I started this today, good content.
Good insights!
I by bb nn mn
🎉🎉🎉🎉🎉
Well done bhaiya
Hey Durgesh Can you Please tell me the complete Roadmap how to get into Data Analytics 😊
Seriously the Hard work you did is Recommendable🎉🎉🎉
❤❤
Really a Great Journey ! Truely Inspiring
Where is the next part of this lecture?
Lewis Christopher Wilson Helen Rodriguez Robert
Dandwat Pranam mere chote bhai Durgesh ko, Bhai you are helping people a lot....Khaas kar ye wala video....Its' huge respect from my side to Durgesh and Pragya....
Do Comment what part of this you want a New Video ?😮
Hi is this playlist enough for learning SQL for data analytics? Kindly let me know!!
Yes !
What's the correct query for the last question?
Thank you for the insightful information.
Glad it was helpful!
You are too late for this video. Second there was no such email
Yeah ! I just posted it like is this happening so what’s the Reason
Thanks to the Content Creator ! This was something Really Good that’s why shared it with Audience.
🤣🤣🤣
you can tell everyone to watch at 1.5x
Sir when is your podcast is coming on how you crack the interview of seven eleven company with proper resources and roadmap 😊
Thank you for this informative tutorial of how to use DATEADD and DATEPART (WEEKDAY, Date) to find the next Sunday (or even the Sunday of 2, 3, ... more weeks) from a specific date ❤
Can you share data source its usen for us
your explain so patiently good explanation Thank you
Sir please start uploading Real world projects on Excel, SQL, Power BI, python 😊
Nice Explanation Pragya Mam 😮❤
Really a Nice Explanation
Awesome Bro you nailed it 👌🏻
Sir please start uploading Real world projects on Excel, SQL, Power BI, python 😊
Sir please make brand new data analyst playlist With brand new lectures, in proper sequence with real world projects and interviews questions and answers Make 1 stop solution for Data analytics sir 😊 Start brand new job oriented Data Analyst playlist 😊
Hello ma'am recently I recently applied for data analyst internship at probo. I am not able to 2 sql question and want to know solutions of these 2 questions.
very useful
Datasets & Resources - datacityedtech.in/downloads-and-resourses/
It doesn't work
thank you sir for this wonderful playlist
Helpful
That's my mentor durgesh for you ❤lot's to come ..hope you live long and stay strong to make more data analyst
thanks
provide the dataset please ..
Best explanation ..pls continue to upload videos on daily basics
I think there is some issue in the query while deleting the duplicated record, it just delete both original and dupe record which matches the condition, rather we should use dense_rank() function to delete the dupe record
Nicely explained...
Can you please suggest more topics to prepare in Python for cracking interviews
I have been following all the SQL problems covered from video 1 to video 5, your explanations are excellent, these are really helping me in my interview preparation. Thank you so much .looking forward for next video
Hi Pragya, I found the interview questions quite insightful. However, I have a query regarding the last question where we fetch 50% of the records. I opted for using Row_number(), but I noticed you suggested Dense_rank(). Could you please clarify the specific reason behind using Dense_rank() over Row_number()?
where can I find the answers for practice assignment?