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 ...
Using the Sort Control 
Creating Custom Groups
Subtotals Using the Group Sort Expert
Report Alerts
Specifying and Limiting a Range for a Parameter
Using the Section Expert to Work with Sections
Starting a New Report 
Saving the Report 
Database Filtering with the Select Expert 
Using the Report Wizards 
Using a Parameter to set N in a Top N or 
Variable Scope
Summarizing Groups 
Window 
Using Guides and Guidelines to Move and Align Objects 
Conditionally Formatting Fields 
Time Debugger
Using a Variable in a Formula


• 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 ...
Selecting Specific Records from the Database 
Understanding Tables, Records, and Fields 
Creating String Formulas 
Inserting Graphics 
Formatting on Report Alerts
Parameter Field Considerations
Using the Report Wizards 
Using Group Selection toFilter the Records in the Report
Applying a Formatting Style to the 
Sorting Records within a Group 
Understanding Subreports
Selecting and Sizing Objects 
Summarizing Groups 
Conditionally Formatting Multiple Sections
Placing Fields on the Report 
Using Multiple Sections in Reports
Applying the DrillDownGroupLevel 
Using Evaluation Time Functions


• 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 ...
Selecting and Sizing Objects
Using Bookmarks to Navigate Through Formulas Conditional Formatting
Working with Text Objects
Basing Report Formulas or Conditional Formatting on Report Alerts
Creating Running Totals for a List of Numbers
Understanding Crystal Formula Syntax
Drawing a Box
Exploring the Toolbars
Starting the Crystal Reports Program
Inserting Special Fields Selecting Specific Records from the Database
Applying a Formatting Style to the Cross-Tab
Case Sensitive vs. Case Insensitive
Format Painter
Create a Report Using the Standard Report Creation Wizard
Filter Types of the Select Expert
Working with the Page Commands
Modifying Individual Objects in the Chart
Charting Cross Tabs
Using the Parameter Panel
Database Filtering with the Select Expert
Creating a Cross-Tab Report


• 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 ...
Ordering Groups Based on Their Subtotals Using the Group Sort Expert Combining Multiple Tables
Using Evaluation Time Functions
Working with the Page Commands
Create a Report Using the Standard Report Creation Wizard
Performing Simple Number Calculations
Viewing and Editing the Select Formula
Using the PDF Format for Crystal Reports
Linking a Subreport
Using the Preview Panel
Using the Chart Options
Understanding How Cross-Tabs Affect Your Data
The Template Dialog Box Power Formatting
Creating String Formulas
Producing Charts
Understanding Export Formats and Destinations
Grouping on a Formula Field
Customizing the Cross-Tab Format
Creating a Summary Report
The Fields Dialog Box
Creating a Group
Parameter Field Considerations


• 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 ...
What is a Report Template
Using the Group Tree to Navigate the Report
Template Considerations
Creating a Group
Using a Formula to Customize the Group Name Field
Customize Group Name Field
Understanding Export Formats and Destinations
Advanced Grouping
Creating Custom Groups
Producing Charts
Browsing Field Data
Using a Parameter to set N in a Top N or Bottom N report
Using a Field Name to Customize the Group Name
The Workbench Creating a Simple Report
Using Auto-Arrange Chart
Modifying Groups
Applying a Template and the consequences
Understanding How Cross-Tabs Affect Your Data
Using the Formula Editor
Formatting Template Fields
Learning about Linking


• 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 ...
Backgrounds
The @font-face Rule
Text Shadow
Video Formats
Image Borders
Word Wrapping Colors, Gradients, Background Images, and Masks
Strategies
The Target Pseudo-Class
The CSS3 Speech Module
Media Queries
Negation Pseudo-Class
Transitions Layout: Columns and Flexible Box
Preprocessors
background-origin, and background-size Borders and Box Effects
Attribute Selectors
What Are Vendor Prefixes
Web Accessibility


• 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 ...
Management
Multiple Nested Tables Microsoft Data Mining Algorithms
CRISP-DM
Microsoft Logistic Regression Algorithm
Topics include:
Microsoft Sequence Clustering Algorithm
Data View
Microsoft Decision Trees Algorithm
Models, Induction and Prediction SQL Server Analysis Services Data Mining Tools
Data Mining Concepts
Concepts and Terminology
Cross Validation
Compare Mining Structures
Introduction to SQL Server Data Tools
The User Interface
Data Mining and Results
Data Preparation
Model Usage
Connection
Microsoft Naïve Bayes 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 ...
Media Queries
Using data Attributes
Framework: Foundation
Flexible Background Images
Targeting Widths and Devices with CSS3 Media Queries
Gestures
Drag-and-Drop Code Builder
Embedding from YouTube or Vimeo
Google Maps
Hosting Your Own Videos
Consolidating the Web with Native Extensions
Media Queries
Local Storage Example
A Simple Example
GeoLocation API
Responsive Design: Good for All Devices


• 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 ...
Preparing a Worksheet for Controls
Using the PivotChart Filter Field Buttons
Understanding How Controls Work
Understanding PivotTables
Formatting a PivotTable
Switching PivotTable Fields
Modifying an Inserted Picture Data Linking
Importing Access Data
Saving to OneDrive
Adding a Group Box Control
Using the DMIN Function
Filtering a PivotTable
Defining the PivotTable Structure
Circling Invalid Data
Importing Tab Delimited Text
Sharing Workbooks via the Network
Creating a One-Variable Table
Saving a Document as Macro Enabled
Understanding Database Functions
Sorting in a PivotTable PivotCharts
Personalising Excel


• 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 ...
Saving a New Workbook on Your Computer
Understanding the Status Bar
Formatting for Money
Applying General Formatting
Understanding the Quick Access Toolbar
Creating Formulas That Subtract
Italicising Text
Creating Mixed References Font Formatting
Changing Font Size
Performing an Alphabetical Sort
Navigating Using the Keyboard
Setting the Default Column Width
Understanding Dialog Boxes
Clearing Cells
Understanding Worksheets
Applying and Using a Filter
Accessing the Backstage View
Using Undo and Redo Selecting Ranges
Sorting on More Than One Column Filtering Data
Using the Format Painter Cell Alignment


• 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 ...
Changing Column Colour Schemes
Applying Alternate Date Formats
Changing Margins by Dragging
Creating Sparklines
Using Shape Styles
Adding More Complexity
Formatting
Defining Names From Worksheet
Preparing for Complex Formulas
Manipulative Functions
Changing Individual Bar Colours
Setting a Background
Creating a Custom Fill List
Applying Names to Existing Formulas
Values Conditional Formatting
Formatting With WordArt
Understanding Borders
Creating the Base Formula
Hiding Rows and Columns
Understanding Tables
Adding More Operations


• 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 ...
Adding a Data Column
Working With a Power View Object
Using Related Power Pivot Fields
Power View
Creating a Calculated Field
Transforming Data
Understanding Power Pivot
Adding Slicers Get & Transform
Formatting Data Model Fields
Adding Titles and Images
Formatting Power View Data
Navigating a Data Map
Understanding Relational Data
Updating a Power View Report
Working With Measure Fields
Adding Power View to the Ribbon
Reducing Data Rows
Enabling Power View
Displaying the Query Editor
Adding More Power Views


• 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 ...
Running a Macro
Understanding Controls
Navigating the Excel Object Hierarchy
Using Message Boxes
Understanding Collections
Using the For...To...Next Structure
Working with Procedures and Functions
Creating a Sub Procedure
Working with Forms and Controls
Using the Do...Loop Structure
Understanding Data Types
Understanding VBA's Error Trapping Options
Controlling Program Execution
Working with Option Button Controls
Understanding Errors
Assigning a Macro to the Quick Access Toolbar
Understanding UserForms
Working with the Frame 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 ...
Preformatted Text
Documenting Changes
External Style Sheets
Nesting Unordered Lists
Descendant Selectors
The Cascade
Case Sensitivity
Blocks and Inline Elements
Whitespace
Quoted Text
Points (pt)
HTML Links
Merging Cells HTML Forms
Email Links
ID Selectors
Pixels (px)
Selectors
XHTML vs. HTML
HTML Elements
Absolute Paths


• See Training Course Details...

---

HTML 5

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

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

• Some of the training topics covered include ...
HTML5 Forms
Prefixing your Keys
Page Structure
Getting and Creating Audio Files
datalist
required
Page Simplification
Some Other New Form Field Attributes
HTML5 New Form Attributes
Current State of Browser Support
drawImage() - Basic
Modernizr
The Path Drawing Process
autocomplete
The HTML5 Spec(s)
Additional Changes
Outlining
The section Tag


• 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 ...
JavaScript Basics
Built-in Functions vs Methods
String(object)
for in Loop Syntax
Basics of Form Validation
Working with Images
Validating Select Menus
Associative Arrays
A Loosely-typed Language
Switch / Case
Properties
Image Rollover Function
Preloading
Conditionals
Accessing Form Data
JavaScript Objects, Methods and Properties
Arrays
do while Loop Syntax
The getElementById() Method


• 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 ...
JavaScript Basics-
Conditionals
jQuery Core-
Use Event Delegation
GET vs. Post
Beware Anonymous Functions
Don't Treat jQuery as a Black Box
Optimizing Your Code: The RequireJS Build Tool
Operators
Ajax Events
$.fn.load
Avoid the Universal Selector
Basic Operators
Selecting Elements
Data Types
$.fn.hover


• 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 ...
PhoneGap
Levels of Support
Overriding Themes with Custom CSS Plugins
What Is jQuery Mobile?
Buttons and Toolbars
Sending Emails
Sliders
Data-role
plugin Architecture
Themes and Swatches
ThemeRoller
Creating Your Own Plugin
Virtual Integration with the Phone
Supported Devices/OSs/Browsers
HTML5 and CSS3 Getting Started with jQuery
Dialogs


• See Training Course Details...

---

Microsoft Access

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

• In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.

• Some of the training topics covered include ...
Relational Database Design
Importing and Exporting Records
Macro Techniques
Modifying Forms
Creating and Using Reports
Working With Records
Designing a Lookup Database
Creating and Using Macros
Creating Queries
Sorting and Filtering
Parameter Queries
Multi Table Queries
Understanding VBA
Formatting Tables
Adding Transactional Records
Setting Table Relationships
An Introduction to VBA
DIY Forms
Getting to Know Access 
Creating and Using Forms
Aggregation Queries


• See Training Course Details...

---

Microsoft Access Programming Using VBA

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

• This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.

• Some of the training topics covered include ...
Why Program in Access?
Understanding Error Handling
Naming Procedures
Using the With Statement
Using the Immediate Window to Call Procedures
Using the Select Case...End Select Structure
Using Expressions, Variables, and Intrinsic Functions
Understanding Modules
Considering Variable Scope and Lifetime Together
Understanding Objects
Understanding Recordset Cursor Properties - Optional
Working with the Code Editor
Navigating the Access Object Hierarchy
Setting Break Expressions
Working with Variable Lifetime
Understanding the Order of Events
Working with Variable Scope
Using the Object Browser
Introduction to Programming in Access
Working with the Application 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 ...
Working with Folders and Files
Using PivotTables CONNECTING TO DATABASES
Importing, Transforming, and Loading Data into Excel and Power Pivot
Grouping Options
Loading into Power BI Desktop
Understand and perform importing from SQL Server Analysis Services Multidimensional.
Understanding the Issues
Understanding and Handling Special Situations
Understand and perform importing from SQL Server Analysis Services Tabular. PERFORMING MERGES
Understand Power Query formulas.
Introduction to Power BI Desktop
Data Sources GROUPING AND SUMMARISING WITH POWER QUERY
Using Ranges in Excel
Understand working with relational data.
Loading into Power Pivot
Power Query Interface
Appending Operations
Performing Merges
Loading Data
Understand the M interface.
Understand and utilize merges. LOADING YOUR DATA


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


• See Training Course Details...

---

Microsoft Power BI

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

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

• Some of the training topics covered include ...
The Power BI Interface
Direct connectivity from Power BI desktop
Power BI desktop queries
Shape data using formatting and transformations.
Create a Power BI dashboard
Managing a Power BI solution
Use Power BI with SQL Server Analysis Services data, including Analysis services models running in multidimentional mode. The Developer API
Understand the DAX syntax and use DAX functions to enhance your dataset.
Importing different data sources into Power BI
Viewing reports from Excel files Shaping and Combining Data
Using databases as a data source for Power BI
Create calculated columns, calculated tables and measures. Interactive Data Visualisations
Combine data together from tables in your dataset. Modeling data
Using the Power BI mobile app
The developer API
Create relationships between data tables.
Custom visuals Power BI mobile app
Creating Power BI reports
Using Excel as a data source for Power BI
Power BI embedded
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 ...
Importing Large Datasets
Theming Reports
Merge datasets.
Drill Through
Calculated Columns and Calculated Fields
Understanding DAX
Creating PivotTables
Utilize themes.
Applying Filters
Navigate the Power BI interface.
Use Bing maps.
Visualizing Power View Reports
Understanding Aggregations
Topics include –
Power View
Introduction to Power BI
Configure tours, scenes, and layers.


• 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 ...
Copying a Gantt Chart Image
Entering Variable Costs
Entering Tasks
Linking to an External Pool
Filtering Report Data
Changing Time Periods
Saving an Existing View
More Highlight Filters
Entering Lead Time
Preparing for the Custom View
Creating an Over Allocation Report
Creating a Custom Group for the
Understanding Graphical Reports
Working With Fixed Unit Tasks
Creating a Custom View
Copying Table Data
Manually Updating Tasks
Creating Custom Fields
Computers and Project Management Creating a New Project
Modifying a Template
Changing the X Axis Categories


• 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 ...
Reviewing the Project
Setting Up Project Information
Printing Resources for Tasks Getting Help
Using Google to Get Help
Modifying a Schedule Using Dependencies
Working With Calendars
Simple Resource Assignments
Navigating the Help Window
Working With Tables
Showing and Collapsing the Ribbon
Printing Sheet Views
Computers and Project Management Creating a New Project
Working With Views
Assigning Calendars to Resources
Entering Public Holidays
Adding Additional Resources
Assigning Resources You Do Not Have
Adjusting Resource Availability
Tasks and Resources
Creating Dependencies in Task Entry


• 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
Case Study Variable Costs
Assigning Daily Costs
Using The Tracking Box
Showing Tiers
Viewing Project Costs Constraints and Deadlines
Assigning Overtime
Adding To A Material Assignment
Printing Headers
Editing Existing Filters
Reviewing Our Project
Creating a Deadline
Checking Work For Materials Costs
Checking Resource Usage
Setting Page Breaks
Moving a Project’s Start Date Project Tracking
Exploring Tables
Contouring Materials Usage
Working With Gridlines
Understanding Gantt Chart Bars
Adding a Constraint


• 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 ...
Altering Tasks With Custom WBS
Applying a Newly Organised Item
Removing Unwanted Reports Visual Reports
Removing a Custom View and Its
Assigning Resources From the Pool
Syncing Tasks With SharePoint
Changing the X Axis Categories
Saving a Project as a Template
Running a Report
Understanding Project Downsizing
Checking for Resource Links
Creating a Common Resource Pool
Creating a Lookup Custom Field
Localising a Macro
Understanding Project VBA
Linking a New Project File to the Pool
Setting a Combined Project Start
Working With Shared Resources


• 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 ...
Cube processing options 
MS BI is comprehensive - more than Analysis Services on SQL Server 
Modeling M:M dimensions, Fact (degenerate) dimensions, Role-playing dimensions, writeback dimensions 
Best practices - health monitoring 
KPIs 
Adding calculated members 
.NET Assemblies
SharePoint 12 and AS 
SPS RS web parts & .NET 2.0 report viewer controls 
Refining Dimensions and Measures in BIDS 
Excel 2003 Pivot Tables 
Creating Data Sources and Data Source Views 
SQL RS & Report Builder 
Future Directions & Integration with Office 12
Actions - regular, drill-through and reporting 
Understanding fact (measures) and cube modeling 
Welcome to the Real Time - Proactive Caching 
Customizing Aggregation Design - Processing Design 
Advanced Storage Design - MOLAP, ROLAP, HOLAP 
Partitions - relational and Analysis Services partitions 


• 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 ...
Executing packages – DTExec and DTExecUI 
The Variables window 
The Conditional Split Transformation 
The FTP Task 
Introduction to Control Flow
The Data Conversion Transformation 
Control Flow: The OnError event handler 
Creating Database Maintenance Plans using SSMS 
Introduction to SSIS scripting 
Scheduling and Executing Plans 
Variables Overview 
SSIS for DBAs: Using SQL Server Management Studio
Deployment security 
Data Flow: Error data flow 
The Web Service Task 
The SSIS script editor 
Script in Data flow: The Script Component 
Using variables in control flow 
Configuring Package Logging 
Working with Packages 
Managing packages with DTUtil 


• 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 ...
Learn how to Create Key Performance Indicators (KPIs)
Understand Measure (fact) and Cube Modeling
Create Cubes by using the Cube Wizard
Understand Basic OLAP Modeling (star schema)
Design Reports by using Report Builder
Create Data Source Views
Review the three SSAS Action Object Types: Regular, Drillthrough, and Reporting
Implement Proactive Caching
Introduction to MDX Queries
Explore Clustering
Design Reports using Reporting Services
Understand Writeback in Dimensions
Review Microsoft Office SharePoint Server 2007
MDX Expressions
Explore Scalability Options
Understand Basic MDX Syntax
Discover how to add .NET Assemblies
Introduction to Data Mining
Understand SSAS Database Backup and Restore
Review Semi-Additive Measures in OLAP Cubes


• 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 
Package Management
Advanced Data Flow
Understanding Variables 
Integration Services Security 
Handling Errors and Debugging 
Using Containers 
Package Deployment
Configurations 
Working with Workflow Tasks 
Extending Integration Services Capabilities through Code 
Best Practices for Package Development and Design 
Event Handling 
Synchronous and Asynchronous Transformations 
Scripting and Custom Components
Data Flows


• 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 ...
Choosing the Right Model
Understanding the Tabular Model
The Tabular Solution
Understanding the Multidimensional Model
Processing Strategies
Introduction to Microsoft SQL Server Analysis Services
Developing Dimensions
Version Changes of SSAS from 2008-2014
Measures and Measure Groups
Common Analysis Services Solutions
Configuring Cube Options
Understand and utilize security.
Maintaining and Optimizing
Utilizing Translations
Utilizing Data Sources and Data Source Views
Creating a Cube
Analysis Services Installation and Architecture: One Product, Two Models


• 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 ...
Managing SQL with the SQL Tasks
Using Destinations and Understanding choices
Looping and Sequence Tasks
Choosing the Script Task or Script Component
Examining the Transformation and Other Tasks Variables, Parameters and Expressions
Creating Dynamic Packages
Version Changes of SSIS From 2008-2012
Administration of SQL Using the SQL Management Objects Tasks Data Flow
Managing with Control Flow
Creating SQL Server Integration Services Packages
Utilizing SQL Server Integration Services Data Typing
Using the Workflow Tasks
Performing Joins with the Merge Transformation
Using Expressions in Packages Containers
Utilizing Connection Managers SQL Server Integration Services Tasks
Understanding Variables
Utilizing Container Loops Performing Joins
Working with XML
Data Loading with the Analysis Services Tasks
Working with Advanced Logging and Reporting
Define and Use Variables and Parameters


• 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 ...
Utilizing Lists
Utilizing Chart Wizard
Utilizing Data Sources
Understanding Report Parts
SQL Server 2016 Report Builder Basic Reports
Exploring the Report Builder Interface
Utilizing Dynamic Headers and Footers
Examining Parameters
Examining Security
Introduction to SQL Server 2016 Report Builder
Exploring Matrix
Mastering Data Region(s)
Understanding HTML5 and Textboxes
Examining Maps
Working with Expressions
Understanding Visualizations
Creating Subreports and Drillthrough Reports
Visualizing Your Company Report Templates


• 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 ...
Create Measures and Measure Groups
Define Named Calculations in a Data Source View
Using SQL Server Data Tools (SSDT)
Deployment Requirements and Considerations for Analysis Services Deployment
Backup Options Restore Options
Define a Data Source View
Create a Dimension by Generating a Non-Time Table in the Data Source
Create a Data Source
Supported Data Sources
Create a Dimension by Using an Existing Table
Explore Data in a Data Source View
Add a Standard Action
Define a Fact Relationship and Fact Relationship Properties
Partition Writeback Calculations
Rename a Multidimensional Database Processing a multidimensional model
Work with Diagrams in Data Source View Designer
Define Logical Primary Keys in a Data Source View
Cube or model permissions Process permissions
Error Configuration Roles and Permissions
Create User-Defined Hierarchies
Modify or Delete an Analysis Services Database


• See Training Course Details...

---

Microsoft SQL Server 2016/2017 Analysis Services Tabular Modelling

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

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

• Some of the training topics covered include ...
Data sources supported in SSAS  tabular 2016 Create Tabular Models
Create and Manage Hierarchies Partitions
Impersonation
Topics include- Overview of SSAS Tabular models
DAX formula compatibility in DirectQuery mode Tables and Columns
Sort Data in a Table
DirectQuery Mode
Create and Manage Perspectives Translations Roles
Manage Roles by using SSMS
Create and Manage KPIs Hierarchies
Database Process Partitions in the Workspace Database Perspectives
Create and Manage Partitions in the Workspace
Add columns to a table
Specify Mark as Date Table for use with Time Intelligence
Analyze in Excel
Change table, column
Import Data
Data sources supported in tabular 1400 models
Filter Data in a Table Relationships
Import from Analysis Services
Rename a Table or Column


• See Training Course Details...

---

Microsoft SQL Server Reporting Services SSRS 2016

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

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

• Some of the training topics covered include ...
Use databars, sparklines, and indicators in reports Summarising Report Data
Creating a report with the report wizard
Configuring data access with report designer
Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
Sorting and grouping
Work with expressions and embedded code.
Report subscription and delivery Administering Reporting Services
Drillthrough in mobile reports
Use report services configuration manager to reconfigure SSRS servers.
Data filters
Introduction to reporting services
Mobile report publisher
Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
Overview of mobile reports
Add a drillthrough to a custom URL
Topics include Introduction to Reporting Services
Create a report using report builder or report designer.
Drilldown and drill through Sharing Reporting Services Reports
Extend reporting services functionality with external assemblies.
Reporting services tools Reporting Services Data Sources
Schedules


• 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 ...
Pivot Table Concepts
Downloading the Answers Report Formatting
About Business Intelligence
Using the Dashboard Editor
Managing Presentation Catalog Objects Deploying Requests to Dashboards
Understanding The Dashboard Interface
Managing Dashboard Objects Creating a Report
Ticker View
Saving and Reusing Filter Settings
Totals within Pivot Tables Advanced Formatting
Column Formatting
Chart View
Creating a New Request
Managing the Views Using Secondary Views
Navigating the Answers Interface
Defining the Pivot View
About Views
Basic Navigation Using A Dashboard
Customizing the Table View
Using Prompts to Filter Data
Narrative 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 ...
Using Packages 
Other Supplied Packages
Scope and Name Resolution 
Nesting Blocks 
User-Defined Exceptions 
Beyond Declarative Integrity 
Stored Functions and SQL 
Anchored Types 
Types of Triggers 
PL/SQL Stored Program Compilation 
Generating an Error 
Using VARRAYs 
Cascading Triggers and Mutating Tables 
PL/SQL Blocks and Programs 
Oracle Directories 
WHILE and FOR Loops 
Assignment and Conversions 
Procedures and Functions 
Maintaining Stored Programs
Calling a Stored Function 


• 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 ...
Logical and Physical Storage Structures 
Synonyms
Concurrency 
Subqueries 
Using SQL Functions 
Selecting from Multiple Tables 
Defining Tables 
Introduction to SQL 
SQL*Plus LOB Support 
Oracle Versioning and History 
The EXISTS Operator 
Date Functions 
String Functions 
Correlated Subqueries 
Conversion Functions 
The Aggregate Functions 
Inline Constraints 
Nulls and DISTINCT 
Constraints 
Loading Tables From External Sources 


• 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 ...
break and continue 
Defining and Calling Functions 
Sending Email with PHP 
Working with Conditions 
magic_quotes_gpc 
Getting a Directory Listing 
Loops 
preg_match() 
By Reference vs. By Value 
Inserting and Updating Records 
Two-dimensional Arrays 
File System Management 
Reusing Code and Writing Functions 
Looping through Arrays 
Superglobal Arrays 
auto_prepend_file and auto_append_file 
mysqli() Overview 
Session Functions 
PHP Functions 


• 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 ...
Optimising and Compressing Media
Modifying Bullets
Saving a Presentation as a PDF
Using Presenter View
Applying Borders
The Animation Pane
Using an Existing Template
Changing the Theme Colours
Editing Audio Clips
Recolouring an Image
Changing the Slide Background
Enhancing Images
Editing a Data Series
Understanding Action Buttons
Creating Custom Slide Layouts
Understanding Themes


• 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 ...
How Microsoft PowerPoint Works
Exiting Safely From PowerPoint
Make It Readable
Inserting a Title Slide
Using the Eyedropper
Copying Shapes
Editing Text
Moving and Resizing Placeholders
Applying Font Formatting
Changing Bullet and Numbering
Printing Handouts
Applying a SmartArt Style
Accessing the Help Window
Using Resume Reading
Reusing Slides
Understanding Slide Layouts
Slide Numbers
Using the Zoom Tool
Changing Presentation Views


• See Training Course Details...

---

SQL

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

• SQL (Structured Query Language) is central to working with any form of database. In this practical hands on course participants learn how to use the full potential of SQL to write complex queries. The course covers select statements, grouping and aggregating data, joins, subqueries and unions. Participants will also learn how to insert, update and delete data and how to create and alter Views and Stored Procedures. The course will significantly help anyone who needs to retrieve or manipulate information in a relational database. No prior knowledge of SQL is required.

• Some of the training topics covered include ...
Creating Stored Procedures
Sorting Records
Selecting All Columns in All Rows
Creating Views
Adding and Dropping Columns
Dropping Stored Procedures
The WHERE Clause and Operator Words
Checking for Equality
The NOT Operator
Benefits of Views
Relational Database Management System
Primary Keys
CASE syntax
Mathematical Calculations
Sorting By Multiple Columns
Columns
Popular Databases
Checking Multiple Conditions


• 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 ...
Select the Report Type Dialog
Choose Table Style or Matrix Style Dialog
Welcome to the Report Wizard Dialog
Reporting Services 2005 Toolbars
Previewing a Report with Parameters
Creating a Data Source and Dataset
Filters
Fields tab
Deploy Sample Reports to Report Server
Adding Fields to the Table Data Region
General
Entities
Using the Report Manager
Creating a Data Source View
Reporting Services 2005 Data Options
Create a Reporting Services 2005 Report Query
Resizing
Building a Table Report


• 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 ...
Investigate the list data region 
Investigate Reporting Services charts 
Ad-Hoc Reporting with Report Builder 2.0
Learn how to create a basic report using the SQL Server Reporting Services Wizard 
Discover the classes and methods exposed by the Reporting Services Web Service API 
Calculation and Formatting
Learn how to work with rich text to produce mail merge style reports 
Investigate the scheduling of report snapshots 
Discover how to create standard report subscriptions 
Learn about datasets and data regions 
Snapshots and Subscriptions
Dig into the use of unbound, multivalued, and cascading parameters 
Gain a basic understanding of the components behind SQL Server Reporting Services 
Explore how to use Report Builder to build ad-hoc tabular, matrix and chart reports Discover how to create Report Builder reports without using the wizards 
Understand scope as it applies to aggregate functions 
Introducing SQL Server Reporting Services


• 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 ...
Troubleshoot Package Failures Deploying Packages
Overview of Data Warehouse Components
Secure Databases Working with MDS and Windows Azure
Introduction to Data Warehouses
Debug Package Execution Components
Install Integration Services Working with Integration Services
Configure the Package Execution Strategy
Add Data Flow Components to a Data Flow Task
Create Expressions with Variables
Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
Execute SSIS Packages on the Server
Create Package Templates Implementing Data Flow
Execute Packages from Different Control Flow Working with Dynamic Variables
Change Granularity Creating Fact Tables and Columnstore Indexes
Examine MSI Packages
Add Packages to an SSIS Project Managing Control Flow
Create Dimensions
Track Changed Data Managing Data Flow
Perform Transformation Tasks
Overview of Data Warehouses


• See Training Course Details...

---

SQL Server Reporting Services SSRS 2012/2014

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

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

• Some of the training topics covered include ...
Installing and Configuring Reporting Services Reporting Services Architecture
Work with Multivalued Parameters  Enhancing Reports with Data Visualisations
Create A Shared DataSet for Northwind
Report Parameters
Built-in Functions
Rein in the Length of a Text Field
Create a  Parameterised Report
Installing SQL Server Data Tools
Reporting Services Modes
Formatting Tablix Rows and Columns Making Reports Interactive
Considering Report Layout Options
Using Charts in a Report
Sparkline
Using Unbound Parameters Understanding Report And Data Set Parameters
Create a Form-Like Report from a list Calculations Using Expressions And Functions
Create and Configure a Report Server Project
Shared Dataset Design View  Creating Ad Hoc Reports with Report Builder
Overview
Create a Pie Chart with Point Labels
Indicators


• See Training Course Details...

---

Transact SQL

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

• In this two day intensive course you will learn how to create queries to retrieve, add, update, and report from your SQL Server database. You will sort and aggregate data, use built-in functions, create stored procedures, subqueries, table operators, set operators, conditional operators, views, indexes, and explore SQL Server error handling features.

  The course is particularly suitable for Data Analysts or candidates involved in retrieving and reporting business and management information. No prior SQL knowledge is assumed.

• Some of the training topics covered include ...
Work with Window Functions
Analyze Data from Query Plans
Configure User-Defined Functions (UDF)
Work with Grouping Sets Managing Error Handling and Transactions
Create Queries to Test Nullability
Delete Data
Assign Aliases Using Queries
Combine Data Using Simple Joins
Work with SSPs and SMOs
Work with Dynamic SQL Working with Subqueries and Table Expressions
Work with Predicates
Manage Stored Procedures
Modifying Data
Work with Binary Data Types
Work with System Catalog Views Optimizing Query Performance
Manage Transactions Querying SQL Server System Metadata
Update Data
Group and Aggregate Data Programming in T-SQL
Manage Views
Work with String and Numeric Data Types
Sort the Queried Data


• See Training Course Details...

---

Visio

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline
• Some of the training topics covered include ...
with background pages
Working with links
Integration with PowerPoint
Working with Web-enabling features
Creating technical layouts
File and print properties
Drawing tools
Drawing scales
Planning a diagram
Brainstorming diagrams
Sharing diagrams using a browser
Project management diagrams
The start page
Creating a basic diagram
Custom themes and templates
Working with text
 Shape behaviors


• See Training Course Details...

---

Email us about this courses

---