- 46
- 201 391
Techie Creators
India
เข้าร่วมเมื่อ 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
มุมมอง: 534
วีดีโอ
How to Get Unmatched Records from Two Tables using JOIN in SQL |Oracle SQL Tutorial |Techie Creators
มุมมอง 1866 หลายเดือนก่อน
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
มุมมอง 687 หลายเดือนก่อน
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
มุมมอง 837 หลายเดือนก่อน
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
มุมมอง 29110 หลายเดือนก่อน
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
มุมมอง 38710 หลายเดือนก่อน
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
มุมมอง 54610 หลายเดือนก่อน
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
มุมมอง 1.1K11 หลายเดือนก่อน
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
มุมมอง 35111 หลายเดือนก่อน
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
มุมมอง 160ปีที่แล้ว
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
มุมมอง 113ปีที่แล้ว
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
มุมมอง 135ปีที่แล้ว
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.9Kปีที่แล้ว
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
มุมมอง 902ปีที่แล้ว
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
มุมมอง 472ปีที่แล้ว
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
มุมมอง 164ปีที่แล้ว
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
มุมมอง 2.7Kปีที่แล้ว
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.5Kปีที่แล้ว
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
มุมมอง 360ปีที่แล้ว
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.3Kปีที่แล้ว
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
มุมมอง 10Kปีที่แล้ว
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
มุมมอง 8Kปีที่แล้ว
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
มุมมอง 1222 ปีที่แล้ว
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
มุมมอง 7184 ปีที่แล้ว
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
มุมมอง 6364 ปีที่แล้ว
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
มุมมอง 5314 ปีที่แล้ว
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
มุมมอง 5K4 ปีที่แล้ว
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.2K4 ปีที่แล้ว
DEFAULT Constraint | Oracle SQL Tutorial for beginners | Techie Creators
CHECK Constraint | Oracle SQL Tutorial for beginners | Techie Creators
มุมมอง 4794 ปีที่แล้ว
CHECK Constraint | Oracle SQL Tutorial for beginners | Techie Creators
FOREIGN Key Constraint | Oracle SQL Tutorial for beginners | Techie Creators
มุมมอง 4844 ปีที่แล้ว
FOREIGN Key Constraint | Oracle SQL Tutorial for beginners | Techie Creators
good you saved my time
thanks
thank u my sister❤
Excellent explanation, you have good teaching skills
I got this problems anyone help me.. select username,expiry_date from dba_users where USERNAME = 'SYSTEM'; select username,expiry_date from dba_users where USERNAME = 'SYSTEM' * ERROR at line 1: ORA-01034: ORACLE not available Process ID: 0 Session ID: 0 Serial number: 0
After entering conn /as sysdba It is showing like this Invalid username/password; logon denied
its worked thanks a lot
How to drop check constraints
Recently I installed SQL developer tool .but I don't have username and password. How can I setup new connection?
Have you got username and password
thank you so much!!!!!!
It worked! Thanks for this amazing tutorial.
when i try to reset and conn /as sysdba i got again 'invalid username/password; logon denied'
Thank you, this was really helpful.
You same my life
I don't know what I would have done without this tutorial, you saved me, like and suscription more than deserved
cant i will able to run my old sql queries now?
how can i open that left side table disciption box ?
Thanks much! it works
Hi I have issue that I have created a integration service but when I enable the service it saying that 'integration service is unavailable'
Thanks a lot
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!!!