![Data Info @Rajanikanth Gaja](/img/default-banner.jpg)
- 79
- 18 407
Data Info @Rajanikanth Gaja
India
Registrace 30. 01. 2021
Hi, this is Rajanikanth Gaja and I post videos on Computer Science related concepts, especially data-related technologies, these videos will help you in interviews as well as in clearing your theory and coding questions. If this channel helped you even a bit, please consider subscribing to the channel.
If you need any personal help in SQL, Mock interviews, or Coding help You can contact me at rajanikanthgaja@gmail.com, Please note it will be charged.
Thank you :)
✨ Work-related E- emails can be sent to: rajanikanthgaja@gmail.com
If you need any personal help in SQL, Mock interviews, or Coding help You can contact me at rajanikanthgaja@gmail.com, Please note it will be charged.
Thank you :)
✨ Work-related E- emails can be sent to: rajanikanthgaja@gmail.com
The Little Master: calculat when Sachin Tendulkar first reached 500 runs and his batting average
Hi, this is Rajanikanth Gaja and I post videos on Computer Science related concepts, especially data-related technologies, these videos will help you in interviews as well as in clearing your theory and coding questions. If this channel helped you even a bit, please consider subscribing to the channel.
For your CZcams video about the SQL query for calculating when Sachin Tendulkar first reached 500 runs and his batting average
#sqltutorial #sql #queries # RunningTotalSQL # BattingAverageSQL #CTESQL # WindowFunctionsSQL # SQLforDataAnalysis # SQLExamples # SQL with Sports Data # Data Engineering SQL # SQLTipsandTricks # Learn SQL # SachinTendulkarStats # SQLPerformanceOptimization #sachin
#sachin #sachintendulkar
If you need any personal help in SQL, Mock interviews, or Coding help You can contact me at rajanikanthgaja@gmail.com, Please note it will be charged.
Thank you :)
✨ Work-related E- emails can be sent to: rajanikanthgaja@gmail.com
For your CZcams video about the SQL query for calculating when Sachin Tendulkar first reached 500 runs and his batting average
#sqltutorial #sql #queries # RunningTotalSQL # BattingAverageSQL #CTESQL # WindowFunctionsSQL # SQLforDataAnalysis # SQLExamples # SQL with Sports Data # Data Engineering SQL # SQLTipsandTricks # Learn SQL # SachinTendulkarStats # SQLPerformanceOptimization #sachin
#sachin #sachintendulkar
If you need any personal help in SQL, Mock interviews, or Coding help You can contact me at rajanikanthgaja@gmail.com, Please note it will be charged.
Thank you :)
✨ Work-related E- emails can be sent to: rajanikanthgaja@gmail.com
zhlédnutí: 39
Video
Most Asked SQL JOIN based Interview Question | #of Records after 4 types of JOINs #sql #sqlinterview
zhlédnutí 178Před 28 dny
In this video we will discuss SQL Join based interview question where you need to tell no of records in output when you join 2 tables. This question is very important from interview point of view as well join understanding point of view. It is a must watch concept. Hi, this is Rajanikanth Gaja and I post videos on Computer Science related concepts, especially data-related technologies, these vi...
How to Calculate Total and Productive Hours from Employee Swipe Data Using #SQL | #Sql Tutorial #MNC
zhlédnutí 493Před měsícem
#sql #dataengineer Acies Global & CGI & MNC SQL Interview Question | Employee Swipe in and Swipe out Hi, this is Rajanikanth Gaja and I post videos on Computer Science related concepts, especially data-related technologies, these videos will help you in interviews as well as in clearing your theory and coding questions. If this channel helped you even a bit, please consider subscribing to the c...
5.Electricity Consumption (Advanced Aggregate Functions in SQL) #sqlinterview #sqlrpgle
zhlédnutí 81Před měsícem
In this video, we dive into SQL techniques for analyzing electricity billing data. You'll learn how to calculate the total electricity consumption, total cost, and average monthly consumption for each household per year. We'll walk you through a practical example using a dataset from an electricity billing system, showcasing how to use SQL aggregation functions like SUM and AVG, and how to orga...
Double Self Join in SQL | Amazon Interview Question | Excel Explanation Included | Data Analytics
zhlédnutí 77Před měsícem
Hi, this is Rajanikanth Gaja and I post videos on Computer Science related concepts, especially data-related technologies, these videos will help you in interviews as well as in clearing your theory and coding questions. If this channel helped you even a bit, please consider subscribing to the channel. If you need any personal help in SQL, Mock interviews, or Coding help You can contact me at r...
Learn Database Normalization - 1NF, 2NF, 3NF | Complete guide to Database Normalization in SQL #SQL
zhlédnutí 111Před měsícem
An easy-to-follow database normalization tutorial, with lots of examples and a focus on the design process. Explains the "why" and "how" of normalization, and takes you step-by-step through: This is a complete guide for anyone to understand Database Normalization in SQL. I will not just explain the Normalization concepts but also show you step by step process of normalizing a de-normalized data...
Famous SQL Interview Question | First Name , Middle Name and Last Name of a Customer #sqltutorial
zhlédnutí 984Před 2 měsíci
Description In this SQL tutorial, we tackle a famous SQL interview question: how to extract the first name, middle name, and last name of a customer from a database. This is a common problem that tests your ability to handle string manipulation and understand the structure of names within a database. We'll walk you through the SQL query to efficiently retrieve these name components, ensuring yo...
How to find nth highest salary in sql #sqltutorial
zhlédnutí 79Před 2 měsíci
In this SQL tutorial, learn how to find the nth highest salary using SQL Server. We'll walk through step-by-step SQL queries to retrieve the nth highest salary from an employee database table. Whether you're a beginner or looking to refresh your SQL skills, this video will provide clear examples and explanations. Subscribe for more SQL tutorials and coding tips! SQL tutorial nth highest salary ...
4. SQL Query for LinkedIn Top Voice Badge #sqltutorial
zhlédnutí 82Před 2 měsíci
In this video, we'll show you how to write an SQL query to find LinkedIn's top voice creators who qualify for the badge. We'll cover the essential SQL commands, including JOIN, GROUP BY, COUNT, and SUM, and explain the criteria LinkedIn uses to determine the top voice badge recipients. Whether you're a beginner looking to learn SQL or an experienced developer wanting to refine your skills, this...
3 - Premium Customers (**Master SQL CTEs: Calculate Average Orders and More!**)
zhlédnutí 110Před 2 měsíci
se keywords like "SQL tutorial," "CTE in SQL," "SQL queries," "SQL average function," etc. #sqltutorial #ctes #sqlquiz #sql #sqltraining #sqlinterviewquestions Hi, this is Rajanikanth Gaja and I post videos on Computer Science related concepts, especially data-related technologies, these videos will help you in interviews as well as in clearing your theory and coding questions. If this channel ...
Segregate Data - SQL Interview ? Below 4 Years | SQL Problem Level "EASY" #MNC
zhlédnutí 51Před 2 měsíci
Hi, this is Rajanikanth Gaja and I post videos on Computer Science related concepts, especially data-related technologies, these videos will help you in interviews as well as in clearing your theory and coding questions. If this channel helped you even a bit, please consider subscribing to the channel. If you need any personal help in SQL, Mock interviews, or Coding help You can contact me at r...
2."SQL Tutorial: Find Top Employee of the Month!" #sql #sqltutorial
zhlédnutí 224Před 2 měsíci
In this tutorial, we'll walk you through an SQL query to identify the top-performing employee each month based on the number of projects they completed. Using Common Table Expressions (CTEs) and ranking functions, you'll learn how to extract, group, and rank data effectively. Perfect for beginners and intermediate SQL users looking to enhance their skills! 🔹 Key Concepts Covered: Common Table E...
Case 15 : Complex SQL Query 1 | Derive Points table for ICC tournament #sql
zhlédnutí 383Před 3 měsíci
#sql #sqlserver #sqltips #sqlforbeginners #sqlinterviewquestions In this video we are going to discuss about a very interesting SQL scenario where we will be deriving points table for a typical tournament . I am putting the create and insert script below. Please do try yourself first before checking the solution. create table icc_world_cup ( Team_1 Varchar(20), Team_2 Varchar(20), Winner Varcha...
1.Return Orders Customer Feedback |Solving a REAL Business Use Case Using SQL#sql #dataengineers
zhlédnutí 74Před 3 měsíci
#sql #business #days #analytics Create orders table CREATE TABLE orders_tbl ( order_id INT PRIMARY KEY, order_date DATE, customer_name VARCHAR(50), sales INT ); Create returns table CREATE TABLE returns_tbl ( order_id INT, return_date DATE ); Insert data into orders table INSERT INTO orders_tbl (order_id, order_date, customer_name, sales) VALUES (1, '2024-01-01', 'Rajanikanth', 1239), (2, '2024...
Real Time Case 13 |SQL problem | Players Reports By Geography | Pivot Ka Baap #sql #dataengineers
zhlédnutí 73Před 3 měsíci
In this video we will solve a LeetCode problem where we need to pivot the data from row to column. The interesting part about this problem is we don't have a common key to pivot the data on. Script: create table players_location ( name varchar(20), city varchar(20) ); delete from players_location; insert into players_location values ('Sachin','Mumbai'),('Virat','Delhi') , ('Rahul','Bangalore'),...
CASE12:need final list of passengers allowed to enter the lift based on the max capacity of the lift
zhlédnutí 200Před 3 měsíci
CASE12:need final list of passengers allowed to enter the lift based on the max capacity of the lift
REAL TIME CASE11:Angel One Easy-Peasy SQL Interview Question for a Data Science & Data Engg Position
zhlédnutí 332Před 3 měsíci
REAL TIME CASE11:Angel One Easy-Peasy SQL Interview Question for a Data Science & Data Engg Position
REAL TIME CASE10:Print Movie Stars (⭐ ⭐ ⭐ ⭐) For best movie in each Genre|MNC SQL Interview Question
zhlédnutí 290Před 4 měsíci
REAL TIME CASE10:Print Movie Stars (⭐ ⭐ ⭐ ⭐) For best movie in each Genre|MNC SQL Interview Question
REAL TIME CASE9: Display List of Survey Nums separated by , for the Particular Farmer. #STRING_AGG
zhlédnutí 64Před 6 měsíci
REAL TIME CASE9: Display List of Survey Nums separated by , for the Particular Farmer. #STRING_AGG
How to create empty table with strucutre based on other table #sql
zhlédnutí 53Před 6 měsíci
How to create empty table with strucutre based on other table #sql
query to swap values/gender in a given table #sql #interview
zhlédnutí 51Před 7 měsíci
query to swap values/gender in a given table #sql #interview
REAL TIME CASE 8 : Business Days Excluding Weekends and Public Holidays
zhlédnutí 97Před 10 měsíci
REAL TIME CASE 8 : Business Days Excluding Weekends and Public Holidays
REAL TIME CASE 7 : Glamorous Question 2 #sql #database #shorts
zhlédnutí 44Před 10 měsíci
REAL TIME CASE 7 : Glamorous Question 2 #sql #database #shorts
REAL TIME CASE 6 : Glamorous Question 1 #sql #database #shorts
zhlédnutí 48Před 10 měsíci
REAL TIME CASE 6 : Glamorous Question 1 #sql #database #shorts
REAL TIME CASE 5 : The FROM and TO #sql #database
zhlédnutí 68Před 10 měsíci
REAL TIME CASE 5 : The FROM and TO #sql #database
REAL TIME CASE 4 : TOP CTC GUY’s #sql #database #short
zhlédnutí 68Před 10 měsíci
REAL TIME CASE 4 : TOP CTC GUY’s #sql #database #short
I'm from UK 🇬🇧. These videos are a goldmine for data engineers! The real-time SQL use cases were spot on and incredibly relevant to the challenges we face daily. The practical examples and clear explanations make it so much easier to apply these concepts in our projects. Great job! 👏
❤
Well explained 🎉
Thank you 🙂
Tq for sharing bro😊
Plz subscribe and share with your friends for better reach
@@rajanikanthgaja2916 Alredy subscribed bro...Im a student in SVGIE✊️✊️
❤❤❤❤
😊❤😊
Excellent Explanation rajinkanth garu
Thank you
🎉🎉❤🎉🎉
Good explanation rajini😊
Thanks
Very good explanation 👍🏽
Very good explanation
Thanks for your comment
with col_transformed as ( select *, (len(name) - len(replace(name,' ',''))) as checker, CHARINDEX(' ',name) as first_space, CHARINDEX(' ',name,CHARINDEX(' ',name)+1) as second_space from test_names ) select name, case when checker = 0 then name else SUBSTRING(name,1,first_space-1) end as first_name, case when checker = 2 then SUBSTRING(name,first_space+1, (second_space - first_space)) else null end as middle_name, case when checker != 0 then case when checker = 1 then SUBSTRING(name,first_space+1, (len(name)-first_space)) else SUBSTRING(name,second_space+1, (len(name)-second_space)) end else null end as last_name from col_transformed;
🎉🎉❤🎉🎉
❤
WITH cte AS ( SELECT customer_name, TRIM(value) AS part, ROW_NUMBER() OVER (PARTITION BY customer_name ORDER BY (SELECT 1)) AS rn FROM customers CROSS APPLY STRING_SPLIT(customer_name, ' ') ) SELECT customer_name, MAX(CASE WHEN rn = 1 THEN part END) AS first_name, MAX(CASE WHEN rn = 2 THEN part END) AS middle_name, MAX(CASE WHEN rn = 3 THEN part END) AS last_name FROM cte GROUP BY customer_name;
🎉🎉🎉❤🎉🎉🎉
❤
to viewers : while watching this video just take break for every 3 minutes and prepare a notes on this concept...and iam sure u guys won't forget in your life time....
🎉❤🎉
🎉🎉❤🎉🎉
very good question...Keep posting such questions and i will keep liking & share your channel....But please 1 video in every 2 day.or else every day post new & quality level questions...👍👍👍👍
❤
Please provide create & insert statement in the description box for every video.
Sure
I like your approach to make others understand after writing each query and that too step by step in excel...Great keep it up....looking forward to see 1 video in every two days.....Please bring quality level sql questions.👍👍
Sure definitely thanks for your feedback plz subscribe and share my video's for better reach
🎉🎉❤🎉🎉
❤
❤
😊❤😊
Thanks for sharing. Here's my approach on SQL server: =========================================== with cte2 as (select *, ROW_NUMBER() over(partition by name order by (select 1)) rn from names cross apply string_split(name,' ')) select Max(First_name) First_name, Max(Middle_name) Middle_name, Max(Last_name) Last_name from (select *, case when rn = 1 then value end as First_name, case when COUNT(name) over(partition by name) > 2 and rn = 2 then value end Middle_name, case when COUNT(name) over(partition by name) < 3 and rn = 2 then value when COUNT(name) over(partition by name) >= 3 and rn = 3 then value end Last_name from cte2) s1 group by name ===========================================
Excellent
Hi varun, Thanks for your query. Is your query gave the desired output??
🎉🎉❤🎉🎉
❤
Clear cut explanation sir👏
Thanks for your comment plz subscribe my channel this channel will help you in learning sql
❤
🎉❤🎉
with cte as( select team_1, count(*) as total_matches from (select team_1 from icc union all select team_2 from icc) group by 1 ), cte1 as( select c.team_1, i.winner , count(case when c.team_1=i.winner then c.team_1 else null end) as won from cte c left join icc i on c.team_1=i.winner group by 1,2 ), cte2 as( select c.team_1,c.total_matches,c1.won, (c.total_matches - c1.won) as loss from cte1 c1 left join cte c on c.team_1=c1.team_1 ) select *, (won*2) as total_points from cte2 order by 5 desc
❤
❤
🎉❤🎉
-----------My Solution in Oracle ------------------------------ SELECT trim(substr('DATA', LEVEL,1)) str_2_tab FROM dual CONNECT BY LEVEL <= length('DATA') ; Output : str_2_tab D A T A
💓
Nice explanation Sir
Thank you😊
❤❤
Super explanation bro..
Thank you so much 🙂
💓
❤🎉🎉❤
🎉🎉❤🎉🎉
💓
🎉🎉❤🎉🎉