Oracle database 12c: the complete reference

    4
    99 orders In stock
    ₹1699 ₹1461

    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 Concepts Oracle 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*Plus The 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

    Writer Name
    Byrla
    Type:
    Business And Investment
    Language
    English
    Book Cover
    Paperback

    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 Concepts Oracle 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*Plus The 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

    Other Sellers