{"id":74,"date":"2018-12-19T04:01:39","date_gmt":"2018-12-19T04:01:39","guid":{"rendered":"http:\/\/people.utm.my\/aiai\/?p=74"},"modified":"2018-12-19T04:01:39","modified_gmt":"2018-12-19T04:01:39","slug":"introduction-to-sql","status":"publish","type":"post","link":"https:\/\/people.utm.my\/aiai\/2018\/12\/19\/introduction-to-sql\/","title":{"rendered":"Introduction to SQL"},"content":{"rendered":"<p style=\"text-align: left\"><strong>Definition of a Relational Database<\/strong><br \/>\nA relational database is a collection of<br \/>\nrelations or two-dimensional tables.<\/p>\n<p style=\"text-align: left\"><strong>Relational Database Properties<\/strong><br \/>\nA relational database:<br \/>\n\uf046 Can be accessed and modified by executing<br \/>\nstructured query language (SQL) statements<br \/>\n\uf046 Contains a collection of tables with no<br \/>\nphysical pointers<br \/>\n\uf046 Uses a set of operators<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-75 size-full\" src=\"https:\/\/people.utm.my\/aiai\/wp-content\/uploads\/sites\/546\/2018\/12\/Sql1.png\" alt=\"\" width=\"1045\" height=\"702\" srcset=\"https:\/\/people.utm.my\/aiai\/wp-content\/uploads\/sites\/546\/2018\/12\/Sql1.png 1045w, https:\/\/people.utm.my\/aiai\/wp-content\/uploads\/sites\/546\/2018\/12\/Sql1-300x202.png 300w, https:\/\/people.utm.my\/aiai\/wp-content\/uploads\/sites\/546\/2018\/12\/Sql1-768x516.png 768w, https:\/\/people.utm.my\/aiai\/wp-content\/uploads\/sites\/546\/2018\/12\/Sql1-1024x688.png 1024w\" sizes=\"auto, (max-width: 1045px) 100vw, 1045px\" \/><\/p>\n<p><strong>FEATURES OF SQL<\/strong><br \/>\n\uf046 It processes sets of data as groups<br \/>\nrather than as individual units.<br \/>\n\uf046 It provides automatic navigation to the<br \/>\ndata.<br \/>\n\uf046 It uses statements that are complex and<br \/>\npowerful individually, and that therefore<br \/>\nstand alone.<br \/>\n\uf046 It is common language for all Relational<br \/>\nDatabase.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-76 size-full\" src=\"https:\/\/people.utm.my\/aiai\/wp-content\/uploads\/sites\/546\/2018\/12\/sql2.jpg\" alt=\"\" width=\"925\" height=\"667\" srcset=\"https:\/\/people.utm.my\/aiai\/wp-content\/uploads\/sites\/546\/2018\/12\/sql2.jpg 925w, https:\/\/people.utm.my\/aiai\/wp-content\/uploads\/sites\/546\/2018\/12\/sql2-300x216.jpg 300w, https:\/\/people.utm.my\/aiai\/wp-content\/uploads\/sites\/546\/2018\/12\/sql2-768x554.jpg 768w\" sizes=\"auto, (max-width: 925px) 100vw, 925px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-77 size-full\" src=\"https:\/\/people.utm.my\/aiai\/wp-content\/uploads\/sites\/546\/2018\/12\/sql3.jpg\" alt=\"\" width=\"949\" height=\"556\" srcset=\"https:\/\/people.utm.my\/aiai\/wp-content\/uploads\/sites\/546\/2018\/12\/sql3.jpg 949w, https:\/\/people.utm.my\/aiai\/wp-content\/uploads\/sites\/546\/2018\/12\/sql3-300x176.jpg 300w, https:\/\/people.utm.my\/aiai\/wp-content\/uploads\/sites\/546\/2018\/12\/sql3-768x450.jpg 768w\" sizes=\"auto, (max-width: 949px) 100vw, 949px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Definition of a Relational Database A relational database is a collection of relations or two-dimensional tables. Relational Database Properties A relational database: \uf046 Can be accessed and modified by executing structured query language (SQL) statements \uf046 Contains a collection of &hellip; <a href=\"https:\/\/people.utm.my\/aiai\/2018\/12\/19\/introduction-to-sql\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":120,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-74","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/people.utm.my\/aiai\/wp-json\/wp\/v2\/posts\/74","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/people.utm.my\/aiai\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/people.utm.my\/aiai\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/people.utm.my\/aiai\/wp-json\/wp\/v2\/users\/120"}],"replies":[{"embeddable":true,"href":"https:\/\/people.utm.my\/aiai\/wp-json\/wp\/v2\/comments?post=74"}],"version-history":[{"count":1,"href":"https:\/\/people.utm.my\/aiai\/wp-json\/wp\/v2\/posts\/74\/revisions"}],"predecessor-version":[{"id":78,"href":"https:\/\/people.utm.my\/aiai\/wp-json\/wp\/v2\/posts\/74\/revisions\/78"}],"wp:attachment":[{"href":"https:\/\/people.utm.my\/aiai\/wp-json\/wp\/v2\/media?parent=74"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/people.utm.my\/aiai\/wp-json\/wp\/v2\/categories?post=74"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/people.utm.my\/aiai\/wp-json\/wp\/v2\/tags?post=74"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}