Sumário Itens Encontrados: 2461 Relational Database Design Using Oracle2 Data Retrieval Using the SQL SELECT Statement3 Restricting and Sorting Data4 Single-Row Functions5 Using Conversion Functions andConditional Expressions6 Reporting Aggregated Data Using the Group Functions7 Displaying Data from Multiple Tables8 Using Subqueries to Solve Problems9 Using the Set Operators10 Manipulating Data11 Using DDL Statements to Create and Manage TablesA About the CD-ROMGlossaryIndexPosition the Server TechnologiesThe Oracle Server ArchitectureThe Oracle WebLogic ServerOracle Enterprise ManagerCloud ComputingExercise 1-1: Investigate Your Databaseand Application EnvironmentDevelopment Tools and LanguagesUnderstand Relational StructuresReal-World ScenariosData ModelingEntities and RelationsExercise 1-2: Design an Entity-Relationship Diagramfor the Geological Cores ScenarioRows and TablesSummarize the SQL LanguageSQL StandardsSQL CommandsA Set-Oriented LanguageUse the Client ToolsSQL*PlusSQL DeveloperCreate the Demonstration SchemasUsers and SchemasThe HR and OE SchemasDemonstration Schema Creationx OCA Oracle Database 12c: SQL Fundamentals I Exam Guide? Two-Minute DrillQ&A Self TestLab QuestionSelf Test AnswersLab Answer2 Data Retrieval Using the SQLSELECT Statement 55List the Capabilities of SQL SELECT StatementsIntroducing the SQL SELECT StatementThe DESCRIBE Table CommandExercise 2-1: Describing the HumanResources SchemaCapabilities of the SELECT StatementExecute a Basic SELECT StatementThe Primitive SELECT StatementSyntax RulesExercise 2-2: Answering Our FirstQuestions with SQLSQL Expressions and OperatorsThe NULL ConceptExercise 2-3: Experimenting with Expressionsand the DUAL Table3 Restricting and Sorting Data 109Limit the Rows Retrieved by a QueryThe WHERE clauseComparison OperatorsExercise 3-1: Using the LIKE OperatorBoolean OperatorsPrecedence RulesSort the Rows Retrieved by a QueryThe ORDER BY ClauseExercise 3-2: Sorting Data UsingAmpersand SubstitutionSubstitution VariablesDefine and VerifyExercise 3-3: Using Ampersand Substitution4 Single-Row Functions 175Describe Various Types of FunctionsAvailable in SQLDefining a FunctionTypes of FunctionsUse Character,Number,and Date Functionsin SELECT StatementsUsing Character Case Conversion FunctionsExercise 4-1: Using the Case Conversion FunctionsUsing Character Manipulation FunctionsExercise 4-2: Using the CharacterManipulation FunctionsUsing Numeric FunctionsWorking with DatesUsing Date FunctionsExercise 4-3: Using the Date FunctionsConditional Expressions 233Describe Various Types of ConversionFunctions Available in SQLConversion FunctionsUse the TO_CHAR,TO_NUMBER,and TO_DATE Conversion FunctionsUsing the Conversion FunctionsExercise 5-1: Converting Dates intoCharacters Using the TO_CHAR FunctionApply Conditional Expressions in a SELECT StatementNested FunctionsGeneral FunctionsExercise 5-2: Using NULLIF and NVL2for Simple Conditional LogicConditional FunctionsExercise 5-3: Using the DECODE Function6 Reporting Aggregated DataUsing the Group Functions 277Describe the Group FunctionsDefinition of Group FunctionsTypes and Syntax of Group FunctionsIdentify the Available Group FunctionsUsing the Group FunctionsExercise 6-1: Using the Group FunctionsNested Group FunctionsGroup Data Using the GROUP BY ClauseCreating Groups of DataThe GROUP BY ClauseGrouping by Multiple ColumnsExercise 6-2: Grouping Data Based onMultiple ColumnsInclude or Exclude Grouped Rows Using the HAVING ClauseRestricting Group ResultsThe HAVING ClauseExercise 6-3: Using the HAVING Clause7 Displaying Data from Multiple Tables 315Write SELECT Statements to Access Data from MoreThan One Table Using Equijoins and NonequijoinsTypes of JoinsJoining Tables Using ANSI SQL SyntaxQualifying Ambiguous Column NamesThe NATURAL JOIN ClauseExercise 7-1: Using the NATURAL JOINThe JOIN USING ClauseThe JOIN ON ClauseExercise 7-2: Using the NATURALJOINâ¦ON ClauseN-Way Joins and Additional Join ConditionsNonequijoinsJoin a Table to Itself Using a Self-JoinJoining a Table to Itself Using the JOINâ¦ON ClauseExercise 7-3: Performing a Self-JoinView Data That Does Not Meet a JoinCondition by Using Outer JoinsInner versus Outer JoinsLeft Outer JoinsRight Outer JoinsFull Outer JoinsExercise 7-4: Performing an Outer-Joinxiv OCA Oracle Database 12c: SQL Fundamentals I Exam GuideGenerate a Cartesian Product of Two or More TablesCreating Cartesian Products Using Cross JoinsExercise 7-5: Performing a Cross-Join8 Using Subqueries to Solve Problems 365Define SubqueriesExercise 8-1: Types of SubqueriesDescribe the Types of Problems That the Subqueries Can SolveUse of a Subquery Result Set for Comparison PurposesStar TransformationGenerate a Table from Which to SELECTGenerate Values for ProjectionGenerate Rows to be Passed to a DML StatementExercise 8-2: More Complex SubqueriesList the Types of SubqueriesSingle- and Multiple-Row SubqueriesCorrelated SubqueriesExercise 8-3: Investigate the DifferentTypes of SubqueriesWrite Single-Row and Multiple-Row SubqueriesExercise 8-4: Write a Query That Is Reliableand User Friendly9 Using the Set Operators 395Describe the Set OperatorsSets and Venn DiagramsSet Operator General PrinciplesExercise 9-1: Describe the Set OperatorsUse a Set Operator to Combine MultipleQueries into a Single QueryThe UNION ALL OperatorThe UNION OperatorThe INTERSECT OperatorThe MINUS OperatorMore Complex ExamplesExercise 9-2: Using the Set OperatorsControl the Order of Rows ReturnedExercise 9-3: Control the Orderof Rows Returned10 Manipulating Data 423Describe Each Data Manipulation Language (DML) StatementINSERTUPDATEDELETEMERGETRUNCATEDML Statement FailuresInsert Rows into a TableExercise 10-1: Use the INSERT CommandUpdate Rows in a TableExercise 10-2: Use the UPDATE CommandDelete Rows from a TableRemoving Rows with DELETEExercise 10-3: Use the DELETE CommandRemoving Rows with TRUNCATEControl TransactionsDatabase TransactionsThe Transaction Control StatementsExercise 10-4: Use the COMMITand ROLLBACK Commands11 Using DDL Statements to Createand Manage Tables 475Categorize the Main Database ObjectsObject TypesNaming Schema ObjectsObject NamespacesExercise 11-1: Determine What Objects AreAccessible to Your SessionReview the Table StructureExercise 11-2: Investigate Table StructuresList the Data Types That Are Available for ColumnsExercise 11-3: Investigate the Data Typesin the HR schemaCreate a Simple TableCreating Tables with Column SpecificationsCreating Tables from SubqueriesAltering Table Definitions After CreationDropping and Truncating TablesExercise 11-4: Create TablesExplain How Constraints Are Createdat the Time of Table CreationThe Types of ConstraintsDefining ConstraintsExercise 11-5: Work with ConstraintsSystem RequirementsTotal Tester Premium Practice Exam SoftwareInstalling and Running Total TesterPremium Practice Exam SoftwareElectronic BookTechnical SupportTotal Seminars Technical SupportMcGraw-Hill Content SupportGlossary 517Index 533