CompTIA Data+ (DA0-001) Cert Prep: Domain 2.0 Data Mining
1h 27mBeginner2022-01-03
Authors
Mike Chapple
Teaching Professor at the University of Notre Dame
Course details
Are you wanting to learn more about data analytics or seeking your CompTIA Data+ certification? In this course, instructor Mike Chapple explains data mining and helps you prepare for the second domain of the Data+ exam. Mike steps you through data acquisition and integration, including ETL and ELT processes, APIs, web scraping, sampling, and more. He goes over cleaning and profiling datasets, then covers data manipulation techniques, such as sorting, filtering, aggregating, and recording your data, as well as data transposition and normalization. Plus, Mike discusses query optimization methods like indexing, record subsets, query execution plans, and parameterization.
Skills covered
Data AnalysisCert PrepData ScienceBusiness Analysis and StrategyBusiness Software and Tools
Concepts
Introduction
- Data mining
- What you need to know
Data Acquisition and Integration
- ETL and ELT processes
- Public databases
- Application programming interfaces (APIs)
- Web scraping
- Surveys and observation
- Sampling
Cleaning and Profiling Datasets
- Duplicate and redundant data
- Missing data
- Invalid data and outliers
- Handling outliers
Data Manipulation Techniques
- Sorting data
- Filtering data
- Aggregating data
- Recoding data
- Data transposition
- Data normalization
- String manipulation
- Working with dates
- Derived values
- Combining datasets
Query Optimization
- Indexing
- Record subsets
- Query execution plans
- Parameterization
Next Steps
- Continuing your studies