Imate žicu za učenje?

Oracle Database 11g: Using Subqueries and Regular Expressions

Overview/Description
To recognize the steps for retrieving data using subqueries and using regular expressions to search for, match, and replace strings.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites
Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI).

Expected Duration (hours)
1.8

Lesson Objectives

Oracle Database 11g: Using Subqueries and Regular Expressions

  • identify the steps for writing multiple-column and scalar subqueries.
  • recognize the steps for solving problems by using correlated subqueries and the WITH clause.
  • write multiple-column, correlated, and scalar subqueries in a given scenario and solve a problem using the WITH clause.
  • recognize the benefits of implementing complex match logic in the database, using regular expressions.
  • identify the steps for using regular expressions functions and for accessing subexpressions.
  • use regular expression functions to search for, replace, and manipulate data, and also add a CHECK constraint to a column.
  • Trajanje: 
    1,75 h
    Šifra: 
    257896_ENG

    Koraci do učenja

    1Prijavi se

    Prijavite se, a ako nemate korisničko ime, registrirajte se.

    2Pronađi i upiši program

    Pronađite edukacijske programe u Katalogu i Certifikaciji, ili koristite polje za pretragu.

    3Uči

    Upisani programi dostupni su u meniju Korisnik, Moji tečajevi.

    »Detaljne upute