Performance Optimization for OLAP Workloads in SQL Server

Focused View

1:02:12

152 View

1 - Overview.mp4

00:56

2 - Introduction to Analytic Data.mp4

02:49

3 - OLAP vs. OLTP - How Do They Differ.mp4

07:28

4 - Assigning Business Goals and Meaning to Data.mp4

06:59

5 - Classifying Data - Dimensions vs. Facts.mp4

06:55

6 - Optimizing Data Load Processes.mp4

09:16

7 - Indexing - B-Tree Versus Columnstore Indexes.mp4

07:27

8 - ETL, Validation, and Analyzing Data Sources.mp4

05:04

9 - Caching Challenging Metrics for Quick Retrieval.mp4

03:40

10 - Scaling Analytic Data.mp4

08:50

11 - Conclusion.mp4

02:48

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Apress, a Springer Nature company, is a publisher dedicated to meeting the information needs of developers, IT professionals, and tech communities worldwide. Our high-quality, practical content helps technology professionals at all levels increase the skills they need to advance in their day-to-day work. Key topics on our list of over 3,000 titles include big data, databases, open source, web development, Java, Python, Apple & Swift, and of course there is Apress’ well-known line of Microsoft and .NET titles. Apress customers have the option to purchase our print or eBooks on a title-by-title basis or to subscribe to all Apress content via our subscription product Apress Access. Apress has editorial staff in the US, the UK, and in Pune, India. Our authors are spread out all over the world.