{"id":166641,"date":"2023-03-13T14:32:24","date_gmt":"2023-03-13T13:32:24","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=166641"},"modified":"2023-03-13T14:32:26","modified_gmt":"2023-03-13T13:32:26","slug":"database-what-is-it","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/database-what-is-it","title":{"rendered":"Database: what is it, and how does it work?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"166641\" class=\"elementor elementor-166641\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-cdbebef e-flex e-con-boxed e-con\" data-id=\"cdbebef\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-9501d4c elementor-widget elementor-widget-text-editor\" data-id=\"9501d4c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p><span style=\"font-weight: 400;\">Databases are used to store and manipulate data. Find out everything you need to know about it, and why you should start a <\/span><b>Data Management course<\/b><span style=\"font-weight: 400;\">.<\/span><\/p><p><span style=\"font-weight: 400;\">To understand what a database is, it is important to first understand what data is. Simply put, it is information that can be linked to any object. They can take many different forms: numbers, bytes, images, and text files&#8230;<\/span><\/p><p><span style=\"font-weight: 400;\">Thus, a database is an organized collection of <\/span><b>structured data<\/b><span style=\"font-weight: 400;\">. Usually stored electronically on a computer, it allows for easy access, management, manipulation, and updating of data. <\/span><b>Databases simplify data management<\/b><span style=\"font-weight: 400;\">.<\/span><\/p><p><span style=\"font-weight: 400;\">In other words, a database is a place where data is stored. It can be compared to a library, where the data would act as books.<\/span><\/p><p><span style=\"font-weight: 400;\">An example of this is an online telephone directory. Such a platform uses a database to <\/span><b>store data<\/b><span style=\"font-weight: 400;\"> about people, phone numbers, and other contact information.<\/span><\/p><p><span style=\"font-weight: 400;\">Typically, a database is controlled by a <\/span><b>DataBase Management System<\/b><span style=\"font-weight: 400;\"> (DBMS). The data, the DBMS, and the associated applications form a &#8220;database system&#8221; which is often abbreviated to &#8220;database&#8221;.<\/span><\/p><p><span style=\"font-weight: 400;\">In the most common types of databases, the data is <\/span><b>organized in rows and columns<\/b><span style=\"font-weight: 400;\"> in a series of tables. This format makes it easy to process the data and formulate queries. On most databases, queries are performed in SQL (Structured Query Language).<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d4e9d10 elementor-widget elementor-widget-spacer\" data-id=\"d4e9d10\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-column .elementor-spacer-inner{height:var(--spacer-size)}.e-con{--container-widget-width:100%}.e-con-inner>.elementor-widget-spacer,.e-con>.elementor-widget-spacer{width:var(--container-widget-width,var(--spacer-size));--align-self:var(--container-widget-align-self,initial);--flex-shrink:0}.e-con-inner>.elementor-widget-spacer>.elementor-widget-container,.e-con-inner>.elementor-widget-spacer>.elementor-widget-container>.elementor-spacer,.e-con>.elementor-widget-spacer>.elementor-widget-container,.e-con>.elementor-widget-spacer>.elementor-widget-container>.elementor-spacer{height:100%}.e-con-inner>.elementor-widget-spacer>.elementor-widget-container>.elementor-spacer>.elementor-spacer-inner,.e-con>.elementor-widget-spacer>.elementor-widget-container>.elementor-spacer>.elementor-spacer-inner{height:var(--container-widget-height,var(--spacer-size))}<\/style>\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-f021d1c e-flex e-con-boxed e-con\" data-id=\"f021d1c\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-1c7d1b7 elementor-widget elementor-widget-heading\" data-id=\"1c7d1b7\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h3 class=\"elementor-heading-title elementor-size-default\">What are the different types of databases?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2ccd8c1 elementor-widget elementor-widget-text-editor\" data-id=\"2ccd8c1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">There is a wide variety of databases. One of the most common is the <\/span><b>relational database<\/b><span style=\"font-weight: 400;\">, predominant since the 1980s. In it, data is organized in the form of a set of tables with columns and corridors.<\/span><\/p><p><span style=\"font-weight: 400;\">In <\/span><b>object-oriented databases<\/b><span style=\"font-weight: 400;\">, data is represented in the form of objects. In <\/span><b>distributed databases<\/b><span style=\"font-weight: 400;\">, two or more files located at different sites are brought together and the database can be stored on multiple computers distributed at different physical locations.<\/span><\/p><p><span style=\"font-weight: 400;\">A NoSQL or <\/span><span style=\"text-decoration: underline;\"><strong><a href=\"https:\/\/datascientest.com\/en\/all-about-non-relational-databases\">non-relational database<\/a><\/strong><\/span><span style=\"font-weight: 400;\"> allows the storage and manipulation of unstructured data. This type of database is gaining popularity with the rise of web applications.<\/span><\/p><p><span style=\"font-weight: 400;\">These are just a few examples, as there are many different types of databases. We can also mention <\/span><strong><span style=\"text-decoration: underline;\"><a href=\"https:\/\/datascientest.com\/en\/data-warehouse-2\">data warehouses<\/a><\/span><\/strong><span style=\"font-weight: 400;\">, OLTP databases, or even cloud databases.<\/span><\/p><p><span style=\"font-weight: 400;\">Some categories of databases are specifically designed for use in science, finance, or other sectors. Technological developments and advances, such as the Cloud or automation, are also giving rise to new types of databases.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-130a356 elementor-align-center button-principal elementor-widget elementor-widget-button\" data-id=\"130a356\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-md\" href=\"https:\/\/datascientest.com\/en\/data-management-course\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Learn to use DataBases<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b4c7af3 elementor-widget elementor-widget-text-editor\" data-id=\"b4c7af3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">A database consists of <\/span><b>five main components<\/b><span style=\"font-weight: 400;\">: hardware, software, data, procedure, and database access language.<\/span><\/p><p><span style=\"font-weight: 400;\">The <\/span><b>hardware<\/b><span style=\"font-weight: 400;\"> consists of electronic devices such as computers and storage systems. The software part is a set of programs used to manage and control the database.<\/span><\/p><p><span style=\"font-weight: 400;\">It includes the <\/span><b>database software<\/b><span style=\"font-weight: 400;\">, the operating system, the network software for sharing the data, and the applications that access the data.<\/span><\/p><p><span style=\"font-weight: 400;\">Data is the <\/span><b>raw information<\/b><span style=\"font-weight: 400;\"> that is stored in the database. It can be in a variety of formats, such as text, images, or video.<\/span><\/p><p><span style=\"font-weight: 400;\">The procedure is a set of rules and instructions for using the <\/span><b>DataBase Management System<\/b><span style=\"font-weight: 400;\"> (DBMS). Finally, the database access language is used to access the data, enter new data, update existing data, or retrieve it via queries.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8e8abc0 elementor-widget elementor-widget-spacer\" data-id=\"8e8abc0\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-0378c9d e-flex e-con-boxed e-con\" data-id=\"0378c9d\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-14ad7be elementor-widget elementor-widget-heading\" data-id=\"14ad7be\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">What is a DBMS?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9ff1c0d elementor-widget__width-initial elementor-widget elementor-widget-video\" data-id=\"9ff1c0d\" data-element_type=\"widget\" data-settings=\"{&quot;youtube_url&quot;:&quot;https:\\\/\\\/www.youtube.com\\\/watch?v=lDpB9zF8LBw&quot;,&quot;video_type&quot;:&quot;youtube&quot;,&quot;controls&quot;:&quot;yes&quot;}\" data-widget_type=\"video.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-video .elementor-widget-container{overflow:hidden;transform:translateZ(0)}.elementor-widget-video .elementor-wrapper{aspect-ratio:var(--video-aspect-ratio)}.elementor-widget-video .elementor-wrapper iframe,.elementor-widget-video .elementor-wrapper video{height:100%;width:100%;display:flex;border:none;background-color:#000}@supports not (aspect-ratio:1\/1){.elementor-widget-video .elementor-wrapper{position:relative;overflow:hidden;height:0;padding-bottom:calc(100% \/ var(--video-aspect-ratio))}.elementor-widget-video .elementor-wrapper iframe,.elementor-widget-video .elementor-wrapper video{position:absolute;top:0;right:0;bottom:0;left:0}}.elementor-widget-video .elementor-open-inline .elementor-custom-embed-image-overlay{position:absolute;top:0;right:0;bottom:0;left:0;background-size:cover;background-position:50%}.elementor-widget-video .elementor-custom-embed-image-overlay{cursor:pointer;text-align:center}.elementor-widget-video .elementor-custom-embed-image-overlay:hover .elementor-custom-embed-play i{opacity:1}.elementor-widget-video .elementor-custom-embed-image-overlay img{display:block;width:100%;aspect-ratio:var(--video-aspect-ratio);-o-object-fit:cover;object-fit:cover;-o-object-position:center center;object-position:center center}@supports not (aspect-ratio:1\/1){.elementor-widget-video .elementor-custom-embed-image-overlay{position:relative;overflow:hidden;height:0;padding-bottom:calc(100% \/ var(--video-aspect-ratio))}.elementor-widget-video .elementor-custom-embed-image-overlay img{position:absolute;top:0;right:0;bottom:0;left:0}}.elementor-widget-video .e-hosted-video .elementor-video{-o-object-fit:cover;object-fit:cover}.e-con-inner>.elementor-widget-video,.e-con>.elementor-widget-video{width:var(--container-widget-width);--flex-grow:var(--container-widget-flex-grow)}<\/style>\t\t<div class=\"elementor-wrapper elementor-open-inline\">\n\t\t\t<div class=\"elementor-video\"><\/div>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-427faa9 elementor-widget elementor-widget-spacer\" data-id=\"427faa9\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3896edd elementor-widget elementor-widget-text-editor\" data-id=\"3896edd\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">A DBMS is a <\/span><b>DataBase Management System<\/b><span style=\"font-weight: 400;\">. It is a set of programs that allow users to access databases, manipulate data, generate reports, and represent data. This system also helps control access to the database.<\/span><\/p><p><span style=\"font-weight: 400;\">It is the interface between the database and the <\/span><b>end users or programs<\/b><span style=\"font-weight: 400;\">. It also allows performance monitoring, backup, restore, or database configuration. Among the most popular examples are MySQL, Microsoft Access, Microsoft SQL Server, Oracle Database, FileMaker Pro, or dBase.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-53c79fd elementor-widget elementor-widget-spacer\" data-id=\"53c79fd\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-fee798d e-flex e-con-boxed e-con\" data-id=\"fee798d\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e6718c5 elementor-widget elementor-widget-heading\" data-id=\"e6718c5\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">What is SQL?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f05ca25 elementor-widget elementor-widget-text-editor\" data-id=\"f05ca25\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"text-decoration: underline;\"><strong><a href=\"https:\/\/datascientest.com\/en\/sql-learn-all-about-the-programming-language-for-databases\">Structured Query Language<\/a><\/strong><\/span><span style=\"font-weight: 400;\"> (SQL) is a programming language used by all relational databases to query, manipulate, and control access to data.<\/span><\/p><p><span style=\"font-weight: 400;\">Initially <\/span><b>developed by IBM<\/b><span style=\"font-weight: 400;\"> in the 1970s, this language is still the most widely used today. However, there are alternatives.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8d388b4 elementor-align-center button-principal elementor-widget elementor-widget-button\" data-id=\"8d388b4\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-md\" href=\"https:\/\/datascientest.com\/en\/data-management-course\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Learn SQL with DataScientest<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8abfc9b elementor-widget elementor-widget-spacer\" data-id=\"8abfc9b\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-f2d2365 e-flex e-con-boxed e-con\" data-id=\"f2d2365\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-9534591 elementor-widget elementor-widget-heading\" data-id=\"9534591\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">A Data Management course to learn database management<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c768506 elementor-widget elementor-widget-text-editor\" data-id=\"c768506\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Database management is essential for companies today. It is an essential element of data science and data analysis. If information is not organized in a database, it cannot be exploited.<\/span><\/p><p><span style=\"font-weight: 400;\">To take full advantage of <\/span><b>Big Data<\/b><span style=\"font-weight: 400;\">, you can train your employees in database management with <\/span><span style=\"text-decoration: underline;\"><strong><a href=\"https:\/\/datascientest.com\/en\/data-management-course\">our Data Management course<\/a><\/strong><\/span><span style=\"font-weight: 400;\">. This course allows you to learn how to manipulate databases with SQL and Python, but also to acquire solid notions of Data Quality and Data Visualization.<\/span><\/p><p><span style=\"font-weight: 400;\">This training is also available if you are a student or a professional in transition. As the French leader in Data Science training, DataScientest allows you to obtain a degree certified by <\/span><b>the Sorbonne<\/b><span style=\"font-weight: 400;\"> in only three months. For more information, see the complete presentation.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-25552ec elementor-align-center button-principal elementor-widget elementor-widget-button\" data-id=\"25552ec\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-md\" href=\"https:\/\/datascientest.com\/en\/data-management-course\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Start a training course in Data Management<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-10e60b6 e-flex e-con-boxed e-con\" data-id=\"10e60b6\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d02cd76 elementor-widget elementor-widget-html\" data-id=\"d02cd76\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\r\n{\r\n  \"@context\": \"https:\/\/schema.org\",\r\n  \"@type\": \"FAQPage\",\r\n  \"mainEntity\": [{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"What are the different types of databases?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"There is a wide variety of databases. One of the most common is the relational database, predominant since the 1980s. In it, data is organized in the form of a set of tables with columns and corridors. In object-oriented databases, data is represented in the form of objects. In distributed databases, two or more files located at different sites are brought together and the database can be stored on multiple computers distributed at different physical locations.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"What is a DBMS?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"A DBMS is a DataBase Management System. It is a set of programs that allow users to access databases, manipulate data, generate reports, and represent data. This system also helps control access to the database.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"What is SQL?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Structured Query Language (SQL) is a programming language used by all relational databases to query, manipulate, and control access to data. Initially developed by IBM in the 1970s, this language is still the most widely used today. However, there are alternatives.\"\r\n    }\r\n  }]\r\n}\r\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Databases are used to store and manipulate data. Find out everything you need to know about it, and why you should start a Data Management course. To understand what a database is, it is important to first understand what data is. Simply put, it is information that can be linked to any object. They can [&hellip;]<\/p>\n","protected":false},"author":63,"featured_media":166643,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2412],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Database: what is it, and how does it work?<\/title>\n<meta name=\"description\" content=\"Databases are used to store and manipulate data. Find out everything you need to know about it, and why you should start a Data Management course.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/en\/database-what-is-it\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Database: what is it, and how does it work?\" \/>\n<meta property=\"og:description\" content=\"Databases are used to store and manipulate data. Find out everything you need to know about it, and why you should start a Data Management course. To\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/database-what-is-it\" \/>\n<meta property=\"og:site_name\" content=\"Data Science Courses | DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-13T13:32:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-13T13:32:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2023\/02\/Database_what_is_it.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"768\" \/>\n\t<meta property=\"og:image:height\" content=\"421\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/en\/database-what-is-it#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/database-what-is-it\"},\"author\":{\"name\":\"\",\"@id\":\"\"},\"headline\":\"Database: what is it, and how does it work?\",\"datePublished\":\"2023-03-13T13:32:24+00:00\",\"dateModified\":\"2023-03-13T13:32:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/database-what-is-it\"},\"wordCount\":802,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Cloud &amp; Data Engineering\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/database-what-is-it#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/database-what-is-it\",\"url\":\"https:\/\/datascientest.com\/en\/database-what-is-it\",\"name\":\"Database: what is it, and how does it work?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2023-03-13T13:32:24+00:00\",\"dateModified\":\"2023-03-13T13:32:26+00:00\",\"description\":\"Databases are used to store and manipulate data. Find out everything you need to know about it, and why you should start a Data Management course.\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/database-what-is-it\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"Data Science Courses | DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"\",\"url\":\"https:\/\/datascientest.com\/en\/author\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Database: what is it, and how does it work?","description":"Databases are used to store and manipulate data. Find out everything you need to know about it, and why you should start a Data Management course.","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:\/\/datascientest.com\/en\/database-what-is-it","og_locale":"en_GB","og_type":"article","og_title":"Database: what is it, and how does it work?","og_description":"Databases are used to store and manipulate data. Find out everything you need to know about it, and why you should start a Data Management course. To","og_url":"https:\/\/datascientest.com\/en\/database-what-is-it","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2023-03-13T13:32:24+00:00","article_modified_time":"2023-03-13T13:32:26+00:00","og_image":[{"width":768,"height":421,"url":"https:\/\/datascientest.com\/en\/files\/2023\/02\/Database_what_is_it.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"","Estimated reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/database-what-is-it#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/database-what-is-it"},"author":{"name":"","@id":""},"headline":"Database: what is it, and how does it work?","datePublished":"2023-03-13T13:32:24+00:00","dateModified":"2023-03-13T13:32:26+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/database-what-is-it"},"wordCount":802,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Cloud &amp; Data Engineering"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/database-what-is-it#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/database-what-is-it","url":"https:\/\/datascientest.com\/en\/database-what-is-it","name":"Database: what is it, and how does it work?","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2023-03-13T13:32:24+00:00","dateModified":"2023-03-13T13:32:26+00:00","description":"Databases are used to store and manipulate data. Find out everything you need to know about it, and why you should start a Data Management course.","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/database-what-is-it"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"Data Science Courses | DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"","url":"https:\/\/datascientest.com\/en\/author"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/166641"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/63"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=166641"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/166641\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/166643"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=166641"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=166641"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=166641"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}