Beginning with database version 10g, Oracle has provided a new syntax for retrieving data from multiple tables. While Oracle's syntax has not yet gained widespread acceptance, we will see that it offers some advantages, not least of which is its simpler syntax. Many consider Oracle's join syntax to be more intuitive and readable than the ANSI standard.
In this article by Steve Ries, author of OCA Oracle Database 11g: SQL Fundamentals I: A Real World Certification Guide (1ZO-051) we shall join tables using the new Oracle join syntax.Read 1ZO-051: Understanding Oracle JOIN Syntax in full
The ability to retrieve data from a table is an absolutely essential element of learning SQL. However, real-world requirements often demand the ability to select data from multiple tables concurrently and present it in a meaningful way. Herein lies the ability to join tables.
In this article by Steve Ries, author of OCA Oracle Database 11g: SQL Fundamentals I: A Real World Certification Guide (1ZO-051), we shall join tables using ANSI-compliant join syntax.Read 1ZO-051: Oracle Database 11g: Using ANSI Standard Joins in full
Packt author Tom Laszewski speaks about his latest Oracle book: Oracle Information Integration, Migration, and ConsolidationRead Oracle Information Integration, Migration, and Consolidation in full
Why would a company or organization choose to use Sametime? They might choose Sametime because it closely integrates with their existing collaboration environment—IBM Lotus Notes and Domino, Lotus Quickr, or IBM Connections. They may also choose a real-time collaboration system such as Sametime to save money. Online meetings and instant messaging helps save money by eliminating the need for travel costs and long distance phone expenditures, especially if a company integrates Sametime with their existing Voice over Internet Protocol (VoIP) system.
In this article written by Gabriella Davis, Marie L. Scott, and Thomas Duff, authors of IBM Sametime 8.5.2 Administration Guide, we will cover:
- What's new in Sametime 8.5.2
- What has changed with regards to Sametime server architecture
- The different types of Sametime clients available in Sametime 8.5.2
- Why you should install Sametime 8.5.2 or upgrade from prior versions
Jeff Laskowski , author of the new book and eBook: Agile IT Security Implementation Methodology, gives his top 10 tips on organizing an Agile IT Security Team.
Read Top 10 tips for organizing an Agile IT Security Team in full
In this article by Paul Goodey, author of Salesforce CRM: The Definitive Admin Handbook, we will describe in detail the Salesforce CRM record storage features and user interface that can be customized such as objects, fields, and page layouts. In addition, we will see an overview of the relationship that exists between the profile and these customizable features that the profile controls.
This article looks at the methods for configuring and tailoring the application to suit the way your company information can be best represented within the Salesforce CRM application.Read Configuration in Salesforce CRM in full
SharePoint 2010 uses InfoPath 2010 to create rich, powerful electronic forms. InfoPath forms can replace the default forms used for SharePoint lists or act as custom forms that provide the user interface and business rules required to run a custom business process.
When automating business processes, we automatically think of workflow. SharePoint 2010 supports many different workflow and task-management scenarios. There are a number of out of the box workflows that can be used to perform tasks such as to requesting feedback or approval for a document. Where these workflows don't suffice, they can be copied, modified, and extended, or completely new custom workflows can be constructed. These custom workflows can perform a range of custom actions, allocate tasks to users, or automate an end-to-end business process as required.
In this article written by Dr Adrian Colquhoun, author of Microsoft SharePoint 2010 Power User Cookbook, we will cover:
- Creating an InfoPath form for a SharePoint list
- Using the Collect Feedback workflow to receive feedback on a Microsoft Word 2010 document
Microsoft SharePoint 2010 is the best-in-class platform for content management and collaboration. With Visual Studio, developers have an end-to-end business solutions development IDE. To leverage this powerful combination of tools it is necessary to understand the different building blocks of SharePoint.
In this article by Balaji Kithiganahalli, author of Microsoft SharePoint 2010 Development with Visual Studio 2010 Expert Cookbook, we will cover:
- Creating a list using a Client Object Model
- Handling exceptions
- Calling Object Model asynchronously
SAP Master Data Management (SAP MDM) enables information integrity across the business network, in a heterogeneous IT landscape. SAP MDM enables the sharing of harmonized master data, formerly trapped in multiple systems, and ensures cross system data consistency.
In this article by Uday Rao, author of SAP NetWeaver MDM 7-1 Administrators Guide, we cover:
- Mount and unmount an MDM server
- Start and stop an MDM server
WebSphere Application Server, often referred to simply as WAS, is a JEE-compliant application server platform. JEE stands for Java Enterprise Edition and was previously referred to as J2EE. JEE application servers provide functionality to deploy fault-tolerant, distributed, and multi-tier Java software.
In this article by Steve Robinson, author of IBM WebSphere Application Server 8.0 Administration Guide, we will be covering a few of the command-line tools shipped with WAS to help you with problem diagnosis when WebSphere or applications are not running as they should. We will also introduce the IBM Support Assistant, a very powerful WebSphere Application Server (WAS) support tool, and walk through how to analyze a WAS log file using one of the many ISA add-ons.
Specifically we will cover the following topics:
- Dumping namespaces
- EAR expander
- IBM Support Assistant (ISA)