CompTIA IT Fundamentals: Database Concepts

CompTIA    |    Beginner
  • 19 videos | 2h 9m 22s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 29 users Rating 4.7 of 29 users (29)
Computers require hardware and software to operate, but they also rely on data to be truly useful. Data comes in many forms and is an invaluable commodity in today's world. In order to make data useful, we use databases. In this course, you will learn about the basics of databases, beginning with what they are and how they're structured. Then you will dig into the common types of databases, database records, and basic database creation. Finally, you will explore database management systems, data manipulation and access methods, dumps and backups, and how to import and export databases. This course helps prepare learners for the CompTIA IT Fundamentals (ITF+) certification exam, FC0-U61.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Provide an overview of databases and how they are used
    Provide an overview of database structure or schema, including structured vs. semi-structured vs. unstructured databases
    Identify the role and features of relational databases
    Recognize the role and features of nosql databases
    Compare and contrast flat files and databases
    Outline the role and features of database records
    Use microsoft excel to create a basic database
    Perform basic database operations
    Identify the role and features of a dbms
  • Provide an overview of database storage and data persistence
    Outline the various methods for data manipulation
    Perform basic data manipulation methods
    Perform basic data definition methods
    Perform basic data control methods
    Outline various database access methods
    Provide an overview of database dumps and backups
    Export and import databases
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 5s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 10m 56s
    After completing this video, you will be able to provide an overview of databases and how they are used. FREE ACCESS
  • Locked
    3.  Database Structure
    6m 38s
    Upon completion of this video, you will be able to provide an overview of database structure or schema, including structured vs. semi-structured vs. unstructured databases. FREE ACCESS
  • Locked
    4.  Relational Databases
    10m 5s
    After completing this video, you will be able to identify the role and features of relational databases. FREE ACCESS
  • Locked
    5.  Non-relational (NoSQL) Databases
    4m 58s
    Upon completion of this video, you will be able to recognize the role and features of NoSQL databases. FREE ACCESS
  • Locked
    6.  Flat Files vs. Databases
    7m 36s
    After completing this video, you will be able to compare and contrast flat files and databases. FREE ACCESS
  • Locked
    7.  Database Records
    4m 34s
    Upon completion of this video, you will be able to outline the role and features of database records. FREE ACCESS
  • Locked
    8.  Using Excel to Create Databases
    6m 8s
    Find out how to use Microsoft Excel to create a basic database. FREE ACCESS
  • Locked
    9.  Performing Database Operations
    6m 35s
    In this video, discover how to perform basic database operations. FREE ACCESS
  • Locked
    10.  Database Management System (DBMS)
    5m 47s
    After completing this video, you will be able to identify the role and features of a DBMS. FREE ACCESS
  • Locked
    11.  Database Storage and Persistence
    9m 8s
    Upon completion of this video, you will be able to provide an overview of database storage and data persistence. FREE ACCESS
  • Locked
    12.  Data Manipulation
    7m 5s
    After completing this video, you will be able to outline the various methods for data manipulation. FREE ACCESS
  • Locked
    13.  Using Data Manipulation Methods
    11m 4s
    Discover how to perform basic data manipulation methods. FREE ACCESS
  • Locked
    14.  Using Data Definition Methods
    7m 27s
    In this video, find out how to perform basic data definition methods. FREE ACCESS
  • Locked
    15.  Using Data Control Methods
    6m 24s
    During this video, discover how to perform basic data control methods. FREE ACCESS
  • Locked
    16.  Database Access Methods
    5m 8s
    After completing this video, you will be able to outline various database access methods. FREE ACCESS
  • Locked
    17.  Database Dumps and Backups
    6m 36s
    After completing this video, you will be able to provide an overview of database dumps and backups. FREE ACCESS
  • Locked
    18.  Exporting and Importing Databases
    11m 11s
    Find out how to export and import databases. FREE ACCESS
  • Locked
    19.  Course Summary
    57s
    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 Linux+: Software Management
Rating 4.3 of 15 users Rating 4.3 of 15 users (15)
Course CompTIA IT Fundamentals: Operating Systems
Rating 4.8 of 52 users Rating 4.8 of 52 users (52)
Course CompTIA IT Fundamentals: Data, CPUs, & Troubleshooting
Rating 4.8 of 66 users Rating 4.8 of 66 users (66)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course CompTIA IT Fundamentals: Data, CPUs, & Troubleshooting
Rating 4.8 of 66 users Rating 4.8 of 66 users (66)
Course CompTIA IT Fundamentals: Operating Systems
Rating 4.8 of 52 users Rating 4.8 of 52 users (52)
Course CompTIA IT Fundamentals: Networking & Wireless Technologies
Rating 4.7 of 51 users Rating 4.7 of 51 users (51)