DBMS: Oracle SQL
Prerequisites
·
No as such prerequisites are required.
·
Familiar with database concept is advantageous.
Course Contents
1. Writing Basic SQL SELECT Statements
·
SQL Overview
·
Arithmetic Expressions
·
NULL Value
·
Column Alias
·
Concatenation Operator
·
Literals
·
Eliminating Duplicate Rows
2. Restricting and Sorting Data
·
WHERE clause
·
Logical Operators
·
SQL Operators
·
LIKE Operator
·
AND, OR and NOT Operators
·
ORDER BY Clause
3. Row Functions
·
Character Functions
·
Number Functions
·
Date Functions
·
Conversion Functions
·
General Functions
4. Displaying Data from Multiple Tables
·
Types of Joins in Oracle
·
SQL Joins
5. Aggregating Data Using Group Functions
·
Group Functions
·
Group By Clause
·
HAVING Clause
6. Subqueries
·
Single Row subqueries
·
Multiple Row Subqueries
·
Correlated Subqueries
7. Manipulating Data
·
INSERT Statement
·
UPDATE Statement
·
DELETE Statement
·
MERGE Statement
·
Transaction Control
·
Locks
8. Creating and Managing Tables
·
Data Definition Language
·
Data Types
·
CREATE TABLE Statement
·
ALTER TABLE Statement
·
Rename an Object
·
Comments
9. Including Constraints
·
Primary Constraints
·
FOREIGN KEY Constraint
·
NOT NULL Constraint
·
UNIQUE Constraint
·
CHECK Constraint
·
ALTER statement
·
Dropping a constraint
·
Disabling Constraints
·
Enabling Constraints
·
Cascading Constraints
·
Viewing Constraints
10. Views
·
Creating a View
·
Retrieving Data from a View
·
Modifying a View
·
Destroying a View
·
User View
11. Other Database Objects
·
Sequence
·
Index
·
Synonyms
12. Controlling User Access
·
Privileges
·
System Privileges
·
Object Privileges
·
Role
13. Using SET Operators
·
UNION Operator
·
UNION ALL Operator
·
INTERSECT Operator
·
MINUS Operator
14. Oracle Datetime Functions
·
Oracle 9i Date time Support
·
CURRENT_DATE
·
CURR