Upcoming Events

marco's picture

Oracle XML Training With Marco Gralike

Oracle XML Training With Marco Gralike
Event date: 
Tue, 2012-03-27 - Wed, 2012-03-28

With great pleasure we announce a very interesting 2-day seminar with Marco Gralike about XML titled "Oracle XML Database Training". The course will deal in depth with performance problems, design, set-up, architecture and troubleshooting.
Marco Gralike, member of OakTable and Oracle ACE Director si know as the top expert for XML in Oracle database.
The seminar will take place on March 27-28 2012 in Ljubljana, Slovenia, at Poslovna hiša Unija, Tržaška cesta 515, 1251 Brezovica pri Ljubljani.   The seminar is organized by DbProf d.o.o. in cooperation with SIOUG, Slovenian Oracle User Group.

Seminar description:
XML is nowadays in use all around us. XML is part of Microsoft Office documents, reports, service orientated architectures and in mobile devices. The urge to do more with all this XML data, becomes very important or the need to do this more efficiently. The core Oracle database functionality which deals with XML in the database, called "XMLDB", a so called "no cost option" functionality of the database, is becoming popular as a solution to deal with these huge amounts of this semi-structured data.
Delivered XML data can be consumed via XMLDB and transformed into relational data or relational data will be used as a basis for XML to service the needs of the outside world. Oracle XMLDB functionality supports all W3C standards defined while dealing with XML. The Oracle XMLDB functionality can not only be used to generated and consume XML, but also to create Native Database Web Services (out-of-the-box web services), or support for HTTP, FTP or WebDAV. The Oracle XMLDB environment has his own file/folder environment and is relied upon, also by Oracle, heavily regarding Oracle tool reporting, interfacing or database security.
Seminar Goals:
Besides the introduction of the history of XMLDB, an overview and concepts, the course will deal in depth with performance problems, design, set-up, architecture and troubleshooting. The main goal of this seminar is to get necessary understanding how this technology can be used to the maximum extent like efficiently consuming or generating XML files. Also real life customer use-cases will be demonstrated and explained, regarding their drawbacks and benefits in the solutions.
Audience
The training has been designed for everyone (architects, developers or database administrators) who are involved in using XMLDB functionality. The seminar provides a quick start for people who will have to consume, generate or manage XML or want to use database build-in XMLDB functionality.

Expected knowledge

  • Basic knowledge of the Oracle database
  • Basic understanding of SQL and PL/SQL knowledge
  • Basic understanding of XML knowledge

The training is using Oracle's freely provided and downloadable OTN Developer Days VirtualBox virtual machine training environment. The extra training material, which will be needed for this course, like supporting documents, pdf's, examples and code, will be provided at the beginning of the course.
Training Goals
Will offer a holistic overview of the Oracle XML database functionality
Will offer an in depth overview and reasoning on how to handle XML data to come to performing, working, solutions
Will offer insight in the architectures and mechanisms in Oracle's database solutions to deal with XML problems
Will offer ways to avoid and troubleshoot problems
Will demonstrate to get the best, regarding performance and functionality, out of this XML database functionality
The training material will be deliverd in electronic form.
After this training, attendees are able to make balanced decisions regarding choices of how to setup and implement the XMLDB database functionality and its architecture. It will help them in choosing the right choices among possible methods for consuming, generating or storing XML. It will demonstrate how easy it can be to open up propriety relational environments to service orientated architectures and also when one should not use this functionality.

Training Agenda:

Day one
An introdcution of XML in the database
XML DB architecture:

  • The Protocol Server
  • The XDB Repository
  • XDB Repository Events

XML DB structures:

  • API's supporting XML interfacing, URIType-functionality
  • The XMLType datatype

XML en XML Schema Design and best practices
Storage of XML in the database:

  • XMLType CLOB Storage
  • XMLType Object Relational Storage
  • XMLType Binary XML Storage
  • XML Partitioning

Indexing of XML in the database:

  • BTree Index usage in regards to XML structures
  • Function based Index usage in regards to XML structures
  • Oracle Text Index usage in regards to XML structures
  • The Unstructured XMLIndex
  • The Structured XMLIndex

Security and Folder handling
Troubleshooting and Performance
 
Day two
XML/SQL Operators
XML Packages, functions and procedures
XPath
XQuery
XSL Transformations
XMLType Views
Troubleshooting and Performance

About
Marco Gralike, working for AMIS Services BV as a principal Oracle database consultant in the Netherlands, has experience as a DBA since 1994 (Oracle 6). Marco is also eager and skillful in other fields, like operating system administration and application servers, mainly to find working, performing solutions. Marco has been specializing in Oracle XMLDB since 2003, focusing on his old love, database administration and performance. He has been an Oracle XMLDB enthusiast ever since.
He is also a dedicated contributor of the Oracle User Group community, helping people with their steep XMLDB learning curve. To this purpose, Marco also devoted his personal blog site to XMLDB and other Oracle issues. Marco has presented among others in Holland, UKOUG, Oracle OpenWorld, Hotsos, MOW, and ODTUG Kaleidoscope. He has been awarded the Oracle ACE and ACE Director title for his work in the Oracle XMLDB area and has been a member of the OakTable Network since 2009. Currently he is also an Oracle Advisory Board member for XMLDB functionality in the next Oracle release.
Registration for the seminar:

Seminar Location:
Poslovna hiša Unija, Tržaška c. 515, 1351 Brezovica pri Ljubljani

cary.millsap's picture

Mastering Oracle Trace Data, March 9, Irving Texas

Mastering Oracle Trace Data by Cary Millsap, Method R Corporation
Event date: 
Fri, 2012-03-09

Mastering Oracle Trace Data
A one-day course taught by Cary Millsap
On March 9, Cary Millsap will teach his popular one-day Mastering Oracle Trace Data course in Irving, Texas. The date and location are ideal for people attending the 10th anniversary Hotsos Symposium, which will be held March 5–8, also in Irving.
Course registration includes a day of instruction with Cary, a new book, a T-shirt, and licenses for software that will help you get more out of your trace data the moment you get home from class. See I Can Help You Trace It, the story behind the course. You can register here.
For other Method R events, see the Method R Corporation calendar.

garygoodman's picture

Hotsos Symposium 2012

10th Annual Hotsos Symposium 2012
Event date: 
Sun, 2012-03-04 - Thu, 2012-03-08

Join the world's top Oracle performance analysts including Tom Kyte, Jonathan Lewis, Tanel Põder, and Kerry Osborne at the tenth annual Hotsos Symposium, which is the conference dedicated to issues of Oracle system performance. The Symposium will be held March 4 — 8, 2012 at the Omni Mandalay Hotel in Irving, TX.

tim.evdbt@gmail.com's picture

RMOUG Training Days 2012

RMOUG Training Days 2012
Event date: 
Tue, 2012-02-14 - Thu, 2012-02-16

One of the largest Oracle user group conferences in the world, the "Training Days 2012" conference presented by the Rocky Mountain Oracle Users Group (http://www.RMOUG.org) is two days on Wednesday and Thursday (15-16 Feb), consisting of more than 140 presentations by more than 100 of the top speakers in the world.  Registration for this conference, from as low as US$265 - US$340 for early registration, is an incredible educational value.  Click here to register for this event.
 
Sixteen (16) Oak Table members are presenting at this event, along with dozens of Oracle ACEs and ACE Directors.  Oak Table member and ACE Director Cary Millsap will be providing the keynote address.  In addition to twenty high-end vendors exhibiting their products and services, the "RAC Attack" hands-on labs will be running in the exhibition area throughout the conference.
 
On the Tuesday preceding the conference (14-Feb), we also have five extended four-hour University sessions by some of the expert presenters at the conference.  Click here to register for these complimentary sessions, which runs from US$112.50 when registering for the 2-day Training Days conference as well, or US$125.00 when just registering for the University sessions alone.
 
Additionally, on the Tuesday preceding the conference (14-Feb), Oracle TechNet (OTN) is presenting their FREE full-day "Developer's Day" featuring top developers from Oracle Corporation.  Click here to register for this complimentary event.

Jonathan Lewis's picture

UKOUG Annual Conference 2011, 5th - 7th Dec

Event date: 
Mon, 2011-12-05 - Wed, 2011-12-07
kurtvm's picture

UKOUG Oaktable Sunday 2011

UKOUG Oaktable Sunday 2011
Event date: 
Sun, 2011-12-04

 Why not join us for OakTable day on Sunday 4th December?
 
In a smaller setting, you can attend a dedicated set of sessions directly from a selection of OakTable members away from any potential session contention of the main conference. The sessions will be presented in just two streams, and will also be repeated on the Wednesday of the main conference, allowing you two chances not to miss some of the top sessions of the conference. Participants of OakTable Sunday will also receive the exclusive chance to win a selection of signed books by various OakTable members, and the opportunity to join the OakTable for an informal panel session and a beer. Attendees will receive a commemorative shirt to mark the event.
Sponsored by Scale Abilities Ltd and Miracle A/S.

To view the presentations on offer visit the agenda grids.
 
To register click here.

Jonathan Lewis's picture

UKOUG Special event: Security.

UKOUG Security event
Event date: 
Tue, 2011-09-13

A special UKOUG event on security held at the birthplace of computing, and featuring a presentation from Pete Finnigan (Oak Table).
A tour of this historic site will be available for attendees, but make sure you register early.
 
 

Jonathan Lewis's picture

NoCOUG Summer Conference 2011

NoCOUG
Event date: 
Thu, 2011-08-18

Now in its 25th year and 100th Conference
Three streams of technical information and a keynote by Jonathan Lewis
 

khailey's picture

Free Webinar with Cary Millsap, Kerry Osborne and Karen Morton

http://dboptimizer.com/2011/07/27/free-webinar-with-cary-millsap-kerry-osborne-a
Event date: 
Thu, 2011-07-28

Thursday, July 28 11:00am PDT  :  Register Here
Oracle performance tuning and optimization is not always easy. Now’s your chance to hear from people who have been there and ask them the questions that are keeping you up at night.
Three senior DBAs and performance tuning specialists and members of the elite OakTable network will discuss best performance optimization and tuning practices for the Oracle® Database.
Participate in this online roundtable to gain specific insight and learn about advanced performance tips for the Oracle® Database. During this event you will:

  • Learn how to improve Oracle performance and availability while improving productivity
  • Understand about best practices and tips from very senior Oracle DBAs from the OakTable network
  • Interact with experts by submitting questions, prior and during the webinar, and sharing your more painful performance optimization challenges with our panel

About our panelists:
Karen Morton is a Senior DBA Performance and Tuning Specialist for Fidelity Information Services. Having used Oracle since the early 90’s, she began consulting and teaching others how to use Oracle over a decade ago. Karen is a frequent speaker at conferences and user groups, an Oracle ACE, and a member of the OakTable network. Karen has co-authored three books from Apress: Beginning Oracle SQL, Pro Oracle SQL and Expert Oracle Practices: Oracle Database Administration from the Oak Table. She blogs at karenmorton.blogspot.com.
Cary Millsap has been part of the Oracle community since 1989. He is the founder and president of Method R Corporation. He is widely known in the Oracle community as a speaker, educator, consultant, and writer. He wrote Optimizing Oracle Performance  with Jeff Holt, and he is a co-author of Oracle Insights: Tales of the Oak Table . Cary is also an architect of the Method R software tools that help professionals around the world manage Oracle performance. He blogs at carymillsap.blogspot.com and tweets at twitter.com/CaryMillsap.
Kerry Osborne began working with Oracle in 1982. He has worked both as a developer and a DBA. For the past several years, he has been focused on understanding Oracle internals and solving performance problems. He is an OakTable member and is the author of an upcoming Apress book Expert Oracle Exadata. Mr. Osborne is also a co-founder of Enkitec, an Oracle-focused consulting company headquartered in Dallas, Texas. He blogs at kerryosborne.oracle-guy.com.OakTable link: http://www.oaktable.net/users/kerry-osborne.
Register today. And don’t forget to fill in your questions on the webinar registration form.

kurtvm's picture

ODTUG Kscope11

ODTUG Kscope11
Event date: 
Sun, 2011-06-26 - Thu, 2011-06-30

 ODTUG Kscope11 is the conference for you if you are looking for training and answers in the following areas:
Take a sneak peak at Kscope 11 content by topic area by clicking on your area of interest below:

BI and Oracle EPM

Application Express

Database Development

Oracle Fusion Middleware

MySQL

 

Why? Because Kscope offers the best content and the most sessions on these topics than any other conference. 

To prevent automated spam submissions leave this field empty.