SQL Fundamentals of Querying

A One Day Training Course
Overview
Students will learn what SQL is and how they can query a database to answer business questions.

Who Should Attend
Students enrolling in this course should understand the basic concepts involved in working with a personal computer (PC). For example, students should be familiar with such terms as computer memory, data files, and program files. Students should also be familiar with the components that make up a personal computer, including input, output and storage devices.

Prerequisites
A basic knowledge of concepts related to database structure and terminology, such as fields (or columns) and records (or rows) is helpful.

Content
Lesson 1: Introduction to databases and SQL
Lesson 2: Introduction to the SELECT statement
Lesson 3: Calculating data
Lesson 4: Selecting specific rows
Lesson 5: Working with other operators
Lesson 6: Grouping data
Lesson 7: Multi-table queries
Lesson 8: Other SQL front-end applications
Appendices
The sample database

Advanced SQL Querying

A One Day Training Course
Overview
To develop the delegate’s use of SQL to and advanced level. this course introduces data manipulation language and database definition language.

Who Should Attend
You should attend this course if you wish to have a good understanding of all DML statements (SELECT, INSERT,
UPDATE, DELETE) and all of the DDL statements needed to build database objects (CREATE, DROP, ALTER). This course also covers the use of views, access control, transaction control, advanced select queries and using SQL scripts.

Prerequisites
Delegates for this course should have a good basic understanding of SQL select statements. This course assumes knowledge of SQL to the level of our Introduction course.

Content
Lesson 1: Querying with unions and advanced joins Querying multiple
tables with unions Advanced Joins Calculating with COMPUTE
Lesson 2: Querying with subqueries Subqueries
Lesson 3: Adding data Inserting data SELECT INTO
Lesson 4: Updating and removing data Updating records Deleting records Deleting the contents of tables
Lesson 5: Manipulating tables and views Creating tables Modifying tables Deleting tables Adding and removing views
Lesson 6: Manipulating indexes Adding and removing indexes
Lesson 7: Ensuring data integrity with transactions Transactions
Lesson 8: Creating databases Creating a database with SQL Deleting a database

Visio 2013 Introduction

Duration
1 Day

Overview
The Introduction to Visio 2013 training course covers how to create professional diagrams to simplify complex information.

Objectives
You will learn how to create drawings like flowcharts and business process diagrams, work with shapes, text, art and objects and manage pages.

Who Should Attend
New and exisiting users of Visio who want to learn how the product is used efficently in the production of complex flow charts and business process diagrams.

Content

Getting Started with Visio
• Identify the Components of the Visio 2013 Interface
• Customise the Visio Interface
• Create a New Drawing
• Save a Drawing
• Open a Drawing
• Print and Share your Drawing

Creating a New Drawing
• Understand the Shapes Pane
• Add Shapes to a Drawing
• Connect Shapes
• Use Drag and Drop, Cut, Copy and Paste & Undo and Redo

Working with Shapes and Formatting Shapes
• Select Shapes
• Move, Rotate, Resize, Duplicate and Delete Shapes
• Apply a Shape Style
• Change the Fill and Line Colour
• Add Effect

Arrange Shapes
• Use Auto Align and Auto Space
• Change the Layout of the Page
• Rotate the Diagram

Format Text
• Change the Font Face, Size and Colour
• Apply Text Effects
• Use the Text Dialog
• Change Text Alignment
• Rotate Text

Insert Art & Objects
• Insert Online and Local Pictures
• Insert Charts
• Insert CAD Drawings
• Insert Text Boxes

Format the Page
• Change the Theme of the Current Page
• Choose a Variant for the Current Page
• Apply a Page Background
• Add Borders and Titles

Manage Pages
• Insert Pages
• Browse through Pages
• Rename and Delete Pages
• Create Background Pages

The Finishing Touches
• Check Spelling
• Modify Page Size and Orientation
• Use Page Setup
• Add Headers and Footers

Excel 2016 – Advanced

Duration: 1 day

Overview
The Excel 2016 Advanced training course builds on the techniques and concepts presented in the Intermediate course. It is designed to help you to extend your knowledge of some of the more specialised and advanced capabilities of Excel.

Objectives
This course focuses on how to perform more efficient Data Analysis using features such as Pivot Tables, Data Models, Power Pivots and “What If” tools. It covers more advanced use of Calculations and Functions including using formulas to control Conditional Formats. It also looks at controlling and protecting content in a spreadsheet by use of Data Validation and selective password security. Automation using recorded Macros is also covered.

Who Should Attend
This course is designed for Microsoft Excel users who wish to develop their skills so they can use the advanced techniques to manipulate and interrogate Excel data

Prerequisites
It is recommended that proposed delegates have attended a Microsoft Excel 2016 Intermediate course or have equivalent knowledge.

Content

FUNCTIONS AND CALCULATIONS
Extending the scope of formulas by using functions such as SUMIF, COUNTIF, IFERROR
Creating multi-level formulas by “nesting” functions.
Naming cells or cell ranges
Using Names in formulas
Limiting the scope of Names and managing Names in a workbook.
Using Array formulas
Using a formula to control Conditional Formats

CONTROLLING CONTENT
Applying Data Validation
Using levels of password protection to control content in spreadsheet.

USING WHAT IF ANALYSIS
Setting up and Using Goal Seek
Creating and Saving Scenarios
Loading and Viewing Scenarios
Creating a Data Table of results

WORKING WITH SOLVER
Enabling Solver Add-in
Setting Constraints in Solver
Modifying Constraints
Setting Solver Options
Generating Reports and Scenarios with Solver

ADVANCED USE OF PIVOT TABLES
Using Data Tables in the creation of Pivot Table reports
Using the “summarize values by” & “show values as” to adjust and customise the Pivot Table.
Using calculated fields and items in a Pivot Table.
Creating a Pivot Chart and using it to pivot data in report.
Using drill-down features including new pivot chart drill down buttons.
Using slicers and timelines to filter data in the report

DATA MODELS AND POWER PIVOTS
Using the Data Model feature to pivot data from multiple Excel sources.
Adding to the Data Model
Creating pivot table reports from the Data Model
Using Power Pivot
Importing data from an external source (such as access)
Use of new automatic relationship detection.
Pivoting data in Power Pivot
An explanation of the new “get and transform” group on the data tab.

USING MACROS
Purpose of a Macro
Recording and naming a macro
Editing the recorded code in the visual basic editing window.
Running a macro
Assigning a macro to a button on the ribbon or the QAT

Excel 2016 – Intermediate

Duration: 1 day

Overview
The Intermediate Excel 2016 training course builds on the techniques and concepts presented in the Excel Introduction course. It focuses on how to work more efficiently with calculations, how to further enhance the appearance of the data in the spreadsheet and introduces some data analysis features of Excel.

Objectives
This course will demonstrate how to control more complex formulae and functions and how to use formulae auditing. It will cover the use of various tools to analyse data such as sorting, filtering and a basic introduction to Pivot tables. You will also learn how to organize and present your data using tables, charts and conditional formatting.

Who Should Attend
This course is designed for Microsoft Excel users who wish to extend their knowledge and skills beyond building simple workbooks.

Content

WORKING WITH MORE ADVANCED CALCULATIONS AND FUNCTIONS
Use of Brackets in Calculations.
Use of Absolute References (Dollar Signs) In Calculations
Building “3-D” Calculations by Linking Formulas across Sheets or across
Workbooks. Controlling 3-D Links.
Using Formula Auditing
Using some Statistical Functions – Average, Max, Min, Count and CountA
Use of Dates in Calculations.
Some basic Date and Time Functions
An introduction to Logical Functions IF, AND, OR
Basic Use of VLOOKUP and HLOOKUP

USING EXCEL TABLE FEATURE
Advantages of Table feature and applying it to data.
How to working with Data Tables
Creating Calculated Columns
Filtering and Sorting in Tables

CONDITIONAL FORMATTING
How to applying basic Conditional Formatting
Using “Traffic Lights” Conditional Formats
Sorting and Filtering based on Conditional Formats

AN INTRODUCTION TO PIVOT TABLE REPORTS
What are Pivot Table Reports?
Creating a basic Pivot Table Repot
The Design Window and how to use it
“Pivoting” and Refreshing the Data
Using the Pivot Table Ribbons

WORKING WITH GRAPHIC OBJECTS
More Advanced Charting:
Formatting Charts.
Adding trend lines to Charts.
Use of Spark lines.
Dual Axis charts and combination charts.
Using SmartArt
Use of Screenshot Tool

Excel 2016 – Introduction

Duration: 1 day

Overview
Microsoft Excel is a useful tool for generating spreadsheets from a number of data sources. Using calculations and functions, users can easily manage any type of data including budgets, financial data, statistical data, reports, charts, graphs and small lists.

Objectives
This Excel course introduces the necessary features and skills which enable a user to begin working effectively and efficiently with Excel.

Who Should Attend
This course is designed for those who wish to gain the necessary skills to begin working with Excel 2016 spreadsheets. It will focus on how to create and edit spreadsheets, how to format content and create calculations and how to print and present the results.

Content

CREATING A BASIC WORKBOOK
Getting Started & Signing In (Where Appropriate)
Explanation of the Excel Screen and the Ribbons.
The Purpose of the Quick Access Toolbar.
Changing Ribbon Display Options and Customising the QAT
Using the New “Tell Me What You Want To Do” Help and Search Feature of 2016
Creating a New Workbook or Opening an Existing Workbook
The Purpose of Templates. New templates introduced in 2016
Saving a Workbook.

WORKING WITH DATA
Moving Around the Spreadsheet
Understanding Cell References
Entering, Deleting and Updating Content in the Spreadsheet. Using
Undo and Redo.
Creating basic Formulas
Using quick Functions such as AutoSum and Average
Using Copy, Cut and Paste. Purpose of Paste Special
Saving Time With AutoFill and FlashFill
Using the Quick Analysis Tool to Add in Quick Calculations or Formats.
Using quick Sort and Filter

FORMATTING DATA AND THE WORKSHEET
Adjusting the Size of Rows and Columns
Applying Number Formats
Formatting Headings – Including Font, Colours, Borders, Wrap Text and
Merge and Centre.
Using the Format Painter and the Styles Gallery
Clearing Formatting
Naming Worksheets and Formatting Worksheet Tabs
Freezing Titles on Screen

CREATING GRAPHIC CONTENT
Creating and Formatting a Basic Chart
Adding Text Boxes and Comments.
Adding Pictures using the Automatic Orientation New to 2016
Drawing Shapes – including the new 2016 pre-sets

VIEWING, PRINTING AND SHARING THE WORKBOOK
Inserting and Adjusting Page Breaks.
Using Print Preview and “Page Break Views” in the Work Area.
Using the Page Setup Dialog to Control Print Output
Saving a Workbook as a PDF or XPS file
Emailing a Workbook as an Attachment.
Using the “Inspect Document” and “Check Compatibility” Features.

Microsoft Frontpage

A One-Day Training Course

Course Aims:

This course covers the use of Microsoft FrontPage XP to create HTML (Hypertext Markup Language) documents for publication on the World Wide Web and corporate intranets. It gives a practical introduction to the main HTML tags and covers the techniques necessary to create pages and link them together to build a Web site, incorporating text, graphics and hyperlinks.

Continue reading “Microsoft Frontpage”

ITIL-F-V3

Foundation Certificate in IT Service Management – ITILV3

Duration: 3 days

Course Aims and Objectives

This course provides comprehensive first-level training for anyone involved in provision, support, and delivery of IT Services. It is accredited by, and follows the syllabus specified by the APM Group (www.apmgroup.co.uk).

Continue reading “ITIL-F-V3”

Introduction to Microsoft Project

A Two Day Training Course

Course Aims:

This course provides guidance on how to plan and schedule projects using Microsoft Project. Participants will acquire the necessary skills to create a new project, including entering task, resource and cost information; organise tasks using WBS techniques; analyse and adjust schedules with date and dependency constraints plus how to print graphic charts and tabular reports.

On this course, you will be introduced to many of the topics required for the Microsoft Office Specialist Project exam in the relevant version.

Continue reading “Introduction to Microsoft Project”