{"id":1572,"date":"2015-09-04T19:45:15","date_gmt":"2015-09-05T00:45:15","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=1572"},"modified":"2015-09-04T19:45:15","modified_gmt":"2015-09-05T00:45:15","slug":"oca12c-1z0-061-additional-reading-02","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2015\/1572\/","title":{"rendered":"OCA12c \u2013 1Z0-061 \u2013 Additional Reading 02"},"content":{"rendered":"<p><strong>[Additional] Reading material for 1z0-061 Oracle Database 12c SQL Fundamentals test.<\/strong><\/p>\n<p><strong>Chapter 2: Introducing SQL<\/strong>\u00a0introduces you to writing simple queries using SELECT statement. It also introduces you to filtering and sorting data.<\/p>\n<ul>\n<li>2 Retrieving Data Using the SQL SELECT Statement\n<ul>\n<li>2.1 Explain the capabilities of SQL SELECT statements<\/li>\n<li>2.2 Execute a basic SELECT statement<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li>3 Restricting and Sorting Data\n<ul>\n<li>3.1 Limit the rows that are retrieved by a query<\/li>\n<li>3.2 Sort the rows that are retrieved by a query<\/li>\n<li>3.2 Use ampersand substitution to restrict and sort output at runtime<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><span style=\"text-decoration: underline;\">Reading Material<\/span><\/p>\n<ul>\n<li><a href=\"https:\/\/en.wikibooks.org\/wiki\/Oracle_Programming\/Retrieving_Data_Using_the_SQL_SELECT_Statement\">Retrieving Data Using the SQL SELECT Statement<\/a><\/li>\n<li><a href=\"http:\/\/docs.oracle.com\/database\/121\/SQLRF\/sql_elements.htm#SQLRF002\">Basic Elements of Oracle SQL<\/a><\/li>\n<li><a href=\"http:\/\/docs.oracle.com\/database\/121\/SQLRF\/operators.htm#SQLRF003\">Operators<\/a><\/li>\n<li><a href=\"http:\/\/docs.oracle.com\/database\/121\/SQLRF\/queries005.htm#SQLRF52348\">Sorting Query Results<\/a><\/li>\n<li><a href=\"https:\/\/oracle-base.com\/articles\/misc\/sql-for-beginners-the-select-list\">SQL for Beginners (Part 1) : The SELECT List<\/a><\/li>\n<li><a href=\"https:\/\/oracle-base.com\/articles\/misc\/sql-for-beginners-the-from-clause\">SQL for Beginners (Part 2) : The FROM Clause<\/a><\/li>\n<li><a href=\"https:\/\/oracle-base.com\/articles\/misc\/sql-for-beginners-the-where-clause\">SQL for Beginners (Part 3) : The WHERE Clause<\/a><\/li>\n<li><a href=\"http:\/\/docs.oracle.com\/database\/121\/SQLRF\/statements_10002.htm#i2134734\">The WHERE clause<\/a><\/li>\n<li><a href=\"http:\/\/docs.oracle.com\/database\/121\/SQLRF\/statements_10002.htm#BABHFGAA\">Row Limiting Clause<\/a><\/li>\n<li><a href=\"http:\/\/docs.oracle.com\/database\/121\/SQLRF\/statements_10002.htm#i2171079\">The ORDER BY Clause<\/a><\/li>\n<li><a href=\"https:\/\/blogs.oracle.com\/opal\/entry\/sqlplus_101_substitution_varia\">SQL*Plus 10.1 Substitution Variables<\/a><\/li>\n<li><a href=\"http:\/\/docs.oracle.com\/database\/121\/SQPUG\/ch_five.htm#SQPUG437\">Using Substitution Variables<\/a><\/li>\n<li><a href=\"http:\/\/www.oracle.com\/technetwork\/issue-archive\/2006\/06-sep\/o56asktom-086197.html\">On ROWNUM and Limiting Results<\/a><\/li>\n<li><a href=\"https:\/\/oracle-base.com\/articles\/12c\/row-limiting-clause-for-top-n-queries-12cr1\">Row Limiting Clause for Top-N Queries<\/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 2: Introducing SQL\u00a0introduces you to writing simple queries using SELECT statement. It also introduces you to filtering and sorting data. 2 Retrieving Data Using the SQL SELECT Statement 2.1 Explain the capabilities of SQL SELECT statements 2.2 Execute a basic SELECT statement 3 &#8230; <a title=\"OCA12c \u2013 1Z0-061 \u2013 Additional Reading 02\" class=\"read-more\" href=\"https:\/\/bijoos.com\/oraclenotes\/2015\/1572\/\" aria-label=\"Read more about OCA12c \u2013 1Z0-061 \u2013 Additional Reading 02\">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-1572","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\/1572","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=1572"}],"version-history":[{"count":0,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1572\/revisions"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=1572"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=1572"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=1572"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}