Пікірлер

• 
  @riccarrasquilla3799 күн бұрын

  thanks for the video

• 
  @riccarrasquilla3799 күн бұрын

  thanks for the video

• 
  @riccarrasquilla3799 күн бұрын

  thanks for the video

• 
  @diogopinheiro653012 күн бұрын

  You are the MAN!!!

• 
  @andikhapahlevi16 күн бұрын

  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

• 
  @darrylw9920 күн бұрын

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

• 
  @darrylw9922 күн бұрын

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

• 
  @darrylw9925 күн бұрын

  What's this got to do with SSIS

• 
  @abbasmuhammed214Ай бұрын

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

• 
  @pinkomooreАй бұрын

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

• 
  @passportbro904Ай бұрын

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

• 
  @johnmichelotti5373Ай бұрын

  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?

• 
  @majestro4077Ай бұрын

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

• 
  @sreelakshmia67622 ай бұрын

  Do you have same in oracle?

• 
  @salence992 ай бұрын

  Clear, articulate, simple. Excellent

• 
  @teekay37472 ай бұрын

  Step one is googling the meaning of aggregate

• 
  @mishasawangwan66523 ай бұрын

  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.

• 
  @thirumalaip64583 ай бұрын

  Why no videos nowadays ?

• 
  @bartoszcwiakala89163 ай бұрын

  Love it, thanks!

• 
  @aleksandraarsic11003 ай бұрын

  Awesome video, thank you!

• 
  @sumit-visatotravel87804 ай бұрын

  Very well explained!

• 
  @davindersra4 ай бұрын

  Please make more videos you are really outstanding in the explanations

• 
  @panneerselvam85774 ай бұрын

  Thank you so much for clear demo🎉

• 
  @horhe04234 ай бұрын

  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?

• 
  @R3V0_7774 ай бұрын

  Outstanding video! Thank you!

• 
  @matthewwallen53054 ай бұрын

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

• 
  @rathanakumark5 ай бұрын

  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.

• 
  @DraconaiMac5 ай бұрын

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

• 
  @eRRor4hack5 ай бұрын

  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

• 
  @iliashterev385 ай бұрын

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

• 
  @iliashterev385 ай бұрын

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

• 
  @iliashterev385 ай бұрын

  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.

• 
  @apoorvavanaparthi88535 ай бұрын

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

• 
  @tsunamio77505 ай бұрын

  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.

• 
  @Shankar-zi3yk6 ай бұрын

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

• 
  @user-fx3cs7ew1o6 ай бұрын

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

• 
  @charlotxtreme7 ай бұрын

  Most clear tutorial i've even seen.

• 
  @haowen27997 ай бұрын

  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?

• 
  @chinenyeonwe84198 ай бұрын

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

• 
  @RainSoundsToConcentrate8 ай бұрын

  Amazing video ,ty 😎

• 
  @drecksackblase35309 ай бұрын

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

• 
  @Ferruccio_Guicciardi10 ай бұрын

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

• 
  @Dayzdeee10 ай бұрын

  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! 😊

• 
  @bujin197710 ай бұрын

  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!

• 
  @alexintel802910 ай бұрын

  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?

• 
  @tamhoang773310 ай бұрын

  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.

• 
  @DanielHernandezCa10 ай бұрын

  Thank yoj

• 
  @leodigiacomo10 ай бұрын

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

• 
  @altareq2495311 ай бұрын

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

• 
  @cidaiha11 ай бұрын

  Thank you, PERFECT EXPLANATION !