CERTIFICATE COURSE IN ORACLE ADMINISTRATION
Programme Code: SCPS/CS/OA/2020-21
Class: III BSc IT Total Hours: 36 hours Modules: 5
SYLLABUS
Module I (5 hours)
Basic DATABASE Concept and SQL Basic history of database concept:
Introduction to DBMS, RDBMS, ORDBMS, Advantage of ORACLE database and version information, Interface tools usage: sqlplus, isqlplus, sqldeveloper, Toad, SQL Language overview : DQL, DML, DDL, DCL, TCL, usage of ANSI standard, SELECT Command – Column Alias Rules, String data, Concatenations with various data
Module II (6 hours)
Restricting and Sorting Data using WHERE Clause – Character Strings and Dates, number, General Comparison Conditions = > >= < <= <>, Other Comparison BETWEEN , IN , LIKE , NULL, Logical Conditions AND OR NOT, ORDER BY Clause, Sorting by Column Alias , Column Position, Multiple Columns
Module III (6 hours)
Single-Row Functions:
Character Functions: UPPER, LOWER, INITCAP, LENGTH, SUBSTR, INSTR, LPAD, RPAD, CONCAT, LTRIM, RTRIM, TRIM, REPLACE, TRANSLATE, REVERSE, Number Functions: ROUND, TRUNC, MOD, POWER, CEIL , FLOOR, ABS, Dates Functions: SYSDATE, MONTHS_BETWEEN, NEXT_DAY, LAST_DAY, ADD_MONTHS, ROUND, TRUNC, Arithmetic on Date, Conversion Functions: Implicit Data-Type Conversion & Explicit Data-Type Conversion, TO_CHAR ,TO_NUMBER, TO_DATE
Module IV (7 hours)
Joins: Equi Join / Simple Join / Normal Join, Ansi Join, Left Outer, Right Outer, Full Outer, Natural Join, Natural Outer Joins, Inner Join, Join … Using Clause, Join … On Clause, Cross Join, Non-Equi Join, Self Join, Oracle Standard Outer Joins.
Module V (6 hours)
Data Definition Language – DDL:
DDL : CREATE, ALTER, RENAME, DROP, TRUNCATE, DEFAULT OPTION, Constrain Table Copy