Oracle SQL & PL/SQL H&book: A Guide for Data Administrators Developers & Bus…

Description: About this productSynopsisOracle SQL and PL/SQL Handbook is designed as both a basic reference as well as a how-to guide. It offers thorough coverage of Oracle's SQL query language and PL/SQL programming language. It focuses on the practical aspects of using SQL and PL/SQL to most effectively extract usable information from Oracle systems. Thus it is of use not only to database administrators, but also to business managers, developers, and power users. the book's initial chapters offer a complete introduction to the relational database environment, including a discussion of how to use the logical data model to understand the database. From there, Oracle database objects are covered, along with uses of the Data Definition Language (DDL), the Data Control Language (DCL), and the Data Manipulation Language (DML). Throughout the book frequently used commands and content are stressed, and numerous examples of SQL techniques are provided. In addition, most of the book's chapters provide practice questions designed to reinforce concepts covered.Product IdentifiersISBN-100201752948ISBN-139780201752946eBay Product ID (ePID)2289129Key DetailsAuthorJohn Adolph PalinskiNumber Of Pages528 pagesFormatPaperbackPublication Date2002-08-08LanguageEnglishPublisherAddison Wesley ProfessionalPublication Year2002Additional DetailsCopyright Date2003IllustratedYesDimensionsWeight30.4 OzHeight1.2 In.Width7.2 In.Length8.9 In.Target AudienceGroupScholarly & ProfessionalClassification MethodLCCN2002-023208LC Classification NumberQA76.73.S67P35 2002Dewey Decimal005.75/65Dewey Edition21Table Of ContentIntroduction. What is Oracle? Who Should Use This Book? How is this Book Organized? Conventions. Other Sources of Information. Installing the Practice Database and Tools. What Software to Get? How to Get the Software? Setting Up Personal Oracle. Installing the Practice Tables. What's Next. 1. Understanding Relational DatabasesThe Entity Relationship Diagram, Database Schema Diagram, and Normalization. Entities and Attributes. Entity Relationship Diagram Concepts. Ordinality and Cardinality. Keys and Joins. Creating an Entity Relationship Drawing. Identifying the Major Entities. Defining the Identifiers. Defining the Relationships, Cardinality, and Ordinality. Defining Descriptive Attributes. Creating the Entity Relationship Diagram. Converting the Entity Relationship Diagram to a Relational Model. Conversion to the Relational Model. Normalization. The Data Schema Diagram. Table Relationship Drawing. Employee Database Table Relationship Drawing. What's Next. Practice. 2. Building the Database with the Data Definition Language. Logging On to SQL*PLUS. Entering A Command. Using The SQL*PLUS Editor. Menu Commands. Database Objects That Store Data. The Desk Analogy. Tablespaces. Creating and Modifying Tables. Indexes. Maintaining the Integrity of the Database. Synonyms and Other Nice Things. Oracle Object-Oriented Features. User-defined Data Types (ADTs). Collection Types. Toad. What's Next. Practice. 3. The Data Control and Data Manipulation Languages and the Data Dictionary. Creating User Accounts. Data Control Language. Roles. Revoking Privileges. Privileges. Granting Access to Your Tables and Database Objects. The Data Manipulation Language (DML). Using the INSERT Command. Inserting Records from Another Table. Using the UPDATE Command. Deleting Records. The COMMIT and ROLLBACK Commands. The TRUNCATE Command. Oracle's Data Dictionary. The User_objects and All_objects Views. Reviewing PL/SQL Code Blocks with User_source. What's Next. Practice. 4. Retrieving Database Records Using SQLThe Select, Where, and Order By Clauses. Identifying Table and Column Names. Making a Simple Database Query. Components of a Simple Select. Examples of Simple Select Statements. End listing. Computing numeric values in the Select clause. Limiting the Database Records Retrieved. Evaluation Operators Used In The WHERE Clause. Using the Equal (=) and Is Operators. Using the Greater Than (>) and Less Than ( Using the In Operator. Any, Some, or All Keywords. Using the Between Operator. Using the Like Operator. Using And/ Or To Document Multiple Conditions. Mixing AND/OR in the Where Clause. Ordering Records. Ascending/Descending Order. Using Expression Numbers as the Names of Sort Columns. Printing the Results of Your Query. What's Next. Practice. 5. Retrieving Records Using SQLThe From, Group By,

Price: 159.84 USD

Location: Multiple Locations

End Time: 2024-11-17T15:36:46.000Z

Shipping Cost: 3.97 USD