Showing posts with label Training. Show all posts
Showing posts with label Training. Show all posts

Tuesday, 26 November 2019

On the PL/SQL you don't write when using APEX.

Fancy joining in on a discussion with PL/SQL and Oracle APEX community members from around the world?

I'm honoured join Karen Cannell and Scott Spendolini, to be hosted by Steven Feuerstein in the next AskTom PL/SQL Office Hours on December 3, 2019.

It seems a few people haven't heard of these "office hours" sessions, but they're worth a go - more than just your average webinar. And they're all recorded for later viewing.

Topic
This is just the PL/SQL sessions! Every month they have one for Oracle APEX, SQL, Spatial, JavaScript, JSON, Database Security, and even more.

Product segments

It's probably one of the richest learning resources Oracle currently produces, and I really need to tap into more of it.

If the timezone gods allow it, I recommend live participation, as you really do get your questions answered. The produce managers handle the chatline, ensuring questions get followed through.

I think Steven's ensuring we have a good 15 minutes for questions, because they always come through. They keep the chat transcripts, too. The one for Oracle Forms Modernisation was all about the questions!

And it's free - you only need to sacrifice your email address, though it's probably the best email feed I have. Concise, infrequent, except my forum feed, of course.

On December 3, in my 15 minutes of fame, I plan to (spark debate?) about "the PL/SQL you don't need to write". I delivered this as an APEX application, instead of whipping out the ol' powerpoint.

Join in next week, and Karen will start with some decent habits, and the other Scott will no doubt enlighten us about security, or some such.

Free training - from Oracle... well, in this case, delegated to some passionate volunteers. ;p

Friday, 15 April 2016

Training: jQuery and Dynamic Actions in APEX

Sage Computing Services are happy to announce a new 2 day course for Oracle APEX developers.

jQuery and Dynamic Actions in APEX

This course is designed for APEX developers who know their way around the APEX builder but want to build more interactive & user friendly applications that are also suitable for touch devices.

Upon completion attendees will have a great understanding of the communication between the browser and the database, using dynamic actions effectively and including jQuery suitable for database developers.

Prerequisites


Attendees are expected to be reasonably familiar within the APEX development environment.
Experience with APEX 5.0 is an advantage but not essential.

All but two exercises are independent of APEX version, so while the course will be taught on 5.0, you can transfer your new skills to 4.x.

Understanding of CSS & jQuery is not required. Attendees will be taught how this syntax is used from a database developer's perspective.

Register Interest


We will schedule a course in the Perth CBD prior to financial year end (June 2016), date to be announced. More course details are available here.

Please contact me (Scott at  sagecomputing.com.au) or Tweet/PM me @swesley_perth to register your interest.

If you're based in another Australian capital city and have a group of 4 or more, we can come to you. If you're in the Asia & Pacific region, I'm sure we could work something out with any of the courses from our catalogue. I'd love to make new friends in our region.

Scott.

Wednesday, 22 July 2015

Perth - Free 1/2 day Education Event

Thanks to Sage Computing Services, AUSOUG are hosting a free 1/2 day education event for it's members.

Join us Wednesday 19th August, 2015 at the Duxton Hotel from 2:30pm to be regaled with tales of tuning, APEX, SQL and PL/SQL.

  • Penny - Practical Tuning Tips for Developers
  • Kylie - Snazzy SQL: Titbits to advance your code
  • Katie - PL/SQL: Are you making the most of it?
  • Scott - APEX 5 isn't just a sexy new IDE 

Full details here, but we'll make sure it's a fun afternoon :)

Tuesday, 8 October 2013

Advert: SAGE APEX 4.2 course

SAGE Computing
Attention Perth residents - and perhaps those interstate...

SAGE Computing are holding a 4 day Oracle Application 4.2 course from the 28th October, 2013.

Please contact me or Penny if you're interested in attending.

Scott.

Thursday, 30 May 2013

Oracle APEX Techniques - Video Course

Little pig, little pig...I'm happy to finally announce a project this little green pig was assisting me with last year - a video series on Oracle Application Express techniques, published thanks to Packt Publishing.
http://www.packtpub.com/content/oracle-apex-techniques/video

The course targets new to intermediate APEX developers who have a general understanding of SQL and PL/SQL, and is based on APEX 4.2.

The course is 8 sections of 5 videos, each about 3-4 minutes each. The videos are screencasts from my laptop, with my voice describing what's happening on screen - very similar to a webinar.

Check out this sample clip looking at Interactive Reports detail view.

After having read a number of technical books and heard from other authors regarding the work involved, I can certainly say it was an interesting project to be involved with. I would love to include many other techniques I've acquired over the past six months in addition to the wealth of information that's out there - but we only had a limited number of minutes available - they sure add up quickly!

So if you're starting to learn Oracle Application Express; or you've been using it for a while and you're wondering if you've missed anything useful - you might like to consider this video series. I hope you find it valuable.

Oracle APEX Techniques
Oracle APEX Techniques
Cheers,

Scott

Wednesday, 31 October 2012

OTDUG Australia / NZ APEX training

ODTUG APEX event training details

If you didn't get enough APEX at the Perth conference, then thanks to ODTUG and AUSOUG, you can supplement it further by welcoming ACE Director Martin D'Souza and Oracle Application Express Product Manager David Peake to Australia and New Zealand.

They will dive deep into the APEX world, including a hands-on lab.

  • Auckland - November 5-6, 2012
  • Melbourne - November 8-9, 2012

Further details can be found here: http://www.odtugapextraining.com/AU.html

I'll be attending the Melbourne event - I might see you there!

Scott

Monday, 9 January 2012

First events of 2012

Today is the true new year for many, and Sage Computing Services would like to announce it's first training event for the year open for enrolment.

JDeveloper Workshop
27th February to 2nd March
Perth CBD
Taught by Oracle Ace & Educator of the year - Penny Cookson
Workshop details

If you can't make that, keep the morning of the 29th Feb free. If things haven't changed on me over the new year, AUSOUG will be sending out details of a breakfast at the West Perth Oracle building by one of our favourites - Connor McDonald.

If you're interested in any of our courses, feel free to drop us a line and we can schedule a time frame that suits you.

Scott

Saturday, 8 October 2011

Advert: Sage Training for Apex & PL/SQL

Hello to all from Perth, Australia (and beyond if you like)

Sage Computing Services have just scheduled two courses for November:

Oracle Apex 4 Workshop => 9-11th November
PL/SQL Workshop => 21-23 November

Both will be held in the Perth CBD, please e-mail us if you're interested in further details.

Cheers!

Scott

ps - we don't often put on PL/SQL training here in Perth - get in while you can!

Tuesday, 5 July 2011

Learning SQL?

Sometimes I hit the "Explore" link in Google Reader, I encounter some interesting an amusing things - kinda like using iTunes Genius but for web pages that suit your RSS interests.

I stumbled across this blog listing free SQL books - as he says, not all of them Oracle, but worth a look.
http://newappsdba.blogspot.com/2011/06/free-sql-e-books.html

I thought the OracleXE tutorial was well constructed - great for beginners trying to tinker with a locally installed Oracle database.

Not too long ago I created a small document detailing the installation process and basic configuration for OracleXE 11g Beta on a Windows box, which can be found here. I just hadn't got around to publishing it in any form.

If I can convince my laptop to open an EPUB file, I might even be able to comment on the SQL Performance Explained e-book. (nope, while writing this I tried a few avenues, but my patience has been lost)

Scott

Monday, 20 June 2011

A mash of Oracle related thoughts

It's been almost a month since my last confession. I have plenty I want to say!

Australian Oracle User Group
As usual, there is various activity going on around the country.

July 14 2011 there is a one day Northern Region Conference at Jupiters Townsville. Kudos to Mark Lancaster et al for that one. It's a shame I can't be there.

August 16-17 2011 is this year's InSync conference. My paper has been accepted so I look forward to seeing & meeting old & new members of the Oracle community from around Australia and the world. This will be the largest Oracle event I've been to so far.

August 18 2011 there will be a Day or Real World Performance with Tom Kyte, Andrew Holdsworth & Graham Norwood. This has recently been announced and looks very attractive. I'll be looking out for more details on this - a similar event was recently at UK-OUG.

November 3-4 2011 will be my hometown's conference - Oracle with 20:20 Foresight, of which this year I have taken the reigns from Penny Cookson as the Program Chair. It will be an interesting and challenging task, and I look forward to what should be an even better event than last year. The call for papers is now open, so get your submissions in by August 10th.

In between all these events will be the regular branch meetings where you can catch a local presenter talking about anything Oracle. Aussie Oracle technologists - get in there!

And if you're not from Australia, I hope this isn't the only sort of plane that will get you here (think volcanic ash...)

So when you sit down to write or update your presentation, keep an eye out for tips such as these to create something outside the square.

Keep Yourself in the Loop
Oh so tempting to throw a PL/SQL pun in there, but I'll leave this the exception.
Steven Feuerstein and his team have been doing such a great job moving forward with the PL/SQL Challenge website, it's now in version 2.0.
In addition to a daily PL/SQL quiz, Steven has now launched a weekly SQL quiz and a weekly Apex quiz.

Now you don't have to play competitively or publicly rank yourself amongst the few thousand active players - but it is a great place to spend 5-10 minutes every day testing yourself on your general knowledge of Oracle technology. When I was first learning Oracle I spent a fair bit of time at asktom.oracle.com, this is another location you should bookmark and visit regularly. And on top of all this, Steven has given away almost US$30k in prizes - and it's not just for the winners. Granted, US$30K just isn't the same as AUD$30k these days, but it's worth the effort ;-)

And more kudos to Aussies Gary Myers and Jeff Kemp for ranking highly in the recent quarterly playoffs.

Oracle Training
What has been keeping my working life busy recently - in between the regular consulting - has been the influx of training request around the country. I only hope that planes will be flying regularly once the volcanic ash has settled down, otherwise I might have some disappointed customers!

It's end of financial year time, and it's great that so many companies out there want to keep their team skilled. I've been keeping our Apex notes up to date with all things Apex 4.0; our own Oracle Ace Director Chris Muir has been hitting it hard with numerous JDeveloper ADF workshops; plus we have our regular SQL training to keep your queries sharp, amongst our other courses.

If you're on the lookout for exceptional Oracle training, hit up Sage's website.

My Blog Layout
While nothing has changed yet, I plan to give this site a little revamp and bring it into 2011. I've learnt a few things along the blogging path, so keep an eye out for additions such as Google +1. It's such an interesting concept, and I'll be keeping an eye out to see where it goes down the rabbit hole. I read an interesting analysis at Phandroid, and webmasters can learn more about it at Google.
I also want to make it a little less clunky & boring and perhaps show that I have some of my sister's graphic design genes.

I'm even tempted to go Apex.

Around the Oracle Community
There have been a number of great posts by Oracle bloggers recently that I'd like to share if you haven't seen them already, or in case you missed them.
  • Eddie Awad shared a short video by Tom Kyte talking about Oracle. It's good to see the occasional video instead of faceless text - it's just a shame our Australian networks just don't make it easy to see this content smoothly on our smartphones.
  • Speaking of mobiles, Peter Raganitsch has been talking about theming on Apex for mobile devices.
  • Apex 4.1 is moving forward, and one of the features I'm looking forward to working with is the Error Handling Improvements. If you haven't upgraded from Apex 3.x, why not?!
  • Plug-ins is one area that I really need to catch up on, experts like Dan McGhan are doing all sorts of crazy work with Apex Plug-ins, demonstrating Apex as the flexible tool it is.
  • And if you haven't heard or have forgotten, Oracle XE 11g has been released in beta. The world keeps on spinning
An Apex Book Everyone Must Have
And I simply can't go by without mentioning the latest Apress book Expert Oracle Application Express.
I had the wonderful opportunity of being a technical reviewer for this book, and it's simply stunning. You might see my ugly mug somewhere in the first few pages.
Not only that, as you've probably heard, proceeds of this book help support the families of Carl Backstom and Scott Spadafore.
Keep an eye out for other Apress books that are in the works, too. I have a feeling there are a few other good ones on the way ;-)

Now, back to the business of real(ish) work. I should be back to more regular postings from July.

ScottWe.

Tuesday, 3 May 2011

Oracle Training Australia (plug)

As it so happens, June is going to be a busy month training for us in Perth, Australia.

For 5 days from the 13th June, ACE Director Chris Muir will be conducting a JDeveloper Workshop in Perth. If you're an Oracle Forms developer who wants to migrate your skill set to the 21st century, this is your course.

Alternatively, you can immerse yourself in the world of Oracle Application Express. From 15th June for 3 days, I will take you on an Application Express workshop - no experience necessary.

To supplement that, we are also holding an Advanced Application Express & New Features workshop for Apex 4.0 on the 28-30th June 2011 in West Perth.

Feel free to contact that Sage team for more information.

If you're somewhere in Australia other than Perth, and you can't make it across in June - arrange a time where we can travel to you to train your team. SQL, JDeveloper, Apex, Forms, DB Tuning... name your poison. We have competitive rates, extensive training notes, and I'll almost guarantee you'll have a good time.

Otherwise, we hope to see you at the next Oracle event.

Scott

Tuesday, 1 March 2011

Advert: SAGE Computing Services Training - 2011

This April SAGE Computing Services are holding a training event that may interest beginners, business users, testers & developers alike.

April 18th-21st 2011 - Oracle SQL 10/11g Workshop - Perth
The course is designed to provide the student with a basis for developing systems using the Oracle database. The SQL language is covered from simple to complex constructs. Guidelines are provided on writing SQL for optimum performance and ease of maintenance.

Stay tuned as we are also looking to schedule a JDeveloper Workshop in the next few months, and are happy to hear about any requests for Application Express 3.x or 4.0 training.

We also arrange on-site training on-demand around Australia.

Hit up our website for further training enquiries and follow through to the contact us details page. We look forward to hearing from you soon.

Thursday, 18 November 2010

Advert: SAGE Computing Services Training - Apex 4.0 Workshops

SAGE Computing Services are featuring two training workshops early next month, not long after the AUSOUG conference.

December 6th - Oracle Application Express 4.0 New Features Workshop
This 
course is designed to familiarize current Application Express developers with the exciting new features in Apex 4.0. Topics will include the changes in the interface, new client events, tabular form enhancements, web sheets and team development.

December 8th - 10th - Application Express 4.0 Workshop
If you're looking to get involved with 
Apex, this course provide you with the skills and knowledge required to develop a complete application with the latest release of Oracle’s Application Express 4.0 product. You will develop web interfaces including forms, reports and charts, add validation and customise the formatting to create a small application.

Visit our training web page for more information about our extensive course catalogue. Follow through to the contact us details page. We look forward to hearing from you soon.

Scott Wesley & the team at SAGE Computing Services.
I'm sure Penny, Eddie, Kate, Chris, Branka, Kylie & Ray would like you all to enjoy summer (or winter/wet/dry), and have a great new year!


Final days before the 2010 AUSOUG conference

This blog has been a little neglected as I've been a busy little bee recently, mainly fretting about getting my presentation completed for next week's Australian Oracle User Group Conference - AUSOUG 2020. I have plenty of ideas lined up for post topics, so I should be more active come the next few weeks.

As for the conference, SAGE Computing Services (my employer) will have an exhibition booth, so why don't you come by and say hello to our team. We will have a few things to give away plus some prizes to win - but make sure you bring your thinking caps because we're going to make you work for them!

I'll be joining the rest of the user group committee in Burswood on Sunday night just to make sure everything is good to go - including perhaps that I did the right thing setting up for a wide-screen projector. We should have a good turn out, although humbling in comparison to some of the overseas gigs, I hear.

Some of us are scheduled to present:
  • Penny Cookson - Meet the CBO in Version 11g
    • 11:30am 22nd Nov 2010
  • Scott Wesley - 'n' methods to improve Apex performance
    • 3:15pm 22nd Nov 2010
  • Ray Tindall - Active Directory Integration - AD, WLS & ADF in Harmony
    • 9:45pm 23rd Nov 2010
  • Chris Muir - A change is as good as a REST: JDeveloper 11g's REST web services
    • 11:00am 23rd Nov 2010
  • Penny Cookson - A Path to the Future for Dinosaur Nerds: JDeveloper ADF - A Mind Map for Forms Developers
    • 3:45pm 23rd Nov 2010
The conference program can be subject to change, so check on the day to ensure you don't miss out!

So unless the schedule's changed on me, I'll probably be at the following sessions:

  • Steven Feuerstein - Golden Rules for Developers
  • Penny Cookson - Meet the CBO in Version 11g
  • Howard Ong - Make your legacy application live forever
  • Scott Wesley (won't want to miss this one!) - Apex Performance
  • Jeff Kemp - Oracle Apex Themes and Templates
    • (but sorry Jeff, I may find myself at Mogens Nørgaard - Oracle Licencing)
  • Damien Bootsma - Database performance made easy
  • Tom Kyte - The Best Way
  • Stuart Long Keynote - Cloud Services Automation (CSA)
  • Guy Harrison Keynote - Technology trends impacting Oracle professionals
  • Connor McDonald - Managing optimiser statistics
  • Frank Bommarito - Outlines, Profiles, SQL Plan Baselines

Yes, my selection is very much weighted towards Oracle performance this year. Nothing wrong with having a theme...

Please do come by our booth if you are also after training information, we train around Australia all year round and cover a wide range of Oracle topics. We can also customise the content to suit your organisation - talk to us to find out more. If you can make it to the conference, contact us on-line.

For you conference goers, if I don't see you anywhere amongst all of that, no doubt we'll all be with a beer at the welcome reception from 5pm (oh, I'll be at the AUSOUG AGM first - save me some beer)

Speakers, committee members, exhibitors et al. - listen out for details regarding dinner on Tuesday night, it's always a great night. I may be there... but it's my & Tracey's first wedding anniversary that day ;-)

ScottWe