Tutorials

Tutorials

• How to create Oracle Multitenant database user accounts

  Database administrator Brian Peasland outlines the process of creating users in an Oracle Multitenant environment and details new views in the Oracle data dictionary.  Continue Reading

• Oracle upgrades: Tips and trends

  If you’re planning an Oracle upgrade, start here to learn about the latest Oracle upgrade trends. Also, get expert advice from Oracle gurus and learn about the current state of Oracle Fusion Middleware upgrades.  Continue Reading

• Oracle database upgrade guide

  If you’re considering a move to a new Oracle database version -- especially Oracle Database 11g or Oracle Database 11gR2 -- read our Oracle database upgrade guide for tips and customer success stories.  Continue Reading

• Oracle application upgrade guide

  Read this Oracle application upgrade guide for news, demos and advice on the latest in Oracle application upgrades, whether you’re upgrading Oracle E-Business Suite, PeopleSoft or to Oracle Fusion applications.  Continue Reading

• RAD Studio 2010 supports Oracle databases, .NET environments

  The three versions of Embarcadero’s RAD Studio 2010 are designed for individual developers and teams of developers building client-server and RAD Web applications for native Windows and .NET.  Continue Reading

• Toad 10: Good for database developers, good for administrators

  A major strength of Toad 10 is its ability to serve both Oracle database application developers and administrators equally well.  Continue Reading

• Codeless AJAX development improves Alpha Five V10 for the Web

  By adding a form of codeless AJAX development, Alpha Software lets V10 developers create Web-based apps with richer user interface controls.  Continue Reading

• Oracle application development trends toward the Web

  With the economy forcing developers to pursue less expensive methods of Oracle application development, many are evaluating Web development tools, including those for Rapid Application Development.  Continue Reading

• Oracle APEX is totally RAD for Web development

  Oracle’s Application Express (APEX) development environment allows developers to create Web applications quickly for Oracle databases that feature Rapid Application Development (RAD) tools.  Continue Reading

• Oracle data warehousing tutorial

  In this Oracle data warehousing tutorial, learn data warehousing basics and data warehousing concepts. Get tips on using data warehousing tools, find out the most useful Oracle data warehousing features and learn about the most common data ...  Continue Reading

• Oracle business intelligence guide

  In this Oracle business intelligence guide, learn how to start an Oracle business intelligence implementation with BI advice from the experts. Get the latest Oracle business intelligence news, understand basic business intelligence concepts and ...  Continue Reading

• Oracle ETL tools tutorial

  In this Oracle Extract, Transform and Load (ETL) tutorial, learn how to evaluate Oracle ETL tools, understand ETL concepts and read advice on ETL basics from our panel of experts.  Continue Reading

• How to determine your SQL database through needs analysis

  Finding the best SQL database for your company can be a long-drawn-out process that should not be taken lightly. The journey starts with a single step: a thorough 'needs analysis.  Continue Reading

• The MySQL open source database in the enterprise

  The MySQL open source database is not a head-to-head competitor with the SQL database offerings of Oracle, IBM and Microsoft, but many have discovered its hidden advantages.  Continue Reading

• Breaking down the contenders in the SQL database market

  In this chapter we take a look at the relative strengths and weaknesses in the SQL database offerings of The Big Three in the SQL database market: Oracle, IBM and Microsoft.  Continue Reading

• Diving deeper into the SQL database features

  There are dozens of SQL database features for Oracle, IBM and Microsoft that have advantages and disadvantages that must be sorted through. This guide should help.  Continue Reading

• Guide to Oracle virtualization licensing and support

  In this guide, learn about Oracle virtualization licensing and support policies and how Oracle licensing and support for virtualization stacks up against its competition.  Continue Reading

• Oracle virtualization introduction guide

  This introductory guide to Oracle virtualization is designed to help you define and understand the basics of Oracle virtualization including Oracle's VM.  Continue Reading

• Guide to Oracle's virtualization strategy

  This guide to Oracle virtualization strategy covers how Oracle VM fits into the virtualization market, and Oracle's recent acquisition of Virtual Iron.  Continue Reading

• Oracle VM vs. VMware: A closer look

  Trying to decide between Oracle VM and VMWare for your Oracle virtualization needs? Read this Oracle VM vs. VMWare guide for a side-by-side comparison of the two Oracle virtualization vendors.  Continue Reading

• Oracle applications learning guide

  This learning guide is a one-stop shop for information on Oracle's changing role in the enterprise applications space, with news, analysis and tips on Oracle's acquisitions, Project Fusion, E-Business Suite and other apps, the battle between Oracle ...  Continue Reading

• Stored procedures in PL/SQL

  Learn about Oracle PL/SQL stored procedures, such as the stored procedure definition and stored procedure examples in this PL/SQL tutorial for beginners and experts.  Continue Reading

• PL/SQL functions and triggers in Oracle

  Learn about using Oracle PL/SQL functions and triggers, such as how to import a trigger and how and when to use a PL/SQL function in this PL/SQL tutorial.  Continue Reading

• PL/SQL datatypes in Oracle

  Learn about PL/SQL datatypes in Oracle, and learn the definitions of BLOB, CLOB, DATE, VACHAR2 and more in this PL/SQL tutorial for beginners and experts.  Continue Reading

• Choosing the right server hardware is all about choosing the right software

  Before evaluating the server hardware, knowing what edition of Oracle 11g to choose and whether to run that edition on a virtualized server is crucial. This section takes a look at factors to consider in making that decision.  Continue Reading

• Can Sun shine running Oracle 11g?

  Until the recent past, not many users would consider using a Sun server to run a departmental database. With the Oracle-Sun merger, that could change. Here are some Sun contenders worthy of consideration.  Continue Reading

• The best of the Oracle 11g-ready servers

  With all the software upgrade choices made, it is time to look at the server hardware. This section is a deep dive comparing the technical merits of five servers deemed capable of running Oracle 11g database with good performance.  Continue Reading

• Comparing servers for Oracle database 11g upgrades

  An Oracle 11g upgrade means server hardware will need more octane. Find out how to compare Oracle 11g servers for database upgrades and which servers will speed performance.  Continue Reading

• Oracle database upgrades: the in-place vs. migration upgrade decision

  With a full understanding of Oracle 11g's capabilities and how you plan to exploit them, it is time to plan the upgrade. But do you carry out an in-place upgrade or a migration upgrade? This section examines the pros and cons of each  Continue Reading

• Oracle data export guide

  Exporting data is a common task for an Oracle DBA, but not necessarily a straightforward one. In this compliation of questions and answers, SearchOracle.com's resident Oracle experts Eli Leiba, Karen Morton and Brian Peasland explain how it's done, ...  Continue Reading

• Solving common Oracle error codes guide

  Solve your Oracle errors quickly and easily with help from this fast guide. It covers every expert response pertaining to Oracle errors on SearchOracle.com.  Continue Reading

• Oracle database performance tuning guide

  Learn the tricks of industry experts for identifying and eliminating performance problems in this guide. Topics include tuning fundamentals and fallacies, explanations of performance tuning tools, disk I/O and SQL tuning specifics, and common ...  Continue Reading

• Oracle database security guide

  Keeping data and systems secure is a must for any Oracle DBA. Beyond patching known security flaws, there is a great deal a DBA can do to protect Oracle DBMSs and applications from security breaches, both from inside and outside your organization....  Continue Reading

• Crash Course: Oracle basics

  This crash course will bring you up to speed on Oracle DBMS basics for versions 8.x through 9.x, and provide you with an overview of Oracle10g's new tools and features.  Continue Reading

• Fast guide to finding and keeping an Oracle job

  If you're looking for a new Oracle job or want to keep the one you have, check out these valuable Oracle career resources, including job interview, hiring and salary information.  Continue Reading

• Relational Database Management System (RDBMS) fundamentals tutorial

  New to database administration or development? Here's a quick guide that can get you started by providing background on the relational model and practical advice for working with a relational database management system.  Continue Reading

• SQL guide for Oracle users

  Whether you are a newbie or a seasoned expert looking to tweak query performance, this learning guide to the structured query language (SQL) has something for you. These seven chapters can help you figure out how to get the data you need by looking ...  Continue Reading

• Learning Guide: Backup and recovery

  Backup and recovery is arguably the DBA's most important responsibility. This Learning Guide covers everything from the basics of creating a backup and recovery plan to the specifics of using RMAN and other methods of hot and cold backups. Samples ...  Continue Reading

• Oracle PL/SQL tutorial

  This PL/SQL tutorial can help both newbies and veterans become better acquainted with the Oracle development language and hone their developer skills.  Continue Reading

• Fast Guide: Becoming an Oracle Certified Professional

  This fast guide offers expert advice on every aspect of Oracle certification, from beginning your training to implementing new skills in the workplace.  Continue Reading

• Importing into Oracle tutorial

  SearchOracle.com's resident Oracle experts Karen Morton and Brian Peasland guide users through some importing tips and techniques, such as how to load text files without SQL*Loader, importing a dump multiple times, importing from different versions,...  Continue Reading