Course Outline

Control user access

  • User Management
  • System permissions and object
  • Granting
  • Receiving permission
  • Roles
  • Using the links

Managing schema objects

  • ALTER TABLE command
  • Adding, modifying, and deleting columns
  • Add, remove, turn off constraintów
  • Create indexes
  • Flashback operations
  • External tables

Operations on large data sets

  • MERGE command
  • DML operations of podzapytaniami
  • DML operations with RETURNING clause
  • INSERT command multi tables

Conditional expressions

  • CASE expression
  • DECODE expression

Generate reports by grouping related data

  • The GROUP BY clause
  • The HAVING clause
  • Aggregating data - ROLLUP and CUBE operators
  • Identification summaries - GROUPING function
  • Aggregating data - GROUPING SETS operator

Managing data in different time zones

  • Time zones
  • Variations TIMESTAMP
  • Differences between DATE and TIMESTAMP
  • Conversion operations

Advanced subqueries

  • Subqueries
  • Multi-column subqueries
  • The subquery in the FROM clause
  • Correlated subqueries
  • WITH clause - re-use query blocks

Join tables

  • Inequality in the WHERE clause and the FROM clause
  • Semijoin
  • Antijoin

The processing of hierarchical data

  • The tree structure
  • hierarchical Queries
  • Pseudo column
  • Sort data in a hierarchical query
  • Useful functions

Regular expressions

  • Simple and complex patterns

Requirements

Oracle SQL undergoing a course in the first part

  14 Hours
 

Related Courses

Related Categories