Data Warehousing for Starters

  Рет қаралды 2,138

James Oliver

James Oliver

Күн бұрын

Пікірлер: 14
@Dayzdeee
@Dayzdeee Жыл бұрын
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! 😊
@ljubicar1987
@ljubicar1987 2 жыл бұрын
You are very easy to understand, I like your videos!
@Situayo
@Situayo 2 жыл бұрын
Very happy I found this channel. ☺️
@JamesOliver
@JamesOliver 2 жыл бұрын
Welcome aboard!
@chinenyeonwe8419
@chinenyeonwe8419 Жыл бұрын
Thank you so much for this. Way too easy to understand
@rapo107
@rapo107 3 жыл бұрын
James... Please make more videos on this. Thanks in advance..🙏🙏
@JamesOliver
@JamesOliver 3 жыл бұрын
I plan to. They are coming. ;)
@jrbatemanjr
@jrbatemanjr Жыл бұрын
Is this slide deck available publicly ?
@Alex-ol4bv
@Alex-ol4bv 2 жыл бұрын
In the part about the database itself you mention that in a scenario with very large amounts of data, SQL server is probably insufficient. What would be the next (bigger) tech stack you would use in such a situation?
@JamesOliver
@JamesOliver 2 жыл бұрын
It is a good question and you have several options; if you prefer an on-prem setup, Teradata as your database has unbelievable performance. However, if you prefer Cloud Snowflake or SQL managed instance in Azure are some good options. As we know budget is usually the deciding factor lol. I used to run a Teradata shop and now I run a SQL Server shop and the performance difference is stark. Those Teradata engineers built an amazing product for data warehouses.
@Alex-ol4bv
@Alex-ol4bv 2 жыл бұрын
@@JamesOliver thanks for the elaborate feedback. Much appreciated!
@JamesOliver
@JamesOliver 2 жыл бұрын
@@Alex-ol4bv Anytime!
@interestingmusic280
@interestingmusic280 3 жыл бұрын
Videos on Data Vault plz ?
@JamesOliver
@JamesOliver 3 жыл бұрын
This is a great suggestion! Thank you.
SubTotals with SQL using ROLLUP
7:06
James Oliver
Рет қаралды 11 М.
Building an Enterprise Data Warehouse
21:20
James Oliver
Рет қаралды 29 М.
Гениальное изобретение из обычного стаканчика!
00:31
Лютая физика | Олимпиадная физика
Рет қаралды 4,8 МЛН
To Brawl AND BEYOND!
00:51
Brawl Stars
Рет қаралды 17 МЛН
Database Triggers - React to Table Changes
9:51
James Oliver
Рет қаралды 3,9 М.
MicroStrategy Desktop is FREE but is it good?
21:33
James Oliver
Рет қаралды 3,2 М.
SQL Unpivot and more
14:45
James Oliver
Рет қаралды 13 М.
SQL Performance Tips
8:47
James Oliver
Рет қаралды 7 М.
Database vs Data Warehouse vs Data Lake | What is the Difference?
5:22
Alex The Analyst
Рет қаралды 846 М.
My AI powered life saving invention
7:44
James Oliver
Рет қаралды 489
Learn the Fundamentals of Microsoft Fabric in 38 minutes
38:00
Learn Microsoft Fabric with Will
Рет қаралды 214 М.
Data Blending - Advanced Documents - MicroStrategy
16:34
James Oliver
Рет қаралды 8 М.
Requirements as the Driving Force for Data Warehousing
7:28
Jason Calanno
Рет қаралды 685
Full outer joins don't get enough love
6:06
James Oliver
Рет қаралды 3,7 М.