{"id":1582,"date":"2015-09-05T19:08:02","date_gmt":"2015-09-06T00:08:02","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=1582"},"modified":"2015-09-05T19:08:02","modified_gmt":"2015-09-06T00:08:02","slug":"oca12c-1z0-061-additional-reading-04","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2015\/1582\/","title":{"rendered":"OCA12c \u2013 1Z0-061 \u2013 Additional Reading 04"},"content":{"rendered":"<p><strong>[Additional] Reading material for 1z0-061 Oracle Database 12c SQL Fundamentals test.<\/strong><\/p>\n<p><strong>Chapter 4: Using Group Functions<\/strong>\u00a0explains data aggregations, Oracle\u2019s built-in group function, and nesting of functions.<\/p>\n<ul>\n<li>6 Reporting Aggregated Data Using the Group Functions\n<ul>\n<li>6.1 Identify the available group functions<\/li>\n<li>6.2 Describe the use of group functions<\/li>\n<li>6.3 Group data by using the GROUP BY clause<\/li>\n<li>6.4 Include or exclude grouped rows by using the HAVING clause<\/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\/functions003.htm#SQLRF20035\">Aggregate Functions<\/a><\/li>\n<li><a href=\"http:\/\/beginner-sql-tutorial.com\/sql-group-functions.htm\">SQL Group Functions<\/a><\/li>\n<li><a href=\"https:\/\/oracle-base.com\/articles\/misc\/string-aggregation-techniques\">String Aggregation Techniques<\/a><\/li>\n<li><a href=\"http:\/\/www.techonthenet.com\/oracle\/having.php\">HAVING Clause<\/a><\/li>\n<li><a href=\"https:\/\/oracle-base.com\/articles\/misc\/rollup-cube-grouping-functions-and-grouping-sets\">ROLLUP, CUBE, GROUPING Functions and GROUPING SETS<\/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 4: Using Group Functions\u00a0explains data aggregations, Oracle\u2019s built-in group function, and nesting of functions. 6 Reporting Aggregated Data Using the Group Functions 6.1 Identify the available group functions 6.2 Describe the use of group functions 6.3 Group data by using the GROUP BY &#8230; <a title=\"OCA12c \u2013 1Z0-061 \u2013 Additional Reading 04\" class=\"read-more\" href=\"https:\/\/bijoos.com\/oraclenotes\/2015\/1582\/\" aria-label=\"Read more about OCA12c \u2013 1Z0-061 \u2013 Additional Reading 04\">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-1582","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\/1582","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=1582"}],"version-history":[{"count":0,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1582\/revisions"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=1582"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=1582"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=1582"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}