- Thriving in a Data-Driven World
- Understanding the Relational Database
- The Relational Database Continues to Lead the Way
- Examples and Exercises
- Summary
- Q&A
- Workshop
The Relational Database Continues to Lead the Way
The relational database has been the superior database choice for effectively managing data for several decades, and it continues to dominate the market share. This is true for many reasons:
▶ A well-designed relational database provides a simple, organized, easy-to-manage mechanism for data.
▶ A relational database is scalable as data grows and objects are added to the database.
▶ Linking data in multiple tables is easy.
▶ Maintaining the integrity of data is simple using built-in features such as referential integrity (primary and foreign key constraints).
▶ The overall management of data and use of SQL to communicate with the database is simplified.
▶ Relevant and useful data is easy to retrieve.
SQL and the relational database management system go hand in hand; you cannot have one without the other. SQL is an English-like language that enables you to create and manage a relational database and to then easily and effectively retrieve data from the database for a specific purpose.