Introduction to Oralce SQL

3. Data Constraints
• Primary Key, Foreign Key and Check Constraints
• Applying Arithmetic expressions with SELECT statement.
• Column Aliases, NULL values
• Using DISTINCT keyword, concatenation operator, DESCRIBE Command.
• Working with Operators (arithmetic, relational, logical, range searching, pattern matching)
• Set Operator
• UNION and UNIONALL, ORDERBY
• Pseudo columns – ROWID, ROWNUM, USER, UID, SYSDATE
4. Working with Functions
• Numeric Function - FLOOR, MOD, POWER, ROUND, SQRT and TRUNC
• Character Functions - CHR, ASCII, CONCAT, INITCAP, LOWER, SUBSTR,TRIM, UPPER)
• Date Functions - ADD_MONTHS, LAST_DAY, NEXT_DAY, MONTHS_BETWEEN
• Conversion Function - TO_NUMBER, TO_CHAR and TO_DATE
• Aggregate Functions - AVG, COUNT, MAX, MIN, SUM
• Other Functions - NVL, DECODE, COALESCE

5. Join and Transaction Processing
• What is joins?
• Types of Joins (cross join, natural join, equijoin, outer joins, self-join)
• Introduction to DCL
• DCL Statements (GRANT, REVOKE, COMMIT, ROLLBACK, SAVEPOINT)
• System privileges, Create New User, Assign and Revoke rights
6. Understanding Sequences, Synonym, Views and Indexes
• Create Sequences
• Create Synonym
• Create Views
• Create Indexs