12c SQL Fundamentals 1Z0-061

Oracle 12c SQL Fundamentals I 1Z0-061

  • Introduction
  • Describe the features of Oracle Database 12c
    Describe the salient features of Oracle Cloud 12c
    Explain the theoretical and physical aspects of a relational database
    Describe Oracle server’s implementation of RDBMS and object relational database management system (ORDBMS)

  • Retrieving Data using the SQL SELECT Statement
  • Explain the capabilities of SQL SELECT statements – POST
    Execute a basic SELECT statement – POST

  • Restricting and Sorting Data
  • Limit the rows that are retrieved by a query – POST
    Sort the rows that are retrieved by a query – POST
    Use ampersand substitution to restrict and sort output at runtime – POST I

  • Using Single-Row Functions to Customize Output
  • Describe various types of functions available in SQL – POST
    Use character, number, and date functions in SELECT statements – POST

  • Using Conversion Functions and Conditional Expressions
  • Describe various types of conversion functions that are available in SQL – POST
    Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions – POST I, POST II, POST III, POST IV
    Apply conditional expressions in a SELECT statement – POST

  • Reporting Aggregated Data Using the Group Functions
  • Identify the available group functions – POST
    Describe the use of group functions – POST
    Group data by using the GROUP BY clause – POST
    Include or exclude grouped rows by using the HAVING clause – POST

  • Displaying Data From Multiple Tables Using Joins
  • Write SELECT statements to access data from more than one table using equijoins and nonequijoins – POST I, POST II, POST III
    Join a table to itself by using a self-join – POST
    View data that generally does not meet a join condition by using OUTER joins – POST
    Generate a Cartesian product of all rows from two or more tables – POST

  • Using Subqueries to Solve Queries
  • Define subqueries – POST
    Describe the types of problems that the subqueries can solve – POST
    Describe the types of subqueries – POST
    Write single-row and multiple-row subqueries
    Using the SET Operators – POST
    Describe set operators – POST
    Use a set operator to combine multiple queries into a single query – POST
    Control the order of rows returned – POST

  • Managing Tables using DML statements
  • Truncate data – POST
    Insert rows into a table – POST
    Update rows in a table – POST
    Delete rows from a table – POST
    Control transactions – POST

  • Introduction to Data Definition Language
  • Categorize the main database objects – POST, POST II
    Explain the table structure – POST
    Describe the data types that are available for columns – POST
    Create a simple table – POST
    Explain how constraints are created at the time of table creation – POST
    Describe how schema objects work – POST

    Esse Blog é reconhecido pela
    Sou articulista
    Sou articulista

    Clique para seguir este blog e receber notificações via email de novos posts.

    Tércio Costa

    Tércio Costa

    Formado em Ciências da Computação pela UFPB com experiência em Servidores Windows Server e Linux e banco de dados Oracle desde 2008 juntamente com os seus serviços. Desenvolvimento de Sistemas em Java SE com banco de dados Oracle e MySQL. Certificado Oracle Certified SQL Expert, mantendo o blog https://oraclepress.wordpress.com/ reconhecido pela OTN, articulista na OTN, portal http://www.profissionaloracle.com.br/gpo e na revista SQL Magazine.

    Links Pessoais

    Serviços verificados

    Visualizar Perfil Completo →

    Total de Visualizações da Página
    • 63,248 Visualizações
    %d blogueiros gostam disto: