CompTIA Data+ (DA0-001) Cert Prep: Domain 2.0 Data Mining

Learn about data mining as you prepare for the CompTIA Data+ (DA0-001) exam.

Introduction

• Data mining
• What you need to know

1. Data Acquisition and Integration

• ETL and ELT processes
• Public databases
• Application programming interfaces (APIs)
• Web scraping
• Surveys and observation
• Sampling

2. Cleaning and Profiling Datasets

• Duplicate and redundant data
• Missing data
• Invalid data and outliers
• Handling outliers

3. Data Manipulation Techniques

• Sorting data
• Filtering data
• Aggregating data
• Recoding data
• Data transposition
• Data normalization
• String manipulation
• Working with dates
• Derived values
• Combining datasets

4. Query Optimization

• Indexing
• Record subsets
• Query execution plans
• Parameterization

Next Steps

• Continuing your studies