Price On RequestIntroduction: Data, information, Database, DBMS, relations, tuples, attributes , Oracle engine, architecture (client servers). SQL, SQL statement (DCL, DDL, DML) Data-type (Char, Number, Date, Varchar varchar. Create table: Insert Data into tables, view data from table, view table structure, eliminate duplicate rows from table, create table from another table, Alter table schemas, Delete Data from table, Update the table contents, Rename table, Drop table. Computation on table data using arithmetic operation and logical operation, Search data (using range, pattern matching, NOT operation). Function : Scalar function (lower, upper, power, greatest, least, mod, trunk, ascii, translate, abs, sqrt, initcap,length, concat, substr, lapd, rapd, instr, sysdate, monts_ between, next_day, add_months (calculate the number of days , no. or months, no. of weeks) to _Char, to_number, to_ date, nvl, nvl2, nullif, count, coalesce, case (yyyy, mm, month, mon, day, dy, ddsp, ddspth, mi, ss hh). group by a aggregate functions (avg, couny, max, min, sum), order by clause, constraints (primary key constraint, foreign key constraint, check constraint, null, unique, dropping constraints, cascading constraints). Joins: Joins of two or more table (equi join, self join, outer join , inner join, cross join). Views : introduction to view, create view, retrieve data from view, dropping view). Sequencing: creating sequence, nextval, currval, modifying a sequence, use sequence in query, delete sequence. Security Management using SQL: create user account, administrator account, granting and revoking the permission on objects, change user password, creating role and use of role. PL/ SQL (programming in SQL): Introduction to PL/ SQL Structure: data type, control structure , text message, Cursor programming Cursor introduction, types of cursor, attributes of cursor, task of open, fetch and close commands, parameterized cursors, Error handling in PL/ SQL. PL/ SQL objects Procedures and functions: Create functions and procedures, use parameters, delete Oracle package Alteration to existing package, private Vs public, overloading procedure. Database triggers: Triggers Vs procedures, creating triggers, types of triggers (row, statement, before Vs after trigger, deleting triggers) Generating a primary key using data base triggers
SS Informatics Software Solutions