CompTIA Data+: Understanding Databases

CompTIA    |    Intermediate
  • 15 videos | 1h 40m 1s
  • Includes Assessment
  • Earns a Badge
Rating 4.8 of 44 users Rating 4.8 of 44 users (44)
Databases are the backbone of modern life, powering everything from online shopping to social media to memberships and countless other activities. They enable us to store, manage, and retrieve vast amounts of information quickly and efficiently. Understanding databases is the very first step in mastering data analytics. In this course, you will explore databases, beginning with the basic concepts of data analytics, databases, including relational and non-relational databases, and common roles in the field of data science. Then you will examine structured query language (SQL) including examples of SQL operations. Finally, you will investigate the purpose of databases in applications, database management systems (DBMS), how databases are implemented in everyday business environments, and common database tasks. 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 basic concepts of data analytics
    Describe common roles in the field of data science
    Identify basic concepts of databases
    Describe different types of databases
    Outline database components
    Describe the purpose and role of relational databases
    Identify the purpose and role of non-relational (nosql) databases
  • Use a database management system (dbms) to manage data
    Perform basic operations on sql databases
    Work with primary and foreign key relationships between tables in a relational database
    Outline the role of databases in application development
    Identify how databases are typically used in business scenarios
    Outline typical methods for working with databases as well as some common tasks performed
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 8s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 7m 58s
    After completing this video, you will be able to outline the basic concepts of data analytics. FREE ACCESS
  • Locked
    3.  Common Roles in Data Science
    8m 48s
    Upon completion of this video, you will be able to describe common roles in the field of data science. FREE ACCESS
  • Locked
    4.  Introduction to Databases
    5m 23s
    During this video, you will learn how to identify basic concepts of databases. FREE ACCESS
  • Locked
    5.  Types of Databases
    7m 47s
    Upon completion of this video, you will be able to describe different types of databases. FREE ACCESS
  • Locked
    6.  Database Components
    7m 56s
    After completing this video, you will be able to outline database components. FREE ACCESS
  • Locked
    7.  Relational Databases
    7m 40s
    Upon completion of this video, you will be able to describe the purpose and role of relational databases. FREE ACCESS
  • Locked
    8.  Non-Relational (NoSQL) Databases
    10m 35s
    After completing this video, you will be able to identify the purpose and role of non-relational (NoSQL) databases. FREE ACCESS
  • Locked
    9.  Using Database Management Systems (DBMS)
    7m 30s
    Learn how to use a database management system (DBMS) to manage data. FREE ACCESS
  • Locked
    10.  Performing SQL Operations
    9m 22s
    During this video, discover how to perform basic operations on SQL databases. FREE ACCESS
  • Locked
    11.  Exploring Database Relationships
    6m 23s
    In this video, find out how to work with primary and foreign key relationships between tables in a relational database. FREE ACCESS
  • Locked
    12.  Databases in Applications
    4m 37s
    After completing this video, you will be able to outline the role of databases in application development. FREE ACCESS
  • Locked
    13.  How Databases Are Used in Business
    8m 45s
    After completing this video, you will be able to identify how databases are typically used in business scenarios. FREE ACCESS
  • Locked
    14.  Methods for Working with Databases
    5m 13s
    Upon completion of this video, you will be able to outline typical methods for working with databases as well as some common tasks performed. FREE ACCESS
  • Locked
    15.  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 IT Fundamentals: Basic IT Concepts
Rating 4.7 of 114 users Rating 4.7 of 114 users (114)
Course CompTIA Data+: Data Visualization Reports
Rating 5.0 of 6 users Rating 5.0 of 6 users (6)
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+: Database Concepts
Rating 4.6 of 23 users Rating 4.6 of 23 users (23)
Course CompTIA Server+: Servers & Cloud Computing
Rating 4.6 of 100 users Rating 4.6 of 100 users (100)
Course CompTIA Data+: Data Analytics Tools
Rating 4.3 of 32 users Rating 4.3 of 32 users (32)