| |
 |
|
|
Module 6: SQL & PL/SQL & TOAD-
2 Week (24 hours) |
- Getting started with SQL
- SQL language to create and manipulate
SQL database objects.
- Database creation and management
- Stored Procedures
- SQL QUERIES: UNIONS, JOINS, QUERIES,
SUBQUERIES
- Character String Functions: LPAD,
ASCII, RPAD, CHR, LTRIM, CONCAT, RTRIM,
INITCAP, TRIM, INSTR,REPLACE, LENGTH,
SOUNDEX, LOWER, SUBSTR, UPPER, VSIZE
- Aggregate/ Group functions: STDDEV,
AVG, SUM, COUNT, VARIANCE, MAX, Group
By, MEDIAN, Incorrect Usage, MIN
- Date Timestamp Functions: ADD_MONTHS,
ROUND, CURRENT DATE, SESSIONTIMEZONE,
CURRENT TIMESTAMP, SYSDATE, DBTIMEZONE,
SYSTIMESTAMP, EXTRACT, TO_CHAR, LAST_DAY,
TO_DATE, LOCALTIMESTAMP, TO_TIMESTAMP,
MONTHS_BETWEEN, NEW_TIME, TRUNC, NEXT_DAY
- Numerical Math Functions: Log, ABS,
MOD, POWER, ROUND, CEIL, SQRT, EXP,
FLOOR, TRUNC
- Conversion Functions: ROWIDTONCHAR,
DECODE, TO_CHAR, NVL, TO_NUMBER, NVL2,
TRANSLATE, ROWIDTOCHAR
- Analytical Functions: ROWNUM,
CUBE, Group by, HAVING
- Miscellaneous Functions: GREATEST,
LEAST
- Intro to DBMS, RDBMS, Normalization,
SQL, PL-SQL
- Inserting, Deleting, and Updating
Data
- Commit and Rollback
- DML, DDL, DCL
- SELECT, WHERE clauses, Sorting, Wildcards,
Distinct
- Create, Alter, Drop Tables
- Different data types for fields
- Constraints: Primary keys, Foreign
keys, Unique, Not Null
- Group and Have clause
- Joins: inner join, outer joins, self
join
- Introduction to Functions, Procedures,
Triggers, Cursor, Sequence
- Interview questions and answers discussion
- Written test
- Oral presentation test
|
|
|
