Beginning Oracle SQL : For Oracle Database 12c / / by Tim Gorman, Inger Jorgensen, Melanie Caffrey, Lex deHaan

• Autore: Gorman Tim
• Pubblicazione: Berkeley, CA : , : Apress : , : Imprint : Apress, , 2014
• Edizione: 3rd ed. 2014.
• Descrizione fisica: 1 online resource (429 p.)
• Disciplina: 004; 005.13; 005.7585
• Soggetto topico: Database management; Data structures (Computer science); Database Management; Data Structures and Information Theory
• Persona (resp. second.): JorgensenInger; CaffreyMelanie; deHaanLex
• Note generali: "The expert's voice in Oracle"--Cover.; Includes index.
• Nota di contenuto: ""Contents at a Glance""; ""Contents""; ""About the Authors""; ""About the Technical Reviewer""; ""Acknowledgments""; ""Introduction""; ""Chapter 1: Relational Database Systems and Oracle""; ""1.1 Information Needs and Information Systems""; ""1.2 Database Design""; ""Entities and Attributes""; ""Generic vs. Specific""; ""Redundancy""; ""Consistency, Integrity, and Integrity Constraints""; ""Data Modeling Approach, Methods, and Techniques""; ""Semantics""; ""Information Systems Terms Review""; ""1.3 Database Management Systems""; ""DBMS Components""; ""Kernel""; ""Data Dictionary"" ; ""Query Languages""""DBMS Tools""; ""Database Applications""; ""DBMS Terms Review""; ""1.4 Relational Database Management Systems""; ""1.5 Relational Data Structures""; ""Tables, Columns, and Rows""; ""The Information Principle""; ""Datatypes""; ""Keys""; ""Missing Information and Null Values""; ""Constraint Checking""; ""Predicates and Propositions""; ""Relational Data Structure Terms Review""; ""1.6 Relational Operators""; ""1.7 How Relational Is My DBMS?""; ""1.8 The Oracle Software Environment""; ""1.9 Case Tables""; ""The ERM Diagram of the Case""; ""Table Descriptions"" ; ""Chapter 2: Introduction to SQL and SQL Developer""""2.1 Overview of SQL""; ""Data Definition""; ""Data Manipulation and Transactions""; ""Retrieval""; ""Security""; ""Privileges and Roles""; ""GRANT and REVOKE""; ""2.2 Basic SQL Concepts and Terminology""; ""Constants (Literals)""; ""Variables""; ""Operators, Operands, Conditions, and Expressions""; ""Arithmetic Operators""; ""The Alphanumeric Operator: Concatenation""; ""Comparison Operators""; ""Logical Operators""; ""Expressions""; ""Functions""; ""Database Object Naming""; ""Comments""; ""Reserved Words"" ; ""2.3 Introduction to SQL Developer""""Installing and Configuring SQL Developer""; ""Connecting to a Database""; ""Exploring Objects""; ""Schema Browser""; ""Entering Commands""; ""Browsing table data""; ""Run Statement""; ""Run Script""; ""Saving Commands to a Script""; ""Running a Script""; ""Exporting Your Data""; ""User-Defined Reports""; ""Tuning Your SQL""; ""Writing PL/SQL""; ""Running PL/SQL Code for Testing""; ""Debugging Code to Find Errors""; ""Data Modeller""; ""Chapter 3: Data Definition, Part I""; ""3.1 Schemas and Users""; ""3.2 Table Creation""; ""3.3 Datatypes"" ; ""Number Datatype""""Character Datatype""; ""Date Datatype""; ""3.4 Commands for Creating the Case Tables""; ""3.5 The Data Dictionary""; ""Chapter 4: Retrieval: The Basics""; ""4.1 Overview of the SELECT Command""; ""4.2 The SELECT Clause""; ""Column Aliases""; ""The DISTINCT Keyword""; ""Column Expressions""; ""The DUAL Table""; ""Null Values in Expressions""; ""4.3 The WHERE Clause""; ""4.4 The ORDER BY Clause""; ""4.5 AND, OR, and NOT""; ""The OR Operator""; ""The AND Operator and Operator Precedence Issues""; ""The NOT Operator""; ""4.6 BETWEEN, IN, and LIKE""; ""The BETWEEN Operator"" ; ""The IN Operator""
• Sommario/riassunto: Beginning Oracle SQL is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. These tools include SQL*Plus and SQL Developer. SQL*Plus is the one tool any Oracle developer or database administrator can always count on, and it is widely used in creating scripts to automate routine tasks. SQL Developer is a powerful, graphical environment for developing and debugging queries. Oracle's is possibly the most valuable dialect of SQL from a career standpoint. Oracle's database engine is widely used in corporate environments worldwide. It is also found in many government applications. Oracle SQL implements many features not found in competing products. No developer or DBA working with Oracle can afford to be without knowledge of these features and how they work, because of the performance and expressiveness they bring to the table. Written in an easygoing and example-based style, Beginning Oracle SQL is the book that will get you started down the path to successfully writing SQL statements and getting results from Oracle Database. Takes an example-based approach, with clear and authoritative explanations Introduces both SQL and the query tools used to execute SQL statements Shows how to create tables, populate them with data, and then query that data to generate business results.
• Titolo autorizzato: Beginning Oracle SQL
• ISBN: 9781430265573; 1430265574
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Lingua di pubblicazione: Inglese
• Record Nr.: 9910300466003321
• Lo trovi qui: Univ. Federico II