SQL for Data Warehousing and Analytics

I am currently working on a series of podcasts covering the broad categories of our SQL analytical functions and features and while I was doing some research I came across of series of four articles in the Oracle Magazine. This series of article is written by Melanie Caffrey who is a senior development manager at Oracle. She is a coauthor of Expert PL/SQL Practices for Oracle Developers and DBAs (Apress, 2011) and Expert Oracle Practices: Oracle Database Administration from the Oak Table (Apress, 2010). The four articles are under the banner "Technology: SQL 101" and parts 9, 10, 11 and 12 cover SQL analytics. Here are the links to the four articles: Jan 2013 Having Sums, Averages, and Other Grouped Data March 2013 A Window into the World of Analytic Functions May 2013 Leading Ranks and Lagging Percentages: Analytic Functions, Continued July 2013 Pivotal Access to Your Data: Analytic Functions, Concluded   The articles cover topics such as GROUP BY, SUM, AVG, H...

 Big Data has the power to change the way we work, live, and think. The datafication of everything will create unprecedented demand for data scientists, software developers and engineers who can derive value from unstructured data to transform the world. The Oracle Academy Big Data Resource Guide is a collection of articles, videos, and other resources organized to help you gain a deeper understanding of the exciting field of Big Data. To start your journey visit the Oracle Academy website here:  https://academy.oracle.com/oa-web-big-data.html . This landing pad will guide through the whole area of big data using the following structure: What is “Big Data” Engineered Systems Integration Database and Data Analytics Advanced Information Supplemental Information This is great resource packed with must-see videos and must-read whitepapers and blog posts by industry leaders.  Enjoy Technorati Tags: Big Data , Data Warehousing , Oracle , Training

For data warehousing projects Oracle Partitioning really is a must-have feature because it delivers so many important benefits such as: Dramatically improves query performance and speeds up database maintenance operations Lowers costs by enabling a tiered storage approach that allows data to be stored on the most cost-effective storage for better resource utilisation Combined with Oracle Advanced Compression, it provides an automated approach to information lifecycle management using a simple, efficient, yet powerful way to manage data growth and reduce complexity and costs To help you get the most from partitioning we have released a new tutorial that covers the 12c new features. Topics include how to: Use Interval Reference Partitioning Perform Cascading TRUNCATE and EXCHANGE Operations Move Partitions Online Maintain Multiple Partitions Maintain Global Indexes Asynchronously Use Partial Indexes For more information about this tutorial follow this link to the O...

If you missed my sessions at OpenWorld then don't worry - all the content we used for pattern matching (presentation and hands-on lab) is now available for download. My presentation " SQL: The Best Development Language for Big Data ?" is available for download from the OOW Content Catalog, see here: https://oracleus.activeevents.com/2013/connect/sessionDetail.ww?SESSION_ID=9101 For the hands-on lab (" Pattern Matching at the Speed of Thought with Oracle Database 12c ") we used the Oracle-By-Example content. The OOW hands-on lab uses Oracle Database 12c Release 1 (12.1) and uses the MATCH_RECOGNIZE clause to perform some basic pattern matching examples in SQL. This lab is broken down into four main steps: Logically partition and order the data that is used in the MATCH_RECOGNIZE clause with its PARTITION BY and ORDER BY clauses. Define patterns of rows to seek using the PATTERN clause of the MATCH_RECOGNIZE clause. These patterns use regular expression...

You've visited our new web page on OTN , you've downloaded the pattern matching  iBook , now register for the webcast! If you are interested in learning about our exciting new 12c SQL pattern matching feature then mark your diaries. On Wednesday, October 30th at 8:00 am (US/Pacific time zone)  Supriya Ananth , who is one of our top curriculum developers at Oracle, will be hosting an OLL webcast on our new SQL pattern matching feature. The ability to recognize patterns in a sequence of rows has been a capability that was widely desired, but not possible with SQL until now. Row pattern matching in native SQL improves application and development productivity and query efficiency for row-sequence analysis. With Oracle Database 12c you can use the new MATCH_RECOGNIZE clause to perform pattern matching in SQL to do the following: Logically partition and order the data using the PARTITION BY and ORDER BY clauses Use regular expressions syntax to define patterns of ...

This year's OpenWorld had major focus on data warehousing and big data. To help you find and download the most important presentations from the conference I have put together a new guide -   OpenWorld 2013 in a box. This new guide is a follow-up to the Must-See guides that were published ahead of the conference. All the sessions listed in those conference guides are included in this new  OpenWorld 2013 in a box guide .  This new booklet is divided into the following sections Overview - links to main keynotes Database 12c - George Lumpkin, VP of Product Management talks about the exciting new features in Oracle Database 12c Must-Download presentations - presentations delivered by the product management and development teams along with key customer presentations. Links - everything you need to keep up to date on Oracle’s strategy and products for data warehousing and big data. The list of must-download presentations is broken down into the following categories: General -...

Interest in big data is growing rapidly and big data was a very hot topic at this year's OpenWorld conference. In response to this Oracle Education has released a new 3-day training course for big data to help customers and partners get hands-on time to develop the skills to acquire, organize, analyse big data so they can make key decisions based on these new data streams . The course lasts 3 days and is offered as a classroom session and/or using or virtual training environment. In this course you will learn to: Define Big Data. Understand Oracle's Integrated Big Data Solution. Describe the Oracle Big Data Components. Define Cloudera's distribution of Hadoop and its components. Acquire raw data using Oracle NoSQL Database and HDFS. Organize the collected data using Hive and Oracle Big Data Connectors. Analyze big data using the Oracle Analytics tool. Derive business decisions using Oracle BI tools. Study the case-scenarios where Oracle Big Data is applied succes...