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

แชร์
ฝัง
  • เผยแพร่เมื่อ 1 ธ.ค. 2024

ความคิดเห็น • 62

  • @NICITACADEMY
    @NICITACADEMY  2 ปีที่แล้ว +1

    *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
    th-cam.com/play/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF.html
    📌*IICS demo session:*
    th-cam.com/video/C1zGVRFM3-A/w-d-xo.html
    📌*Informatica Full Course:*
    th-cam.com/video/V2FtZ_INmjg/w-d-xo.html
    📌*SQL Full Course:*
    th-cam.com/video/iuvzjf7nU1I/w-d-xo.html
    📌*Informatica, IICS, and SQL playlist*
    🌕 IICS Tutorial ENGLISH - Playlist
    th-cam.com/play/PLsphD3EpR7F9sqnL3R0jeETHP08Touklj.html
    🌕 Informatica training in ENGLISH - Playlist
    th-cam.com/play/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd.html
    🌕 Informatica Interview Preparation - ENGLISH
    th-cam.com/play/PLsphD3EpR7F-z_PFoL-uFc9_4DEnYsR3d.html
    🌕Oracle SQL - தமிழில்
    th-cam.com/play/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4.html
    🔵 Informatica training in தமிழில் - Playlist
    th-cam.com/play/PLsphD3EpR7F8dOIX6bhpv3fnZ8Io_WrH3.html
    🔵 Informatica Interview Preparation - TAMIL
    th-cam.com/play/PLsphD3EpR7F8MoCdaGFY_xO7mMfT3fvnD.html
    🔵Unix for Informatica Developer
    th-cam.com/play/PLsphD3EpR7F8jeo31oVNJ0yG9AaD-5_jw.html
    🌕Informatica Project videos
    th-cam.com/play/PLsphD3EpR7F98r1Mp4QGT9iYmTNwyzPa6.html
    Please subscribe, Like, and comment. I will post more videos.
    Thanks

  • @allmedia656
    @allmedia656 8 หลายเดือนก่อน +1

    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

  • @georgehall2882
    @georgehall2882 9 หลายเดือนก่อน +1

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

    • @NICITACADEMY
      @NICITACADEMY  9 หลายเดือนก่อน

      Glad you like them!

  • @krishnanselvam786
    @krishnanselvam786 2 ปีที่แล้ว +3

    Thank you so much sir.

  • @praneetnema7683
    @praneetnema7683 2 ปีที่แล้ว +1

    thank you sir
    waiting for other vedios to upload

  • @crazygirl-rz5ot
    @crazygirl-rz5ot 2 ปีที่แล้ว +2

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

  • @jai7104
    @jai7104 2 ปีที่แล้ว +1

    THANKING SO MUCH FOR MAKING VIDEO'S

  • @kalairaju8739
    @kalairaju8739 2 ปีที่แล้ว +1

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

  • @sdr9688
    @sdr9688 2 ปีที่แล้ว +1

    Good explain thank you sir plz more videos

  • @shathabdhir
    @shathabdhir ปีที่แล้ว +2

    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

  • @kavyaannam1489
    @kavyaannam1489 2 ปีที่แล้ว +1

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

    • @NICITACADEMY
      @NICITACADEMY  2 ปีที่แล้ว

      Sure 👍 Keep watching. Thanks for your follow up.

  • @thehero3974
    @thehero3974 2 ปีที่แล้ว +1

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

  • @sabeerrookie862
    @sabeerrookie862 2 ปีที่แล้ว +2

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

  • @hasanmougharbel8030
    @hasanmougharbel8030 2 ปีที่แล้ว +1

    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
      @NICITACADEMY  2 ปีที่แล้ว +1

      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.

  • @amitprasad5471
    @amitprasad5471 ปีที่แล้ว +1

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

    • @NICITACADEMY
      @NICITACADEMY  ปีที่แล้ว

      Please join my live training

  • @mrtharunprao
    @mrtharunprao ปีที่แล้ว +1

    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
      @NICITACADEMY  ปีที่แล้ว +1

      I will try my best

    • @mrtharunprao
      @mrtharunprao ปีที่แล้ว

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

  • @malikbasha4797
    @malikbasha4797 2 ปีที่แล้ว +1

    thankyou sir

  • @Cheybanala
    @Cheybanala 2 ปีที่แล้ว +1

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

  • @technicalfact8390
    @technicalfact8390 2 ปีที่แล้ว +1

    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.

  • @sabeerrookie862
    @sabeerrookie862 2 ปีที่แล้ว +3

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

    • @NICITACADEMY
      @NICITACADEMY  2 ปีที่แล้ว

      please send mail to nicitacademy@gmail.com or please check description of the video.

  • @teddyteddy6044
    @teddyteddy6044 ปีที่แล้ว +1

    Sir plz upload remaining 10 videos out of 20

  • @lakshmiprasanna4227
    @lakshmiprasanna4227 2 ปีที่แล้ว +2

    We want Manual testing explanation sir

  • @premkumar-yb7vt
    @premkumar-yb7vt 2 ปีที่แล้ว +1

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

  • @kuttiesgalattavlogs4589
    @kuttiesgalattavlogs4589 2 ปีที่แล้ว +1

    Hi sir..please upload about collections

  • @mamathareddy4986
    @mamathareddy4986 2 ปีที่แล้ว +1

    sir please upload remaining videos of this

  • @WisdomWomenWarrior
    @WisdomWomenWarrior 2 ปีที่แล้ว +1

    Sir, Kindly upload 11th onwards videos

  • @PandiyanSEce
    @PandiyanSEce 2 ปีที่แล้ว +1

    How we can access other remaining 10 Oracle SQL videos

    • @NICITACADEMY
      @NICITACADEMY  2 ปีที่แล้ว

      Please check the description and playlist.

    • @PandiyanSEce
      @PandiyanSEce 2 ปีที่แล้ว

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

  • @krishnanselvam786
    @krishnanselvam786 2 ปีที่แล้ว +1

    please post video listagg() funtions sir.

    • @NICITACADEMY
      @NICITACADEMY  2 ปีที่แล้ว +1

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

    • @krishnanselvam786
      @krishnanselvam786 2 ปีที่แล้ว

      @@NICITACADEMY thank you so much sir.

  • @manikantamaddiguntla-x9w
    @manikantamaddiguntla-x9w ปีที่แล้ว

    i want plsql bro please upload videos

  • @saireddyksr
    @saireddyksr 2 ปีที่แล้ว +2

    Waiting for 11 video Sir

  • @thehero3974
    @thehero3974 2 ปีที่แล้ว +1

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

  • @thehero3974
    @thehero3974 2 ปีที่แล้ว +2

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