Chapter 27

Summarize Methods Used to Interface with Databases

In this chapter, you learn about CompTIA IT Fundamentals+ Objective 5.3: Summarize methods used to interface with databases, including relational methods (data manipulation: select, insert, delete, update; data definition: create, alter, drop, permissions), database access methods (direct/manual access, programmatic access, user interface/utility access, query/report builders), and export/import (database dump, backup).

Foundational Topics

Relational Methods

Relational methods refer to how a relational database is created, used, and updated. Two major categories are discussed in this section:

  • Data manipulation

  • Data definition

Data Manipulation

Data manipulation refers to the ...

Get CompTIA IT Fundamentals+ FC0-U61 Cert Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.