<?xml version="1.0" encoding="UTF-8"?>
<mods xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.loc.gov/mods/v3" version="3.1" xsi:schemaLocation="http://www.loc.gov/mods/v3 http://www.loc.gov/standards/mods/v3/mods-3-1.xsd">
  <titleInfo>
    <title>OCA Oracle Database SQL</title>
    <subTitle>exam guide (exam 1Z0-071)</subTitle>
  </titleInfo>
  <titleInfo type="alternative">
    <title>Complete exam preparation</title>
  </titleInfo>
  <name type="personal">
    <namePart>O'Hearn, Steve</namePart>
    <role>
      <roleTerm authority="marcrelator" type="text">creator</roleTerm>
    </role>
    <role>
      <roleTerm type="text">autor.</roleTerm>
    </role>
    <role>
      <roleTerm authority="marcrelator" type="code">aut</roleTerm>
    </role>
  </name>
  <typeOfResource>text</typeOfResource>
  <originInfo>
    <dateIssued encoding="marc">2017</dateIssued>
    <issuance>monographic</issuance>
  </originInfo>
  <language>
    <languageTerm authority="iso639-2b" type="code">spa</languageTerm>
  </language>
  <language objectPart="translation">
    <languageTerm authority="iso639-2b" type="code">eng</languageTerm>
  </language>
  <physicalDescription>
    <form authority="marcform">print</form>
    <extent>609 páginas : : tables ; fig + :CD ROM.</extent>
  </physicalDescription>
  <abstract>This thoroughly revised Oracle Press guide offers 100% coverage of all objectives on the latest version of the Oracle Database SQL Exam. Ideal both as a study guide and on-the-job reference, OCA Oracle Database SQL Exam Guide (Exam 1Z0-071) features detailed explanations, examples, practice questions, and chapter summaries. “Certification Objectives,” “Exam Watch,” and “On the Job” sections reinforce salient points throughout. You will gain access to two complete practice exams that match the tone, tenor, and format of the live test.</abstract>
  <tableOfContents>Oracle and Structured Query Language (SQL). -- Using DDL Statements to Create and Manage Tables. -- Manipulating Data. -- Resticting and sorting Data. -- Using Single - Row Fuctions to Customize Output. -- Using Conversion Fuctions and Conditional Expressions. -- Reporting Aggregated Data Using the Group Functions. -- Displaying Data from Multiple Tables. -- Using Subqueries to Solve Queries. -- Managing Schema Objects. -- Using the set Operators. - Managing Objects with Data Dictionary Views. -- Manipulating Large Data Sets. -- Controlling User Acces. -- About the CD-ROM.</tableOfContents>
  <note>Contents.</note>
  <subject authority="lcsh">
    <topic>Oracle</topic>
    <topic>Computer file</topic>
  </subject>
  <subject authority="lcsh">
    <topic>Database management</topic>
    <topic>Examinations</topic>
  </subject>
  <subject authority="lcsh">
    <topic>Electronic data processing personnel</topic>
    <topic>Certification</topic>
  </subject>
  <subject authority="lcsh">
    <topic>PL/SQL</topic>
    <topic>Computer program language</topic>
  </subject>
  <subject authority="lcsh">
    <topic>Database management</topic>
  </subject>
  <classification authority="ddc" edition="23">005.7565 O'999</classification>
  <identifier type="isbn">9781259585487</identifier>
  <identifier type="isbn">9781259585494</identifier>
  <identifier type="isbn">1259585484</identifier>
  <identifier type="isbn">1259585492</identifier>
  <recordInfo>
    <recordContentSource authority="marcorg">CO-ViULL</recordContentSource>
    <recordCreationDate encoding="marc">230428</recordCreationDate>
    <recordChangeDate encoding="iso8601">20251030135900.0</recordChangeDate>
    <languageOfCataloging>
      <languageTerm authority="iso639-2b" type="code">spa</languageTerm>
    </languageOfCataloging>
  </recordInfo>
</mods>
