1ZO-051: Oracle Database 11g: Using ANSI Standard Joins

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.

Irrlicht: Creating a Basic Template Application

Irrlicht is an open source technology that is used to create 2D and 3D applications.

In this article by Aung Sithu Kyaw and Johannes Stein, authors of Irrlicht 1.7 Realtime 3D Engine, we will:

• Create a new empty project
• Explain the use of an Irrlicht device
• Use the "game loop"

So let's get on with it...

Top 10 tips for organizing an Agile IT Security Team

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.

Animating Properties and Tweening Pages in Android 3-0

In this article by Alex Shaw, author of Android 3-0 Animations Beginners Guide, we will build on the tweening techniques we've already learned, and also apply some new techniques that were introduced in Android 3.0.

In this article, we shall:

• Use a ViewFlipper for animating a book-like application
• Use Java to define a new tween animation and apply it to a view
• Use an ObjectAnimator to apply an animation to a view, a bit like a tween
• Use a ValueAnimator to generate values, which we will use for a more complex animation
• Compare the Animator classes to the tween classes.

Microsoft SharePoint: Recipes for Automating Business Processes

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:

1. Creating an InfoPath form for a SharePoint list
2. Using the Collect Feedback workflow to receive feedback on a Microsoft Word 2010 document

Oracle BI Publisher 11g: Learning the new XPT format

Oracle BI Publisher is Oracle's reporting XML-based technology, which generates highly formatted data output using multiple data sources. BIP also offers different types of Layout Templates for designing a report.

In this article by Daniela Bozdoc, author of Oracle BI Publisher 11g: A Practical Guide to Enterprise Reporting, we will look at the XPT format, which is a new template option provided by BIP. It is designed in a totally BIP-integrated layout design interface. We will also see how to use this interface to design a complete report.

Moodle Plugins

Moodle has evolved from an academic project to the world's most popular virtual learning environment. During this evolution, its complexity has risen dramatically and so have the skills that are required to administer the system. Moodle 2 Administration is a complete, practical guide to administering Moodle sites.

In this article by Alex Büchner, author of Moodle 2 Administration, we cover:

• Module plugins: This covers core functionality available in a course, the front page, My Moodle page, and the user profile pages. They include Activity modules, Blocks, and Filters.
• Repositories: Repositories allow incorporating data into Moodle, either from internal sources or from external sites.
• Portfolios: These are the opposite of repositories. Portfolios allow exporting content from Moodle to other applications or data storage.
• Miscellaneous plugins: These include Text editors, Licences, Question types, Question behaviours, and Plagiarism prevention.