Free Training in Oracle 10g / 11g, Application Express (ApEx), SQL Tuning, PL/SQL, SQL Trace |
New! Convert webinar times
|
| Webinar Topic | Description | Date | Time | Register |
|---|---|---|---|---|
|
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 |
Mar. 5, 2010 |
1PM - 2PM ET |
|
|
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.
