November 11-12: Oracle SQL Course – 2 days

Published by beatrix on June 14, 2010 in General. 0 Comments

Cost: €450.00 for members. €595.00 for non-members.
Where: Professional.ie – 4400 Cork Airport Business Park
Register now: httphttp://www.itcork.ie/index.cfm?page=events&eventId=189

Description:

On a welcome return to Cork following his two sold-out sessions for it@cork last year, International Oracle author, trainer and expert, Dan Hotka, will illustrate coding techniques that ensure a consistent response time between instances and releases of the Oracle database. He focuses on performance tuning of actual SQL statements, as well as covering a variety of Oracle Server tuning topics.

Prerequisites:

A working knowledge of the SQL language. Knowledge of SQL Explain Plans is helpful but not necessary.

Topics covered:

-How Oracle arrives at an Execution Plan
-In-depth look at Explain Plans
-Advanced problem-solving topics using V$ Table information
-SQL Trace/Stats Pack
-PL/SQL Tuning/Profiling
-SQL problem-solving topics using V$ Table information
-Lectures and topics are enhanced with live illustrations and hands-on exercises

Attendees Receive:

-Study guide with presentations and relevant white papers
-Course files full of tuning and problem discovery scripts
-Opportunity to ask the tough Oracle questions
-A hands-on opportunity to learn more about Oracle, TOAD and/or SQL Developer

Detailed Overview:

The course starts out with a complete overview of the Oracle architecture, so delegates can get an understanding how their SQL and applications can take advantage of the computing environment. It then moves to a discussion on the differences of the various Explain Plan steps such as Merge-Join and Nested-Loop, and when is it best to use each. Dan goes into considerable detail, with SQL examples, on how the optimizers (both rule and cost) make their decisions. Participants will work with a variety of SQL statements, reviewing explain plans and making changes to make these SQL statements perform better. Delegates will also experience how to monitor their application environment, and see how to find problem SQL in their applications.

This workshop includes a section on monitoring Oracle RDBMS and SQL via the v$ tables and TOAD and is packed full of scripts to discover a variety of issues.

The course utilizes a variety of current tools. Participants will have the opportunity to learn more about TOAD and SQL Developer, as well as the Oracle tools like SQL*Plus, TKProf, and Stats Pack.

Summary Course Outline:

SQL Statement Tuning

- Oracle RDBMS Architecture overview
- Understanding/Reading/Interpreting Explain Plans
- Understanding the Rule-based Optimizer
- Understanding the Cost-based Optimizer
- Working with Hints

SQL Tuning Tools

- Tuning Tool Review: Statspack, Events, Tracing/Tkprof
- Profiling and tuning PL/SQL
- Finding Problem SQL using v$ information

About Dan Hotka:

Dan Hotka is a Training Specialist who has over 31 years in the computer industry and over 26 years of experience with Oracle products.  He is an internationally recognized Oracle expert with Oracle experience dating back to the Oracle V4.0 days.  Dan’s latest book is the TOAD Handbook by Pearson.  He is also the author of SQL Developer Handbook by Oracle Press, SQL Developer Handbook by Oracle Press, Oracle9i Development By Example, and Oracle8i from Scratch by Que and has co-authored 7 other popular books including the Database Oracle10g Linux Administration by Oracle Press. He is frequently published in Oracle trade journals, and regularly speaks at Oracle conferences and user groups around the world.

Bookmark and Share

June 10: Midsummer it@cork Networking Evening at the Murphy Brewery with Minister for Enterprise, Trade and Innovation, Mr Batt O’Keeffe TD

Published by beatrix on June 3, 2010 in General. 0 Comments

To register: http://www.itcork.ie/index.cfm?page=events&eventId=184
For it@cork members only
Venue: Murphy Brewery 6pm

This Annual Midsummer Event at the brewery always proves popular. As well as some excellent speakers, the networking opportunities are always superb too. The Minister for Enterprise, Trade and Innovation, Mr Batt O’Keeffe TD will be addressing members at this year’s event!

Bookmark and Share

June 1st: Technology Roadshow: Discover the latest innovation in IT technology!

Published by beatrix on May 17, 2010 in General. 0 Comments

From 8.30am to 10am

Cost: Free for members – 30€ for non-members

Where: Fota Island – Golf Course

Register now: http://www.itcork.ie/index.cfm?page=events&eventId=183

Welcome and Introduction.
Dave Ridley,  Brand Manager of IBM Systems.

Systems for a Smarter Planet.
How IBM systems can help you drive your business operations, reduce operational costs, improve efficiency, energy costs and improve performances.

How IBM’s new System x eX5 maximizes workload performance.
Workloads are growing, data is exploding, and memory-intensive applications need more than raw processing power, they need more memory to maximize performance. eX5 can boost performance and minimize licensing costs by de-coupling memory from the processor.

Five Generations of Collaboration and Innovation: Intel and IBM working together.
How IBM and Intel work together to deliver the IBM System x offerings.

Hands on demo and one to one discussions.
Have the opportunity to see the hardware in action and ask questions to the experts.

Bookmark and Share

IT Security Seminar May 27th: How hackers threaten your security?

Published by beatrix on May 5, 2010 in General. 0 Comments

To register: http://www.itcork.ie/index.cfm?page=events&eventId=182

From: 8.00 am to 10.30 am

Cost: Free for members / 30€ for non-members

Attend  this exclusive seminar that explains how today’s financially motivated hackers threaten the security of your IT systems and your data. Sophos security expert Dr James Lyne will shed light on how threats work, and how best to protect your computers and your data on a tight budget.

Objectives:

  – The changing threat landscape
  - How threats actually work
  - Live demonstration of a malware attack
  - Practical strategies to protect against threats 

Bookmark and Share

Few Places Available: Communications and Branding Seminar ‘Building cost effective reputation for your business’

Published by beatrix on April 18, 2010 in events. 0 Comments

Register now: http://www.itcork.ie/index.cfm?page=events&eventId=177

The course will take place on April 22nd from 11am to 1pm

Free for Members – 40€ Non-Members – Few places available

Location: Cork  International Airport Hotel

Warren Buffet said “It takes 20 years to build a reputation and five minutes to ruin it. If you think about that, you’ll do things differently.”

DESCRIPTION: Reputation is earned and not bought

How do my costumers perceive me?  Why would they buy my brand rather than my competitor’s? How would I persuade them that I am the one to trust? Should I be completely transparent? What should I communicate to my customers and how? How can I build a connection with my customers?… All these questions you are asking yourself will be answered on the course and more!!

This course provides a great range of information and tools to portray and reveal the right image and the right reputation for your brand, services, products and overall your company at a low cost.

OBJECTIVES OF THE COURSE:

In the current time, small as well as medium size businesses need more than ever to know how their customers perceive them and make sure they are perceived the right way.

You will get to know the keys to successful reputation:

Damien Mulley from Mulley Communications will cover:

  • How to figure out what your core values are and to reflect them in all communications (internal and external)
  • Defining what the “story” of your product or service offering is and sharing it with the public
  • How to prepare for every type of communication
  • Building in marketing and communications into the products themselves
  • How to manage your reputation and analyse the aftermath

Colin Byrne from Totem will cover:

  • How to build a brand identity
  • How to make an emotional connection with your customers
  • How to differentiate your business with your competitors’ business
  • How can you give a meaning to your brand
  • How to increase awareness and build your business

AUDIENCE: This course is dedicated to:

  • Small and medium size businesses
  • IT and High Tech organisations
  • Start ups
  • Organisations with low budget or no budget
  • Business that know little or nothing about communicating around their brand and products
Bookmark and Share

CLOUD COMPUTING AND OPEN SOURCE SEMINAR – APRIL 27

Published by beatrix on April 7, 2010 in General. 0 Comments

This Seminar is free for it@cork members
Register at: http://www.itcork.ie/index.cfm?page=events&eventId=181

Where: Cork County Hall
When: Tuesday April 27 – 4pm to 6.30pm
Cost: Free for members – 30€ for non-members

This seminar provides all the information about the use of Cloud Computing and Open-Source in Local Government, Cloud Computing and Open-Source as part of the Enterprise Ireland Strategy for the IT SME and its success in Denmark.

Program:

4.00pm Tim Willoughby, Assistant Director of Local Government Management Association (LGMA)
Topic: Use of Cloud Computing and Open-Source in Local Government

4.30pm Nomination from Enterprise Ireland
Topic: Cloud Computing and Open-Source as part of the EI Strategy for the IT SME

5.00pm Christian Lanng, is the CEO of Tradeshift who is a start-up that is using open-source, cloud computing and mobile technologies to enable advanced e-business between all size of business globally. Christian is one of the inventors of the Danish open-source e-business infrastructure NemHandel, as well as being a former Head of Division for the Danish Ministry of Science, Technology and Innovation where he championed everything from open-source to open data and generally believe the government it-infrastructure should be a platform for innovation.
Topic: The success of Cloud Computing, Open-Source and e-Invoicing in Denmark

5.30pm Nomination from IBM

6.00pm Questions & Answers

Bookmark and Share

Event: April 14th – Supporting “Industry-University” Collaboration

Published by beatrix on April 1, 2010 in General. 0 Comments

At 11:30am in National Software Centre, Mahon, Cork

FREE EVENT FOR ALL

Targeting: Technology CEOs. Managing Directors, Development Directors, Product Management, Product Development

Purpose: Extend your R&D with the help of third level colleges technologies & capabilities and multiple financial supports available. To help Technology Product Companies in their R&D by combining third level college technologies and capabilities with significant funding available to promote collaboration. To help innovative Service Companies in improving their service delivery and build Intellectual Property into their business by working with third level colleges with many areas of support and funding available.

This session presents the Irish Software Association – Irish Software Innovation Network (ISIN) initiative to actively assist technology companies and third level college projects in getting together to drive commercialisation, Services Innovation capabilities in UCC and some success stories around how the UCC have worked with technology companies in successful R&D collaborative projects.

Program:
11.30am Opening Address: TBD

11.40am ISIN Introduction: Michael Martin, ISIN Manager

12.00am Services Innovation and Case Study: JB McCarthy. Financial Services Innovation Centre, UCC

12.20pm Technology Transfer and Case Study: Brendan Cremen, Technology Transfer Office, UCC

12.40pm Open Discussion on accelerating innovation and the role of ISIN

1.00pm Light Lunch, Networking opportunity

This event will be of particular interest to CEOs, CTOs, CIOs, Product Management, Product Marketing, Technology Management and others in software and service enabled SMEs and MNCs.

Places are limited. To register for this free event please email:- michael.martin@ibec.ie

About ISIN:
The Irish Software Innovation Network, ISIN is a free matchmaking service to help Software Companies to identify and engage with relevant 3rd Level Research. ISIN is funded by Enterprise Ireland and managed by the Irish Software Association. The Network will help companies bridge the gap that often exists between the business world and the academic world.
ISIN will facilitate the set up of clusters of academics, indigenous software companies and Multi-National’s, to address particular problems posed by industry in a collaborative fashion.

Bookmark and Share

€100,000 in training for members over last 2 years – what about the next 2?

Published by Alison on February 23, 2010 in General. 0 Comments

We’ve been working hard to draw together a great application for Skillnet funding so that our members can have access to technical training at a subsidised rate (50%)

There are a lot of Skillnets competing for the available funding and we have to have an excellent application to be in with a chance of securing any.

We need to prove the committment of companies – that they will access the subsidised training and pay the subsidised rate for the courses. We need companies to fill in a letter of intent and send it to us before Friday to include it in our application. Companies can also make sure that their training needs are included in the application by filling out the online survey.

In the last two years €100,000 worth of training was delivered in Cork through the Software Skillnet. If we get what we’re looking for twice that amount could be delivered. However without the help of member companies we run the risk of not being able to access any funding.

Please help us to secure this funding for you!

Bookmark and Share

The IT Sentiment survey results are in and they’re really positive!

Published by Alison on November 9, 2009 in General. 0 Comments

Key stats:

  • 52% of respondents think the Global Downturn is Over the Worst and 25% that it is Near to the End
  • 83% of respondents think that the Technology sector will play a Significant Role in the Recovery of the Economy
  • 40% of respondents plan to Recruit IT/Technical staff in the next 12 months
  • 48% of respondents think the Opportunities for Growth in the IT Industry are Increasing and 46% Stable

From the open ended questions:

The key role for IT in economic recovery was seen as the technology sector’s ability to enable other sectors to become more productive and cost effective. Also identified were the areas of technology usage to support business decisions and processes; green and clean technology and the generation of innovative and new technologies in general.

The key areas identified as having opportunities for growth were: green technology; cloud computing; virtualisation; mobile phone applications; data warehousing / data centres; and selling online.

We’re hoping that the theme of this year’s conference Recovery Through Technology reflects the confidence within the sector. Topics will include cloud computing; innovative products; competitiveness; and raising financial capital. We have Liam Casey of PCH International, opening the conference with ‘New Opportunities in the Global Economy’. (Casey was one of the speakers at the recent Global Economic Forum in Farmleigh.) and Mike Fitzgerald of Altobridge (this year’s Ernst & Young’s Emerging Entrepreneur of the Year) will discuss ‘How to Create an International Success from Ireland’.

It’s great to see that the sector is so optimisitc and confident! Thank you to everyone who completed a survey and congratulations again to Bob Grantham of CIX for winning the free place at the conference!

Bookmark and Share

Congratulations to Bob Grantham of CIX, winner of the draw for a conference place!

Published by Alison on November 4, 2009 in General. 0 Comments

Thank you to everyone who completed our IT Sentiment Survey – we had 63 responses in total. Bob Grantham’s was the lucky survey number to come out of our randomizer and wins a place for the Recovery Through Technology Conference on November 18.

The findings of the survey will be summarised and put up on the website soon.

Bookmark and Share