{"id":18713,"date":"2020-06-30T13:24:54","date_gmt":"2020-06-30T20:24:54","guid":{"rendered":"https:\/\/careerkarma.com\/blog\/?p=18713"},"modified":"2023-12-01T03:37:17","modified_gmt":"2023-12-01T11:37:17","slug":"relational-database","status":"publish","type":"post","link":"https:\/\/careerkarma.com\/blog\/relational-database\/","title":{"rendered":"What is a Relational Database?"},"content":{"rendered":"\n<p>You\u2019ve probably come across the term <code>database<\/code> at some point in your life. Databases are a set of data that is stored on a computer.<br><\/p>\n\n\n\n<p>Hospitals use databases to track the treatments they administer; accountancy firms use databases to keep track of accounting records; and web applications use databases to keep a list of their users and content for their platform.<br><\/p>\n\n\n\n<p>But what about relational databases? How do they work? What\u2019s the difference between a database and a relational database?&nbsp;<br><\/p>\n\n\n\n<p>Those are all good questions and in this guide, we\u2019re going to break down the basics of relational databases and how they work.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-what-is-a-database\">What is a Database?<\/h2>\n\n\n\n<p>Databases allow you to store data on a computer. In a database, data is stored using tables. Tables are like the blueprint for storing a particular type of data. Each table has a set of columns which define what data can be stored in a database.<br><\/p>\n\n\n\n<p>Within each table you can store records which are individual entries in your database. Each value in a record should correspond with the columns in the table.<br><\/p>\n\n\n\n<p>Here\u2019s an example of a database:<br><\/p>\n\n\n\n<figure class=\"wp-block-table course-info-table\"><table><tbody><tr><td><strong>Post<\/strong><\/td><\/tr><tr><td>id<\/td><td>title<\/td><td>text<\/td><td>meta<\/td><\/tr><tr><td>1<\/td><td>What is a Relational Database?<\/td><td>This is a blog post.<\/td><td>This is the meta description.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>In this table, our database contains four columns. These are: id, title, text and meta. The title, text and meta columns store strings. The id column stores an integer which we can use to uniquely identify each post.<br><\/p>\n\n\n\n<p>Our database contains one record. This record stores data about the blog post with the title \u201cWhat is a Relational Database?\u201d.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-what-is-a-relational-database\">What is a Relational Database?<\/h2>\n\n\n\n<p>A relational database is a special type of database. It allows you to access data in relation to other pieces of data in the database.<br><\/p>\n\n\n\n<p>Data in relational databases is stored using rows and columns. Rows, or \u201crecords\u201d, are individual entries in the database, and tables. Tables store the structure of a particular type of data. In a relational database, tables can be linked \u2013 related \u2013 to each other. This allows you to create connections between similar data points in the database.<br><\/p>\n\n\n\n<p>Suppose you are creating a database for a blog. You want your database to store two tables: the users who can sign in to your blog and a list of posts for your blog.<br><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/6_tp3PbrNK5G34Y28c3jOgV4L4ZW3pBucaRD5aQRRwUhANhqZLGYC3TORP7l9ebTTBIlFdVcArWveKCrb-hM-4snaVQCryvEUlhFy990OMWOzG1NwW5l9aSkGIAclAVEB6KA7ttS\" alt=\"\"\/><\/figure>\n\n\n\n<p>You may want to link these two tables together so every post on your blog is associated with the account of the user who created the blog post. This is made possible in relational databases. We\u2019ve illustrated this in the diagram above.<br><\/p>\n\n\n\n<p>In this diagram you can see there is a relation between our two database tables. Our \u201cUser\u201d table is connected to our \u201cPost\u201d table. When we create a post, we associate that post with a user using the \u201ccreatedBy\u201d field. This helps us keep track of who has created a database.<br><\/p>\n\n\n\n<p>In simple terms, relational databases are a way of organizing data.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-how-do-relations-work\">How do Relations Work?<\/h2>\n\n\n\n<p>Every row in a table is assigned a key, which is a unique identifier used to track that particular record. The keys that are associated with a record are called primary keys.<br><\/p>\n\n\n\n<p>When you want to create a link between two tables, you can reference that key in another table. This is called creating a foreign key. In our example above, each record in our \u201cUser\u201d table has a primary key. Each User value in our \u201cPost\u201d table has a foreign key.<br><\/p>\n\n\n\n<p>Think of it this way. Primary keys are stored in the <em>primary<\/em> place a piece of data is stored. Foreign keys are stored in another table and are used to reference data from a specific table.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-what-is-sql\">What is SQL?<\/h2>\n\n\n\n<p>Relational databases can be queried using the Structured Query Language, or SQL. This is a standard language that allows you to interact with databases. While the technology itself is old, almost every database runs on SQL. It makes it easy to join tables with just a few lines of code.<br><\/p>\n\n\n\n<p>SQL is not only useful for database developers. Using SQL, people who need to analyze data \u2013 such as marketers or salespeople \u2013 can gather information about the data stored in their database. For instance, a salesperson could use SQL to find out how many clients they have acquired in the past month.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-what-are-the-benefits-of-relational-databases\">What Are the Benefits of Relational Databases?<\/h2>\n\n\n\n<p>When databases were first used, every developer wanted to store data in their own way. This meant that you needed to spend a lot of time reading over a database schema to understand how a database was structured. Often, these databases were made based on inefficient structures because no standardized processes were used.<br><\/p>\n\n\n\n<p>Enter the relational database. The relational model is a standard way of storing data in a database. It makes it easy to create connections between data. These connections allow you to create links between meaningful information by joining tables together.<br><\/p>\n\n\n\n<p>In our diagram above, the main benefit of relational databases is clear. You can see the relationship between the \u201cPost\u201d and \u201cUser\u201d tables clearly. A User is the owner of a Post.<br><\/p>\n\n\n\n<p>There are a few other benefits to the relational model that you should know about.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-redundancy\">Redundancy<\/h3>\n\n\n\n<p>The relational model reduces data redundancy. Information for a single record appears in one place, rather than in multiple tables. In our example above, a User record is stored in the \u201cUser\u201d table. We don\u2019t have to repeat that data in our \u201cPost\u201d table; all we need to do is create a connection between the two.<br><\/p>\n\n\n\n<p>The reduced redundancy made possible by relational databases helps make data more consistent. When you update one record in a database, any value which is linked to that record will automatically see the new updates. If we updated a user\u2019s email address in our above example, such a change would be immediately known by all the Posts which the user created.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-flexibility\">Flexibility<\/h3>\n\n\n\n<p>The relational model gives you more flexibility over your applications. This is provided by SQL, which uses a language for creating tables called DDL, or Data Definition Language. This allows you to add columns, add tables, change relations and more.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-what-systems-use-relational-databases\">What Systems Use Relational Databases?<\/h2>\n\n\n\n<p>Relational databases have been implemented by a range of <a href=\"https:\/\/careerkarma.com\/blog\/learn-database-programming\/\">database programming<\/a> products. Most modern databases use SQL to process data or at the very least are capable of processing SQL.<br><\/p>\n\n\n\n<p>Most of the databases you\u2019ll encounter in small-scale applications are powered by SQL. Even larger applications use SQL and the relational model to store data.<br><\/p>\n\n\n\n<p>In technology, relational database systems have a longer name: a Relational Database Management System. Here are a few examples of these systems:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-postgresql\">PostgreSQL<\/h3>\n\n\n\n<p>PostgreSQL is an open-sourced SQL database. This means that it\u2019s not controlled by any company; it is maintained by a community of developers.<br><\/p>\n\n\n\n<p>PostgreSQL is commonly used for web application development. The system is easy to use and reliable. The system has also been in development for years which means there is an abundance of resources online about how to work with a PostgreSQL database.<br><\/p>\n\n\n\n<p>The drawback to a PostgreSQL database is that it is slower than other databases like MySQL, which we\u2019ll discuss below. It also doesn\u2019t have such a large developer community as some other database servers.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-mysql\">MySQL<\/h3>\n\n\n\n<p>MySQL is the most popular SQL database in the world. It is most commonly used in web application development, often alongside the PHP programming language.<br><\/p>\n\n\n\n<p>MySQL has been around since 1995 and there is a massive following of developers who have expertise using this database model. The system is also easy to use and inexpensive to set up. This makes it an ideal choice for applications of all sizes.<br><\/p>\n\n\n\n<p>MySQL is not as effective at scaling as some other database systems and it lacks a few advanced features that are present in systems like the Oracle Database.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-oracle-database\">Oracle Database<\/h3>\n\n\n\n<p>Oracle, the multinational computing company, owns a technology called Oracle Database. This is a relational database system for large applications.&nbsp;<br><\/p>\n\n\n\n<p>Unlike MySQL and PostgreSQL, Oracle Database is not open-sourced. This means that you can\u2019t spin up your own Oracle Database without a license.<br><\/p>\n\n\n\n<p>Oracle has been known to scale well. That\u2019s why it is used for applications such as banking, which have massive data querying and storage needs. The main drawback of using Oracle Database is that it\u2019s not open source which means that there are fewer people who know how to use the technology.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-sqlite\">SQLite<\/h3>\n\n\n\n<p>SQLite is an open-source database. It was designed to be as lightweight as possible. As a result, it can store an entire database in one file. This makes SQLite really good for small applications because you don&#8217;t need to spin up a larger database when you\u2019re only going to be storing a few tables.<br><\/p>\n\n\n\n<p>SQLite is commonly used for small web applications and in other applications such as MP3 players and cell phones.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-sql-server\">SQL Server<\/h3>\n\n\n\n<p>SQL Server is a relational database system owned by Microsoft. It\u2019s code is closed, which means that you can\u2019t spin up a database without having a license. Most of the users of SQL Server are enterprise customers.<br><\/p>\n\n\n\n<p>The SQL Server system can scale effectively. However, it can be expensive to operate an SQL server database at scale because you have to pay to use it when you pass a certain point.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-conclusion\">Conclusion<\/h2>\n\n\n\n<p>Relational databases store data in tables. Each table stores a set of columns which correspond to values in each database entry. Relational Database Management Systems are used to manage data in a relational database. There are a wide range of these services available, although the most common are: PostgreSQL, SQLite, MySQL, Oracle DB and SQL Server.<\/p>\n","protected":false},"excerpt":{"rendered":"You\u2019ve probably come across the term database at some point in your life. Databases are a set of data that is stored on a computer. Hospitals use databases to track the treatments they administer; accountancy firms use databases to keep track of accounting records; and web applications use databases to keep a list of their&hellip;","protected":false},"author":240,"featured_media":18714,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[18070],"tags":[],"class_list":{"0":"post-18713","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-software-engineering-skills"},"acf":{"post_sub_title":"","sprint_id":"","query_class":"What is a {technical term}","school_sft":"","parent_sft":"","school_privacy_policy":"","has_review":"","is_sponser_post":"","is_guest_post":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.4 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>What is a Relational Database?: A Complete Guide | Career Karma<\/title>\n<meta name=\"description\" content=\"Relational databases are a type of database that stores data in relation to other values. On Career Karma, learn how relational databases work.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/careerkarma.com\/blog\/relational-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is a Relational Database?\" \/>\n<meta property=\"og:description\" content=\"Relational databases are a type of database that stores data in relation to other values. On Career Karma, learn how relational databases work.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/careerkarma.com\/blog\/relational-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Career Karma\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/facebook.com\/careerkarmaapp\" \/>\n<meta property=\"article:published_time\" content=\"2020-06-30T20:24:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-01T11:37:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/06\/twitter-jankolario-lRoX0shwjUQ-unsplash.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1020\" \/>\n\t<meta property=\"og:image:height\" content=\"708\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"James Gallagher\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@career_karma\" \/>\n<meta name=\"twitter:site\" content=\"@career_karma\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"James Gallagher\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/relational-database\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/relational-database\\\/\"},\"author\":{\"name\":\"James Gallagher\",\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/#\\\/schema\\\/person\\\/e79364792443fbff794a144c67ec8e94\"},\"headline\":\"What is a Relational Database?\",\"datePublished\":\"2020-06-30T20:24:54+00:00\",\"dateModified\":\"2023-12-01T11:37:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/relational-database\\\/\"},\"wordCount\":1627,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/relational-database\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/twitter-jankolario-lRoX0shwjUQ-unsplash.jpg\",\"articleSection\":[\"Software Engineering\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/careerkarma.com\\\/blog\\\/relational-database\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/relational-database\\\/\",\"url\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/relational-database\\\/\",\"name\":\"What is a Relational Database?: A Complete Guide | Career Karma\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/relational-database\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/relational-database\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/twitter-jankolario-lRoX0shwjUQ-unsplash.jpg\",\"datePublished\":\"2020-06-30T20:24:54+00:00\",\"dateModified\":\"2023-12-01T11:37:17+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/#\\\/schema\\\/person\\\/e79364792443fbff794a144c67ec8e94\"},\"description\":\"Relational databases are a type of database that stores data in relation to other values. On Career Karma, learn how relational databases work.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/relational-database\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/careerkarma.com\\\/blog\\\/relational-database\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/relational-database\\\/#primaryimage\",\"url\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/twitter-jankolario-lRoX0shwjUQ-unsplash.jpg\",\"contentUrl\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/twitter-jankolario-lRoX0shwjUQ-unsplash.jpg\",\"width\":1020,\"height\":708},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/relational-database\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog\",\"item\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Software Engineering\",\"item\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/software-engineering-skills\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"What is a Relational Database?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/\",\"name\":\"Career Karma\",\"description\":\"Latest Coding Bootcamp News &amp; Career Hacks from Industry Insiders\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/#\\\/schema\\\/person\\\/e79364792443fbff794a144c67ec8e94\",\"name\":\"James Gallagher\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/james-gallagher-150x150.jpg\",\"url\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/james-gallagher-150x150.jpg\",\"contentUrl\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/james-gallagher-150x150.jpg\",\"caption\":\"James Gallagher\"},\"description\":\"James Gallagher is a self-taught programmer and the technical content manager at Career Karma. He has experience in range of programming languages and extensive expertise in Python, HTML, CSS, and JavaScript. James has written hundreds of programming tutorials, and he frequently contributes to publications like Codecademy, Treehouse, Repl.it, Afrotech, and others.\",\"url\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/author\\\/jamesgallagher\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"What is a Relational Database?: A Complete Guide | Career Karma","description":"Relational databases are a type of database that stores data in relation to other values. On Career Karma, learn how relational databases work.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/careerkarma.com\/blog\/relational-database\/","og_locale":"en_US","og_type":"article","og_title":"What is a Relational Database?","og_description":"Relational databases are a type of database that stores data in relation to other values. On Career Karma, learn how relational databases work.","og_url":"https:\/\/careerkarma.com\/blog\/relational-database\/","og_site_name":"Career Karma","article_publisher":"http:\/\/facebook.com\/careerkarmaapp","article_published_time":"2020-06-30T20:24:54+00:00","article_modified_time":"2023-12-01T11:37:17+00:00","og_image":[{"width":1020,"height":708,"url":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/06\/twitter-jankolario-lRoX0shwjUQ-unsplash.jpg","type":"image\/jpeg"}],"author":"James Gallagher","twitter_card":"summary_large_image","twitter_creator":"@career_karma","twitter_site":"@career_karma","twitter_misc":{"Written by":"James Gallagher","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/careerkarma.com\/blog\/relational-database\/#article","isPartOf":{"@id":"https:\/\/careerkarma.com\/blog\/relational-database\/"},"author":{"name":"James Gallagher","@id":"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94"},"headline":"What is a Relational Database?","datePublished":"2020-06-30T20:24:54+00:00","dateModified":"2023-12-01T11:37:17+00:00","mainEntityOfPage":{"@id":"https:\/\/careerkarma.com\/blog\/relational-database\/"},"wordCount":1627,"commentCount":0,"image":{"@id":"https:\/\/careerkarma.com\/blog\/relational-database\/#primaryimage"},"thumbnailUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/06\/twitter-jankolario-lRoX0shwjUQ-unsplash.jpg","articleSection":["Software Engineering"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/careerkarma.com\/blog\/relational-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/careerkarma.com\/blog\/relational-database\/","url":"https:\/\/careerkarma.com\/blog\/relational-database\/","name":"What is a Relational Database?: A Complete Guide | Career Karma","isPartOf":{"@id":"https:\/\/careerkarma.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/careerkarma.com\/blog\/relational-database\/#primaryimage"},"image":{"@id":"https:\/\/careerkarma.com\/blog\/relational-database\/#primaryimage"},"thumbnailUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/06\/twitter-jankolario-lRoX0shwjUQ-unsplash.jpg","datePublished":"2020-06-30T20:24:54+00:00","dateModified":"2023-12-01T11:37:17+00:00","author":{"@id":"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94"},"description":"Relational databases are a type of database that stores data in relation to other values. On Career Karma, learn how relational databases work.","breadcrumb":{"@id":"https:\/\/careerkarma.com\/blog\/relational-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/careerkarma.com\/blog\/relational-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/careerkarma.com\/blog\/relational-database\/#primaryimage","url":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/06\/twitter-jankolario-lRoX0shwjUQ-unsplash.jpg","contentUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/06\/twitter-jankolario-lRoX0shwjUQ-unsplash.jpg","width":1020,"height":708},{"@type":"BreadcrumbList","@id":"https:\/\/careerkarma.com\/blog\/relational-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog","item":"https:\/\/careerkarma.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Software Engineering","item":"https:\/\/careerkarma.com\/blog\/software-engineering-skills\/"},{"@type":"ListItem","position":3,"name":"What is a Relational Database?"}]},{"@type":"WebSite","@id":"https:\/\/careerkarma.com\/blog\/#website","url":"https:\/\/careerkarma.com\/blog\/","name":"Career Karma","description":"Latest Coding Bootcamp News &amp; Career Hacks from Industry Insiders","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/careerkarma.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94","name":"James Gallagher","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/01\/james-gallagher-150x150.jpg","url":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/01\/james-gallagher-150x150.jpg","contentUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/01\/james-gallagher-150x150.jpg","caption":"James Gallagher"},"description":"James Gallagher is a self-taught programmer and the technical content manager at Career Karma. He has experience in range of programming languages and extensive expertise in Python, HTML, CSS, and JavaScript. James has written hundreds of programming tutorials, and he frequently contributes to publications like Codecademy, Treehouse, Repl.it, Afrotech, and others.","url":"https:\/\/careerkarma.com\/blog\/author\/jamesgallagher\/"}]}},"_links":{"self":[{"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/posts\/18713","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/users\/240"}],"replies":[{"embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/comments?post=18713"}],"version-history":[{"count":0,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/posts\/18713\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/media\/18714"}],"wp:attachment":[{"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/media?parent=18713"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/categories?post=18713"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/tags?post=18713"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}