Roel Hartman is another speaker at #MALAGAPEX18 with more than one session. In this blog entry, we presented his session A Deep Dive into APEX JET Charts. 

Today, we want to highlit the session titled as Top Ten Tweaks for the Interactive Grid.

The Interactive Grid is introduced in APEX 5.1 as a best of both worlds of Tabular Forms and Interactive Reports. Although a lot of settings are declaratively available within the APEX builder, there are a ton of features built in that are only accessible by JavaScript. In this session, you will learn how to use the most interesting “hidden” features with just a few lines of JavaScript.

Some examples:

• Adding and removing buttons from the Interactive Grid toolbar.
• Adding and removing actions from the toolbar menu.
• Adding and removing functionality from the row level pop up menu.
• Removing complexity on the column level.
• Adding tooltips to a column.
• Changing the layout of columns and headings.
• Updating multiple records at once.
• Refreshing (only) changed records within the grid.
• Removing only deleted records from the grid – without a full refresh.

Something else you must know is that Roel is a very active user at twitter, so feel free to follow his account at @RoelH, and remember to check out our own twitter channel at @malagAPEX to get the latest news about the #MALAGAPEX18!

For this edition of #MALAGAPEX18, there are some speakers who will be sharing more than one session with us. One of them is Richard Martens. We spoke about another of his talks in this blog entry regarding (how to) Validate User input with Oracle APEX.

However, he’ll have another talk titled “Restful services and Remote SQL in Oracle” and as we know you like to know a bit more than the title, here are some more details:

Apex 5.2 offers the “remote SQL” feature, a way to use RESTfull services straight from APEX. The presentation will show how to consume RESTfull services using HTTP(s), GET, PUT and POST, not only to ORDS (remote SQL) enabled services but also from MySQL or Postgres databases…

There is still one more session from Richard (he’s going to be very busy), so don’t forget to stay tuned to our Twitter account (@malagapex) to get the latest updates about #MALAGAPEX18. And if you haven’t done so yet, go to this link to get your tickets!

Richard’s Twitter handle is: @rhjmartens 

We also have speakers from the house, and today we’re more than pleased with talking about Trond Enstad.

Trond is a Norwegian Entrepreneur and technical IT consultant, working in performance analyst and very well known troubleshooter. Trainer, mentor and public speaker, Oracle DBA – operations, development and engineering, Infrastructure – planning, sizing and engineering, Nearshoring/offshoring, ITIL, Multilingual and facilitator, with more than 25 years of technical experience in IT industry. Owner and CEO of OracleTuningGuy.com and novoshore.com.

Regarding his presentation, Oracle APEX & NodeJS – a match made in heaven, here is a quick summary:

Live build session of backend server stats collection agent and apex front end in 40 minutes. Backend agent build with NodeJS (javascript) using Oracle’s NodeJS driver to insert stats into remote db. Front end is build with Oracle APEX, OracleJET and timer plugin.

Integrating this type of services adds a great value to our apps, so you better put an eye on this session to get a bigger picture of what you can do with APEX. If you don’t have your tickets yet, follow this link and get ready for this session! Follow Trond at his twitter account (@OracleTuningGuy), follow our own Twitter account to stay tuned (@malagAPEX) and keep the track of the hash #MALAGAPEX18!

We wanted to talk today about Geertjan Wielenga, a very brave Oracle member coming to #MALAGAPEX18 without any slides…

Geertjan is an Oracle Senior Principal Product Manager for Oracle JET, Oracle’s JavaScript strategy for enterprise Mobile and Web development, based at The Netherlands. Writer, speaker, and trainer active in the software industry with a proven and consistent track record since 1996

He decided to submit an abstract titled “Oracle JET: No Slides, Just Code!“. Bellow, you can find a small peak about his talk:

What’s Oracle JET? JET is the JavaScript Extension Toolkit, which is Oracle’s official enterprise JavaScript solution. It is used throughout Oracle as the frontend user interface technology for all modern Cloud products, while it is also Oracle’s strategy for extending Oracle products, such as Oracle Sales Cloud, Oracle HCM Cloud, and more.

In this session, see how everything fits together, without slides, just code!

We think this one is a great opportunity to learn more about this Oracle resource from one of the people in charge of this powerful tool. Stop thinking now, go to the ticket’s platform, and get ready for this session! Don’t forget to follow Geertjan at his Twitter account (@GeertjanW), and remember to check out our own Twitter channel at @malagAPEX to get the latest news about the #MALAGAPEX18!

You still have some more hours to get your Early-Bird tickets today, so that’s why we’ve chosen today for sharing the Agenda for #malagAPEX18!!

We haven’t filled all the gaps yet, but we want to let you know about most of the sessions and the great quality of speakers driving those talks. We’ll be linking these entries as soon as we publish the corresponding abstract’s entry with more details, so feel free to check this post in the future to get the full picture!

Day 1

Day 2

Feel free to comment to us how much do you like this conference agenda!! We’re so happy of having such great speakers, and we really want to make this initiative of spreading Oracle technologies, specially APEX, here in Spain!

Today, we want to present the session by Andrzej Nowakowski titled: “Natural Language – modern user interface”. But let’s learn a bit more about Andrzej first.

He’s an Oracle APEX integration developer with over 13 years of experience. Developer and moderator of the polish APEX Forum forumapex.dbe.pl. Blogger (apex.dbe.pl, apexutil.bloger.com). Founder www.apexutil.com, www.dbe.pl, www.apex-designers.com

Regarding his presentation, Natural Language – modern user interface, here is a quick summary:

Developers since decades have used the same types of data input components like text fields, select lists, date pickers, etc. Although the style of interfaces is changing (other colors, other shapes or total other design styles),  they are still standard components. If the application must interact with public users or end users that can’t use a keyboard, a better solution is to use more natural interface. Until very recently, there wasn’t any alternative to standard GUIs. But this has now changed and you can build applications with modern, natural interfaces. One of the most popular interfaces is the voice recognition from Amazon… called –  Alexa. With Alexa, you can build natural voice applications that offer users a more intuitive way to use.

In this presentation, we will build a real-world APEX application to order Pizza via the voice interface. To build this solution we will only use APEX with ORDS and Alexa Kit.

You shouldn’t be missing such a great opportunity to integrate Alexa and APEX. That’s why you have to follow our Twitter account (@malagAPEX) and keep the track of the hash #MALAGAPEX18!

As we continue talking about our speakers, we want to focus today’s post on Niall McPilips.

Niall has been developing using Oracle since Oracle V5. He has been using Oracle PL/SQL Web technologies since 1995 and Oracle APEX since 2005.  Niall has developed a number of large, multi-lingual applications for multinational companies and organizations all over the world.  Several of these receives tens of millions of page views per year.  Niall is a strong believer in APEX solutions because of their stability, scalability, and rapid development speed.  Niall is also the organizer of the Swiss APEX Meetup group.

For #malagapex18, he has submitted an abstract titled “Building a large Image library using APEX”. Here you can find a quick summary of his talk:

This case study will describe the approach and challenges faced when overhauling a 14-year old image library of over 40’000 photos. The new version was developed using Oracle APEX 5.1, Oracle Multimedia, Oracle Text and PL/SQL. Issues addressed include automatic extraction of image metadata to facilitate searches and image description, automatic resizing of images using Oracle Multimedia, customization of APEX reports to produce a modern presentation format for the photo library.

We really look forward to attending Nial’s presentation. Meanwhile, you can follow his Twitter account @Niall_McP, and don’t forget to stay tuned to our Twitter account (@malagAPEX) to get the latest news on #MALAGAPEX18!

Here we have a new blog entry about another of our great speakers. In this post, we’d like to talk about an Oracle ACE Director and European Oracle User Group Ambassador: Heli Helskyaho.

She is the CEO of Miracle Finland Oy and an Ambassador for EOUC (EMEA Oracle Users Group Community). Heli holds a Master’s degree (Computer Science) from the University of Helsinki and she has specialized in databases. At the moment she is working on her doctoral studies, researching and teaching at the University of Helsinki. Her research areas cover Big Data, multi-model databases, schema discovery and methods and tools for utilizing semi-structured data for decision making.
Heli has been working in IT since 1990. She has held several positions but every role has always included databases and database design. Heli believes that good database design and good documentation reduces performance problems and makes solving them easier and we do not disagree with this. A great APEX application starts with a great database design.

Appart of being an Oracle ACE Director and a very frequent speaker at many conferences, she is the author of Oracle SQL Developer Data Modeler for Database Design Mastery (Oracle Press 2015) and a co-author of Real World SQL and PL/SQL: Advice from the Experts (Oracle Press 2016).

Having such a great background, we had to ask Heli for more than one session. However, today we’ll be highlighting only one of those sessions, titled: “Design your databases straight to the Cloud”. Here follows a sneak peek on this session:

Everybody is talking about Cloud. How does the Cloud change my work as a database designer? What should I know and what new to learn? In this session, we will talk about these concerns and design a small database to the cloud using Oracle SQL Developer Data Modeler and Oracle SQL Developer.

You can check her Twitter account at @HeliFromFinland. She’s very active, and always sharing interesting content with the community. Stay tuned to our Twitter account (@malagAPEX) to get the latest news about #MALAGAPEX18!

Today, we’ll put our focus on Roel Hartman, to learn a bit about his background and the talks he’ll drive at #MALAGAPEX18, the upcoming 31st of May and 1st of June.

He started a long time ago using Oracle RDBMS 5, Oracle Forms 2.3, RPT/RPF and Oracle*Case 4.5. Since a few years, he has been focussing mainly on Oracle Application Express. Roel has been a speaker on UKOUG, OOW, Collaborate, ODTUG’s KSCOPE and a number of local Oracle User Groups. Within ODTUG he acted as the APEX Content Lead for the Kscope14 and KScope15 conferences and is a member of the Board of Directors. He keeps an (APEX-related) blog on http://roelhartman.blogspot.com. In June 2009 Roel received an Oracle ACE award and in August 2010 he was appointed Oracle ACE Director. Roel was a co-writer of the “Expert Oracle Application Express” and “Oracle Application Express for Mobile Web Applications” books. Roel is Director at APEX Consulting in The Netherlands.

Today, we want to highlit one of the sessions from Roel, titled as A Deep Dive into APEX JET Charts.

In this session, we will take a closer look at the options the new JET Charting engine brings to the APEX world. There are a quite a lot of declarative options to explore, but also the JavaScript API is worthwhile investigating. You will learn that with just a few lines of JavaScript you can change the look and feel of a chart to impress your boss.

Outline:

• What is Oracle JET.
• Declarative JET integration in APEX.
• Modify the JET charts using Dynamic Actions and a few snippets of JavaScript.
• Use other JET components in APEX.
• Building an APEX plugin for a JET component

Something else you must know is that Roel is a very active user at twitter, so feel free to follow his account at @RoelH, and remember to check our own twitter channel at @malagAPEX to get the latest news about the #MALAGAPEX18!

In this post, we’d like to present you to the one and only dancing ((#ougn18)) APEX developer Alex Nuijten.

This very well known speaker, awarded the Oracle ACE Director membership back in August 2010, is an independent consultant (allAPEX), specializing in Oracle database development with PL/SQL and Oracle Application Express (APEX) and Alex is a member of the Smart4APEX team. Besides his consultancy work, he conducts training classes, mainly in APEX, SQL and PL/SQL. Alex has been a speaker at numerous international conferences, such as ODTUG, Oracle Open World, UKOUG, IOUG, OUGF, BGOUG, OGH APEX World and OBUG. For his presentations, Alex received several Best Speaker awards. He wrote many articles in Oracle related magazines, and at regular intervals, he writes about Oracle Application Express and Oracle database development in his blog “Notes on Oracle” (nuijten.blogspot.com). Alex is also a co-author of the following books “Oracle APEX Best Practices” (published by Packt Publishers) and “Real World SQL and PL/SQL” (published by Oracle Press).

For #MALAGAPEX18, he’ll be talking about Structuring an APEX application. Here are the details:

Creating beautiful applications with APEX is easy, especially after the introduction of Universal Theme. It is easy to follow the wizards and drop SQL and PL/SQL all over the place in your application thereby creating a maintenance nightmare. When a table is changed, which pages are affected? How can you easily find out? Getting the structure of your application right requires a method to follow. In this session, I will share my thoughts on structuring your APEX application. This session will focus on just that: build robust applications; leverage views, packages, instrumentation, etc.

If you don’t want to miss anything of what Alex has to say, don’t forget to follow his Twitter account at @alexnuijten. For sure, you all will enjoy the talks of this dancing APEX developer.

Don’t forget to stay tuned to our Twitter account (@malagAPEX) to get the latest news about #MALAGAPEX18!