tailieunhanh - OCA: Oracle Database 11g Administrator Certified Associate Study Guide- P1

OCA: Oracle Database 11g Administrator Certified Associate Study Guide- P1: There is high demand for professionals in the information technology (IT) industry, and Oracle certifications are the hottest credential in the database world. You have made the right decision to pursue certification, because being Oracle Database 11g certified will give you a distinct advantage in this highly competitive market. | Covers Both the 1Z0-051 and 1Z0-052 Exams Includes Real-World Scenarios Hands-On Exercises and Leading-Edge Exam Prep Software Featuring Custom Test Engine Hundreds of Sample Questions Electronic Flashcards for PCs Pocket PCs and Palm Handhelds Entire Book in PDF OCA Oracle Database 11g Administrator Certified Associate STUDYGUIDE. Exams 1Z0-051 Biju Thomas and 1Z0-052 Qsybex SERIOUS SKILLS. OCA Oracle Database 11g Administrator Certified Associate Study Guide 1Z0-051 Exam Objectives OBJECTIVE CHAPTER Retrieving Data Using the SQL SELECT Statement List the capabilities of SQL SELECT statements 1 Execute a basic SELECT statement 1 Restricting and Sorting Data Limit the rows that are retrieved by a query 1 Sort the rows that are retrieved by a query 1 Use ampersand substitution to restrict and sort output at runtime 1 Using Single-Row Functions to Customize Output Describe various types of functions available in SQL 2 Use character number and date functions in SELECT statements 2 Using Conversion Functions and Conditional Expressions Describe various types of conversion functions that are available in SQL 2 Use the TO_CHAR TO_NUMBER and TO_DATE conversion functions 2 Apply conditional expressions in a SELECT statement 2 Reporting Aggregated Data Using the Group Functions Identify the available group functions 3 Describe the use of group functions 3 Group data by using the GROUP BY clause 3 Include or exclude grouped rows by using the HAVING clause 3 Displaying Data from Multiple Tables Write SELECT statements to access data from more than one table using 4 equijoins and nonequijoins Join a table to itself by using a self-join 4 View data that generally does not meet a join condition by using outer joins 4 Generate a Cartesian product of all rows from two or more tables 4 Using Subqueries to Solve Queries Define subqueries 4 Describe the types of problems that the subqueries can solve 4 List the types of subqueries 4 Write single-row and multiple-row subqueries 4 Exam