Day 10 - Analytical | Window Functions in SQL | Oracle SQL for Beginners | Oracle SQL Tutorial

#JUSTIN#ORACLE#SQL#TAMIL#oracle#sqlinterviewquestions#sqlinterviewquestionsandanswers#oracle#sqlinterviewquestions#sqlinterviewquestionsandanswers

========================================================

⏬ Like the video and comment if you have questions

👉WhatsApp group for SQL/PLSQL discussion✅

🌕For Live training contact me on WhatsApp [phone]) or below link

✅SQL Tutorial Full course with notes

(📢Trainer: Chandra - A Tableau and Informatica, AWS Certified Professional)
📌Having 16+ years of IT experience in Banking, Insurance, and Retail domain
📌Handling corporate and Live training sessions last 10 years

========================================================

📌 Oracle 21C Installation: with software: (How to import HR Schema in Oracle 21C)

Oracle 11g Installation:

==========================================================================

🔵Oracle SQL Tutorial - English

🌕Oracle SQL - தமிழில்

📌 Oracle SQL Day wise Video: ENGLISH

**********************************************************************************
📌 Oracle SQL Full Course in 6 hours - TAMIL

📌Oracle SQL Day wise Video: TAMIL
-----------------------------------

************************************************************************************

Oracle Interview questions:

sql interview questions and answers,
sql server interview questions and answers,
sql questions and answers,sql interview questions for testers,
sql interview questions for freshers,sql interview questions pdf,
sql interview questions for beginners,sql interview questions,
sql interview questions for data analyst,
sql interview questions youtube,
sql interview questions for business analyst,
sql interview questions for experienced,
interview questions sql,
oracle interview questions,
sql interview questions,
top 50 oracle interview questions,
oracle interview questions ,
oracle pl sql interview questions and answers,
intermediate level sql interview questions,
oracle dba interview questions and answers,
top 50 oracle interview questions ,
oracle interview questions for experienced,
interview questions sql,
sql interview questions and answers,
sql interview questions for freshers,
sql interview preparation

===================================
SQL Notes: - Analytical Functions in Oracle
===================================

⏬Oracle Day 10 - Analytical Functions

✅SQL Tutorial Full course

[NICITACADEMY]

*Complete 48 hours of Self-Paced Courses and Interview Questions Links:*

Are you interested in joining my Live training? or Self-Paced course?

You can visit our website for more details.



*WhatsApp group:*


Thanks,
NiC IT Academy



🔵Oracle SQL Tutorial - English

📌*IICS demo session:*

📌*Informatica Full Course:*

📌*SQL Full Course:*

📌*Informatica, IICS, and SQL playlist*

🌕 IICS Tutorial ENGLISH - Playlist

🌕 Informatica training in ENGLISH - Playlist

🌕 Informatica Interview Preparation - ENGLISH

🌕Oracle SQL - தமிழில்

🔵 Informatica training in தமிழில் - Playlist

🔵 Informatica Interview Preparation - TAMIL

🔵Unix for Informatica Developer

🌕Informatica Project videos

Please subscribe, Like, and comment. I will post more videos.

Thanks

[allmedia]

First time I learned SQL/ETL by you and got job. THis second time that I'm learning your lessons. Its so clear and you make easy to understand PL/SQL better. Thank you RAJ

[georgehall]

I just ran across your channel and I wanted to say thank you. Great, informal videos.

[crazygirl-rzot]

sir pls post the next videos...I'm learning lot in easy way from your videos

[kalairaju]

Sir we need plsql class in a single video like this.It will be very helpful for us sir

[kavyaannam]

Thank you for the new vedio sir
Please 🙏 upload all the tutorials

[praneetnema]

thank you sir
waiting for other vedios to upload

[shathabdhir]

3. Which is the top transaction in each day.;

select *
from (select TRANS_DATE, TRANSACTION_ID, ACCOUNT_NO, NAME, CR_DR, AMOUNT, BALANCE_AMOUNT,
rank() over(partition by TRANS_DATE order by amount desc) as trans from transactions)
where trans = 1 ;

is this correct for 3rd question, the Querry is missing in the excel sheet

[hasanmougharbel]

Hey there, god bless your efforts in this channel.
As a newbie sql learner i have general enquiry.
What is the major difference between Oracle database and mysql database.
Is there any advantages i need to consider before choosing to work on one of them.
Thanks for taking care of this.

[sdr]

Good explain thank you sir plz more videos

[sabeerrookie]

Please do more sql topics sir like synonyms, sequence and roll up

[jai]

THANKING SO MUCH FOR MAKING VIDEO'S

[amitprasad]

sir very nice content.👍👍
but still we are waiting for remaining video.

[mrtharunprao]

Sir can you please upload the remaining lectures. It will be a great help sir...
And can you please upload a real time project with an end to end project.
Thank you for your video

[technicalfact]

Sir, please complete oracle sql series . You have mentioned 20 videos but there is only 10 videos.
I am learning through your video step by step.
I need your video sir.

[thehero]

Sir Thank you so much.... please upload Views video soon

[lakshmiprasanna]

We want Manual testing explanation sir

[teddyteddy]

Sir plz upload remaining 10 videos out of 20

[Cheybanala]

Hi Sir can you please make a video on performance running techniques with examples

[sabeerrookie]

we need to change IT domain sir how to contact you sir.