Oracle Database (SQL/PLSQL) Training Course

Introduction

Oracle Database is the first database designed for enterprise grid computing, the most flexible and cost effective way to manage information and applications. Enterprise grid computing creates large pools of industry-standard, modular storage and servers.
Oracle Database is the first database designed for enterprise grid computing, the most flexible and cost effective way to manage information and applications. Enterprise grid computing creates large pools of industry-standard, modular storage and servers.

Program Objectives

• To become a complete Database Professional
• To provide insight into real world scenarios of life as Software developer in IT Industry
• To provide students with indispensable knowledge and skills which will
• enable them to pursue career in the IT
• •To provide skill based professional training for career advancement
• To provide the entry level and mid-career professionals with concrete building blocks to
• create a path for full employment and successful career.
• To provide guidance for ‘How to crack interview’, Do’s and Don’ts of an Interview
• And last but not least To find a Job in Software Database domain in 2 Months

iTpreneur Advantage = Pay Fees on Job

• Certified Corporate Trainers from the IT industry with rigorous understanding of specialized domain.
• Lecture contents prepared by Industry experts.
• Live Projects to work on with IT industry standards.
• Focus on cross cultural and various onshore and offshore client oriented trainings
• Weekly workshop from industry experts
• An innovative teaching methodology delivers in- depth knowledge with quality tailored programs that maximize a return on your investment.
• Strategic Association for global certification

Program Structure

Class Room Training with hands on pracitce

Duration

80 Hours

6 Weeks (Regular/Weekday Batch) & 8 Weekends (Weekends Batch)

Eligibility

• Graduates and Post-Graduates –BSC, BCS, BCA, BE, B.Tech, MSc, MCS, MCA, M.Tech
• No Previous Programming Experience necessary
• Job aspirants looking to make career in Database domain.

Career Prospects

PL/SQL Developer,Database Analyst, OracleDatabase Admin,Oracle-ADF Developer,Data ModelerEng. ,Oracle TraineeEngineer, Oracle SQL Support Engineer, Business Analyst, Oracle HRMS Technical Consultant,SQL/PLSQL Support Executive, Oracle SCM Techno Functional, Oracle Application developer.

Syllabus

Prerequisite:
• Computer Fundamentals, Windows Operating System
• Oracle10g Extensions to DML and DDL Statements
• Regular Expressions
• Multi table Insert

Oracle SQL ( IZ– 047-051): 60hrs

• Introduction
• Writing Basic SQL SELECT Statements
• Restricting and Sorting Data
• Single- Row Functions
• Displaying Data from Multiple Tables
• Aggregating Data Using Group Functions
• Sub queries
• Manipulating Data
• Creating and Managing Tables
• Including Constraints
• Creating Views
• Other Database Objects
• Controlling User Access
• SQL Workshop
• Using SET Operators
• Oracle 10g / 11g Date time Functions

OraclePL-SQL:20hrs.

• Course Contents
• Variables & writing executable statements
• Oracle Server
• Control Structures
• Composite Data Types
• Explicit Cursors
• Advanced Explicit Cursor Concepts
• Exception Handling
• Procedures
• Functions
• Triggers
• Packages
• Oracle Supplied Packages
• Large Objects
• Dependencies.

For More Details Contact

iTpreneur Data System Pvt. Ltd. 2nd Floor, Karnik Corner, Opposite to Wood Land Showroom, JM Road, Deccan, Pune-411004. Call: 020-65302020/ 020-65624040 / 9822878920 / 9689999090 E-mail : info@itpreneurpune.com

Share This Post:

iTpreneu