Your cart is empty
Now you can master the latest version of the fundamental SQL language used in all relational databases today with ORACLE 12C: SQL, 3E. Much more than a study guide, this edition helps you transform a basic knowledge of databases into proficiency with the latest SQL and Oracle concepts and techniques. You learn to use Oracle 12c SQL most effectively as you prepare for the first exam in the Oracle Database Administrator or Oracle Developer Certification Exam paths. This edition initially focuses on creating database objects, including tables, constraints, indexes, sequences, manipulating data, and more. The author then explores both basic data query techniques as well as advanced query topics using a proven hands-on approach. ORACLE 12C: SQL, 3E introduces the latest features and enhancements in 12c, from enhanced data types and invisible columns to new CROSS and OUTER APPLY methods for joins. To help you transition to further studies and even more advanced books in this series, appendixes introduce SQL tuning, compare Oracle's SQL syntax with other databases, and overview Oracle connection interface tools: SQL Developer and SQL Plus. Trust ORACLE 12C: SQL, 3E to provide the knowledge you need for Oracle certification testing and the solid foundation for pursuing a career as a database administrator or developer.
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Achieve Extreme Application Performance for a Private Cloud with Oracle Exalogic Elastic Cloud Transition to a private cloud computing infrastructure and achieve unmatched levels of performance with help from this Oracle Press guide. Oracle Exalogic Elastic Cloud Handbook shows you how to plan, implement, and maintain a private cloud. Find out how to set up components, deploy Java applications, maximize redundancy and throughput, and migrate legacy workloads. Examples, screenshots, and diagrams are included throughout this comprehensive resource. Configure Oracle Exalogic Elastic Cloud nodes and racks Optimize Java EE application performance on Oracle WebLogic Server Provision and administer a highly scalable private cloud Build, debug, and manage custom Java applications Secure, monitor, and tune using Oracle Enterprise Manager Leverage capabilities from Oracle Fusion Middleware Consolidate Oracle and third-party application workloads
Learn how to most effectively use PL/SQL programming language with one of the most popular and widely-used software programs in large companies today -- Oracle (R)11g. ORACLE (R) 11G: PL/SQL PROGRAMMING & ORACLE (R) CD, 2E, International Edition uses Oracle (R) 11g to provide an overview of the PL/SQL programming language from a developer's perspective. The author begins with a step-by-step expanded introduction to fundamental PL/SQL concepts before progressing to the writing and testing of PL/SQL code. This edition also covers more advanced topics, such as Dynamic SQL and code tuning, as well as developments in bulk processing, compound triggers, PL/SQL compiler features and hiding source code. Updates reflect the latest Oracle (R) 11g release with the most recent figures and examples using the user-friendly SQL Developer tool. A wealth of real-world examples, a straightforward presentation, and accompanying Oracle (R) CD make this book is an invaluable resource in preparing for the new Oracle (R) Certification exam or mastering the PL/SQL programming language with Oracle (R).
The Most Complete Guide to Maximizing Oracle Recovery Manager Deploy a rock-solid data backup and disaster recovery strategy with the in-depth guidance of this authoritative volume. From the exclusive publishers of Oracle Press books, Oracle Database 10g RMAN Backup & Recovery shows you, step by step, how to set up RMAN-ready databases, create reliable backup tapes and discs, and perform accurate Oracle system restores. Find out how to use RMAN from the command line and from Enterprise Manager, generate meaningful lists and reports, and automate administrative tasks using third-party media management tools. Plus, you'll learn to perform incremental backups, Flashback recoveries, and database cloning. Set up, configure, and maintain Oracle Database 10g RMAN Use RMAN recovery catalogs, target database packages, and control files Centralize backup tape management using Oracle Secure Backup Perform online, offline, and incremental system backups Monitor and tune performance with Enterprise Manager Grid Control and Database Control Accomplish complete and partial RMAN database restores Improve functionality using VERITAS NetBackup, EMC NetWorker Module, and Tivoli Storage Manager Overcome human errors using Flashback Versions Query and Transaction Query Create clone and standby databases from tape and disc backups Work with Real Application Cluster (RAC) databases and sync-and-split hardware technologies
YOUR ON-THE-JOB QUICK REFERENCE.
. Carry essential Oracle Database administration information and
troubleshooting techniques along with you so you can handle a wide
variety of tasks on the spot. This handy resource offers fast
access to administrative commands, error resolutions, best
practices, and more. Written by an Oracle expert and published by
Oracle Press, this convenient reference gives you quick solutions
in an easy-to-find format. Don't leave your desk without it! Get
details on: .
From the exclusive publishers of Oracle Press Books, here is the only book available offering complete coverage of RMAN (Recovery Manager), Oracle’s free backup and recovery technology. An indispensable resource for new Oracle users, database administrators, and system administrators.
"Learn cutting-edge technology from Oracle experts"
Written by Oracle insiders, this comprehensive guide covers everything you need to know about Real Application Clusters -- low-cost hardware platforms that can rival and exceed the quality of service, availability, and scalability of the most expensive mainframe systems. Concepts covered are applicable to all previous versions of Oracle Tuning and troubleshooting tips, providing insight on the most advanced diagnostics available Detailed coverage of advanced RAC concepts Working code for all examples available online
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Master Oracle Database 12c PL/SQL Application DevelopmentDevelop, debug, and administer robust database programs. Filled with detailed examples and expert strategies from an Oracle ACE, Oracle Database 12c PL/SQL Programming explains how to retrieve and process data, write PL/SQL statements, execute effective queries, incorporate PHP and Java, and work with dynamic SQL. Code testing, security, and object-oriented programming techniques are fully covered in this comprehensive Oracle Press guide. Explore new SQL and PL/SQL features in Oracle Database 12c Build control structures, cursors, and loop statements Work with collections, varrays, tables, and associative array collections Locate and repair errors and employ exception handlers Execute black box, white box, and integration tests Configure and manage stored packages and libraries Handle security with authentication and encryption Use LOBs to store text and multimedia content Write and implement PL/SQL and Java triggers Extend functionality using dynamic SQL statements Understand object types, nested tables, and unnesting queries
This Oracle Press certification exam guide prepares you for the new Oracle Database 12c certification track, including the core requirements for OCA and OCP certification. OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063) covers all of the exam objectives on the Installation and Administration, SQL Fundamentals, and Advanced Administration exams in detail. Each chapter includes examples, practice questions, Inside the Exam sections highlighting key exam topics, a chapter summary, and a two-minute drill to reinforce essential knowledge. 300+ practice exam questions match the format, topics, and difficulty of the real exam. Electronic content includes interactive practice exam software with hundreds of questions that include detailed answers and explanations, a score report performance assessment tool, and a PDF copy of the bookIdeal as both exam guide and on-the-job referenceThe most comprehensive single preparation tool for the Oracle Database 12c OCA and OCP certification exams
ORACLE 11G: SQL is not simply a study guide; it is written for individuals who have just a basic knowledge of databases and can be utilized in a course on this latest implementation of SQL from Oracle.
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Master the Fundamentals of Oracle Database 12cFilled with easy-to-follow tutorials, this Oracle Press guide provides detailed coverage of core database concepts, the role of the administrator, and enterprise database capabilities. Oracle Database 12c: Install,Configure & Maintain Like a Professional walks you through database configuration, administration, programming, backup and recovery, and high availability. You'll get in-depth introductions to SQL and PL/SQL as well as important information on managing large databases and using Oracle's engineered systems. This essential beginner's resource features: Critical Skills--Lists of specific skills covered in each chapter Projects--Practical exercises that show how to apply the critical skills learned in each chapter Progress Checks--Quick self-assessment sections to check your progress Ask the Expert--Q&A sections filled with helpful tips Notes--Extra information related to the topic being covered Mastery Checks--Chapter-ending quizzes to test your knowledge
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Master Oracle Enterprise Manager 10g Grid ControlCentralize and simplify enterprise infrastructure administration using the detailed information contained in this Oracle Press guide. Oracle Enterprise Manager 10g Control Handbook shows you how to implement a grid-based management system and maintain on-demand access to critical services. Develop rollout plans, configure hardware and software, deploy targets and agents, control access, and distribute business reports. This authoritative resource also explains how to generate reliable backups, implement top-down performance monitoring, and maximize system availability. Plan and carry out an Oracle Enterprise Manager 10g Grid Control rollout Set up customized metrics, alerts, thresholds, targets, and agents Manage IT resources from a centralized control console or the command line Manage your infrastructure using secure protocols Automate administrative tasks with Oracle's management agent Distribute business intelligence using the reporting and dashboard features Work with Oracle Enterprise Manager Database Control and Oracle Real Application Clusters Build physical and logical standby databases using Oracle Data Guard
This new edition of Understanding Oracle APEX 5 Application Development shows APEX developers how to build practical, non-trivial web applications. The book introduces the world of APEX properties, explaining the functionality supported by each page component as well as the techniques developers use to achieve that functionality. The book is targeted at those who are new to APEX and just beginning to develop real projects for production deployment. Reading the book and working the examples will leave you in a good position to build good-looking, highly-functional, web applications. Topics include: conditional formatting, user-customized reports, data entry forms, concurrency and lost updates, and updatable reports. Accompanying the book is a demo web application that illustrates each concept mentioned in the book. Specific attention is given in the book to the thought process involved in choosing and assembling APEX components and features to deliver a specific result. Understanding Oracle APEX 5 Application Development is the ideal book to take you from an understanding of the individual pieces of APEX to an understanding of how those pieces are assembled into polished applications. Teaches how to develop non-trivial APEX applications. Provides deep understanding of APEX functionality. Shows the techniques needed for customization.
Demystifying the power of the Oracle 12c database The Oracle database is the industry-leading relational database management system (RDMS) used from small companies to the world s largest enterprises alike for their most critical business and analytical processing. Oracle 12c includes industry leading enhancements to enable cloud computing and empowers users to manage both Big Data and traditional data structures faster and cheaper than ever before. Oracle 12c For Dummies is the perfect guide for a novice database administrator or an Oracle DBA who is new to Oracle 12c. The book covers what you need to know about Oracle 12c architecture, software tools, and how to successfully manage Oracle databases in the real world. * Highlights the important features of Oracle 12c * Explains how to create, populate, protect, tune, and troubleshoot a new Oracle database * Covers advanced Oracle 12c technologies including Oracle Multitenant the "pluggable database" concept as well as several other key changes in this release Make the most of Oracle 12c's improved efficiency, stronger security, and simplified management capabilities with Oracle 12c For Dummies.
An updated guide for an updated certification exam! As the most popular database software in the world, Oracle Database 12c has been updated for the first time in nearly six years and the changes are significant. This study guide reviews how Oracle 12c allows multiple instances to be used simultaneously via the cloud. You'll sharpen your skills to prepare for the three levels of certification: Oracle Certified Associate, Oracle Certified Professional, and Oracle Certified Master. Workbook exercise appendix, test engine, chapter review questions, electronic flashcards, searchable PDF glossary, and two bonus practice exams all help to enhance your preparation to take the Oracle 12c exam. * Addresses such topics as: database architecture, configuring and recoverability, configuring backup specifications, and performing user-managed backup and recovery * Reviews how to use RMAN to create backups, perform recovery, and duplicate a database * Looks at performing tablespace point-in-time recovery and using flashback technology * Covers diagnosing the database, managing memory, managing resources, and automating tasks Focusing 100 percent on the exam objectives, OCP: Oracle Database 12c Administrator Certified Professional Study Guide is designed for those who feel they are ready to attempt this challenging exam.
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Implement Proven Database Optimization SolutionsSystematically identify and eliminate database performance problems with help from Oracle Certified Master Richard Niemiec. Filled with real-world case studies and best practices, Oracle Database 11g Release 2 Performance Tuning Tips & Techniques details the latest monitoring, troubleshooting, and optimization methods. Find out how to find and fix bottlenecks, configure storage devices, execute effective queries, and develop bug-free SQL and PL/SQL code. Testing, reporting, and security enhancements are also covered in this Oracle Press guide. Properly index and partition Oracle Database 11g Release 2 Work with Oracle Exadata and Oracle Exalogic Elastic Cloud Efficiently manage disk drives, RAID arrays, and memory Tune queries with Oracle SQL hints and the TRACE utility Troubleshoot databases using V$ views and X$ tables Distribute workload using Oracle Real Application Testing Generate reports using Oracle's Statspack and Automatic Workload Repository tools Use sar, vmstat, and iostat to monitor system statistics "This is a timely update of Rich's classic book on Oracle Database performance tuning to cover hot new topics like Oracle Database 11g Release 2 and Oracle Exadata. This is a must-have for DBAs moving to these new products." --Andrew Mendelsohn, Senior Vice President, Oracle Database Server Technologies
Master Cloud Computing with Oracle Enterprise Manager 12"c"
Gain organizational agility, foster innovation, and lower TCO by adopting a service-oriented, cloud-based IT solution. "Building and Managing a Cloud Using Oracle Enterprise Manager 12c" thoroughly explains how to architect, configure, and manage components of a public or private cloud lifecycle. Discover how to choose the right architecture, deploy applications, govern self-service provisioning, monitor users, and implement security. This Oracle Press guide features best practices and case studies from the authors' experiences as Oracle product managers. Plan and deploy a flexible cloud infrastructure Configure Oracle Enterprise Manager 12c Self Service Portal Bundle applications using Oracle Virtual Assembly Builder Set up, manage, and monitor IaaS, PaaS, and DBaaS Meter usage and establish chargeback policies Work with large-scale clouds and enforce compliance Manage cloud service levels Diagnose and repair bottlenecks and faults
Start developing with Oracle SQL. This book is a one-stop introduction to everything you need to know about getting started developing an Oracle Database. You'll learn about foundational concepts, setting up a simple schema, adding data, reading data from the database, and making changes. No experience with databases is required to get started. Examples in the book are built around Oracle Live SQL, a freely available, online sandbox for practicing and experimenting with SQL statements, and Oracle Express Edition, a free version of Oracle Database that is available for download. A marquee feature of Beginning Oracle SQL for Oracle Database 18c is the small chapter size. Content is divided into easily digestible chunks that can be read and practiced in very short intervals of time, making this the ideal book for a busy professional to learn from. Even just a 15-20 minute block of free time can be put to good use. Author Ben Brumm begins by helping you understand what a database is, and getting you set up with a sandbox in which to practice the SQL that you are learning. From there, easily digestible chapters cover, point-by-point, the different aspects of writing queries to get data out of a database. You'll also learn about creating tables and getting data into the database. Crucial topics such as working with nulls and writing analytic queries are given the attention they deserve, helping you to avoid pitfalls when writing queries for production use. What You'll Learn Create, update, and delete tables in an Oracle database Add, update, delete data from those database tables Query and view data stored in your database Manipulate and transform data using in-built database functions and features Correctly choose when to use Oracle-specific syntax and features Who This Book Is For Those new to Oracle who are planning to develop software using Oracle as the back-end data store. The book is also for those who are getting started in software development and realize they need to learn some kind of database language. Those who are learning software development on the side of their normal job, or learning it as a college student, who are ready to learn what a database is and how to use it also will find this book useful.
Protecting Oracle Database 12c helps you solve the problem of maximizing the safety, resilience, and security of an Oracle database whilst preserving performance, availability, and integration. The book demonstrates through coded examples how to enable the consolidation features of Oracle Database 12c without increasing risk of either internal corruption or external vulnerability. In addition, new protections not publicly available are included in a task-based recipe format so that demonstrable risk improvements can be achieved, measured, and communicated to higher management. Most importantly, the challenge of privileged access control within a consolidation environment will be addressed, thus enabling a safe move to greater efficiency. * Demonstrates the securing of software and identity vulnerabilities. * Guides in implementing access controls over privileged accounts. * Helps you integrate with identity access management systems. * Provides a safe path to consolidation using the new, pluggable database feature set.
This book is the definitive reference on PL/SQL, considered throughout the database community to be the best Oracle programming book available. Like its predecessors, this 6th edition of Oracle PL/SQL Programming covers language fundamentals, advanced coding techniques, and best practices for using Oracle's powerful procedural language. Thoroughly updated for Oracle Database 12c, this edition reveals new PL/SQL features and provides extensive code samples, ranging from simple examples to complex and complete applications, in the book and on the companion website. It's an indispensable reference for both novices and experienced Oracle programmers.
Oracle security expert David Knox explains how to design and develop an integrated, secure Oracle environment.
Provides beginning DBAs and developers with a solid foundation in the database administration and programming basics needed to embark on an Oracle career. The focus is on Oracle Database 10g, but you’ll get the fundamentals applicable to all Oracle database releases.
This authorized guide from Oracle Press explains how implement all the new features of Oracle9i and manage a robust, high-performance Oracle database. Youll get new and revised material on installation, database creation, using STATSPACK, Recovery Manager, Oracle9i Application Server, external tables, flashback queries, and much more.
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Master Oracle Business Intelligence 11g Reports and DashboardsDeliver meaningful business information to users anytime, anywhere, on any device, using Oracle Business Intelligence 11g. Written by Oracle ACE Director Mark Rittman, Oracle Business Intelligence 11g Developers Guide fully covers the latest BI report design and distribution techniques. Find out how to execute effective queries, build accurate models, use scorecards and KPIs, create dynamic reports, set up dashboards, and publish tosmartphones and wireless devices. This Oracle Press guide contains comprehensive details on Oracle Exalytics In-Memory Machine, the best-in-class, preintegrated BI platform. Install or upgrade to Oracle Business Intelligence 11g Develop and manage custom Oracle Business Intelligencerepositories Access relational, file, and multidimensional data sources Design print-quality reports with Oracle Business Intelligence Publisher Create web-enabled analyses, dashboards, and visualizations Integrate with other applications using Oracle BusinessIntelligence 11g Action Framework Employ authentication, authorization, and row-level security Configure and deploy Oracle Exalytics In-Memory Machine
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Maximize Oracle Exadata CapabilitiesLeverage all of the powerful features available in the Oracle Exadata Database Machine using the proven techniques inside this Oracle Press guide. Written by Oracle experts, Achieving Extreme Performance with Oracle Exadata shows you how to take full advantage of this complete, optimized package of software, servers, and storage. Best practices for enterprise deployments, high availability, administration, backup and recovery, data warehousing, online transaction processing, consolidation, and migration are included in this authoritative resource. Take advantage of the tightly integrated hardware and software in the Oracle Exadata Database Machine Work with Oracle Exadata software features, including Smart Scans, Oracle Exadata Hybrid Columnar Compression, storage indexes, Oracle Exadata Smart Flash Cache, and I/O Resource Manager Understand Oracle Exadata Database Machine balanced hardware architecture Architect, administer, and monitor Oracle Exadata Storage Servers Deploy data warehouses on the Oracle Exadata Database Machine Run online transaction processing (OLTP) workloads on the Oracle Exadata Database Machine Consolidate databases with and migrate databases to the Oracle Exadata Database Machine
You may like...
Master Competitive Analytics with Oracle…
Helen Sun, William Smith Paperback
Oracle Internals - Tips, Tricks, and…
Donald K. Burleson Paperback R2,127 Discovery Miles 21 270
Oracle Database 12c Release 2 New…
Bob Bryla, Robert Freeman Paperback
Advanced Tuning for JD Edwards…
Michael Jacot, Allen Jacot, … Paperback
Oracle GoldenGate 11g Handbook
Robert G Freeman Paperback
Oracle Database 12c DBA Handbook
Bob Bryla Paperback
Oracle WebCenter 11g Handbook
Frederic Desbiens, Peter Moskovits, … Paperback
Oracle Essbase & Oracle OLAP - The Guide…
Michael A. Schrader, Dan Vlamis, … Paperback
Oracle E-Business Suite Development…
Anil Passi, Vladimir Ajvaz Paperback
Oracle Procure-to-Pay Guide
Melanie Anjele Cameron Paperback