ebook ebooks e-book e-books downloaden bei MyEbooks.ch downloaden

Beginning Oracle SQL

:	Lex deHaan, Karen Morton, Tim Gorman, Inger Jorgensen, Daniel Fink, Andrew Morton
:	Beginning Oracle SQL
:	Apress
:	9781430271963
:	1
:	CHF 35.80
:

:	Allgemeines, Lexika
:	English

:	459
:	Wasserzeichen/DRM
:	PC/MAC/eReader/Tablet
:	PDF

Beginning Oracle SQL is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. The book is a revision of the classicMastering Oracle SQL and SQL*Plus byLex de Haan, and has been updated to cover developments in Oracle's version of the SQL query language. 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
Introduc s 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

Lex de Haan studied applied mathematics at the University of Technology in Delft, the Netherlands. His experience with Oracle goes back to the mid-1980s, version 4. He worked for Oracle Corporation from 1990 to 2004 in various education-related roles, ending up in Server Technologies (product development) as senior curriculum manager for the advanced database administration curriculum. In that role, he was involved in the development of Oracle9i and Oracle Database 10g. In March 2004, he decided to go independent and founded Natural Join B.V. (http://www.naturaljoin.nl). From 1999 until his passing in 2006, he was involved in the ISO SQL language standardization process, as a member of the Dutch national body. He was also one of the founding members of the OakTable network (http://www.oaktable.net).

	Titlte Page	1
	Copyright Page	2
	Contents at a Glance	3
	Table of Contents	4
	About the Authors	17
	Acknowledgments	19
	Introduction	21
	About this Book	21
	About the Chapters of this Book	22
	About the Case Tables	23
	Chapter 1: Relational Database Systems and Oracle	24
	1.1 Information Needs and Information Systems	24
	1.2 Database Design	25
	Entities and Attributes	25
	Generic vs. Specific	26
	Redundancy	27
	Consistency, Integrity, and Integrity Constraints	28
	Data Modeling Approach, Methods, and Techniques	29
	Semantics	30
	Information Systems Terms Review	30
	1.3 Database Management Systems	30
	DBMS Components	31
	Kernel	31
	Data Dictionary	31
	Query Languages	31
	DBMS Tools	32
	Database Applications	32
	DBMS Terms Review	32
	1.4 Relational Database Management Systems	33
	1.5 Relational Data Structures	33
	Tables, Columns, and Rows	34
	The Information Principle	35
	Datatypes	35
	Keys	35
	Missing Information and Null Values	36
	Constraint Checking	37
	Predicates and Propositions	37
	Relational Data Structure Terms Review	37
	1.6 Relational Operators	38
	1.7 How Relational Is My DBMS?	39
	1.8 The Oracle Software Environment	40
	1.9 Case Tables	42
	The ERM Diagram of the Case	42
	Table Descriptions	44
	Chapter 2: Introduction to SQL, AQL*Plus, and SQL Developer	48
	2.1 Overview of SQL	48
	Data Definition	49
	Data Manipulation and Transactions	49
	Retrieval	50
	Security	52
	Privileges and Roles	52
	GRANT and REVOKE	54
	2.2 Basic SQL Concepts and Terminology	55
	Constants (Literals)	55
	Variables	57
	Operators, Operands, Conditions, and Expressions	57
	Arithmetic Operators	58
	The Alphanumeric Operator: Concatenation	58
	Comparison Operators	58
	Logical Operators	59
	Expressions	59
	Functions	60
	Database Object Naming	61
	Comments	62
	Reserved Words	62
	2.3 Introduction to SQL*Plus	62
	Entering Commands	63
	Using the SQL Buffer	64
	Using an External Editor	65
	Using the SQL*Plus Editor	66
	Using SQL Buffer Line Numbers	69
	Using the Ellipsis	71
	SQL*Plus Editor Command Review	71
	Saving Commands	72
	Running SQL*Plus Scripts	74
	Specifying Directory Path Specifications	75
	Adjusting SQL*Plus Settings	76
	Spooling a SQL*Plus Session	79
	Describing Database Objects	80
	Executing Commands from the Operating System	80
	Clearing the Buffer and the Screen	80
	SQL*Plus Command Review	80
	2.4 Introduction to SQL Developer	81
	Installing and Configuring SQL Developer	81
	Connecting to a Database	84
	Exploring Objects	85
	Entering Commands	86
	Run Statement	87
	Run Script	88
	Saving Commands to a Script	89
	Running a Script	90
	Chapter 3: Data Definition, Part I	93
	3.1 Schemas and Users	93
	3.2 Table Creation	94
	3.3 Datatypes	95
	3.4 Commands for Creating the Case Tables	97
	3.5 The Data Dictionary	99
	Chapter 4: Retrieval: The Basics	104
	4.1 Overview of the SELECT Command	104
	4.2 The SELECT Clause	106
	Column Aliases	107
	The DISTINCT Keyword	108
	Column Expressions	108
	The DUAL Table	109
	Null Values in Expressions	111
	4.3 The WHERE Clause	111
	4.4 The ORDER BY Clause	112
	4.5 AND, OR, and NOT	115
	The OR Operator	115
	The AND Operator and Operator Precedence Issues	116