SQL for Data Warehousing and Analytics

Here it is….. THE ultimate, comprehensive review for big data warehousing for #OOW18. This review is for everyone who either missed this year’s conference or just wants to relive the amazing experience all over again ( but focusing on just the best bits obviously! ). So here you go, my complete view nicely packaged and available free of charge in a number of different formats…           Following on from this year’s OpenWorld I have now put together the ultimate, comprehensive review for big data warehousing content from #OOW18. This free review contains the following information: Key video highlights from the main executive keynotes Overview of the announcements for Autonomous Database - contains the links you need to learn even more about how the Autonomous Database can simplify and speed up your big data warehousing projects! Full list of Oracle Product Management and Development presenters, links to all their social media sites are included alon...

  Day three is a wrap so now is the perfect time to start planning your Day 4 session at   OpenWorld 2018. Here’s your absolutely  Must-See  agenda for Thursday at OpenWorld 2018... My favorite session of the whole conference is today - Using Analytic Views for Self-Service Business Intelligence,  which is at 9:00am in Room 3005, Moscone West. Multi-Dimensional models inside the database are very powerful and totally cool. AVs uniquely deliver sophisticated analytics from very simple SQL. If you only get to one session today then make it this one! Of course, today is your final chance to get some much-needed real hands-on time with Autonomous Data Warehouse in the ADW Hands-on Lab at 1:30pm - 2:30 at the Marriott Marquis (Yerba Buena Level) - Salon 9B. The product management team will help you sign up for a free cloud account and then get you working on our completely free workshop. Don't miss it, just bring your own laptop!   THURSDAY's MUST-SEE GUIDE     Don't...

  Here’s your absolutely Must-See agenda for Wednesday at OpenWorld 2018... Day one is a wrap so now is the perfect time to start planning your Day 3 session at   OpenWorld 2018. The list is packed full of really excellent speakers from Oracle product management talking about Autonomous Database and the Cloud. These sessions are what Oracle OpenWorld is all about: the chance to learn from the real technical experts. Highlight of today is two additional chances to get some real hands-on time with Autonomous Data Warehouse in the ADW Hands-on Lab at 12:45pm - 1:45pm and then again at 3:45pm - 4:45pm, both at the Marriott Marquis (Yerba Buena Level) - Salon 9B. We will help you sign up for a free cloud account and then get you working on our completely free workshop. Don't miss it, just bring your own laptop!   WEDNESDAY'S MUST-SEE GUIDE     Don't worry if you are not able to join us in San Francisco for this year's conference because I will be providing a com...

  Here’s your absolutely Must-See agenda for Tuesday at OpenWorld 2018... Day one is a wrap so now is the perfect time to start planning your Day 2 session at   OpenWorld 2018. The list is packed full of really excellent speakers from Oracle product management talking about Autonomous Database and the Cloud. These sessions are what Oracle OpenWorld is all about: the chance to learn from the real technical experts. Highlight of today is the chance to get some real hands-on time with Autonomous Data Warehouse in the ADW Hands-on Lab at 3:45 PM - 4:45 PM at the Marriott Marquis (Yerba Buena Level) - Salon 9B. We will help you sign up for a free cloud account and then get you working on our completely free workshop. Don't miss it, just bring your own laptop!   TUESDAY'S MUST-SEE GUIDE     Don't worry if you are not able to join us in San Francisco for this year's conference because I will be providing a comprehensive review after the conference closes on Thursd...

Here’s your absolutely Must-See agenda for Monday at OpenWorld 2018... It all starts today -   OpenWorld 2018.  Each day I will provide you with a list of must-see sessions and hands-on labs. This is going to be one of the biggest and most exciting OpenWorlds ever! Today is Day 1 so here here is my definitive list of Must-See sessions for the opening day. The list is packed full of really excellent speakers from Oracle product management talking about Autonomous Database and the Cloud. These sessions are what Oracle OpenWorld is all about: the chance to learn from the real technical experts. MONDAY'S MUST-SEE GUIDE     Don't worry if you are not able to join us in San Francisco for this year's conference because I will be providing a comprehensive review after the conference closes on Thursday. The review will include links to download the presentations for each of my Must-See sessions and links to any hands-on lab content as well. Have a great conference. If you ...

It’s  not long until the doors open at the Moscone Center in San Francisco for the biggest and most exciting tech conference in the calendar. Looking at the online content catalog it’s hard to know where to start because there are so many sessions and just not enough time! Which is here my Must-See Guide comes to the rescue. It lists all the most important data warehouse, big data, analytics, machine learning sessions and labs at #oow18 is now available as a comprehensive Day-by-Day version: My Day-by-Day guide for OpenWorld 2018 is available in both old-fashioned PDF format as a free download from here  and the more useful Apple Book format as a free download   from here   ( open this link in a browser and then click on the blue “View in iBooks” button below the cover-picture ). As usual, all feedback is welcome and if I have missed a session or a hands-on lab that you think should be included in this guide then send me a quick email with the details: keith.lak...

There are so many sessions at this year’s OpenWorld it’s hard to know where to start when trying to pick which sessions to attend! To help you get your personal calendar organized and totally focused on THE most important sessions here is my pick of the very best sessions and labs that you definitely won’t want to miss! Simply cut & paste the links below into your calendar app and then sit back and relax because all you need to do next is turn up at Moscone and enjoy the best tech conference ever :-) ...so if you have a calendar app on your computer then just use the iCal links to subscribe to my calendars. Your calendar app should allow you to color-code each calendar to make life easier and more colourful!   For data warehousing and cloud-focused sessions+labs use these links: iCal format: https://calendar.google.com/calendar/ical/31pd442io213d7n1o44rstlqno%40group.calendar.google.com/private-5fc5e75a3b08e9ab2f2f0a3a16b839ef/basic.ics Web page:  https:...

That’s right: Autonomous Data Warehouse Cloud is LIVE  and available in the Oracle Cloud. ADWC Launch Event at Oracle Conference Center We had a major launch event on Thursday last week at the Oracle Conference center in Redwood Shores which got a huge amount of press coverage. Larry Ellison delivered the main keynote covering how our next-generation cloud service is built on the self-driving Oracle Autonomous Database technology which leverages machine learning to deliver unprecedented performance, reliability and ease of deployment for data warehouses. As an autonomous cloud service, it eliminates error-prone manual management tasks and, most importantly for a lot readers of this blog, frees up DBA resources, which can now be applied to implementing more strategic business projects. The key highlights of our Oracle Autonomous Data Warehouse Cloud include: Ease of Use: Unlike traditional cloud services with complex, manual configurations that require a database expert to...

If you missed all the major announcements from OpenWorld 2017 about Oracle Autonomous Data Warehouse Cloud  then take some time to review this blog post Review of Big Data Warehousing at OpenWorld 2017 - Now Available . Take a look a Chapter 2 - YOUR ORACLE DATA WAREHOUSE IN THE AUTONOMOUS CLOUD. Once you have fully digested the powerpoint presentations and videos included in Chapter 2 you will then be ready to watch this exciting new video: Below is an excerpt of Thomas Kurian’s Keynote session at Oracle Cloud World in Feb 2018. In this video, George Lumpkin, VP of Product Management, shows how easy it is to create an new data warehouse inside the Oracle Autonomous Data Warehouse Cloud, how fast and elastic it is and how quick and easy it is to integrate with other parts of Oracle's Cloud portfolio - in this case Oracle Analytics Cloud. This demo will take you from zero-to-dashboard in around 10 minutes!    For the full-length video of Thomas Kurian's keynote at O...

Those of you with long memories might just be able to recall a whole series of posts I did on SQL pattern matching which were taken from a deep dive presentation that I prepared for the BIWA User Group Conference . The title of each blog post started with SQL Pattern Matching Deep Dive... and covered a set of 6 posts: Part 1 - Overview Part 2 - Using MATCH_NUMBER() and CLASSIFIER() Part 3 - Greedy vs. reluctant quantifiers Part 4 - Empty matches and unmatched rows? Part 5 - SKIP TO where exactly? Part 6 - State machines There are a lot of related posts derived from that core set of 6 posts along with other presentations and code samples. One of the challenges, even when searching via Google, was tracking down all the relevant content. Therefore, I have spent the last 6-9 months converting all my deep dive content into a book and I have added a lot of new content based discussions I have had at user conferences, questions posted on the developer SQL forum, discussions with my...

Those of you with long memories might just be able to recall a whole series of posts I did on SQL pattern matching which were taken from a deep dive presentation that I prepared for the BIWA User Group Conference . The title of each blog post started with SQL Pattern Matching Deep Dive... and covered a set of 6 posts: Part 1 - Overview Part 2 - Using MATCH_NUMBER() and CLASSIFIER() Part 3 - Greedy vs. reluctant quantifiers   Part 4 - Empty matches and unmatched rows? Part 5 - SKIP TO where exactly? Part 6 - State machines There are a lot of related posts derived from that core set of 6 posts along with other presentations and code samples. One of the challenges, even when searching via Google, was tracking down all the relevant content. Therefore, I have spent the last 6-9 months converting all my deep dive content into a book - an Apple iBook. I have added a lot of new content based discussions I have had at user conferences, questions posted on the developer ...

Did you miss OpenWorld 2017? Then my latest book is definitely something you will want to download! If you went to OpenWorld this book is also for you because it covers all the most important big data warehousing messages and sessions during the five days of OpenWorld. Following on from OpenWorld 2017 I have put together a comprehensive review of all the big data warehousing content from OpenWorld 2017. This includes all the key sessions and announcements from this year's Oracle OpenWorld conference. This review contains the following information: Welcome - an overview of the contents. Let’s Go Autonomous - containing all you need to know about Oracle’s new, fully-managed Autonomous Data Warehouse Cloud . This was the biggest announcement at OpenWorld so this chapter contains videos, presentations and podcasts to get you up to speed on this completely new data warehouse cloud service. Keynotes - Relive OpenWorld 2017 by watching the most important highlights f...

Day 4 is here which makes today #Autonomous Wednesday. Included my definitive list of Must-See sessions for today are two of THE most important sessions at this years conference. You will not want to miss these two sessions: The rest of list is, of course, packed full of sessions and labs covering our Big Data Warehouse technologies and features. These sessions are what Oracle OpenWorld is all about: the chance to learn about the latest technology from the real technical experts. WEDNESDAY'S MUST-SEE GUIDE Don't worry if you are not able to join us in San Francisco for this year's conference because I will be providing a comprehensive review after the conference closes on Thursday. The review will include links to download the presentations for each of my Must-See sessions and links to any hands-on lab content as well. Have a great conference. If you are here in San Francisco then enjoy the conference - it's going to be an awesome conference this ...

Day 3, Tuesday, is here and this is my definitive list of Must-See sessions for today. Today we are focused on the new features in Oracle Database 18c - multitenant, in-memory, Oracle Text, machine learning, Big Data SQL etc etc. These sessions are what Oracle OpenWorld is all about: the chance to learn about the latest technology from the real technical experts. TUESDAY'S MUST-SEE GUIDE Don't worry if you are not able to join us in San Francisco for this year's conference because I will be providing a comprehensive review after the conference closes on Thursday. The review will include links to download the presentations for each of my Must-See sessions and links to any hands-on lab content as well. Have a great conference. If you are here in San Francisco then enjoy the conference - it's going to be an awesome conference this year. Don't forget to make use of our Big DW #oow17 smartphone app which you can access by pointing your phone at thi...

Day 2, Monday, is here and this is my definitive list of Must-See sessions for today. The list is packed full of sessions and labs that follow on from yesterday's (Sunday) big announcements around Oracle Autonomous Database and Oracle Autonomous Data Warehouse Cloud. These sessions are what Oracle OpenWorld is all about: the chance to learn about the latest technology from the real technical experts. MONDAY's MUST-SEE GUIDE Don't worry if you are not able to join us in San Francisco for this year's conference because I will be providing a comprehensive review after the conference closes on Thursday. The review will include links to download the presentations for each of my Must-See sessions and links to any hands-on lab content as well. Have a great conference. If you are here in San Francisco then enjoy the conference - it's going to be an awesome conference this year. Don't forget to make use of our Big DW #oow17 smartphone app which you can...

It all starts today -   OpenWorld 2017. Each day I will provide you with a list of must-see sessions and hands-on labs. This is going to be one of the most exciting OpenWorlds ever! Today is Day 1 so here here is my definitive list of Must-See sessions for the opening day. The list is packed full of really excellent speakers such as Franck Pachot ,  Ami Aharonovich ,  Galo Balda and  Rich Niemiec . These sessions are what Oracle OpenWorld is all about: the chance to learn from the real technical experts. Of course you need to end your first day in Moscone North Hall D for Larry Ellison's welcome keynote - it's going to be a  great one! SUNDAY'S MUST-SEE GUIDE Don't worry if you are not able to join us in San Francisco for this year's conference because I will be providing a comprehensive review after the conference closes on Thursday. The review will include links to download the presentations for each of my Must-See sessions and links to any ha...

It’s only 4 days and counting until OpenWorld 2017 starts. If you are coming to this year’s conference then you will definitely want to use our completely free #oow17 online BDW app for smartphones and tablets which is now live :  https://keithlaker.github.io/Storyboard.html#LandingPad . The app includes a day-by-day calendar of all the most important sessions covered in the comprehensive Big Data Warehousing Must-See Guide, see here:  https://oracle-big-data.blogspot.co.uk/2017/08/updated-big-data-warehousing-must-see.html . The day-by-day coverage breaks sessions down into 5 categories: Data Warehousing and Cloud Analytics and Machine Learning Unstructured and development Big Data Hands-on labs each session is color coded to the above topics making it easier to focus on the areas that are most important to you. Please send my any feedback. Hope the app is useful and enjoy OpenWorld 2017: Your Data Warehouse Transformation Starts Here. Landing page wh...

** NEW ** Chapter 5 *** UPDATED *** Must-See Guide now available as PDF and via Apple iBooks Store This updated version now contains details of all the most important hands-on labs AND a day-by-day calendar . This means that our comprehensive guide now covers absolutely everything you need to know about this year’s Oracle OpenWorld conference. Now, when you arrive at Moscone Conference Center you are ready to get the absolute most out of this amazing conference. The updated, and still completely  free,  big data warehousing Must-See guide for OpenWorld 2017 is now available for download from the Apple iBooks Store -  click here ,  and in PDF format -  click here . Just so you know…this guide contains the following information: Page 8 - On-Demand Videos Page 11 - Justify Your trip Page 18 - Key Presenters Page 39 - Must See Sessions Page 83 - Must See Day-by-Day Page 150 - Useful Maps Chapter 1  - Introduction ...