{"id":795,"date":"2016-06-15T20:34:40","date_gmt":"2016-06-16T03:34:40","guid":{"rendered":"https:\/\/database.guide\/?p=795"},"modified":"2021-02-04T14:12:06","modified_gmt":"2021-02-04T04:12:06","slug":"database-tutorial","status":"publish","type":"post","link":"https:\/\/database.guide\/database-tutorial\/","title":{"rendered":"Database Tutorial"},"content":{"rendered":"<p>This database tutorial is for beginners. It explains basic concepts\u00a0and assumes no prior knowledge of databases.<\/p>\n<p>You don&#8217;t need to follow along &#8211; there aren&#8217;t any exercises. But there are plenty of\u00a0screenshots and a few diagrams. The purpose of the tutorial is to introduce you to the basic concepts of databases.<\/p>\n<p><!--more--><\/p>\n<p>This tutorial consists of\u00a0two\u00a0parts:<\/p>\n<h2><a href=\"https:\/\/database.guide\/database-tutorial-part-1-about-databases-creating-databases-tables\/\">Database Tutorial (Part 1) &#8211; About Databases, Creating Databases, Tables<\/a><\/h2>\n<p>This article covers\u00a0the following:<\/p>\n<ul>\n<li>What is a database?<\/li>\n<li>What is a Database Management System (DBMS)?<\/li>\n<li>Types of databases<\/li>\n<li>What does a relational database look like?<\/li>\n<li>Creating a database<\/li>\n<li>Creating tables<\/li>\n<li>Data types<\/li>\n<\/ul>\n<h2><a href=\"https:\/\/database.guide\/database-tutorial-part-2-relationships-adding-data-querying-databases\/\">Database Tutorial (Part 2) &#8211; Relationships,\u00a0Adding Data, Querying Databases<\/a><\/h2>\n<p>This article covers\u00a0the following:<\/p>\n<ul>\n<li>Relationships<\/li>\n<li>The different ways of\u00a0adding\u00a0data to\u00a0a database<\/li>\n<li>Querying a database<\/li>\n<\/ul>\n<p>A fast reader\u00a0could probably finish\u00a0this tutorial in 10 minutes. But take your time,\u00a0it&#8217;s important that you\u00a0understand the concepts presented, as they are fundamental concepts in the world of databases.<\/p>\n<p>Once\u00a0you&#8217;ve finished this tutorial, you can move on to a more specific database tutorial, such as the <a href=\"https:\/\/database.guide\/microsoft-access-tutorial\/\">Microsoft Access tutorial<\/a> or the <a href=\"https:\/\/database.guide\/sql-tutorial-for-beginners\/\">SQL tutorial<\/a>.<\/p>\n<p><!--more--><\/p>\n<h2><\/h2>\n<h2><\/h2>\n","protected":false},"excerpt":{"rendered":"<p>This database tutorial is for beginners. It explains basic concepts\u00a0and assumes no prior knowledge of databases. You don&#8217;t need to follow along &#8211; there aren&#8217;t any exercises. But there are plenty of\u00a0screenshots and a few diagrams. The purpose of the tutorial is to introduce you to the basic concepts of databases.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[11,19,33],"class_list":["post-795","post","type-post","status-publish","format-standard","hentry","category-database-concepts","tag-create-database","tag-relationships","tag-tutorial"],"_links":{"self":[{"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts\/795","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/comments?post=795"}],"version-history":[{"count":12,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts\/795\/revisions"}],"predecessor-version":[{"id":14622,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts\/795\/revisions\/14622"}],"wp:attachment":[{"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/media?parent=795"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/categories?post=795"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/tags?post=795"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}