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

 

Zielgruppe

  • Technischer Berater
  • PL/SQL-Entwickler
  • Systemanalytiker

Voraussetzungen

  • Search data using advanced sub queries
  • Retrieve row and column data from tables with the SELECT statement
  • Control user access and manage schema objects
  • Run data manipulation statements (DML) to update data in the Oracle Database 10g
  • Employ SQL functions to generate and retrieve customized data

Kursziele

  • Search data using advanced sub queries
  • Retrieve row and column data from tables with the SELECT statement
  • Control user access and manage schema objects
  • Run data manipulation statements (DML) to update data in the Oracle Database 10g
  • Employ SQL functions to generate and retrieve customized data

Produktbeschreibung

  • Identify features of an Entity Relationship (ER) model
  • Identify features of Relational Database Management System (RDBMS)
  • Identify the SQL statement to retrieve data from tables
  • Identify arithmetic expressions used to perform operations on data
  • Identify operators used to format results in SQL statements
  • Identify features of single-row functions
  • Match the character functions with their uses
  • Match the number functions with their purpose
  • Identify the use of natural joins to retrieve data from multiple tables
  • Identify the use of an equi-join to retrieve data from multiple tables
  • Identify the use of self-join to retrieve data from a table
  • Identify the code for using the INSERT statement
  • Identify the code for using the UPDATE statement
  • Identify the code for using the DELETE statement
  • Identify tasks to be performed for granting system privileges
  • Identify tasks to be performed for granting object privileges
  • Identify syntax for performing various tasks for maintaining columns
  • Identify the code for retrieving data hierarchically from a table
  • Identify the code for formatting hierarchical reports
  • Identify features of regular expression functions
Preis (exkl. MwSt.)

638,- €

Bestellen