Introducing the concept of "relational" databases.
[MUSIC] 0:00 In this modern competitive business environment, the companies that learn how 0:04 to use the mountains of data they've captured have a competitive advantage. 0:08 Knowledge is power and the databases are the foundation of that knowledge. 0:13 For the purposes of our SQL courses, 0:19 the databases that we've been using have been small, with only hundreds of rows. 0:21 In the real world, databases are very large, 0:27 having millions of rows in a single table. 0:30 These commonly used databases are called relational databases. 0:33 This term came about from structuring databases 0:38 in a way that tables are linked to each other by shared attributes. 0:41 These links are the relationships between tables. 0:46 As an organization's data needs grow, 0:49 they need a database that can grow and scale with them. 0:54 How a database schema is designed has a tremendous impact on the types of 0:58 reports that they can generate and the performance of that database. 1:03 There are many reasons why relational databases became the standard for 1:08 application data storage. 1:12 A few of which are eliminating redundant data reduces storage requirements on disk. 1:14 Well structured and properly segmented data can be accessed and modified quickly. 1:20 Bad data leads to bad reports. 1:26 Relational databases allow schema designers to enforce 1:29 good data principles which lead to better data quality and better reports. 1:32 If you imagine unstructured data in a poorly designed database schema, 1:37 it might look like this. 1:41 But if you picture organizing your data with a more thoughtful approach, 1:43 it might start to look like this. 1:48 This is what relational databases do, they organize data into related tables 1:51 that give context and meaning to the words and numbers contained within. 1:57 Hi, I'm Andrew, 2:02 a database user, a lifelong learner and teacher here at Treehouse. 2:03 In this course, we're going to be learning a lot about relational databases and 2:08 writing complex SQL queries and joining relational data together. 2:12 In the upcoming videos, 2:18 we'll be taking a look at the concepts that make relational databases work. 2:19 And start thinking about data in terms of sets 2:24 as opposed to individual values or rows. 2:28
You need to sign up for Treehouse in order to download course files.Sign up