Sumário Itens Encontrados: 126Chapter 1. SQL and DataWhat Is SQL?Why Learn SQL?An Introduction to DatabasesLab 1.1. The Relational DatabaseLab 1.2. Data Normalization and Table RelationshipsLab 1.3. The STUDENT Schema DiagramChapter 2. SQL: The BasicsLab 2.1. The SQL Execution EnvironmentLab 2.2. The Anatomy of a SELECT StatementLab 2.3. An Introduction to SQL*PlusChapter 3. The WHERE and ORDER BY ClausesLab 3.1. The WHERE ClauseLab 3.2. The ORDER BY ClauseChapter 4. Character, Number, and Miscellaneous FunctionsData TypesReading Syntax DiagramsLab 4.1. Character FunctionsLab 4.2. Number FunctionsLab 4.3. Miscellaneous Single-Row FunctionsChapter 5. Date and Conversion FunctionsLab 5.1. Applying Oracleâs Date Format ModelsLab 5.2. Performing Date and Time MathLab 5.3. Understanding the TIMESTAMP and TIME ZONE Data TypesLab 5.4. Performing Calculations with the Interval Data TypesLab 5.5. Converting from One Data Type to AnotherChapter 6. Aggregate Functions, GROUP BY, and HAVING ClausesLab 6.1. Aggregate FunctionsLab 6.2. The GROUP BY and HAVING ClausesChapter 7. EquijoinsLab 7.1. The Two-Table JoinLab 7.2. Joining Three or More TablesChapter 8. SubqueriesLab 8.1. Simple SubqueriesLab 8.2. Correlated SubqueriesLab 8.3. Inline Views and Scalar Subquery ExpressionsLab 8.4. ANY, SOME, and ALL Operators in SubqueriesOracle SQL By Example - 4th EdChapter 9. Set OperatorsLab 9.1. The Power of UNION and UNION ALLLab 9.2. The MINUS and INTERSECT Set OperatorsChapter 10. Complex JoinsLab 10.1. Outer JoinsLab 10.2. Self-JoinsChapter 11. Insert, Update, and DeleteLab 11.1. Creating Data and Transaction ControlLab 11.2. Updating and Deleting DataLab 11.3. The SQL Developer Data TabChapter 12. Create, Alter, and Drop TablesLab 12.1. Creating and Dropping TablesLab 12.2. Altering Tables and Manipulating ConstraintsChapter 13. Indexes, Sequences, and ViewsLab 13.1. IndexesLab 13.2. SequencesLab 13.3. ViewsChapter 14. The Data Dictionary, Scripting, and ReportingLab 14.1. The Oracle Data Dictionary ViewsLab 14.2. Scripting and ReportingChapter 15. SecurityLab 15.1. Users, Privileges, Roles, and SynonymsChapter 16. Regular Expressions and Hierarchical QueriesLab 16.1. Regular ExpressionsLab 16.2. Hierarchical QueriesChapter 17. Exploring Data Warehousing FeaturesLab 17.1. Advanced SQL Concepts, Analytical Functions, and the WITH ClauseLab 17.2. ROLLUP and CUBE OperatorsChapter 18. SQL OptimizationLab 18.1. The Oracle Optimizer and Writing Effective SQL StatementsAppendix A. Answers to Quiz QuestionsChapter 1Chapter 2Chapter 3Chapter 4Chapter 5Chapter 6Chapter 7Chapter 8Chapter 9Chapter 10Chapter 11Chapter 12Chapter 13Chapter 14Chapter 15Chapter 16Chapter 17Chapter 18Appendix B. SQL Formatting GuideCaseFormatting SQL CodeSQL DeveloperAppendix C. SQL*Plus Command ReferenceSQL*Plus Commands Supported in SQL DeveloperSQL*Plus CommandsPredefined SQL*Plus VariablesThe LOGIN.SQL and GLOGIN.SQL FilesFormatting Output in SQL*PlusEditing in SQL*PlusSQL*Plus Line Editor Editing CommandsUsing the SQL*Plus Line Editor to Save and Retrieve FilesCommand Scripts in SQL*PlusAppendix D. STUDENT Database SchemaAppendix E. Table and Column DescriptionsAppendix F. Additional Example TablesChapter 4: Character, Number, and Miscellaneous FunctionsChapter 5: Date and Conversion FunctionsChapter 10: Complex JoinsChapter 11: Insert, Update, and DeleteChapter 16: Regular Expressions and Hierarchical QueriesChapter 17: Exploring Data Warehousing FeaturesAppendix G. Navigating the Oracle DocumentationWhere Do You Find the Oracle Documentation?Navigating the LibraryJump-Starting Your SearchOracle Documentation TitlesError MessagesReading Oracle Syntax DiagramsAppendix H. ResourcesUseful Oracle-Related Web SitesAlternative SQL Execution ToolsDatabase Design SoftwareUser GroupsOracle-Related PublicationsAcademic ResourcesBooksAppendix I. Oracle Data Types