Video

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

SELECT bowler, COUNT(DISTINCT over) AS no_of_overs_bowled, SUM(CASE WHEN run = 0 THEN 1 ELSE 0 END) AS maiden_overs, SUM(run) AS total_runs FROM your_table_name GROUP BY bowler

Create Video On Cluster or non cluster index😅

Create Video On Cluster or non cluster index😅

thank you so much. very nice video

Very well explained. I had an issue where I had implemented SCD 1. Later SCD 2 replaced it. I would say SCD 4 is a more elegant way. Great job! thanks for this video

Awesome video😎😎👍👍

in SCD0 if we are using the column anymore then doesn't it make sense to delete the column rather than keeping it and not updating?

we can use the email address as a primary key right? it's unique.

what is the reason behind the grade relying on student_ID and Course_ID ?

gookd work

Here in converting the table in 3NF how could we know that we have to add an attribute of "Teacher-id".

Superb bro

Very good and useful video on index. Keep going 👍👍👍

Thanks alottt

Last mai teacher id kahn sy aya koi bta skta h

Last mai teacher id kahn sy aya koi bta skta h

Please make another mock interviews for latest questions like custom visuals,Q&A,more dax questions and some scenario based questions along with sql, Python, excel and statistical analysis Please please please make I really needed guided videos like this to prepare well. I am preparing now interviews for data analyst and power bi developer

It's really very helpful, you all most covered all questions I will surely practice and hopefully I will also select soon

Didnt understand anything Using complex words If we could understand complex words we could have read our book

thanks

How to implement scd type 2 in ORACLE using merge statement..when matched we need to update the record as well as insert.how to do that in oracle database..i don't find any video on this in entire social media.. please help

Great job 👍♥️

Finally understood😊

I found my SQL guru 🙏🙏🙏🙏 You are inspirational sir 🙏🙏 First time iam coping data looking at the videos and practising. Just 🙏🙏🙏💐💐💐💐

great contents

Thank you for your efforts your videos are simple and easy to understand

great explanation bro.....but I am facing voice related issues in your videos....the voice gets low suddenly...can you help me with that?

Nice Video Keep It Up

THANKS A LOT, IT WAS SO USEFULL FOR ME😍

the explanation is clear thank you

very detailed explanation

Beautifully explained!

Course Name; teacher; Correct?

I am 28 can I start my career in IT ?

Thank You!

Thanks Tech coach. We usually tend to forget how to correctly use substr instr, if we do not use it frequently. Saved me good time with this quick reference.