Sumário Itens Encontrados: 201Part I: An SQL Concepts OverviewHOUR 1 Welcome to the World of SQLPart II: Building Your DatabaseHOUR 2 Defining Data Structures3 Managing Database Objects4 The Normalization Process5 Manipulating Data6 Managing Database TransactionsPart III: Getting Effective Results from QueriesHOUR 7 Introduction to Database Queries8 Using Operators to Categorize Data9 Summarizing Data Results from a Query10 Sorting and Grouping Data11 Restructuring the Appearance of Data12 Understanding Dates and TimesPart IV: Building Sophisticated Database QueriesHOUR 13 Joining Tables in Queries14 Using Subqueries to Define Unknown Data15 Combining Multiple Queries into OnePart V: SQL Performance TuningHOUR 16 Using Indexes to Improve Performance17 Improving Database PerformancePart VI: Using SQL to Manage Users and SecurityHOUR 18 Managing Database Users19 Managing Database SecurityPart VII: Summarized Data StructuresHOUR 20 Creating and Using Views and Synonyms21 Working with the System CatalogHOUR 22 Advanced SQL Topics23 Extending SQL to the Enterprise, the Internet, and the Intranet24 Extensions to Standard SQLPart IX: AppendixesAPPENDIX A Common SQL CommandsB Installing Oracle and Microsoft SQLC Answers to Quizzes and ExercisesD Bonus ExercisesE GlossaryIndexHOUR 1: Welcome to the World of SQLSQL Definition and HistorySQL SessionsTypes of SQL CommandsCanary Airlines: The Database Used in This BookSummaryQ&AWorkshopHOUR 2: Defining Data StructuresWhat Is Data?Basic Data TypesHOUR 3: Managing Database ObjectsDatabase Objects and SchemaTables: The Primary Storage for DataIntegrity ConstraintsHOUR 4: The Normalization ProcessNormalizing a DatabaseDenormalizing a DatabaseHOUR 5: Manipulating DataOverview of Data ManipulationPopulating Tables with New DataUpdating Existing DataDeleting Data from TablesHOUR 6: Managing Database TransactionsWhat Is a Transaction?Controlling TransactionsPoor Transactional ControlHOUR 7: Introduction to Database QueriesThe SELECT StatementCase-SensitivityFundamentals of Query WritingHOUR 8: Using Operators to Categorize DataWhat Is an Operator in SQL?Comparison OperatorsLogical OperatorsConjunctive OperatorsNegative OperatorsArithmetic OperatorsHOUR 9: Summarizing Data Results from a QueryAggregate FunctionsHOUR 10: Sorting and Grouping DataWhy Group Data?The GROUP BY ClauseGROUP BY Versus ORDER BYCUBE and ROLLUP ExpressionsThe HAVING ClauseHOUR 11: Restructuring the Appearance of DataANSI Character FunctionsCommon Character FunctionsMiscellaneous Character FunctionsMathematical FunctionsConversion FunctionsCombining Character FunctionsHOUR 12: Understanding Dates and TimesHow Is a Date Stored?Date FunctionsDate ConversionsHOUR 13: Joining Tables in QueriesSelecting Data from Multiple TablesUnderstanding JoinsJoin ConsiderationsHOUR 14: Using Subqueries to Define Unknown DataWhat Is a Subquery?Embedded SubqueriesCorrelated SubqueriesSubquery PerformanceHOUR 15: Combining Multiple Queries into OneSingle Queries Versus Compound QueriesCompound Query OperatorsUsing ORDER BY with a Compound QueryUsing GROUP BY with a Compound QueryRetrieving Accurate DataHOUR 16: Using Indexes to Improve PerformanceWhat Is an Index?How Do Indexes Work?The CREATE INDEX CommandTypes of IndexesWhen Should Indexes Be Considered?When Should Indexes Be Avoided?Altering an IndexDropping an IndexHOUR 17: Improving Database PerformanceWhat Is SQL Statement Tuning?Database Tuning Versus SQL Statement TuningFormatting Your SQL StatementFull Table ScansOther Performance ConsiderationsCost-Based OptimizationHOUR 18: Managing Database UsersUser Management in the DatabaseThe Management ProcessTools Utilized by Database UsersHOUR 19: Managing Database SecurityWhat Is Database Security?What Are Privileges?Controlling User AccessControlling Privileges Through RolesHOUR 20: Creating and Using Views and SynonymsWhat Is a View?Creating ViewsUpdating Data Through a ViewDropping a ViewPerformance Impact of Nested ViewsWhat Is a Synonym?HOUR 21: Working with the System CatalogWhat Is the System Catalog?How Is the System Catalog Created?What Is Contained in the System Catalog?System Catalog Tables by ImplementationQuerying the System CatalogUpdating System Catalog ObjectsHOUR 22: Advanced SQL TopicsCursorsStored Procedures and FunctionsTriggersDynamic SQLCall-Level InterfaceUsing SQL to Generate SQLDirect Versus Embedded SQLWindowed Table FunctionsWorking with XMLHOUR 23: Extending SQL to the Enterprise, the Internet, and the IntranetSQL and the EnterpriseAccessing a Remote DatabaseSQL and the InternetSQL and the IntranetHOUR 24: Extensions to Standard SQLVarious ImplementationsExample ExtensionsInteractive SQL StatementsAPPENDIX A: Common SQL CommandsSQL StatementsSQL ClausesAPPENDIX B: Installing Oracle and Microsoft SQLWindows Installation Instructions for OracleWindows Installation Instructions for Microsoft SQL ServerAPPENDIX C: Answers to Quizzes and ExercisesHour 1, âWelcome to the World of SQLâHour 2, âDefining Data StructuresâHour 3, âManaging Database ObjectsâHour 4, âThe Normalization ProcessâHour 5, âManipulating DataâHour 6, âManaging Database TransactionsâHour 7, âIntroduction to the Database QueriesâHour 8, âUsing Operators to Categorize DataâHour 9, âSummarizing Data Results from a QueryâHour 10, âSorting and Grouping DataâHour 11, âRestructuring the Appearance of DataâHour 12, âUnderstanding Dates and TimesâHour 13, âJoining Tables in QueriesâHour 14, âUsing Subqueries to Define Unknown DataâHour 15, âCombining Multiple Queries into OneâHour 16, âUsing Indexes to Improve PerformanceâHour 17, âImproving Database PerformanceâHour 18, âManaging Database UsersâHour 19, âManaging Database SecurityâHour 20, âCreating and Using Views and SynonymsâHour 21, âWorking with the System CatalogâHour 22, âAdvanced SQL TopicsâHour 23, âExtending SQL to the Enterprise, the Internet, and the IntranetâHour 24, âExtensions to Standard SQLâAPPENDIX D: Bonus ExercisesAPPENDIX E: Glossary