CompTIA Data+: Understanding Data Manipulation

CompTIA    |    Intermediate
  • 11 videos | 55m 48s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 13 users Rating 4.5 of 13 users (13)
Data is rarely received in perfect form and often requires some sort of manipulation to make it sing. That is why the world needs data analysts. They can squeeze every bit of usefulness from datasets, and they also know how to prep datasets to extract meaning from them. In this course, you will explore key concepts of data manipulation, beginning with data manipulation tools. Then you will learn organization techniques like filtering and sorting data to make it easier to interpret. Next, you will focus on date functions, logical functions, aggregate functions, and system functions. Finally, you will investigate the best practices associated with data manipulation. This course can be used to prepare for CompTIA Data+ (DA0-001) exam.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Outline the purpose and role of data manipulation in database management
    Provide an overview of typical data manipulation tools
    Filter data in a dataset
    Sort data in a dataset
    Implement date functions
  • Use logical functions with a dataset
    Use aggregate functions with a dataset
    Use system functions with a dataset
    Describe data manipulation best practices
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 47s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 6m 21s
    After completing this video, you will be able to outline the purpose and role of data manipulation in database management. FREE ACCESS
  • Locked
    3.  Data Manipulation Tools
    6m 49s
    Upon completion of this video, you will be able to provide an overview of typical data manipulation tools. FREE ACCESS
  • Locked
    4.  Filtering Data
    6m 9s
    Learn how to filter data in a dataset. FREE ACCESS
  • Locked
    5.  Sorting Data
    4m 51s
    In this video, find out how to sort data in a dataset. FREE ACCESS
  • Locked
    6.  Implementing Date Functions
    6m 16s
    During this video, discover how to implement date functions. FREE ACCESS
  • Locked
    7.  Using Logical Functions
    6m 15s
    Find out how to use logical functions with a dataset. FREE ACCESS
  • Locked
    8.  Using Aggregate Functions
    5m 39s
    During this video, you will learn how to use aggregate functions with a dataset. FREE ACCESS
  • Locked
    9.  Using System Functions
    6m 38s
    Discover how to use system functions with a dataset. FREE ACCESS
  • Locked
    10.  Data Manipulation Best Practices
    5m 32s
    Upon completion of this video, you will be able to describe data manipulation best practices. FREE ACCESS
  • Locked
    11.  Course Summary
    31s
    In this video, we will summarize the key concepts covered in this course. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course CompTIA Data+: Data Analytics Tools
Rating 4.3 of 32 users Rating 4.3 of 32 users (32)
Course CompTIA Data+: Database Concepts
Rating 4.6 of 23 users Rating 4.6 of 23 users (23)
Course CompTIA IT Fundamentals: Networking & Wireless Technologies
Rating 4.7 of 51 users Rating 4.7 of 51 users (51)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Google Professional Cloud Developer: Google Cloud Software Development
Rating 4.6 of 28 users Rating 4.6 of 28 users (28)
Course CompTIA Data+: Data Governance
Rating 4.9 of 10 users Rating 4.9 of 10 users (10)
Course Database Fundamentals: Getting Started with SQL
Rating 4.5 of 272 users Rating 4.5 of 272 users (272)