Read the Tables — TechKnowSurge

About this interactive

From the lesson: - A database server hosts databases, a database holds tables, and a table holds records. - A table has columns (in the lesson: employee ID, last name, first name, work phone), and each row is one record, here one employee. - In a relational database the tables relate to each other. The lesson's example is a customers table and a table of what they buy, put together for every sale. In these items each sale carries the customer's ID, which is how the two tables relate: to find who made a sale, take its customer ID and find that row in the customers table. A query does the same thing for you, pulling the matching records. Type names and table names as they are written in the item. Capital letters do not matter to the checker.

What you'll learn

Read a database table: count its records (one per row) and its columns, and find a value in a record
Follow a relationship between two tables, customers and sales, to answer a question neither table answers alone, and say which table a new record goes in

Aligned to

CompTIA Tech+

5.2 Compare and contrast various database structures.

5.1 Explain database concepts and the purpose of a database.

5.3 Summarize methods used to interface with databases.

Key terms

Relational Database: A database structure that organizes data into interconnected tables whose records share defined relationships with one another.
Database Server: A server that hosts one or more databases, manages stored data, and provides access to that data for other machines or applications on a network.
Query: A command submitted to a database server to retrieve, filter, or manipulate stored data.

Topics

Database Relational Database Tables Records Query Interactive Fill In

About TechKnowSurge

TechKnowSurge builds IT and cybersecurity professionals through hands-on, concept-first training built around real understanding — not memorization. Free interactive tools, structured programs, and 25+ years of real-world experience, all in one place.

Explore free tools and programs →