Oracle SQL: Das umfassende Handbuch - Hardcover

Hardcover

ISBN 10: 3836262428 ISBN 13: 9783836262422

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

Edition details

• Language: German
• ISBN 10: 3836262428
• ISBN 13: 9783836262422
• Binding: Hardcover
• Edition number: 3