From the course: Learning Relational Databases
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Relational structures
- [Instructor] At their core, all relational databases rely on storing data about the real world in a series of simple two-dimensional data tables. These tables are organized in to a series of cells, grouped in to horizontal rows and vertical columns, just like what you're probably used to from using Microsoft Excel or Apple Numbers. These rows and columns go by different names in different database systems, and it's not uncommon to hear people interchange them in conversation, but they all mean essentially the same thing. The vertical columns sometimes go by the names attributes, values, or fields, and they store a single piece of information such as the first name or the last name of the employees in your organization. The horizontal rows most commonly go by the name records, and every record is made up of a series of values stored in the intersecting columns. While every record in the table has an identical structure horizontally, each record represents a single entity such as an…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.