RSS Feed

Archive for the ‘What’s New in Omagh’ Category

SQL Query Language Intro in Omagh and Rest of NI

December 18, 2013 by admin No Comments »

Mullan Training is now delivering SQL Server and Query Language Training Courses in Omagh

We can also deliver closed, customised training courses in Lisburn, Belfast, L’Derry, Dungannon, Coleraine and throughout NI

Course Synopsis

The goal of this SQL training course is to provide students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server™.

Course Objectives

On completion of this SQL Server training course, delegates should be able to:

  • Describe the uses of and ways to execute the Transact-SQL language.
  • Use querying tools.
  • Write queries to retrieve data.
  • Group and summarize data by using Transact-SQL.
  • Join data from multiple tables.
  • Write queries that retrieve and modify data by using subqueries.
  • Modify data in tables.
  • Query text fields with full-text search.
  • Describe how to create programming objects.

Intended Audience

This SQL training course is intended for:

  • SQL Server database administrators
  • SQL Server implementers
  • SQL Server system engineers
  • SQL Server developers
  • IT professionals who are responsible for writing Transact SQL queries for SQL Server.

Course Prerequisites

Before attending this course, delegates are expected to have:

  • Experience using a Microsoft Windows operating system.

An understanding of basic relational database concepts, including:

  • Logical and physical database design
  • Data integrity concepts
  • Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, and many-to-many)
  • How data is stored in tables (rows and columns).
  • Familiarity with the role of the database administrator.

 

Call us on 028 9032 2228 or email info@mullantraining.com to enquire

 

QlikView Designer Training Course in Belfast, Lisburn, Omagh, Derry and Throughout Northern Ireland

October 22, 2013 by admin No Comments »

 

QlikView – Designer

 

http://www.mullantraining.com/QlikView_-_Designer

2 Day Course

Course Outcomes

Delegates will learn:

  • Interface layout
  • Design fundamentals
  • How to create a QlikView application with sheets
  • The Charts and graphs available to developers and business users inside of QlikView applications

QlikView training courses in Belfast Northern Ireland

 

New Course – Cloud Computing for IT Professionals and Business

September 27, 2013 by admin No Comments »

Introduction

This is a foundational course, for business and IT professionals, on the important topic of “Cloud Computing”. The training course provides a practical, hands-on overview of this fast moving technology across three layers – software, platforms and infrastructure – benefiting those organizations who are considering adoption of the Cloud Computing approach to their IT operations. On completion, course attendees will be able to evaluate as well as effectively deploy Cloud based computing environments and applications. This course is held in our Belfast City Centre training suites, just opposite the Europa Hotel

 

Click Here to see full Course Content

Attendees Will Learn About

Essentials of Cloud Computing encompassing:

  • Service Models
  • Application Scope
  • Opportunities & Risks
  • Infrastructure Deployment
  • Virtualization Techniques
  • Reliability & Resilience
  • Security & Privacy
  • Usability & Performance
  • Vendor Offerings

Who Should Attend

This course is suitable for all business and IT professionals who need to acquire the technical knowledge, and experience practical implementation issues related to Cloud Computing.

Course Content

 

Cloud Computing Fundamentals

  • Evolution
  • Objectives
  • Characteristics
  • Components
  • Delivery Models
  • Service Layers
  • Opportunities
  • Risks
  • Benefits
  • Vendor Survey

Cloud Computing Services

  • Software as a Service (SaaS)
  • Platform as a Service (PaaS)
  • Infrastructure as a Service (IaaS)
  • System Architectures and Operational Models
  • Vendor Selection Challenges

Cloud Computing Deployment

  • Infrastructure and Connectivity
  • Virtualization Types and Techniques
  • Security and Privacy
  • Reliability and Resilience
  • Usability and Performance
  • Real World Case Studies
 

Microsoft Office 2013 Training Courses now available in Belfast, Omagh, Derry, Newry and Throughout Northern Ireland

July 19, 2013 by admin No Comments »

Mullan Training is now delivering training courses in Microsoft Office 2013. These courses include

Microsoft Access 2013 Intro – Advanced Courses Relational database systems, forms, reports, data storage
Microsoft Excel 2013 Intro – Advanced Courses Spreadsheets, charts, pivot tables
Microsoft InfoPath 2013 Intro – Advanced Courses Create XML-based forms for SharePoint
Microsoft OneNote 2013 Intro – Advanced Courses Organize your thoughts and ideas in a notebook format
Microsoft Outlook 2013 Intro – Advanced Courses The email standard as well as personal information manager
Microsoft PowerPoint  2013 Intro – Advanced Courses Create business or school presentations
Microsoft Publisher 2013 Intro - Advanced Courses Publish brochures, newsletters, and much more
Microsoft Visio 2013 Intro - Advanced Courses Create drawings, charts, maps and more
Microsoft Word 2013 Intro - Advanced Courses The industry standard for word processing
Microsoft Project 2013 Intro - Advanced Courses Create effective project plans and effectively maintain & update project progress

 

 

Please contact us if you would like:

  • Information on our courses (rates, dates, outlines)
  • To book a Closed course for your company only
  • To book a onto a course on our  Public Course Schedule
 

NEW COURSE – PowerPivot Training Course with Excel 2010 & 2013 in Belfast, Omagh, Derry, Newry and Throughout Northern Ireland

by admin No Comments »
PowerPivot is an add-in for Microsoft Excel 2010 that enables you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous data, create calculated columns and measures using formulas, build PivotTables and PivotCharts, and then further analyze the data so that you can make timely business decisions without requiring IT assistance.
Our 1 Day course will enable delegates to maximise the benefit of this useful tool.
Prerequisites
This course is designed for Advanced users – a knowledge of Pivot tables and Advanced functions is required.

 Course Content

  • Installation & Set up of Power Pivot
  • Creating your first Power Pivot report
  • Creating a data model & refining it
  • Using Tables & Structured References
  • Using Pivot Tables & Slicers
  • SQL Basics
  • Power Pivot formulas & DAX
  • Complex DAX examples
  • Working with time-intelligence
  • Power Pivot Dashboard
  • New features of Power Pivot in Excel 2013

 

Contact us on 028 9032 2228 or email info@mullantraining.com for dates and prices.

 

Sage RTI Training Courses in Omagh, Cookstown and throughout Co. Tyrone

December 10, 2012 by admin No Comments »

Are You RTI Ready?

Mullan Training is now offering Sage RTI workshops in Omagh, Dungannon and throughout Tryone and the rest of Northern Ireland to make sure you are!

Here are some basics of RTI and a useful link to help you prepare for RTI, available from Sage through Ledger Services

RTI Basics

In April 2013 HM Revenue & Customs (HMRC) is introducing a new way of reporting PAYE called ‘Real Time Information’ (RTI).

How will RTI affect you?

  • As an employer/pension provider you will submit information to HMRC about PAYE payments throughout the year as part of your payroll process (monthly), rather than at the end of the year as you do now.
  • RTI only affects the submission of PAYE information – payment arrangements will remain unchanged.
  • Most employers will be legally required to report payroll information in real time from April 2013 with ALL employers doing so before October 2013. HMRC will tell you when.

RTI Workshops

Sage Payroll 50 and Instant Payroll software are both RTI ready…Are you? If not then don’t fear as we are now open for bookings for RTI workshops in line with RTI voluntary sign up.

We can deliver closed training courses for you in your own premises and will be running Public Courses in various enterprise centres and other venues in Northern Ireland.

What Will You Learn?

  • Learn about the different online submissions required.
  • How to ensure your payroll data is RTI compliant.
  • Go ‘hands on’ and practise the RTI routines in a demo environment

Course Objectives

By the end of this workshop you will:

  • Understand why RTI is being introduced and how it affects your payroll processing
  • Know how to prepare your data so that it is RTI ready
  • Learn about the different RTI submissions including how & when to make them
  • Identify & correct mistakes that may occur when processing under RTI
  • See the impact RTI has on your payroll year end

Useful Link

For detailed information on RTI, you can visit the HMRC website

Contact Us For Course Details

Please contact us if you would like details and costs on our Sage RTI training courses – we will be pleased to provide you with detailed course content, costs and dates

 

Omagh Courses Coming Up!

April 15, 2010 by admin No Comments »

Here is a list of the computer training courses in Omagh over the next few months – please contact us on 028 9032 2228 if you have any questions.

We will try and tailor our courses as best we can to suit your needs!

Application Level Cost Per Delegate (excl. VAT)
Course date(s)
(Click to view course Outline) 1 2 3 May June July
Microsoft Word Intro £90 £175 £260 14 14 19
Microsoft Word Adv £140 £265 £375 24 24 29
Microsoft Excel Intro £100 £190 £270
13
8 16
Microsoft Excel
Adv
£140 £265 £375
24
18 27
Microsoft Access
Intro
£250 £475 £675 8 7 15
Sage Line 50 Interm £145 £275 £390 4 1 1
Sage Payroll Interm £145 £275 £390 27 23 28
Adobe Photoshop Interm £150 £285 £405 6 2 6
Adobe After Effects Interm £300 £570 £810 7 4 14
Crystal Reports Interm £450 £855 £1215 23 17 20