Migrating To A Cloud Data Warehouse
This course details what is involved in migrating data warehouses and data marts to cloud based Analytical Relational DBMSs such as Amazon Redshift, Google Big Query, Microsoft Azure SQL Data Warehouse, IBM DB2 Warehouse on Cloud, Oracle Autonomous Data Warehouse, Snowflake and Teradata Vantage on Cloud.
For most companies today the attraction of cloud computing is too tempting to ignore and one of the areas, that is high priority, is analytics. Many companies are looking take to advantage of new technologies available on the cloud for real-time analytics, machine learning and analysis of huge volumes of multi-structured data, to add to what they already know. However, given that their core analytical systems are data warehouses and data marts sitting in their data centres, it’s not surprising that migrating these systems to the cloud is high on the agenda.
This 1-day course details what is involved in migrating data warehouses and data marts to cloud based Analytical Relational DBMSs such as Amazon Redshift, Google Big Query, Microsoft Azure SQL Data Warehouse, IBM DB2 Warehouse on Cloud, Oracle Autonomous Data Warehouse, Snowflake and Teradata Vantage on Cloud.
You will learn:
- What should be in a data warehouse migration plan
- Pre-migration preparation
- Defining a data warehouse migration strategy
- The risks that can threaten the chance of success and how to de-risk a project
- How to migrate a data warehouse schema, data and ETL jobs and security while minimizing impact on business users
- Understanding SQL differences
- Whether you should migrate an existing data warehouse ‘as is’ or try to make changes during migration?
- Existing data warehouse DBMS specifics you need to know about in a migration
- Migration tools to help you
Who should attend
CDO’s, CIO’s, IT managers, CTO’s, business analysts, data analysts, data scientists, BI managers, business intelligence and data warehousing professionals, enterprise architects, data architects.
About the instructor: Mike Ferguson
Mike is Managing Director of Intelligent Business Strategies Limited. As an analyst and consultant he specialises in business intelligence and enterprise business integration. With over 35 years of IT experience, Mike has consulted for dozens of companies. He has spoken at events all over the world and written numerous articles. Mike is Chairman of Big Data LDN – the fastest growing Big Data conference in Europe, and chairman of the CDO Exchange. Formerly he was a principal and co-founder of Codd and Date Europe Limited – the inventors of the Relational Model, a Chief Architect at Teradata on the Teradata DBMS and European Managing Director of Database Associates. He teaches popular master classes in Analytics, Big Data, Data Governance & MDM, Data Warehouse Modernisation and Data Lake operations.
Avega Group & Quest for knowledge offer professional courses within Business Intelligence & Data Warehouse.
Visa alla event