Open Contact Form
Please Contact Us

Your Name (required)

Your Email (required)

Subject

Your Message

img

SQL

Retrieving Data Using the SQL Select Statement

  • Basic SELECT statement
  • Arithmetic expressions and NULL values
  • Column alias
  • Concatenation operator
  • Literal character string
  • Alternative quote operator
  • DISTINCT keyword
  • DESCRIBE command

Retrieving and Sorting Data

  • Limit the retrieve rows
  • Sort the rows
  • Substitution variables

Using Single – Row Function

  • Single-row SQL Functions
  • Character Functions
  • Number Functions
  • Working with dates
  • Date Functions

Using Conversion Functions and Conditional Expression

  • Implicit and explicit data type conversion
  • TO_CHAR, TO_DATE, TO_NUMBER functions
  • Nested Functions
  • General Functions
  • CASE and DECODE Conditional expressions

Reporting Aggregate Data Using the Group Function

  • Group Functions MIN
  • MAX, COUNT, AVG,DISTINCT within group functions
  • NULL values in a group functions

Displaying Data from Multiple Tables

  • Types of JOINS
  • Natural join
  • Self-Join
  • Non-equijoin
  • Outer join
  • Cartesian Products

Using Subquery

  • Single row subquery
  • Group Function in subquery
  • HAVING clause with subquery
  • Multiple-row subquery
  • NULL values in Subquery

Using Set Operator

  • UNION and UNION ALL
  • INTERSECT
  • MINUS
  • ORDER BY clause

Manipulating Data

  • INSERT, UPDATE, DELETE
  • TRUNCATE and COMMIT
  • ROLLBACK and SAVEPOINT
  • Read consistency
  • FOR UPDATE clause

DDL Statement to Create and Manage Tables

  • Naming rules
  • CREATE Table
  • Data Types
  • Constraint NOT NULL
  • PRIMARY KEY
  • FOREIGN KEY
  • UNIQUE,ALTER Table
  • Create table using a subquery

Creating other Schema Objects

  • Views
  • Sequence
  • Index
  • Synonyms

Controlling User Access

  • Creating a role
  • Object Privileges
  • Revoking object privileges

Managing Schema Objects

  • Managing constraints
  • Creating Index
  • Performing flashback operations
  • Creating and using external tables

Managing Objects with Data Dictionary Views

  • Table information
  • Column information
  • Constraint information
  • View information
  • Sequence Information
  • Synonym information
  • Comment to a table

Manipulating Large Data Sets

  • Unconditional INSERT
  • Pivoting INSERT
  • INSERT ALL
  • Merging rows
  • Tracking the chnages

Managing Data in Different Time Zones

  • INTERVAL data types
  • EXTRACT
  • TZ_OFFSET
  • FROM_TZ
  • TO_TIMESTAMP
  • TO_YMINTERVAL
  • TO_DSINTERVAL

Retrieving Data Using Subqueries

  • Using scalar subquery
  • correlated subqueries
  • EXISTS and NOT EXISTS
  • WITH clause

Regular Expression Support

  • REGEXP_LIKE
  • REGEXP_REPLACE
  • REGEXP_INSTR
  • REGEXP_SUBSTR
  • Accessing subexpressions
  • REGEXP_COUNT