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