From the course: MySQL Essential Training (2019)
Unlock this course with a free trial
Join today to access over 22,600 courses taught by industry experts.
Database organization - MySQL Tutorial
From the course: MySQL Essential Training (2019)
Database organization
- [Instructor] The purpose of a database is to organize your data, and to make it available in convenient forms. My SQL is a relational database. A relational database is organized in two dimensional tables comprised of rows and columns. A relational database has tables. It could have one table, or many tables. In this example the database has three tables, customer, item, and sale. A table has rows and columns. In this example, the customer table has three rows and six columns. The columns are named id, name, address, city, state, and zip. A row is like an individual record in a table. In fact, some will use the term record interchangeably with row. In this example, the highlighted row is the record for Mary Smith in the customer table. A column is like a field. And again, some will use the term field interchangeably with column. In this example, the highlighted column is named address and contains an address for each row in the table. Each row in a table has a unique key. The…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
A brief overview of SQL4m 39s
-
(Locked)
Database organization2m 58s
-
(Locked)
Selecting rows5m 32s
-
(Locked)
Selecting columns2m 26s
-
(Locked)
Counting rows2m 2s
-
(Locked)
Inserting data3m 14s
-
(Locked)
Updating data3m 56s
-
(Locked)
Deleting data4m 47s
-
(Locked)
Joining queries across tables4m 8s
-
(Locked)
Finding databases, tables, and columns1m 40s
-
-
-
-
-
-
-