Pre-Conference Workshops

    On Sunday, April 22, 2018, IOUG offers an extra, comprehensive day of Oracle training complimentary for IOUG Forum attendees. Select which pre-conference workshop you wish to attend during registration. Space is limited! 

    Oracle Hands-On Labs

    Hands-On LabWorking with Managed Relational Databases in the Cloud

    Python and Oracle Database: Scripting for the Future

    Speaker: Blaine Carter, Oracle

    Get hands-on and learn the features of the Python cx_Oracle interface for Oracle Database.  Learn efficient techniques for connection management and statement handling and more. If you want to use Python and Oracle Database, this session is for you.  Basic programming skills in any language are required.

    9:00 a.m. - 10:00 a.m.

    Upgrade and Migrate to Oracle Database 18

    Speaker: Roy Swonger, Oracle

    In this hands-on lab, you will first upgrade a database from to RELEASE 18. Then you will convert this database to a pluggable database (PDB) and plug it into a multitenant container database (CDB). Finally, you will migrate a second database directly into a RELEASE 18 PDB using the new 12c Full Transportable Export/Import feature. This is a great way to get hands-on experience with different upgrade and migration methods, all under the tutelage of Oracle's database upgrade  team -- not to mention a look at Release 18 of Oracle Database!

    10:30 a.m. - 11:30 a.m.

    Identifying Securty Risk with the Database Security Assessment Tool (DBSAT)

    Speaker: Russ Lowenthal, Oracle

    With the growing number of data breaches every day and the stringent regulatory landscape, safeguarding sensitive information has become critical. As part of Oracle’s defense in depth strategy, the Oracle Database Security Assessment Tool (DBSAT) helps identify areas of risk and recommends changes to mitigate those configuration, operational and technical risks. Attend this hands-on lab and learn how to easily run DBSAT to identify your exposure to the top database security risks and how to remediate them. You will also learn how to analyze the different risk findings identified within the security reports, and prioritize them, so that you are well on your path to securing your databases. DBSAT is the place to start!

    12:30 p.m. - 1:30 p.m.

    Oracle Big Data SQL: Analyze Data Across Oracle Database, Hadoop and Kafka

    Speaker: Marty Gubar, Oracle

    Organizations are capturing data in a variety of data stores including Oracle Database, Kafka, and Hadoop. Oracle Big Data SQL allows you to use Oracle SQL and security policies to seamlessly query across these stores. This means that existing Oracle Database query applications—without changes—will now be able to take advantage of this new information. This hands-on lab introduces you to how this is achieved: providing access to big data sources, implementing unified security, and delivering analyses that combine and correlate all data.

    2:00 p.m. - 3:00 p.m.

    Using JavaScript Object Notation in Oracle Database 12c

    Speaker: Mark Drake, Oracle

    The schemaless nature of JavaScript Object Notation (JSON) has enabled it to become an extremely popular method for persisting application data. Oracle Database 12c provides end-to-end support for JSON data: the database can store, index, and query JSON content in a highly performant manner. In addition to providing flexible SQL access to JSON data, Oracle Database also fully supports the schemaless development paradigm in which applications can be built using simple document-store APIs. This hands-on lab provides an introduction to the JSON-related features of Oracle Database 12c.

    3:30 p.m. - 4:30 p.m.

    Working with Managed Relational Databases in the Cloud

    Speaker: Michael Barras, Amazon Web Services

    Spend the day working hands-on with Amazon Relational Database Service (RDS) for Oracle, a managed cloud database from AWS. AWS engineers will guide you though setting up, configuring and accessing Oracle databases. They'll discuss what makes RDS unique and how it helps database administrators stop worrying about infastructure and focus on high-value database tasks. No prior cloud experience necessary. Walk away with a deeper understanding of running Oracle databases in the cloud, and confidence in your ability to quickly provision databases for scalability, high availablity and reliability. 

    1:00 p.m. - 5:00 p.m.

    Oracle Cloud Journey Hands-On Lab

    Speakers: Tariq Farooq, Brain Surface; Erik Brenner, Mythics; Kai Yu, Dell EMC; Charles Kim, Viscosity North America

    Full day event sponsored by the Oracle Cloud SIG and IOUG. An Oracle User Community Cloud SIG series of Hands On Lab (HOL) Activities for Oracle Technology Professionals to obtain Cloud experience using Oracle Public Cloud and Oracle Technologies together using their own laptop/device to accomplish work essential for their businesses & careers. Attendees learn how to setup OCI/Networking, OS secure authentication, Generate a key, Spin VMs, Create a storage container to use the Cloud and spin an Oracle Database as a Service (DBaaS) Instance. Methods of Oracle database backup to the Cloud, configuring RMAN to backup to Oracle Cloud will also be covered. This year’s workshop expands into Oracle Monitoring technology that monitoring BOTH the Infrastructure and User Experience using Oracle Management Cloud (OMC). Learn how the Oracle Management (OMC) Cloud Application Performance Monitoring technology is deployed, with each attendee getting hands on experience deploying the technology on a WebLogic sever, and learn how troubleshooting is accelerated. Attendees to this workshop bring their own device, connect over WiFi, are assigned an Oracle Cloud trial account and are lead through activities by IOUG Cloud SIG leaders.

    Breakdown of Oracle Cloud Journey HOL Sessions:

    • Networking/OCI in the Oracle Cloud – 10:00am – 11:30am
    • How to build Oracle Cloud VMs – 11:30am – 1:30pm (30 minute lunch break)
    • Oracle Database as a Service (DBaaS) – 1:30pm – 3:00pm
    • Management and Troubleshooting with Oracle Management Cloud (OMC) – 3:00pm – 4:30pm






    Copyright © 2019 . All Rights Reserved
    All material, files, logos and trademarks within this site are properties of their respective organizations.
    Terms of Service - Privacy Policy - Contact

    Terms of Service Privacy Policy Contact

    Copyright ©2019 All Rights Reserved
    All material, files, logos and trademarks within this site are properties of their respective organizations.