iNEWPM
Course Duration:2 Months

Course Details

DBMS: Oracle SQL

                                                                                                                                 

Prerequisites

·         No as such prerequisites are required.

·         Familiar with database concept is advantageous.

Course Contents


1.      Writing Basic SQL SELECT Statements

·         SQL Overview

·         Arithmetic Expressions

·         NULL Value

·         Column Alias

·         Concatenation Operator

·         Literals

·         Eliminating Duplicate Rows

2.      Restricting and Sorting Data

·         WHERE clause

·         Logical Operators

·         SQL Operators

·         LIKE Operator

·         AND, OR and NOT Operators

·         ORDER BY Clause

3.      Row Functions

·         Character Functions

·         Number Functions

·         Date Functions

·         Conversion Functions

·         General Functions

4.      Displaying Data from Multiple Tables

·         Types of Joins in Oracle

·         SQL Joins

5.      Aggregating Data Using Group Functions

·         Group Functions

·         Group By Clause

·         HAVING Clause

6.      Subqueries

·         Single Row subqueries

·         Multiple Row Subqueries

·         Correlated Subqueries

7.      Manipulating Data

·         INSERT Statement

·         UPDATE Statement

·         DELETE Statement

·         MERGE Statement

·         Transaction Control

·         Locks

8.      Creating and Managing Tables

·         Data Definition Language

·         Data Types

·         CREATE TABLE Statement

·         ALTER TABLE Statement

·         Rename an Object

·         Comments

9.      Including Constraints

·         Primary Constraints

·         FOREIGN KEY Constraint

·         NOT NULL Constraint

·         UNIQUE Constraint

·         CHECK Constraint

·         ALTER statement

·         Dropping a constraint

·         Disabling Constraints

·         Enabling Constraints

·         Cascading Constraints

·         Viewing Constraints

10.  Views

·         Creating a View

·         Retrieving Data from a View

·         Modifying a View

·         Destroying a View

·         User View

11.  Other Database Objects

·         Sequence

·         Index

·         Synonyms

12.  Controlling User Access

·         Privileges

·         System Privileges

·         Object Privileges

·         Role

13.  Using SET Operators

·         UNION Operator

·         UNION ALL Operator

·         INTERSECT Operator

·         MINUS Operator

14.  Oracle Datetime Functions

·         Oracle 9i Date time Support

·         CURRENT_DATE

·         CURR

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