Course Description
In this associate level course, we will learn about the fundamentals of Data Warehouse and BI systems. Starting with definitions and Key characteristics of OLTP, DWH, BI, Big Data systems; the course will take you through a smooth ride about the key components and various layers of these modern data processing systems.
Later in the course we’ll browse through the architectural differences of OLTP, DWH and Big Data Systems. Towards the end the course shares an overview of Cloud base Data Processing technologies that are facilitated by the leading Cloud Service providers like AWS, Oracle and MS Azure.
The concluding section contains a job market analysis which indicates the usefulness of learning the DWH & BI technologies and skills for getting your dream job in the world of Data.
Course Goals
After taking the course, learners will get a brief exposure to modern data processing systems of the era i.e. Data Warehouse, BI, Big Data, Data Lake, Delta Lake and Data Processing in various cloud service providers. From the course, the middle and senior management can also gain insights on categories of specific data processing environments and the newbies will get significant knowledge about the various underlying technologies which are in high demand in the job market across the globe.
Audience
This course will help :
Newbies
Entry-level environmental professionals
Middle management
Senior management
Topics Covered
• Introduction to DWH, Big Data and BI
• Database and OLTP systems
• Data Warehousing
• Characteristics of Data Warehouse
• DWH Solution Design
• Big Data Analytics
• Introduction to Big Data
• 4 V’s of Big Data
• Big Data Platform
• Data Lake, Delta Lake, Data Pipeline
• Difference between OLTP, DWH and Big Data
• Introduction to Business Intelligence
• Business Intelligence Solution Design
• DWH, Big Data and BI on Cloud
• Cloud Platforms for Data Processing
• Cloud Solutions Architecture
• Example of DWH, BI and Big Data Applications
• Benefits of DWH/BI for an organization
• Career Options and Job market analysis
Instructor
Abdul Mannan is a graduate in Computer Science & certified professional in Oracle, Ms SQL Server, Teradata and Oracle Cloud. He is enriched with experience of managing complex data life cycle; several BI Systems sized 300TB, 900+ TB size & daily data processing of 7billion Records through 200+ concurrent ETL Jobs (Oracle ETL, SAS, Big Data Tools). Recently, as Corporate & Professional Trainer of Data Warehouse and Business Intelligence and Database Systems; overall he has Trained 1000+ technical resources spread across various countries including United Kingdom, Nigeria, EU, Qatar & Pakistan. With 19+ years of experience across international and national organizations Mannan is an expert consultant in Oracle DB management, SQL Server, SQL, SAS, ODI, OBIEE, OAS, ETL/ELT, PostgreSQL, AWS RDS, Backup and Recovery, Performance Optimization of production systems, Disaster Recovery and High availability. He has successfully delivered important assignments with diversified Clientele, including but not limited to World Bank, Lavastorm Sweden, MDA UK, Ericsson Nigeria, Govt of Qatar, MTN Nigeria, Govt. of Pakistan.
What you will get upon completion
You will get a certificate upon course completion for a fee that you can show to your prospective or current employer to demonstrate your proof of competency and skill on this subject.