Oracle PL/SQL training in Virginia.
Duration: 4 – 6 weeks
2S Informatics is located in Ashburn, VA, is IT training, mentoring and development firm specializing in Database development and Administration, Informatica and Business Objects technologies.
Real-world application and expert best practices set our instructors apart. Having instructors speak from experience and not just from a conceptual perspective is a tremendous value-add for the participants. Because our instructors have extensive industry experience, you reap the benefit of best practices in a wide variety of industries in some of the largest and most successful organizations in the world. Real-world experience also allows our instructors to provide students with practical feedback and professional context.
Our expertise, experience, breadth and depth of knowledge outstrip our competitors. Hand-picked from the top programmers, architects and consultants in the industry, our instructors have an average of 12+ years of experience in designing and developing high-performance, medium/large scale enterprise class applications and has impressive list of credentials.
Trainings: Class Room
Pre-Requisite: Graduate/Software Developer
Timings: 6:30pm - 8:30pm (Tue, Thu) and 8am - 11am (Sat and Sun)
Extras: Interview Questions & Answers will be covered along with course
Placement assistance provided for 3 months after completing training
Please reply to this ad for more details.
Oracle PL/SQL Developer
Duration: 4 – 6 weeks
This is In-Class training, designed for anyone who wants to get job as PL/SQL Developer
After finishing the training candidates will be well versed with topics mentioned below and will be able to perform day to day development activities using SQL, PL/SQL and UNIX Shell scripting, They will also be able to attend interviews as Oracle Database Developer.
Brief Technical overview
Create and Manage Tables, Manipulating Data, Retrieving Data, Restricting, Sorting Data, Reporting Aggregated, Loading Data, Performance Tuning, Batch Processing, Developer custom ETL and Unix shell scripting,
· RDBMS concepts
· Introduction to SQL
· Introduction to DDL, DML and TCL
· SQL single and multiple row functions
· Inner,Outer, Equi, Non Equi, Self Joins
· SubQueries and Set operators
· Views and Materialized views
· Indexes, Partitions
· Introduction to PL/SQL
· Creation of PL/SQL Block
· Procedures, Functions, Packages, Triggers, Control Structures, Concept of Error
· Implicit, Explicit and Ref Cursors
· Collections, Bulk loading concepts
· Introduction to Shell scripting
· Concepts of batch processing
· Creating shell scripts
· Integrating shell scripts with oracle database
· SQL Loader
· External Tables
· Introduction to SQL and PLSQL tuning
· Explain plan, SQL Trace, TKPROF
· Optimizer Hints
Recents Ads for ORACLE 9I SQL PL/SQL Training..