Having an understanding of the inner workings (internals) of a SELECT statement provide such a deep knowledge of Oracle that it leads to better database design and better performance tuning. This talk will discuss the internals of the SELECT statement and how and where it gets the data to return for the answer to a…

Having an understanding of the inner workings (internals) of a SELECT statement provide such a deep knowledge of Oracle that it leads to better database design and better performance tuning. This talk will discuss the internals of the SELECT statement and how and where it gets the data to return for the answer to a…

DBA’s are always looking to better themselves which leads to questions on forums such as “How do I learn to be a DBA”, or “How do I go from Amateur DBA to Expert DBA”? A common answer is “read the Concepts Manual”. That’s good advice, but there is more … much more. The Oracle database…

DBA’s are always looking to better themselves which leads to questions on forums such as “How do I learn to be a DBA”, or “How do I go from Amateur DBA to Expert DBA”? A common answer is “read the Concepts Manual”. That’s good advice, but there is more … much more. The Oracle database…

The benefits of knowing your data before embarking on a BI project are endless. Sure you can buy a tool to help with this. Or you could use R, an open source tool. This session will dig into methods for using R to connect to your data source to see visual and tabular analyses of…

MySQL is the most popular database on the web and the demand for qualified Database Administrators and Developers is very high.  A popular way to learn MySQL and show mastery are the MySQL DBA and MySQL Developer certifications.  This session will cover the areas of competency required by each of the exam, how to study…

MySQL is the most popular database on the web and the demand for qualified Database Administrators and Developers is very high.  A popular way to learn MySQL and show mastery are the MySQL DBA and MySQL Developer certifications.  This session will cover the areas of competency required by each of the exam, how to study…

This talk will benefit the Beginner and Mid-Level Oracle DBA when faced with running Oracle on a Windows Server, and may also teach some old hands a trick or two.  Instead of delving into topics that would be for Server Administrators, this session will deal with issues directly related to  DBAs running Oracle on a…

This talk will benefit the Beginner and Mid-Level Oracle DBA when faced with running Oracle on a Windows Server, and may also teach some old hands a trick or two.  Instead of delving into topics that would be for Server Administrators, this session will deal with issues directly related to  DBAs running Oracle on a…

If you currently use an on-premise ERP, CRM or other applications on-premise  such as E-Business Suite, Siebel, SAP, Peoplesoft or any other enterprise or homewgrown application for your business requirements and are looking forward to move some of the functionality to the cloud, Integration is a very crucial component, central to the solution. Without integration,…