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

Web sémantique et Web de données
Inria (French Institute for Research in Computer Science and Automation) via France Université Numerique Linked Data Engineering
openHPI Implementing ETL with SQL Server Integration Services
Microsoft via edX Advanced Manufacturing Enterprise
University at Buffalo via Coursera Big Data Services: Capstone Project
Yandex via Coursera