Free Technical Trainings in Oracle, XML DB, Business Intelligence and More |
| Webinar Topic | Description | Date | Time | Register |
|---|---|---|---|---|
|
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 Sept. 10 |
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 June 19 |
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 April 11 |
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 (India Only) |
9AM (GMT+5.30) |
|
|
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 |
|
An Introduction to Oracle Warehouse Builder |
This presentation will provide a basic understanding of Oracle Warehouse Builder. The presentation will define the Extract, Transform, and Load process and specifically discuss Oracle Warehouse Builder. The presentation will provide an overview of the tool and how projects are created, how to import tables, what a mapping looks like and some basic transformations. Lastly, this presentation will discuss the advantages of Oracle Warehouse Builder over standard PL/SQL and its return on investment. Language: English |
Presented May 15 |
n/a |
Get Presentation |
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.

