Free
Course

CompTIA IT Fundamentals: Database Concepts

Understand DBMS intricacies, gain proficiency in data manipulation, storage, and data backup. Learn backup strategies and import/export for ITF+ certification.

Start

  • Skill level

    Beginner

  • Time to complete

    Approx. 2 hours

  • Certificate of completion

    Yes

  • Prerequisites

    None

About this course

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.

Learning objectives

  • 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
Meet the creator of the course
Aaron Sampson
IT Trainer/Consultant
Aaron specializes in certification-level training, consulting, and production of instructional content. He began his IT career as an instructor pursuing his Microsoft certifications, and to this day, he continues to design, implement, and train professionals in the realm of Microsoft applications and services. With over 25 years of experience, Aaron has delivered training in a vast array of technologies within Microsoft’s back-end products, such as SQL Server, Exchange Server, and System Center. More recently, he has expanded into cloud solutions that include Microsoft Azure and Microsoft 365. Aaron’s credentials include Microsoft Certified Trainer, Solutions Associate, IT Professional, and Solutions Expert. When he’s not at work, you can find Aaron on the golf course or playing his guitar.

How it works

Expert-led videos

In this course, you'll watch videos created by industry-leading experts for some of the biggest tech companies in the world. They'll cover key concepts, go through sample applications, prepare you for industry certifications, and more. Watch on any device — whenever and wherever you want — to learn at your own pace.
Start

Reviews from learners

  • Very well put together as usual. I learn so much from each experience with Codecademy. I can't explain how satisfied I am with this institution.
    David W
    Verified Learner
  • Everything Codecademy offers is useful for all software developers.
    Fidan M
    Verified Learner
  • I thought that I would never be able to learn to code but Codecademy has made it very easy. I just love it!
    Adyan H
    Verified Learner

Our learners work at

  • Google Logo
  • Meta Logo
  • Apple Logo
  • EA Logo
  • Amazon Logo
  • IBM Logo
  • Microsoft Logo
  • Reddit Logo
  • Spotify Logo
  • Uber Logo
  • YouTube Logo
  • Instagram Logo

3 Differences Between SQL & NoSQL That All Devs Should Know About

Cory Stieg
Sep 7, 2022

Ask a developer to explain the difference between SQL and NoSQL databases, and they’ll probably launch into a high-level conversation about the characteristics of relational and non-relational databases. And while that is the most notable difference between the databases, you might still be wondering what exactly that means for you.

At some point in your coding journey, you’ll need to learn to use a database, explains David Patlut, Curriculum Manager at Codecademy. “Anybody who’s getting into programming is going to run into using a database, because you have to persist [keep] data on any kind of application that you build,” he says.

Continue reading

Join over 50 million learners and start CompTIA IT Fundamentals: Database Concepts today!

Start

Looking for something else?

Related courses and paths

Browse more topics

View full catalog

Unlock additional features with a paid plan

  • Portfolio projects

    Create professional projects you can share with recruiters to showcase your skills and experience.

  • Job-readiness checker

    Evaluate how well you meet the requirements for any job description based on your skills and experience.

  • Certificate of completion

    Earn a document you can share with your network to prove that you’ve completed this course.
See pricing and plans