|
List of Practicals
1. SQL Statements – 1
a. Writing Basic SQL SELECT Statements
b. Restricting and Sorting Data
c. Single-Row Functions
2. SQL Statements – 2
a. Displaying Data from Multiple Tables
b. Aggregating Data Using Group Functions
c. Subqueries
3. Manipulating Data
a. Using INSERT statement
b. Using DELETE statement
c. Using UPDATE statement
4. Creating and Managing Tables
a. Creating and Managing Tables
b. Including Constraints
5. Creating and Managing other database objects
a. Creating Views
b. Other Database Objects
c. Controlling User Access
6. Using SET operators, Date/Time Functions, GROUP BY clause (advanced
features) and advanced subqueries
a. Using SET Operators
b. Datetime Functions
c. Enhancements to the GROUP BY Clause
d. Advanced Subqueries
7. PL/SQL Basics
a. Declaring Variables
b. Writing Executable Statements
c. Interacting with the Oracle Server
21
d. Writing Control Structures
8. Composite data types, cursors and exceptions.
a. Working with Composite Data Types
b. Writing Explicit Cursors
c. Handling Exceptions
9. Procedures and Functions
a. Creating Procedures
b. Creating Functions
c. Managing Subprograms
d. Creating Packages
10. Creating Database Triggers