CompTIA Data+ (DAO-001)

CompTIA Data+ (DAO-001)

Introduction To CompTIA Data+

Course Welcome
Module Overview
Instructor Introduction
What is the CompTIA Data Plus Exam
Roles that should consider the exam
Exam Objectives
Discussion – The Importance of Data
US DOD Member Data Directives and 8570

Module 1 – Data Concepts and Environments
1.1 Module Overview
1.2 Understanding Data Schemes
1.3 Databases
1.4 Demonstration – Google Cloud SQL
1.5 Data Warehouses and Data Lakes
1.7 Comparing OLTP and OLAP Processing
1.8 Demonstration – AWS Redshift
1.9 Demonstration – Deploy SQL DemoBench
1.10 What is Column Database
1.11 Data Structures, Files and Types
1.12 Module Summary Review
1.13 Module Review Questions

Module 2 – Data Mining
2.1 Module 2 Overview
2.2 Data Acquisition and Integration
2.3 Demonstration – Data Integration Techniques
2.4 API Fundamentals
2.5 Demonstration – Google Vision API
2.6 Data Profiling and Cleansing
2.7 Data Collection Method Options
2.8 Data Outliers
2.9 Understanding ETL and ELT
2.10 Query Optimization
2.11 Understanding Data Manipulation Techniques
2.12 Module Summary Review
2.13 Module Review Questions

Module 3 – Data Analysis
3.1 Module Overview
3.2 Descriptive Statistical Methods
3.3 Measures of Tendency and Dispersion
3.4 Understanding Percentages
3.5 Inferential Statistical Methods
3.6 Hypothesis Testing with Excel
3.7 Whiteboard – Linear Regression and Correlation
3.8 Whiteboard – Analysis Testing
3.9 Module Summary Review
3.10 Module Review Questions

Module 4 – Data Visualization
4.10 Module Review Questions
4.1 Module Overview
4.2 Translate Business Requirements to Reports
4.3 Whiteboard – Translate Business Requirements
4.4 Dashboard Fundamentals
4.5 Demonstration – Dashboard Components
4.6 Data Sources and Attributes
4.7 Understanding Chart and Graphs
4.8 Reports Type and Elements
4.9 Module Summary Review

Module 5 – Data Governance, Quality and Controls
5.1 Module Overview
5.2 Introduction to Data Governance
5.3 The Data Lifecycle
5.4 Determining Data Classification
5.5 Data Ownership
5.6 Data Storage Access
5.7 Data Privacy and Frameworks
5.8 Information Rights Management (IRM) and Data Loss Prevention (DLP)
5.9 Setting Data Quality Control
5.10 Methods to Validate Quality
5.11 Data Transformation Tools
5.12 Data Security Fundamentals
5.13 Master Data Management (MDM)
5.14 Module Summary Review
5.15 Module Review Questions

Module 6 – Exam Preparation and Practice Exams
6.1 Module Overview
6.2 Course Summary Review
6.3 Data Plus Exam Experience
6.4 Certification CEU Requirements
6.5 Practice Exams-Additional Resources
6.6 Course Closeout