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