UK TRAINING COURSES 

TRAINING COURSES UK

---

Crystal Reports 2008

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• A  two day training course will prepare participants to build and distribute complex reports which include sorting, grouping, linking, formula creation and parameters using Crystal Reports 2008. No prior Crystal Reports experience is assumed.

• Some of the training topics covered include ...
Conditionally Formatting Fields 
Subtotals Using the Group Sort Expert
Using Subreports to Link "Unlinkable" Data 
Creating Hyperlinks
Reordering Groups 
Using the Running Totals Feature
Suppressing Rows, Columns or Totals
Passing Data from the Main Report into a Subreport
Performing Simple Number Calculations 
Sorting Records within a Group 
Formulas
Adding Multiple Tables to a Report 
Using a Parameter to Select Records
Conditional Running Totals 
Window 
Parameters
Using Multiple Parameter Fields in Reports
Format Painter 
Chart 
Using Guides and Guidelines to Move and Align Objects 


• See Training Course Details...

---

Crystal Reports 2011

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• A two day comprehensive training course will prepare participants to build and distribute complex reports which include sorting,grouping, linking, formula creation and parameters using the Crystal Reports 2011 release.

• Some of the training topics covered include ...
Time Debugger
Creating an Unlinked Subreport
Previewing the Report 
Using the Chart Options 
Declaring a Variable
Summarizing Groups 
Saving the Report 
Passing Data from the Main Report into a Subreport
Linking a Subreport
Format Painter 
Formatting Part or All of an Object 
Using the Running Totals Feature
Working with the Page Commands 
Using the Sort Control 
Placing Fields on the Report 
Understanding How Crystal Reports 
Parameter Fields Overview
Creating Hyperlinks
Working with Cross-Tab Reports
Adding Parameter Values to Text 


• See Training Course Details...

---

Crystal Reports 2013

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• This two day comprehensive training course will prepare participants to build and distribute complex reports which include sorting, grouping, linking, formula creation and parameters using the Crystal Reports 2013. No prior knowledge of Crystal Reports is required.

• Some of the training topics covered include ...
Understanding the Formula Evaluation Subreports
Drawing a Line
Using the Parameter Panel
Applying the Drill-Down Feature
Using Evaluation Time Functions
Using a Parameter to Select Records
Modifying Individual Objects in the Chart
Understanding Crystal Formula Syntax
Adding Fields into a Text Object
Separating Statements in Complex Formulas
Creating Running Totals for a List of Numbers
Starting a New Report
Calculating Percentages
Creating Multiple Groups in a Report
Understanding How Cross-Tabs Affect Your Data
Using the Sort Control
Exporting to a Report Definition Format Using the Report Wizards
Conditional Running Totals Prompting with Parameters
Applying Chart Templates Exporting Your Reports
Creating Hyperlinks Creating Powerful Groups
Using the Group Tree to Navigate the Report


• See Training Course Details...

---

Crystal Reports 2016

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• This hands on Crystal Reports 2016 report designer course introduces participants to creating parametrised reports which filter, sort and aggregate data. The course also demonstrates; techniques for ascertaining which tables to join together when working with external databases. No prior Crystal Reports experience is assumed.

• Some of the training topics covered include ...
Displaying Parameter Fields
Using Group Selection to Filter the Records in the Report
The Group Sorting Dialog Box
Using Guides and Guidelines to Move and Align Objects
Learning about Linking
Creating a Simple Report
Using the PDF Format for Crystal Reports
Working with Variables
Passing Data from the main Report into a Subreport
Using the Parameter Panel
Exploring the Toolbars
Sorting Records within a Group
Filter Types of the Select Expert
Starting a New Report
Using the Preview Panel
Inserting Graphics
Formatting Sections
When and Why to Group Records
Calculating Percentages
Adding Parameter Values to Text  Objects Allowing Multiple Values in Parameters
Formatting Sections Conditionally


• See Training Course Details...

---

Crystal Reports XI

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• This two day comprehensive Crystal Reports XI trainingcourse will prepare participants to build and distribute complex reports whichinclude sorting, grouping, linking, formula creation and parameters.
  
  Crystal Reports training courses are also available in Crystal Reports versions8.0, 8.5, 9.0 and 10. 

• Some of the training topics covered include ...
Understanding How Crystal Reports Processes the Data
Selecting Records with Multiple Criteria
Format Painter
Browsing Field Data
What Is a Pass
Customizing the Group Name Field
Creating String Formulas
Unlinked versus Linked Subreports
Grouping Hierarchically Working with Cross-Tab Reports
Inserting Special Fields Selecting Specific Records From the Database
Pass #1
Creating a Dynamic Value List for Parameter Values
Using the Chart Options
Creating the Formulas
The Highlighting Expert
CurrentFieldValue Report Alerts
Using a Field Name to Customize the Group Name
Producing Charts
Working with Text Objects
Selecting and Sizing Objects
Formatting Individual Cells


• See Training Course Details...

---

CSS3

• 1 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• This CSS3 course will expose students to new features in CSS3. Participants will learn how to use selectors and pseudo elements, font, color, and layout techniques; transforms, transitions, and animations. The course will explore how CSS media queries can be used to change how websites are presented on mobile devices.

• Some of the training topics covered include ...
Introducing CSS3
Implementing CSS3 in the "Real World"
Modernizr
What is CSS3?
What Are Vendor Prefixes
Web Accessibility
HTML5 Selectors and Pseudo Classes
The History of CSS
Styling Video
Image Borders
Layout: Columns and Flexible Box
Embedding Media
Media Queries
Accessibility Features
Responsive Images and the viewport Metatag
The @font-face Rule
Flexible Box Model Vendor Prefixes
Frameworks and Grid Systems
Backgrounds


• See Training Course Details...

---

Data Mining using Excel and Microsoft SQL Server Analysis Services

• 3 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• This course is intended for Power Users, IT Professionals, Report Developers, BI Professionals and  Project Managers interested in exploring the Microsoft toolsets for data mining, machine learning and predictive analytics. Participants will fully explore the potential of Excel PowerPivot and Excel Data Mining Add-ins used in  conjunction with Microsoft  SQL Server Analysis Services (SSAS).

• Some of the training topics covered include ...
Saving Results to the Database
Data Mining and Results
Creating Reports Using Reporting Services
Microsoft Decision Trees Algorithm
Offline Mode and Immediate Mode
Microsoft Time Series Algorithm
Visio Data Mining Add-In  
Microsoft Linear Regression Algorithm
Types of Data Mining Algorithms
Microsoft Clustering Algorithm
Data Preparation
Microsoft Association Algorithm
Cross Validation
Named Calculation
The User Interface
Excel PowerPivot Data Mining Add-ins
Cross Validation
Microsoft Logistic Regression Algorithm
Model Usage


• See Training Course Details...

---

Developing Websites for Mobile Devices

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• This two day intensive course will demonstrate how to use HTML5, CSS, JavaScript, and other tools to create websites which adapt their layout to the client device, whether it be a smartphone, tablet computer or desktop computer. The course assumes prior knowledge of HTML, CSS and some familiarity with SQL.

• Some of the training topics covered include ...
jQuery Mobile
A First Look at Foundation
Google Maps
Flexible Grids
Browser and Device Support
The GeoLocation API
Flexible Background Images
GeoLocation API
Building Responsive Sites
The Case for Flexible
Using max-device-width
Flexible Images and Other Media
Targeting Widths and Devices with CSS3 Media Queries
Accessing Camera, Contacts, Calendar, and More - But Not Yet
Linearizing the Layout
Video Formats
Gestures
Responsive Design: Good for All Devices
Hosting Your Own Videos


• See Training Course Details...

---

Excel Advanced

• 1 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• A one-day course covering Microsoft Excel advanced topics.

• Some of the training topics covered include ...
Deleting a Macro
Disabling Tracked Changes
Exporting Data as Text
Opening a Password Protected Workbook
Using Subtotals With AutoFilter
Inserting a PivotChart
Importing Access Data
Protecting a Worksheet With Controls Sharing Workbooks
Exporting to Microsoft Word
Consolidating Data Using the SUM Function Data Tables
Understanding Save Options
Creating a Linked Consolidation
Modifying an Inserted Picture Data Linking
Using Relative Names for Subtotals Data Consolidation
Recording a Simple Macro
Displaying Scenarios
Filtering a PivotTable
Using the DMAX Function
Working With an Outline
Understanding Advanced Filtering
Counting in a PivotTable


• See Training Course Details...

---

Excel Basic

• 1 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• A one day course introducing Excel.  Participants will learn how to writing formulas, use conditional formatting, create charts and print workbooks.

• Some of the training topics covered include ...
Understanding the Excel Start Screen
Accessing the Help Window
Understanding Cell Alignment
Using the Format Painter Cell Alignment
Using Google to Get Help
Performing an Alphabetical Sort
Approximating Column Widths
Understanding the Quick Access Toolbar
Creating Absolute References
Setting Precise Columns Widths
Deleting Data
Setting the Default Column Width
Creating Compound Filters
Understanding Printing
Problems With Relative Formulas
Worksheet Zooming
Adding Commands to the QAT
Relative Formulas
Using the Thousands Separator
Printing a Range
Using the Ribbon


• See Training Course Details...

---

Excel Intermediate

• 1 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• A one day course covering Microsoft Excel Intermediate topics.

• Some of the training topics covered include ...
The MOD Function
Extracting Dates and Numbers Worksheet Techniques
The ROUND Function
Filling Data
Showing Gridlines
Using the More Borders Command
Changing WordArt Fill
Formatting With WordArt
Understanding Conditional
Custom Formatting Large Numbers
Understanding Goal Seeking
Adding a Chart Title
Formatting Clock Time
Changing Line Chart Colours
Removing Borders
The LOOKUP Function
Copying Nested Functions
Creating a Custom Fill List
The PMT Function Complex Formulas
Creating the Base Formula
Deleting a Table Chart Elements


• See Training Course Details...

---

Excel Power Pivot

• 1 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• A one day course introducing candidates to Power View and Power Pivot Excel tools.

• Some of the training topics covered include ...
Updating a Power View Report
Adding Slicers Get & Transform
Understanding the Query Editor
Viewing and Editing a Tour
Changing the Look
Working With Scene Options
Understanding Get & Transform
Editing Query Steps
Adding Power View to the Ribbon
Creating a Calculated Field
Understanding the Navigator Pane
Working With Height and Category
Tiling Data in Power View
Understanding Power Pivot
Adding a Data Column
Creating a New Query From the Web
Using Related Power Pivot Fields
Creating a New Query From a File
Navigating a Data Map


• See Training Course Details...

---

Excel Programming Using VBA

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• A two day Excel VBA programming course which introduces advanced Excel users to the process of writing and editing Macros. No prior programming experience is assumed.

• Some of the training topics covered include ...
Understanding Objects
Working with Methods
Working with Boolean Expressions
Navigating the Excel Object Hierarchy
Working with the PivotFields Collection
Working with the Combo Box Control
Using the If...End If Decision Structures
Working with Option Button Controls
Using Visual Basic Help
Writing an Error-Handling Routine
Understanding the Err Object
Using the Toolbox
Understanding Control-of-Flow Structures
Understanding the Development Environment
Trapping Errors with the On Error Statement
Naming Procedures
Using the Immediate Window to Call Procedures
Working with the Text Box Control
Setting Control Properties in the Properties Window
Working with the Label Control


• See Training Course Details...

---

HTML

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• A two day course introducing HTML (Hyper Text Markup Language). Delegates will learn to create and edit simple web pages containing text, lists, images, hyperlunks, forms and tables.

  No prior HTML or web development knowledge is assumed. 

• Some of the training topics covered include ...
Media Types and Units of Measurement
Points (pt)
The title Attribute HTML Images
The Inherit Value
Default Pages
ID Selectors
CSS Rules
Unordered Lists
Phrase Elements
Password Fields
The HTML Skeleton
Introduction to HTML
Inches (in), Centimeters (cm), and Millimeters (mm)
Case Sensitivity
Long Descriptions
Whitespace
Getting Started
Text Links
Start Attribute
DOCTYPE Declarations
Form Elements


• See Training Course Details...

---

HTML 5

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• Participants on this two day courses will learn about HTML5 structural, semantic, and form tags, how to use Canvas to create drawings natively in the browser, how to work with HTML5 audio and video, the methods for storing variables client-side, and how you build applications that work offline. The course is aimed at delegates with an existing knowledge of HTML 4 or xhtml.

• Some of the training topics covered include ...
HTML5 - Background
Prefixing your Keys
Laying out a Page with HTML 4 - the "old" way
Audio Formats
Getting and Creating Audio Files
Cache Manifest File
Getting Started with Canvas
The video Element
New HTML5 Structural Tags
Other Storage Methods
autocomplete
Circles and Arcs
The section Tag
Additional Changes
Accessibility
The HTML5 Spec(s)
A Sample Application
The HTML5 Way
Page Structure


• See Training Course Details...

---

JavaScript

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• This introductory two day JavaScript training course aimed at Web Designers will enable participants to interpret, adapt and write their own JavaScript code.
  
  No prior programming knowledge is assumed.-

• Some of the training topics covered include ...
Function Syntax
JavaScript Objects, Methods and Properties
Validating Radio Buttons
JavaScript Form Validation
Methods
JavaScript Basics
Validating Text areas
Basic Rules
User-defined Functions
Built-in Functions vs Methods
A Loosely-typed Language
JavaScript Variables
The this Object
Validating Select Menus
Basics of Form Validation
Validating Checkboxes


• See Training Course Details...

---

JQuery

• 3 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• This intensive three day jQuery training course provides a comprehensive overview of the jQuery JavaScript library. Ideally candidates should have a working knowledge of HTML and CSS.

• Some of the training topics covered include ...
Managing Effects
Data Methods
Breaking and Continuing
Chaining
Operators
Keep Things DRY
The Setup
Traversing
Disconnecting Events
$(document).ready()
jQuery's Ajax-related Methods
Plugins-
Beware Anonymous Functions
$.fn.hover
Operations on Numbers and Strings
$.fn.load
Selecting Form Elements
Checking Types


• See Training Course Details...

---

JQuery Mobile

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• A two day intensive course in which participants develop single sites for all popular smartphone, tablet, and desktop platforms. You'll learn how to use jQuery Mobile to handle touch events, build mobile-optimized forms and widgets, incorporate HTML5 features, leverage phone capabilities such as making calls and texting, and more. Along the way, we'll cover jQuery Mobile's extensive theme framework and plugin architecture.

  Prior knowledge of HTML, CSS and JavaScript is required.

• Some of the training topics covered include ...
Creating Your Own Plugin
Buttons and Toolbars
What Is jQuery Mobile?
Data-role
Buttons and Linking Pages
Orientation (Portrait/Landscape)
ThemeRoller
HTML5 and CSS3 Getting Started with jQuery
Dialogs Widgets and UI
Ajax-driven Page Navigation
Making Calls
Hosting vs. CDN
Video The Theme Framework
Using Others' Plugins
Overview
Lists and Buttons
Collapsible Blocks Events


• See Training Course Details...

---

Microsoft Access

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.

• Some of the training topics covered include ...
Macro Techniques
Modifying Forms
Using a Navigation Form
Importing and Exporting Records
Querying Techniques
Parameter Queries
Creating a Lookup Database
Designing a Lookup Database
Adding Records to a Table
An Introduction to VBA
Creating and Using Forms
Understanding VBA
Aggregation Queries
Creating Queries
Creating and Using Macros
Calculations in Queries
Getting to Know Access 
Adding Transactional Records
Relational Database Design
Database Wellness
Setting Table Relationships


• See Training Course Details...

---

Microsoft Access Programming Using VBA

• 3 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.

• Some of the training topics covered include ...
Using Message Boxes
Calling Procedures
Understanding Error Handling
Using Intrinsic Constants
Using the For...Next Structure
Using Intrinsic Functions
Using the For Each...Next Structure
Using the Object Browser
Debugging Code
Creating a Sub Procedure
Understanding Procedures
Understanding Control-of-Flow Structures
Controlling Program Execution
Understanding the DoCmd Object
Using the Immediate Window to Call Procedures
Considering Variable Scope and Lifetime Together
Working with Recordsets
Understanding Constants


• See Training Course Details...

---

Microsoft Excel Power Query

• 1 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• This course familiarises the participant with Microsoft Power Query, a revolutionary data tool for Excel that allows you to intuitively discover and automate the import, transformation, and combination of data across a variety of data sources for use in Excel and Microsoft Power BI. Power Query is a free add-in for Excel that enhances the self-service Business Intelligence experience in Excel.  The course uses Excel 2016, however Power Query works with Excel 2010 and above.  

  Participants should be familiar with Excel and the concepts of datasets and basic reporting including the use of PivotTables.

• Some of the training topics covered include ...
Loading Data
Data Sources GROUPING AND SUMMARISING WITH POWER QUERY
Using PivotTables CONNECTING TO DATABASES
Grouping Options
Importing Data
Summarising WORKING WITH THE POWER QUERY LANGUAGE “M”
Understanding Data Types WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
Course topics include- INTRODUCTION TO POWER QUERY
Understand and perform importing from SQL Server Analysis Services Tabular. PERFORMING MERGES
Understand and utilize merges. LOADING YOUR DATA
Using Ranges in Excel
Working with Folders and Files
Combining Worksheets
Loading into Excel
Power Query Interface
Importing, Transforming, and Loading Data into Excel and Power Pivot
Understanding and Handling Special Situations
Loading into Power Pivot
Transforming Data
Understanding the Issues
Understand and perform importing from SQL Server Analysis Services Multidimensional.


• See Training Course Details...

---

Microsoft Excel PowerPivot Data Analytic Expressions DAX Language

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• This course is intended for Power Users, Business Intelligence Developers and IT Professionals who will be involved with the development of Excel PowerPivot queries and tabular modelling. The course is intended to expose the delegates to the technology of DAX and to familiarise them with functionality of DAX at an advanced level.

   Prior experience with Excel and Microsoft SQL query writing is useful.

• Some of the training topics covered include ...
Using Multiple Calendars Utilising Advanced DAX Functionality
Many-to-Many Relationships
Introduction to DAX
Single Table Evaluation Context
Introduction to DAX
Handling Errors Using DAX Functions
Logical Functions
Multiple Table Evaluation Context Working with Dates
Date Functions
Aggregation Functions
Conversion Functions
Filter Functions
Understanding Values
Mathematical Functions
Explaining Syntax
Working with Calendars
Information Functions
Text Functions
The CALCULATE Function
PowerPivot Data Model
Utilizing Operators


• See Training Course Details...

---

Microsoft Power BI

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• This course is intended for Managers, Report Developers and Data Participants who will learn how to use Microsoft Power BI to transform organisational data into rich visuals that facilitate new ways of thinking. This course covers both Power BI On Line and Power BI desktop. 

• Some of the training topics covered include ...
The Power BI Interface
Managing a Power BI solution
Combine data together from tables in your dataset. Modeling data
Power BI desktop queries
Importing different data sources into Power BI
Topics covered include- Introducing Power BI
Direct connectivity from Power BI desktop
Overview of the Power BI Data Model. Using Power BI
Using Excel as a data source for Power BI
Custom visuals Power BI mobile app
Connecting to Power BI data
Create calculated columns, calculated tables and measures. Interactive Data Visualisations
Shape data using formatting and transformations.
Create relationships between data tables.
Using databases as a data source for Power BI
Importing data into Power BI
Viewing reports from Excel files Shaping and Combining Data
Use Power BI with SQL Server Analysis Services data, including Analysis services models running in multidimentional mode. The Developer API
Direct connectivity from the Power BI service
The developer API
Understand the DAX syntax and use DAX functions to enhance your dataset.


• See Training Course Details...

---

Microsoft Power Graphics

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• The course is targeted towards business analysts, business intelligence developers and reporting professionals. Participant will learn how to combine the functionality of Power View, PowerPivot, Power Query and Power BI into graphs, charts, KPIs, reports and other data visualisations.

• Some of the training topics covered include ...
Utilise data sources.
Visualizing Power View Reports
Filter data.
Adding Slicers to Reports
Introduction to the PowerPivot Interface
Perform data cleaning.
Utilize themes.
Importing Data with a Query
Merge datasets.
Creating a Cascading Relationship
Creating PivotTables
Hiding Columns, Change Data Type, Sorting, and Filtering
Understand querying with natural language
Utilizing DAX Functions
Importing Large Datasets
Examining Tiles
Power Map


• See Training Course Details...

---

Microsoft Project Integrated Course

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• A short intensive course covering Microsoft Project Levels 1, 2 and 3. This course teaches you everything you need to know to get up and running with using Microsoft Project competently.

• Some of the training topics covered include ...
Filtering a Visual Report
Resource Assignment Summary Assigning Resources
The Importance of Planning
Using the Personal Template Folder
Changing Time Periods
Critical Path and Project Slack
Understanding Excel Visual Reports
Understanding Printing
Changing the Unit Display Resourcing Concepts
Checking Work For Materials Costs
Understanding Task Durations
Cloning an Existing Report
Formatting Table Fields
Exiting From Project 2016 Project Management
Inserting Custom Fields
Importing Data From Excel Working Collaboratively
Simple Resource Assignments
Assignments
Understanding Working With
Viewing the Critical Path


• See Training Course Details...

---

Microsoft Project Level 1

• 1 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• The skills and knowledge acquired in this course are sufficient for the learner to be able to use Microsoft Project 2016 to create a new project, enter and work with tasks and resources, create a schedule, and print effective project information.

  At the completion of this course you should be able to:

  Start Microsoft Project and identify how it works
  Explain some of the key concepts associated with project management
  Create a new project file in Project
  Enter tasks into a project file
  Create relationships between tasks in a project
  Add resources, including labour, materials and equipment to a project
  Understand and use resource assignment calculations
  Assign resources to tasks using a number of different methods
  Print various aspects of a project
  Obtain help for Project whenever you need it

• Some of the training topics covered include ...
Understanding Your Project
Entering Work Resources
Working With Split Screens
Exiting From Project  Project Management
More Resources in Multiple Assignments
Understanding Resource Availability
Other Sources of Assistance
Understanding the Project Start Screen
Entering Material Resources
Understanding Scheduling Icons
Contouring Work Hours
Gantt Chart View
Working With Views
Steps in Creating a Project
Adding More of the Same Resource
Understanding Tasks
Understanding Printing
Creating Dependencies in Task Information
Understanding Resources
Modifying the Standard Calendar


• See Training Course Details...

---

Microsoft Project Level 2

• 1 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• Microsoft Project - Level 2 is designed for existing users of Microsoft Project who wish to extend their skills and knowledge beyond the creation of simple projects.

  At the completion of this course you should be able to:

  Use various techniques for levelling over allocation of resources
  Assign material resources in a project
  Assign and track costs within a project
  Apply constraints and deadlines to tasks in a project
  Track the progress of a project
  Work more productively with project views
  Work with tables in Project
  Work with some of the features that allow you to control your data
  Format projects to make them more appealing and relevant
  Print data from Gantt Charts in a variety of ways and presentations

• Some of the training topics covered include ...
Assigning Daily Costs
Viewing Project Costs Constraints and Deadlines
Reviewing Our Project
Changing Rates During a Project
Grouping Tasks
Changing the Layout
Understanding Overtime
Modifying Specific Tiers
Creating an Over Allocation Report
Working With Progress Lines
Hiding Open Files Tables
Working With Multiple Files
Creating a Custom Filter
Exporting to PDF
Using The Tracking Box
Highlighting Date Ranges
Showing Tiers
Formatting Selected Bars
Automatically Updating Tasks
Understanding Gantt Chart Bars
Adding Fields Using Add New Column


• See Training Course Details...

---

Microsoft Project Level 3

• 1 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• Microsoft Project - Level 3 aims to take the learner to more advanced levels of Microsoft Project. It covers a diverse range of topics including working simultaneously on multiple projects, sharing resources between several projects, downsizing very large projects, using templates, and automating operations with VBA.

  At the completion of this course you should be able to:

  Create and work with several types of custom fields
  Create and work with WBS Codes
  Create a custom view with a custom filter, group and table
  Run and modify standard graphical reports as well as create your own custom reports
  Create and work with visual reports
  Work with and create project templates
  Work with and link multiple projects in Project
  Create shared resources for use amongst multiple projects
  Downsize large project files into more manageable entities
  Export project data to other applications
  Collaborate on projects with others using Skype for Business and SharePoint
  Create VBA macros to automate operations in a project file

• Some of the training topics covered include ...
Understanding Custom Fields
Adding a Contact as a Resource
Creating Graphical Indicator Custom
Removing Unwanted Reports Visual Reports
Understanding WBS Codes
Testing a Formula
Filtering a Visual Report
Working With a Resource Master Downsizing Larger Projects
Modifying a Formula
Working With a Synced Task List Microsoft Project VBA
Exporting to Excel Using a Map
Running a Report
Understanding Graphical Reports
Creating WBS Codes
Creating a Custom Group for the View
Applications
Renumbering WBS Codes
Creating a Common Resource Pool
Using a Custom Project Template
Creating Smaller Projects


• See Training Course Details...

---

Microsoft SQL Server 2005 Analysis Services SSAS

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• In this course participants learn how to use Microsoft SQL Server 2005 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2005 developer the tools to build data warehousing and decision support system solutions. This course also provides information on end-user tools including Microsoft Excel 2003/2007 and Microsoft SQL Server 2005 Reporting Services.

• Some of the training topics covered include ...
Creating Data Sources and Data Source Views 
Adding scripts 
Using multiple fact tables 
Understanding dimensional modeling - Dimensions (Type 1, 2, or 3) or rapidly changing 
Partitions - relational and Analysis Services partitions 
Excel Services 12 and AS (Web Services)
Beginning MDX 
Intermediate MDX 
Processing mining models 
Adding calculated members 
Introduction to Data Mining
Perspectives 
Report Center (type of dashboard) uses KPIs, Reports, Excel Web, Filter 
Best practices - health monitoring 
Understanding fact (measures) and cube modeling 
Advanced Storage Design - MOLAP, ROLAP, HOLAP 
Customizing Aggregation Design - Processing Design 
Creating cubes - using the UDM and the Cube Build Wizard 


• See Training Course Details...

---

Microsoft SQL Server 2005 Integration Services SSIS

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• This two day course will familiarise participants with SQL Server Integration Services 2005 (SSIS) tools and technologies. In this course you will learn about the SQL Server Management Studio (SSMS) and building Database Maintenance Plans. You will be introduced to the Business Intelligence Development Studio (BIDS) and working with Control Flow and Data Flow. You will also become familiar with SSIS package management and package deployment along with learning to write solid code using debugging, error handling and logging techniques.

• Some of the training topics covered include ...
Data Viewers 
The Data Conversion Transformation 
Scheduling packages with SQL Server Agent
Managing packages with SQL Server Management Studio 
The Variables window 
Configuration Overview 
The Slowly Changing Dimension Transformation 
SSIS for DBAs: Using SQL Server Management Studio
SSIS system variables 
Configuring Package Logging 
SSIS Package Architecture Overview 
The WMI tasks 
Using variables to pass information between packages 
Configurations and deployment 
Database Maintenance Plans 
The Properties window 
Launching BIDS 
Advanced Data Flow
The SSIS menu 


• See Training Course Details...

---

Microsoft SQL Server 2008 Analysis Services SSAS

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• In this two day course participants learn how to use Microsoft SQL Server 2008 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2008 developer the tools to build data cubes and forecasting solutions. This course also provides information on end-user tools including Microsoft Excel 2007, Office Visio 2007 Professional Edition, SQL Server Business Intelligence Development Studio (BIDS) Microsoft SQL Server 2005 Integrated Services and Reporting Services.

• Some of the training topics covered include ...
Review Microsoft Office SharePoint Server 2007
Advanced SSAS
Implement SSIS to Manage SSAS Datbases
Intermediate SSAS
MDX Expressions
Design Reports by using Report Builder
Review Semi-Additive Measures in OLAP Cubes
Using SSAS in BIDS
Understand Performance Tuning and Optimization
Understand Dimensional Modeling (stars and snowflakes)
Understand Basic MDX Syntax
Understand Data Mining Concepts
Create Data Sources
Explore how to add MDX Script Commands
Understand Writeback in Dimensions
Implement XMLA Scripts in SSMS


• See Training Course Details...

---

Microsoft SQL Server 2008 Integration Services SSIS

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• This two day course will enable technology professionals with little or no ETL experience to be comfortable and productive with the SSIS tools and technologies. In this course you will learn about the Business Intelligence Development Studio (BIDS) and working with Control and Data Flows to build workflows to extract, transform, and load data using a variety of data sources, transformations, and destinations. You will also become familiar with SSIS package management and package deployment along with learning to write solid code using debugging, error handling, and logging techniques.

• Some of the training topics covered include ...
Exploring and Executing an Integration Services Package in BIDS 
Exploring and Executing a Package Outside of BIDS 
Best Practices for Package Development and Design 
Overview of Package Management 
Using Containers 
Variables and Configurations
Going Beyond ETL
Best Practices
The Data Flow Task 
Installing a Package 
Best Practices for Using Integration Services 
Control Flow
Migrating and Maintaining SQL Servers with Integration Services 
Executing Packages 
Handling Errors and Debugging 
Working with Windows Management Instrumentation
Scripting in Data Flows with the Script Component 


• See Training Course Details...

---

Microsoft SQL Server 2012/2014 Analysis Services SSAS

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• This intensive instructor-led course is intended for IT professionals who are interested in quickly learning how to utilize an Analysis Services multidimensional or tabular solution. This course also discusses how to use the Analysis Services development tools to create both multidimensional and tabular projects, and follows with explanations on how to use the management and administrative tools to manage both Analysis Services solutions.

• Some of the training topics covered include ...
Exploring Security
Creating a Cube
Relating with Relationships
Understanding the Tabular Model
The Multidimensional Solution
Understand and utilize security.
Utilizing Data Sources and Data Source Views
Analysis Services Installation and Architecture: One Product, Two Models
Introduction to Microsoft SQL Server Analysis Services
Handling Hierarchies.
Deploying
Managing Measures
Dissecting with Dimensions
Querying the Solution and Understanding DAX
Understanding Perspectives
The Tabular Solution
Creating a Tabular Project
Measures and Measure Groups
Examining Deployment Options


• See Training Course Details...

---

Microsoft SQL Server 2012/2014 Integration Services SSIS

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• This two day intensive course introduces SQL Server Integration Services using the SQL Server 2012 or 2014 versions. No prior knowledge of Integration Services is assumed.

• Some of the training topics covered include ...
Utilizing Sequences in a Container
Understanding Variables
Examining the Transformation and Other Tasks Variables, Parameters and Expressions
Utilizing the Import/Export Wizard
Using the Best Practices Debugging SQL Server Integration Services Packages
Utilizing Connection Managers SQL Server Integration Services Tasks
Understanding Packages
Handling Errors Common SQL Server Integration Services Design Patterns
Utilizing Container Loops Performing Joins
Using the Workflow Tasks
Coding the Script Task
Define and Use Variables and Parameters
Working in the Explore Window
Optimizing Sources for Extraction
Utilizing SQL Server Integration Services Data Typing
Understanding Deployment Strategies 
Performing Joins with the Merge Transformation
Looping and Sequence Tasks
Working with Advanced Logging and Reporting
Choosing the Script Task or Script Component
The SQL Server Integration Service


• See Training Course Details...

---

Microsoft SQL Server 2016 Report Builder SSRS

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• Aimed at Data Analysts and SQL users this instructor-led course provides participants with the necessary knowledge to develop reports using Microsoft SQL Server 2016 Report Builder. The course covers Report Builder wizards, basics of report design, report parameters, report expressions, filters, report visualisations including graphs, charts, images and gauges. The course also covers the use of maps, interactive reports, report parts, sub reports, subscriptions and exporting options.

• Some of the training topics covered include ...
Examining Parameters
Utilizing Dynamic Headers and Footers
Examining Management
Exploring the Report Builder Interface
Visualizing Your Company Report Templates
Exploring Matrix
SQL Server 2016 Report Builder Wizards
Filtering, Grouping, and Sorting
Working with Expressions
Using Tables
Understanding Variances Between SQL Versions
Exploring Table or Matrix Wizard
Utilizing Charts
SQL Server 2016 Report Builder Graphics
Planning Your Reports
Understanding Report Parts
Exploring Subscriptions
Utilizing Chart Wizard
Using the List Object to Combine Other Items


• See Training Course Details...

---

Microsoft SQL Server 2016/2017 Analysis Services SSAS Multdimensional Modelling

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• This intensive two day course is intended for SQL professionals and business intelligence professionals. The course covers the use of Analysis Services development tools to create and deploy multidimensional SSAS projects.

• Some of the training topics covered include ...
Deploy Model Solutions Using XMLA
Work with Diagrams in Data Source View Designer
Explore Data in a Data Source View
Define Logical Relationships in a Data Source View
Delete a Data Source
Define a Data Source View
Attach and Detach Analysis Services Databases
Supported Data Sources
Use a Template to Create an Action Deployment
Add a Standard Action
Edit or Delete Partitions Merge Partitions
Batch Processing Remote Processing
Deploy Model Solutions with the Deployment Utility
View the XML for an Analysis Services Project Data Sources
Create Measures and Measure Groups
Authorizing access to objects and operations
Deploy Model Solutions Using the Deployment Wizard
Modify or Delete in Solution Explorer Database Dimensions
Deploy Analysis Services Projects
Test an Action
Document and Script an Analysis Services Database


• See Training Course Details...

---

Microsoft SQL Server 2016/2017 Analysis Services Tabular Modelling

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• A two day intensive course detailing how to create, deploy, use and manage tabular models in Microsoft SQL Server Analysis Services (SSAS) 2016 – 2017. The course is aimed at Data Analysts and SQL professionals.  No prior knowledge of SSAS is assumed.

• Some of the training topics covered include ...
Create and Manage Partitions in the Workspace
Row filter mappings
DirectQuery Mode
Create and Manage Tabular Model Partitions
Create a Calculated Column
Impersonation
Set the Data Type of a Column
Define partitions in DirectQuery models
Create a New Tabular Model Project
Data sources supported in SSAS tabular 2017
Test a model in DirectQuery mode
Restore from Power Pivot
Tabular model designer
Import from Analysis Services
Analyze a tabular model in Excel Deploy tabular model solutions
Delete Relationships
Import data by using a native query
Specify Mark as Date Table for use with Time Intelligence
Manage Roles by using SSMS


• See Training Course Details...

---

Microsoft SQL Server Reporting Services SSRS 2016

• 3 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• This three day intensive course will give delegates a comprehensive understanding of how to design and publish parametrised reports, manage permissions, schedule automated reporting and configure report caching. The course also demonstrates how to build reports designed for tablets and mobile devices.

• Some of the training topics covered include ...
Use report services configuration manager to reconfigure SSRS servers.
Preparing data for mobile reports
Report caching, snapshots, and comments
Using Datasets Creating Paginated Reports
Sorting and grouping
Overview of mobile reports
Configuring data access with report designer
Topics include Introduction to Reporting Services
Reporting services tools Reporting Services Data Sources
Publish a report to reporting services Working with Reporting Services Data
Use databars, sparklines, and indicators in reports Summarising Report Data
Extend reporting services functionality with external assemblies.
Drilldown and drill through Sharing Reporting Services Reports
Report subscription and delivery Administering Reporting Services
Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
Formatting data
Secure access to reports by using authentication, permissions, and SSL encryption.
Introduction to reporting services
Configuring data access with report builder
Data filters
Creating a report with the report wizard


• See Training Course Details...

---

Oracle Business Intelligence - Create Reports and Interactive Dashboards

• 3 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• Oracle Business Intelligence (BI), formerly known as Siebel Business Analytics, empowers business users with sophisticated data analytic capabilities without any knowledge of database structures or the SQL database language. This training course will guide students through all of the features available from the product to allow one to build sophisticated dashboards and reports.

• Some of the training topics covered include ...
Using the Dashboard Editor
Column Formatting
Column Selector View
Logical Data Models
Chart View
Creating a New Request
Ticker View
Saving and Reusing Filter Settings
View Selector View
Navigating the Answers Interface
A Pivoting Scenario
Set Operations
Databases and Data Models
Controlling the Report Definition
Warehouse Models and Schemas
Sorting Data
Totals within Pivot Tables Advanced Formatting
Using Dashboard Prompts
Using Prompts to Filter Data
Pivot Table Concepts
OLAP, BI, DSS Introduction to Oracle BI Answers and Dashboards


• See Training Course Details...

---

Oracle PL/SQL

• 3 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• This three day course gives participants a sound understanding of working with Oracle PL/SQL. The courses assumes no prior programming knowledge and is hands on in character.

• Some of the training topics covered include ...
Declaring Variables 
Stored Functions and SQL 
Passing Parameters and Default Arguments 
Maintaining PL/SQL Code 
External LOBs 
Maintaining Stored Programs
The Package Interface and Implementation 
Compile-Time Warnings 
Row-Level Triggers 
Cursor Parameters 
Associative Array Collections 
Procedures and Functions 
Triggers on Views 
PL/SQL Stored Program Compilation 
Cursors 
Other Supplied Packages
PL/SQL Blocks and Programs 
FORALL Statement 
Datatypes 


• See Training Course Details...

---

Oracle SQL

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• A two day intensive course familiasing participants with the use of SQL in an Oracle context. SQL statements will be written and executed using a number of Oracle environments including SQL* Plus and Oracle SQL Developer.

• Some of the training topics covered include ...
SQL Queries 
Views 
Pattern Matching: LIKE and REGEXP_LIKE 
Datatypes 
Compound Expressions 
The CASE...WHEN Expression 
Relational Database Management Systems 
Numeric Functions 
Introduction to SQL 
Data Definition and Control Statements 
Explicit Locking 
The DELETE statement 
Modifying Table Definitions 
Other Database Objects 
Subqueries 
Using SQL Functions 
Constraints 
The UPDATE Statement 
Logical and Physical Storage Structures 


• See Training Course Details...

---

PHP

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• A two day intensive course introducing PHP and equipping candidates with the skills necessary to build PHP driven dynamic web sites. Participants should have a sound knowledge of HTML.

• Some of the training topics covered include ...
Authentication with Session Control 
Processing Form Input 
Managing Data 
Directory Functions 
Advantages and Disadvantages of PEAR DB 
mail() 
The php.ini File 
require 
magic_quotes_gpc 
User Functions 
Working with Loops 
Getting File Information 
String Manipulation 
PHP Tags 
Magic Quotes
Regular Expression Syntax 
while 
Enumerated Arrays 


• See Training Course Details...

---

PowerPoint Advanced

• 1 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• Microsoft PowerPoint - Advanced Level is designed for users who are keen to extend their understanding and knowledge of the software beyond creating basic presentations.

• Some of the training topics covered include ...
Applying a Theme
Formatting Table Data
Editing a Data Series
Co-Authoring Documents
Understanding Online Pictures
Formatting Media Clips
Modifying a Template
Inserting a Chart Using the Ribbon
Saving to a Storage Device
Using an Existing Template
Applying a Table Style
Creating a Custom Show
Animating SmartArt Graphics
Creating Custom Theme Colours
Adjusting Row Heights
Applying Shading
Understanding the Chart Format
Inserting Rows and Columns


• See Training Course Details...

---

PowerPoint Basic

• 1 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• The skills and knowledge acquired in Microsoft PowerPoint Basic Level are sufficient to be able to create real-world slide shows. You will learn how to create, print and publish presentations.

   

• Some of the training topics covered include ...
The Save As Dialog Box
Printing Handouts
Changing the Slide Layout
Accessing the Help Window
Creating a Hyperlink to Another
Customising the Status Bar
Creating Presentations in PowerPoint
Navigating a Presentation
Preparing for Presentations
Opening Multiple Presentations
Changing the Office Theme
Brilliant Presentations
Editing Shapes
Inserting a Title and Content Slide
Applying a Colour Scheme
Working With Text
Copying Shapes
Understanding Presentation Views
The PowerPoint Screen


• See Training Course Details...

---

SQL

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• This short intensive SQL (Structured Query Language) course assumes no prior knowledge. Candidates will learn how to write SQL queries which can extract filtered, grouped and aggregated data from a relational database. The course also covers creating tables, views, updating, inserting and deleting data. This course focuses on core SQL which is applicable to almost all database platforms.

• Some of the training topics covered include ...
Selecting Specific Columns
The LIKE Operator
Simple SELECT Statements
Aliases
Common Date Functions Subqueries, Joins and Unions
Order of Evaluation Advanced SELECTs
Columns
Using CASE Inserting, Updating and Deleting Records
Sorting By Column Position
The WHERE Clause and Operator Words
Checking Multiple Conditions
Mathematical Calculations
Table Aliases
Creating Tables
Dropping Stored Procedures
Data Types
Selecting Distinct Records
WHERE and ORDER BY


• See Training Course Details...

---

SQL Server 2005 Reporting Services SSRS

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• This is a two day course which equips participants with the skills necessary to effectively use SQL Server 2005 Reporting Services. Enable Technology also run a comparable two day Reporting Services 2000 training course.

• Some of the training topics covered include ...
SQL Server Management Studio Overview
Using Reporting Services 2005 Expressions
Reporting Services 2005 Windows
The Reporting Services 2005 Report Designer
Query tab
The Main Components of the Design Environment
Data Output
History Properties
Reporting Services 2005 Deployment Options
Tools for Managing Reports
Security
Configure and Run the Job Package
Report Toolbar
Creating Formulas
Understanding Users and Groups
Interactive Sort
Default Folder Structure
Chart Types


• See Training Course Details...

---

SQL Server 2008 Reporting Services SSRS

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• A two day intensive course introducing the comprehensive range of SQL Server Reporting Services 2008 report writing and deployment features.

• Some of the training topics covered include ...
Discover interactive sorting 
Explore the storing of credentials within a data source 
Explore how to create expressions in your reports using 
Find out how to create drill-down reports 
Explore the potential deployment and security issues that might arise when working with custom assemblies 
Discover the classes and methods exposed by the Reporting Services Web Service API 
Learn how to calculate group totals and percentages 
Dig into the use of unbound, multivalued, and cascading parameters 
Explore the use of Reporting Services gauges 
Creating Matrix Reports and Charts
Learn how to format report items using the formatting toolbars, the Properties window, and the Textbox Properties dialog box 
Learn how to enable and control report caching 
Explore the basic architecture of SQL Server Reporting Services 
Learn about report variables and when you might need to use them 
Learn how to enable basic authentication for reports and how to require SSL for report operations 
Discover how to improve parameter prompts using drop-down list parameters 


• See Training Course Details...

---

SQL Server Data Warehouse Implementation

• 3 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• Participants will learn to perform ETL (Extraction Transformation and Loading) operations by creating SSIS packages, managing a control flow and data flow, executing packages, and troubleshooting errors. To ensure the smooth functioning of the ETL operations, you will manage SSIS packages and secure them. Delegates will use SSIS packages to design and build a Data Warehouse.

  The course requires a working knowledge of SQL.

• Some of the training topics covered include ...
Examine MSI Packages
Deploy SSIS Packages
Securing Packages and Databases
Change Granularity Creating Fact Tables and Columnstore Indexes
Cleanse Data Using DQS Managing SSIS Package Execution
Configure MDS
Install Integration Services Working with Integration Services
Create an SSIS Project
Add Packages to an SSIS Project Managing Control Flow
Debugging and Troubleshooting Packages
Profile OLTP Data
Perform Transformation Tasks
Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
Add Script Tasks and Script Components to an SSIS Package
Execute Packages from Different Control Flow Working with Dynamic Variables
Overview of Data Warehouse Components
Debug Package Execution Components
Work with Windows Azure
Deploy a Control Flow
Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
Overview of Data Warehouses


• See Training Course Details...

---

SQL Server Reporting Services SSRS 2012/2014

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• Aimed at Report Writers using SQL Server Reporting Services (SSRS) 2012 and 2014 this intensive two day course demonstrates how to create and deploy parameterised reports using Report Builder and Report Designer. No prior Reporting Services experience is assumed but a reasonable grasp of SQL is essential.

• Some of the training topics covered include ...
Building a List Report Configuring Tablix  Properties and Groups
Create a Shared Data Source and Two Data Sets
Create a Tabular Report  Using the Tablix Report Type
Create a Form-Like Report from a list Calculations Using Expressions And Functions
Report Project Types  Working with Report Server Projects
Indicators
Data Set Parameters
Create a  Parameterised Report
Cascading Parameters
Expression Operators
The Tablix Component
Build a Simple Report
Globals Collection Creating Custom Functions
Drilldown Reports Managing Page Layout and Adding Interactivity
Using Report Parts Shared Data Sets
Formatting Text Boxes in the Properties Window
Building a Matrix Report
Exploring the Tablix Report Type
Sparkline
Setting Report Project Properties
Introduction to Report Builder


• See Training Course Details...

---

Transact SQL

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline

• This two day Transact SQL course introduces delegates to querying and manipulating data in Microsoft SQL Server. The course explores how to write select statements, join tables, create subqueries, write update, delete and insert statements. It differs from the generic SQL course in that if explores Microsoft SQL Server product specific functions and the notation associated with creating Microsoft SQL Server User Defined Functions, Stored Procedures and Triggers.

  The course id practical, hands on and does not assume prior SQL or programming experience.

• Some of the training topics covered include ...
Create Queries to Test Nullability
Overview of SQL Server
Configure Indexes
Work with System Databases
Manage Stored Procedures
Combine Data Using Simple Joins
Work with Grouping Sets Managing Error Handling and Transactions
Work with Date and Time Data Types
Modifying Data
Filter the Queried Results
Work with Table Expressions Working with Set Operators, Conditional Operators, and Window Functions
Getting Started with SQL Server 2012
Work with Set Operators
Manage SQL Server Constraints Writing SELECT Queries
Create Queries Using Built-in Functions
Work with Advanced Functions Working with PIVOT, UNPIVOT, and Grouping Sets
Control Program Flow
Work with T-SQL Statements
Delete Data
Create Queries Using Join Algorithms
Work with String and Numeric Data Types


• See Training Course Details...

---

Visio

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline
• Some of the training topics covered include ...
Windows, stencils, and objects
Customization and reporting
Displaying shape dimensions
Block, tree, and onion diagrams
Getting started
Sharing diagrams using a browser
Drawing tools
Documenting software systems
Special drawing operations
Integration with PowerPoint
Integrating Visio with other programs
Creating a basic diagram
Presentation Mode
Planning a diagram
Layout and connection techniques
Editing objects
Basic shapes and lines


• See Training Course Details...

---

Email us about this courses

---