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

[@NICITACADEMY]

*Complete 48 hours of Self-Paced Courses and Interview Questions Links:* courses.nicitacademy.com/ Are you interested in joining my Live training? or Self-Paced course? You can visit our website for more details. www.nicitacademy.com/ Contact me for more details @ 🌕 wa.link/m4lat0 *WhatsApp group:* chat.whatsapp.com/KMN5pKoLGSu8PuFLxSouB0 Thanks, NiC IT Academy ======================================================================= 🔵Oracle SQL Tutorial - English kzbin.info/aero/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF 📌*IICS demo session:* kzbin.info/www/bejne/eWLdeImIe7JmY6M 📌*Informatica Full Course:* kzbin.info/www/bejne/jGOppY2VfrOgoMk 📌*SQL Full Course:* kzbin.info/www/bejne/n6bZq52cbNOIZ6s 📌*Informatica, IICS, and SQL playlist* 🌕 IICS Tutorial ENGLISH - Playlist kzbin.info/aero/PLsphD3EpR7F9sqnL3R0jeETHP08Touklj 🌕 Informatica training in ENGLISH - Playlist kzbin.info/aero/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd 🌕 Informatica Interview Preparation - ENGLISH kzbin.info/aero/PLsphD3EpR7F-z_PFoL-uFc9_4DEnYsR3d 🌕Oracle SQL - தமிழில் kzbin.info/aero/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4 🔵 Informatica training in தமிழில் - Playlist kzbin.info/aero/PLsphD3EpR7F8dOIX6bhpv3fnZ8Io_WrH3 🔵 Informatica Interview Preparation - TAMIL kzbin.info/aero/PLsphD3EpR7F8MoCdaGFY_xO7mMfT3fvnD 🔵Unix for Informatica Developer kzbin.info/aero/PLsphD3EpR7F8jeo31oVNJ0yG9AaD-5_jw 🌕Informatica Project videos kzbin.info/aero/PLsphD3EpR7F98r1Mp4QGT9iYmTNwyzPa6 Please subscribe, Like, and comment. I will post more videos. Thanks

[@georgehall2882]

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

[@NICITACADEMY]

Glad you like them!

[@allmedia656]

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

[@krishnanselvam786]

Thank you so much sir.

[@NICITACADEMY]

Most welcome

[@crazygirl-rz5ot]

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

[@NICITACADEMY]

Will upload soon

[@kalairaju8739]

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

[@NICITACADEMY]

Will upload soon

[@jai7104]

THANKING SO MUCH FOR MAKING VIDEO'S

[@NICITACADEMY]

Welcome

[@praneetnema7683]

thank you sir waiting for other vedios to upload

[@NICITACADEMY]

Keep watching

[@sdr9688]

Good explain thank you sir plz more videos

[@NICITACADEMY]

Sure I will

[@kavyaannam1489]

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

[@NICITACADEMY]

Sure 👍 Keep watching. Thanks for your follow up.

[@sabeerrookie862]

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

[@NICITACADEMY]

please send mail to [e-mail] or please check description of the video.

[@malikbasha4797]

thankyou sir

[@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

[@hasanmougharbel8030]

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.

[@NICITACADEMY]

Hi, Thanks for your wishes. MySQL is open source DB, and Oracle is Paid DB server. But SQL is almost same for both DBs. So please start learning Oracle SQL.

[@sabeerrookie862]

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

[@soundaryakota7579]

Yes Sir Please

[@Cheybanala]

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

[@NICITACADEMY]

Yes, soon

[@thehero3974]

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

[@NICITACADEMY]

Ok sure

[@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

[@NICITACADEMY]

I will try my best

[@mrtharunprao]

@@NICITACADEMY Thank you sir. Will be waiting for an end to end project with an explanation👍.

[@PandiyanSEce]

How we can access other remaining 10 Oracle SQL videos

[@NICITACADEMY]

Please check the description and playlist.

[@PandiyanSEce]

Playlist also available for day 10 alone. Description also given upto day 10 sir. Please share

[@amitprasad5471]

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

[@NICITACADEMY]

Please join my live training

[@technicalfact8390]

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.

[@NICITACADEMY]

Sure. I ll do

[@technicalfact8390]

Thanks sir

[@premkumar-yb7vt]

Hi sir Sir can u explain ( index and cursor) also sir plz And n-varchar also sir

[@NICITACADEMY]

Sure

[@lakshmiprasanna4227]

We want Manual testing explanation sir

[@NICITACADEMY]

I will try

[@kuttiesgalattavlogs4589]

Hi sir..please upload about collections

[@NICITACADEMY]

Will do soon

[@teddyteddy6044]

Sir plz upload remaining 10 videos out of 20

[@WisdomWomenWarrior]

Sir, Kindly upload 11th onwards videos

[@NICITACADEMY]

Sure, I will upload

[@krishnanselvam786]

please post video listagg() funtions sir.

[@NICITACADEMY]

Thanks for your continuous follow up. I will post all your questions.

[@krishnanselvam786]

@@NICITACADEMY thank you so much sir.

[@mamathareddy4986]

sir please upload remaining videos of this

[@NICITACADEMY]

Sure I will do

[@manikantamaddiguntla-x9w]

i want plsql bro please upload videos

[@saireddyksr]

Waiting for 11 video Sir

[@NICITACADEMY]

Very soon

[@thehero3974]

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

[@NICITACADEMY]

Ok sure

[@thehero3974]

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

[@NICITACADEMY]

Ok sure