From the course: Complete Guide to T-SQL for Data Analysts by Microsoft Press

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Relational database concepts

Relational database concepts - SQL Tutorial

From the course: Complete Guide to T-SQL for Data Analysts by Microsoft Press

Start my 1-month free trial Buy for my team

Relational database concepts

“

- [Instructor] In this sub lesson, we are going to describe relational database concepts. So the goal of relational model is to enable a consistent representation of data with minimal or no redundancy without sacrificing completeness. This allows for the definition of data integrity rules as part of the model. Relational refers to a set of data, such as employees, and not relationship between the tables. So let's take a look at a bunch of the terminology that you're going to run into as you start working with the relational database management systems. So first off, we are going to see here that we have what is ultimately going to a table of data, which most people would know this by. But let's take a look at what relational theory would call this and what SQL itself would call this. So as mentioned a moment ago, most people would look at this and say, "I see a table of data." So in SQL, it's known as a table, but in…

Contents