iNEWPM

Course Details

Course: Oracle Database Technology

Course Duration: 50 Hrs.

Course Fee: Rs. 4000/student  

Module 1:       Basic SQL

1.     Introduction of Data Base

2.     Retrieving Data Using the SQL SELECT Statement

3.     Restricting & Sorting Data

4.     Using Single-Row Functions to Customize Output

5.     Reporting Aggregated Data Using the Group Functions

6.     Displaying Data from Multiple Tables

7.     Using Subqueries to Solve Queries

8.     Using the Set Operators

9.     Manipulating Data

10.                        Using DDL Statements to Create & Manage Tables

11.                       Creating Other Schema Objects

12.                        Managing Objects with Data Dictionary Views

Module 2: Advance SQL

1.     Introduction

2.     Controlling User Access

3.     Managing Schema Objects

4.     Manipulating Large Data Sets

5.     Generating Reports by Grouping Related Data

6.     Managing Data in Different Time Zones

7.     Retrieving Data Using Subqueries

8.     Hierarchical Retrieval

9.     Regular Expression support  

Are you providing Training Classes
IT Courses / Govt Exam Preparation
Higher Studies / Studies Abroad
NEWFreeCompanies HiringUpdates//nuPM