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 220.127.116.11 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 18.104.22.168 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.
Speaker: Mark Drake, Oracle
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