OCA Oracle database SQL exam guide : (exam 1Z0-071) /

A fully updated, integrated self-study system for the Oracle Database SQL Exam 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 G...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: O'Hearn, Steve (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: New York : McGraw-Hill Education, [2017]
Colección:Oracle Press
Temas:
Oracle (Computer file)
Electronic data processing personnel > Certification > Study guides.
Database management > Examinations > Study guides.
SQL (Computer program language) > Examinations > Study guides.
Bases de données > Gestion > Examens > Guides de l'étudiant.
SQL (Langage de programmation) > Examens > Guides de l'étudiant.
Database management > Examinations.
Electronic data processing personnel > Certification.
examination study guides.
Study guides.
Guides de l'étudiant.
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Oracle and structured query language (SQL)
  • using DDL statements to create and manage tables
  • Manipulating data
  • Restricting and sorting data
  • Using single-row functions to customize output
  • Using conversion functions 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 access.

Ejemplares similares