Sumário Itens Encontrados: 316Chapter 1: Relational Database Systems and Oracle1.1 Information Needs and Information Systems1.2 Database DesignEntities and AttributesGeneric vs. SpecificRedundancyConsistency,Integrity,and Integrity ConstraintsData Modeling Approach,Methods,and TechniquesSemanticsInformation Systems Terms Review1.3 Database Management SystemsDBMS ComponentsDatabase ApplicationsDBMS Terms Review1.4 Relational Database Management Systems1.5 Relational Data StructuresTables,Columns,and RowsThe Information PrincipleDatatypesKeysMissing Information and Null ValuesConstraint CheckingPredicates and PropositionsRelational Data Structure Terms Review1.6 Relational Operators1.7 How Relational Is My DBMS?1.8 The Oracle Software Environment1.9 Case TablesThe ERM Diagram of the CaseTable DescriptionsChapter 2: Introduction to SQL and SQL Developer2.1 Overview of SQLData DefinitionData Manipulation and TransactionsRetrievalSecurity2.2 Basic SQL Concepts and TerminologyConstants (Literals)VariablesOperators,Operands,Conditions,and ExpressionsFunctionsDatabase Object NamingCommentsReserved Words2.3 Introduction to SQL DeveloperInstalling and Configuring SQL DeveloperConnecting to a DatabaseExploring ObjectsSchema BrowserEntering CommandsBrowsing table dataRun StatementRun ScriptSaving Commands to a ScriptRunning a ScriptExporting Your DataUser-Defined ReportsTuning Your SQLWriting PL/SQLData ModellerChapter 3: Data Definition,Part I3.1 Schemas and Users3.2 Table Creation3.3 DatatypesNumber DatatypeCharacter DatatypeDate Datatype3.4 Commands for Creating the Case Tables3.5 The Data DictionaryChapter 4: Retrieval: The Basics4.1 Overview of the SELECT Command4.2 The SELECT ClauseColumn AliasesThe DISTINCT KeywordColumn Expressions4.3 The WHERE Clause4.4 The ORDER BY Clause4.5 AND,OR,and NOTThe OR OperatorThe AND Operator and Operator Precedence IssuesThe NOT Operator4.6 BETWEEN,IN,and LIKEThe BETWEEN OperatorThe IN OperatorThe LIKE Operator4.7 CASE Expressions4.8 SubqueriesThe Joining ConditionWhen a Subquery Returns Too Many ValuesComparison Operators in the Joining ConditionWhen a Single-Row Subquery Returns More Than One Row4.9 Null ValuesNull Value DisplayThe Nature of Null ValuesThe IS NULL OperatorNull Values and the Equality OperatorNull Value Pitfalls4.10 Truth Tables4.11 ExercisesChapter 5: Retrieval: Functions5.1 Overview of Functions5.2 Arithmetic Functions5.3 Text Functions5.4 Regular ExpressionsRegular Expression Operators and MetasymbolsRegular Expression Function SyntaxREGEXP_LIKEREGEXP_INSTRREGEXP_SUBSTRREGEXP_REPLACE5.5 Date FunctionsEXTRACTROUND and TRUNCMONTHS_BETWEEN and ADD_MONTHSNEXT_DAY and LAST_DAY5.6 General FunctionsGREATEST and LEASTNVLDECODESAMPLE Function5.7 Conversion FunctionsTO_NUMBER and TO_CHARConversion Function FormatsDatatype ConversionCAST5.8 Stored FunctionsFunction in WITH Clause of Query5.9 ExercisesChapter 6: Data Manipulation6.1 The INSERT CommandStandard INSERT CommandsINSERT Using Subqueries6.2 The UPDATE Command6.3 The DELETE Command6.4 The MERGE Command6.5 Transaction Processing6.6 Locking and Read ConsistencyLockingRead ConsistencyTerms ReviewChapter 7: Data Definition,Part II7.1 The CREATE TABLE Command7.2 More on DatatypesCharacter DatatypesNumbers Revisited7.3 The ALTER TABLE and RENAME Commands7.4 ConstraintsOut-of-Line ConstraintsInline ConstraintsConstraint Definitions in the Data DictionaryCase Table Definitions with ConstraintsA Solution for Foreign Key References: CREATE SCHEMADeferrable Constraints7.5 IndexesIndex CreationIndex Management7.6 Performance Monitoring with SQL Developer AUTOTRACE7.7 Sequences7.8 Synonyms7.9 The CURRENT_SCHEMA Setting7.10 The DROP TABLE Command7.11 The TRUNCATE Command7.12 The COMMENT Command7.13 ExercisesChapter 8: Retrieval: Multiple Tables and Aggregation8.1 Tuple Variables8.2 JoinsCartesian ProductsEquijoinsNon-equijoinsJoins of Three or More TablesSelf-Joins8.3 The JOIN ClauseNatural JoinsEquijoins on Columns with the Same Name8.4 Outer JoinsOld Oracle-Specific Outer Join SyntaxNew Outer Join SyntaxOuter Joins and Performance8.5 The GROUP BY ComponentMultiple-Column GroupingGROUP BY and Null Values8.6 Group FunctionsGroup Functions and Duplicate ValuesGroup Functions and Null ValuesGrouping the Results of a JoinThe COUNT(*) FunctionValid SELECT and GROUP BY Clause Combinations8.7 The HAVING ClauseThe Difference Between WHERE and HAVINGHAVING Clauses Without Group FunctionsA Classic SQL MistakeGrouping on Additional Columns8.8 Advanced GROUP BY FeaturesGROUP BY ROLLUPGROUP BY CUBECUBE,ROLLUP,and Null Values8.9 Partitioned Outer Joins8.10 Set Operators8.11 ExercisesChapter 9: Retrieval: Some Advanced Features9.1 Subqueries ContinuedThe ANY and ALL OperatorsCorrelated SubqueriesThe EXISTS Operator9.2 Subqueries in the SELECT Clause9.3 Subqueries in the FROM Clause9.4 The WITH Clause9.5 Hierarchical QueriesSTART WITH and CONNECT BYLEVEL,CONNECT_BY_ISCYCLE,and CONNECT_BY_ISLEAFCONNECT_BY_ROOT and SYS_CONNECT_BY_PATHHierarchical Query Result Sorting9.6 Analytic FunctionsPartitionsFunction Processing9.7 Row Limiting9.8 Flashback FeaturesAS OFVERSIONS BETWEENFLASHBACK TABLE9.9 ExercisesChapter 10: Views10.1 What Are Views?10.2 View CreationCreating a View from a QueryGetting Information about Views from the Data DictionaryReplacing and Dropping Views10.3 What Can You Do with Views?Simplifying Data RetrievalMaintaining Logical Data IndependenceImplementing Data Security10.4 Data Manipulation via ViewsUpdatable Join ViewsNonupdatable ViewsThe WITH CHECK OPTION Clause10.5 Data Manipulation via Inline Views10.6 Views and Performance10.7 Materialized ViewsProperties of Materialized ViewsQuery Rewrite10.8 Global Temporary Table10.9 Invisible Columns10.10 ExercisesChapter 11: SQL*Plus Basics and Scripting11.1 Introduction to SQL*PlusUsing the SQL BufferUsing an External EditorUsing the SQL*Plus EditorSaving CommandsRunning SQL*Plus ScriptsSpecifying Directory Path SpecificationsAdjusting SQL*Plus SettingsSpooling a SQL*Plus SessionDescribing Database ObjectsExecuting Commands from the Operating SystemClearing the Buffer and the ScreenSQL*Plus Command Review11.2 SQL*Plus VariablesSQL*Plus Substitution VariablesSQL*Plus User-Defined VariablesSQL*Plus System Variables11.3 Bind VariablesBind Variable DeclarationBind Variables in SQL Statements11.4 SQL*Plus ScriptsScript ExecutionScript ParametersSQL*Plus Commands in ScriptsThe login.sql Script11.5 Report Generation with SQL*PlusThe SQL*Plus COLUMN CommandThe SQL*Plus TTITLE and BTITLE CommandsThe SQL*Plus BREAK CommandThe SQL*Plus COMPUTE CommandThe Finishing Touch: SPOOL11.6 HTML in SQL*PlusHTML in SQL*Plus11.7 Building SQL*Plus Scripts for AutomationWhat Is a SQL*Plus Script?Capturing and Using Input Parameter ValuesPassing Data Values from One SQL Statement to AnotherHandling Error ConditionsSQL*Plus Error Logging11.8 ExercisesChapter 12: Object-Relational Features12.1 More DatatypesCollection DatatypesMethods12.2 VarraysCreating the ArrayPopulating the Array with ValuesQuerying Array Columns12.3 Nested TablesCreating Table TypesCreating the Nested TablePopulating the Nested TableQuerying the Nested Table12.4 User-Defined TypesCreating User-Defined TypesShowing More Information with DESCRIBE12.5 Multiset OperatorsWhich SQL Multiset Operators Are Available?Preparing for the ExamplesUsing IS NOT EMPTY and CARDINALITYUsing POWERMULTISETUsing MULTISET UNIONConverting Arrays into Nested Tables12.6 ExercisesAppendix A: The Seven Case TablesERM DiagramTable Structure DescriptionsColumns and Foreign Key ConstraintsHierarchical Employees OverviewCourse Offerings OverviewAppendix B: Answers to the Exercises