{"id":24,"date":"2024-09-26T16:16:05","date_gmt":"2024-09-26T20:16:05","guid":{"rendered":"https:\/\/community.mis.temple.edu\/evanlehman\/blog\/points\/learning-sql-programming\/"},"modified":"2024-09-26T16:16:05","modified_gmt":"2024-09-26T20:16:05","slug":"learning-sql-programming","status":"publish","type":"points","link":"https:\/\/community.mis.temple.edu\/evanlehman\/points\/learning-sql-programming\/","title":{"rendered":"Learning SQL Programming"},"content":{"rendered":"<p>Temple University sponsored this LinkedIn Learning session, where I watched the video and learned more about SQL programming along with 5 quizzes to test what I learned. This video taught me a lot of new things about SQL programming, as well as reinforced skills I previously learned. Some reinforced topics I learned more about were the JOIN commands (LEFT, RIGHT, INNER, OUTER, etc.); as well as math operations using integers, floats, and commands such as COUNT, SUM, and AVERAGE. Some completely new material learned was how to modify data in a table using the UPDATE, DELETE, and INSERT commands; also including how to transform data using the SUBSTR, CAST, and REPLACE commands.<\/p>\n","protected":false},"author":29285,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-24","points","type-points","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/community.mis.temple.edu\/evanlehman\/wp-json\/wp\/v2\/points\/24","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/community.mis.temple.edu\/evanlehman\/wp-json\/wp\/v2\/points"}],"about":[{"href":"https:\/\/community.mis.temple.edu\/evanlehman\/wp-json\/wp\/v2\/types\/points"}],"author":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/evanlehman\/wp-json\/wp\/v2\/users\/29285"}],"replies":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/evanlehman\/wp-json\/wp\/v2\/comments?post=24"}],"version-history":[{"count":0,"href":"https:\/\/community.mis.temple.edu\/evanlehman\/wp-json\/wp\/v2\/points\/24\/revisions"}],"wp:attachment":[{"href":"https:\/\/community.mis.temple.edu\/evanlehman\/wp-json\/wp\/v2\/media?parent=24"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}