YoVDO

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

Internet of Things: Sensing and Actuation From Devices
University of California, San Diego via Coursera
用Python玩转数据 Data Processing Using Python
Nanjing University via Coursera
Enabling Technologies for Data Science and Analytics: The Internet of Things
Columbia University via edX
Data Journalism Fundamentals
Google via Independent
Data Science Essentials
Microsoft via edX