{"id":1584,"date":"2015-09-05T19:10:43","date_gmt":"2015-09-06T00:10:43","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=1584"},"modified":"2015-09-05T19:10:43","modified_gmt":"2015-09-06T00:10:43","slug":"oca12c-1z0-061-additional-reading-05","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2015\/1584\/","title":{"rendered":"OCA12c \u2013 1Z0-061 \u2013 Additional Reading 05"},"content":{"rendered":"<p><strong>[Additional] Reading material for 1z0-061 Oracle Database 12c SQL Fundamentals test.<\/strong><\/p>\n<p><strong>Chapter 5: Using Joins and Subqueries<\/strong>\u00a0explains how data from multiple tables can be related via joins, subquries. and by using SET operators.<\/p>\n<ul>\n<li>7 Displaying Data from Multiple Tables Using Joins\n<ul>\n<li>7.1 Write SELECT statements to access data from more than one table using equijoins and nonequijoins<\/li>\n<li>7.2 Join a table to itself by using a self-join<\/li>\n<li>7.3 View data that generally does not meet a join condition by using OUTER joins<\/li>\n<li>7.4 Generate a Cartesian product of all rows from two or more tables<\/li>\n<\/ul>\n<\/li>\n<li>8 Using Subqueries to Solve Queries\n<ul>\n<li>8.1 Define subqueries<\/li>\n<li>8.2 Describe the types of problems that the subqueries can solve<\/li>\n<li>8.3 Describe the types of subqueries<\/li>\n<li>8.4 Write single-row and multiple-row subqueries<\/li>\n<li>8.5 Using the SET operators<\/li>\n<li>8.6 Describe set operators<\/li>\n<li>8.7 Use a set operator to combine multiple queries into a single query<\/li>\n<li>8.8 Control the order of rows returned<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><span style=\"text-decoration: underline;\">Reading Material<\/span><\/p>\n<ul>\n<li><a href=\"http:\/\/docs.oracle.com\/database\/121\/SQLRF\/queries006.htm#SQLRF30046\">Joins<\/a><\/li>\n<li><a href=\"http:\/\/docs.oracle.com\/database\/121\/SQLRF\/queries003.htm#SQLRF52332\">Hierarchical Queries<\/a><\/li>\n<li><a href=\"http:\/\/docs.oracle.com\/database\/121\/SQLRF\/queries007.htm#SQLRF52357\">Using Sub Queries<\/a><\/li>\n<li><a href=\"https:\/\/blogs.oracle.com\/optimizer\/entry\/outerjoins_in_oracle\">Outer Joins in Oracle<\/a><\/li>\n<li><a href=\"https:\/\/oracle-base.com\/articles\/12c\/lateral-inline-views-cross-apply-and-outer-apply-joins-12cr1\">LATERAL Inline Views, CROSS APPLY and OUTER APPLY Joins<\/a><\/li>\n<li><a href=\"http:\/\/docs.oracle.com\/database\/121\/SQLRF\/queries004.htm#SQLRF52341\">The UNION [ALL], INTERSECT, MINUS Operators<\/a><\/li>\n<li><a href=\"http:\/\/www.gplivna.eu\/papers\/sql_set_operators.htm\">Set Operators<\/a><\/li>\n<\/ul>\n<p style=\"text-align: center;\"><a href=\"https:\/\/bijoos.com\/oraclenotes\/certification-12c\/oracle-1z0-061\">1Z0-061\u00a0Objectives List<\/a><\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/bijoos.com\/oraclenotes\/certification-12c\">Oracle Database 12c OCA Certification<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>[Additional] Reading material for 1z0-061 Oracle Database 12c SQL Fundamentals test. Chapter 5: Using Joins and Subqueries\u00a0explains how data from multiple tables can be related via joins, subquries. and by using SET operators. 7 Displaying Data from Multiple Tables Using Joins 7.1 Write SELECT statements to access data from more than one table using equijoins &#8230; <a title=\"OCA12c \u2013 1Z0-061 \u2013 Additional Reading 05\" class=\"read-more\" href=\"https:\/\/bijoos.com\/oraclenotes\/2015\/1584\/\" aria-label=\"Read more about OCA12c \u2013 1Z0-061 \u2013 Additional Reading 05\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1584","post","type-post","status-publish","format-standard","hentry","category-certification-learning"],"acf":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1584","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/comments?post=1584"}],"version-history":[{"count":0,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1584\/revisions"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=1584"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=1584"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=1584"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}