thanks for the video

thanks for the video

thanks for the video

You are the MAN!!!

Hello sir if you still active user please I want to know how you to create a script for the DATA_LOAD.trg cause I've been reading several article of community they showing only loaded data from the cube not from the datawarehouse. Please can you help me with this

It's rubbish that you have to hard code the columns for the pivot... can you not do a select Distinct to populate that?

Thanks but how can you have sales amount greater than the inventory amount

What's this got to do with SSIS

thank you so much, I appreciate that, and it was very useful

Your videos are great, you speak in such a clear manner

Im just proud of myself that i started learning sql 2 weeks ago and i understand about 95% of what ur talking about. Goals

Been using SQL as a functional ERP resource so I don’t know if I am an expert. This is very well done and IMHO not too far out of reach for someone who has the basics. Where have you been hiding?

do we also need to add weights on the hidden layers? all of them? or only the weights of the input

Do you have same in oracle?

Clear, articulate, simple. Excellent

Step one is googling the meaning of aggregate

no disrespect because you raise an important fact about joins. that said… you should have specified that this is most relevant when a target column is nullable; eg country code in this example.. otherwise if it’s non nullable the outer join is pointless. also this is like one of the first hard lessons you learn when you start writing real queries.

Why no videos nowadays ?

Love it, thanks!

Awesome video, thank you!

Very well explained!

Please make more videos you are really outstanding in the explanations

Thank you so much for clear demo🎉

I just finished your Microstrategy Architect course in udemy and this video is very informative. Thank you for sharing all the knowledge. I am new to everything microstrategy, and I’m struggling on a specific requirement which is to compare previous 4 weeks average to current week’s. Any idea or source material you can direct me to?

Outstanding video! Thank you!

Well produced video, but it’s the equivalent to very professionally explaining how to set yourself on fire

Hi James Oliver, This video looks good and helpful. I wanted to create freeform sql report with promts and filters. how can we use filters in Freeform SQL Report.

VERY nice......... clear and concise. Thank you!

Script to try yourself: create table Account_Balance( Account_Number int, Balance int); insert into Account_Balance values(1,100), (2,150), (3,200), (4,250), (5,1000), (6,5000) select * from Account_Balance create table Account_Payments( Date date, Account_Number int, Payment int); insert into Account_Payments values('2021-02-06',1,50), ('2021-02-06',2,25), ('2021-02-06',2,125), ('2021-02-06',3,100), ('2021-02-06',4,50), ('2021-02-06',5,500), ('2021-02-06',6,250), ('2021-02-06',6,250) select * from Account_Payments

That is not the Terminator. It is C3PO's girlfriend. Full outer is a combination of all 3. Left, Inner, Right.

I learned this the hard way when I was pulling customers and comments. Inner join would not pull customers without a comment.

I was just about to say this tutorial is awesome and then you went onto the deleted and inserted tables without taking a moment to walk trough the target table after the merge. And I have learned so far that deleted and inserted tables are available only within the scope of the triggers. Which confused me further.

Thank you so much for this clear and concise explanation!!!!!!! 🙏

I just love the WHERE-statement in the UPDATE; that will be applied n-times for each entry. I hope MS SQL offers some cashing natively, because that looks like a killer app.

Hey in check u used columname but it in resukt set we get only after_payment how could it happen

at the first query, isn't it the same as union all? instead of left join+coalesce? if not, when do you use which?

Most clear tutorial i've even seen.

Very good explanation! Got to see how it starts with a join, and evolves to apply. Thanks for the good content! Two questions: 1. Is there any case where we only want to use APPLY over other functions? 2.In the cross apply example that returns top 2 rows for each person, I guess using ROW_NUM() would also work. How would it differ from using apply here? Is it performance wise?

Thank you so much for this. Way too easy to understand

Amazing video ,ty 😎

this is the first SQL tutorial i found on youtube which is not from an indian guy, thank you

Thanks for sharing the most flexible way to define the JSON tree from the dataset source !

I love your teaching style! I took a data science bootcamp and was crammed with lots of information in a short period of time. I survived, but I'm now going back through all the topics I learned and trying to digest all the information in a more relaxed pace. Thank you! 😊

Seems like a bit of an odd one, this. It seems like the sort of thing even a beginner should understand. If I was to interview and test a junior SQL developer for a job (something I'll be helping to do within the next couple of months) and they didn't know this, I would be very hesitant to employ them! Your statement about this sort of thing separating an expert or a true professional from a novice or intermediate developer just seems way off!

Thank you for this video, it's the best explanation I've seen. Question: Is it fair to say that outer apply and left join are interchangeable?

Hello James! Thanks a lot for your explanation. How to save the video after adding noise? I wan to compare input and output that video.

Thank yoj

Hi James, do you have any recommendation for courses (free or paid) on backend SQL Development?

You teach incredibly great..... expert level but yet so simple and easy the way you teach. awesome James Oliver

Thank you, PERFECT EXPLANATION !