CompTIA Data+: Database Concepts

CompTIA    |    Intermediate
  • 13 videos | 1h 14m 52s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 23 users Rating 4.6 of 23 users (23)
Databases are used for creating and storing virtually any type of data. Data drives business in the twenty-first century, and IT professionals interested in mastering data analytics must understand the key concepts surrounding databases and their uses in almost every facet of business. In this course, you will discover database concepts, beginning with challenges associated with databases, self-driving databases, data warehouses, data marts, and data lakes and lakehouses. Then you will explore the concepts of Online Transactional Processing (OLTP) and Online Analytical Processing (OLAP). You will learn about database schemas and look closely at star and snowflake schemas, which are common in data warehouses. Finally, you will explore slowly changing dimensions that shape the methods analysts use to keep historical and current data. This course can be used to prepare for the DA0-001: CompTIA Data+ exam.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Outline common challenges encountered when working with databases in a modern data-driven environment
    Recognize the purpose and role of self-driving databases
    Identify the purpose and role of data warehouses
    Outline the purpose and role of data marts
    Identify the purpose and role of data lakes and data lakehouses
    Outline the purpose and role of online transactional processing (oltp)
  • Recognize the purpose and role of online analytical processing (olap)
    Identify the purpose of database schemas, including the three basic schema types, differences between schemas and instances, and the advantages of database schemas
    Work with a star schema and identify its purpose, advantages, and disadvantages
    Work with a snowflake schema and identify its purpose, advantages, and disadvantages
    Outline the role of slowly changing dimensions, including reasons to keep historical and current information
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 11s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 11m 4s
    Upon completion of this video, you will be able to outline common challenges encountered when working with databases in a modern data-driven environment. FREE ACCESS
  • Locked
    3.  Self-driving Databases
    3m 54s
    After completing this video, you will be able to recognize the purpose and role of self-driving databases. FREE ACCESS
  • Locked
    4.  Data Warehouses
    5m 32s
    Upon completion of this video, you will be able to identify the purpose and role of data warehouses. FREE ACCESS
  • Locked
    5.  Data Marts
    4m 41s
    After completing this video, you will be able to outline the purpose and role of data marts. FREE ACCESS
  • Locked
    6.  Data Lakes and Lakehouses
    4m 30s
    Upon completion of this video, you will be able to identify the purpose and role of data lakes and data lakehouses. FREE ACCESS
  • Locked
    7.  Online Transactional Processing (OLTP)
    8m 17s
    After completing this video, you will be able to outline the purpose and role of Online Transactional Processing (OLTP). FREE ACCESS
  • Locked
    8.  Online Analytical Processing (OLAP)
    6m 21s
    Upon completion of this video, you will be able to recognize the purpose and role of Online Analytical Processing (OLAP). FREE ACCESS
  • Locked
    9.  Database Schemas
    7m 23s
    After completing this video, you will be able to identify the purpose of database schemas, including the three basic schema types, differences between schemas and instances, and the advantages of database schemas. FREE ACCESS
  • Locked
    10.  Working with Star Schema
    6m 47s
    In this video, you will learn how to work with a star schema and identify its purpose, advantages, and disadvantages. FREE ACCESS
  • Locked
    11.  Working with Snowflake Schema
    6m 40s
    In this video, you will learn how to work with a snowflake schema and identify its purpose, advantages, and disadvantages. FREE ACCESS
  • Locked
    12.  Slowly Changing Dimensions
    7m 35s
    After completing this video, you will be able to outline the role of slowly changing dimensions, including reasons to keep historical and current information. FREE ACCESS
  • Locked
    13.  Course Summary
    59s
    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 A+ Core 2: Linux, macOS, & Windows File Systems
Rating 4.2 of 69 users Rating 4.2 of 69 users (69)
Course CompTIA Data+: Data Manipulation Techniques
Rating 4.1 of 7 users Rating 4.1 of 7 users (7)
Course CompTIA A+ Core 2: Information Management & Change Management Processes
Rating 4.6 of 2143 users Rating 4.6 of 2143 users (2143)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course CompTIA Data+: Understanding Databases
Rating 4.8 of 44 users Rating 4.8 of 44 users (44)
Course CompTIA Data+: Data Analytics Tools
Rating 4.3 of 32 users Rating 4.3 of 32 users (32)
Course CompTIA Data+: Data Visualization Dashboards
Rating 4.8 of 6 users Rating 4.8 of 6 users (6)