Software Engineering - Oracle PL/SQL Course Curriculum

Software Engineering - Oracle PL/SQL Course Curriculum

Course: SEF – Database Foundation on Oracle (Duration: 11 Weeks)

Course Overview:
This is an intensive course that is designed to give the student maximum exposure to Oracle SQL, PL/SQL. This course starts with introduction to Linux and RDBMS concepts. The students also will learn basic fundamentals of Java programming language and ProC. The student learns by doing, and this class has dozens of in-class exercises and the student will be guided from very simple SQL commands to increasingly complex PL/SQL coding techniques.

Audience:
Engineering graduates or MCAs with a good consistent academic record in SSLC, HSLC and graduation, with 0-1 years of work experience The participants will possess good computer usage skills – using computers for creating documents, sending emails etc.

Prior knowledge of programming is not assumed.
The participants will be shortlisted based on an Aptitude test.
The final selection will be based on personal interview.

Course Objectives:
On completion of this course, successful participants will be able to:

Perform effectively as entry level software professionals.
Writing different Queries to access the database.
Develop and maintain programs in the platform they have studied.
Contribute as members of a team.
Get a hands-on experience on the concepts learnt during the course.

Assessment Strategies:
Assessment methodology is based on Kirkpatrick's model of measuring learning effectiveness (Level 2 & 3). The participants will be assessed using tests, examinations, viva-voce and written assignments to evaluate the degree of achievement of the objectives. Specifically the following assessment mechanisms will be used.

Continuous assessments during training to track learning.
Periodic written and/or online test for review
End of module written and/or online examinations.
End of course project

Certification:
Not Applicable

Module 1: Introduction to Linux & RDBMS (Duration: 1 Week)

Objectives:
At the end of this module successful participants will be able to:

Understand concept of OS.
Understand Linux as open source OS.
Work with Linux using basic commands.
Browse file system.
Work with bash shell.
Understand users, groups and permissions.
Understand and describe DBMS & RDBMS.
Design small scale Database.
Understand E-R model.
Understand types, exclusive arcs and integrity constraints.
Normalize data.
Understand and describe Oracle database server.

Lessons

Linux Ideas and History
Linux Usage and Basic
Overview & Simple Commands
Browsing the File System
The Bash Shell
Standard I/O and Pipes
Users, Groups, and Permissions
vi Editor Basics and Printing
Running Commands and Getting Help
Introduction to Database Management Systems (DBMS)
Introduction to RDBMS
Database Design
Normalization and Normal Forms
Advanced Concepts – Super types and Subtypes, Exclusive Arcs, Domains, Integrity
Constraints
E-R model Exercises and Case Studies
Normalization Exercises and Case Studies
Introduction to Oracle DBMS

Module 2: Oracle SQL (Duration: 3 Weeks)

Objectives:
At the end of this module successful participants will be able to:

A summation of relational database principles and an introduction to the Oracle relational database server.
Using the iSQL*Plus web-based database interface and other traditional interfaces.
Writing simple SQL queries and moderately complex SQL queries using various join techniques.
Summarizing, grouping and sorting data.
Advanced query techniques such as correlated subqueries.
Developing simple SQL*Plus reports.
Creating and maintaining database tables.
Taking advantage of new features such as the use of regular expressions.
Moving beyond basic table definitions, consideration of defining the full range of database objects, such as advanced table definitions, indexes, sequences, views and others.
Understanding basic database security and object privileges.
Using the powerful set of built-in SQL functions.
Protecting the database and extending the basic data model using declarative constraints.
Performing advanced SQL queries such as grouping and cube operations and SQL99 join syntax.
Developing complex SQL*Plus reports and using SQL*Plus scripts.

Lessons

Introduction to SQL
Writing Basic SQL Statement
Restricting & Sorting Data
Single Row Functions
Displaying Data from Multiple Tables
Aggregating Data using Group Functions
Sub-Queries
Producing Readable Output with iSQL*Plus
Manipulating Data
Creating and Managing Tables
Including Constraints
Creating Views
Creating Other Database Objects
Controlling User Access
SQL Workshop
Using Set Operators
Oracle 10g Datetime Functions
Enhancements to the Group BY Clause
Advanced Sub Queries
Hierarchical Retrieval
Oracle 10g Extensions to DML and DDL Statements

Module 3: Oracle PL/SQL (Duration: 3 Weeks)

Objectives:
At the end of this module successful participants will be able to:

Understand the environment and context in which PL/SQL operates.
Consider the advantages and benefits of PL/SQL within a database environment.
Declaring program variables and complex data types.
Developing logic within PL/SQL program blocks.
Fetching data from the database into program variables.
Returning program output to users.
Handling program exceptions.
Using explicit and implicit database cursors.
Using the advanced features of nested blocks and subprograms.
How to take advantage of new features such as regular expression support and the handling of string literals within program code.

Lessons

Introduction to PL/SQL
Declaring Variables
Writing Executable Statements
Interacting with the Oracle Server
Writing Control Structures
Working with Composite Data Types
Writing Explicit Cursors
Advanced Explicit Cursor Concepts
Handling Exceptions
Creating Procedures
Creating Functions
Managing Subprogram
Creating Packages
More Package Concepts
Oracle Supplied Packages
Manipulation Large Objects
Creating Database Triggers
More Trigger Concepts
Managing Dependencies

Module 4: Java Programming Language (Duration: 3 Weeks)

Objectives:
At the end of this module successful participants will be able to:

Understand the Java software architecture, and the design decisions which make Java software portable, efficient, secure and robust.
Learn how to configure a simple Java development environment.
Know the grammar, data types and flow control constructs of the Java language for simple procedural programming.
Create Java technology applications that leverage the object-oriented features of the Java language, such as encapsulation, inheritance, and polymorphism.
Execute a Java technology application from the command line.
Use Java technology data types and expressions.
Use Java technology flow control constructs.
Use arrays and other data collections.
Implement error-handling techniques using exception handling.
Create multithreaded programs.

Lessons

Getting Started with Java
Object-Oriented Programming
Identifiers, Keywords, and Types
Expressions and Flow Control
Arrays
Class Design
Advanced Class Features
Exception Handling
Collections and Generics Framework
Threads
File Handling using java.io Package
JDBC

Module 5: Interfacing with External Code with Pro C (Duration: 1 Week)

Objectives:
At the end of this module successful participants will be able to:

Design, code, and test C language programs using embedded SQL statements to access the Oracle database.
Understand concepts of external code.
Work with Pro* precompiler.
Work on hands-on exercises provide practice with the Oracle Pro* programmatic Interfaces.

Lessons

Embedded SQL Syntax Differences
Pro* Precompiler
Precompiler Options
Static SQL and Dynamic SQL
Host/Bind Variable Declaration
Using Host/Bind Variables
Null Data Values

©Talentsprint