Items related to Oracle SQL: Das umfassende Handbuch
Synopsis
Essential for any Oracle database developer!
If you are professionally engaged in Oracle, a comprehensive knowledge of the relevant SQL dialect is essential. Jürgen Sieben, already known to many through his books on Oracle PL/SQL and Oracle APEX, has now also updated his book to Oracle SQL. It shows you how Oracle and SQL work together and what strategies you can use to store, analyze or delete data in the database. New in the 3rd Edition: Changes in Oracle 12.2. and an analytical view section.
- Introduction, basics, reference
- Includes transaction management, rights allocation, optimization
- Advanced SQL functionality, SQL/XML, analytical functions, database modeling
From the contents:
- Relational Database Concept
- Fundamentals: selection and projection
- Read data from multiple tables: joins
- Line functions, group functions, analytical functions.
- Subqueries
- Data Manipulation
- Create views, tables and indexes
- Introduction to Oracle Rights Management
- Hierarchical queries and XML queries
- The Model Clause
- Row Pattern Matching
- Pivoting and Query Tables
- Work with large data structures
- Performance optimization of SQL queries
- Normalization of data models
- Common Data Modeling Errors
- Manage Parameters
- Multilingual data
"synopsis" may belong to another edition of this title.
(No Available Copies)
Search Books: Create a WantCan't find the book you're looking for? We'll keep searching for you. If one of our booksellers adds it to AbeBooks, we'll let you know!
Create a Want
