Beginning Oracle SQL For Oracle Database 12c
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 creati...
| Autores principales: | , , , |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Berkeley, CA :
Apress
2014.
|
| Edición: | 3rd ed. 2014. |
| Colección: | The expert's voice in Oracle
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629386306719 |
Tabla de Contenidos:
- ""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""
