› › Oca Ocp Introduction To Oracle9i Sql Study Guide

OCA / OCP: Introduction to Oracle9i SQL Study Guide

Author : Chip Dawes

Publisher : John Wiley & Sons

Page : 611 pages

File Size : 31,39 MB

Release : 2006-02-20

Category : Computers

ISBN : 0782152503

Get eBook

Book Description

Here's the book you need to prepare for Exam 1Z0-007: Introduction to Oracle9i: * In-depth coverage of official exam objectives * Practical information on using SQL in a real-world Oracle9i environment * Hundreds of challenging review questions, in the book and on the CD Authoritative coverage of all exam objectives, including: * Writing basic SQL SELECT statements * Restricting and sorting data * Displaying data from multiple tables * Aggregating data using group functions * Producing readable output with iSQL*Plus * Creating and managing tables * Controlling user access



OCA / OCP: Oracle9i DBA Fundamentals I Study Guide

Author : Biju Thomas

Publisher : John Wiley & Sons

Page : 461 pages

File Size : 11,87 MB

Release : 2006-02-20

Category : Computers

ISBN : 9780782152456

Get eBook

Book Description

Here's the book you need to prepare for Exam 1Z0-031: OCA/OCP: Oracle9i DBA Fundamentals I Study Guide In-depth coverage of official exam objectives Practical information on implementing and managing Oracle9i databases Hundreds of challenging review questions, in the book and on the CD Authoritative coverage of all exam objectives, including: Understanding Oracle architecture and its main components Identifying DBA administrative tools Setting up password file authentications Creating and managing Initialization Parameter Files Configuring OMF Create a database using Oracle Database Configuration Assistant Creating a database manually Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.



Oracle9i DBA JumpStart

Author : Bob Bryla

Publisher : John Wiley & Sons

Page : 367 pages

File Size : 41,73 MB

Release : 2006-02-20

Category : Computers

ISBN : 0782151612

Get eBook

Book Description

Get Up to Speed for Oracle9i Administration Training Courses--Fast! Oracle9i DBA JumpStart gives you the solid grounding you need to approach Oracle certification with confidence: * Introduction to relational database concepts * Using basic SQL*Plus and iSQL*Plus commands * Understanding Oracle database functions * Using multiple tables * Restricting, sorting, and grouping data * Creating and maintaining a database * Using SQL*Plus reporting techniques * Creating and maintaining database objects * Setting up users and managing security * Configuring optimization * Creating backups * Troubleshooting



OCP: Oracle9i Performance Tuning Study Guide

Author : Joseph C. Johnson

Publisher : John Wiley & Sons

Page : 613 pages

File Size : 39,22 MB

Release : 2006-07-14

Category : Computers

ISBN : 9780782152746

Get eBook

Book Description

Here's the book you need to prepare for Exam 1Z0-033: Oracle9i Database: Performance Tuning. This Study Guide provides: In-depth coverage of official exam objectives Practical information on optimizing Oracle9i databases Hundreds of challenging review questions, in the book and on the CD Authoritative coverage of all exam objectives, including: Using Diagnostic and Tuning Tools Monitoring and Managing the Buffer Cache Optimizing Sort Operations Detecting and Resolving Lock Contention Diagnosing Shared Server Performance Issues Using Oracle Blocks Efficiently Tuning SQL Statements Configuring Resource Manager Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.



OCP: Oracle9i DBA Fundamentals II Study Guide

Author : Matthew Weishan

Publisher : John Wiley & Sons

Page : 532 pages

File Size : 43,61 MB

Release : 2006-02-20

Category : Computers

ISBN : 078215249X

Get eBook

Book Description

Here's the book you need to prepare for Exam 1Z0-032: Oracle9i Database: Fundamentals II. In-depth coverage of official exam objectives Practical information on implementing and managing Oracle9i databases Hundreds of challenging review questions, in the book and on the CD Authoritative coverage of all exam objectives, including: Identifying solutions included with Oracle9i for managing complex networks Using Oracle Net Services and client server connections Establishing web client connections through Oracle networking products Troubleshooting database connections Using and configuring the Oracle Shared Server Backing up, restoring, and recovering databases Configuring the database archiving mode Using Recovery Manager (RMAN) Loading data into, and transporting data between databases Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.



Mastering Dreamweaver MX Databases

Author : Susan Sales Harkins

Publisher : John Wiley and Sons

Page : 734 pages

File Size : 31,99 MB

Release : 2006-02-20

Category : Computers

ISBN : 0782152023

Get eBook

Book Description

Master the Techniques for Creating Data-Driven Websites with Dreamweaver MX Harness the power of Dreamweaver MX to build dynamic, database-driven websites. Mastering Dreamweaver MX Databases equips you with all the coding and database skills you need. You'll find focused coverage of key Dreamweaver MX features, plus highly practical instruction relating to the most important scripting languages and databases supported by Dreamweaver MX. Topics include: Creating ASP, JSP, ColdFusion, ASP.NET, and PHP pages Connecting to SQL Server, MySQL, Oracle, Access, and other ODBC databases Capturing, storing, retrieving, and updating data Choosing the language and database combination that's right for your purpose Mastering the Dreamweaver MX data view, insert, and update features Creating recordsets and queries in Dreamweaver MX-supported languages and databases Securing your site and database using Dreamweaver MX features and best practices Designing pages using live data from your database with Dreamweaver's Live Data view Saving time using master/detail forms and templates Creating search pages for your database Using the extensions available to Dreamweaver MX to aid database development Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.



OCA Oracle Database SQL Exam Guide

Author : Steve O'Hearn

Publisher :

Page : 609 pages

File Size : 50,26 MB

Release : 2017

Category : Database management

ISBN : 9781259585500

Get eBook

Book Description

Features detailed explanations, examples, practice questions, and chapter summaries. "Certification Objectives," "Exam Watch," and "On the Job" sections reinforce salient points throughout.



OCA Java SE 8 Programmer I Study Guide (Exam 1Z0-808)

Author : Edward G. Finegan

Publisher : McGraw Hill Professional

Page : 611 pages

File Size : 18,32 MB

Release : 2015-09-11

Category : Computers

ISBN : 1259587533

Get eBook

Book Description

The official study guide for the entry-level Oracle Certified Associate exam for Java Programmers—fully updated for Java SE 8 Confidently prepare for the OCA Java SE 8 Programmer I exam with this thoroughly revised, up-to-date guide from Oracle Press. Featuring step-by-step exercises, comprehensive chapter self-tests, and two complete downloadable practice exams, this volume provides an integrated, easy-to-follow study system based on a proven methodology. OCA Java SE 8 Programmer I Study Guide (Exam 1Z0-808) offers the most complete and in-depth coverage of all of the exam objectives, and also serves as an essential on-the-job reference for Java developers. You’ll have access to a total of more than 250 challenging practice questions that precisely mirror the content of the live exam—no other guide on the market provides the same level of accuracy and detail. Questions accurately simulate the type and style of questions found on the actual test Includes special “Exam Watch,” “Inside the Exam,” and “On the Job” sections Downloadable MAC and PC compatible test engine includes two complete practice exams



OCA/OCP

Author :

Publisher :

Page : 539 pages

File Size : 47,40 MB

Release : 2002

Category : Database management

ISBN :

Get eBook

Book Description



OCA Oracle Database 11g SQL Fundamentals I Exam Guide

Author : John Watson

Publisher : McGraw Hill Professional

Page : 608 pages

File Size : 23,95 MB

Release : 2008-06-19

Category : Computers

ISBN : 0071597867

Get eBook

Book Description

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. A Fully Integrated Study System for OCA Exam 1Z0-051 Prepare for the Oracle Certified Associate Oracle Database 11g: SQL Fundamentals I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-051, including: SQL SELECT statements Restricting and sorting data Single-row functions Conversion functions and conditional expressions Group functions Displaying data from multiple tables Subqueries Set operators DML and DDL statements Schema objects On the CD-ROM: One full practice exam that simulates the actual OCA exam Detailed answers and explanations Score report performance assessment tool Complete electronic book Bonus exam available free with online registration