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

Offered By: LinkedIn Learning

Tags

CompTIA Data+ (Plus) Courses Data Mining Courses Data Cleaning Courses Data Manipulation Courses Data Acquisition Courses Data Integration Courses Data Profiling Courses

Course Description

Overview

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

Syllabus

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

Taught by

Mike Chapple

Related Courses

Introduction to Data Science
University of Washington via Coursera Big Data Analytics in Healthcare
Georgia Institute of Technology via Udacity More Data Mining with Weka
University of Waikato via Independent Mining Massive Datasets
Stanford University via edX Pattern Discovery in Data Mining
University of Illinois at Urbana-Champaign via Coursera