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 ...
Conditional Running Totals 
Moving and Aligning Objects 
Creating Text Objects 
Understanding Running Totals
Adding Fields into a Text Object
Creating On-Demand Subreports
Declaring a Variable
Cascading Parameter Fields 
Using Parameters in Conditional 
Using the Chart Options 
Modifying Groups 
Using Subreports to Link "Unlinkable" Data 
Passing Data from the Main Report into a Subreport
Format Painter 
Understanding How Crystal Reports 
When and Why to Group Records 
Database Links versus Subreports in One-to-Many Situations
Allowing Multiple Values in Parameters


• 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 ...
Creating an Unlinked Subreport
Formatting Objects 
Processes the Data
Formatting Sections 
Learning about Linking 
Case Sensitive vs. Case Insensitive 
Unlinked versus Linked Subreports
Creating a Summary Report 
The Main Components of the Design 
Assigning a Value to a Variable
Customize Group Name Field 
Getting Help 
Using Group Selection toFilter the Records in the Report
Calculating Percentages 
Creating On-Demand Subreports
Changing Background Colors
Using the Preview Panel 


• 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 ...
Using Parameters in Conditional Formatting
Creating on-demand Subreports
Calculating Percentages
Saving the Report
Adding Multiple Tables to a Report Creating and Using Formulas
Selecting Records with Multiple Criteria
The Template Dialog Box Power Formatting
Performing Simple Number Calculations
Understanding Subreports
Customize Group Name Field
Using Bookmarks to Navigate Through Formulas Conditional Formatting
Sorting with a Parameter
Grouping Data in Date/Time Intervals
The Record Selection Dialog Box
The Formula Editor Toolbar
Browsing Field Data
Using Multiple Parameter Fields in Reports
Using Group Selection to Filter the Records in the Report
Creating a Group
Case Sensitive vs. Case Insensitive
Formatting Objects


• See Training Course Details...

---

Crystal Reports 2016

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

• This two day intensive Crystal Reports 2016 is aimed at report writers. Delegates will learn how to connect to an underlying database and how to design parametrised reports which filter, group and aggregate data. The course will demonstrate how to correctly join database tables, access SQL views and use stored procedures.

  No prior Crystal Reports knowledge is assumed

• Some of the training topics covered include ...
The Chart Dialog Box
Saving the Report
The Template Dialog Box Power Formatting
Using the Sort Control
Modifying Individual Objects in the Chart
Customizing Group Sort Order
Grouping Hierarchically Working with Cross-Tab Reports
Creating Text Objects
The Summaries Dialog Box
The Formula Editor Toolbar
Applying the Drill-Down Feature
Inserting Graphics
Understanding the Formula Evaluation Subreports
Group and Sort Direction
Using Guides and Guidelines to Move and Align Objects
Database Filtering with the Select Expert
Exporting to Windows Applications
Parameter Field Considerations
The Fields Dialog Box
Unlinked versus Linked Subreports
Format Painter


• 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 ...
Guidelines
Formatting Sections
The Summaries Dialog Box
Using a Parameter Field
Changing the Summary Operation
Assigning a Value to a Variable
Pass #3
What are Report Alerts
Understanding Subreports
Using Multiple Sections in Reports
Inserting Graphics
Pre-Pass #2
What Is a Pass
Reordering Groups
Using Parameters in Conditional Formatting
Separating Statements in Complex Formulas
Using the Group Tree to Navigate the Report
Setting the Default Layout for Design and Preview Views Using the Report Wizards
Using a Formula to Customize the Group Name Field
Pass #1
Using the Formula Editor


• 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 ...
Word Wrapping Colors, Gradients, Background Images, and Masks
Rounded Corners
The @font-face Rule
Media Queries
Responsive Images and the viewport Metatag
Transitions Layout: Columns and Flexible Box
Web Accessibility
Frameworks and Grid Systems
Accessibility Features
What Are Vendor Prefixes
The Target Pseudo-Class
Attribute Selectors
Browser Support
Preprocessors
Fonts on the Web
Image Borders
Introducing CSS3
Negation Pseudo-Class
Modernizr
Styling Video


• 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 ...
Microsoft Decision Trees Algorithm
Model Usage
Microsoft Linear Regression Algorithm
Testing and Validation of Mining Models
Creating Reports Using Reporting Services
Microsoft Naïve Bayes Algorithm
Named Queries
Microsoft Logistic Regression Algorithm
Connection
Microsoft Clustering Algorithm
Microsoft Neural Network Algorithm
Cross Validation
Exploring Data
Multiple Nested Tables Microsoft Data Mining Algorithms
Data Mining and Results
Saving Queries
Microsoft Association Algorithm
Accuracy and Validation
Types of Data Mining Algorithms


• 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 ...
Video Formats
A Simple Example
Media Queries
JavaScript Implementation
Hiding Browser UI
Flexible Background Images
Consolidating the Web with Native Extensions
jQuery Mobile
Consolidating the Web with Native Extensions
Responsive Design: Good for All Devices
Google Maps
Flexible Images and Other Media
PhoneGap
The Case for Flexible
Integrating with the Home Screen
Browser and Device Support
Media Queries


• 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 ...
Setting Save Options
Using Database Functions
Finding the Difference From
Copying Validation Settings Controls
Defining the PivotTable Structure
Linking Between Worksheets
Grouping in PivotTable Reports
Setting Advanced Options Protecting Data
Sorting in a PivotTable PivotCharts
Password Protecting a Workbook
Setting Formula Options
Clearing a Report Filter
Providing Restricted Access to Cells
Setting Macro Security
Providing Total Access to Cells
Disabling Worksheet Protection
Creating Your Own PivotTable
Linking Between Workbooks
Working With Connected Data Unlinking Connections
Consolidating With Identical Layouts
Creating a Default Scenario


• 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 ...
Vertical Cell Alignment
Printing a Help Topic
Understanding Workbooks
Getting to Know Excel
Understanding Lists
Setting the Default Column Width
Embedding a Chart Into a Worksheet
Formulas That Multiply and Divide
Changing Background Colours
Understanding Data Editing
Typing Numbers
Choosing the Right Chart
Approximating Row Height
Multiple Value Filters
Selecting Non Contiguous Ranges
Calculating an Average
Setting Precise Row Heights Working With a Worksheet
Viewing the Formula Bar
Editing Longer Cells
Understanding Font Formatting
Opening an Existing Workbook


• 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 ...
Using the More Borders Command
Adding Axes Titles
Applying a Border to a Cell
Using Shape Styles
Using Names to Select Ranges
Repositioning the Legend
Formatting the Drawing Pencil Essential Functions
Defining Names for Constant Values
Splitting a Table
Changing Column Colour Schemes
Formatting
Using IF With Numbers
Creating a Custom Fill List
Top Ten Items
Adding More Complexity
Understanding Quick Analysis
Understanding Borders
Understanding Tables
Filling a Series
Formatting Cells Containing Values
Renaming a Table


• 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 ...
Power Pivot
Working With Time Settings
Creating a Data Model PivotTable
Tiling Data in Power View
Formatting Power View Data
Working With Mapping Confidence
Understanding Power Pivot
Working With Location Fields
Navigating a Data Map
Changing a Power Pivot View
Working With Height and Category
The Advanced Editor
Rearranging and Sorting Fields
Working With Scene Options
Connecting to a Data Source
Using Related Power Pivot Fields
Working With Data Model Fields
Editing Query Steps
Power View
Adding More Power Views
Enabling Power Pivot


• 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 the Err Object
Using Break Mode during Run mode
Understanding Objects
Calling Procedures
Working with Procedures and Functions
Writing an Error-Handling Routine
Understanding Data Types
Using Expressions, Variables, and Intrinsic Functions
Working with the Code Editor
Saving a Macro-Enabled Workbook
Using Input Boxes
Working with the Text Box Control
Using the With Statement
Creating a Standard Module
Understanding UserForms
Displaying the Developer Tab in the Ribbon
Understanding Procedures
Working with the Command Button 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 ...
Closing Tags
Whitespace
Grouping
Select Menus
Start Attribute
Phrase Elements
Absolute vs. Relative Paths
Getting Started
Paragraphs
Creating Tables
The HTML Skeleton
Quoted Text
Radio Buttons
Anchors
Some XML Stuff Paragraphs, Headings and Text
Targeting New Windows
Attributes
Inches (in), Centimeters (cm), and Millimeters (mm)
Email Links
The title Attribute HTML Images
Points (pt)


• 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 ...
novalidate
The HTML5 Spec(s)
HTML5 Forms
HTML5 and JavaScript
required
New Form Elements
Offline Application API
Indexed Database API
HTML5 New Form Attributes
Colour and Transparency
The HTML5 Way
Audio Formats
autocomplete
Modernizr


• 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 ...
Validating Checkboxes
ParseFloat() and parseInt()
Image Rollovers
typeof Operator
JavaScript Objects, Methods and Properties
Methods
for Loop Syntax
Validating Select Menus
JavaScript Syntax
Built-in Functions vs Methods
Arrays
JavaScript Basics
String(object)
Switch / Case
Storing User-Entered Data
Dot Notation
Properties
Validating a Registration Form


• 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 ...
Manipulating Elements
Working with Selections
Key Concepts
Conditional Variable Assignment with the Ternary Operator
Attributes
A Is for Asynchronous
Detach Elements to Work with Them
$.fn.toggle
The for Loop
The Module Pattern
The while Loop
Using RequireJS with jQuery
Basic Operators
Finding and Evaluating Plugins
Plugins-
Manipulating Attributes
jQuery Core-


• 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 ...
Sending Emails
Progressive Enhancement
Using Others' Plugins
Overview
Sliders
Creating Your Own Plugin
PhoneGap
Making Calls
Data-role
plugin Architecture
HTML5 and CSS3 Getting Started with jQuery
Themes and Swatches
Lists and Buttons
Levels of Support
Video The Theme Framework
Virtual Integration with the Phone
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. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.

• Some of the training topics covered include ...
Adding Records to a Table
DIY Forms
Creating a Lookup Database
Navigation Pane Protection
Relational Database Design
Creating a Relational Database
Action Queries
Sorting and Filtering
Aggregation Queries
Multi Table Queries
Database Security
Creating and Using Reports
Calculations in Queries
Creating and Using Forms
Parameter Queries
Creating and Using Macros
Designing a Lookup Database
Macro Techniques
Data Validation
Querying Techniques
Working With Records


• See Training Course Details...

---

Microsoft Access Programming Using VBA

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

• This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.

• Some of the training topics covered include ...
Using the Do...Loop Structure
Trapping Errors with the On Error Statement
Considering Variable Scope and Lifetime Together
Working with the ADODB Recordset Object
Using Visual Basic Help
Introduction to Programming in Access
Locking Records for Updating
Creating a Sub Procedure
Understanding Collections
Writing an Error-Handling Routine
Organizing Code and Procedures
Understanding Expressions and Statements
Specifying a Recordset Cursor Type
Understanding Errors
Working with the Application Object
Understanding Control-of-Flow Structures
Using Expressions, Variables, and Intrinsic Functions
Setting Breakpoints
Using the For...Next Structure
Understanding the DoCmd Object


• 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 ...
Understand and utilize merges. LOADING YOUR DATA
Combining Worksheets
Grouping Options
Using Ranges in Excel
Data Sources GROUPING AND SUMMARISING WITH POWER QUERY
Loading into Power BI Desktop
Using PivotTables CONNECTING TO DATABASES
Loading Data
Working with Folders and Files
Understanding the Issues
Understand Power Query formulas.
Loading into Power Pivot
Understand working with relational data.
Transforming Data
Understand the M interface.
Summarising WORKING WITH THE POWER QUERY LANGUAGE “M”
Loading into Excel
Course topics include- INTRODUCTION TO POWER QUERY
Understand and perform importing from SQL Server Analysis Services Tabular. PERFORMING MERGES
Appending Operations
Understanding Data Types WORKING WITH CSV, TXT AND EXCEL WORKSHEETS


• 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 ...
Text Functions
Many-to-Many Relationships
Filter Functions
Utilizing Operators
Mathematical Functions
Using Multiple Calendars Utilising Advanced DAX Functionality
Multiple Table Evaluation Context Working with Dates
Working with Calendars
Conversion Functions
Aggregation Functions
Statistical Functions
Date Functions
Explaining Syntax
Introduction to DAX
The CALCULATE Function
Relational Functions Understanding Evaluation Contexts
Single Table Evaluation Context
Handling Errors Using DAX Functions
PowerPivot Data Model
Understanding Values


• 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 ...
Using databases as a data source for Power BI
Power BI desktop queries
The Power BI Interface
Managing a Power BI solution
Using Excel as a data source for Power BI
Using the Power BI mobile app
The developer API
Overview of the Power BI Data Model. Using Power BI
Understand the DAX syntax and use DAX functions to enhance your dataset.
Power BI embedded
Combine data together from tables in your dataset. Modeling data
Create a Power BI dashboard
Viewing reports from Excel files Shaping and Combining Data
Use Power BI direct connectivity to access data in Azure SQL data warehouse
Connecting to Power BI data
Direct connectivity from the Power BI service
Importing different data sources into Power BI
Creating Power BI reports
Use Power BI with SQL Server Analysis Services data, including Analysis services models running in multidimentional mode. The Developer API
Importing data into Power BI
Shape data using formatting and transformations.


• 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 ...
Hierarchies
Drill Through
Applying Filters
Working with Tables
Add time to a presentation.
Configuring Drill Through
Examine map data.
Importing Data with a Query
Utilizing DAX Functions
Configure tours, scenes, and layers.
Perform data cleaning.
Creating a Cascading Relationship
Aggregations
Hiding Columns, Change Data Type, Sorting, and Filtering
Utilise data sources.
Utilize themes.
Load data.


• 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 ...
Enhancing Report Appearance
Components Graphical Reports
Testing a Formula
Entering Cost Resources
Linking to an External Pool
Understanding Task Durations
Modifying a Formula
Understanding Resources
Using a Custom Project Template
Understanding Effort Driven
Running a Localised Macro  
Tasks and Resources
Modifying a Schedule Using
Understanding Visual Reports
Changing Time Periods
Creating Custom Fields
Working With Effort Driven Tasks
Creating a Custom Combination View
Setting Up Project Information
Showing Tiers


• 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 ...
Working With Calendars
Gantt Chart View
Examining Task Information
Entering Milestones
Modifying the Standard Calendar
Printing Tasks for Resources
Assigning Resources You Do Not Have
Setting Up Project Information
Viewing the Critical Path
Entering Task Durations
Creating a New Task Calendar
How Project Works
Using the Ribbon
Changing Calendar Options
Creating Dependencies in Task Entry
Assigning Part Time Resources
Understanding Printing
Working With Fixed Unit Tasks
Working With Split Screens
Entering Tasks
Printing a Help Topic


• 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 ...
Basic Data Highlighting
Saving an Existing View
Changing Gantt Chart Styles
Changing Work Effort
Assigning Daily Costs
Printing Specific Dates and Pages
Using Custom Views
Entering Delayed Tasks
Exploring Tables
Modifying Specific Tiers
Changing Text Styles
Assigning Per Usage Costs
Using Print Preview
Tracking Actuals On A Gantt Chart
Viewing Task Slippage Project Views
More Highlight Filters
Setting Page Breaks
Editing Existing Filters
Assigning Material Costs
Adding To A Material Assignment
Understanding Gantt Chart Bars


• 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 ...
Combining Projects
Running a Macro
Manipulating Report Data
Checking for Resource Links
Breaking Subproject Links
Creating WBS Codes
Template Project Templates
Exporting to Excel Using a Map
Saving a Visual Report as a Template
Opening Shared Resource Projects
Creating Custom Fields
Editing Custom WBS Codes Custom Views
Creating a Formula in a Custom Field
Creating a Custom Group for the View
Copying Table Data
Applying a Newly Organised Item
Creating the Downsized Master File
Recording a Macro
Syncing Tasks With SharePoint
Understanding Project Templates


• 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 ...
Understanding fact (measures) and cube modeling 
SQL RS & Report Builder 
Examples of using each of the 9 algorithms (MS Clustering, MS Decision Trees, Naïve Bayes, MS Sequence Clustering, MS Time Series, MS Association Rules, MS Neural Network) 
Report Center (type of dashboard) uses KPIs, Reports, Excel Web, Filter 
Creating cubes - using the UDM and the Cube Build Wizard 
Using the Add Business Intelligence Wizards - write-back, semi-additive measures, time intelligence, account intelligence 
Modeling M:M dimensions, Fact (degenerate) dimensions, Role-playing dimensions, writeback dimensions 
What Is Microsoft BI? 
Business Scorecards 2005 & ProClarity 
SSAS Administration 
Translations - cube metadata and currency localization 
Modeling intermediate fact tables 
KPIs 
Demonstration of SQL Reporting Services with cube as data source 
Adding calculated members 
Advanced Storage Design - MOLAP, ROLAP, HOLAP 
SPS RS web parts & .NET 2.0 report viewer controls 


• 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 ...
The WMI tasks 
The Slowly Changing Dimension Transformation 
The deployment utility 
Changes in SQL Server 2005 Service Pack 2 
The Sort Transformation 
Advanced Control Flow
Script in Control flow: The Script Task 
Database Maintenance Plans 
The Copy Column Transformation 
Variables and Configurations
The Analysis Services tasks 
SSIS system variables 
Property expressions 
Data Transformations 
The File System Task 
Data Flow Overview 
Configuration discipline 


• 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
View a Cube by using Excel
MDX Expressions
Implement SSIS to Manage SSAS Datbases
Understand the Calculation Subtab
Explore how to add MDX Script Commands
Intermediate SSAS
Discover how to add .NET Assemblies
Review Semi-Additive Measures in OLAP Cubes
Implement Excel 2007 Pivot Tables and Charts
View a Cube by using SQL Reporting Services
Understand Performance Tuning and Optimization
Understand the Cube Structure
View Aggregation Designs
Discover how to Create Perspectives
Define Business Intelligence
Review the Algorithms that SSAS Includes
Cube Storage and Aggregation
Understand Common MDX Functions and Tasks
Explore Scalability Options


• 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 ...
Error Handling and Logging 
Data Flow Best Practices 
Executing Packages 
Data Viewers 
Configurations 
Create a Package Deployment Utility 
Exploring and Executing a Package Outside of BIDS 
Advanced Data Flow
Understanding Variables 
Working with Analysis Services 
Best Practices
Deployment and Management Best Practices 
Using Integration Services Beyond ETL 
Handling Slowly Changing Dimensions 
Understanding Integration Services 
Migrating and Maintaining SQL Servers with Integration Services 
Using Variables in Control Flow 


• 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 ...
Analysis Services Installation and Architecture: One Product, Two Models
Utilizing Translations
Analysis Services Tools.
Creating a Cube
Developing Dimensions
Processing Strategies
Maintaining and Optimizing
Managing Measures
Browsing the Model
Deploying
Measures and Measure Groups
Utilizing Data Sources and Data Source Views
The Multidimensional Solution
Deploying
Browsing Perspectives and Translations
Dissecting with Dimensions
Relating with Relationships
Deploy a multidimensional model.


• 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 ...
Performing Joins with the Lookup Transformation
Administration of SQL Using the SQL Management Objects Tasks Data Flow
The SQL Server Integration Service
Examining the Transformation and Other Tasks Variables, Parameters and Expressions
Data Loading with the Analysis Services Tasks
Overview of Containers
Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages
Using the Best Practices Debugging SQL Server Integration Services Packages
Working with XML
Choosing the Script Task or Script Component
Looping and Sequence Tasks
Utilizing Sequences in a Container
Utilizing Container Loops Performing Joins
Managing with Control Flow
Using Package Hierarchies: Parent Child
Examining the SSIS Engine
Define and Use Variables and Parameters
Coding the Script Task
Working with Advanced Logging and Reporting
Understanding Parameters SQL Server Integration Services Tools
SQL Server Integration Services Architecture


• 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 ...
Using Tables
Exploring the Report Builder Interface
Utilizing Charts
Examining Management
Exploring Table or Matrix Wizard
Examining Maps
SQL Server 2016 Report Builder Basic Reports
Understanding Report Parts
Working with Map Wizard
Exploring Gauges
Utilizing Dynamic Headers and Footers
Utilizing Data Sources
Mastering Data Region(s)
SQL Server 2016 Report Builder Advanced Reporting
Examining Security
Understanding Visualizations
SQL Server 2016 Report Builder Graphics
Utilizing Chart Wizard
Utilizing Lists


• 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 ...
Define a Regular Relationship and Regular Relationship Properties
Create Named Sets
Define Logical Primary Keys in a Data Source View
Define Assignments and Other Script Commands
Create a Time Dimension by Generating a Time Table
Test an Action
Move an Analysis Services Database
Create User-Defined Hierarchies
Defined Linked Measure Groups Partitions
Define a Referenced Relationship and Referenced Relationship Properties
Tools and Approaches for Processing
Cube or model permissions Process permissions
Configure Analysis Services Project Properties
Authorizing access to objects and operations
Using SQL Server Data Tools (SSDT)
Replace a Table or a Named Query in a Data Source View
Set Impersonation Options for a Data Source Connection
Deploy Analysis Services Projects
Delete a Data Source View Dimensions
Backup and Restore of Analysis Services Databases
Change a Partition Source


• 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 ...
Data sources supported in SSAS tabular 2017
Delete a Column
Create a Calculated Column
Create and Manage Partitions in the Workspace
Create and Manage Perspectives Translations Roles
Analyze in Excel
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Enable DirectQuery mode in SSDT
Data sources supported in SSAS  tabular 2016 Create Tabular Models
Data sources supported in tabular 1200 models
Filter Data in a Table Relationships
Create a Calculated Table
Process Database, Table, or Partition
DAX formula compatibility in DirectQuery mode Tables and Columns
Sort Data in a Table
Import from Power Pivot
Create a Relationship Between Two Tables
Impersonation
Create and Manage Hierarchies Partitions


• 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 ...
Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
Implementing report filters and parameters Visualizsng Data with Report Services
Reporting services components
Drillthrough in mobile reports
Drilldown and drill through Sharing Reporting Services Reports
Use report services configuration manager to reconfigure SSRS servers.
Overview of mobile reports
Add a drillthrough to a custom URL
Secure access to reports by using authentication, permissions, and SSL encryption.
Using Datasets Creating Paginated Reports
Report parameters
Create a report using report builder or report designer.
Topics include Introduction to Reporting Services
Creating a report with the report wizard
Publish a report to reporting services Working with Reporting Services Data
Use databars, sparklines, and indicators in reports Summarising Report Data
Databars, sparklines, indicators, gauges, and maps
Sorting and grouping
Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
Data filters
Mobile report publisher


• 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 ...
No Results View Using Pivot Table Views
OLAP, BI, DSS Introduction to Oracle BI Answers and Dashboards
Understanding the Dashboard Structure
Oracle BI Architecture
About Business Intelligence
Managing the Views Using Secondary Views
Totals within Pivot Tables Advanced Formatting
Pivot Table Concepts
Sections and Pages
Navigating the Answers Interface
Saving and Reusing Filter Settings
Prompts Column Formatting
Previewing the Answers
Defining the Pivot View
BI and Presentation Catalog Security
Filtering Data
Warehouse Models and Schemas
Transactional Databases
Basic Navigation Using A Dashboard
Filters View


• 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 ...
Nesting Blocks 
Types of Triggers 
Internal LOBs 
PL/SQL Variables and Datatypes 
LOB Locators 
Parameter Modes 
Anchored Types 
Exception Handling
Beyond Declarative Integrity 
Fetching Rows 
Record Variables 
Large Object Types 
Conditional Statements IF/THEN 
Creating a Stored Function 
Records and Collections
Triggers
Oracle Directories 
User-Defined Exceptions 


• 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 ...
Running SQL*Plus Scripts 
SQL*Plus Substitution Variables 
Using SQL Functions 
Datatypes 
Compound Expressions 
Correlated Subqueries 
Date Formats 
Modifying Table Definitions 
The Aggregate Functions 
Grouping Rows 
SQL Functions 
Views 
Intervals 
Joining Tables 
Subqueries 
The SELECT Statement 
Graphical Clients 
Constraints 
SQL Queries - Joins 


• 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 ...
PHP Functions 
Passing Variables on the URL 
Querying a Database 
Authenticating Users 
Regular Expression Syntax 
Looping through Arrays 
Flow Control 
Magic Quotes
Shortcomings of mail() 
Including Files 
Working with String Manipulation Functions 
mysqli Methods and Properties 
String Manipulation 
Working with Enumerated Arrays 
Defining and Calling Functions 
How PHP Works 
PEAR:DB 
Common Characters ( . \d \D \w \W \s \S ) 


• 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 ...
Understanding Themes
Resizing an Image
Chart Elements
Creating Custom Slide Layouts
Setting Up a Speaker-Led Show
Applying Shading
Working With Pie Charts
Co-Authoring Documents
Saving a Customised Theme
Working Collaboratively
Understanding Media in PowerPoint
Templates
Elements
Changing the Theme Colours
About Self Running Presentations
Animating SmartArt Graphics
Creating a Custom Show
Sending a Presentation via Email
Slide Master


• 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 ...
Presentations
Applying WordArt to Text
Presentation
Understanding the Status Bar
Aligning Shapes Using the Ribbon
Inserting a Title Slide
Creating an Internal Hyperlink
Presentation Methods and Hardware
Customising the Status Bar
Adding Commands to the QAT
Getting to Know PowerPoint
Application
Creating a Hyperlink to Another
Inserting a Table
Understanding the Start Screen
Inserting Text Into SmartArt
Grouping Shapes
Working With Presentations
Adding Shapes Below


• 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 ...
Sorting By Multiple Columns
DELETE
Table Aliases
The BETWEEN Operator
Dropping Stored Procedures
Checking for Equality
Mathematical Calculations
Conditional Processing with CASE
Using the WHERE clause to check for greater or less than
Sorting Records
Common String Functions
Popular Databases
Creating Tables
Simple SELECT Statements
Primary Keys
Creating Stored Procedures
Selecting Specific Columns


• 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 ...
Navigation
Identifying Field
Using Reporting Services 2005 Expressions
Attributes
Rendering Extensions
Starting SQL Server Business Intelligence Development Studio
Accessing Reports via the Report Manager
Formatting Reporting Services 2005 Reports
Tables Pane
Filters
Previewing Reporting Services 2005 Reports
Creating a Report Model Project
Understand the Report Model Architecture
History Properties
Introduction to Reporting Services 2005
Displaying Parameters in a Report
Data-driven Subscription
The Reporting Services 2005 Key Components
Deploy Sample Reports to Report Server
Understanding System-level Roles


• 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 ...
Understand how to plan and configure for deployment 
Advanced Reporting Services Programming
Investigate the list data region 
Learn about datasets and data regions 
Learn about report variables and when you might need to use them 
Find out how to use Report Manager to manage user accounts and roles 
Investigate the scheduling of report snapshots 
Learn how to create a tabular report from scratch 
Learn how to create data-driven report subscriptions 
Creating Matrix Reports and Charts
Investigate how to call a custom assembly from a report 
Introducing SQL Server Reporting Services
Discover how to create standard report subscriptions 
Investigate how to manage Reporting Services projects using Report Manager 
Learn how to format report items using the formatting toolbars, the Properties window, and the Textbox Properties dialog box 
Managing Reporting Services
Understand scope as it applies to aggregate functions 
Learn how to enable and control report caching 
Master the Reporting Services Grouping pane 


• 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 ...
Execute Packages from Different Control Flow Working with Dynamic Variables
Deploy a Control Flow
Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
Execute SSIS Packages on the Server
Add Packages to an SSIS Project Managing Control Flow
Secure Packages
Introduction to Data Warehouses
Work with Windows Azure
Securing Packages and Databases
Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
Overview of Data Warehouses
Add Script Tasks and Script Components to an SSIS Package
Examine MSI Packages
Add Data Flow Components to a Data Flow Task
Secure Databases Working with MDS and Windows Azure
Examine Data Warehousing Concepts
Work with MDS Databases
Create Package Templates Implementing Data Flow
Install Integration Services Working with Integration Services
Create Expressions with Variables


• 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 ...
Using Parameters with Ad Hoc SQL
Creating a Customer Contact List  Creating Ad Hoc Reports With Report Builder
A Tour of the Report Builder Interface
Null Handling
Creating a Columnar Report
Report Definition Language (RDL)
Create a Custom Function  Managing Page Layout and Adding Interactivity
Providing a Drop-Down List for a Report Parameter
Building a Matrix Report
Setting Report Project Properties
Building a List Report Configuring Tablix  Properties and Groups
Build a Simple Report
User Collection
Tablix Cell Content and Scope Building a Tablix Report
Drilldown Reports Managing Page Layout and Adding Interactivity
Formatting Text Boxes in the Properties Window
Using Unbound Parameters Understanding Report And Data Set Parameters
Report Builder Installation and Execution Options
Shared Dataset Design View  Creating Ad Hoc Reports with Report Builder
Introducing SQL Server Data Tools


• 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 ...
Getting Started with SQL Server 2012
Work with the XML Data Type Sorting and Filtering Data
Create Queries Using Join Algorithms
Work with Data Access Technologies Implementing Stored Procedures
Manage Query Plans
Work with T-SQL Statements
Assign Aliases Using Queries
Work with Variables and Batches
Overview of SQL Server
Insert Data
Create Queries to Test Nullability
Merge Data Working with SQL Server Built-in Functions
Work with PIVOT and UNPIVOT
Modifying Data
Work with Table Expressions Working with Set Operators, Conditional Operators, and Window Functions
Overview of T-SQL
Work with Window Functions
Filter the Queried Results
Work with System Databases
Write CASE Expressions Working with SQL Data Types
Combine Data Using Simple Joins


• See Training Course Details...

---

Visio

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline
• Some of the training topics covered include ...
Basic shapes and lines
Working with links
Drawing scales
Presenting diagrams in Visio and HTML
 Shape behaviors
Windows, stencils, and objects
Documenting software systems
Web site maps
Creating a basic diagram
File and print properties
Formatting text
Custom stencils
Presentation Mode
Sharing diagrams using a browser
Custom shapes and stencils
Integrating Visio with other programs


• See Training Course Details...

---

Email us about this courses

---