Sumário Itens Encontrados: 335Chapter 1: Relational Database Systems and Oracle1.1 Information Needs and Information Systems1.2 Database DesignEntities and AttributesGeneric vs. SpecificRedundancy.Consistency,Integrity,and Integrity ConstraintsData Modeling Approach,Methods,and TechniquesSemanticsInformation Systems Terms Review.1.3 Database Management SystemsDBMS ComponentsKernelData DictionaryQuery LanguagesDBMS ToolsDatabase ApplicationsDBMS Terms Review1.4 Relational Database Management Systems1.5 Relational Data Structures.Tables,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 Descriptions.Chapter 2: Introduction to SQL,AQL*Plus,and SQL Develop2.1 Overview of SQLData DefinitionData Manipulation and TransactionsRetrievalSecurityPrivileges and RolesGRANT and REVOKE.2.2 Basic SQL Concepts and TerminologyConstants (Literals)VariablesOperators,Operands,Conditions,and ExpressionsArithmetic OperatorsThe Alphanumeric Operator: ConcatenationComparison OperatorsLogical OperatorsExpressionsFunctionsDatabase Object NamingCommentsReserved Words.2.3 Introduction to SQL*Plus.Entering CommandsUsing the SQL BufferUsing an External EditorUsing the SQL*Plus EditorUsing SQL Buffer Line NumbersUsing the EllipsisSQL*Plus Editor Command ReviewSaving 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 Review2.4 Introduction to SQL DeveloperInstalling and Configuring SQL DeveloperConnecting to a DatabaseExploring ObjectsRun StatementRun ScriptSaving Commands to a ScriptRunning a ScriptChapter 3: Data Definition,Part I3.1 Schemas and Users3.2 Table Creation3.3 Datatypes3.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 ExpressionsThe DUAL TableNull Values in 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 Subqueries.The 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 Functions.5.3 Text Functions5.4 Regular ExpressionsRegular Expression Operators and Metasymbols.Regular Expression Function SyntaxInfluencing Matching BehaviorREGEXP_INSTR Return ValueREGEXP_LIKEREGEXP_INSTRREGEXP_SUBSTRREGEXP_REPLACE5.5 Date FunctionsEXTRACTROUND and TRUNCMONTHS_BETWEEN and ADD_MONTHSNEXT_DAY and LAST_DAY5.6 General FunctionsGREATEST and LEASTNVLDECODE5.7 Conversion FunctionsTO_NUMBER and TO_CHARConversion Function FormatsDatatype ConversionCAST5.8 Stored Functions.5.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 ConsistencyChapter 7: Data Definition,Part II7.1 The CREATE TABLE Command7.2 More on DatatypesCharacter DatatypesComparison SemanticsColumn Data InterpretationNumbers 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 Constraints.7.5 IndexesIndex CreationUnique IndexesBitmap IndexesFunction-Based IndexesIndex 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 Functions.A Classic SQL MistakeGrouping on Additional Columns8.8 Advanced GROUP BY FeaturesGROUP BY ROLLUPGROUP BY CUBECUBE,ROLLUP,and Null ValuesThe GROUPING FunctionThe GROUPING_ID Function.8.9 Partitioned Outer Joins8.10 Set Operators.8.11 ExercisesChapter 9: Retrieval: Some Advanced Features.9.1 Subqueries ContinuedThe ANY and ALL OperatorsDefining ANY and ALL.Rewriting SQL Statements Containing ANY and ALLCorrelated SubqueriesThe EXISTS OperatorSubqueries Following an EXISTS OperatorEXISTS,IN,or JOIN?NULLS with NOT EXISTS and NOT IN9.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_ISLEAF.CONNECT_BY_ROOT and SYS_CONNECT_BY_PATHHierarchical Query Result Sorting9.6 Analytical Functions.PartitionsFunction Processing9.7 Flashback FeaturesAS OFVERSIONS BETWEEN.FLASHBACK TABLE9.8 ExercisesChapter 10: Views10.1 What Are Views?.10.2 View Creation.Creating a View from a Query.Getting Information About Views from the Data DictionaryReplacing and Dropping Views.10.3 What Can You Do with Views?.Simplifying Data RetrievalMaintaining Logical Data IndependenceImplementing Data Security10.4 Data Manipulation via ViewsUpdatable Join ViewsNonupdatable Views.The WITH CHECK OPTION Clause.Disappearing Updated RowsInserting Invisible RowsPreventing These Two Scenarios10.5 Data Manipulation via Inline Views10.6 Views and Performance.10.7 Materialized ViewsProperties of Materialized Views.Query Rewrite10.8 ExercisesChapter 11: Writing and Automating SQL*Plus Scripts11.1 SQL*Plus VariablesSQL*Plus Substitution VariablesSQL*Plus User-Defined VariablesImplicit SQL*Plus User-Defined VariablesUser-Friendly PromptingSQL*Plus System Variables11.2 Bind VariablesBind Variable DeclarationBind Variables in SQL Statements11.3 SQL*Plus ScriptsScript Execution.Script ParametersSQL*Plus Commands in Scripts.The login.sql Script.11.4 Report Generation with SQL*PlusThe SQL*Plus COLUMN CommandThe SQL*Plus TTITLE and BTITLE CommandsThe SQL*Plus BREAK Command.The SQL*Plus COMPUTE CommandThe Finishing Touch: SPOOL.11.5 HTML in SQL*PlusHTML in SQL*Plus.11.6 Building SQL*Plus Scripts for AutomationWhat Is a SQL*Plus Script?.Capturing and Using Input Parameter Values.Passing Data Values from One SQL Statement to AnotherMechanism 1: The NEW_VALUE ClauseMechanism 2: Bind VariablesHandling Error Conditions11.7 ExercisesChapter 12: Object-Relational Features.12.1 More DatatypesCollection Datatypes.Methods12.2 Varrays.Creating the Array.Populating the Array with ValuesQuerying Array Columns.12.3 Nested TablesCreating Table Types.Creating 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 CARDINALITY.Using POWERMULTISETUsing MULTISET UNIONConverting Arrays into Nested Tables12.6 ExercisesAppendix A: The Seven Case TablesERM DiagramTable Structure DescriptionsColumns and Foreign Key ConstraintsHierarchical Employees OverviewCourse Offerings Overview