skip to content
Beginning Oracle SQL Preview this item
ClosePreview this item
Checking...

Beginning Oracle SQL

Author: Lex De Haan; Tim Gorman; Inger Jørgensen; Melanie Caffrey
Publisher: Berkeley, CA : Apress : Imprint : Apress, 2014.
Edition/Format:   eBook : Document : EnglishView all editions and formats
Database:WorldCat
Summary:
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  Read more...
Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

 

Find a copy online

Links to this item

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Genre/Form: Electronic books
Additional Physical Format: Printed edition:
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Lex De Haan; Tim Gorman; Inger Jørgensen; Melanie Caffrey
ISBN: 9781430265573 1430265574 9781430265566 1430265566
OCLC Number: 876884026
Description: 1 online resource (XXII, 403 pages 89 illustrations) : online resource
Contents: At a Glance; 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 RowsThe 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 TestingDebugging 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 IssuesThe NOT Operator; 4.6 BETWEEN, IN, and LIKE; The BETWEEN Operator; The IN Operator; The LIKE Operator; 4.7 CASE Expressions; 4.8 Subqueries; The Joining Condition; When a Subquery Returns Too Many Values; Comparison Operators in the Joining Condition; When a Single-Row Subquery Returns More Than One Row; 4.9 Null Values; Null Value Display; The Nature of Null Values; The IS NULL Operator; Null Values and the Equality Operator; Null Value Pitfalls; 4.10 Truth Tables; 4.11 Exercises; Chapter 5: Retrieval: Functions; 5.1 Overview of Functions.
Responsibility: by Lex De Haan, Tim Gorman, Inger Jørgensen, Melanie Caffrey.
More information:

Abstract:

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 SQLfrom 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.

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/876884026> # Beginning Oracle SQL
    a schema:CreativeWork, schema:Book, schema:MediaObject ;
    library:oclcnum "876884026" ;
    library:placeOfPublication <http://id.loc.gov/vocabulary/countries/xxu> ;
    schema:about <http://experiment.worldcat.org/entity/work/data/889214638#Topic/sql_computer_program_language> ; # SQL (Computer program language)
    schema:about <http://experiment.worldcat.org/entity/work/data/889214638#Topic/database_management> ; # Database management
    schema:about <http://dewey.info/class/004/e23/> ;
    schema:about <http://experiment.worldcat.org/entity/work/data/889214638#Topic/computer_science> ; # Computer science
    schema:about <http://experiment.worldcat.org/entity/work/data/889214638#Topic/oracle_computer_file> ; # Oracle (Computer file)
    schema:author <http://experiment.worldcat.org/entity/work/data/889214638#Person/haan_lex_de> ; # Lex De Haan
    schema:author <http://experiment.worldcat.org/entity/work/data/889214638#Person/gorman_tim> ; # Tim Gorman
    schema:author <http://experiment.worldcat.org/entity/work/data/889214638#Person/jorgensen_inger> ; # Inger Jørgensen
    schema:author <http://experiment.worldcat.org/entity/work/data/889214638#Person/caffrey_melanie> ; # Melanie Caffrey
    schema:bookFormat schema:EBook ;
    schema:datePublished "2014" ;
    schema:description "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 SQLfrom 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."@en ;
    schema:description "At a Glance; 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."@en ;
    schema:exampleOfWork <http://worldcat.org/entity/work/id/889214638> ;
    schema:genre "Electronic books"@en ;
    schema:inLanguage "en" ;
    schema:isSimilarTo <http://worldcat.org/entity/work/data/889214638#CreativeWork/> ;
    schema:name "Beginning Oracle SQL"@en ;
    schema:productID "876884026" ;
    schema:url <http://public.eblib.com/choice/publicfullrecord.aspx?p=1694228> ;
    schema:url <http://dx.doi.org/10.1007/978-1-4302-6557-3> ;
    schema:url <http://proquest.safaribooksonline.com/9781430265566> ;
    schema:workExample <http://worldcat.org/isbn/9781430265573> ;
    schema:workExample <http://dx.doi.org/10.1007/978-1-4302-6557-3> ;
    schema:workExample <http://worldcat.org/isbn/9781430265566> ;
    wdrs:describedby <http://www.worldcat.org/title/-/oclc/876884026> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/889214638#Person/caffrey_melanie> # Melanie Caffrey
    a schema:Person ;
    schema:familyName "Caffrey" ;
    schema:givenName "Melanie" ;
    schema:name "Melanie Caffrey" ;
    .

<http://experiment.worldcat.org/entity/work/data/889214638#Person/gorman_tim> # Tim Gorman
    a schema:Person ;
    schema:familyName "Gorman" ;
    schema:givenName "Tim" ;
    schema:name "Tim Gorman" ;
    .

<http://experiment.worldcat.org/entity/work/data/889214638#Person/haan_lex_de> # Lex De Haan
    a schema:Person ;
    schema:familyName "Haan" ;
    schema:givenName "Lex De" ;
    schema:name "Lex De Haan" ;
    .

<http://experiment.worldcat.org/entity/work/data/889214638#Person/jorgensen_inger> # Inger Jørgensen
    a schema:Person ;
    schema:familyName "Jørgensen" ;
    schema:givenName "Inger" ;
    schema:name "Inger Jørgensen" ;
    .

<http://experiment.worldcat.org/entity/work/data/889214638#Topic/database_management> # Database management
    a schema:Intangible ;
    schema:name "Database management"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/889214638#Topic/oracle_computer_file> # Oracle (Computer file)
    a schema:Intangible ;
    schema:name "Oracle (Computer file)"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/889214638#Topic/sql_computer_program_language> # SQL (Computer program language)
    a schema:Intangible ;
    schema:name "SQL (Computer program language)"@en ;
    .

<http://worldcat.org/isbn/9781430265566>
    a schema:ProductModel ;
    schema:isbn "1430265566" ;
    schema:isbn "9781430265566" ;
    .

<http://worldcat.org/isbn/9781430265573>
    a schema:ProductModel ;
    schema:isbn "1430265574" ;
    schema:isbn "9781430265573" ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.