Video description
- Discover the importance of the relational database model
- Become comfortable with the terminology used by database practitioners
- Work with the structure of relational databases
- Avoid data anomalies using normalization
Table of contents
- What Is SQL and Why Is It Important? 00:03:55
- SQL, An international Standard Database Language 00:03:55
- Why Data is Stored in Databases 00:02:18
- The Needle in a Haystack Problem 00:02:01
- The Structure of a Relational Database 00:02:16
- The Relational Model 00:02:16
- Nomenclature Confusion 00:02:53
- Functional Dependencies 00:02:26
- Keys 00:02:48
- Modification Anomalies 00:03:58
- Normalization 00:07:29
- The Components of a Data Processing Chain 00:02:31
- The Front End of the Chain 00:02:31
- The Back End of the Chain 00:03:30
- Designing a Database with Entity-Relationship Model 00:10:27
- A Database is a Model of a Physical or Conceptual System 00:10:27
- Converting an E-R Model into a Relational Model 00:03:01
- Business Rules and Constraints 00:04:37
Product information
- Title: Introducing SQL and Relational Databases
- Author(s):
- Release date: September 2018
- Publisher(s): Apress
- ISBN: 9781484238417
You might also like
video
Advanced Applied SQL for Business Intelligence and Analytics
Extend your knowledge of SQL, databases, and BI by mastering complex topics such as materialized views, …
video
Intermediate to Advanced SQL: Move Beyond the Basics to Master Complex Concepts
Learn the basics of creating, maintaining, protecting, and querying relational databases using SQL, the standard language …
video
Learning SQL
Almost 3 Hours of Video Instruction Description Learning SQL LiveLessons Skill Level Beginner Intermediate What You …
video
SQL Beginner to Guru: MySQL Edition - Master SQL with MySQL
SQL skills are in demand. Learn to master SQL using MySQL. Become a SQL Guru today! …