Free Training in Oracle 10g / 11g, Application Express (ApEx), SQL Tuning, PL/SQL, SQL Trace |
New! Convert webinar times
|
| Webinar Topic | Description | Date | Time (ET) | Register |
|---|---|---|---|---|
|
JavaScript in APEX - The Lost Lesson for Database Developers |
Oracle Application Express developers often have strong backgrounds in SQL and PL/SQL, but JavaScript is another story. However, JavaScript is a very important part of any well-built Web 2.0 application. In this session, explore JavaScript through a series of analogies, 9 in total, that will relate important concepts in the language back to what you already know in the database world. Want to learn more APEX? Everything APEX!
Language: English |
August 20, 2010 |
1PM–2PM |
|
|
Oracle Application Express "Plug-Ins" |
If you use Oracle Application Express then you have probably heard of "plug-ins" by now. But you may still have some unanswered questions, such as:
These questions and more will be answered during this webinar. This will be a high level introduction to plug-ins during which we will demonstrate how plug-ins can save your organization time and money by easing development efforts. Attendees will receive a copy of the next SkillBuilders plug-in – one week before its general release to the public. Want to learn more APEX? Everything APEX!
Language: English |
Recorded |
On Demand! |
View recorded training in Windows Media format |
|
Rapid Development with the Grails Platform |
Grails is a dynamic-language based, complete-stack framework that brings simplicity and elegance to web development. It uses the Groovy programming language to work with the existing, mature open-source projects Spring, Hibernate, and SiteMesh. Through its plug-in system, it incorporates many other projects as well, ranging from Quartz scheduling to GWT user interfaces to Spring (Acegi) Security, with more added all the time. This talk will demonstrate some of the main features of web site development with Grails, including:
Want to learn more Groovy? Instructor-Led, online class: Getting Started with Groovy and Grails!
Language: English |
Recorded |
On Demand! |
View recorded training in Windows Media format |
|
JavaScript in APEX – A Lesson for the PL/SQL Developer |
Oracle Application Express developers often have strong backgrounds in SQL and PL/SQL, but JavaScript is another story. However, JavaScript is a very important part of any well-built Web 2.0 application. In this session, explore JavaScript through a series of analogies, 9 in total, that will relate important concepts in the language back to what you already know in the database world. Recorded at ODTUG Kaleidoscope 2010 Want to learn more APEX? Everything APEX!
Language: English |
Recorded |
On Demand! |
View recorded training in Windows Media format |
|
Oracle Application Express Version 4.0 is a Game Changer |
APEX 4.0 is a game changer – and it's closer than you may think! Some of the highlights of the release include:
Want to learn more APEX? Everything APEX!
Language: English |
Recorded |
On Demand! |
View recorded training in Windows Media format |
|
Learn How To Use Oracle Analytic Functions |
SQL is a language that allows you to perform queries to answer a wide range of questions about your data. While standard SQL is quite powerful, there are many questions that it cannot answer at all or that it can only answer with complex and inefficient SQL workarounds. Questions about running totals, percent of total, and ranking within a group fall into this area. Also, more complex issues such as Top-N within a group and aggregates over a range also fall in this arena. These questions can be easily answered via a new class of SQL statements called Analytic Functions. This presentation will show you how to use Oracle's Analytic Function extensions to SQL to answer these questions simply and efficiently. Want to learn more Oracle? Check out our scheduled Oracle classes!
Language: English |
Recorded |
On Demand! |
View recorded training in Windows Media format |
|
Groovy for Java Developers |
Groovy is part of the new generation of dynamic languages for the JVM. It's not intended to replace Java, but rather to make it easier, more flexible, and more powerful. Groovy is what Java would have been like had it been designed in the 21st Century. Groovy dramatically simplifies Java development, and also brings modern language concepts like builders, closures, and metaprogramming to existing Java systems. The purpose of this session is to demonstrate both how Groovy makes Java development quicker and easier, and also to show some of Groovy's more advanced features. The capabilities illustrated will include:
Want to learn more Groovy? Instructor-Led, online Groovy for Java Developers class!
Language: English |
Recorded |
On Demand! |
View recorded training in Windows Media format |
|
Oracle Application Express as a Reporting Solution |
Many organizations use applications that run on Oracle such as SunGard Banner, FAMIS, and Oracle Applications to name a few. These applications often offer reporting capabilities that are rigid or ineffective when it comes to keeping up with changing business needs and/or business processes viewed as "unusual" or "non-standard". More and more, these organizations are turning to Oracle Application Express (APEX) to fill this reporting void. Because of its small learning curve and impressive capabilities, APEX is the perfect solution to deliver all kinds of reports. In this webinar, learn how to use APEX to build applications used solely for reporting purposes. Topics will include:
Want to learn more APEX? Everything APEX!
Language: English |
Recorded |
On Demand! |
View recorded training in Windows Media format |
|
Designer/Developer Workflow with Flex 4 and Flash Catalyst |
Flex 4 and Flash Catalyst provide the easiest and most rapid way to build engaging Rich Internet Applications today. In this webinar, we'll show you how to use Flash Catalyst to convert a designer's Photoshop file into a Flex 4 UI, enhance the user experience with transitions and effects, then use the data centric features of FlashBuilder 4 to create a complete application that can create, read, update, and delete records using a PHP data service.
Language: English |
Recorded |
On Demand! |
View recorded training in Windows Media format |
|
jQuery Tabs in Oracle Application Express |
Many developers and organizations are looking for ways to take their Application Express (Apex) applications to the next level. On the client side, one of the best tools available for this purpose is jQuery and jQuery UI. In this webinar, we'll show you how to how "install" jQuery into your Apex application. Afterward, we'll demonstrate how to use a jQuery UI widget called Tabs to improve upon a rather cluttered application page.
Language: English |
Feb. 3, 2010 (recorded 9/17/09) |
On Demand! |
View recorded training in Windows Media format |
|
Using the Oracle 11g SQL Results Cache |
Learn how to configure and use the Oracle Database 11g SQL Results Cache in this webinar. Dave will teach the fundamentals of the cache, then demonstrate how to configure, use, monitor and do performance testing using the results cache.
Language: English |
Recorded |
On Demand! |
View recorded training in Windows Media format |
|
Introduction to Oracle Application Express |
Application Express (Apex) is an easy to use platform for developing data-centric web based applications. Although it has been around for years, many people have yet to really discover and utilize its unique strengths. Those new to Apex often have many questions including: What can Apex do for me or my organization? What features are available "out of the box" and can I extend the product if needed? Is is secure and can it scale? This session will answer these questions, and many more, via a high level product overview which will include a live demo.
Language: English |
Presented |
On Demand! |
View recorded training in Windows Media format |
|
Oracle Forms to Oracle APEX – A Migration Roadmap |
Many organizations are seeking an HTML-based migration path for their Oracle Forms applications. The main platforms available, including JSP/JSF, .NET, and PHP, are object oriented and may require extensive time and training for those new to them. Audience: Oracle Forms and Reports Developers, IT Management, Oracle DBAs. Language: English |
Recorded |
On Demand! |
View recorded training in Windows Media format |
|
"Look What You Can Do With PL/SQL!" with Steven Feuerstein |
This webinar provides a whirlwind tour of some of the most exciting features of PL/SQL that you all should know about and use, including DBMS_ERRLOG, FORALL, BULK COLLECT and DBMS_UTILITY.FORMAT_ERROR_BACKTRACE. Oracle ACE Director Steven Feuerstein is an expert on the Oracle PL/SQL language. He is the author or coauthor of 10 books on PL/SQL including Oracle PL/SQL Programming and Oracle PL/SQL Best Practices, is a PL/SQL Evangelist and has been developing software since 1980. His current obsession is improving PL/SQL code quality through automated unit testing. You can find out more about Steven and his PL/SQL-related activities by visiting www.stevenfeuerstein.com and www.ToadWorld.com/SF. Language: English |
Recorded |
On Demand! |
View recorded training in Windows Media format |
|
Introduction to Oracle Application Express |
Application Express (Apex) is an easy to use platform for developing data-centric web based applications. Although it has been around for years, many people have yet to really discover and utilize its unique strengths. Those new to Apex often have many questions including: What can Apex do for me or my organization? What features are available "out of the box" and can I extend the product if needed? Is is secure and can it scale? This session will answer these questions, and many more, via a high level product overview which will include a live demo.
Language: English |
Recorded |
On Demand! |
View recorded training in Windows Media format |
|
Customizing Oracle Grid Control with User Defined Metrics and Reports |
Learn how to use "User Defined Metrics" in Oracle Grid Control. This session is going to be highly technical in nature – attendees should have a good understanding of Oracle Grid Control. Topics covered will include an overview of Grid Control, an introduction to User Defined Metrics (UDMs), creating Host UDMs, creating Database UDMs, creating Alerts on UDMs, creating custom reports using UDM values and creating rules for UDB Alerts.
Language: English |
Presented |
n/a |
Get Presentation |
|
Oracle Security: Guidelines for an Effective Audit |
This webinar outlines the need for securing Oracle, and explores the traditional approach versus the correct approach. Topics covered include data flow, privilege and access assessment, and caveat emptor.
Language: English |
Recorded |
On Demand! |
View recorded training in Windows Media format |
|
jQuery Tabs in Oracle Application Express |
Many developers and organizations are looking for ways to take their Application Express (Apex) applications to the next level. On the client side, one of the best tools available for this purpose is jQuery and jQuery UI. In this webinar, we'll show you how to how "install" jQuery into your Apex application. Afterward, we'll demonstrate how to use a jQuery UI widget called Tabs to improve upon a rather cluttered application page.
Language: English |
Recorded |
On Demand! |
View recorded training in Windows Media format |
|
Scaling to Infinity – Partitioning Data Warehouses on Oracle |
Learn the basic design issues necessary to scaling data warehouses in size while maintaining performance and manageability. Key is the proper use of partitioning, but the theoretical and practical underpinnings for the recommendations are reviewed as well. Language: English |
Recorded August 12, 2009 |
On Demand! |
View recorded training in Windows Media format |
|
Introduction to Oracle Data Guard |
What is High Availability? What is Disaster Recovery? And why do we need them? This webinar, geared toward both technical staff and management, is designed to answer those questions. We begin with a Data Guard overview including basic concepts and components, and cover configuring, monitoring and troubleshooting Data Guard. Language: English |
Presented Sept. 9, 2009 |
n/a |
Get Presentation |
|
Oracle 11g New Features |
This session provides an overview of important new features in Oracle 11g. The discussion begins with performance enhancements, including improved analysis of Wait Events, a new invisible index feature and caching of SQL statement results. In the next session we will cover Database Replay, which allows the capture of a production workflow for testing on a testing server and Oracle 11g's simplified PL/SQL code compiling, which also eliminates the need for a C compiler allowing it to be used on Windows platforms. Presenter: Chuck Felix Language: English |
Recorded |
On Demand |
View recorded training in Windows Media format |
|
Oracle 11g New Features – Part II |
This training provides you with a technical introduction to the Database Replay utility, which can capture a real workload and replay that workload against a test system. (Note that in this presentation Chuck delivers a live demo of database replay and encounters an error with the capture process. Per Chuck "....having saved the previous capture files into a sub-directory was the problem. Even though the capture files were moved out of the default directory, the fact that there was a sub-directory there was enough to make the capture job FAIL!") Database Administrators, PL/SQL Developers, IT Managers and Training Coordinators with Oracle Database experience can all benefit from this webinar. Presenter: Chuck Felix Language: English |
Recorded |
On Demand |
View recorded training in Windows Media format |
|
SQL Tuning: Analyzing Oracle SQL Execution Plans |
An Oracle SQL execution plan is a vital component in diagnosing performance issues with sql statements. One of the challenges faced by Oracle developers and DBA's alike is how to use execution plan to focus efforts. Searching for specific operations or access paths may shift your the focus away from the real issue and waste your time making changes that have little positive impact. Using the foundation of the Throwaway Method and Response Time-based tuning, this session shows how to look for inefficiencies in statement processing and how to identify operations that contribute the most to the overall response time. Presenter: Daniel Fink, Oracle Oak Table Member Language: English |
Recorded |
On Demand |
View recorded training in Windows Media format |
|
Shared Spreadsheet Nightmares? Oracle ApEx to the Rescue! |
In this session we will show you how easy it can be to convert an existing spreadsheet into an ApEx application. Once the application is created we'll explore some of the advanced functionality available "out of the box". Later we will enhance the application by adding validations which help ensure the integrity of the data as well as authentication and authorization schemes which provide security. Presenter: Daniel McGhan, ApEx expert, developer of the famous Brown University Energy Efficiency Application and SkillBuilders ApEx instructor. Language: English Also see: Online ApEx Classes |
Recorded |
On Demand |
|
|
Oracle Real Application Clusters (RAC) |
Oracle Real Application Clusters (RAC) is Oracle's premier clustering product. RAC provides both scalability and availability by allowing multiple instances to simultaneously access the same database. This session will provide you with an overview of the RAC architecture and features. In addition, some administration and tuning tips will be provided. As with most technology, RAC is not a solution for every scenario. Some applications scale well with RAC and others don't scale as well. Some examples of different configuration options and architectures will be provided. This will allow you to decide if RAC might be right for your system. Presenter: Edward Whalen Language: English |
Recorded |
On Demand |
View recorded training in Windows Media format |
|
Understanding and Using PL/SQL Arrays and Bulk Processing |
PL/SQL is Oracle's procedural language extension to SQL. It is functionally similar to SQL Server and Sybase's Transact SQL, but much more powerful. The strength of PL/SQL and similar language extensions to SQL is that they are much more flexible than SQL. Their weakness is their performance. Oracle has addressed this weakness via PL/SQL's support of PL/SQL Arrays and Bulk Processing. For many applications traditional PL/SQL requires us to process one row at a time. With Arrays and Bulk Processing many of these same applications can be easily rewritten to process many rows at a time. Additionally, Arrays allow us to build in-memory tables which are designed to avoid repeated SQL queries. Both techniques can lead to significant improvement in PL/SQL performance. In this presentation we review various scenarios where PL/SQL is required. We then demonstrate the traditional PL/SQL solutions, and how to convert the traditional slower PL/SQL code to much faster code using PL/SQL Arrays and Bulk Processing. Presenter: Geoff Wiland Language: English |
Recorded |
On Demand |
View recorded training in Windows Media format |
|
Understanding and Using XML |
XML, the eXtensible Markup Language, is a universal language for describing data. XML is somewhat similar to HTML but addresses a much broader purpose and is therefore far more powerful and useful. In short, XML provides a common data format that all applications can share. In this presentation, we review the many uses of XML in application design and demonstrate how to create an XML document. Once created, we examine how to automatically validate your XML document using both DTD schemas and XSchemas. Additionally, we describe and give examples of how XML Stylesheets are used to convert XML to HTML for presentation in a browser. This presentation will give you a solid foundation in how XML is used in developing modern software applications. Presenter: Geoff Wiland Language: English |
Recorded |
On Demand |
View recorded training in Windows Media format |
|
How, Why and When to use Oracle SQL Trace |
Attend this free training session and learn:
Your Instructor: Dave Anderson has more than 27 years of hands-on experience in the I.T. industry. His last 12 years have been spent working with Oracle – as a developer and administrator. Dave is also a frequent presenter at Oracle User Groups around the country. Language: English |
Recorded |
On Demand |
View portions |
|
Effective Use of Oracle SQL Trace |
Extended SQL Trace is one of the most effective diagnostic tools for Oracle. When done properly, tracing reveals exactly what calls a user session is making and eliminates guess work when addressing performance issues. This presentation focuses on real life experience with lightly documented issues and covers how to properly trace a user session, wait events, trace file architecture and how to read it, and summarizing session activity using profiling tools. We finish with several test cases demonstrating the usefulness of sql trace to diagnose session, sql, system and architecture issues. Presenter: Daniel Fink specializes in Oracle performance diagnosis and optimization, monitoring and data recovery. He has been in IT for over 17 years, first as a Cobol programmer on the Vax VMS platform. In 1995, he transitioned to Oracle, first as a developer, then DBA...on DEC Alpha OpenVMS and Oracle Parallel Server 7.0.13. He has been both a development and production DBA (often at the same time). For the past 5 years, Daniel has focused on Oracle performance diagnosis and optimization. He has been a member of the Oak Table Network (www.oaktable.net) since 2004. Daniel has presented at conferences and user group meetings across the United States and Europe, including RMOUG Training Days, The Hotsos Symposium, IOUG-A Live!, UKOUG, Miracle dbForums in Denmark and Scotland. Language: English |
Recorded |
On Demand |
View recorded training in streaming Flash video |
|
SQL Injection: From the Basics to Botnet-Based Attack Automation |
SQL Injection is an enormous emerging data security threat, used to commit wide-scale fraud, steal from bank accounts, capture credit card numbers, distribute malware, and construct botnets. Neil Daswani reviews how SQL Injection works, provides examples of advanced and automated SQL injection attacks, outlines how to properly defend against attacks, and discusses why you must defend against them — even if you don't store "sensitive" information in your databases. Presenter: Neil Daswani has held R&D, teaching and managerial roles at Google, Stanford University, DoCoMo USA Labs, Yodlee, and Bellcore (now Telcordia). He is an expert in data security, and the lead author of "Foundations of Security: What Every Programmer Needs to Know." Language: English |
Presented |
n/a |
Get Presentation |
|
Oracle Database 11g Real Application Testing: SQL Performance Analyzer |
This webinar focuses on Oracle Database 11g Real Application Testing's SQL Performance Analyzer component. Real Application Testing combines a workload capture & replay feature with an SQL performance analyzer to help you test changes against real-life workloads, then helps you fine-tune them before putting them into production. Language: English |
Recorded |
On Demand |
View recorded training in streaming Flash video |
|
Oracle Database 11g Real Application Testing: Database Replay |
This webinar focuses on the capabilities of Oracle Database 11g Real Application Testing's Database Replay component. Real Application Testing combines a workload capture & replay feature with an SQL performance analyzer to help you test changes against real-life workloads, then helps you fine-tune them before putting them into production. Language: English |
Presented |
n/a |
Get Presentation |
|
Free Yourself of Statspack |
Find out how – beginning with Oracle 10g and growing more powerful in Oracle 11 – the new features of ASH (Active Session History) and AAS (Average Active Sessions) are more versitile and powerful than statspack. Learn more about ASH, a new paradigm in performance data, and AAS, the ultimate summary of ASH data. Kyle will also present examples of problem detection, analysis and resolution, as well as scripts to get the most out of ASH with the least amount of effort. Language: English Presenter: Kyle Hailey, ASH Master! Kyle recently helped Oracle redesign OEM to be wait-event centric and was the Technical Editor of the 5-Star Oracle Wait Event Tuning book by Richmond Shee. |
June 4, 2008 (India Only) |
9AM (GMT+5.30) |
Register |
|
An Introduction to SOA and Web Services |
This one hour presentation will provide the attendee with a basic understanding of the general Service Oriented Architecture (SOA) and its more specific manifestation as Web Services. Topics that Kevin will discuss include the SOA service provider/consumer model, the Web Service XML technology stack (WSDL, SOAP, and UDDI), coarse grained vs. fine grained transactions, web latency, and asynchronous transmissions. Language: English |
May 1 |
1:00pm - 2:00pm EDT |
Get Presentation |
|
XML in Oracle |
This 90-minute XML in Oracle presentation describes the primary features of Oracle10g Release 2 XML DB. XML DB is an Oracle product that provides high performance XML storage and retrieval capabilities. Data can be stored in XML tables, in columns of standard Oracle tables, in Oracle's XML Repository, or in XML documents stored external to the Oracle database. With XML DB, Oracle now combines the capabilities and advantages of Oracle relational databases with the capabilities and advantages of XML. Features such as the XMLType datatype, structured versus unstructured XML storage, schema registration, XQuery, and the XML Repository are described. Many code examples are shown to demonstrate these features. Language: English |
Recorded |
On Demand |
View recorded training in streaming Flash video |
System Requirements
To join a SkillBuilders webinar, you will need:
- Internet Explorer® 5.0 or newer, Netscape® 6.0 or newer, Mozilla Firefox® 1.0 or newer (with JavaScript™ and Java™ enabled)
- Windows® 2000, XP, 2003 Server or Vista
- Stable 56k modem, cable modem, ISDN, DSL or better Internet connection
- Minimum of Pentium® 400MHz processor with 256MB of RAM (recommended)
- Telephone. Headset or speaker phone is recommended.Local or long-distances phone charges are additional and are billed by your telephone service provider. Phone number is provided when registration is completed.
