Software Analyst Track B -Continued

Oracle 9i and 10GDBA: Includes both 8 & 8i DBA. ‘i’ in Oracle 8i, Oracle 10G and object relational technology, architecture, database objects, SQL and PL/SQL: Language constructs, syntax, and usage; data definition language, data manipulation language, data control language; basic data modeling and database design and basic Oracle Procedure Builder; architecture, startup and shutdown, database creation, managing database internal and external constructs (such as rego logs, rollback segments, and tablespaces) and all other structures. Backup and Recovery: motives, architecture as it relates to backup and recovery, backup methods, failure scenarios, recovery methodologies, archive logging, troubleshooting; Performance. Tuning: diagnosis of tuning problems, database optimal configuration, shared pool tuning, buffer cache tuning, Oracle block usage, tuning rollback segments and redo mechanisms, monitoring and detection lock contention, tuning sorts, tuning in OLTP, SDD and mixed environments, and load optimization; data warehousing features.
Java Programming: Introduction to Java, Java environment, Object oriented programming in Java, Java program structure, programs, data, variables and calculations; loops and logic; arrays and strings, defining classes, methods, constructors, recursion, packages, class members, nested classes; extending classes and inheritance, polymorphism, universal superclass, interfaces; exceptions; streams, files and stream output, stream input, and object streams; utility classes, vector collections; threads; creating Windows; container layout managers, adding menu to a Window, more on applets; handling events; JDBC, mapping relational data onto Java objects, calling procedures, handling errors, browsing a database, running JDeveloper against Oracle, the AppBrowser; JDBC connecting to Oracle8i.

Java Server Pages: Evolution of the Web Server, getting started with java server pager and servlets, creating HTML forms, saving data between requests, debugging and error handling, organizing applications, interacting with java beans, performance, JSP and servlet lifecycles, browser interaction with the server, core servlet components, core java server page components, JSP directives, introduction to application architecture, browser-server interaction, single-tiered interaction, building two-tiered applications, designing three-tiered applications, using RMI in a web application, using CORBA in a web application, using enterprise javabeans in a web application.

Data Modeling using ERWin: Installing, features, logical and physical models, view support, enhanced user interface, enhanced editors, report browser, templates, many-to-many transform, information systems, databases, and models. Constructing a logical database. The Key-based model. Naming and defining entities and attributes. Refining model relationships. Normalization. Creating a physical database. Dependent entity types. Business process reengineering, modelers, generators.

Track B First Page