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

Data Wrangling with MongoDB
MongoDB via Udacity Getting and Cleaning Data
Johns Hopkins University via Coursera 软件包在流行病学研究中的应用 Using software apps in epidemiological research
Peking University via Coursera Creating an Analytical Dataset
Udacity Implementing ETL with SQL Server Integration Services
Microsoft via edX