{"id":5638,"date":"2023-03-28T22:11:30","date_gmt":"2023-03-28T19:11:30","guid":{"rendered":"http:\/\/professor.norton.net.br\/?p=5638"},"modified":"2023-03-28T22:11:30","modified_gmt":"2023-03-28T19:11:30","slug":"ams-bd-join","status":"publish","type":"post","link":"https:\/\/professor.norton.net.br\/index.php\/2023\/03\/28\/ams-bd-join\/","title":{"rendered":"AMS &#8211; BD &#8211; JOIN"},"content":{"rendered":"\n<p><a href=\"https:\/\/professor.norton.net.br\/wp-content\/uploads\/2021\/03\/lbd05.pptx\">Apresenta\u00e7\u00e3o<\/a><\/p>\n\n\n\n<p><strong>Exemplo<\/strong><\/p>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-aed46eaa-8b96-4c6f-b8c2-fe50e8eed40a\" href=\"https:\/\/professor.norton.net.br\/wp-content\/uploads\/2023\/03\/lbd05_exemplo.zip\">Exemplo<\/a><a href=\"https:\/\/professor.norton.net.br\/wp-content\/uploads\/2023\/03\/lbd05_exemplo.zip\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-aed46eaa-8b96-4c6f-b8c2-fe50e8eed40a\"><\/a><\/div>\n\n\n\n<p>Atividade<\/p>\n\n\n\n<p>1-Utilizando inner join extraia do banco de dados biblioteca&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>As reservas efetuadas pelos leitores exibindo o nome do leitor, nome da obra e data da reserva<\/li>\n\n\n\n<li>Os&nbsp;empr\u00e9stimos efetuados pelos leitores exibindo o nome do leitor, nome da obra, e c\u00f3digo da copia e nome do funcionarios<\/li>\n<\/ul>\n\n\n\n<p>2-Utilizando left outer join extraia do banco de dados biblioteca&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>os leitores que nunca fizeram reservas&nbsp;<\/li>\n\n\n\n<li>os leitores que nunca fizeram empr\u00e9stimos<\/li>\n\n\n\n<li>as obras que nunca foram emprestadas<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Apresenta\u00e7\u00e3o Exemplo Atividade 1-Utilizando inner join extraia do banco de dados biblioteca&nbsp; 2-Utilizando left outer join extraia do banco de dados biblioteca&nbsp;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-5638","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/professor.norton.net.br\/index.php\/wp-json\/wp\/v2\/posts\/5638","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/professor.norton.net.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/professor.norton.net.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/professor.norton.net.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/professor.norton.net.br\/index.php\/wp-json\/wp\/v2\/comments?post=5638"}],"version-history":[{"count":1,"href":"https:\/\/professor.norton.net.br\/index.php\/wp-json\/wp\/v2\/posts\/5638\/revisions"}],"predecessor-version":[{"id":5639,"href":"https:\/\/professor.norton.net.br\/index.php\/wp-json\/wp\/v2\/posts\/5638\/revisions\/5639"}],"wp:attachment":[{"href":"https:\/\/professor.norton.net.br\/index.php\/wp-json\/wp\/v2\/media?parent=5638"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/professor.norton.net.br\/index.php\/wp-json\/wp\/v2\/categories?post=5638"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/professor.norton.net.br\/index.php\/wp-json\/wp\/v2\/tags?post=5638"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}