The majority of this book covers how to read data from a database with SQL queries. Reading is one of the four basic database operations out of create, read, update, and delete (CRUD).
This chapter focuses on the remaining three operations for Databases, Tables, Indexes, and Views. In addition, the Transaction Management section covers how to execute multiple commands as a single unit.
Databases
A database is a place to store data in an organized way.
Within a database, you can create database objects, which are things that store or reference data. Common database objects include tables, constraints, indexes, and views.
A data model or a schema describes how database objects are organized within a database.
Figure 5-1 shows a database that contains many tables. The specifics around how the tables are defined (i.e., the Sales table contains five columns) and how they connect with one another (i.e., the customer_id column in the Sales table matches the customer_id column in the Customer table) are all a part of the schema of the database.
Figure 5-1. A database containing a star schema
The tables in Figure 5-1 are arranged in a star schema, which
is a basic way of organizing tables in a database. The star schema includes a fact table in the center and is surrounded by dimension tables (also known as lookup tables). The fact table records ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
