• Reduced price
Oracle Database 12C: The Complete Reference by Byrla Book-9789351343707
  • Oracle Database 12C: The Complete Reference by Byrla Book-9789351343707

Oracle Database 12C: The Complete Reference

₹1,699.00
₹1,100.00 Save ₹599.00
Book Title: Oracle Database 12C: The Complete Reference
Author: Byrla
ISBN-13: 9789351343707
Publication: McGraw Hill Education
Quantity
Available

  • COD Available. Delivery Time 4 - 7 Working Days in India. COD Available. Delivery Time 4 - 7 Working Days in India.
  • For General Enquiries WhatsApp 7200833323 (Chat Support) For General Enquiries WhatsApp 7200833323 (Chat Support)
  • Trusted by over 100K+ customers Trusted by over 100K+ customers

Overview of Oracle Database 12C: The Complete Reference Book

Maintain a scalable, highly available enterprise platform and reduce complexity by leveraging the powerful new tools and cloud enhancements of Oracle Database 12c. This authoritative Oracle Press guide offers complete coverage of installation, configuration, tuning and administration. Find out how to build and populate Oracle databases, perform effective queries, design applications and secure your enterprise data. Oracle Database 12c: The Complete Reference also contains a comprehensive appendix covering commands, keywords, features and functions. Set up Oracle Database 12c or upgrade from an earlier version. Design Oracle databases and plan for application implementation. Construct SQL and SQL*Plus statements and execute powerful queries. Secure data with roles, privileges, visualization and encryption. Move data with SQL*Loader and Oracle Data Pump. Restore databases using flashback and the Oracle Database Automatic Undo Management feature. Build and deploy PL/SQL triggers, procedures and packages. Work with Oracle pluggable and container databases. Develop database applications using Java, JDBC and XML. Optimize performance with Oracle Real Application Clusters.Table of Contents: Part I: Critical Database ConceptsOracle Database 12c Architecture Options Installing Oracle Database 12c and Creating a Database Upgrading to Oracle Database 12c Planning Oracle Applications - Approaches, Risks and Standards Part II: SQL and SQL*PlusThe Basic Parts of Speech in SQL Basic SQL*Plus Reports and Commands Getting Text Information and Changing It Searching for Regular Expressions Playing the Numbers Dates: Then, Now and the Difference Conversion and Transformation Functions Grouping Things Together When One Query Depends on Another Some Complex Possibilities Changing Data: Insert, Delete, Update and Merge Decode and Case: If, Then and Else In Sql Creating and Managing Tables, Views, Indexes, Clusters and Sequences Partitioning Basic Oracle Security Part III: Beyond the Basics Advanced Security - Virtual Private Databases Advanced Security - Transparent Data Encryption Working with Table spaces Using SQL*Loader to Load Data Using Data Pump ExpoPart and ImpoPart Accessing Remote Data Using Materialized Views Using Oracle Text for Text Searches Using External Tables Using Flashback Queries Flashback - Tables and Databases SQL Replay Part IV: PL/SQL An Introduction to PL/SQL Online Application Upgrades Triggers Procedures, Functions and Packages Using Native Dynamic SQL and DBMS_SQL PL/SQL Tuning Part V: Object-Relational Databases Implementing Object Types, Object Views and Methods Collectors (Nested Tables and Varying Arrays) Using Large Objects Advanced Object-Oriented Concepts Part VI: Java in Oracle An Introduction to Java JDBC Programming Java Stored Procedures Part VII: Hitchhiker's Guides The Hitchhiker's Guide to the Oracle Data Dictionary The Hitchhiker's Guide to Tuning Applications and SQL The Hitchhiker's Guide to SQL Result Cache and Client-Side Query Cache Case Studies in Tuning The Hitchhiker's Guide to Pluggable Databases The Hitchhiker's Guide to Oracle Real Application Clusters The Hitchhiker's Guide to Database Administration The Hitchhiker's Guide to XML in Oracle Part VIII: Alphabetical Reference

  • Book Type :

ComputerScience

Book Binding :

Paperback

Language :

English

Number of Pages :

1468 pages

<h2 style="font-size:14px;colo

BKDPSBU_9789351343707
2017-11-12
New product

Reviews

Write your review

Oracle Database 12C: The Complete Reference

Book Title: Oracle Database 12C: The Complete Reference
Author: Byrla
ISBN-13: 9789351343707
Publication: McGraw Hill Education

Write your review