Oracle Database 11g: SQL Fundamentals II (Self-Study Course)

 

Quién debería asistir

  • Database designers
  • Database administrators

Objetivos del curso

  • Identify the steps for managing data in different time zones in Oracle Database 11g, for managing time intervals, and for using date-time functions
  • Recognize the steps for retrieving data using subqueries and using regular expressions to search for, match, and replace strings
  • Recognize the steps for controlling user access to objects and also for maintaining these objects by dropping columns and adding constraints and indexes
  • Recognize the steps for querying data dictionary views to view schema objects, and for performing operations on large amounts of data, such as inserting data into multiple tables

Descripción del Producto

  • Oracle Database 11g: Controlling User Access and Managing Schema Objects
    • Controlling User Access
    • Managing Schema Objects
  • Oracle Database 11g: Data Dictionary Views and Large Data Sets
    • Managing Objects with Data Dictionary Views
    • Manipulating Large Data Sets
  • Oracle Database 11g: Managing Data in Different Time Zones
    • Using Time Zones and Datetime Functions
  • Oracle Database 11g: Using Subqueries and Regular Expressions
    • Retrieving Data Using Subqueries
    • Using Regular Expressions

Precio contra pedido