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).
Relational methods refer to how a relational database is created, used, and updated. Two major categories are discussed in this section:
Data manipulation refers to the ...