Wydawca: Packt Publishing
Sue Harper, Susan Harper
As technology rapidly evolves, many developers are looking for valuable tools to assist them with their daily tasks. When dealing with databases, a clean, easy-to-navigate interface for working and browsing is essential. Oracle SQL Developer is a graphical user interface that makes life much easier by allowing you to browse database objects, run SQL statements and scripts, and create, edit, and debug PL/SQL statements in the most efficient way. It enhances productivity and simplifies your database development tasks. Although the SQL Developer journey looks simple and easy, there are many areas that can go undiscovered, leaving you just scratching the surface.It's easy to get started and master this powerful tool with this book to hand. It will provide you with in-depth details about all aspects of using SQL Developer to assist you in your day-to-day database tasks and activities. You will learn to utilize SQL Developer's extensible environment to support your ongoing needsThis book offers detailed instructions for installing, configuring, and effectively using Oracle SQL Developer. You will learn how to utilize every feature of this development tool and make the most out of it. While none of the tasks are complex, the book progresses from the easy, most commonly used features, such as browsing objects and writing queries in the SQL Worksheet, to the more involved and possibly less frequently used features, such as Tuning and Testing SQL and PL/SQL, and adding User Extensions, and finally to those features used by a smaller more targeted audience, such as Migrations, Oracle APEX, and the Data Modeler. Throughout the book there are tips and suggestions gathered as a result of working with the current SQL Developer user base. This book will also show you how to assess the health of your database with built-in as well as customized reports.By the end of the book you will be confident in making the best use of SQL Developer, and be able to set up and maintain a productive environment for quick and easy database development.
Ajith Narayanan, Susan Harper
At times, DBAs support 100s of databases at work. In such scenarios, using a command-line tool like putty adds to the difficulty, while SQL Developer makes the life of a developer, DBA, or DB architect easier by providing a graphical user interface equipped with features that can bolster and enhance the user experience and boost efficiency. Features such as DBA panel, Reports, Data Modeler, and Data Miner are just a few examples of its rich features, and its support for APEX, REST Services, timesten, and third-party database drivers demonstrate its extensibility.You may be a newbie to databases or a seasoned database expert, either way this book will help you understand the database structure and the different types of objects that organize enterprise data in an efficient manner. This book introduces the features of the SQL Developer 4.1 tool in an incremental fashion, starting with installing them, making the database connections, and using the different panels. By sequentially walking through the steps in each chapter, you will quickly master SQL Developer 4.1.
Dirk Manuel
As the complexity of software applications increases and the length of the implementation life cycles decreases, companies are looking for effective ways of training users in new applications, and the new releases of existing applications. Oracle's User Productivity Kit solves these problems by enabling the rapid creation of software application simulations, which are used for training purposes or to generate business documents. Although UPK provides such advanced features, nothing has been written about this application yet.This book provides a guided approach to building high-quality, re-functional simulations of tasks performed in software applications. With this book in hand, it is easy for organizations that are implementing or upgrading software to meet their full training and documentation requirements. This book explains how to harness all of the functionality provided by Oracle's User Productivity Kit, formerly known as OnDemand, to develop better quality training. It also covers the advanced topics of customizing UPK's built-in delivery formats, and defining new ones to extend the capabilities of UPK.This book explains how to make the most of Oracle User Productivity Kit's available functionality to create high-quality simulations. These simulations can be used during instructor-led training, self-directed learning, or refresher training. By following the approach described in this book, you will create world-class training material that your trainees will find useful, engaging, and informative. As a result, they will remember more of what they are taught, and will be better equipped to use the application on which you are training them. In turn, they will become more productive sooner, make fewer mistakes, and require less support. To ensure effective knowledge transfer through training simulations, it is necessary to add a business context to recordings, and to provide additional explanations. This book will teach you more than simple mouse-clicks and keystrokes.
Tarry Singh
Virtualization is taking the technology world by storm and dramatically helping organizations save money. Oracle VM is free and forked from the open source Xen hypervisor, which brings down your upfront costs for an agile data center. The robust capabilities and easy-to-use web interface of Oracle VM Manager helps administrators manage their Internal Data Center from anywhere in the world, helping us come closer to ubiquitous computing.This practical book will give you hands-on experience on how to manage your Virtual Machines using Oracle VM Manager. Equipped with step-by-step installation and management information you will not only learn to manage your Virtual Data Center but also will include this guide among the books you consider most essential.This book will take you into the various methods of importing Virtual Machines. You will learn to import VMs through HTTP/FTP, Repository servers, and even import other VM formats such as VMware VMs. You will also learn about the Xen utilities such as xm, xentop, and virsh. You will learn to manage your VMs through the simple and intuitive web interface of Oracle VM Manager. No matter how compact it may seem, this book covers all the essentials while keeping your learning experience to the point. The book has been deliberately written in a conversational manner so that you feel at home while learning Oracle VM Manager.
Bob Griesemer, Robert E Griesemer
In today's economy, businesses and IT professionals cannot afford to lag behind the latest technologies. Data warehousing is a critical area to the success of many enterprises, and Oracle Warehouse Builder is a powerful tool for building data warehouses. It comes free with the latest version of the Oracle database.Written in an accessible, informative, and focused manner, this book will teach you to use Oracle Warehouse Builder to build your data warehouse. Covering warehouse design, the import of source data, the ETL cycle and more, this book will have you up and running in next to no time.This book will walk you through the complete process of planning, building, and deploying a data warehouse using Oracle Warehouse Builder. By the book's end, you will have built your own data warehouse from scratch.Starting with the installation of the Oracle Database and Warehouse Builder software, this book then covers the analysis of source data, designing a data warehouse, and extracting, transforming, and loading data from the source system into the data warehouse. You'll follow the whole process with detailed screenshots of key steps along the way, alongside numerous tips and hints not covered by the official documentation.
Bob Griesemer, Robert E Griesemer
In today's economy, businesses and IT professionals cannot afford to lag behind the latest technologies. Data warehousing is a critical area to the success of many enterprises, and Oracle Warehouse Builder is a powerful tool for building data warehouses. It comes free with the latest version of the Oracle database.Written in an accessible, informative, and focused manner, this book will teach you to use Oracle Warehouse Builder to build your data warehouse. Covering warehouse design, the import of source data, the ETL cycle and more, this book will have you up and running in next to no time.This book will walk you through the complete process of planning, building, and deploying a data warehouse using Oracle Warehouse Builder. By the book's end, you will have built your own data warehouse from scratch.Starting with the installation of the Oracle Database and Warehouse Builder software, this book then covers the analysis of source data, designing a data warehouse, and extracting, transforming, and loading data from the source system into the data warehouse. You'll follow the whole process with detailed screenshots of key steps along the way that have all been updated for the new Fusion Client Platform interface in 11gR2, alongside numerous tips and hints not covered by the official documentation. You’ll finish up with a brand new chapter on code templates where you’ll implement a complete mapping using JDBC connectivity and code template mappings.
Vadym Gurevych
If you have an osCommerce-based online business, you need this book. Packed with expert guidance on all aspects of building a better online, this book will make your store stand out from the crowd.All approaches and techniques described here are proven to have worked well for successful osCommerce-based online businesses among the, over 650, all around the globe with which the author has been actively involved as developer, project manager, or online business consultant.osCommerce is an open-source e-commerce solution written in PHP and MySQL that can be set up on various platforms. More than 10,000 businesses and sole traders all around the world benefit from its features and flexibility. The importance of the osCommerce community consisting of over 100,000 can not be stressed enough as this is where both online merchants and web developers can communicate and find solutions. There are many contributions ?˘‚Ǩ‚Äù modules for osCommerce that further extend its functionality ?˘‚Ǩ‚Äù making it suitable for almost every business's requirements.