{"id":1627,"date":"2023-09-26T10:35:03","date_gmt":"2023-09-26T14:35:03","guid":{"rendered":"https:\/\/community.mis.temple.edu\/professionalachievement\/?post_type=tribe_events&#038;p=1627"},"modified":"2023-09-26T10:35:03","modified_gmt":"2023-09-26T14:35:03","slug":"introduction-to-sql","status":"publish","type":"tribe_events","link":"https:\/\/community.mis.temple.edu\/professionalachievement\/event\/introduction-to-sql\/","title":{"rendered":"Introduction to SQL"},"content":{"rendered":"<p>The presentation is designed for students who want to learn to write SQL statements for data analysis.<\/p>\n<p><strong>Topics:<\/strong><\/p>\n<ul>\n<li>Relational Database Basics<\/li>\n<li>Relationships<\/li>\n<li>Datatypes<\/li>\n<li>Primary &amp; Foreign Keys<\/li>\n<li>Introduction to SQL Statements<\/li>\n<li>Database Manipulation Language (DML)<\/li>\n<li>SELECTing All Columns and Rows<\/li>\n<li>SELECTing Specific Columns or Rows<\/li>\n<li>Using the WHERE Clause and Operator Symbols<\/li>\n<li>Checking for a NULL value<\/li>\n<li>Using BETWEEN, IN, LIKE and NOT Operator<\/li>\n<li>Checking Multiple Conditions using AND and OR<\/li>\n<li>Using Common Math Functions<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>The presentation is designed for students who want to learn to write SQL statements for data analysis. Topics: Relational Database Basics Relationships Datatypes Primary &amp; Foreign Keys Introduction to SQL [&hellip;]<\/p>\n","protected":false},"author":26738,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","jetpack_post_was_ever_published":false,"_tribe_events_status":"","_tribe_events_status_reason":"","footnotes":""},"tags":[],"tribe_events_cat":[776368,776371],"class_list":["post-1627","tribe_events","type-tribe_events","status-publish","tribe_events_cat-25-points","tribe_events_cat-event","cat_25-points","cat_event","entry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/community.mis.temple.edu\/professionalachievement\/wp-json\/wp\/v2\/tribe_events\/1627","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/community.mis.temple.edu\/professionalachievement\/wp-json\/wp\/v2\/tribe_events"}],"about":[{"href":"https:\/\/community.mis.temple.edu\/professionalachievement\/wp-json\/wp\/v2\/types\/tribe_events"}],"author":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/professionalachievement\/wp-json\/wp\/v2\/users\/26738"}],"replies":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/professionalachievement\/wp-json\/wp\/v2\/comments?post=1627"}],"version-history":[{"count":1,"href":"https:\/\/community.mis.temple.edu\/professionalachievement\/wp-json\/wp\/v2\/tribe_events\/1627\/revisions"}],"predecessor-version":[{"id":1628,"href":"https:\/\/community.mis.temple.edu\/professionalachievement\/wp-json\/wp\/v2\/tribe_events\/1627\/revisions\/1628"}],"wp:attachment":[{"href":"https:\/\/community.mis.temple.edu\/professionalachievement\/wp-json\/wp\/v2\/media?parent=1627"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/community.mis.temple.edu\/professionalachievement\/wp-json\/wp\/v2\/tags?post=1627"},{"taxonomy":"tribe_events_cat","embeddable":true,"href":"https:\/\/community.mis.temple.edu\/professionalachievement\/wp-json\/wp\/v2\/tribe_events_cat?post=1627"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}