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 ...
Managing Resources with Explorers 
Sorting Records within a Group 
Selecting and Sizing Objects 
Inserting Graphics 
Conditionally Formatting Multiple Sections
Inserting Special Fields
Creating a Parameter Field
Reordering Groups 
Creating an Unlinked Subreport
Creating Multiple Groups in a Report 
Summarizing Groups 
Basing Report Formulas or Conditional 
Power Formatting with Multiple Sections
Parameter Field Considerations
Creating a Group 
Conditional Running Totals 
Group and Sort Direction 
Creating a Summary Report 
Using the Section Expert to Work with Sections


• 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 ...
Using Multiple Parameter Fields in Reports
Customizing Cross-Tab Group Names
Using Guides and Guidelines to Move and Align Objects 
The Data Dialog Box 
Formatting
Selecting and Sizing Objects 
Filter Types of the Select Expert 
Calculating Percentages 
Modifying Groups 
Using the Sort Control 
The Fields Dialog Box 
Creating Report Alerts
Formatting Individual Cells
Format Painter 
Passing Data from the Main Report into a Subreport
Processes the Data
Additional Summary Options 
Assigning a Value to a Variable
Conditional Running Totals 


• 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 ...
Creating a Dynamic Value List
The Main Components of the Design  Window
Using the Parameter Panel
Choosing a Data Source
Group and Sort Direction
Starting the Crystal Reports Program
The Formula Editor Toolbar
Using Multiple Parameter Fields in Reports
Modifying Individual Objects in the Chart
Using the Group Tree to Navigate the Report
Starting a New Report
The Record Selection Dialog Box
Working with the Page Commands
Formatting Charts
Viewing and Editing the Select Formula
The Template Dialog Box Power Formatting
Customizing the Cross-Tab Format
Sorting Records within a Group
Formatting Sections
Creating Multiple Groups in a Report
Record Selection Formula Templates Grouping and Sorting Data


• See Training Course Details...

---

Crystal Reports 2016

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

• By the end of this short intensive Crystal Reports 2016 course participants will be able to create well laid out reports which displays data from multiple database sources. Delegates will able to use conditional formatting, filter, sort, group and aggregate data, use parameters and write formulas. The course is aimed at report writers and developers and assumes no prior Crystal Reports experience.

• Some of the training topics covered include ...
Exploring the Toolbars
Calculating Percentages
Creating Custom Groups
Using the Group Tree to Navigate the Report
Understanding Running Totals
Creating Hyperlinks Creating Powerful Groups
Conditional Running Totals Prompting with Parameters
Reordering Groups
Customizing Cross-Tab Group Names Report Alerts
Understanding How Crystal Reports Processes the Data
Formatting Objects
Filter Types of the Select Expert
Record Selection Formula Templates Grouping and Sorting Data
Importing a Pick List
Previewing the Report
Quick Formatting with the Template Expert
Modifying Individual Objects in the Chart
Formatting Part or All of an Object
Sorting with a Parameter
Creating Running Totals for a List of Numbers
Adding Fields into a Text Object


• 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 ...
Defining the Purpose of the Report
Applying Chart Templates Exporting Your Reports Within Your Organization
Creating a Group
Crystal Reports XI Before You Begin
Creating On-Demand Subreports
Creating Custom Groups
Creating Your Own Templates
Allowing Multiple Values in Parameters
Repeating Row Heading for Multi-Page Cross-Tabs
Creating Report Alerts
Advanced Grouping
Selecting Records with Multiple Criteria
Understanding Running Totals
Inserting Lines and Boxes
Summarizing Groups
What are Report Alerts
Using the Section Expert to Work with Sections
Performing Simple Number Calculations
Starting the Crystal Reports Program
About the Formula Workshop
Getting Help Formatting Features


• 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 ...
Transitions and Transforms
Embedding Media
Box Shadow Transitions, Transforms, and Animations
Text Shadow
Video Formats
The History of CSS
Font Services
Responsive Images and the viewport Metatag
The Opacity Property
Frameworks and Grid Systems
Attribute Selectors
Introducing CSS3
The CSS3 Speech Module
Styling Video
Fonts on the Web
Browser Support
Targeting Widths and Devices with CSS3 Media Queries


• 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 Sequence Clustering Algorithm
Concepts and Terminology
Microsoft Neural Network Algorithm
Accuracy and Validation
Microsoft Association Algorithm
Testing and Validation of Mining Models
Creating Reports Using Reporting Services
Data Source
Model Usage
Models, Induction and Prediction SQL Server Analysis Services Data Mining Tools
Types of Data Mining Algorithms
Microsoft Decision Trees Algorithm
CRISP-DM
Exploring Data
Cross Validation
Multiple Nested Tables Microsoft Data Mining Algorithms
Cross Validation
Data Mining Concepts
Microsoft Clustering Algorithm


• 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 ...
Optimizing for Mobile
Media Queries
jQuery Mobile
Flexible Grids
The Viewport
Swiping to Change Pages
New HTML5 Features
Using the Accelerometer
Video Formats
Designing for Mobile Devices
Handling Orientation Change
Optimizing the Video Experience for Mobile
Using data Attributes
Drag-and-Drop Code Builder
The Flexible Grid: A More Responsive Layout Strategy
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 ...
Creating Calculated Items
Enabling Tracked Changes
Setting Excel Options
Understanding Data Importing
Using the Cell Link to Display the Selection
Inserting a Timeline Filter PivotTable Features
Using the DMIN Function
Exporting Data as Text
Working With an Outline
Creating Scenarios
Understanding Types of Controls
Creating Subtotals
Merging Scenarios PivotTables
Editing a Macro
Creating Relative Names for Subtotals
Using Formulas in Criteria
Sharing Workbooks via the Network
Disabling Tracked Changes
Disabling Worksheet Protection
Working With a Protected Worksheet
Using Relative Names for Subtotals Data Consolidation


• 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 ...
Approximating Row Height
Resizing a Chart
Creating a Chart Sheet
What if Formulas
Changing the Chart Layout
Deleting Rows and Columns
Understanding the Backstage View
Vertical Cell Alignment
Growing and Shrinking Fonts
Using the Ribbon
Understanding Number Formatting
Understanding How Help Works
Understanding Font Formatting
Understanding Printing
Changing Background Colours
Printing a Chart Sheet
Using the Thousands Separator
Printing an Embedded Chart
Formatting Percentages
Understanding the Charting Process
Creating Mixed References Font Formatting


• 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 ...
Drawing Borders
Using Names to Select Ranges
Extracting With Flash Fill
Understanding Chart Formatting
Applying Alternate Date Formats
Removing Page Breaks
Hiding Rows and Columns
Formatting
Grouping Worksheets
The MOD Function
Defining Names From Worksheet
Clearing Print Titles
Creating a Table From Scratch
Understanding Filling
Pasting Defined Names Into
Understanding Defined Names
Clearing Conditional Formatting
Understanding Tables
Using Counting Functions
Preparing for Complex Formulas


• 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 ...
Working With Merged Queries
Working With Data Model Fields
Rearranging and Sorting Fields
Working With Location Fields
Updating a Power View Report
Exporting a Tour as a Video
Formatting Power View Data
Working With Height and Category
Switching Visualisations
Editing Query Steps
Creating a Calculated Field
Understanding Power Map
Understanding Relational Data
Transforming Data
Understanding Power Pivot
Understanding Get & Transform
Working With the Data Model
Creating a New Query From the Web
Merging Queries
Creating a Power View Sheet


• 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 ...
Using Debugging Tools
Working with Variable Scope
Working with the Label Control
Using the For...To...Next Structure
Introducing Visual Basic for Applications
Working with UserForm Properties, Events, and Methods
Working with Option Button Controls
Using Expressions, Variables, and Intrinsic Functions
Understanding Constants
Understanding VBA's Error Trapping Options
Using the Object Browser
Creating a Function Procedure
Controlling Program Execution
Using the Toolbox
Understanding Modules
Understanding Collections
Creating a PivotTable Using Worksheet Data
Working with Properties
Setting Breakpoints
Assigning a Macro to the Quick Access Toolbar


• 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 ...
Anchors with the id Attribute
Id and Name Attributes
Blocks and Inline Elements
The HTML Skeleton
Password Fields
TheElement TheElement
Unordered Lists
Inches (in), Centimeters (cm), and Millimeters (mm)
External Style Sheets
Form Elements
Case Sensitivity
Exs (ex)
ID Selectors
Benefits of Cascading Style Sheets
Introduction to HTML
Creating Tables
Get vs. Post
Checkboxes
Phrase 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 ...
autofocus
drawImage() - Sprites
Video Tag Attributes
HTML5 New Form Attributes
Laying out a Page with HTML 4 - the "old" way
Audio Tag Attributes
Accessibility
Page Structure
Offline Application API
Graceful Degradation
Creating and Converting Video Files
datalist
Prefixing your Keys
HTML5 Forms
novalidate
HTML5 Web Storage
date/time input types


• 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 ...
Built-In JavaScript Objects
JavaScript Form Validation
typeof Operator
do while Loop Syntax
Strings
Validating Radio Buttons
Image Rollovers
Built-in Functions vs Methods
Backward Compatibility
while Loop Syntax
Validating Checkboxes
Built-in Functions
Image Rollover Function
isNaN(object)
Switch / Case
Function Syntax
Validating a Registration Form
Arrays


• 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 ...
Same-origin Policy and JSONP
The Setup
Getting and Setting Information about Elements
jQuery's Ajax-related Methods
Utility Methods
Switch Statements
Ajax and Firebug
Functions
Manipulating Attributes
Keep Things DRY
Working with Selections
The for Loop
A Sample Application
Cache Length during Loops
Refining and Filtering Selections
Working with JSONP
Events-
Plugins-


• 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 ...
Buttons and Toolbars
Supported Devices/OSs/Browsers
Orientation (Portrait/Landscape)
Dialogs
Lists and Buttons
Video The Theme Framework
Buttons and Linking Pages
Levels of Support
Collapsible Blocks Events
Sliders
Ajax-driven Page Navigation
plugin Architecture
Virtual Integration with the Phone
Hosting vs. CDN
Data-role
Basic Page Template
Page Transitions


• See Training Course Details...

---

Microsoft Access

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

• This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.

• Some of the training topics covered include ...
Formatting Tables
Macros on Forms
Creating and Using Macros
Data Validation
Parameter Queries
Using a Navigation Form
Getting to Know Access 
Creating a Relational Database
Calculations in Queries
Creating and Using Reports
Modifying Forms
Aggregation Queries
Creating a Lookup Database
An Introduction to VBA
Importing and Exporting Records
Understanding VBA
Action Queries
DIY Forms
Navigation Pane Protection
Database Wellness
Querying Techniques


• 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 ...
Understanding Constants
Understanding the Form Object
Locking Records for Updating
Setting Breakpoints
Creating a Sub Procedure
Understanding Recordset Cursor Properties - Optional
Using Message Boxes
Understanding Control-of-Flow Structures
Determining the Value of Expressions
Creating a Standard Module
Understanding the Err Object
Understanding the Development Environment
Working with Variable Scope
Using the Immediate Window to Call Procedures
Using the For...Next Structure
Guidelines for use of Branching Structures
Understanding Procedures
Using Debugging Tools
Using the If...End If Decision Structures


• 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 ...
Data Sources GROUPING AND SUMMARISING WITH POWER QUERY
Course topics include- INTRODUCTION TO POWER QUERY
Using Ranges in Excel
Loading into Excel
Importing, Transforming, and Loading Data into Excel and Power Pivot
Understand and perform importing from SQL Server Analysis Services Multidimensional.
Summarising WORKING WITH THE POWER QUERY LANGUAGE “M”
Understanding Data Types WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
Understand and perform importing from SQL Server Analysis Services Tabular. PERFORMING MERGES
Performing Merges
Introduction to Power BI Desktop
Loading into Power Pivot
Importing Data
Using PivotTables CONNECTING TO DATABASES
Understand working with relational data.
Transforming Data
Understand the M interface.
Understanding the Issues
Working with Folders and Files
Understand Power Query formulas.
Understanding and Handling Special Situations


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


• 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 ...
Create a Power BI dashboard
Use Power Bi desktop to create interactive data visualisations. Direct Connectivity
Managing a Power BI solution
Using databases as a data source for Power BI
Importing data into Power BI
Shape data using formatting and transformations.
Direct connectivity from Power BI desktop
The Power BI Interface
Overview of the Power BI Data Model. Using Power BI
The developer API
Power BI desktop queries
Power BI embedded
Combine data together from tables in your dataset. Modeling data
Custom visuals Power BI mobile app
Using Excel as a data source for Power BI
Connecting to Power BI data
Direct connectivity from the Power BI service
Create calculated columns, calculated tables and measures. Interactive Data Visualisations
Topics covered include- Introducing Power BI
Importing different data sources into Power BI
Use Power BI direct connectivity to access data in Azure SQL data warehouse


• 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 ...
Load data.
Aggregations
Manage modifications.
Use Bing maps.
Power Map
Exploring the Power View Interface
Theming Reports
Perform data cleaning.
Applying Filters
Understanding Aggregations
Introduction to Power BI
Importing Large Datasets
Navigate the Power Query interface.
Navigate the Power Map interface.
Hierarchies
Importing Data with a Query


• 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 ...
Creating Resource Problems
Entering File Properties Creating Tasks
Custom Fields
Resources
Creating a Custom View
Changing Calendar Options
Linking to Microsoft Excel
Creating a Custom Table for the View
Modifying a Schedule Using
Dependencies
Understanding Resource Levelling
Creating a Summary Milestone Shared Resources
Working With the QAT
Assigning Specific Work Times
Simple Resource Assignments
Auto Scheduling Tasks
Opening Shared Resource Projects
Adding More of the Same Resource


• 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 ...
Creating Dependencies in a Sheet View
Entering Cost Resources
Entering Work Resources
Creating Dependencies in Task Entry
Changing Calendar Options
Checking Progress
Understanding Your Project
Working With Views
Understanding Scheduling Icons
Getting to Know Project 
Entering Lead Time
Examining Task Slack
Accessing the Help Window
Assigning Calendars to Resources
Adding Additional Resources
Understanding Lag Time
Working With Fixed Unit Tasks
Entering Task Durations
Working With Calendars
Working With Task Views
Understanding Tasks


• 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 ...
Resource Levelling
Setting Page Breaks
Changing Text Styles
Assigning Variable Usage Material
Adding a Constraint
Assigning Fixed Costs
Changing Bar Styles Advanced Printing
Highlighting a Range of Tasks
Adding To A Material Assignment
Assigning Per Usage Costs
Exploring Tables
Changing Time Periods
Using Print Preview
Moving a Project’s Start Date Project Tracking
Checking Resource Usage
Adding Fields Using Insert Column
Creating an Over Allocation Report
Saving an Existing View
Understanding the Timescale
Assigning Overtime
Understanding the Data Tools


• 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 ...
Components Graphical Reports
Setting Project Links
Understanding Project Templates
Formatting a Visual Report
Understanding Excel Visual Reports
Creating the Custom View
Localising a Macro
Creating a Read Only Subproject
Saving a Project as a Template
Creating a Summary Milestone Shared Resources
Preparing for the Master Project
Making Reports Global
Removing Unwanted Reports Visual Reports
Creating a Common Resource Pool
Creating a Custom Table for the View
Finalising the Master Other Applications
Running a Macro
Creating a Visual Report From a


• 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 ...
SharePoint 12 and AS 
Processing mining models 
Modeling intermediate fact tables 
Using the Add Business Intelligence Wizards - write-back, semi-additive measures, time intelligence, account intelligence 
Creating Data Sources and Data Source Views 
Perspectives 
New MDX functions 
Report Center (type of dashboard) uses KPIs, Reports, Excel Web, Filter 
Partitions - relational and Analysis Services partitions 
Security - roles and permissions 
Using the MDX query editor in SQL Server Management Studio 
Best practices - health monitoring 
Cube Storage and Aggregation 
Clustering - high availability 
XMLA scripting (SQL Mgmt Studio) 
Data Mining clients 
Storage topics - basic aggregations, MOLAP 


• 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 Copy Column Transformation 
SSIS debugging overview 
Data Viewers 
Deployment options 
Configuring Package Logging 
Script in Control flow: The Script Task 
Importing and Exporting Data 
Configuration options 
Advanced Data Flow
Breakpoints in SSIS 
Working with Packages 
Executing packages – DTExec and DTExecUI 
The Send Mail Task 
Creating Database Maintenance Plans using SSMS 
The SSIS Service 
Scheduling and Executing Plans 
SSIS Package Management
Configuration discipline 
Precedence Constraints 


• 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 ...
Model with SQL Server Business Intelligence Development Studio (BIDS)
Explore Advanced Dimension Types
Understand Measure (fact) and Cube Modeling
Explore how to add MDX Script Commands
Understand Dimensional Modeling (stars and snowflakes)
Deploy and View a Sample Cube
Advanced Administration and Optimization
Cube Storage and Aggregation
Understand Data Mining Concepts
Create Cubes by using the Cube Wizard
Design Reports by using Report Builder
Understand Basic MDX Syntax
Using SSAS in BIDS
Work with Multiple Fact Tables and the Dimension Usage Subtab in BIDS
Explore Clustering
Understand Performance Tuning and Optimization
Implement SSAS Security
Understand Writeback in Dimensions
Review the Algorithms that SSAS Includes


• 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 ...
Using Variables and Configurations between Packages 
Data Flow Best Practices 
Custom Integration Services Components 
Data Flows
Migrating and Maintaining SQL Servers with Integration Services 
Working with Workflow Tasks 
Scripting in Control Flows with the Script Task 
Event Handling 
Control Flow
Scripting in Data Flows with the Script Component 
Using Variables in Control Flow 
Exploring and Executing an Integration Services Package in BIDS 
Understanding Variables 
The Data Flow Task 
Configurations 
Best Practices


• 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 ...
Utilizing Attributes
Creating a Tabular Project
Utilizing Translations
Understanding the Multidimensional Model
Examining Deployment Options
Dissecting with Dimensions
Relating with Relationships
Calculated Members.
Understanding Perspectives
Developing Dimensions
Configuring Cube Options
Maintaining and Optimizing
Deploying
Handling Hierarchies.
Browsing the Model
Version Changes of SSAS from 2008-2014
Deploy a multidimensional model.
Understanding the Tabular 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 ...
Define and Use Variables and Parameters
Understanding Variables
Managing SQL with the SQL Tasks
Examining the Transformation and Other Tasks Variables, Parameters and Expressions
Moving Data with Data Flow
Working with XML
Overview of Containers
Optimizing Sources for Extraction
Utilizing SQL Server Integration Services Data Typing
Using Destinations and Understanding choices
Using the Workflow Tasks
Handling Errors Common SQL Server Integration Services Design Patterns
Using Package Hierarchies: Parent Child
Utilizing Container Loops Performing Joins
Data Loading with the Analysis Services Tasks
Managing with Control Flow
Creating Dynamic Packages
Examining the SSIS Engine
Understanding Deployment Strategies 
SQL Server Integration Services Architecture
Performing Joins with the Merge Transformation


• 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 ...
Formatting Reports
SQL Server 2016 Report Builder Wizards
Utilizing Data Sources
Using the List Object to Combine Other Items
Examining Security
Understanding HTML5 and Textboxes
Exploring Gauges
Using Tables
Understanding Variances Between SQL Versions
Creating Subreports and Drillthrough Reports
SQL Server 2016 Report Builder Basic Reports
Working with Expressions
Exploring Subscriptions
Introduction to SQL Server 2016 Report Builder
Visualizing Your Company Report Templates
Examining Maps
Utilizing Dynamic Headers and Footers
SQL Server 2016 Report Builder Graphics


• 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 ...
Configure Measure Group Properties
Rename a Multidimensional Database Processing a multidimensional model
Create Remote Partitions
Create Measures and Measure Groups
Modify or Delete an Analysis Services Database
Define a Data Source View
Create Local Partitions
Add a Standard Action
Partition Writeback Calculations
Set Data Source Properties
Define Attribute Relationships
Change a Partition Source
Create Calculated Members
Work with Diagrams in Data Source View Designer
Create a Time Dimension by Generating a Time Table
Designing Aggregations
Define a Regular Relationship and Regular Relationship Properties
Ragged Hierarchies
Read Definition permissions
Processing Databases, Dimensions and Partitions
Define a Referenced Relationship and Referenced Relationship Properties


• 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
Import from Analysis Services
Process Database, Table, or Partition
Data types supported
Enable DirectQuery mode in SSDT
Version comparison
Delete a Column
Change table, column
Rename a Table or Column
Connect to a tabular model database
Analyze in Excel
Object-level security
Create and Manage Tabular Model Partitions
Specify Mark as Date Table for use with Time Intelligence
Database Process Partitions in the Workspace Database Perspectives
Create a Calculated Table
Data sources supported in SSAS  tabular 2016 Create Tabular Models
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Add sample data to DirectQuery models
Create a Relationship Between Two Tables


• 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 ...
Report subscription and delivery Administering Reporting Services
Implementing report filters and parameters Visualizsng Data with Report Services
Create a report using report builder or report designer.
Formatting data
Secure access to reports by using authentication, permissions, and SSL encryption.
Publish a report to reporting services Working with Reporting Services Data
Work with expressions and embedded code.
Report caching, snapshots, and comments
Add a drillthrough to a custom URL
Extend reporting services functionality with external assemblies.
Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
Drillthrough in mobile reports
Using Datasets Creating Paginated Reports
Topics include Introduction to Reporting Services
Mobile report publisher
Use databars, sparklines, and indicators in reports Summarising Report Data
Overview of mobile reports
Creating a report with the report wizard
Sorting and grouping
Drilldown and drill through Sharing Reporting Services Reports


• 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 ...
View Selector View
Miscellaneous Tasks Building a Dashboard
Logical Data Models
Ticker View
Defining the Pivot View
Accessing The Presentation Catalog
Managing the Views Using Secondary Views
About Database Technologies
Totals within Pivot Tables Advanced Formatting
Column Formulas Using Primary Views
Sorting Data
Using the Dashboard Editor
Managing Dashboard Objects Creating a Report
View XML and SQL Calls Administering The Presentation Catalog
Managing Saved Content
Viewing Supplementary Content
Column Formatting
Understanding the Dashboard Structure
Report Attributes
Sections and Pages
Warehouse Models and Schemas


• 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 ...
Exception Handlers 
Associative Array Collections 
Oracle Directories 
Stored Subprograms 
Creating a Stored Function 
Assignment and Conversions 
Exception Handling
The DBMS_METADATA Package 
Procedures and Functions 
The DBMS_OUTPUT Package 
Using Packages 
Iterating Through Collections 
Triggers
Privileges for Stored Programs 
Internal LOBs 
Collection Methods 
LOB Locators 


• 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 ...
Combining SELECT Statements 
Nulls and DISTINCT 
Datatypes 
Constraints 
Aggregate Functions and Advanced Techniques 
The EXISTS Operator 
Literal Values 
Data Manipulation and Transactions 
IN and BETWEEN 
Pattern Matching: LIKE and REGEXP_LIKE 
Using SQL Functions 
The CASE...WHEN Expression 
Intervals 
Synonyms
Concurrency 
Scalar Functions 
Tailoring Your SQL*Plus Environment 
Sample Database 
Relational Database and SQL Overview 


• 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 ...
Working with Associative Arrays 
PHP Basics
Constants 
By Reference vs. By Value 
User Functions 
do...while 
Uploading Files via an HTML Form 
When not to use a database abstraction layer? 
Getting a Directory Listing 
mysqli Prepared Statements 
Form Variables 
Writing to a File 
preg_replace() 
fopen() 
Working with Enumerated Arrays 
fgets() 
Creating a Resume Management Page
Cookies 
Type Strength 


• 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 ...
Inserting an Online Picture
Applying a Picture Style
Changing the Theme Colours
Applying Artistic Effects
Viewing the Slide Master
Sending a Presentation via Email
Working With PowerPoint Designer
Saving a Custom Template
Saving a Presentation as a PDF
Creating a Template From a
Merging and Splitting Cells
Using Slide Transitions
Applying a Table Style
Using Quick Layouts
Using an Existing Template
Inserting Action Buttons
Working Collaboratively
Saving to OneDrive
Setting Up a Speaker-Led Show


• 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 ...
Starting PowerPoint From the Desktop
Inserting and Formatting Text
Converting Text to SmartArt
Adding an Assistant
Using Ribbon KeyTips
Inserting a Picture With Caption Slide
Typing Text Into a Slide
Understanding the Status Bar
Editing Text
Switching SmartArt Right to Left
Printing the Outline
Applying WordArt to Text
Presentations
Creating a Presentation
Changing the Slide Layout
Promoting and Demoting Shapes
Working With Text


• 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 ...
Calculated Fields
Benefits of Views
NULL Values
Checking for Equality
Relational Databases
The LIKE Operator
Creating Tables
Grouping and Aggregating Data
Using CASE Inserting, Updating and Deleting Records
Selecting All Columns in All Rows
Selecting Distinct Records
Multi-table Joins
Creating Stored Procedures
Creating Tables
Popular Databases


• 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 ...
Grouping Data
Filters
Adding Groups and Users
Understanding Reporting Services 2005 Subscriptions
Parts of the Chart
Formatting Textboxes with the Textbox Properties Dialog
Navigation
Deploying the Auditing and Management Reports
Using Reporting Services 2005 Expressions
Understanding Reporting Services 2005 Caching
Understanding Snapshots
Identifying Field
Understand the Report Model Architecture
The Reporting Services 2005 Report Designer
Starting SQL Server Business Intelligence Development Studio
Report Builder Design Layout
Report Borders Toolbar
Database Components
Creating Formulas
Data Output


• 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 ...
Explore exporting reports to a variety of formats and using the client-side printing feature of Reporting Services 
Learn how to solve common parameter issues 
Learn how to work with rich text to produce mail merge style reports 
Find out how to use Report Manager to manage user accounts and roles 
Investigate the list data region 
Investigate what SQL Server Reporting Services can do 
Managing Reporting Services
Advanced Reporting Services Programming
Learn how to create custom functions using the Code window 
Find out how to create drill-down reports 
Investigate the scheduling of report snapshots 
Learn about report variables and when you might need to use them 
Learn about datasets and data regions 
Discover the various global collections that you can reference in your expressions 
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 ...
Add Packages to an SSIS Project Managing Control Flow
Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
Create Dimensions
Add Data Flow Components to a Data Flow Task
Secure Databases Working with MDS and Windows Azure
Securing Packages and Databases
Configure MDS
Install Integration Services Working with Integration Services
Troubleshoot Package Failures Deploying Packages
Introduction to Data Warehouses
Execute Packages from Different Control Flow Working with Dynamic Variables
Overview of Data Warehouses
Examine Data Warehousing Concepts
Deploy SSIS Packages
Create Expressions with Variables
Create Fact Tables
Work with Windows Azure
Examine MSI Packages
Perform Transformation Tasks
Secure Packages


• 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 ...
Work with Multivalued Parameters  Enhancing Reports with Data Visualisations
Designing the Page Layout
Multivalued Parameters Dynamic Reports with Parameters
Null Handling
Building a List Report Configuring Tablix  Properties and Groups
Building a Report with Report Builder
Page Structure Properties
Exploring the Tablix Report Type
Create a Report with Interactive Sorting Dynamic Reports with Parameters
Using Parameters with Ad Hoc SQL
Report Builder vs. Report Designer
Create a Matrix Report
Overview
Synchronized Data Alignment  Using the Tablix Report Type
Formatting Tablix Rows and Columns Making Reports Interactive
Sharing Custom Code with Multiple Reports Calculations Using Expressions and Functions
Create a Custom Function  Managing Page Layout and Adding Interactivity
Service Architecture  Report Building Tools
Page Headers and Footers Report Formatting Options
Native Mode Architecture
Drilldown Reports Managing Page Layout and Adding Interactivity


• 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 ...
Work with Subqueries
Work with Data Access Technologies Implementing Stored Procedures
Manage Stored Procedures
Delete Data
Work with Advanced Functions Working with PIVOT, UNPIVOT, and Grouping Sets
Work with System Databases
Work with String and Numeric Data Types
Analyze Data from Query Plans
Group and Aggregate Data Programming in T-SQL
Work with PIVOT and UNPIVOT
Perform Advanced Filtering Querying Data from Multiple Tables
Write CASE Expressions Working with SQL Data Types
Work with SSPs and SMOs
Getting Started with SQL Server 2012
Merge Data Working with SQL Server Built-in Functions
Work with Variables and Batches
Work with Dynamic SQL Working with Subqueries and Table Expressions
Work with Set Operators
Configure Indexes
Work with Binary Data Types
Update Data


• See Training Course Details...

---

Visio

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline
• Some of the training topics covered include ...
Rack diagrams
Integration with PowerPoint
Business diagrams and Web site mapping
Custom stencils
Software and database diagrams
Layout and connection techniques
Working with Web-enabling features
Network diagrams
Sharing diagrams using a browser
with background pages
Formatting drawings
Flowcharts
Presentation Mode
Working with text
Creating a basic diagram
Drawing scales


• See Training Course Details...

---

Email us about this courses

---