What is a Table?
A free video tutorial from Oracle Master Training • 100,000+ Students Worldwide
Oracle Architect & Best Selling Instructor
4.5 instructor rating • 7 courses • 101,156 students
In this lecture, our students going to learn what a table is and why we need to use the tables.
Learn more from the full courseThe Complete Oracle SQL Bootcamp (2021)
Become an In-demand SQL Professional & Pass Oracle SQL 1Z0-071 (OCA) Certification Exam Confidently!
24:57:10 of on-demand video • Updated July 2021
- Pass Oracle 1Z0-071 SQL Database SQL Certification Exam easily on your first try!
- Be Able to Answer any SQL Interview Questions Confidently!
- Become a Job-Ready SQL Developer by Learning All the Skills You will Need!
- Learn Oracle SQL by Professionally Designed Content Step by Step!
- Write, Read and Analyze Any SQL Queries Easily and Learn How to Play with Data!
- Solve any SQL-related Problems by Yourself Creating Analytical Solutions!
- Test Your SQL Skills with Hundreds of Hands-on Examples, Quizzes, Challenges!
- Lifetime Support from the Instructors. Get a Well-Organized Recap Document!
English [Auto] Hi, in this lecture, you will learn what a table is and how we use the tables basically. As I have mentioned before, all the data is stored in the tables, in databases, if you used Excel spreadsheets, maybe you have already used a structure like that in it. But no, I will show you how that table looks like in the databases, of course, we will explain the tables based on the relational databases. Assume that we have the data of our employees in our database, how will we store that? Now let's see an example of a table and talk on that. The data is stored in tables with logical groups. For example, in this figure, this store, the data of the employees in our company, so all the data in this table are related to an employee. We don't have any information about the customers or products, etc. All the data is related to each other. If I want to store the product data, I store it in another table. All right. Here, as you can see in this figure, all the data is stored in cells in our tables. Each cell has only one data in it. As you can see, names, phone numbers, salaries, etc.. Presumably, we can assume in many sense like how we can do in Excel spreadsheets. Actually, this is not stored in the database like that, but it is shown to us like that. Of course, this is the logic of storing the data in tables. The union of all these horizontal cells is called as a record or a roll. A record or a roll includes all the information of a specific element. In here, since we store the employees, Arroyo has all the data of a specific employee, any other table will have another retainer role. All these vertical cells are called as columns. And Ken, how many different types of data but a column can have on the one specific type of data? For example, the first name column here can have only string type of data or higher death column can have only dates. For example, in here, you cannot add a number or string value to that column, so each column has a specific type of values. All the collection of these values are called as table. We can have as many tables as we wish in our database. As you can see in that figure, at tables, stores, the data in table form, this might be askew in some places, like job interviews or exams, etc. So you should know it. A database has so many different types of objects, of course, but the main object of databases are the tables, you will understand much better than the first query from our table and see our table later. So no need to go further for that for now. So this is the end of this structure. See, in the next lecture's.