Oracle SQL Developer Tool is a stand alone graphic database developer tool that connects to Oracle as well as third-party databases which can be used to perform a variety of tasks from running simple queries to migration of databases from third party vendor products to Oracle.
This article by Dr. Jayaram Krishnaswamy, shows how the reader may use Oracle's most recent tool, the Oracle SQL Developer 1.5 to work with the MySQL database. An example of migrating a table in MySQL to Oracle 10G XE is also described.Read Migrating a MySQL table using Oracle SQL Developer 1.5 in full
In this two-part article by Jamie Huskisson, we will apply our knowledge of Magento's core architecture and apply it to one of the fundamental building blocks of Magento, its shipping module.
Here, we will learn how to create a shipping module, so that we can develop our own when the need arises. By the end of this article we will:
- Know where to find shipping modules that others have produced
- Know how to put together a basic shipping module and know what values pertain to what information
- Be able to create our own methods for calculation or handling shipping with Magento
In this article by Mauricio Salatino, we will basically have a look at the following points:
- Background about the jBPM project
- Tools and software
- Eclipse IDE
- SVN client
This article by Mauricio Salatino, will give us a basic background into how the framework was built. We will be fully focused on the approach used to implement jBPM. This approach is called Graph Oriented Programming, and we will discuss and implement a basic solution with it. This will guide us to knowing about the framework internals with a simplistic vision. That will give us the power to understand the main guidelines used to build the entire framework.Read jBPM for Developers: Part 1 in full
Oracle SQL Developer Data Modeler is available as an independent product, providing a focused data modeling tool for data architects and designers. There is also a Data Modeler Viewer extension to SQL Developer, which allows users to open previously created data models and to create read-only models of their database schemas. SQL Developer Data Modeler is a vast tool, supporting the design of logical Entity Relationship Diagrams, and relational models, with forward and reverse engineering capabilities between the two. It supports multi-dimensional, data flow, data type, and physical models, and allows files to be imported from a variety sources and exported to a variety of destinations. It allows users to set naming conventions and verify designs using a set of predefined design rules. Each of these topics is extensive, so in this two-part article by Sue Harper (author of Oracle SQL Developer 2.1) we'll review a few of the areas, illustrating how you can use them and highlight a few key features, using the independent, stand alone release of SQL Developer Data Modeler. We'll include a rief review of the integration points of the Data Modeler Viewer extension to SQL Developer. The product offers support for Oracle and non-Oracle Databases. In the interest of time and space, we have elected to only work with the Oracle database.Read Introducing SQL Developer Data Modeler: Part 1 in full
This article by Sue Harper is all about preparing your environment, installation, and getting started with SQL Developer.
SQL Developer is easy to set up and use. The best way to learn is by practice, and for that you'll need a computer with access to an Oracle database and SQL Developer. This article assumes you have a computer with Microsoft Windows, Linux, or Mac OS X installed, and that you have access to an Oracle database. It focuses on the alternative installations available for SQL Developer, where to find the product, and how to install it. Once your environment is set up, you can follow a quick product walk-through to familiarize yourself with the landscape. You'll create a few connections, touch on the various areas available (such as the SQL Worksheet and Reports navigator), and learn about the control of the windows and general product layout.Read Getting Started with SQL Developer: Part 1 in full