{"id":303,"date":"2019-02-06T06:18:17","date_gmt":"2019-02-06T06:18:17","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=303"},"modified":"2020-05-01T12:29:12","modified_gmt":"2020-05-01T12:29:12","slug":"aws-database-primer","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/aws-certified-solutions-architect-associate-table-of-content\/aws-database-primer\/","title":{"rendered":"AWS Database Primer"},"content":{"rendered":"\n<ul class=\"wp-block-list\"><li>every application depends on a database<\/li><li>it store crucial data and records for its users.<\/li><li>Database engine permits application to access, manage, and search large volumes of data records<\/li><li>database is crucial to meet demands of performance, availability and recoverability for system.<\/li><li>Database systems and engines are broadly grouped into two namely \u2013\n<ul>\n<li>Relational Database Management Systems (RDBMS) and NoSQL (or non-relational) databases<\/li>\n<\/ul>\n<\/li><li>Relational Databases &#8211;\n<ul>\n<li>most common type of database used<\/li>\n<\/ul>\n<ul>\n<li>It offers common interface for users to read and write from database using commands or queries written in SQL<\/li>\n<\/ul>\n<ul>\n<li>It consists of one or more tables, such that a table consists of columns and rows like a spreadsheet.<\/li>\n<\/ul>\n<ul>\n<li>database column contains a specific attribute of the record, like name, address, and telephone number,<\/li>\n<\/ul>\n<ul>\n<li>each attribute is assigned a data type such as text, number, or date,<\/li>\n<\/ul>\n<ul>\n<li>popularly used relational database software are\n<ul>\n<li>MySQL<\/li>\n<\/ul>\n<ul>\n<li>PostgreSQL<\/li>\n<\/ul>\n<ul>\n<li>Microsoft SQL Server<\/li>\n<\/ul>\n<ul>\n<li>Oracle<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li><li>Further categorized as OLTP and OLAP database system, based on how tables are organized and application uses relational database.<\/li><li>Online Transaction Processing (OLTP) \u2013transaction oriented applications with frequent writing and changing data like data entry and e-commerce.<\/li><li>Online Analytical Processing (OLAP) \u2013pertains to reporting or analyzing large data sets.<\/li><li>Data Warehouses\n<ul>\n<li>central repository for data, coming from multiple sources.<\/li>\n<\/ul>\n<ul>\n<li>often referred as a specialized type of relational database<\/li>\n<\/ul>\n<ul>\n<li>used for reporting and analysis through OLAP.<\/li>\n<\/ul>\n<ul>\n<li>use to compile reports and search the database using highly complex queries.<\/li>\n<\/ul>\n<ul>\n<li>They are updated on a batch schedule multiple times per day or per hour,<\/li>\n<\/ul>\n<\/li><li>NoSQL Databases\n<ul>\n<li>have gained popularity<\/li>\n<\/ul>\n<ul>\n<li>are often simpler to use, flexible, and achieve high performance levels<\/li>\n<\/ul>\n<ul>\n<li>relational databases are complex to scale beyond a single server<\/li>\n<\/ul>\n<ul>\n<li>NoSQL architecture permits for horizontal scalability on commodity hardware.<\/li>\n<\/ul>\n<ul>\n<li>are non-relational<\/li>\n<\/ul>\n<ul>\n<li>do not have same table and column semantics of a relational database.<\/li>\n<\/ul>\n<ul>\n<li>are often key\/value stores or document stores with flexible schemas evolving over time or vary.<\/li>\n<li>AWS has a managed service like DynamoDB for building distributed cluster spanning multiple data centers.<\/li>\n<\/ul>\n<\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>every application depends on a database it store crucial data and records for its users. Database engine permits application to access, manage, and search large volumes of data records database is crucial to meet demands of performance, availability and recoverability for system. Database systems and engines are broadly grouped into two namely \u2013 Relational Database&#8230;<\/p>\n","protected":false},"author":1,"featured_media":305,"parent":53,"menu_order":20,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[],"tags":[13,14,5],"class_list":["post-303","page","type-page","status-publish","has-post-thumbnail","hentry","tag-aws-certified-solutions-architect-professional","tag-aws-exam-dumps","tag-aws-solutions-architect"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>AWS AWS Database Primer - Testprep Training Tutorials<\/title>\n<meta name=\"description\" content=\"Pass test with 100% gurantee - Learn Database Primer and enrich your profile. Practice thousand of test to become AWS Solutions Architect - Asociate Now!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.testpreptraining.ai\/tutorial\/aws-certified-solutions-architect-associate-table-of-content\/aws-database-primer\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"AWS AWS Database Primer - Testprep Training Tutorials\" \/>\n<meta property=\"og:description\" content=\"Pass test with 100% gurantee - Learn Database Primer and enrich your profile. Practice thousand of test to become AWS Solutions Architect - Asociate Now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/aws-certified-solutions-architect-associate-table-of-content\/aws-database-primer\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2020-05-01T12:29:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2019\/02\/AWS-Database-Primer.png\" \/>\n\t<meta property=\"og:image:width\" content=\"853\" \/>\n\t<meta property=\"og:image:height\" content=\"398\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/aws-certified-solutions-architect-associate-table-of-content\/aws-database-primer\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/aws-certified-solutions-architect-associate-table-of-content\/aws-database-primer\/\",\"name\":\"AWS AWS Database Primer - Testprep Training Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2019-02-06T06:18:17+00:00\",\"dateModified\":\"2020-05-01T12:29:12+00:00\",\"description\":\"Pass test with 100% gurantee - Learn Database Primer and enrich your profile. Practice thousand of test to become AWS Solutions Architect - Asociate Now!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/aws-certified-solutions-architect-associate-table-of-content\/aws-database-primer\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/aws-certified-solutions-architect-associate-table-of-content\/aws-database-primer\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/aws-certified-solutions-architect-associate-table-of-content\/aws-database-primer\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"AWS Certified Solutions Architect Associate (SAA-C03)\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/aws-certified-solutions-architect-associate-table-of-content\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"AWS Database Primer\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"name\":\"Testprep Training Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\",\"name\":\"Testprep Training\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"contentUrl\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"width\":583,\"height\":153,\"caption\":\"Testprep Training\"},\"image\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"AWS AWS Database Primer - Testprep Training Tutorials","description":"Pass test with 100% gurantee - Learn Database Primer and enrich your profile. Practice thousand of test to become AWS Solutions Architect - Asociate Now!","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:\/\/www.testpreptraining.ai\/tutorial\/aws-certified-solutions-architect-associate-table-of-content\/aws-database-primer\/","og_locale":"en_US","og_type":"article","og_title":"AWS AWS Database Primer - Testprep Training Tutorials","og_description":"Pass test with 100% gurantee - Learn Database Primer and enrich your profile. Practice thousand of test to become AWS Solutions Architect - Asociate Now!","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/aws-certified-solutions-architect-associate-table-of-content\/aws-database-primer\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2020-05-01T12:29:12+00:00","og_image":[{"width":853,"height":398,"url":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2019\/02\/AWS-Database-Primer.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/aws-certified-solutions-architect-associate-table-of-content\/aws-database-primer\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/aws-certified-solutions-architect-associate-table-of-content\/aws-database-primer\/","name":"AWS AWS Database Primer - Testprep Training Tutorials","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2019-02-06T06:18:17+00:00","dateModified":"2020-05-01T12:29:12+00:00","description":"Pass test with 100% gurantee - Learn Database Primer and enrich your profile. Practice thousand of test to become AWS Solutions Architect - Asociate Now!","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/aws-certified-solutions-architect-associate-table-of-content\/aws-database-primer\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/aws-certified-solutions-architect-associate-table-of-content\/aws-database-primer\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/aws-certified-solutions-architect-associate-table-of-content\/aws-database-primer\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"AWS Certified Solutions Architect Associate (SAA-C03)","item":"https:\/\/www.testpreptraining.ai\/tutorial\/aws-certified-solutions-architect-associate-table-of-content\/"},{"@type":"ListItem","position":3,"name":"AWS Database Primer"}]},{"@type":"WebSite","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","name":"Testprep Training Tutorials","description":"","publisher":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization","name":"Testprep Training","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","contentUrl":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","width":583,"height":153,"caption":"Testprep Training"},"image":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/303","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/comments?post=303"}],"version-history":[{"count":7,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/303\/revisions"}],"predecessor-version":[{"id":5167,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/303\/revisions\/5167"}],"up":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/53"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media\/305"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=303"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=303"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=303"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}