Author Description

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 That Gives You The Strongest Possible Starting Point, No Matter What Your Endeavor. Oracle Database Foundations Provides Essential Knowledge About Installing, Configuring, Maintaining, And Querying Oracle 9i And 10g Databases. What You Learn Here Will Benefit You In The Short Term, As You 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;