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 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 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
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
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
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
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
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
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

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

Cloudera adds data engineering capability to enable DataOps

Big data vendor Cloudera is looking to help data engineers use its platform with a new service that brings more power and ...

3 growing applications of AI in data management

There are plenty of ways AI can augment data professionals throughout the data pipeline, from sifting through large data sets for...

Key steps in the feature engineering process

Feature engineering is key to machine learning algorithms. Read on to learn how those features are created and chosen to increase...

SearchBusinessAnalytics

Emotions analytics helps Hotels.com connect with customers

While traveling has been halted for most of us, marketing efforts in hospitality still go on, and one way to sharpen those ...

ThoughtSpot IPO probably still a year away

After hiring a CFO for the first time and making changes to the way it reports revenue, ThoughtSpot is positioning itself to go ...

Power BI platform adds data storytelling capabilities

In its ongoing attempt to extend the reach of analytics to more users, Microsoft, during its virtual user conference, unveiled a ...

SearchSAP

In a time of crisis, S/4HANA implementation strategies shift

During a pandemic, organizations may consider pausing a major project like an S/4HANA migration, but experts believe they can use...

SAP Digital Boardroom helps Parkland Health manage pandemic

Parkland Health managed a surge of cases caused by the COVID-19 pandemic by using data analytics based on SAP Analytics Cloud and...

Real-life look at SAP intelligent RPA uses, benefits, limitations

SAP intelligent RPA works with the SAP ecosystem to help automate time-consuming processes. Learn what intelligent RPA is, how ...

SearchSQLServer

SQL Server database design best practices and tips for DBAs

Good database design is a must to meet processing needs in SQL Server systems. In a webinar, consultant Koen Verbeeck offered ...

SQL Server in Azure database choices and what they offer users

SQL Server databases can be moved to the Azure cloud in several different ways. Here's what you'll get from each of the options ...

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL ...

TheServerSide.com

How IT can deal with challenges of a move online post COVID-19

What will the long-term effects be of COVID-19 on the IT industry? Early indications show that virtual conferences and ...

How COVID-19 created a demand for COBOL basics

An uptick in COBOL interest stems from its presence in entrenched, legacy government apps, such as unemployment or apps for ...

WebAssembly Hub boosts Envoy filter development

Examine WebAssembly Hub's features, why developers have turned to the portal to share Envoy filters and how it seems to be built ...

SearchDataCenter

A look at the main differences of Bourne shell vs. Bash

Shells help admins run commands from the keyboard to the OS. Though Bourne shell and Bash are similar, there are differences in ...

6 tools to know for private cloud monitoring and reporting

Cloud reporting helps admins address capacity issues and reduce outages. Effective tools should include role-based dashboards and...

Set your strategy to get the right liquid-cooled data center

As data center rack densities increase, liquid cooling's benefits are becoming more apparent. Before purchasing, IT teams must ...

SearchContentManagement

How businesses can best build a WordPress knowledge base

A WordPress knowledge base can be useful for companies that want an easy-to-use and customizable product with many plugins that ...

Knowledge bases benefit customer service, call center training

Knowledge bases provide call center agents with training documents and answers to frequently asked questions as they continue to ...

Box Shield, mobile app upgrades on the way

Among a slew of coming upgrades, Box Inc. goes after Microsoft's government business with FedRAMP High certification.

SearchHRSoftware

Oracle HCM Cloud gets on-demand pay, internal talent market

Updates to the Oracle HCM Cloud platform include on-demand pay, internal talent marketplaces, more automation and an expansion of...

How Trump, Biden see automation and AI

The impact of automation and AI on the U.S. workforce has been a longstanding issue in presidential politics. That may be true ...

Corporate LMS adoption may come down to donuts

Corporate learning management systems can be popular with employees. But adoption requires planning and maybe a little schtick, ...