Obtaining an Oracle certification gives you that much needed advantage over other candidates. The Oracle Database 10g Administrator Certified Associate (oca) credential is the first step toward success as an Oracle database professional


Download 30.22 Kb.
NameObtaining an Oracle certification gives you that much needed advantage over other candidates. The Oracle Database 10g Administrator Certified Associate (oca) credential is the first step toward success as an Oracle database professional
A typeDocumentation

CIRCLE TOWERS PLAZA, 9411 LEE HIGHWAY, SUITE R, FAIRFAX, VA 22031.

PHONE: 703-554-3827 EMAIL: PREM@JOBMARKETTRAINING.COM

WWW.JOBMARKETTRAINING.COM





ORACLE PL/SQL DATABASE COURSE
Oracle PL/SQL Database Programming Course (OPDP-001)

JMT Oracle PL/SQL Hands-On Training (OPDP-001) is an intense hands-on course that is designed to give the student maximum exposure to Oracle PL/SQL.  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. In this Oracle PL/SQL Training, students gain the practical knowledge to write PL/SQL programs. Students learn to build stored procedures, design and execute modular applications, and increase the efficiency of data movement. This course is designed for students and practicing Oracle professionals who have no experience or basic experience with SQL and the use of a relational database. Prior experience with Oracle is not required.

Obtaining an Oracle certification gives you that much needed advantage over other candidates. The Oracle Database 10g Administrator Certified Associate (OCA) credential is the first step toward success as an Oracle database professional.

Course Audience

  • Fresh Students planning to make a career in the field of Database / Data Warehousing.

  • Professionals in the IT field who are interested in understanding the concepts covered in the Oracle PL/SQL and OCA certification Exam and making a career in the field of databases.

Learning Objectives

After completing this course, students will learn:

  • Basics of SQL and PL/SQL, DDL & DML

  • Understand the environment and context in which PL/SQL operates.

  • Advantages and benefits of PL/SQL within a database environment.

  • Declaring program variables and complex data types.

  • Developing logic within PL/SQL program blocks.

  • Joining tables, Aggregation, Stored Procedures, Cursors, Triggers.

  • Encapsulating data manipulation statements in stored procedures.

  • Performing complex data manipulation with cursors

  • Leveraging EXCEPTIONs to handle runtime errors

  • Creating triggers to handle data integrity and derivation

  • Utilizing weak and strong cursor variables for dynamic SQL

  • Denormalizing data with user-written functions


Course Benefits

  • Live Instructor-led Training in modern classrooms with fast computers & high speed Internet

  • Thorough review of Oracle PL/SQL topics by industry experts

  • 100% up-to-date material & Live Hands-on Labs

  • Convenient evening & weekend schedule to fit your working life & help you absorb the material

  • Tips and Tricks to improve your chances of getting a job immediately

  • Confidence Building Simulation Tests & Self-Assessments throughout the course

  • Low /Affordable fees to fit your budget & Flexible Payment Options

  • An overview of the scope of the Oracle PL/SQL Job Opportunities and career counseling

  • Classroom located in Fairfax & conveniently accessible from Vienna Metro

  • Academic Scholarships & Discounts for deserving candidates

  • Assistance with Resume Writing, Interview Preparation & Job Placement

Course Instructors



All our instructors are highly skilled professionals with advanced academic degrees and certifications with more than 15 years experience in their respective fields.

Course Schedule





Session

Topics

Session 1

  • Introduction

  • Syllabus Overview

  • Introduction to relational database model

  • Introduction to SQL

  • How to use Oracle SQL Developer & other tools




Session 2

  • How to work with an Oracle database

  • How to use SQL Developer to work with a database

  • How to use SQL Developer to run SQL statements

    • How to use the SQL Reference manual




Session 3

  • How to retrieve data from a single table

  • An introduction to the SELECT statement

  • How to code the SELECT clause

  • How to code the WHERE clause

  • How to code the ORDER BY clause




Session 4

  • How to retrieve data from two or more tables

  • How to work with inner joins

  • How to work with outer joins

  • Other skills for working with joins

  • How to work with unions




Session 5

  • How to code summary queries

  • How to work with aggregate functions

  • How to group and summarize data

  • How to summarize data using Oracle extensions




Session 6

  • How to code subqueries

  • An introduction to subqueries

  • How to code subqueries in search conditions

  • Other ways to use subqueries

  • Guidelines for working with complex queries

  • Two more skills for working with subqueries




  • How to insert, update, and delete data

  • How to create test tables

  • How to commit and rollback changes

  • How to insert new rows

  • How to update existing rows

  • How to delete existing rows





Session 7

  • How to work with data types and functions

  • The built-in data types

  • How to convert data from one type to another

  • How to work with character data

  • How to work with numeric data

  • How to work with date/time data




Session 8

  • How to design a database

  • How to design a data structure (Primary Keys, Foreign Keys, Indexing)

  • How to Normalize the data (7 normal forms & denormalization)




  • How to create tables, indexes, and sequences

  • Creating, Altering & Dropping Tables, Indexes, Sequences, AP schemas, Constraints

    • How to use SQL Developer




Session 9

  • How to create views

  • How to create an updatable view

  • How to create a read-only view

  • How to use the WITH CHECK OPTION clause

  • How to insert or delete rows through a view

  • How to alter or drop a view

  • How to drop a view

  • How to alter a view

  • How to write PL/SQL code

  • An introduction to PL/SQL

  • How to code the basic PL/SQL statements

  • IF statements, CASE statements, loops, cursors, exceptions

  • Other scripting and PL/SQL skills

  • Binding variables, using substitution variables, dynamic SQL




Session 10

  • How to manage transactions and locking

  • Commit, Rollback, Save points, concurrency, locking, deadlocks




Session 11

  • How to create stored procedures and functions

  • How to code stored procedures

  • How to code user-defined functions

  • How to work with packages

  • How to create triggers

  • How to work with triggers




Session 12

  • INTERVIEW PREPARATION

    • Sample Interview Questions

    • Career Consulting




  • RESUME PREPARATION

    • Resume Preparation Tips

    • Job Search Tips

    • Candidate Marketing




  • ORACLE OCA CERTFICATION REVIEW

    • Certification Roadmap

    • Certification Tips

    • Sample Certification Questions

    • Test Simulation



Course Schedule / Duration



New Oracle PL/SQL batch starts every month. Each batch runs for 6 weeks (Each session is 4 hours and there are 2 sessions / week). Please call the number below or check the website for complete schedule.
http://www.jobmarkettraining.com/schedule.php

Course Fee



Only $499/- (Payable in advance).
Scholarships & Group Discounts are available for eligible candidates. Please inquire for more details.

Course Location



CIRCLE TOWERS PLAZA

9411 Lee Highway Suite R,

Fairfax, VA 22031, USA

Registration


Seats are limited. Registration on first come, first served basis.

To register or to obtain more information, please contact
Prem Jadhwani

prem@jobmarkettraining.com

Phone: 703-554-3827

JOB MARKET TRAINING LLC © 2010

Share in:

Related:

Obtaining an Oracle certification gives you that much needed advantage over other candidates. The Oracle Database 10g Administrator Certified Associate (oca) credential is the first step toward success as an Oracle database professional iconTesting the Oracle Database 10g Client Installation 7

Obtaining an Oracle certification gives you that much needed advantage over other candidates. The Oracle Database 10g Administrator Certified Associate (oca) credential is the first step toward success as an Oracle database professional iconOracle Database 11g Express Edition – pl/sql and Database Administration Concepts

Obtaining an Oracle certification gives you that much needed advantage over other candidates. The Oracle Database 10g Administrator Certified Associate (oca) credential is the first step toward success as an Oracle database professional iconOracle® Database Express Edition

Obtaining an Oracle certification gives you that much needed advantage over other candidates. The Oracle Database 10g Administrator Certified Associate (oca) credential is the first step toward success as an Oracle database professional iconHaving started my career as an Oracle apps dba consultant, I have...

Obtaining an Oracle certification gives you that much needed advantage over other candidates. The Oracle Database 10g Administrator Certified Associate (oca) credential is the first step toward success as an Oracle database professional iconEnhanced Oracle Database Monitor Plugin

Obtaining an Oracle certification gives you that much needed advantage over other candidates. The Oracle Database 10g Administrator Certified Associate (oca) credential is the first step toward success as an Oracle database professional iconDescription of issue: Wrong terminology used for Oracle database

Obtaining an Oracle certification gives you that much needed advantage over other candidates. The Oracle Database 10g Administrator Certified Associate (oca) credential is the first step toward success as an Oracle database professional iconOracle/Java, Oracle adf (Application Development Framework)

Obtaining an Oracle certification gives you that much needed advantage over other candidates. The Oracle Database 10g Administrator Certified Associate (oca) credential is the first step toward success as an Oracle database professional iconSoftware Architecture / Design: Development using. Net/C# or Java...

Obtaining an Oracle certification gives you that much needed advantage over other candidates. The Oracle Database 10g Administrator Certified Associate (oca) credential is the first step toward success as an Oracle database professional iconNet professional (C# certified), asp. Net, Database, Internet developer, Service Engineer

Obtaining an Oracle certification gives you that much needed advantage over other candidates. The Oracle Database 10g Administrator Certified Associate (oca) credential is the first step toward success as an Oracle database professional iconProfile Skilled, Senior it professional with 15 years experience...




forms and shapes


When copying material provide a link © 2017
contacts
filling-form.info
search