 Cert Prep - Domain 2.0 Data Mining/thumbnail.webp?token=Y291cnNlcy8yMDIyLzAxL0NvbXBUSUEgRGF0YSsgKERBMC0wMDEpIENlcnQgUHJlcCAtIERvbWFpbiAyLjAgRGF0YSBNaW5pbmcvdGh1bWJuYWlsLndlYnA6MTc4MzQ5NzQ3MDpiZjI0MTRmYWE0YzM1YTYwMmU2MGU5M2ExNjdjZjVhZmRjZDQ5NWVlYjVkZDA3MzYzYTZhODZlNzBmMjk4MjU3)
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
0. Introduction
- 01 - Data mining
- 02 - What you need to know
1. Data Acquisition and Integration
- 03 - ETL and ELT processes
- 04 - Public databases
- 05 - Application programming interfaces (APIs)
- 06 - Web scraping
- 07 - Surveys and observation
- 08 - Sampling
2. Cleaning and Profiling Datasets
- 09 - Duplicate and redundant data
- 10 - Missing data
- 11 - Invalid data and outliers
- 12 - Handling outliers
3. Data Manipulation Techniques
- 13 - Sorting data
- 14 - Filtering data
- 15 - Aggregating data
- 16 - Recoding data
- 17 - Data transposition
- 18 - Data normalization
- 19 - String manipulation
- 20 - Working with dates
- 21 - Derived values
- 22 - Combining datasets
4. Query Optimization
- 23 - Indexing
- 24 - Record subsets
- 25 - Query execution plans
- 26 - Parameterization
Next Steps
- 27 - Continuing your studies
Related courses
- Big Data in the Age of AI
- Build with AI: AI-Powered Dashboards with Streamlit
- Build with AI: LLM-Powered Data Analysis App with Python and Streamlit
- Complete Guide to Analytics Engineering
- Tableau Design and Formatting Essential Training
- Advanced Tableau for Climate Professionals
- Advanced Analytics Engineering: Real-World Practice
- Hands-On Data Analysis with ChatGPT-5