Modules
1 -
Introduction to CompTIA Data+ (DA0-001)
#
Lesson
Duration
Type
1.
Welcome
FREE
11m:38s

2.
Download your free study guide

3.
Exam Tips
FREE
5m:56s

4.
How to Use the Lab Environment

5A.
Lab: Exploring the Lab Environment

6.
Checkpoint: Introduction

2 -
Data Schemas
#
Lesson
Duration
Type
1.
Data Schemas
FREE
2m:39s

2.
Relational Databases
FREE
4m:31s

3.
Non-relational Databases
FREE
5m:3s

4.
Comparing Database Types
4m:40s

5.
Data Normalization
5m:34s

6.
Database Relationships
5m:41s

7.
Referential Integrity
3m:5s

8.
Data Denormalization
2m:19s

9.
Hands-on with Data Schemas
15m:23s

10A.
Lab: Navigating and Understanding Database Design

11.
Checkpoint: Data Schemas

3 -
Data Systems
#
Lesson
Duration
Type
1.
Data Systems
1m:3s

2.
Data Processing Types
4m:11s

3.
Data Warehouse
7m:38s

4.
Data Warehouse Schemas
5m:45s

5.
Data Lakes
4m:53s

6.
Changing Dimensional Data
5m:10s

7.
Hands-on with Data Systems
15m:7s

8.
Checkpoint: Data Systems

4 -
Data Types
#
Lesson
Duration
Type
1.
Data Types
1m:14s

2.
Quantitative & Qualitative
6m:6s

3.
Data Field Types
7m:25s

4.
Converting Data
3m:16s

5A.
Lab: Understanding Data Types and Conversion

6.
Data Structures
6m:47s

7.
Data File Formats
4m:8s

8A.
Lab: Working with Different File Formats

9.
Data Languages
12m:3s

10.
Hands-on with Data Types
25m:5s

11A.
Lab: Understanding Data Structure and Types and Using Basic Statements

12.
Checkpoint: Data Types

5 -
Data Acquisition
#
Lesson
Duration
Type
1.
Data Acquisition
1m:50s

2.
Extracting Data
4m:31s

3.
Transforming Data
3m:57s

4.
Loading Data
6m:27s

5.
Application Programming Interface (API)
7m:42s

6.
Web Scraping
2m:51s

7.
Machine Data
2m:23s

8.
Public Databases
6m:25s

9.
Survey Data
4m:24s

10.
Sampling and Observation
5m:36s

11.
Hands-on with Data Acquisition
10m:5s

12A.
Lab: Using Public Data

13.
Checkpoint: Data Acquisition

6 -
Cleansing and Profiling Data
#
Lesson
Duration
Type
1.
Cleansing and Profiling Data
1m:35s

2.
Data Profiling Steps
4m:31s

3.
Data Profiling Tools
2m:24s

4A.
Lab: Profiling Data Sets

5.
Redundant and Duplicated Data
5m:16s

6A.
Lab: Addressing Redundant and Duplicated Data

7.
Unnecessary Data
3m:17s

8.
Missing Values
5m:18s

9A.
Lab: Addressing Missing Values

10.
Invalid Data
6m:19s

11.
Meeting Specifications
2m:56s

12.
Data Outliers
5m:2s

13.
Hands-on with Cleaning and Profiling Data
13m:50s

14A.
Lab: Preparing Data for Use

15.
Checkpoint: Cleansing and Profiling Data

7 -
Data Manipulation
#
Lesson
Duration
Type
1.
Data Manipulation
1m:12s

2.
Recording Data
8m:6s

3.
Derived Variables
3m:37s

4.
Value Imputation
4m:21s

5.
Aggregation and Reduction
3m:31s

6.
Data Masking
4m:24s

7.
Transposing Data
3m:15s

8.
Appending Data
2m:10s

9.
Hands-on with Data Manipulation
14m:10s

10A.
Lab: Recoding Data

11.
Checkpoint: Data Manipulation

8 -
Performing Data Manipulation
#
Lesson
Duration
Type
1.
Performing Data Manipulation
1m:58s

2.
Data Blending
7m:23s

3.
Parsing Strings
3m:23s

4.
Date Manipulation
5m:31s

5.
Conditional Logic
4m:30s

6.
Aggregation Functions
4m:2s

7.
System Functions
2m:4s

8.
Hands-on with Performing Data Manipulation
12m:38s

9.
Checkpoint: Performing Data Manipulation

9 -
Querying & Filtering Data
#
Lesson
Duration
Type
1.
Querying & Filtering Data
1m:51s

2.
Querying Data
2m:2s

3.
Join Types
5m:46s

4A.
Lab: Working with Queries and Join Types

5.
Filtering Data
2m:23s

6.
Parameterization
2m:46s

7.
Indexing Data
2m:6s

8.
Temporary Tables
2m:52s

9.
Subsets of Records
2m:26s

10.
Query Execution Plan
2m:11s

11.
Hands-on with Querying & Filtering Data
14m:14s

12A.
Lab: Building Queries and Transforming Data

13.
Checkpoint: Querying & Filtering Data

10 -
Types of Analysis
#
Lesson
Duration
Type
1.
Types of Analysis
1m:33s

2.
Determining the Analysis Type
5m:10s

3.
Exploratory Analysis
2m:2s

4.
Performance Analysis
4m:31s

5.
Gap Analysis
4m:35s

6.
Trend Analysis
4m:18s

7.
Link Analysis
4m:6s

8.
Hands-on with Analysis
11m:52s

9.
Checkpoint: Types of Analysis

11 -
Descriptive Statistical Methods
#
Lesson
Duration
Type
1.
Descriptive Statistical Methods
1m:49s

2.
Central Tendency
4m:25s

3A.
Lab: Using the Measures of Central Tendency

4.
Dispersion
2m:6s

5.
Standard Deviation
7m:24s

6.
Z-score
2m:19s

7.
Distribution
3m:35s

8.
Frequency
2m:50s

9.
Percentages
3m:13s

10.
Confidence Interval
2m:55s

11.
Hands-on with Descriptive Statistical Methods
18m:57s

12A.
Lab: Use Measures of Variability

13.
Checkpoint: Descriptive Statistical Methods

12 -
Inferential Statistical Methods
#
Lesson
Duration
Type
1.
Inferential Statistical Methods
2m:49s

2.
T-Tests and P-Values
5m:46s

3.
Hypothesis Testing
5m:16s

4.
Chi-Square
6m:11s

5.
Regression Analysis
2m:14s

6.
Correlation
5m:30s

7.
Hands-on with Inferential Statistical Methods
8m:53s

8A.
Lab: Analyzing Data

9.
Checkpoint: Inferential Statistical Methods

13 -
Visualization Types
#
Lesson
Duration
Type
1.
Visualization Types
1m:27s

2.
Pie Chart
2m:0s

3.
Tree Map
2m:22s

4.
Column and Bar Charts
3m:39s

5.
Line Chart
2m:29s

6.
Combining Charts
5m:16s

7.
Scatter Plot and Bubble Chart
3m:56s

8A.
Lab: Building Basic Visuals to Make Visual Impact

9.
Histogram
3m:5s

10.
Waterfall
2m:59s

11.
Geographic Maps
4m:12s

12A.
Lab: Building Maps with Geographical Data

13.
Heat Maps
2m:40s

14.
Word Clouds and Infographics
3m:17s

15.
Hands-on with Visualization
15m:10s

16.
Checkpoint: Visualization Types

14 -
Creating Reports
#
Lesson
Duration
Type
1.
Creating Reports
2m:1s

2.
The Audience
4m:52s

3.
Data Sources
4m:46s

4.
Data Models
2m:13s

5.
Data Fields
3m:24s

6.
Data Delivery
3m:31s

7.
Reporting Frequency
2m:33s

8.
Report Types
7m:59s

9A.
Lab: Using Visuals to Tell a Story

10.
Hands-on with Creating Reports
14m:48s

11A.
Lab: Building an Ad Hod Report

12.
Checkpoint: Creating Dashboards

15 -
Creating Dashboards
#
Lesson
Duration
Type
1.
Dashboard Development
2m:9s

2.
Data Filtering
6m:42s

3A.
Lab: Filtering Data

4.
Data Tables
2m:15s

5.
Dashboard Design
6m:35s

6.
Documenting Dashboards
3m:48s

7.
Documentation Elements
5m:26s

8.
Report Elements
5m:8s

9.
Dashboard Optimization
3m:38s

10.
Deploying Dashboards
2m:10s

11.
Hands-on with Creating Dashboards
15m:9s

12A.
Labs: Designing Elements for Dashboards

12B.
Labs: Visualizing Data

13.
Checkpoint: Creating Dashboards

16 -
Data Governance
#
Lesson
Duration
Type
1.
Data Governance
1m:33s

2.
Data Lifecycle
5m:7s

3.
Data Roles
4m:50s

4.
Regulations and Compliance
5m:7s

5.
Data Classification
5m:29s

6.
Access Requirements
4m:3s

7.
Data Retention and Destruction
6m:25s

8.
Data Processing
5m:17s

9.
Data Security
6m:3s

10.
Data Access
3m:31s

11.
Data Storage
2m:47s

12.
Entity Relationships
7m:16s

13.
Hands-on with Data Governance
10m:47s

14A.
Lab: Understanding Security Requirements for Protecting Information

15.
Checkpoint: Data Governance

17 -
Data Quality
#
Lesson
Duration
Type
1.
Data Quality
1m:35s

2.
Quality Checks
4m:53s

3.
Quality Dimensions
3m:39s

4.
Quality Rules and Metrics
2m:11s

5.
Data Validation
3m:4s

6.
Automated Validation
2m:27s

7.
Data Verification
3m:36s

8.
Master Data Management (MDM)
5m:1s

9.
Streamlining Data Access
3m:52s

10.
Hands-on with Data Quality
8m:9s

11.
Checkpoint: Data Quality

18 -
Data Analytic Tools
#
Lesson
Duration
Type
1.
Data Analytic Tools
2m:22s

2.
Data Languages
1m:40s

3.
Data Transformation Tools
2m:55s

4.
Data Visualization Tools
3m:44s

5.
Statistical Tools
2m:51s

6.
Reporting Tools
2m:53s

7.
Platform Tools
5m:40s

8.
Checkpoint: Data Analytic Tools

19 -
Conclusion
#
Lesson
Duration
Type
1.
BONUS: Conclusion
11m:9s

2.
CompTIA Data+ (DA0-001) Practice Exam
