Techie Creators
Techie Creators
  • Видео 46
  • Просмотров 182 596
How to Find Top 3 Highest Salary in Each Department using RANK() function in SQL | Techie Creators
Hi Everyone,
In this video, explained how to find or select top 3 highest salary using rank function in SQL.
Watch the full video..!
Do LIKE and Hit the SUBSCRIBE button for more videos like this.
#rank
#oracle
#sql
#trending
#techiecreators
#tech
#dbms
#sqlinterview
#sqlinterviewquestions
Просмотров: 412

Видео

How to Get Unmatched Records from Two Tables using JOIN in SQL |Oracle SQL Tutorial |Techie Creators
Просмотров 1143 месяца назад
Hi Techie People, In this video, explained how to find or get unmatched rows from tables using JOIN in SQL. Watch out the full video..! Thank you for watching. Do LIKE and Hit the SUBSCRIBE button..! #oracle #sql #join #unmatched #dbms #techiecreators
Difference between UNION and JOIN in SQL | Oracle SQL Tutorial for beginners | Techie Creators
Просмотров 333 месяца назад
Hi Everyone, In this video, explained the differences between Union and Join in Oracle SQL practically. I hope it helps. Thanks for watching...! Do LIKE and hit the SUBSCRIBE button for more videos like this. #oracle #sql #union #join #dbms #tech #techiecreators #techiecreators
Difference between TRUNCATE and DELETE command in SQL | Techie Creators
Просмотров 564 месяца назад
Hi Everyone, In this video, explained the difference between truncate and delete command in SQL. This is the most asked question in SQL Interview. I explained in a very easy way. Hope it helps! Thank you for watching..! #oracle #sql #sqlinterview #tech #youtube #trending #truncate #ddl #dml
Remove Leading Zeroes and Space from data in Informatica | Informatica PowerCenter
Просмотров 2267 месяцев назад
Hi Everyone, In this video, I explained how to remove leading zeroes and spaces in Informatica with example. I hope it will be useful for you. Thanks for watching..! #informatica #data #oracle #sql
Fix: ORA-00942: Table or view does not exist solved 100% | Informatica PowerCenter | Techie Creators
Просмотров 2687 месяцев назад
Hi Everyone, In this video, I have shown how to fix ORA-00942: Table or view does not exist error in Informatica PowerCenter. First check if table already exist or not in DB. If table exist in DB and still you are facing this issue - then do watch this video. It will be useful. Thanks for watching..! Do LIKE | SHARE | SUBSCRIBE #informatica #data #oracle #ora:00942 #00942 #fix
PRE SQL In Informatica with Example | Informatica PowerCenter Tutorial
Просмотров 3597 месяцев назад
Hi Everyone, In this video, I explained Pre session SQL in Informatica with practical example. You can specify Pre session SQL command in source qualifier transformation and target instance while creating mapping. You can override the SQL commands while creating session in Workflow Manager. I hope it helps!! Thank you for watching! #informatica #presql #engineer #data #datascience #sql
LISTAGG function in Oracle | LISTAGG() function | Oracle SQL Tutorial for beginners| Techie Creators
Просмотров 7218 месяцев назад
Hi Everyone, In this video, I explained LISTAGG() function in Oracle with practical example. This is simple and informative video with very easy example and explanation. I hope it will be useful for you. Thanks for watching...! Please Do LIKE | SHARE |SUBSCRIBE #oracle #listagg #listagg_function #analyticfunction #techiecreators
POST SQL In Informatica | Informatica PowerCenter Tutorial
Просмотров 2748 месяцев назад
Hi Everyone, In this video, I explained POST SQL in Informatica. If you are facing count issues between the target table and count displaying in Session run properties then do check POST SQL query. I explained POST SQL with example. I hope it will help you. Thanks for watching and keep supporting...! Please Do LIKE , SHARE and SUBSCRIBE.. #informatica #postsql #post_Sql #informaticapowercenter ...
LIKE operator in SQL | Like Operator and two wildcards | Techie Creators
Просмотров 149Год назад
Hi Everyone, In this video I explained LIKE operator in SQL and two wildcards also. Please watch whole video. I hope this will help you. Thank you for watching..! Do LIKE | SHARE | SUBSCRIBE #data #like #sqllike #sql #oraclesql #oracle #engineer
SQL Aggregate functions | MIN|MAX| SUM|AVG| DISTINCT|COUNT| Oracle Tutorial | Techie Creators
Просмотров 93Год назад
Hi Everyone, In this video I explained all SQL Aggregate functions. Here MIN(),MAX(),SUM(),AVG(),DISTINCT(),COUNT() are aggregate functions. I made this video super easy to understand and kept it short and clear. I hope it will help you. Thanks for watching...! Please do LIKE | SHARE | SUBSCRIBE #technology #techiecreators #techie #aggregatefunctions #sql #oracle #data #engineering #engineer #a...
SQL Joins | Inner Join | Left Join | Right Join | Full Join | Techie Creators
Просмотров 119Год назад
Hi Everyone, In this video I explained all Joins in SQL which is INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN. I explained in a very clear and easy way with picture and practical example. I hope it will help you. Thank you for watching..! Please do LIKE | SHARE | SUBSCRIBE #oracle #data #sql #joins #sqljoins #oraclesql #dataanalyst #techiecreators #innerjoin #leftjoin #rightjoin #fulljoin
How to Join Multiple Source Tables In Source Qualifier Query | Custom SQ Query | Informatica
Просмотров 1,5 тыс.Год назад
Hi Everyone, In this video I explained How to Join Multiple Source Tables In Source Qualifier Query without dragging source table into designer area. I made this video super easy to understand. I hope this video will be useful for you. Thanks for watching..! Please do LIKE | SHARE | SUBSCRIBE Your likes, comments , subscribe motivates me to make more videos for you. Keep supporting..! #data #in...
How to Import Sources and Targets and Load data from source to target in Informatica - session 2
Просмотров 736Год назад
Hi Everyone, In this video you will see how we can import sources and targets in Informatica powercenter designer and how we can create simple mapping,workflow and session and load the data from source to target. You will get list of sessions in sequence regarding Informatica powercenter. I am trying my best to keep videos as simple as I can, so that everyone can understand easily and get the k...
Informatica Overview and Architecture | Informatica PowerCenter Tutorial | Techie Creators
Просмотров 285Год назад
Hi Everyone, In this video, you will get to know an overview about Informatica and its architecture. I made this video as simple as I could. So a beginner also can learn the concept easily and learn the things practically. I hope this video will be helpful to you.. Thanks for watching..! Do LIKE | SHARE | SUBSCRIBE #informatica #informaticapowercenter #informaticatutorial #engineering #techiecr...
How to Export and Import the data in Oracle table |Oracle SQL Tutorial for beginners|Techie Creators
Просмотров 120Год назад
How to Export and Import the data in Oracle table |Oracle SQL Tutorial for beginners|Techie Creators
How to Create New Connection in Oracle SQL Developer | ORA:01017 issue Fixed | Techie Creators
Просмотров 1,6 тыс.Год назад
How to Create New Connection in Oracle SQL Developer | ORA:01017 issue Fixed | Techie Creators
PCSF_46008 Cannot connect to domain to lookup service | Failed to connect Repository in Informatica
Просмотров 4 тыс.Год назад
PCSF_46008 Cannot connect to domain to lookup service | Failed to connect Repository in Informatica
CASE Statement in SQL | Conditional logic (if then) in SQL | Techie Creators
Просмотров 260Год назад
CASE Statement in SQL | Conditional logic (if then) in SQL | Techie Creators
How to find 2nd or nth highest salary in SQL using Rank and Dense_Rank function | Techie Creators
Просмотров 1,1 тыс.Год назад
How to find 2nd or nth highest salary in SQL using Rank and Dense_Rank function | Techie Creators
FIX: ORA-28000: the account is locked | Oracle SQL Tutorial for beginners | Techie Creators
Просмотров 8 тыс.Год назад
FIX: ORA-28000: the account is locked | Oracle SQL Tutorial for beginners | Techie Creators
Issue Solved-ORA-28001: the password has expired |Oracle SQL Tutorial for beginners| Techie Creators
Просмотров 7 тыс.Год назад
Issue Solved-ORA-28001: the password has expired |Oracle SQL Tutorial for beginners| Techie Creators
Find 2nd or Nth Highest Salary in SQL | SQL Interview Questions | Techie Creators
Просмотров 1132 года назад
Find 2nd or Nth Highest Salary in SQL | SQL Interview Questions | Techie Creators
Global Temporary Table In SQL | Oracle SQL Tutorial for beginners | Techie Creators
Просмотров 6873 года назад
Global Temporary Table In SQL | Oracle SQL Tutorial for beginners | Techie Creators
Create a New Table From an Existing Table | Oracle SQL Tutorial for beginners | Techie Creators
Просмотров 5103 года назад
Create a New Table From an Existing Table | Oracle SQL Tutorial for beginners | Techie Creators
All Constraints In SQL | Oracle SQL Tutorial for beginners | Techie Creators
Просмотров 5013 года назад
All Constraints In SQL | Oracle SQL Tutorial for beginners | Techie Creators
Add and Drop Constraint On an Existing Table | Oracle SQL Tutorial for beginners | Techie Creators
Просмотров 5 тыс.3 года назад
Add and Drop Constraint On an Existing Table | Oracle SQL Tutorial for beginners | Techie Creators
DEFAULT Constraint | Oracle SQL Tutorial for beginners | Techie Creators
Просмотров 1,1 тыс.3 года назад
DEFAULT Constraint | Oracle SQL Tutorial for beginners | Techie Creators
CHECK Constraint | Oracle SQL Tutorial for beginners | Techie Creators
Просмотров 3783 года назад
CHECK Constraint | Oracle SQL Tutorial for beginners | Techie Creators
FOREIGN Key Constraint | Oracle SQL Tutorial for beginners | Techie Creators
Просмотров 3593 года назад
FOREIGN Key Constraint | Oracle SQL Tutorial for beginners | Techie Creators

Комментарии

  • @sharadmishra3279
    @sharadmishra3279 5 дней назад

    Thnx

  • @ShwetaShirgupe
    @ShwetaShirgupe 13 дней назад

    Mam here password is can't entered, please help me

  • @nyanyaa8043
    @nyanyaa8043 14 дней назад

    The Save Point concept is clear with this video

  • @vishantpatil-m3o
    @vishantpatil-m3o 18 дней назад

    thank you so much , because of you my error got solved, i was trying for 2 hours but the connection was not getting established.🙂

  • @vishantpatil-m3o
    @vishantpatil-m3o 18 дней назад

    thank you so much 😊

  • @GANGADHARCHITTURI
    @GANGADHARCHITTURI 27 дней назад

    your video helped to debug the error with in one minute , thanks alot

  • @themodernmanvibes
    @themodernmanvibes 29 дней назад

    Thanks for your info

  • @aritrakhatua1482
    @aritrakhatua1482 29 дней назад

    Nice video

  • @Leohuntergaming
    @Leohuntergaming Месяц назад

    Yeah kid this is awesome 🎉❤

  • @krushnaldinekar5926
    @krushnaldinekar5926 Месяц назад

    if we want to recover the data which we have deleted ?

    • @techiecreators
      @techiecreators Месяц назад

      We can recover by rollback command but after DML operations only.

  • @DharmeshLodha-r4z
    @DharmeshLodha-r4z Месяц назад

    This video is so helpful ❤ I like this vedio

  • @DharmeshLodha-r4z
    @DharmeshLodha-r4z Месяц назад

    ❤❤❤

  • @screnning
    @screnning Месяц назад

    thank you so mach

  • @Manifestion_kannada
    @Manifestion_kannada Месяц назад

    Solve some data analytics sql question it will help

  • @aashishraj8630
    @aashishraj8630 Месяц назад

    Bang on, it worked perfectly😉

  • @dhanushsarode1596
    @dhanushsarode1596 Месяц назад

    Thank you !

  • @tejasshingan241
    @tejasshingan241 Месяц назад

    Issue resolved, short and simple video. Thanks

  • @insights_shorts
    @insights_shorts Месяц назад

    Ma'am i have questions , for inserting dob what will we use

  • @komalmane0712
    @komalmane0712 Месяц назад

    Thank you so much for concept clearing❤

  • @riper99yt17
    @riper99yt17 Месяц назад

    Old but very helpful , thanks mam 😄

  • @blindtoxic
    @blindtoxic 2 месяца назад

    Thanks a lot❤

  • @KrishanKumar-rm4el
    @KrishanKumar-rm4el 2 месяца назад

    Hi, Thank you so much for sharing this video...

  • @Study.Steady8
    @Study.Steady8 2 месяца назад

    Thank you so much dear. You made my time so relax

  • @caleb_riordan
    @caleb_riordan 2 месяца назад

    Tried for 4 hours and couldnt solve it. Learnt about case sensitivty, pluggable databases, dropping and creating and altering users, but nothing worked. Just gonna uninstall and use the online platform

  • @amvstation4301
    @amvstation4301 2 месяца назад

    bachhi mast sikhaya tune ...bole to zakkas

  • @oladikimounika
    @oladikimounika 2 месяца назад

    THANK YOU!

  • @tinyislamichub
    @tinyislamichub 2 месяца назад

    I want to know the keyboard command you using to run single lines?

  • @BandaGangulappa
    @BandaGangulappa 2 месяца назад

    thank you so much

  • @riturajpandey108
    @riturajpandey108 2 месяца назад

    Thank you so much shivani.

  • @DevChotaliya-mq2vh
    @DevChotaliya-mq2vh 2 месяца назад

    thank you so much sister❤❤❤❤ this helps me alot!!!

  • @Ramdut369
    @Ramdut369 3 месяца назад

    thanks mam

  • @dhanush77324
    @dhanush77324 3 месяца назад

    Thanks a lot 💖

  • @vidhisingh487
    @vidhisingh487 3 месяца назад

    thank u

  • @Status__lover490
    @Status__lover490 3 месяца назад

    Thank you so much mam its really worked I am very satisfied with you ❤thanks again😊😊

  • @anirudhkp9402
    @anirudhkp9402 3 месяца назад

    Thank you sister ❤❤❤. God bless you anytime and everywhere and for everything.

  • @spyderman2353
    @spyderman2353 3 месяца назад

    Nice explanation Love you ❤

  • @mean_zd
    @mean_zd 3 месяца назад

    Love you mam saviour 😂❤.

  • @asurivamshi
    @asurivamshi 3 месяца назад

    Hi, The Informatica Service (10.2 version, windows 10 os) is automatically getting stopped after 2 to 3 minutes. The oracle (11g) services are running perfectly. I have restarted the oracle services and after waiting for 5min I restarted the Informatica service but after 2 to 3 min the informatica service is automatically getting stopped. I have checked the catalina.out but it is not showing any user (my repository user & pwd infa only) related error details. Any idea pls...

    • @SB-ln3ln
      @SB-ln3ln 28 дней назад

      follow the same steps as shown in video ,it works fine definitely.

  • @TheEllemak
    @TheEllemak 3 месяца назад

    It worked perfectly. There is a way to don't have an expiry date?

  • @nishuangel4901
    @nishuangel4901 3 месяца назад

    Thanku so much 🙏

  • @sushantsalunkhe4482
    @sushantsalunkhe4482 4 месяца назад

    In your notepad++ it shows more than 1000 Lines but in my notepad++ there is only 477 lines

  • @user-te4vt9ro1v
    @user-te4vt9ro1v 4 месяца назад

    You are brilliant guruji mam👍

  • @explorewithachuu
    @explorewithachuu 4 месяца назад

    more than 5 hrs my mind got collapsed due to i forget my admin password.after watching yur video within 2 mins i got solution and password has been changed.thankyou so much...liked and subscribed

  • @nishantkulkarni819
    @nishantkulkarni819 4 месяца назад

    Thank you so much I was trying for days to solve this issue,by watching your video it helped me.

  • @zephy95
    @zephy95 4 месяца назад

    you save my LIFE !

  • @sailisurve4603
    @sailisurve4603 4 месяца назад

    It got fixed in seconds

  • @psraj2178
    @psraj2178 4 месяца назад

    Thanks 😊it's very helpfull.

  • @kushagrasharma2738
    @kushagrasharma2738 4 месяца назад

    Thankyou so much 🎉

  • @matheeshasuriyaarachchi856
    @matheeshasuriyaarachchi856 4 месяца назад

    Thank you for the video 👍 clearly shows how pre SQL works before the pipeline is completed

  • @jazerabdi9316
    @jazerabdi9316 5 месяцев назад

    ❤❤❤❤❤ easy and I have found my solution❤❤❤