- Видео 46
- Просмотров 182 596
Techie Creators
Индия
Добавлен 29 сен 2020
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
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
Thnx
Mam here password is can't entered, please help me
The Save Point concept is clear with this video
thank you so much , because of you my error got solved, i was trying for 2 hours but the connection was not getting established.🙂
thank you so much 😊
your video helped to debug the error with in one minute , thanks alot
Thanks for your info
Nice video
Yeah kid this is awesome 🎉❤
if we want to recover the data which we have deleted ?
We can recover by rollback command but after DML operations only.
This video is so helpful ❤ I like this vedio
❤❤❤
thank you so mach
Solve some data analytics sql question it will help
Bang on, it worked perfectly😉
Thank you !
Issue resolved, short and simple video. Thanks
Ma'am i have questions , for inserting dob what will we use
Thank you so much for concept clearing❤
Old but very helpful , thanks mam 😄
Thanks a lot❤
Hi, Thank you so much for sharing this video...
Thank you so much dear. You made my time so relax
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
bachhi mast sikhaya tune ...bole to zakkas
THANK YOU!
I want to know the keyboard command you using to run single lines?
Ctrl + enter
thank you so much
Thank you so much shivani.
thank you so much sister❤❤❤❤ this helps me alot!!!
thanks mam
Thanks a lot 💖
thank u
Thank you so much mam its really worked I am very satisfied with you ❤thanks again😊😊
Thank you sister ❤❤❤. God bless you anytime and everywhere and for everything.
Nice explanation Love you ❤
Love you mam saviour 😂❤.
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...
follow the same steps as shown in video ,it works fine definitely.
It worked perfectly. There is a way to don't have an expiry date?
Thanku so much 🙏
In your notepad++ it shows more than 1000 Lines but in my notepad++ there is only 477 lines
You are brilliant guruji mam👍
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
Thank you so much I was trying for days to solve this issue,by watching your video it helped me.
you save my LIFE !
It got fixed in seconds
Thanks 😊it's very helpfull.
Thankyou so much 🎉
Thank you for the video 👍 clearly shows how pre SQL works before the pipeline is completed
❤❤❤❤❤ easy and I have found my solution❤❤❤
Me toooooo