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

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

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

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

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

 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.

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

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!