COURSE DETAILS

Course Type

Others

Subjects

OracleSql Server

Eligibility

Others

Syllabus

* 1. DML
o 1.1 Select
o 1.2 Update
o 1.3 Delete
o 1.4 Select into
* 2. DDL
o 2.1 create database
o 2.2 alter database
o 2.3 create table
o 2.4 alter table
o 2.5 drop table
o 2.6 create index
o 2.7 drop index
* 3. Where condition
* 4. Operator
o 4.1 Equal
o 4.2 not equal
o 4.3 Less than
o 4.4 Greater than
o 4.5 BETWEEN
o 4.6 LIKE
o 4.7 IN
* 5. Order by
* 6. Wild characters
* 7. SQL alias
* 8. SQL indexes
* 9. SQL view
* 10. NULL values
* 11. SQL constraints
o 11.1 NOT NULL
o 11.2 UNIQU E
o 11.3 Primary key
o 11.4 Foreign key
o 11.5 Check
o 11.6 Default
* 12. SQL joins
o 12.1 Join
o 12.2 Left
o 12.3 Right
o 12.4 Full
* 13. SQL UNION Operators
o 13.1 UNION
o 13.2 UNION ALL
* 14.SQL Functions
o 14.1 Aggregate Functions
+ 14.1.1 AVG
+ 14.1.2 COUNT
+ 14.1.3 FIRST
+ 14.1.4 MIN
+ 14.1.5 SUM
o 14.2 Scalar Functions
+ 14.2.1 UCASE
+ 14.2.2 LCASE
+ 14.2.3 MID
+ 14.2.4 LEN
+ 14.2.5 ROUND
* 15. SQL Group by
* 16. SQL Having
* 17.SQL Dual Table

PL/SQL

* 1.Triggers
o 1.1 Before trigger
o 1.2 After trigger
* 2. Stored Procedure
o 2.1 IN
o 2.2 OUT
o 2.3 IN OUT
* 3. Cursor
* 4. Functions

Location

FIT Computer Education

#68, karuneegar street,
Adambakkam, Chennai, India,
Postal code: 600088.

View Venue Details >
This Course is offered in Adambakkam

Book Your Ticket

ENROLL COURSE

Oracle 10g

Pick a Venue

Course available in Single venue

Show all venues offering Oracle 10g

Course offered in
Adambakkam

Date and Time

No Upcoming Batches listed in Adambakkam Contact Institute directly by sending an Enquiry