| |
| Oracle Certified Professional |
 |
| Oracle is a Relational Database Management System (RDBMS). Oracle is the latest technology, today's system Designers and Developers can build 21st century enabled applications.
Oracle has also demonstrated a continuous ability to build products that help us exceed the demands of the information enabling age we live in. |
|
| TOPICS COVERED IN ORACLE CERTIFIED PROFESSIONAL |
|
* Introduction to oracle products.
* SQL*plus features and commands.
* Data manipulation commands, data control commands.
* Altering tables, data definition commands, joins, types of functions.
* Process Transaction commands, SQL*plus set theory.
* Sub-queries and Co-related queries.
* Security in Oracle
* Locking
* Oracle Objects - Views, clusters, indexes, synonyms, snapshots.
* Formatting output of queries, Report creation.
* Implementing Object Oriented features in Oracle.
* Introduction to PL/SQL.
* Packages
* Creating Cursors, exceptions, procedures, functions and triggers.
* Understanding the Oracle Architecture.
* Features of Latest Oracle Version.
* Data Dictionary
* DBA-An Overview
|
|
| SALIENT FEATURES OF ORACLE CERTIFIED PROFESSIONAL |
|
* Oracle has sophisticated security mechanisms control access to sensitive data by an assortment of privileges.
* Oracle provides sophisticated backup & recovery routines. Backup creates a second copy of Oracle Data, recovery restores a copy of data from back up.
*
Oracle provides flexible space management. It has special abilities that are capable of handling very large databases.
*
Oracle provides open connectivity to & from other vendor's software
*
Oracle server supports a wide range of Development tools, end user query tools, off the shelf applications & office wide information tools. |
|
| APPLICATIONS OF ORACLE CERTIFIED PROFESSIONAL |
|
* Education Industry
* Software Development Industry
* Data warehouse and maintenance
* Domestic Air Services
* Production Industry
* Banking Industry
|
 |
| Oracle9i Administrator |
|
Oracle9i is a Relational Database Management System(RDBMS) with Object Relational Database Management(ORDBMS) futures. Oracle9i is the latest technology, which has many new features over previous versions like 8i and 8. Oracle9i comes with new SQL/PLSQL enhancements. |
|
| TOPICS COVERED IN ORACLE 9i ADMINISTRATOR |
|
* Writing Basic SQL Select Statement.
* Restricting and Sorting Data.
*
Displaying Data from Multiple Tables.
*
Aggregating Data Using Group Functions.
*
Sub queries.
*
Producing Readable Output with iSQL*Plus.
*
Manipulating Data.
*
Creating and Managing Tables.
*
Including Constraints.
*
Creating Views.
*
Other Database Objects.
*
Controlling User Access.
*
SQL Workshop.
*
Using Set Operators.
* Date time Functions.
* Enhancements to Group by Clause.
*
Advanced Sub queries.
*
Hierarchical Retrieval.
*
Extensions to DML and DDL Statements. |
|
| SALIENT FEATURES OF ORACLE 9i ADMINISTRATOR |
|
* Oracle has sophisticated security mechanisms control access to sensitive data by an assortment of privileges.
* Oracle provides sophisticated backup & recovery routines. Backup creates a second copy of Oracle Data, recovery restores a copy of data from back up.
*
Oracle provides flexible space management. It has special abilities that are capable of handling very large databases.
*
Oracle provides open connectivity to & from other vendors software.
*
Oracle server supports a wide range of Development tools, end user query tools, off the shelf applications & office wide information tools. |
|
| APPLICATIONS OF ORACLE 9i ADMINISTRATOR |
|
* Education Industry
* Software Development Industry
* Data warehouse and maintenance
* Domestic Air Services
* Production Industry
* Banking Industry
|
|
| SQL Server 2000 |
|
| SQL Server is the Database Management System(RDBMS) that allows to store huge Databases and manage the same easily. It is an enterprise database management and analysis system. |
|
| TOPICS COVERED IN SQL SERVER 2000 |
|
* Basics of RDBMS
* Introduction to SQL (Structured Query Language)
*
Querying data from SQL Server database
*
Developing various objects like tables, views
*
Data Integrity - Constraints, Rules, Defaults
*
Programming in SQL Server
*
Security in SQL Server - Creating users and ensuring authentication.
*
Creating stored programs
*
Procedures
*
Functions
*
Triggers
*
Working with SQL Enterprise Management window.
*
SQL Server new features. |
|
| SALIENT FEATURES OF
SQL SERVER 2000 |
|
* XML Support : Simplify the integration of your back-end systems and data transfer across firewalls using XML.
* High Availability : Maximize the availability of your business applications with log shipping, online backups.
* Automated Tuning : Automatic tuning and maintenance features enable administrators to focus on other critical tasks.
* Improved Developer Productivity : User-defined functions, cascading referential integrity, and the integrated Transact-SQL debugger allow you to reuse code to simplify the development process.
* Security : Ensure your applications are secure in any networked environment, with role-based security and file and network encryption.
* Data Transformation Services : Automate routines that extract, transform, and load data from heterogeneous sources. |
|
| APPLICATIONS OF SQL SERVER 2000 |
|
* Multinational Companies with huge database to be maintained
* Banking Industry
*
Production Industry
*
Data warehousing companies
*
Educational / Training Industry
*
Air-transportation Service Industry
*
Any business or service industry that stores database |
|
| PHP & MySQL |
|
| PHP is a powerful cross platform server side scripting language. It is a full featured programming language capable of managing huge database driven online environments. Using PHP you can query databases, create dynamic images, create e-commerce websites, manage security for online transactions, read & write files on the server, talk to remote servers - the possibilities are endless. MySQL is a small, compact database server ideal for stand-alone and enterprise applications. The PHP-MySQL combination is also cross-platform. |
|
| SALIENT FEATURES OF PHP & MySQL |
|
|
* PHP is an HTML-embedded server side scripting language. Much of its syntax is borrowed from C, Java and Perl with a couple of unique PHP-specific features thrown in. The goal of the language is to allow web developers to write dynamically generated database driven pages quickly. |
|
| APPLICATIONS OF PHP & MySQL |
|
|
* Open source has brought a lot more than Unix to the computing world. It has also given us Linux, PHP and MySQL. PHP and MySQL are the world's best combination for creating database-driven sites. |
|
Java Development Kit (JDK) |
|
| Java is a Platform Independent, Reliable Programming language introduced by SUN systems, used mainly to Develop Internet applications and applets. |
|
| SALIENT FEATURES OF JAVA DEVELOPMENT KIT |
|
* Java is two stage system having both compiler & interpreter.
* Java is Platform Independent & Portable language. Thus Java Programs can be moved from one computer to another computer, irrespective of the hardware or operating systems.
* Java supports object oriented concepts. Java comes with an extensive set of classes which can be used by inheritance.
* Java allows us to have animation, audio and video clippings in our web page.
* Java provides many safeguards for security. It has strict, compile & run time checking for data types. Java also has concept of error handling which captures errors & eliminates any serious risk to the system.
* Java is a distributed language i.e. it can be used across various networks.
* Java is a simple language as compared to other object oriented languages.
* Java supports multithreading i.e. one can perform multiple tasks in a system, independent of each other.
* Java is capable of dynamic linking.
* Java is an extensible language.
|
|
| TOPICS COVERED IN JAVA DEVELOPMENT KIT |
|
* Introduction to Object Oriented Programming.
* Java Basic: Data types, Object, Arrays, Strings, Operators, Statements, Exception Handling (try-catch-finally).
* Classes & Objects in Java: Constructors, destructors, class methods, extending a class, overriding methods, visibility modifiers, abstract classes and interfaces.
* Applets & Event Handling: Drawing graphics, reading apple parameters, animation.
* Graphical User Interface: Introduction to GUI components and event handling.
* Multithreading.
* Introduction to Swing Package.
* Input & Output: File operations like creating, reading and modifying a file.
* Database Connectivity ( JDBC ).
* Advanced Graphics: Smooth Animation and keeping track of images.
* Network Engineering: URL contents downloading, using URL connection, Introduction to sockets and Client & Server Programming using connection objects.
|
|
| APPLICATIONS OF JAVA DEVELOPMENT KIT |
|
| * Java is used to create web-based applications and allows user interaction on the Internet.
* Java Programs can be used to connect to any computer on the Internet and have financial transactions.
|
|
|
| JavaScript |
|
JavaScript is a script-based Programming language that supports the Development of both client and server components on client side. |
|
| TOPICS COVERED IN JAVA SCRIPT |
|
* Introduction to Navigator Scripting and Navigator Objects.
* JavaScript values, names & literals.
* JavaScript expressions and operators.
* Creating JavaScript object model, built-in objects and functions.
* Tracking mouse events and window events.
* Working with status bar, date objects, random numbers, Windows using functions of JavaScript.
* Creating arrays, documents, back and forward buttons.
* Validating forms and Submitting form input.
* JavaScript objects like links, anchor, button, checkbox, date, document, elements array, form, frame, hidden, history, location, math, navigator, password, radio, reset, select, string, submit, text, text area and window.
* Introduction to CGI.
|
|
| APPLICATIONS OF JAVA SCRIPT |
|
| * It is used to write Programs that are executed by a web-browser within the context of web page on server side.
* It can be used to write web server Programs to process the data.
|
|
|
| JDBC |
|
| JDBC technology is an API that lets you access virtually any tabular data source from the JavaTM programming language. It provides cross-DBMS connectivity to a wide range of SQL databases, and now, with the new JDBC API, it also provides access to other tabular data sources, such as spreadsheets or flat files. |
|
| SALIENT FEATURES OF JDBC |
|
* JDBC programs are platform and Vendor independent.
* JDBC components inter-operate with Database and connect via JDBC-ODBC bridges. |
|
| APPLICATIONS OF JDBC |
|
* You can use JDBC in both applications and applets.
* Database vendors and database tool vendors can supply the low level drivers.
*
Thus, they can optimize their drivers for their specific products.
*
With JDBC you can write useful programs to handle realistic database chores. |
|
| JAVABEANS |
|
| JavaBeans component architecture is the platform-neutral architecture for the Java application environment. |
|
| SALIENT FEATURES OF JAVABEANS |
|
* It is the only component architecture you should consider if you're developing for the Java platform.
* The JavaBeans architecture takes inter-operability, a major step forward so that your code runs on every OS and also within any application environment.
*
JavaBeans components inter-operate with ActiveX and connect via ActiveX-JavaBeans bridges. |
|
| APPLICATIONS OF JAVABEANS |
|
* It is the ideal choice for developing or assembling network-aware solutions for heterogeneous hardware and operating system environments within the enterprise or across the Internet.
* JavaBeans component architecture extends "Write Once, Run AnywhereTM" capability to reusable component development.
*
A beans developer secures a future in the emerging network software market without losing customers that use proprietary platforms. |
|
| Java-Servlet |
|
| Servlets are used for Server-Side Programming. Servlets are generic extensions to Java-enabled servers. Their most common use is to extend Webservers, providing a very secure, portable and easy-to-use replacement for CGI. A Servlet is a dynamically loaded module that services requests from a Webserver. It runs entirely inside the Java Virtual Machine. |
|
| SALIENT FEATURES OF JAVA-SERVLET |
|
* Processing data posted over https using an HTML form, including purchase order or credit card data. A servlet like this could be part of an order-entry and processing system, working with product and inventory databases, and perhaps an on-line payment system.
* Allowing collaboration between people. A servlet can handle multiple requests concurrently; they can synchronize requests to support systems such as on-line conferencing.
* Forwarding requests. Servlets can forward requests to other servers and servlets. This allows them to be used to balance load among several servers that mirror the same content. It also allows them to be used to partition a single logical service over several servers, according to task type or organizational boundaries.
* Being a community of active agents. A servlet writer could define active agents that share work among each other. Each agent would be a servlet, and the agents could pass data among themselves
|
|
| APPLICATIONS OF JAVA-SERVLET |
|
* Create JDBC connection pool.
* Create an Online Catalog System.
* Developing E-Commerce "store fronts" will become one of the most common uses for Java servlets.
* Servlets can be used to deploy Websites that open up large legacy systems on the Internet.
|
|
| TOPICS COVERED IN JAVA-SERVLET |
|
* Servlet Overview & Architecture.
* Servlet Basics.
* Servlet & Html.
* SSI (Server - Side Include).
* Servlet chaining.
* Servlet & the JDBC.
* Servlet Beans.
* Javaserver Pages.
* Servlets as Distributed Object Clients.
* Servlet Session.
|
| |
| JSP |
|
| JavaServer Pages involves generating HTML pages from hybrid HTML/Java source files. These source files are typically named using the .jsp extension (though this isn’t a requirement). Java source code is embedded in .jsp pages using JSP tags that are described in the JSP 1.1 specification. |
|
| SALIENT FEATURES OF JSP |
|
| * JSP allows you to combine the HTML of a Web page with pieces of Java code in the same document. The Java code is surrounded by special tags that tell the JSP container that it should use the code to generate a servlet, or part of one. The benefit of JSPs is that you can maintain a single document that represents both the page and the Java code that enables it. |
|
| APPLICATIONS OF JSP |
|
| * Open source has brought a lot more than Linux to the computing world. It has also given us PHP and MySQL. PHP and MySQL are the world's best combination for creating data-driven sites. |
| |
| J2EE |
|
| J2EE is a multitiered application architecture. The J2EE specification defines roles based on certain functionality in the normal course of development and deployment of a J2EE application. its complexity. |
|
| SALIENT FEATURES OF J2EE |
|
* A J2EE component is a self-contained functional software unit that is assembled into a J2EE application; it then interfaces with other application components. |
|
| APPLICATIONS OF J2EE |
|
|
* You can develop servlet-based Web application that can process HTML forms and generate dynamic content using the J2EE. Source : compufield.com |
|
