Sun & Oracle Certification courses
(Courses leading to certifications from international IT brands)
What are certification courses?
Aptech offers Sun & Oracle Certification courses. Each paper within a certification course takes 15 days to a month to complete.
On successful completion of the training, students can appear for exams conducted by Sun & Oracle receive a professional certification from them.
Who are these courses meant for?
Working professionals in IT who can get certified & improve their career prospects.
Engineering & IT students who use these courses to fill the gap in their college education & to add international certifications to their resume.
College students who wish to build advanced IT skills & get certifications recognized by IT companies.
Why certification courses?
Courses enjoy industry-wide recognition from all IT employers.
Employers prefer the quality assurance that comes with hiring certified professionals.
Surveys show that certified professionals enjoy better salaries & better career advancement opportunities.
Certifications provide a distinct edge over other IT professionals.
FG 310: Developing Applications for J2EE platform
J2EE is a platform-independent, Java-centric environment from Sun for developing, building and deploying web-based enterprise applications online. The J2EE platform consists of a set of services, APIs, and protocols that provide the functionality for developing multi-tiered, web-based applications
Who will the course benefit?
Students and professionals who wish to gain expertise in web application technologies, Servlets, JSP and Struts
What skills will the student gain?
After the completion of this course, the student will be able to:
Understand the concepts of J2EE Component Model
Develop Server side Internet programmes using JSP and Servlets
Use web-tier Design Patterns
Develop Session and CMP Entity beans
Implement transaction and security policies
Basic computer skills
40 hours
(Additionally, students can appear for the following vendor certifications:
• Sun Certified Java Programmer
• Sun Certified Java Developer)
FJ 310: Developing Applications for J2EE platform
Java is an object-oriented programming language with a built-in Application Programming Interface (API) that can handle graphics and user interfaces and be used to create applications or applets
Who will the course benefit?
Students and professionals who wish to gain expertise in Java
What skills will the student gain?
After the completion of this course, the student will be able to:
Describe Object-oriented concepts
Develop applications using Java programming language syntax
Describe exception handling and Multithreading concepts
Develop GUI and event handling
Connect to the database using JDBC
Develop Java client and server programmes using TCP/IP
1. Basic knowledge of Java programming 2. Basic knowledge of HTML
40 hours
Certificate of participation
SL 314: Web development, Servlets & JSP
A Java Servlet is a Java programme which resides and executes on a server. It provides functionality to the server or processes data on the server. JSP is a freely available specification for extending the Java Servlet to generate dynamic web pages on a web server. The Struts Framework is a standard for developing well-architected web applications
Who will the course benefit?
Students and professionals who wish to gain expertise in web application technologies, Servlets, JSP and Struts
What skills will the student gain?
After the completion of this course, the student will be able to:
Develop Server side Internet programmes using JSP and Servlets
Create reusable web components, JavaBeans
Create Custom Tag Libraries
Create web applications using Struts
1. 1. Basic knowledge of Java programming 2. Basic knowledge of HTML
40 hours
Certificate of participation
(Additionally, students can appear for the Sun Certified Web Component Developer (SCWCD) vendor certification)
Note: Prior to attempting this exam, the candidate must be certified as a Sun Certified Programmer (SCJP)
SL 351: Advanced Business Development with EJB
EJB is a Java API that defines component architecture for writing reusable business logic and portable enterprise applications. EJB focuses on the actual business architecture of the model. EJB components are written entirely in Java and run on any EJB compliant server
Who will the course benefit?
Students and professionals who wish to gain expertise in web application technologies, Servlets, JSP and Struts
What skills will the student gain?
After the completion of this course, the student will be able to:
Describe EJB components
Develop J2EE applications using EJB components
Implement security and transactions
Implement web service Endpoint Interfaces
1. Hands-on Java programming experience 2. Knowledge of object-oriented programming, distributed computing and component technology concepts 3. Knowledge of Servlets, JSP and JDBC programming
40 hours
Certificate of participation
(Additionally, students can appear for the Sun Certified Business Component Developer (SCBCD) vendor certification)
Note: Prior to attempting this exam, the candidate must be certified as a Sun Certified Programmer (SCJP)
Introduction to Oracle 9i - SQL (Paper 1)
SQL*Plus, the primary interface to the Oracle database server, provides a powerful yet easy-to-use environment for querying, defining, and controlling data. Oracle 9i SQL delivers the fundamentals of relational and object-relational databases and the powerful SQL programming language. Paper 1 makes the student strong in Oracle SQL statements, and iSQL*Plus, which is used for executing SQL and for formatting and reporting purposes
Who will the course benefit?
Students and working professionals wishing to gain expertise in SQL
What skills will the student gain?
After the completion of this course, the student will be able to:
Define database
Explain basic SQL statements
Describe the various types of functions available in SQL
Describe and use the different types of joins
Describe subqueries
Describe the process of producing readable output with iSQL*Plus
Explain data manipulation using SQL statements
Describe constraints and views
Describe the various database objects
List and explain Oracle 9i extensions to DML and DDL statements
Prior knowledge of data processing concepts and techniques
40 hours
Certificate of participation
(Additionally, students can appear for Oracle 9i SQL vendor certification)
Oracle 9i: Programme with PL/SQL (Paper 2)
Procedural Language/SQL (PL/SQL) extends SQL by adding constructs found in procedural languages, resulting in a structural language that is more powerful than SQL. This paper introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. By the end of this segment, students will be able to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. The students will also learn to create procedures, functions, packages, and database triggers
Who will the course benefit?
Students and working professionals who wish to gain expertise in PL/SQL
What skills will the student gain?
After the completion of this course, the student will be able to:
Describe the features and syntax of PL/SQL
Explain writing executable statements
Explain the control structures
Describe and use composite data types
Explain the process of writing explicit cursors
Describe subprogrammes
Describe the use of functions
Describe packages in PL/SQL
List and explain Oracle server-supplied packages
Describe triggers
Prior knowledge of SQL, and iSQL*Plus is necessary
40 hours
Certificate of participation
(Additionally, students can appear for Oracle 9i PL/SQL vendor certification)
Oracle 9i DBA Fundamentals - 1 (Paper 3)
A Database Administrator’s (DBA) role is of paramount importance since it deals with critical issues of database design and management. This paper gives a firm foundation in basic database tasks. By the end of this segment, students will be able to design, create and maintain an Oracle database
Who will the course benefit?
Students and working professionals who wish to gain expertise in Oracle database administration
What skills will the student gain?
After the completion of this course, the student will be able to:
Describe the Oracle architecture
Identify the features of the Oracle Universal Installer
Explain the start-up and shutdown of an Oracle instance
Describe the process of database creation
Explain data dictionary and dynamic performance views
Explain control file and redo log files
Explain managing tablespaces and datafiles
Describe the different types of indexes and their uses
Explain resource management and privileges
Explain auditing
Describe globalisation support in Oracle
Prior knowledge of Oracle 9i SQL is necessary
82 hours
Certificate of participation
Additionally, students can appear for Oracle 9i DBA - 1 vendor certification)
Oracle 9i DBA Fundamentals - 2 (Paper 4)
Ensuring the database’s availability for use is one of the Database Administrator’s (DBA) major responsibilities. Backups are critical for recovering from different types of failures. Oracle 9i has several methods to backup and recover Oracle database. RMAN, the powerful recovery manager, simplifies the duties of a DBA. By the end of this segment, students will get a foundation in Oracle Net administration, and backup and recovery operations
Who will the course benefit?
Students and working professionals who wish to gain expertise in Oracle backup and recovery operations
What skills will the student gain?
After the completion of this course, the student will be able to:
Explain solutions included with Oracle 9i for managing complex networks
Explain Oracle Net architecture
Describe the process of database and data file backups
List the different Oracle backup methods and recovery operationsM
Describe the database utilities (Export and Import)
List the Oracle architecture components related to backup and recovery operations
Prior knowledge of SQL, and the Oracle 9i Database Administration Fundamentals I course, are essential
40 hours
Certificate of participation
(Additionally, students can appear for Oracle 9i DBA - II vendor certification)
Oracle 9i Database Performance Tuning (Paper 5)
Database performance tuning is critical to any effective information system. Reducing wait times, increasing users' productivity and maximising the performance of an Oracle database are critical to its success. This paper introduces the importance of good initial database design, and the method to tune a production Oracle 9i database. By the end of this segment, students will gain practical experience in tuning an Oracle database
Who will the course benefit?
Students and working professionals who wish to gain expertise in Oracle database and instance tuning
What skills will the student gain?
After the completion of this course, the student will be able to:
Describe the roles associated with the database tuning process
List the important steps in tuning methodology
Describe how the buffer cache is used by different Oracle processes
Define levels of locking
Describe how to perform tuning tasks with Oracle Enterprise Manager and command line interface
Optimise sort operations
Describe configuring resource manager to control resource usage
Prior knowledge of Oracle 9i Database Administration Fundamentals I and Oracle 9i Database Administration Fundamentals II courses is essential
40 hours
Certificate of participation
(Additionally, students can appear for Oracle 9i Performance Tuning vendor certification)
Forms Developer
The ability to build and deploy web-based database applications easily and rapidly in a declarative and productive manner is of paramount importance. The Oracle 9i Forms Developer enables developers to build web applications that are optimised for the Internet. By the end of this segment, students will be able to build, test, and deploy interactive Internet applications
Who will the course benefit?
Students and working professionals who wish to gain expertise in Oracle 9i forms programming
What skills will the student gain?
After the completion of this course, the student will be able to:
Describe Oracle Forms Developer and Oracle Forms Services
Explain the creation of form modules in multiple windows using layout styles
Explain data blocks and frames
Describe LOVs and editors
Describe the creation of Windows and content canvases
Explain triggers
Explain navigation and transaction processing
Describe multiple form applications
Prior knowledge of Oracle9i SQL and PL/ SQL is essential
40 hours
Certificate of participation
(Additionally, students can appear for Oracle 9i Forms Developer vendor certification)
Reports Developer
Oracle 9i Reports Developer, a part of Oracle 9i Developer suite, is a reporting tool for developing reports against data stored in an Oracle database. This segment teaches students to retrieve data, display it in a desired format, and then publish it. By the end of this segment, students will be able to design and build a variety of standard and custom web and paper reports using Oracle 9i Reports Developer
Who will the course benefit?
Students and working professionals who wish to gain expertise in creating complex reports using Oracle 9i Reports Developer
What skills will the student gain?
After the completion of this course, the student will be able to:
Describe the Oracle 9i Reports Developer
Explain mailing labels and letters creation using templates
Describe basic tabular report creation and modification
Explain report creation using XML
Identify the main components and the relations between them in a report document
Describe the process of publishing a report on the web
Explain the process of maximising report performance using Oracle 9i AS reports services
Explain graph creation and embedding in a report
Prior knowledge of Oracle 9i SQL, PL/SQL, and XML is essential
40 hours
Certificate of participation
Join a Sun or Oracle certification course now!
Aptech also offers Dozens of short-term courses.
