oracle-pl-sql

Oracle Sql

Description

This course engages students to analyze complex business situations and create a data model—a Conceptual representation of an organization’s info. Participants implement their database Design by making a physical database using SQL. Basic SQL syntax and therefore the rules for constructing valid SQL statements are reviewed. This course culminates with a project that challenges students to design, implement, and demonstrate a database solution for a business or organization.

Oracle Sql Course Content

Oracle Tables
  • Create Table
  • Create Table As
  • Alter Table
  • Drop Table
  • Global Temp Tables
  • Local Temp Tables.
Oracle Views & Query
  • Create View
  • Oracle Queries
  • Oracle Select
  • Oracle Insert
  • Oracle Insert All
  • Oracle Update
  • Oracle Delete
  • Truncate Table
Oracle Queries
  • Oracle Queries
  • Oracle Select
  • Oracle Insert
  • Oracle Insert All
  • Oracle Update
  • Oracle Delete
  • Truncate Table
Oracle Clauses
  • Oracle DISTINCT
  • Oracle FROM
  • Oracle ORDER BY
  • Oracle GROUP BY
  • Oracle HAVING
Oracle Operators
  • Oracle Union
  • Oracle Union All
  • Oracle Intersect
  • Oracle Minus
Oracle Advance
  • Oracle Procedure
  • Oracle Function
  • Oracle Cursor
  • Oracle Trigger
  • Oracle BEFORE Trigger
  • Oracle AFTER Trigger
  • Oracle DROP Trigger
  • Oracle DISABLE Trigger
  • Oracle ENABLE Trigger
Oracle Joins
  • Oracle Joins
  • Inner Join
  • Outer Join
  • Equi Join
  • Self Join
  • Cross Join
  • Anti Join
  • Semi Join

Courses Features

  • Language
    English
  • Lectures
    1
  • Certification
    Yes
  • Project
    5 Minor + 1 Major
  • Duration
    64 hrs + 36 hrs
  • Max-Students
    20
DEMO
DROP US A QUERY

© Copyright - 2019 | Cyberaegis | All Rights Reserved.