![James Oliver](/img/default-banner.jpg)
- Видео 82
- Просмотров 871 417
James Oliver
США
Добавлен 27 апр 2018
This channel is dedicated to producing instructional videos centered around all areas of MicroStrategy and Machine Learning. From time to time there will be other videos relating to Business Intelligence and Artificial Intelligence.
Discussing my favorite SQL join with an AI
In this video, AI and I will talk about our favorite joins and I'll demonstrate why the full outer join is my favorite SQL join.
Просмотров: 1 415
Видео
Server aliases - why you need them
Просмотров 1,4 тыс.Год назад
Explaining why you need SQL Server server aliases and showing how to create them.
GPT3 AI Assistant
Просмотров 340Год назад
Demonstrating what is possible with AI. An AI that can have a conversation, look after your home, make you laugh, and can be completely configured with an app.
Tips for dealing with SQL Server constraints
Просмотров 1,3 тыс.Год назад
I'll show you tips for effectively dealing with constraints in difficult situations.
Install High-Performance SQL Servers
Просмотров 1,3 тыс.Год назад
In this video I will walk you through installing a high performing SQL Server 2019 instance.
My AI powered life saving invention
Просмотров 4682 года назад
An in-depth look at a device I invented using artificial intelligence that can potentially save children from downing in swimming pools.
Cross & Outer Apply
Просмотров 7 тыс.2 года назад
In this video I'll discuss cross/outer apply and when you should use them. I will also show you how they differ from regular joins.
SubTotals with SQL using ROLLUP
Просмотров 10 тыс.2 года назад
Demonstration of the group by subclause rollup.
Data Warehousing for Starters
Просмотров 2 тыс.2 года назад
A good starting point for anyone interested in getting started with data warehousing.
Database Triggers - React to Table Changes
Просмотров 3,7 тыс.2 года назад
In this video, I will demonstrate how to react to changes in the underlying data in tables using database triggers. I will also explain the purpose of the inserted and deleted tables.
SQL Performance Tips
Просмотров 7 тыс.3 года назад
Quick tips to help with SQL query optimization that will ultimately lead to better performing queries.
SQL Cursors - how and when to use them
Просмотров 60 тыс.3 года назад
In this video, I will show you how to create a cursor in SQL and explain when it should be used using an example.
MicroStrategy Desktop is FREE but is it good?
Просмотров 3,1 тыс.3 года назад
In this video, we will explore the free version of MicroStrategy Desktop. Interested in learning more about MicroStrategy? Check out my Udemy course at the link below: www.udemy.com/course/microstrategy-architect/?referralCode=92CDF683D9FC8F4FAE97
SQL - Merge
Просмотров 35 тыс.3 года назад
This video covers how to use the merge statement with t-sql.
SQL Unpivot and more
Просмотров 13 тыс.3 года назад
In this video I will demonstrate joining multiple unpivot queries using a real work example.
Building an Enterprise Data Warehouse
Просмотров 28 тыс.4 года назад
Building an Enterprise Data Warehouse
Full outer joins don't get enough love
Просмотров 3,5 тыс.4 года назад
Full outer joins don't get enough love
Are you interested in learning MicroStrategy Architect?
Просмотров 1 тыс.4 года назад
Are you interested in learning MicroStrategy Architect?
Incremental Refresh with Intelligent Cubes - MicroStrategy
Просмотров 6 тыс.4 года назад
Incremental Refresh with Intelligent Cubes - MicroStrategy
Advanced Keras Tutorial with TF 2.0
Просмотров 1,1 тыс.4 года назад
Advanced Keras Tutorial with TF 2.0
JSON and SQL Tutorial - Convert a table to JSON and JSON to table
Просмотров 127 тыс.4 года назад
JSON and SQL Tutorial - Convert a table to JSON and JSON to table
Creating Videos with Neural Networks using GAN
Просмотров 10 тыс.4 года назад
Creating Videos with Neural Networks using GAN
Why do we Randomly Initialize Weights in Neural Networks?
Просмотров 3,8 тыс.4 года назад
Why do we Randomly Initialize Weights in Neural Networks?
Hi James, Please add more videos on Microstrategy advanced concepts. I found your videos are very much helpful to use in my projects. Thanks a lot for sharing this knowledge.
Thank you for this very useful video!
Nice Video
This was so cool. Are you potentially planning to go into more detail so people can recreate it ?
Probably the best teaching video I've seen in terms of: Visuals + well paced script + audio on point. Please keep up the good work.
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?