BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//SkillBuilders - ECPv6.15.20//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-ORIGINAL-URL:https://skillbuilders.com
X-WR-CALDESC:Events for SkillBuilders
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/New_York
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20170312T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20171105T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20180311T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20181104T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20190310T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20191103T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20200308T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20201101T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20210314T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20211107T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20220313T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20221106T060000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20210224T080000
DTEND;TZID=America/New_York:20210224T090000
DTSTAMP:20260502T025822
CREATED:20210217T171525Z
LAST-MODIFIED:20210217T171525Z
UID:10000123-1614153600-1614157200@skillbuilders.com
SUMMARY:Manual Standby Database - A Free Webinar
DESCRIPTION:REGISTER FOR THIS WEBINAR \nManual Standby Database\nNear zero data loss with Standard Edition\nA free webinar \nDescription\nData Guard can deliver zero data loss. Consider the worst case: someone steals your DB server and sells it on EBay. If you have Data Guard appropriately configured to replicate and apply changes to a remote standby you will lose no data\, failover will be automatic\, and downtime will be minimal. However\, Data Guard requires Enterprise Edition licenses. What can you do if you are running on Standard Edition? You can configure a Manual Standby instead. It requires a bit more work because you don’t have all the automation that comes with Data Guard\, and you are vulnerable to a small loss of data. But the work can be scripted\, and the data loss kept down to a few minutes. \n  \nIn this webinar we’ll demonstrate the whole process. \n  \nPrerequisite Knowledge\nSome of the content could be described as “advanced”. Basic DBA skills will be needed\, and familiarity with OS and database command line tools. \nPresenters \nJohn Watson\, Oracle Certified Master DBA\, SkillBuilders Director of All Things Oracle Database \n  \nRecording\nBarring any technical glitches\, all webinars are recorded and posted as tutorials. See all tutorials HERE \nRegistration \nBy registering for the webinar\, you will be placed on SkillBuilders mailing list. You will have the option to opt-out of the mailing list at any time. An extra-special event! \n 
URL:https://skillbuilders.com/webinar/manual-standby-database-a-free-webinar/
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20210120T080000
DTEND;TZID=America/New_York:20210120T090000
DTSTAMP:20260502T025822
CREATED:20201217T171324Z
LAST-MODIFIED:20201217T171529Z
UID:10000121-1611129600-1611133200@skillbuilders.com
SUMMARY:Oracle APEX 20.2 New Feature & Practical Applications - A Free Webinar
DESCRIPTION:  \nREGISTER FOR THIS WEBINAR \nOracle APEX 20.2 New Feature & Practical Applications\nOverview of Oracle APEX 20.2 new features and how to apply them to everyday applications. \nAudience\nAll Developers\, DBAs and any people with Oracle APEX experience. \nPresenters\nTyson Jouglet\, Oracle APEX Expert\, SkillBuilders Developer and Teacher \nLino Schildenfeld\, Oracle ACE\, SkillBuilders APEX Developer \nModerator\, Dave Anderson\, SkillBuilders Founder and Oracle DBA \nTopic Summary   \n(Subject to change somewhat) \nRedwood UI \n\nEnabling redwood\nConsiderations\n\nDeveloper Experience Enhancements \n\nMonaco Editor\nAttributes Moved\nEmbedded Code\nSingle Checkbox\n\nReport Printing \n\nBuilt in Printing\n\nData only flag\n\n\nExport data\n\nCards Region \n\nDisplay media\nConditional Actions\nIntro to Template Directives\n\nTemplate Directives \n\nConditions\nCase\nLoop\n\nFaceted Search Enhancements \n\nVisualizations of facet data\nBoolean Check Facets\n\nAutomations \n\nReport runner\n\n  \n  \nRegistration\nBy registering for the webinar\, you will be placed on SkillBuilders mailing list. You will have the option to opt-out of the mailing list at any time.   \nRecording\nAll webinars are recorded and posted as tutorials. See all tutorials HERE \n  \n 
URL:https://skillbuilders.com/webinar/oracle-apex-20-2-new-feature-practical-applications-free-webinar/
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20210119T080000
DTEND;TZID=America/New_York:20210119T090000
DTSTAMP:20260502T025822
CREATED:20201222T174242Z
LAST-MODIFIED:20210113T171911Z
UID:10000122-1611043200-1611046800@skillbuilders.com
SUMMARY:Tuning Oracle for DW and OLTP with Real-Time Materialized Views - A Free Webinar
DESCRIPTION:REGISTER FOR THIS WEBINAR\n \nHow to Support Data Warehouse and OLTP Use in a Single Oracle Database\nA free webinar \nDescription\nLearn how to implement Oracle Real-Time Materialized Views to tune a single Oracle Database for both Data Warehouse and OLTP use. Configuration is not necessarily straight forward. We’ll demonstrate the problems\, and how to fix them. \nBackground\nHow can you tune an Oracle database for both OLTP and Data Warehouse use at the same time? A common solution is to use materialized views: the small transactions address the tables\, the big queries hit the views. However\, if the queries need to return real-time information\, you will likely end up with either fast transactions and slow queries\, or slow transactions and fast queries. Or perhaps everything will be slow. \nIn this webinar John will demonstrate how to use Oracle materialized views to optimize queries without impacting on transaction processing by implementing the recently added feature of Real-Time Materialized Views.  \nFrom Oracle Database release 12.2 and up\, not only can queries be transparently re-written to address the views (that isn’t new at all) but if the view is stale changes in the materialized view logs can be transparently merged into the result set\, thus giving real-time results without the overheads of FAST (or even ON COMMIT) refresh. However\, configuring this is not necessarily straight forward. We’ll demonstrate the problems\, and how to fix them. \n  \nPrerequisite Knowledge\nOracle Database Administrators or anyone with: \n\nA solid understanding of Data Warehouse and Online Transaction Processing (OLTP) concepts\nSome experience with Materialized Views\nSome Oracle tuning experience such as interpreting Execution Plans. A free tutorial on Reading Oracle Execution Plans\, great as an introduction OR a refresher\, can be found here.\n\nPresenters \nJohn Watson\, Oracle Certified Master DBA\, SkillBuilders Director of All Things Oracle Database \nDave Anderson\, SkillBuilders’ Founder\, Oracle DBA \nRecording\nBarring any technical glitches\, all webinars are recorded and posted as tutorials. See all tutorials HERE \nRegistration \nBy registering for the webinar\, you will be placed on SkillBuilders mailing list. You will have the option to opt-out of the mailing list at any time. An extra-special event! \n 
URL:https://skillbuilders.com/webinar/tuning-oracle-for-dw-and-oltp-with-real-time-materialized-views/
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20201209T080000
DTEND;TZID=America/New_York:20201209T090000
DTSTAMP:20260502T025822
CREATED:20201202T172106Z
LAST-MODIFIED:20201205T120443Z
UID:10000120-1607500800-1607504400@skillbuilders.com
SUMMARY:Oracle Database Logon: Let's Count (and Learn) The Ways - A Free Webinar
DESCRIPTION:REGISTER FOR THIS WEBINAR\n \nOracle Database Security: There are other ways than providing your username and password!\nA free webinar \nTo logon to an Oracle database\, the obvious way is to present a username and a password. However\, there are alternatives. For example\, you could logon by presenting a digital certificate instead of a password. Or what if you want to connect as another user\, and you don’t know their password? Or you have scripts where you don’t want to embed the password? And perhaps you need to let your users or junior DBAs use shared accounts without compromising password security and audit. And what is the point of the CREATE USER … NO AUTHENTICATION command? \n  \nThis webinar will describe using SSL certificate authentication\, Proxy Authentication\, the Secure External Password Store\, local and remote Operating System Authentication\, and schema only accounts. Authentication using LDAP directories such as MS-AD will be a later webinar. \nPrerequisite Knowledge\nSome of the content could be described as “advanced”. Basic DBA and/or developer skills will be needed\, and familiarity with OS and database command line tools. \nPresenters \nJohn Watson\, Oracle Certified Master DBA\, SkillBuilders Director of All Things Oracle Database \nDave Anderson\, SkillBuilders’ Founder\, Oracle DBA \nRecording\nBarring any technical glitches\, all webinars are recorded and posted as tutorials. See all tutorials HERE \nRegistration \nBy registering for the webinar\, you will be placed on SkillBuilders mailing list. You will have the option to opt-out of the mailing list at any time. An extra-special event! \n 
URL:https://skillbuilders.com/webinar/database-logon-let-me-count-the-ways/
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20201118T070000
DTEND;TZID=America/New_York:20201118T080000
DTSTAMP:20260502T025822
CREATED:20201106T172318Z
LAST-MODIFIED:20201113T154407Z
UID:10000119-1605682800-1605686400@skillbuilders.com
SUMMARY:Discovering JavaScript Part 4 - A Free Webinar
DESCRIPTION:REGISTER FOR THIS WEBINAR \nJavaScript for Oracle APEX Developers\, Part 4 \nIn this webinar you will learn how to extend declarative APEX components using provided APIs that relate to trees\, AJAX\, and actions. \nDiscovering JavaScript\, Parts 1 \, 2  and 3 are free video tutorials.   \nWatch Part One\, A Beginners Guide to Javascript in APEX. \nWatch Part Two\, JavaScript Objects and Namespaces. \nWatch Part Three\, Events. \nAudience\nIntermediate/Advanced APEX developers \nPresenters\nTyson Jouglet\, Oracle APEX Expert\, SkillBuilders Developer and Teacher \nLino Schildenfeld\, Oracle ACE\, SkillBuilders APEX Developer \nModerator\, Dave Anderson\, SkillBuilders Founder and Oracle DBA \nTopic Summary   \n\nHow do we build APEX applications?\nBuilding a Tree Component\nAdding Actions to Tree Nodes\nWhat is an Action?\nExtending Actions with Shortcuts\nActions Which Depend on the Server\nWhat is the Server Namespace?\nStay Organized by Creating Your Own API\n\nRegistration\nBy registering for the webinar\, you will be placed on SkillBuilders mailing list. You will have the option to opt-out of the mailing list at any time.   \nRecording\nAll webinars are recorded and posted as tutorials. See all tutorials HERE \n  \nWANT MORE?\nCheck out Tyson’s JavaScript Class! \n 
URL:https://skillbuilders.com/webinar/discovering-javascript-part-4-a-free-webinar/
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20201105T080000
DTEND;TZID=America/New_York:20201105T090000
DTSTAMP:20260502T025822
CREATED:20201008T123708Z
LAST-MODIFIED:20201107T004305Z
UID:10000118-1604563200-1604566800@skillbuilders.com
SUMMARY:SQL Tuning with Oracle Optimizer View Merging - A Free Webinar
DESCRIPTION:A vital optimization that your queries need\nOracle’s Cost Based Optimizer (CBO) is an incredible software artifact\, possibly the most complex we will ever work with. But it is not infallible: the CBO needs our help. In this webinar you will learn how we can provide help related to View Merging (aka Unnesting) to the CBO and – in some cases – dramatically reduce response time with a simple rewrite of the query!  \n  \nOne case is CBO’s ability to merge view definitions and subqueries during optimization. If there are two views referenced in the query\, the CBO may choose to build two results sets independently\, then merge two results to create a single result set to pass the user OR merge the view definitions and create a single result set to be passed to the user. The latter plan – reducing the number of results sets to be merged – can often deliver astronomical performance benefits. But not if the syntax of the query prevents it. We need to learn how to not prevent view merging.  \n  \nYou will learn – through demonstrations and proving theories with execution plans – what query structures prevent View Merging. You will learn to recognize View Merging – or the lack of it – in execution plans. You’ll learn what the related suspicious structures are – the “Red Flags”.   \nPrerequisite Knowledge\nSolid experience with Oracle SQL SELECT statement clauses and functions. \nBasic experience reading Oracle execution plans. See SkillBuilders’ Free Tutorial How to Read an Execution Plan for assistance. \nSome familiarity with Oracle sample schemas\, including Scott\, Human Resources (HR)\, Sales History (SH) and Order Entry (OE).  If you haven’t used these demonstration schemas before\, take a couple of minutes to get familiar with them. Refer to the Oracle Documentation for schema diagrams.  \nPresenters \nJohn Watson\, Oracle Certified Master DBA\, SkillBuilders Director of All Things Oracle Database \nDave Anderson\, SkillBuilders’ Founder\, Oracle DBA \nRecording\nBarring any technical glitches\, all webinars are recorded and posted as tutorials. See all tutorials HERE \nRegistration \nBy registering for the webinar\, you will be placed on SkillBuilders mailing list. You will have the option to opt-out of the mailing list at any time. An extra-special event! \n 
URL:https://skillbuilders.com/webinar/learn-oracle-optimizer-view-merging/
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20201021T090000
DTEND;TZID=America/New_York:20201021T100000
DTSTAMP:20260502T025822
CREATED:20200902T154840Z
LAST-MODIFIED:20201016T021107Z
UID:10000116-1603270800-1603274400@skillbuilders.com
SUMMARY:Above and Beyond with SkillBuilders’ Oracle Database Manager (SBODM)
DESCRIPTION:REGISTER FOR THIS WEBINAR \n \nAnother Free Webinar from SkillBuilders\nAttend this free webinar and learn about the many powerful features in SkillBuilders’ Oracle Database Manager  – and how easy they are to use. If you are already an SBODM user\, this is a great opportunity to get your questions answered. \nSBODM can be downloaded HERE. (free) \nSBODM is a free\, open-source\, lightweight and easy-to-use database management tool for Oracle Database. It is free\, written in Oracle APEX and manages a single database – the database on which it is installed. It’s very useful as a complement to SQL Developer (in the webinar we will compare features)\, or\, for Standard Edition Oracle customers\, as the primary replacement for Oracle Enterprise Manager. It’s also an essential tool for Oracle Database Embedded license customers where no management tool is provided.  \nOf course\, SBODM can do the routine stuff like backups\, manage RMAN configurations\, view storage and manage users\, but there’s so much more. For example\, here’s just some of the things that SBODM can do that most other free tools cannot: \n\nDisplay current\, waiting or blocked sessions and allow you to terminate sessions\nSee the current SQL with the Explain Plan\nSee recent alert log entries on the dashboard\, optionally filtered\nReceive job notifications\, export\, import\, rman\, any job (complete/success/error)\nDisplay the complete Alert Log\nSet system thresholds with Alerts and Notifications (Even on Standard Edition!) \nSchedule APEX schema and workspace exports (APEX Backups)\nManage ASM storage\nContext-sensitive Help System with User Customizable Error Messages \nBE MODIFIED to INCLUDE ANY FEATURE or FUNCTION THAT YOU WANT\n\nMany of these features will be demonstrated in this webinar.  \nTopics \n\nBrief Introduction – What is SBODM\nProduct Demonstrations \n\nPresenters\nGarry Lawton\, SkillBuilders Super+ Technologist and Debugger\, SBODM Creator\nDave Anderson SkillBuilders Founder\, President and Oracle Techy\nJohn Watson\, SkillBuilders Super+ Oracle DBA\, Oracle Certified Master \nAudience\nThe webinar is designed for DBA’s and Oracle Database Power Users or Developers who are responsible for managing an Oracle Database. IT Database Management can also benefit. \nRecording\nAll webinars are recorded and posted as tutorials. See all tutorials HERE \nBy registering for the webinar\, you will be placed on SkillBuilders mailing list. You will have the option to opt-out of the mailing list at any time. \nDate \nOctober 21st  at 1:00 pm ET
URL:https://skillbuilders.com/webinar/above-and-beyond-with-skillbuilders-oracle-database-manager-odm-2/
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20200929T090000
DTEND;TZID=America/New_York:20200929T093000
DTSTAMP:20260502T025822
CREATED:20200912T163002Z
LAST-MODIFIED:20201009T142521Z
UID:10000117-1601370000-1601371800@skillbuilders.com
SUMMARY:Refreshable PDB Clones in Oracle Database - A Free Webinar
DESCRIPTION:  \n \nThe Poor Man’s Data Guard\nLearn\, via live demonstration\, how to use Refreshable PDB Clones to provide DataGuard-like capabilities\, even on Oracle Standard Edition! \n  \nWe all know that Multitenant Architecture is inevitable. We also know that some sites have resisted converting to it. Well\, OK: it can be viewed as a needless complication. However\, once you start using it\, you will think “why didn’t I do this years ago”. One reason for this is how easily you can clone and relocate PDBs.  \n  \nThe Refreshable Clone capability takes PDB cloning to another level. It gives you Data Guard type capabilities for preventing data loss and for zero downtime platform migrations\, even for SE2 systems. This webinar will describe the usage case\, and demonstrate how to do it. \n  \nAudience\nPrerequisite knowledge: you need to understand Multitenant Architecture. But then\, that is a prerequisite for anything breathing nowadays.   \n  \nIf you need to get up to speed on Multitenant\, we have three FREE tutorials on Oracle Multitenant Architecture: \n  \nOctober 2017 \n43 Minutes \nMultitenant is Coming\, Resistance is Futile – https://skillbuilders.com/course/multitenant-database-is-coming-resistance-is-futile/  \n  \nAugust 2016 \n16 Minutes \nHow to Convert an Oracle 12c Database to a Multitenant Pluggable Database (PDB) \nhttps://skillbuilders.com/course/how-to-convert-an-oracle-12c-database-to-a-multitenant-pluggable-database-pdb/  \n  \nPresenters \nJohn Watson\, Oracle Certified Master DBA\,  SkillBuilders Director of All Things Oracle Database\nDave Anderson\, SkillBuilders’ Founder\, Oracle DBA \n  \nRecording\nAll webinars are recorded and posted as tutorials. See all tutorials HERE \nRegistration \nBy registering for the webinar\, you will be placed on SkillBuilders mailing list. You will have the option to opt-out of the mailing list at any time.An extra-special event! \n 
URL:https://skillbuilders.com/webinar/refreshable-pdb-clones-in-oracle-database/
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20200826T080000
DTEND;TZID=America/New_York:20200826T090000
DTSTAMP:20260502T025822
CREATED:20200812T093157Z
LAST-MODIFIED:20201029T172708Z
UID:10000114-1598428800-1598432400@skillbuilders.com
SUMMARY:Discovering JavaScript Part 3 - A Free Webinar
DESCRIPTION:REGISTER FOR THIS WEBINAR \n  \nDiscovering Javascript Part 3\nObjective \nIn this webinar\, the third in a series\, you will learn the event driven architecture of JavaScript in the browser. This architecture makes it possible to create interactive websites\, far beyond what is possible with just Oracle APEX and/or HTML. \nDiscovering JavaScript\, Parts 1 and 2 are free video tutorials.   \nWatch Part 1\, A Beginners Guide to Javascript in APEX. \nWatch Part 2\, JavaScript Objects and Namespaces. \nAudience\nOracle APEX developers \nPresenters  \nTyson Jouglet\, Oracle APEX Expert\, SkillBuilders Developer and Teacher\nLino Schildenfeld\, Oracle ACE\, SkillBuilders APEX Developer\nModerator\, Dave Anderson\, SkillBuilders Founder and Oracle DBA \nTopic Summary   \n\nWhat is an Event\nAdding Event Listeners and Handlers\nEvent Bubbling\nDelegating Event Handlers\nEvents can be Noisy!\nCreating a Custom Event\nPassing along Event Data\nDeclarative Dynamic Actions\nExtending Dynamic Actions with Custom Javascript\n\nRegistration\nBy registering for the webinar\, you will be placed on SkillBuilders mailing list. You will have the option to opt-out of the mailing list at any time.An extra-special event! \nRecording\nAll webinars are recorded and posted as tutorials. See all tutorials HERE \n  \nWANT MORE?\nCheck out Tyson’s JavaScript Class! \n 
URL:https://skillbuilders.com/webinar/discovering-javascript-part-3/
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20200819T090000
DTEND;TZID=America/New_York:20200819T100000
DTSTAMP:20260502T025822
CREATED:20200812T103939Z
LAST-MODIFIED:20200814T130745Z
UID:10000115-1597827600-1597831200@skillbuilders.com
SUMMARY:How to Get Started with Oracle Autonomous Database - A Free Webinar
DESCRIPTION:  \nREGISTER FOR THIS WEBINAR \nAn Introduction to Oracle Autonomous Database\nA free webinar. \nOracle’s OCI (Oracle Cloud Infrastructure) and ADB (Autonomous Database) environment is very cool. It is also very complicated. It is designed to scale\, and to be secure. And when Oracle talks “scale”\, they mean the size of Jupiter; and by “secure”\, well\, Fort Knox ain’t got nothing on OCI.  \nUnfortunately\, no-one said that facilities as powerful as this would necessarily be simple to manage. However\, getting started can be easy.  \nThis webinar is not intended to be an in-depth lesson on configuring and using OCI and ADB. This webinar will provide a quick run through of what it can do\, including demonstrating how to get started for a project. Demonstrations will include creating a virtual machine and an Autonomous DB that might be suitable for any developer or DBA to use to\,for example\, develop an APEX application before going live.  \nWhat does such an environment cost? Possibly nothing at all: the “Always Free” tier is available to everyone. \nAudience\nOracle DBA’s\, developers or anyone with basic Oracle Database experience (e.g. SQL) who is interested in a cloud-based Oracle Database environment. \nPresenters \nJohn Watson\, Oracle Certified Master DBA\,  SkillBuilders Director of All Things Oracle Database\nDave Anderson\, SkillBuilders’ Founder\, Oracle DBA \nTopic Summary\n\nWhat is an Autonomous database?\nHow do you use it?\nCreating an environment\, basic use of\nLimitations\nA word on costs \n\nRecording\nAll webinars are recorded and posted as tutorials. See all tutorials HERE \nRegistration \nBy registering for the webinar\, you will be placed on SkillBuilders mailing list. You will have the option to opt-out of the mailing list at any time.An extra-special event! \n 
URL:https://skillbuilders.com/webinar/how-to-get-started-with-oracle-autonomous-database-2/
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20200805T090000
DTEND;TZID=America/New_York:20200805T100000
DTSTAMP:20260502T025822
CREATED:20200325T152325Z
LAST-MODIFIED:20200624T135247Z
UID:10000107-1596618000-1596621600@skillbuilders.com
SUMMARY:Above and Beyond with SkillBuilders’ Oracle Database Manager (SBODM)
DESCRIPTION:REGISTER FOR THIS WEBINAR \n \nAnother Free Webinar from SkillBuilders\nLearn the powerful and extensive features in SkillBuilders’ Oracle Database Manager (SBODM) and how easy they are to use. See demonstrations of job scheduling with a GUI for parameters\, setting thresholds\, alerts and notifications (yes\, compliant\, even with SE2) and much more. Dave and Garry will also compare SBODM to OEM DB Express\, the no-extra-cost database manager many people use with Oracle Database Editions XE and SE2. \nThis session is primarily product demonstrations. \nWhat is SBODM?\nSBODM is a lightweight\, easy-to-use database management tool for Oracle Database. It is free\, written in Oracle APEX and manages a single database – the database on which it is installed. ODM is a potential replacement for OEM DB Express (or the old DB Console). However\, SBODM has several powerful features that DB Express does not. \nTopics (Subject to Change)\n\nIntroduction – What is ODM\nDemonstrations follow…\nEveryday Tasks with ODM\n\nBackup and Recovery\nEtcetera \n\n\nAbove and Beyond the Usual with ODM\n\nScheduling custom PL/SQL blocks\, Procedures and OS executables\nScheduling any OS Script with a GUI for Parameters\nScheduling APEX exports and Includes Exports of the Parsing Schema(s)\nDefining Metric Threshold Alerts and Notifications on SE2\nViewing the Execution Plan of executing SQL statements\n\n\n\nPresenters\nGarry Lawton\, SkillBuilders Super+ Technologist and Debugger  \nDave Anderson SkillBuilders Founder\, President and Oracle Techy \nJohn Watson\, SkillBuilders Super+ Oracle DBA\, Oracle Certified Master \nAudience\nThe webinar is designed for DBA’s and Oracle Database Power Users or Developers who are responsible for managing an Oracle Database. IT Database Management can also benefit. \nRecording\nAll webinars are recorded and posted as tutorials. See all tutorials HERE \n  \nBy registering for the webinar\, you will be placed on SkillBuilders mailing list. You will have the option to opt-out of the mailing list at any time.An extra-special event! \n  \nDate \nAugust 5th\, 2020 at 1:00 pm ET \n 
URL:https://skillbuilders.com/webinar/above-and-beyond-with-skillbuilders-oracle-database-manager-odm/
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20200722T090000
DTEND;TZID=America/New_York:20200722T100000
DTSTAMP:20260502T025822
CREATED:20200711T134858Z
LAST-MODIFIED:20200716T073838Z
UID:10000113-1595408400-1595412000@skillbuilders.com
SUMMARY:Discovering JavaScript Part 2 - A Free Webinar
DESCRIPTION:REGISTER FOR THIS WEBINAR \n  \nA Beginners Guide to JavaScript in APEX (Part 2)\nLearn More JavaScript!\nTake the next step in your JavaScript education!  \nOracle Certified Expert Tyson Jouglet will teach you how to organize JavaScript code for reusability by encapsulating your logic inside of Objects and Namespaces.  \nThis webinar is the second in a series; you can watch Part 1 here. \nTopic Summary\n\nJavaScript Values\nWhat is an Object\nAdding Properties & Methods\nScope and Property Visibility\nIIFE(Immediately Invoked Function Expression)\nCreating a Namespace\nLooking Forward at Modules\n\nPresenters \nOracle Certified APEX Expert Tyson Jouglet\nModerators Lino Schildenfeld and Dave Anderson\nAudience\nOracle APEX developers \n\nRegistration\nBy registering for the webinar\, you will be placed on SkillBuilders mailing list. You will have the option to opt-out of the mailing list at any time.An extra-special event! \nWANT MORE?\nCheck out Tyson’s JavaScript Class! \n 
URL:https://skillbuilders.com/webinar/discovering-javascript-part-2/
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20200617T090000
DTEND;TZID=America/New_York:20200617T100000
DTSTAMP:20260502T025822
CREATED:20200515T143940Z
LAST-MODIFIED:20200604T041118Z
UID:10000111-1592384400-1592388000@skillbuilders.com
SUMMARY:How to Stabilize Performance when Upgrading an Oracle Database - Free Webinar
DESCRIPTION:REGISTER FOR THIS WEBINAR \nStabilizing Performance when Upgrading an Oracle Database\nSQL Plan Baselines Are Your Friend\nRecommended Prerequisite:  Free Tutorial: How to Read an Execution Plan  \nLearn how to use sql plan baselining to maintain consistent performance when upgrading an Oracle Database. \nWe all know what happens with performance when you upgrade: 90% of your SQLs run the same\, 9% run better\, and for 1% performance drops through the floor. And if you are unlucky\, it is the 1% that matter. \nThe solution is Baselining. Baselines stabilize your execution plans through the change\, letting you upgrade safely. The basic functionality is now available for SE2 as well as EE. \nOracle Certified Master DBA John Watson will demonstrate identifying a problem caused by an upgrade from 11g to 19c\, capturing a baseline on 11g\, transferring the baseline to 19c\, and showing that the 11g plan is carried through and performance returns to normal.  \nPresenter\nOracle Certified Master DBA John Watson\nModerator – Dave Anderson \nAudience \nOracle DBAs \nRecording\nAll webinars are recorded and posted as tutorials. See all tutorials HERE \nRegistration \nBy registering for the webinar\, you will be placed on SkillBuilders mailing list. You will have the option to opt-out of the mailing list at any time.An extra-special event! \nDate\nJune 17th\, 2020
URL:https://skillbuilders.com/webinar/how-to-stabilize-performance-when-upgrading-oracle-database/
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20200528T090000
DTEND;TZID=America/New_York:20200528T100000
DTSTAMP:20260502T025822
CREATED:20200515T142327Z
LAST-MODIFIED:20200529T090259Z
UID:10000110-1590656400-1590660000@skillbuilders.com
SUMMARY:Oracle Database Encryption Best Practices  - A Free Webinar
DESCRIPTION:REGISTER FOR THIS WEBINAR \nOracle Database Encryption Best Practices\nDeclaratively Encrypting Data At-Rest and In-Transit \nLearn how to transparently encrypt data at-rest and in-transit. Declaratively. \nIn almost every case\, data has to be encrypted in-transit and at-rest. How do you do this without any impact on the application software? Your DBA does it using Transparent Data Encryption to encrypt all data on disc and Native Network Encryption to protect traffic on the wire. These mechanisms work for new implementations or can be used to retro-fit security to existing environments without needing to write one line of code. Your developers and users may not know it is happening at all.  \nIn this webinar\, OCM John Watson will demonstrate configuring encryption\, including how to prove that it really is working. \nThere are complications related to encryption and Oracle Multitenant Database Architecture. Time permitting\, these complications will be addressed as well. \nPresenters\nOracle Certified Master DBA John Watson\nModerator – Dave Anderson \nAudience\nOracle DBAs or any person with technical database experience interested in Oracle database security.  \nRegistration\nBy registering for the webinar\, you will be placed on SkillBuilders mailing list. You will have the option to opt-out of the mailing list at any time.An extra-special event! \nRecording\nAll webinars are recorded and posted as tutorials. See all tutorials HERE \nDate\nMay 28th\, 2020 1:00 pm ET \nWANT MORE?\n\nSee John’s Oracle Security Administration Course\n \n 
URL:https://skillbuilders.com/webinar/oracle-database-encryption-best-practice/
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20200527T090000
DTEND;TZID=America/New_York:20200527T100000
DTSTAMP:20260502T025822
CREATED:20200515T145854Z
LAST-MODIFIED:20200710T161045Z
UID:10000112-1590570000-1590573600@skillbuilders.com
SUMMARY:Discovering JavaScript Part 1 - A Free Webinar
DESCRIPTION:A Beginners Guide to Javascript in APEX is now a FREE TUTORIAL!\nWATCH THE FREE TUTORIAL \nLearn JavaScript!\nThis webinar is the first of a multipart series which will take us from writing our first JavaScript code snippets all the way to writing our own custom modules. \nIn this webinar you will learn how JavaScript is included on a webpage and the order of operations as a page renders.  You will learn about Types\, Values\, and Functions and their respective roles in creating client side behavior. \nPlease join us as we discover JavaScript together. \nPresenters \nTyson Jouglet\nModerators Lino Schildenfeld and Dave Anderson \nAudience \nWeb Developers \n  \nRegistration\nBy registering for the webinar\, you will be placed on SkillBuilders mailing list. You will have the option to opt-out of the mailing list at any time.An extra-special event! \n  \nDate\nMay 27\, 2020   1:00 PM \n  \nWANT MORE?\nCheck out Tyson’s JavaScript Class!
URL:https://skillbuilders.com/webinar/discovering-javascript-part-1/
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20200422T090000
DTEND;TZID=America/New_York:20200422T100000
DTSTAMP:20260502T025822
CREATED:20200401T110920Z
LAST-MODIFIED:20200424T141849Z
UID:10000109-1587546000-1587549600@skillbuilders.com
SUMMARY:Exploring PLSQL and JavaScript APIs
DESCRIPTION:DOWNLOAD THE SAMPLE CODE \nExploring PLSQL and JavaScript APIs\nThere are several utilities provided by APEX that solve many problems developers encounter. In this webinar\, Certified APEX Expert Tyson Jouglet will demonstrate some of those APIs and show you how they can help build manageable APEX applications.\n \nTopics (Subject to Change)\n\nPL/SQL APIs\n\nAPEX_EXEC\nAPEX_STRING\nAPEX_DATA_PARSER\n\nJavaScript APIs\n\napex.server\napex.region\napex.actions\n\n \nPresenters\nOracle Certified APEX Expert Tyson Jouglet \nOracle ACE Lino Schildenfeld  \nModerator – Dave Anderson \nAudience\nExperienced Oracle APEX Developers \n \nRegistration\nBy registering for the webinar\, you will be placed on SkillBuilders mailing list. You will have the option to opt-out of the mailing list at any time.An extra-special event! \n  \nDate \nApril 22nd\, 2020 at 1:00 pm ET \n 
URL:https://skillbuilders.com/webinar/exploring-plsql-and-javascript-apis/
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20200409T090000
DTEND;TZID=America/New_York:20200409T100000
DTSTAMP:20260502T025822
CREATED:20200326T135547Z
LAST-MODIFIED:20200409T140549Z
UID:10000108-1586422800-1586426400@skillbuilders.com
SUMMARY:Mastering the Oracle APEX Page Designer / Application Builder
DESCRIPTION:REGISTER FOR THIS WEBINAR \n \nOverlooked Features in APEX Application Builder\nThere are several features in the Oracle APEX Page Designer (and Application Builder) that are not widely used\, at least in part because they are not easily found. In this webinar\, certified APEX Expert Tyson Jouglet of SkillBuilders will demonstrate some of his favorites – some of the perhaps overlooked features that we feel you should be using or at least aware of. \n  \nTopics (Subject to Change)\n\n\n\nWhat Tools are Available?\nDemonstrations\, Use Cases\nExamples of Features Covered:\n\nUpdate Application. What’s Involved?\nHow to switch Template A to B\nHow to change app status (e.g. read only)\n\n\n\n\n\n \nPresenters\nOracle Certified APEX Expert Tyson Jouglet \nOracle ACE Lino Schildenfeld  \nModerator – Dave Anderson \nAudience\nIntermediate APEX Dev’s \nRegistration\nBy registering for the webinar\, you will be placed on SkillBuilders mailing list. You will have the option to opt-out of the mailing list at any time.An extra-special event! \n  \nDate \nApril 9th\, 2020 at 1:00 pm ET \n 
URL:https://skillbuilders.com/webinar/mastering-the-page-designer-app-builder/
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20200226T080000
DTEND;TZID=America/New_York:20200226T090000
DTSTAMP:20260502T025822
CREATED:20200220T155922Z
LAST-MODIFIED:20200229T164844Z
UID:10000106-1582704000-1582707600@skillbuilders.com
SUMMARY:How and Why to Upgrade to Oracle Database 19c - A Free Webinar
DESCRIPTION:REGISTER FOR THIS WEBINAR \nHow and Why to Upgrade to Oracle Database 19c\nUpgrading to Oracle Database Release 19c is now essential. Why? Support is expiring soon for all previous releases of the database. Consider this about prior releases:  \n\n12.1.0.2 – Support costs extra money and all support ends in the middle of 2022.\n12.2.0.1 –  All support ends in 2020. That’s it\, it’s all over later this year!\n18c – All support ends in 2021. That’s it\, no more support next year!\n\n \nConsider the ramifications of not upgrading: \n\nSupport is already expensive (22%)! Nobody wants to pay EXTRA money for Extended Support!\nImagine the cost of downtime because you can’t get a fix (patch) from support! \nConsider the uncertainty and potential disaster of being forced to upgrade your OS to an unsupported release (support includes certification against new releases of OS’)\n\n \nBut\, Oracle Database 19c extended support extends into year 2026! \n \nClick to learn how SkillBuilders’ consultants can help you with Oracle Database Upgrades! \nSo\, the reasons to upgrade are not just technical\, they are financial and compatibility driven too. If your databases are to run reliably and securely for the next few years it is time to upgrade. Now.\n \nIn this webinar you will learn: \n\nWhy to Upgrade:\n\nWhat the different levels of Oracle support (e.g. premier\, extended\, sustaining) provide\nCurrent support levels for recent Oracle Database releases\nThe available upgrade paths\n\n\nHow to Upgrade:\n\nSteps involved in doing an upgrade\nA bit about the “big” new features in 19c\nObsolete and deprecated features\nConsiderations for converting to Multitenant while upgrading\nOther miscellaneous but valuable pearls of wisdom about 19c\n\n\n\n \nDownload PDF of SkillBuilders 19c Upgrade Webinar\n \nIntended Audience is database administrators (DBA’s)\, Tech Management and anyone involved in the database upgrade decision making or the actual upgrade.  \nPresenters\nJohn Watson\, Oracle Certified Master DBA \nDave Anderson\, SkillBuilders Founder and DBA
URL:https://skillbuilders.com/webinar/how-and-why-to-upgrade-to-oracle-database-19c/
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20200116T080000
DTEND;TZID=America/New_York:20200116T090000
DTSTAMP:20260502T025822
CREATED:20200111T141356Z
LAST-MODIFIED:20200115T122601Z
UID:10000105-1579161600-1579165200@skillbuilders.com
SUMMARY:Free Webinar - Learn Oracle APEX 19.1 Forms
DESCRIPTION:REGISTER FOR THIS WEBINAR \n \nLearn Oracle APEX Release 19.1 New Features\nLearn how to harness the power of the APEX form region in Oracle APEX Release 19.1. Let APEX handle the sticky boilerplate transactional logic so you can focus on the important business logic.\n This webinar is intended for Novice APEX Developers.\n \n\nNew Form Region\n\nSimilar configuration to Interactive Grids\nEasy to generate form items!\n\n\nSupporting Processes\n\nInitialization – select\nRow Processing – insert/update/delete\n\n\nNew Maintain Session State Property\n\nIn memory vs disk\n\n\nCustomize form processing logic\n\nEasy to add custom logic\n\n\nRecord Locking\n\nOptimistic Vs Pessimistic\nHash vs Record Version ID\n\n\nProblems in 19.1\n\nUI Defaults will break form wizard\nSQLCODE and SQLERRM are not properly handled\n\n\n\nPresenters \nTyson Jouglet\, Certified APEX Expert and Lino Schildenfeld\, Oracle ACE \n \nREGISTER FOR THIS WEBINAR
URL:https://skillbuilders.com/webinar/apex-19-1-forms/
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20191121T070000
DTEND;TZID=America/New_York:20191121T080000
DTSTAMP:20260502T025822
CREATED:20191105T152442Z
LAST-MODIFIED:20220106T173848Z
UID:10000104-1574319600-1574323200@skillbuilders.com
SUMMARY:Install and Configure the Complete APEX Stack
DESCRIPTION:REGISTER FOR THIS WEBINAR \nThis webinar will demonstrate configuring an APEX environment on a Linux\nmachine: \n\nInstall APEX into a 19c database\nConfigure a Tomcat container\nDeploy ORDS to Tomcat\nCompile and install an Apache web listener\n\n  \nThis will be on a single machine\, but the method applies equally to\nmulti-tier environments. The starting point will be a machine with a\ndatabase installed and the software downloaded; the end point will be a\nfunctioning system ready for handing over to developers. \nAbout the Presenter\nJohn Watson has been working with Oracle Database for 25 years. He is an Oracle Certified Master DBA and the author of several of the Oracle Press Exam Guides. John is a practicing DBA\, consultant\, teacher\, mentor and SkillBuilders’ Director of Oracle Database Services.
URL:https://skillbuilders.com/webinar/install-and-configure-complete-apex-stack/
LOCATION:Online\, 213 Robinson Street Fl 2\, Wakefield\, RI\, 02879-3590\, United States
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20191119T070000
DTEND;TZID=America/New_York:20191119T080000
DTSTAMP:20260502T025822
CREATED:20190913T132143Z
LAST-MODIFIED:20191017T154227Z
UID:10000103-1574146800-1574150400@skillbuilders.com
SUMMARY:The Genius of Classic Reports
DESCRIPTION:REGISTER FOR THIS WEBINAR \nDid you mean to say Interactive Reports?\n\nNo!\nReports do not need to look like reports\n\nWhen to use Classic reports?\n\nVery simple or very complex reports\nCreating a custom tailored experience\n\nData Binding Magic\n\nColumn vs Row Templates\nHow to use templates successfully\n\nSome Gotchas with Row Templates\n\nSorting changes\nGetting clever with HTML Expressions\n\nThis webinar is being delivered in conjuction with ODTUG. \nThis webinar is intended for developers who have already built applications with APEX \nPresenters \nTyson Jouglet – Certified APEX Expert\nDavid Anderson
URL:https://skillbuilders.com/webinar/the-genius-of-classic-reports/
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20191029T080000
DTEND;TZID=America/New_York:20191029T090000
DTSTAMP:20260502T025822
CREATED:20190913T131339Z
LAST-MODIFIED:20191026T153849Z
UID:10000102-1572336000-1572339600@skillbuilders.com
SUMMARY:Universal Theme - Basic Principles to Modern Applications
DESCRIPTION:REGISTER FOR THIS WEBINAR \nHow difficult can it be to create modern and responsive app using Oracle APEX 18.x/19.x? \nIn this demo session we will build a public facing app following a few basic principles to demonstrate the power of UT. \nSimple but yet powerful CSS techniques can be daunting for back-end developers so this session is structured for all level audience encouraging you to explore and take on any CSS challenges ahead. \nWe will explore some of the under-utilized secrets of Universal Theme and learn about its gem CSS classes that can simplify your design asks. \nAimed at audience of all levels. \nThis webinar is being delivered in conjuction with ODTUG. \nPrizes\, prizes\, prizes!\nThree attendees will\, by answering a technical question correctly\, win a free seat in an online SkillBuilders APEX class.\nOne additional attendee will win a Free Year of APEX Cloud Hosting (again by answering a technical question correctly)!\nYou’ll learn the answers to the questions in the 1st half of the webinar\, so listen and watch closely! ODTUG’s Karin Gately will pick the winners! \nPresenters \nLino Schildenfeld – Oracle ACE\nTyson Jouglet – Certified APEX Expert\nDavid Anderson
URL:https://skillbuilders.com/webinar/universal-theme-basic-principles-to-modern-applications/
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20191008T080000
DTEND;TZID=America/New_York:20191008T090000
DTSTAMP:20260502T025822
CREATED:20190906T113940Z
LAST-MODIFIED:20190928T113542Z
UID:10000101-1570521600-1570525200@skillbuilders.com
SUMMARY:Universal Theme: Understanding Core Technology and Lesser-Known Features
DESCRIPTION:REGISTER FOR THIS WEBINAR \nThe Universal Theme provides a plethora of tools to quickly build sleek and responsive applications. For more complex applications\, you may want to either manipulate the page to perform certain actions or adjust the display. In this session we will explore custom responsive breakpoints\, the underlying CSS principles of UT known as BEM\, and the theme42 module for custom JavaScript components.” \n  \nUT: Universal Theme\n\nWhat UT does really well\nResponsive\, Gorgeous\, and Flexible\nHow do developers extend this functionality in a stable way?\nLinks to the helpful docs and shortcuts\nCore technologies and features\nMedia queries and custom col classes\nBEM: Block Element modifier and who to write reliable CSS\nthem42 JS module specific for theme42\n\n  \nUT: Understanding Technology\n\nMedia Queries and breakpoints\nHow APEX does this automatically\nHow to use col-X classes to override declarative positioning\n\n  \nUT: Understanding Technology Cont.\n\nBEM – Block Element Modifier\nHow do we write CSS today?\nHow do we write maintainable\, flexible\, and reusable css?\nCSS application order\nWhat is specificity?\nWhy is it CRITICALLY IMPORTANT to strive for a flat level of specificity?\n\n  \nUT: Uncharted Territory\n\nBrief overview of the JavaScript modules\ndemonstrating the theme42 module\ncomponent selectors: them42.PAGE_BODY\, them42.BODY_ACTIONS…\navoid hard coding classes and redefining your own constants that already exist\ntriggering component actions: theme42.toggleWidgets\nusing actions column as fluid extension of report/form\ninitializing message features: theme42.configureSuccessMessages\neasy entry point for configuring message behavior. More advanced options exist in apex.message\n\nThis webinar is intended for developers who have already built applications with APEX \nPresenters \nTyson Jouglet\nDavid Anderson \n 
URL:https://skillbuilders.com/webinar/universal-theme-understanding-core-technology-and-lesser-known-features/
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20190917T090000
DTEND;TZID=America/New_York:20190917T100000
DTSTAMP:20260502T025822
CREATED:20190829T121656Z
LAST-MODIFIED:20190918T150146Z
UID:10000100-1568710800-1568714400@skillbuilders.com
SUMMARY:Dynamic Actions for Super Heroes\, An Oracle APEX Webinar
DESCRIPTION:Regardless if you are new to APEX or have doubts about mastering your dynamic actions\, this is a session for you. We will demystify all corners of DA and how they can be utilized in your applications\, including: \n• How to create DA\n• Passing data between screen components and your DA\n• Event management and event bubbling\n• How to debug DA\n\nIf any of this sounds fuzzy\, join use for a 60-minute demo-loaded session\, where we learn how to make your applications come alive. \nThis webinar is intended for developers who have already built applications with APEX. \nPresenters \nLino Schildenfeld – Oracle ACE\nTyson Jouglet – Certified APEX Expert\nDavid Anderson \nDownloads \n\nSlide Presentations\nDemo App
URL:https://skillbuilders.com/webinar/dynamic-actions-for-oracle-apex-webinar/
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20181219T070000
DTEND;TZID=America/New_York:20181219T080000
DTSTAMP:20260502T025822
CREATED:20181206T125902Z
LAST-MODIFIED:20181208T151213Z
UID:10000099-1545202800-1545206400@skillbuilders.com
SUMMARY:Better Oracle Analytics with Advanced SQL Aggregations
DESCRIPTION:Learn Oracle Analytics with (advanced) SQL aggregations such as LISTAGG\, ROLLUP and CUBE! \nOur Oracle Advanced SQL Tutorial Series provides an in-depth look at Oracle’s Advanced SQL capabilities. Previous tutorials have reviewed features such as Analytic Functions\, Advanced Use of Oracle DECODE CASE PIVOT and UNPIVOT\, Advanced Use of Subqueries\, Adaptive Cursor Sharing\, Record Locking in APEX and other Connection Pooled Environments\, and a host of other topics.  \nThis session addresses Advanced Reporting of Aggregated Data Using Group Functions. It will cover the following major topics:\n• LISTAGG function to concatenate values of a column from multiple rows into a single output column in one row\n• ROLLUP extension to GROUP BY to automatically calculate subtotals and grand totals for a sorted report\n• CUBE extension to GROUP BY to automatically calculate subtotals and grand totals for all possible combinations of sorted data\n• Grouping Functions to enable proper labelling of subtotals\n• Grouping Functions with DECODE or CASE to label subtotals appropriately\n• Grouping Sets extension to GROUP BY to specify exactly which groups are to be subtotaled\n• Use FIRST and LAST to find the lowest and highest subtotal within a group total (e.g. display the average sales by region\, the average sales with the best credit level for that region\, and the average sales with the worst credit level for that region) \nPrerequisite: Basic knowledge of SQL GROUP BY \nPresenters\nGeoff Wiland\nTyson Jouglet\nDavid Anderson
URL:https://skillbuilders.com/webinar/advanced-reporting-aggregated-data-using-group-functions/
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20181128T070000
DTEND;TZID=America/New_York:20181128T080000
DTSTAMP:20260502T025822
CREATED:20181115T125150Z
LAST-MODIFIED:20181208T113055Z
UID:10000098-1543388400-1543392000@skillbuilders.com
SUMMARY:Learn REST Enabled SQL to Access a Remote Database
DESCRIPTION:Learn how to access a remote Oracle database with REST enabled SQL! SkillBuilders’ experts Tyson Jouglet and Garry Lawton will demonstrate the functionality of Oracle ORDS and APEX integration using REST Enabled SQL instead of a traditional DB Link (and the related hassles of DB links). We’ll also demonstrate Web Source Modules and how they are slightly different than REST Enabled SQL.\nTimes displayed are Eastern Time. \nTopics \n\nArchitecture of REST Enabled SQL\nCompare with Web Source Modules\nHow to Enable REST Enabled SQL\nDeclarative Usage in APEX\nDML and DDL over REST Enabled SQL\nProgrammatic Usage with APEX_EXEC\nAdhoc Query Region\nAuthentication – Schema and OAuth2\n\nPrerequisites:  This webinar is intended for developers who have already built applications with APEX. \nPresenters\nTyson Jouglet\nGarry Lawton\nDavid Anderson
URL:https://skillbuilders.com/webinar/rest-enabled-sql/
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20180510T080000
DTEND;TZID=America/New_York:20180510T100000
DTSTAMP:20260502T025822
CREATED:20180425T155802Z
LAST-MODIFIED:20180509T155526Z
UID:10000097-1525939200-1525946400@skillbuilders.com
SUMMARY:How to Create a Physical Standby Database
DESCRIPTION:Learn Oracle Data Guard! \nThis two hour webinar is an extract from our Data Guard course\, detailing the creation of a basic Physical Standby database. The demonstrations will go through the entire process\, starting from a pre-existing noarchivelog mode database and finishing with a Primary Standby configuration\, propagating and applying redo in real time. \nTime permitting\, we will look at some less commonly used facilities that let you gain real value from a Physical Standby\, beyond simple data protection. \nPrerequisites: Students should be a practicing Oracle Database Administrator. \nJohn Watson and Dave Anderson will present this session. \nRelated training: Oracle 12c Data Guard Administration Workshop \n\n \n 
URL:https://skillbuilders.com/webinar/create-physical-standby-database/
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20180412T090000
DTEND;TZID=America/New_York:20180412T100000
DTSTAMP:20260502T025822
CREATED:20180411T121306Z
LAST-MODIFIED:20180411T151823Z
UID:10000096-1523523600-1523527200@skillbuilders.com
SUMMARY:Oracle Tuning Webinar: Why Some SQLs Destroy the Performance of the Database (And techniques for fixing them)
DESCRIPTION:Why do some SQL constructs monopolize so much of the database resources? (destroy database performance) How can I fix / tune these terrible\, resource intensive SQLs?  \nOracle Certified Master DBA John Watson will demonstrate some of these with alternative structures that run faster and take stress off the database. Better execution plans and run-time statistics will be the proof. \nPresenters – Oracle Certified Master DBA John Watson and Dave Anderson
URL:https://skillbuilders.com/webinar/oracle-tuning-why-sqls-destroy-database-performance/
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20180215T080000
DTEND;TZID=America/New_York:20180215T090000
DTSTAMP:20260502T025822
CREATED:20180119T143601Z
LAST-MODIFIED:20180123T125116Z
UID:10000095-1518681600-1518685200@skillbuilders.com
SUMMARY:Record Locking in APEX and other Connection Pooled Environments
DESCRIPTION:We will cover the following major topics: \nThe Issue\n* Multi-user applications and data corruption\n* The LOST UPDATE problem\nPotential Solutions\n* Pessimistic Locking\n* Optimistic Locking\n* Pros and Cons of each\nDedicated Connection vs Connection Pooled Environments\n* Why Pessimistic Locking will not work in APEX and other Connection Pooled Environments\nOptimistic Locking Solutions\n* Two techniques that work\n* One technique that will not work\nCode examples of working techniques are demonstrated \n  \nPresenters \nGeoff Wiland \nDave Anderson \nTyson Jouglet
URL:https://skillbuilders.com/webinar/record-locking-apex-connection-pooled-environments/
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20180201T080000
DTEND;TZID=America/New_York:20180201T090000
DTSTAMP:20260502T025822
CREATED:20180118T223551Z
LAST-MODIFIED:20180203T145028Z
UID:10000094-1517472000-1517475600@skillbuilders.com
SUMMARY:PL/SQL and SQL Injection: Techniques to hack an Oracle Database (and how to block them)
DESCRIPTION:Prevent SQL Injection through PL/SQL! Secure your Oracle applications! \nOracle PL/SQL has the ability to run dynamically created SQL statements. Some developers find this useful\, some hackers find it even more useful. This webinar will demonstrate some commonly used techniques for injecting arbitrary SQLs into an application (hacking)\, with advice on how to detect and mitigate the vulnerabilities. \nPresenters – John Watson and Dave Anderson \nTHIS WEBINAR WAS RECORDED AND IS BEING EDITED FOR RELEASE AS A TUTORIAL. ATTENDEES WILL BE NOTIFIED VIA EMAIL. WE WILL ALSO ANNOUNCE AVAILABILITY VIA TWITTER. @SkillBuildersUS \n 
URL:https://skillbuilders.com/webinar/oracle-security-plsql-sql-injection-techniques/
ORGANIZER;CN="Gary Belke":MAILTO:gary@skillbuilders.com
END:VEVENT
END:VCALENDAR