Oracle employs around 900 people in Ireland, in localisation, sales and product development in their centres in Galway and Dublin.
A sotftware Developer is a person in an organisation concerned with the facets of the software development process, wider than designand codeing a somewhat broader scope of computer programming or a speciality of project managing including some aspects of software product managment.
RDBMS
Short for Relational Database Management System, RDBMS refers to a relational database plus supporting software for managing users and processing SQL queries, performing backups/restores and associated tasks.
Advanced Queue
In computing, Oracle Advanced Queuing (AQ) is a sort of Message Oriented Middleware developed by Oracle Corporation and integrated into its Oracle database.
AQ uses database structures as a repository for asynchronous queuing as an element in various Oracle-oriented and heterogeneous operations. Oracle features utilising Advanced Queuing include:
Oracle Data Guard
Oracle Streams
In Oracle Data Guard primary databases the queue monitor process (often running as qmn0) interacts with AQ.
As of Oracle release 9.2, AQ comes bundled with Standard Edition and Enterprise Edition at no extra cost.
As of Oracle release 10.1, AQ is integrated into Oracle Streams, and is called "Oracle Streams AQ".
Oracle AQ used as the internal Java Message Service provider in the Oracle Enterprise Service Bus.
Oracle AQ is available in all editions of Oracle database, including XE.
SQL
Is a database computer language desinged for the retrieval and managment of data in relational database managment systems.
BPEL
Business Process Execution Language is an oasis standard executable language for specifying interaction with web services. Processes in business process execution language export and import information by using web service interfaces exclusively.
XML
Is a set of rules for encoding documents electronically
JDeveloper
Is a freeware IDE from Oracle. Oracle JDeveloper is the main development platform for Oracles tools
Toad
Quest Software recently released version 9.0 of Toad for Oracle, its “industry-leading, proven database development and administration tool that increases user productivity and application code quality.”
Classes required
Database Systems1
this subjest is mandatory abd starts in semester 3 the learning outcomes are
1 Explain the basic concepts of Database Management Systems and the Relational database model.
2 Develop a data model based on the information given by an enterprise, using an industry standard data modeling notation e.g. UML
3 Develop a data design using the relational data model and normalisation.
4 Implement a database design using SQL data definition language
Database systems 2
Also mandatory in the 4th semester the learning outcomes are
1 Devise solutions to database queries using interactive SQL DML commands, triggers and stored procedures and embedded SQL.
2 Implement solutions to database queries using interactive SQL DML commands, triggers, stored procedures and embedded SQL.
3 Explain issues in physical database design and implementation. Integration of data sources: data cleansing and preparation. Migration and Portablility; Server side processing(triggers and stored procedures).
4 Devise and implement efficient physical database design
Database systems 3
Can be taken as an elective in semester 5 learning outcomes include
1 Compare and contrast approaches to database concurrency management.
2 Devise a recovery plan for a multiuser database.
3 Specify appropriate security measures for a database.
4 Demonstrate an understanding of database management in a multi-user environment by applying concepts of recovery, concurrency, security and data management.
Database optimisation and design
Can be taken as an elective in semester 7 learning outcomes include
1 Develop physical database designs.
2 Describe and explain issues in database query processing and optimisation.
3 Evaluate physical design in terms of efficiency and defend designs in terms of performance.
4 Demonstrate and apply knowledge of physical design and optimisation in a practical way on a multi-user database system.
Specialised database systems
Can be taken as an elective in semester 8 learning outcoms include
1 Develop physical database designs.
2 Describe and explain issues in database query processing and optimisation.
3 Evaluate physical design in terms of efficiency and defend designs in terms of performance.
4 Demonstrate and apply knowledge of physical design and optimisation in a practical way on a multi-user database system.
