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

Excel 2010
Miríadax Intro to Data Science
Udacity Data Manipulation at Scale: Systems and Algorithms
University of Washington via Coursera Statistical Computing with R - a gentle introduction
University College London via Independent Introducción a Data Science: Programación Estadística con R
Universidad Nacional Autónoma de México via Coursera