#CodeOne Session: Let’s Talk AI, ML & DL

Date: Tuesday, 2019-Sep-17 6:00 PM
Location: Moscone South – Room 202
Session: DEV2161

Abstract: You hear everywhere that your job will be taken over by machines and that you need to be doing something else to be relevant. If the job involves making a decision based on a pattern or data analysis (radiology, for example), you can be sure that such a position will undergo a drastic transformation soon. Uber completed 10 billion rides in 2018, almost doubling the number of trips from 2017 to 2018. AI is used everywhere possible in Uber. Uber has changed your life and impacted millions of taxi drivers. This session goes over the basics of artificial intelligence, machine learning, and deep learning (DL) and discusses how these technologies impact you as a human being and as an IT pro. The future is bright; AI is a partnership, not a war.

The movies we watch usually portray intelligent machines being bad and set to destroy humans. Thanks to my colleagues who told me about the War Games movie. This one and the Terminator movie were released in the ’80s. AI is pure fiction in these movies, and give the notion that AI is something the humans must be scared of. AI has come a long way since the ’80s. Now AI is is part of our everyday life – We talk to “Siri”, ask “Alexa” to turn the light on or to play music.

The other aspect of AI is automation. They say the typical jobs that exist today will go away (like the DBA job). I think it is partly true – any job that involves repetitive tasks or analyzing images (radiology) will go through a transformation in the era of automation. That does not mean the job will go away. What you do may have to change.

AI and ML are going to play a major role in enterprises. To be successful and relevant, you must at least know the basics of AI & ML and understand how to use the AI/ML systems. If you are not familiar with Machine Learning, come to this introductory session to learn the basics, a few terminologies and most importantly what you can do to prepare yourself. Will share the job market trends and what is required to be a “Data Architect” or “Data Scientist”.

#OOW19 Session: It’s all in the presentation of data!

Date: Tuesday, 2019-SEP-17 11:15 AM
Location: Moscone West – Room 3020A
Room Setup: OPEN AIR – AUDIENCE HEADSETS
Session: CON2173

Abstract:
DBAs usually collect a lot of data and present it in a tabular format, but management and users like and understand visual representation of data better. The tabular format does not make the impact or get the attention you desire. Attend this session to see how easily you can convert those tabular formats to pictures using the free and open-source Google Charts. Google Charts is a pure JavaScript-based charting library to enhance web applications by adding interactive charting capability. This session includes two demos and is geared for DBAs, architects, and sysadmins who present data to end-users or management.

Though my abstract sounds this as a DBA specific session, it is not. Developers and end-users (even managers) who use SQL to get data from a database for reporting purposes will benefit from this session on using Google Charts. I first got a taste of Google Charts from EBD360 (Carlos Sierra) and SQLD360 (Mauro Pagano) tools. [Note: If you are DBA and not familiar with these tools, you must download the latest SQLDB360, which includes both tools]. The reports from these tools use Google charts extensively. Thought it would be hard to learn, and never tried until I saw a presentation by Kapil Goyal on Database Capacity planning. He used Google charts extensively. A short chat with him revealed that it is not hard to learn Google Charts if you can generate a dataset from the database to draw charts. He also graciously shared the db_capacity.sql script with me (thank you, Kapil).

So here we are, my session is about drawing pie charts, line charts, bar charts, etc using Google charts. The SQL templates I provide can be used to generate your own HTML reports. The ZIP file you download from OOW Session Catalog will include the session slides as well as the template files. See you on Sep 17th @ 11:15 AM #OOW19

SQL*Plus HTML Formatting Attributes

SQL Data embedded in HTML file