【SQL超入門講座】02.データベースのテーブルとは? — Transcript
Full transcript
- 0:02Hello, this is Kino Code. This video is
- 0:06the second part of the SQL introductory
- 0:08course. In the previous video, I
- 0:12explained what SQL and RDBMS are, how
- 0:14to set up the DB Browser environment,
- 0:16and how to open a database. In this
- 0:21video, I will explain database tables
- 0:23and we will take a look at an actual
- 0:25table. Besides this SQL introductory
- 0:30course, Kino Code also provides lessons
- 0:32on popular languages like Python, how
- 0:34to automate tasks with Python, stock
- 0:36analysis using Python, and artificial
- 0:39intelligence. If you haven't subscribed
- 0:43to the channel yet, please do so to
- 0:45receive notifications for new videos.
- 0:47Now, let's start the lesson. So, what
- 0:53is a table? Let me explain tables in
- 0:56the context of databases. A database is
- 1:00composed of multiple tables. What
- 1:03exactly is a table? A table is data
- 1:07organized in a specific, cohesive,
- 1:09tabular format. That might be a bit
- 1:12hard to understand on its own. To help
- 1:15deepen your understanding of tables,
- 1:17let's compare them to Excel. You can
- 1:22think of the database itself as an
- 1:23Excel workbook, meaning the Excel file
- 1:25itself. Excel files have worksheets
- 1:30where the actual text and numbers are
- 1:32entered, right? You can create multiple
- 1:39worksheets, and each sheet might
- 1:41contain things like sales data, product
- 1:43data, or customer data. In this analogy
- 1:49, what we call a worksheet in Excel is
- 1:51referred to as a table in a database.
- 1:55Sometimes tables are simply called "
- 1:57sheets" or "charts," but it's generally
- 1:59better to call them tables. Now, let's
- 2:01look at an example of a table. Let's
- 2:05take a look at an actual example of a
- 2:07table. To check a table in DB Browser,
- 2:11click on the "Database Structure" tab
- 2:13at the top. You will see a "Tables"
- 2:20section, and if you expand it, you can
- 2:22confirm there is a table called "
- 2:23teststore." Now, let's expand it one
- 2:28level further. It appears to contain
- 2:32IDs, sales dates, and employee IDs.
- 2:37There are also data types like the
- 2:39integer type for storing whole numbers,
- 2:41and the text type for storing strings,
- 2:43such as the sales date. Now, let's
- 2:47actually take a look at the table. To
- 2:51check the table, move one tab to the
- 2:52right and look at Data View. This is
- 2:56the data currently stored in the
- 2:58database table. This table contains
- 3:01sales data for each sales
- 3:03representative at an apparel company.
- 3:06Data in the vertical direction, or
- 3:08column direction, is called a column.
- 3:11Data in the horizontal direction is
- 3:13called a record. This data is organized
- 3:17so that information for each employee
- 3:19and each sales date is grouped as one
- 3:20record. For example, you can see that
- 3:26on January 4th, sales rep ID A023 sold
- 3:288 pairs of pants for a total of 56,000
- 3:31yen. As I mentioned, each row of data
- 3:36is called a record. And the columns are
- 3:39referred to as columns. Do you
- 3:41understand? Let's review one more time.
- 3:47Databases store various types of data,
- 3:49and a table is a group of data in a
- 3:51structured, tabular format. Data in the
- 3:56vertical direction, or the column, is
- 3:57called a column. Data in the horizontal
- 4:00direction, or the row, is called a
- 4:02record. This lesson on database tables
- 4:07may have been a bit dull. However, it
- 4:11is essential knowledge for the upcoming
- 4:13lessons, so please be sure to remember
- 4:15it. We will start writing actual SQL in
- 4:18the next lesson, so please look forward
- 4:20to it. That covers the explanation of
- 4:24tables. What did you think? When
- 4:27creating KinoCode videos, we focus on
- 4:29cutting out unnecessary parts to keep
- 4:31things simple while incorporating clean
- 4:33animations. If you enjoyed this, we
- 4:36will be releasing many more videos, so
- 4:38please subscribe to our channel. See
- 4:41you in the next video.
About this transcript
This page contains the full transcript of 【SQL超入門講座】02.データベースのテーブルとは? by キノコード / AI・プログラミング学習チャンネル, generated from the public captions YouTube serves with the video. The transcript has 629 words across 94 segments, with the original timestamps preserved so you can click any line to jump to that moment in the embedded player.
What you can do with it
Use the transcript to take notes, quote the speaker, build a study guide, generate a summary with ChatGPT or Claude via the YouTube Summary tool, or export it as a timed subtitle file with YouTube to SRT. You can also re-open it in the transcriber to choose a caption track available on the video.
Free YouTube transcript tool
YouTube2Text is a free YouTube transcript generator — no signup, no daily limit. Paste any YouTube link and get the full transcript instantly, with timestamps, click-to-jump, caption language selection, AI prompts for ChatGPT, Claude, and Gemini, and exports to TXT, SRT, VTT, or Markdown.