GREETINGS FROM GREENS TECHNOLOGY
INTRODUCTION TO ORACLE 9I/10G SQL
INTRODUCTION:
Concepts of relational and object relational databases, SQL programming language, create and maintain database objects and to store, retrieve, and manipulate data. Participants also learn to retrieve data by using advanced techniques like hierarchical retrieval. Learn how to write SQL and SQL*Plus script files using tools like iSQL Plus,TOAD etc.
Duration: 25 hours
PROGRAM CONTENTS
• Describe relational and object relational database concepts
• Retrieve, insert, update, and delete data
• Use the Single row and Group functions
• Retrieve data using additional advanced techniques like using
• Set operators, correlated subqueries and hierarchical queries
• Solve problems by using multicolumn subqueries
• subqueries in the from clause of a SELECT statement, correlated subqueries, and scalar subqueries
• Use the iSQL*Plus environment
• Write scripts to generate script files
• Generate reports using iSQL*Plus
• Create and maintain database objects
• Control transactions
• Control data/user access
• Use the Oracle9i/10g Single row functions
• Use GROUPING SETS and the WITH clause
• Use the Oracle9i/10g extensions to DML and DDL statements
• Apply techniques in real life simulation and Real time Environments.
EXIT PROFILE:
• The candidate would learn how to use Database programming Technology
INTRODUCTION TO ORACLE 9I/10G PLSQL
INTRODUCTION
This course introduces PL/SQL and understand the benefits of PL/SQL Students learn to create procedures, functions, packages, and database triggers. Use iSQL*Plus to develop these program units, manage PL/SQL program units and database triggers, to manage dependencies, to manipulate large objects, and to use some of the Oracle-supplied packages.
Duration: 25 hours
PROGRAM CONTENTS:
• Describing 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 Subprograms
• Creating Packages
• More Package Concepts
• Using Oracle-Supplied Packages
• Creating Database Triggers
• More Trigger Concepts
• Managing Dependencies
• Manipulating Large Objects
PRE REQUISITES:
• Participants should be familiar with SQL development
• Prior knowledge of RDBMS
EXIT PROFILE:
• The candidate would learn how to create PL/SQL blocks of application code that can shared by multiple forms, reports and data management applications
GLOBAL CERTIFICATION MAPPED:
• Program is mapped with ORACLE 10G DEVELOPER OCA certification
Atten one of our free demo class and get more idea.
My training benefits
My batch sizes are generally very small size 3-4 members OR 1 to 1 also, so students receive direct, hands-on training from us.
100% practical training only.
It is not a slide show training program / theory class program.
At the end of this class, definitely you will refer your colleagues / friends / relatives for my training.
Conducting regularly online- training for US peoples in all time zones (PST,CST,EST,HST,MST).
Installation of software’s in your desktop / laptop will be done.
Will be provided self evaluation testing software, exam simulator, dumps & books with this training.
Continuous support is provided for any of your on-site problems.
Placement assistance will be provided and you will be recommended to some of IT development firms.
The class would be conducted on ALL DAYS
Do pass this info to all your near and dear for utilizing this great opportunity.
Why should I Learn from Greens Technology?
1. Only Experienced Software Professionals having more than 10 Years working in Top MNC's like Infosys,IBM,Verizon,Syntel,HP,TCS,Wipro,CTS
2. 100% placement assistance,90% of our Previous Students are Placed in Various Companies
3. 100% certification assistance. Fees Affordable and Worth paying for what you get.
4. All Courses are designed to match with most of the corporate companies requirements.
5. Training session on personality development and interview facing techniques @ free of cost.
6. For further details visit our web site
Also we offers
Java Technologies
Core Java, JDBC, RMI, JNDI,J2EE, JSP, Servlets, Struts,EJB, JSF, Hibernate, Springs, Jaxp, JUnit , Web Logic,Eclipse3.2 , Design Patterns, Web Services with UML Oracle 9i, Oracle 10g.Oracle 11g.
Microsoft Technologies
VB.NET, ASP.Net, C#.Net, ADO.Net, XML, Web Services, VB, ASP, ATL COM, DCOM, SQL Server 2000 & 2005 programming and admin, Windows 2003 Server Admin, Windows Clustering, XP Admin, Exchange Server.
We also offer Real Time Project Training for final year students on the following Technologies
Java Technologies
Microsoft Technologies
Vist:
http://www.youtube.com/watch?v=zFNDxEOfsV0
http://maps.google.co.in/maps?hl=en&q=greens+technology&um=1&ie=UTF-8&sa=N&tab=wl
Contact
LAKSHMIKANTH
Mobile : 9840496320
Website: www.greenstechnologys.com
Email-id: greens.adyar@gmail.com