Lesson 1: Identifying Basic Concepts of Data Schemas
- Topic 1A: Identify Relational and Non-Relational Databases
- Topic 1B: Understand the Way We Use Tables, Primary Keys, and Normalization
Lesson 2: Understanding Different Data Systems
- Topic 2A: Describe Types of Data Processing and Storage Systems
- Topic 2B: Explain How Data Changes
Lesson 3: Understanding Types and Characteristics of Data
- Topic 3A: Understand Types of Data
- Topic 3B: Break Down the Field Data Types
Lesson 4: Comparing and Contrasting Different Data Structures, Formats, and Markup Languages
- Topic 4A: Differentiate Between Structured Data and Unstructured Data
- Topic 4B: Recognize Different File Formats
- Topic 4C: Understand the Different Code Languages Used for Data
Lesson 5: Explaining Data Integration and Collection Methods
- Topic 5A: Understand the Processes of Extracting, Transforming and Loading Data
- Topic 5B: Explain API/Web Scraping and Other Collection Methods
- Topic 5C: Collect and Use Public and Publicly Available Data
- Topic 5D: Use and Collect Survey Data
Lesson 6: Identifying Common Reasons for Cleansing and Profiling Data
- Topic 6A: Learn to Profile Data
- Topic 6B: Address Redundant, Duplicated, and Unnecessary Data
- Topic 6C: Work with Missing Values
- Topic 6D: Address Invalid Data
- Topic 6E: Convert Data to Meet Specifications
Lesson 7: Executing Different Data Manipulation Techniques
- Topic 7A: Manipulate Field Data and Create Variables
- Topic 7B: Transpose and Append Data
- Topic 7C: Query Data
Lesson 8: Explaining Common Techniques for Data Manipulation and Optimization
- Topic 8A: Use Functions to Manipulate Data
- Topic 8B: Use Common Techniques for Query Optimization
Lesson 9: Applying Descriptive Statistical Methods
- Topic 9A: Use Measures of Central Tendency
- Topic 9B: Use Measures of Dispersion
- Topic 9C: Use Frequency and Percentages
Lesson 10: Describing Key Analysis Techniques
- Topic 10A: Get Started with Analysis
- Topic 10B: Recognize Types of Analysis
Lesson 11: Understanding the Use of Different Statistical Methods
- Topic 11A: Understand the Importance of Statistical Tests
- Topic 11B: Break Down the Hypothesis Test
- Topic 11C: Understand Tests and Methods to Determine Relationships Between Variables
Lesson 12: Using the Appropriate Type of Visualization
- Topic 12A: Use Basic Visuals
- Topic 12B: Build Advanced Visuals
- Topic 12C: Build Maps with Geographical Data
- Topic 12D: Use Visuals to Tell a Story
Lesson 13: Expressing Business Requirements in a Report Format
- Topic 13A: Consider Audience Needs When Developing a Report
- Topic 13B: Describe Data Source Considerations for Reporting
- Topic 13C: Describe Considerations for Delivering Reports and Dashboards
- Topic 13D: Develop Reports or Dashboards
- Topic 13E: Understand Ways to Sort and Filter Data
Lesson 14: Designing Components for Reports and Dashboards
- Topic 14A: Choose Design Elements for Reports/Dashboards
- Topic 14B: Utilize Standard Elements for Reports/Dashboards
- Topic 14C: Create a Narrative and Other Written Elements
- Topic 14D: Understand Deployment Considerations
Lesson 15: Distinguishing Different Report Types
- Topic 15A: Understand How Updates and Timing Affect Reporting
- Topic 15B: Differentiate Between Types of Reports
Lesson 16: Summarizing the Importance of Data Governance
- Topic 16A: Define Data Governance
- Topic 16B: Understand Access Requirements and Policies
- Topic 16C: Understand Security Requirements
- Topic 16D: Understand Entity Relationship Requirements
Lesson 17: Applying Quality Control to Data
- Topic 17A: Describe Characteristics, Rules, and Metrics of Data Quality
- Topic 17B: Identify Reasons to Quality Check Data and Methods of Data Validation
Lesson 18: Explaining Master Data Management Concepts
- Topic 18A: Explain the Basics of Master Data Management
- Topic 18B: Describe Master Data Management Processes
Appendix A: Identifying Common Data Analytics Tools
Appendix B: Mapping Course Content to CompTIA Data+ Certification (DA0-001)
Exams and assessments
This course prepares learners for the CompTIA Data+ (DA0-002) certification exam, taken post course, and included with your course booking.
- Exam format: Maximum of 90 multiple-choice and performance-based questions
- Duration: 90 minutes
- Grading: Pass/fail
Hands-on learning
Participants will complete scenario-based labs, knowledge checks, and discussions to reinforce exam readiness. An exam voucher is included.
