Oracle database foundations
The world of IT is always evolving, but in every area there are stable, core concepts that anyone just setting out needed to know last year, needs to know this year, and will still need to know next year. The purpose of the Foundations series is to identify these concepts and present them in a way t...
| Main Author: | |
|---|---|
| Format: | eBook |
| Language: | Inglés |
| Published: |
San Francisco ; London :
SYBEX
c2004.
|
| Edition: | 1st edition |
| Subjects: | |
| See on Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627581706719 |
Table of Contents:
- Oracle Database Foundations; Front matter; Acknowledgments; Contents; Introduction; Chapter 1: Relational Database Concepts; Are Spreadsheets Like Databases?; Relational Databases; Tables, Rows, and Columns; Primary Keys, Datatypes, and Foreign Keys; Data Modeling; Object-Relational Databases; Abstraction; Methods and Encapsulation; Inheritance; Object-Relational Support; Terms to Know; Review Questions; Chapter 2: SQL*Plus and iSQL* Plus Basics; Some SQL Formalities; Tools for Running SQL; SQL*Plus; iSQL*Plus; SQL*Plus Worksheet; Third-Party Tools; ODBC/JDBC; OCI
- The Ubiquitous SELECT Statement Column Specification; Column Renaming; Duplicate Removal; Expressions; DML for Making Changes; The UPDATE Statement; The INSERT Statement; The DELETE Statement; The MERGE Statement; DDL for Handling Database Objects; The CREATE Statement; The ALTER Statement; The DROP Statement; The RENAME Statement; The TRUNCATE Statement; DCL for Handling Privileges; The GRANT Statement; The REVOKE Statement; Terms to Know; Review Questions; Chapter 3: Oracle Database Functions; Query Basics; The DUAL Table; NULLs: What, When, Why, and How
- String Literals and Concatenating Strings Numeric Literals; Operators and Operator Precedence; Built-In Single-Row Functions; String Functions; Numeric Functions; Date Functions; Conversion Functions; General Functions; User-Defined Functions; Terms to Know; Review Questions; Chapter 4: Restricting, Sorting, and Grouping Data; The WHERE Clause; Comparison Conditions; AND, OR, and NOT; BETWEEN, IN, and LIKE; IS NULL and IS NOT NULL; The ORDER BY Clause; Group Functions and the GROUP BY Clause; Group Functions; The GROUP BY Clause; Using NVL with Group Functions; The HAVING Clause; Terms to Know
- Review Questions Chapter 5: Using Multiple Tables; Join Syntax: Out with the Old and In with the New (SQL:1999); Equijoins; Pre-Oracle9i Equijoin Syntax; Oracle9i Equijoin Syntax; Non-equijoins; Pre-Oracle9i Non-equijoin Syntax; Oracle9i Non-equijoin Syntax; Outer Joins; Pre-Oracle9i Outer Join Syntax; Oracle9i Outer Join Syntax; Self-Joins; Pre-Oracle9i Self-Join Syntax; Oracle9i Self-Join Syntax; Cartesian Products: The Black Sheep of the Family; Pre-Oracle9i Cartesian Product Syntax; Oracle9i Cartesian Product Syntax; Terms to Know; Review Questions; Chapter 6: Advanced SQL Queries
- Subqueries Single-Row Subqueries; Multiple-Row Subqueries; Correlated Subqueries; Multiple-Column Subqueries; Set Operators; UNION and UNION ALL; INTERSECT; MINUS; ROLLUP and CUBE; ROLLUP; CUBE; Terms to Know; Review Questions; Chapter 7: Logical Consistency; Constraints; NOT NULL; CHECK; UNIQUE; PRIMARY KEY; FOREIGN KEY; Transaction Processing; The COMMIT Statement; The ROLLBACK Statement; The SAVEPOINT Statement; Terms to Know; Review Questions; Chapter 8: Installing Oracle and Creating a Database; Oracle Components Overview; Logical Storage Structures; Physical Storage Structures
- Oracle Memory Structures
