As Data Analytics, Data Science is getting popular and Data warehousing is a important domain.
Duration: 2 Months
Fee:12,000/-
Oracle Training Content Overview
Oracle Syllabus
Plsql syllabus
- Writing Basic SQL SELECT Statements
- Restricting and Sorting Data
- Single-Row Functions
- Displaying Data from Multiple Tables
- Aggregating Data Using Group Functions
- Subqueries
- Manipulating Data
- Creating and Managing Tables
- Including Constraints
- Creating Views
- Other Database Objects
- Controlling User Access
- SQL Workshop
- Using SET Operators
Plsql syllabus
Programming in PL/SQL
- Creating and Running PL/SQL Code
- PL/SQL Program Structure
- Loop Basics
- Exception Handlers
PL/SQL Program Data
- Strings
- Numbers
- Records
- Collections
- Miscellaneous Datatypes
SQL in PL/SQL
- Data Retrieval
- Procedures, Functions, and Parameters
- Packages
- Triggers
- Managing PL/SQL Code
- I/O and PL/SQL
- Oracle Forms and Build Internet Applications
- Oracle Reports
