From the course: Microsoft SQL Server 2016: Query Data
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
An introduction to relational theory - SQL Server Tutorial
From the course: Microsoft SQL Server 2016: Query Data
An introduction to relational theory
- [Voiceover] In this lesson, we'll give you a brief introduction to Relational Theory. To be effective at querying a relational database management system, like Microsoft SQL Server, an understanding of relational theory goes a long way. The Relational Model is based on mathematical concepts. It includes considerations around set theory, predicate logic, and attributes. There are definitely more considerations, but those are ones that we don't need to be concerned with for this course. Set Theory is based on the concept of a set. A set is considered to be a collection of distinct objects. Examples might be the keys on your key ring, or the students in a classroom. Each item in a set is distinct, and the mathematical definition states that a set does not contain duplicates. A Predicate is considered an expression that evaluates to true or false when we apply it to objects. For example, stating that a specific car is blue when it is in fact red, results in a false statement. Predicate…
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.