First of all thank you very much for the knowlege sharing.I have a range partition in my oracle database (SAP datawarehouse). My boss wants me to reorganize / rearrange the partitions as the archiving SAP job covers only 50Partitions among 75 partitions. SO he suggested me to rearrange. Is it really required to re arrange ? cant we just add the partitions which are not involved in the archiving job and get rid of the space issues.. If it is possible for you to suggest a video of merging or splitting or rearranging existing partitions in oracle db. it will be really helpful for me. Please suggest.

Crona Squares

Hi, I am looking for a mentor who will guide me to learn power BI. Please suggest.

This is great !👏👏👏

pls can uhh share powerbi file

7971 Erica Harbor

Quiz Link : forms.gle/6LdRRHBVvNRJsGfv5 SQL DDL CREATE TABLE Sales ( Sale_ID NUMBER PRIMARY KEY, Sale_Date DATE, Employee_ID NUMBER, Amount NUMBER );

Jones Robert Hernandez Sharon Moore Kimberly

Leola Village

Question no 3 you solved with a nice approach. Suppose in department 20 if there is a tie between there are two people are getting top salary but the second highest will get rank 3 instead of 2. Dense_rank will solve this purpose. You can correct me if I am wrong

great way of explaining.Just perfect and easy to understand.

This amazing video you made 6 years back from now and even today it is very relevant and helpfull. You have such an amazing explanation talent, why you dont made video on SQL queries regularly!!! .

Lela Passage

Greate examples can you suggest me any course to in udemy to learn advanced SQL and ETL process

Well explained

Amazing content 🎉

This is a great series. Excellent information with precision! Thank you so much. One small doubt. Is the order of columns in composite index still relevant? I had heard that now the order in index doesnt matter... If its still relevant then my bad maybe its about order of indexed columns in predicate.

hii

Very helpful video well explained

Its great that u made this project .Hats off to U.Are you planning to make more projects like this? Bdw Thank You So Much Sir

How to edit SQL query in notepad

Thanks a lot for this video. It really helped me understand SCD and its various types.

Beautiful videos, wouldn't have been better if you create a playlist for them ❤

Can't find this playlist

Amazing explanation man , thanks a lot 🍻

It's really helpful to others Thank you so much.....

Hi Vivek, very good explanation.

Well Explained Thank you!

Output of last table all forms

Pls share data file

the IDs should increment, in type 2

Sir Your Video is really outstanding 👏 please also provide the video of integration of machine learning models in power bi from scratch like building machine learning model then testing and deployment in power bi Please make next video on this end to end project sir 😊

hi sir can you share the github link

Please share files for this project

Hi can you share the transaction table file for performing or referring that data for beginners

Nice

2.) select d.department_name,count(e.employee_id) emp_count from departments d,employees e where d.department_id=e.department_id group by d.department_name; @TechCoach - correct me,if its wrong.

more power to you vivek....

Thank you for uploading this. Will there be more sessions?

hi brother, i am learning oracle financial can please let me know how we can download oracle ebs

Instead of rank() function it is better to use dense_rank() for finding second highest or any other highest salary. In case of repeated values, rank() function skips numbering, that it jumps from rank 1 to 3 directly if there are 2 records with 1st highest salary whereas dense_rank() with assign rank 1 to both highest salary records and rank 2 to the next highest salary record.

Thanks Q)If the primary and foreign keys are equated, will null values be possible?

hello sir i know sql plsql what else should i know in order to learn snowflake

Amazingly useful and very interactive video

it would be really good if explained with unix commands

very crisp and clear explanation.. Thanks a lot

Well explained. thankyou