Modern Data Warehouses
Data Warehouse
| Intermediate
- 12 videos | 1h 4m 56s
- Includes Assessment
- Earns a Badge
In today's world, data warehouses have become necessary for making informed business decisions. The wide availability of data comes at an increased cost of storing it efficiently - a necessity for any business working with large amounts of data. Learn more about the key concepts, architecture, stages, use cases, and available solutions for data warehouses using this course. You will examine data warehousing solutions, architecture, and techniques, discover Amazon Redshift and Google BigQuery, and explore the concepts, such as batch, stream, and real-time analytics. This course will also help highlight the considerations for implementing a data warehouse for a business and the implementation steps and best practices required. After completing this course, you will have a foundational knowledge of implementing a data warehousing solution for your business.
WHAT YOU WILL LEARN
-
Discover the key concepts covered in this course
Define a data warehouse and its characteristics
Describe different key concepts and benefits related to modern data warehouses
List the features and architecture amazon redshift data warehouse
Describe the architecture, characteristics, features, and use cases of google bigquery data warehouse
Outline the architecture and various processes involved in a modern data warehouse -
Recognize various techniques that are commonly encountered in a modern data warehouse
Describe batch processing in a data warehouse with an industry use case
Discuss real-time data processing in a modern data warehouse with an industry use case
Outline stream data analytics in a modern data warehouse with an industry use case
Outline the features and functions of hybrid modern data warehouses
Summarize the key concepts covered in this course
IN THIS COURSE
-
2m 9s
-
7m 48s
-
3. Modern Data Warehouses: Key Concepts and Stages7m 46s
-
4. Amazon Redshift6m 15sIn this video, you'll learn more about Amazon Redshift, which is a data warehouse product that forms a division of Amazon Web Services. It has been named as to describe a shift from Oracle and Red because the corporate color of Oracle is red. It's built on massive parallel processing technology and can easily handle large scale data. FREE ACCESS
-
5. Google BigQuery5m 52sIn this video, you'll describe the architecture, characteristics, features, and use cases of Google BigQuery data warehouse. You'll learn this is a Platform-as-a-Service software that supports queries in ANSI SQL. It contains built-in machine learning capabilities and external access to Google's Dremel technology, a scalable, interactive ad hoc query system for analysis of nested data. FREE ACCESS
-
6. Modern Data Warehouses: Architecture and Processes6m 15s
-
7. Modern Data Warehouses: Techniques4m 1s
-
8. Data Warehouse Solutions: Batch Processing5m 53s
-
9. Data Warehouse Solutions: Real-time Processing6m 50s
-
10. Data Warehouse Solutions: Streaming Analytics6m 26s
-
11. Hybrid Modern Data Warehouse4m 8s
-
12. Course Summary1m 32s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
