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 ...
Create a Report Using the Standard Report Creation Wizard 
Previewing the Report 
Chart 
Creating Running Totals for a List of 
Creating Text Objects 
Browsing Field Data 
Sorting with a Parameter
Inserting Special Fields
Customizing Cross-Tab Group Names
Using the Chart Options 
Choosing a Data Source 
Understanding Crystal Formula Syntax 
Using Guides and Guidelines to Move and Align Objects 
Using Multiple Sections in Reports
Creating Multiple Groups in a Report 
Grouping on a Formula Field
Formatting Features 
Using the Formula Workshop and Editor 
Quick Formatting with the Template 


• 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 ...
Exporting to Windows Applications 
Browsing Field Data 
Understanding How Crystal Reports 
Record Selection Formula Templates 
Using Parameters in Conditional 
Creating an Unlinked Subreport
Charting Cross-Tabs
Group Sorting with a Parameter
Viewing and Editing the Select Formula 
Importing a Pick List
Adding Multiple Tables to a Report 
Cascading Parameter Fields 
Working with Cross-Tab Reports
Cross-Tab
The Main Components of the Design 
Using the Formula Workshop and Editor 
Working with the Page Commands 


• 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 ...
Refreshing the Data
Create a Report Using the Standard Report Creation Wizard
Drawing a Line
Learning about Linking
The Template Dialog Box Power Formatting
Conditionally Formatting Fields Creating Summary Reports and Charts
Adding Parameter Values to Text  Objects Allowing Multiple Values in Parameters
Creating Text Objects
Creating Report Alerts
Exporting to a Report Definition Format Using the Report Wizards
Inserting Lines and Boxes
Using Evaluation Time Functions
Creating Hyperlinks Creating Powerful Groups
Working with the Page Commands
Creating a Group
Formatting Sections
Exploring the Toolbars
Declaring a Variable
Creating a Cross-Tab Report
Quick Formatting with the Template Expert
Using a Parameter to Select Records


• See Training Course Details...

---

Crystal Reports 2016

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

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

  No prior Crystal Reports knowledge is assumed

• Some of the training topics covered include ...
Creative Usage for Report Alerts
Ordering Groups Based on Their Subtotals Using the Group Sort Expert Combining Multiple Tables
Sorting Records within a Group
Starting the Crystal Reports Program
Creating String Formulas
Applying a Formatting Style to the Cross-Tab
Browsing Field Data
Cascading Parameter Fields Using Advanced Formula Features
The Summaries Dialog Box
Inserting Lines and Boxes
The Group Sorting Dialog Box
Working with the Page Commands
Getting Help Formatting Features
Using the PDF Format for Crystal Reports
Summarizing Groups
Creating Boolean (True/False) Formulas
Displaying Parameter Fields
Drawing a Line
Placing Fields on the Report
Creating Report Alerts
Sorting with a Parameter


• 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 ...
Determining the Layout of the Report
Creating a Cross-Tab with Multiple Rows or Columns
Understanding How Cross-Tabs Affect Your Data
Grouping on a Formula Field
Creating Boolean (True/False) Formulas
The Formula Editor Toolbar
Exploring the Toolbars
Ordering Groups Based on Their Subtotals Using the Group Sort Expert Combining Multiple Tables
Understanding How Crystal Reports Processes the Data
Starting a New Report
Adding and Working with Text Objects
Helpful Hints for Formatting the Report
Formatting Sections
The Template Expert
Suppressing Rows, Columns or Totals
Importing a Pick List
Applying the DrillDownGroupLevel
Summarizing Groups
Manipulating Dates with Formulas
Using a Parameter to Select Records
Formatting the Subreport


• 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 ...
Box Shadow Transitions, Transforms, and Animations
Text Shadow
Image Borders
Video Formats
Flexible Box Model Vendor Prefixes
Backgrounds
Font Services
Targeting Widths and Devices with CSS3 Media Queries
Word Wrapping Colors, Gradients, Background Images, and Masks
Styling Video
Attribute Selectors
HTML5 Selectors and Pseudo Classes
Transitions and Transforms
Transitions Layout: Columns and Flexible Box
Negation Pseudo-Class
What is CSS3?
Layout: Columns and Flexible Box
The @font-face Rule
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 ...
Saving Queries
Microsoft Sequence Clustering Algorithm
Visio Data Mining Add-In  
Microsoft Logistic Regression Algorithm
Saving Results to the Database
Data View
Introduction to SQL Server Data Tools
Accuracy and Validation
Cross Validation
Excel PowerPivot Data Mining Add-ins
Models, Induction and Prediction SQL Server Analysis Services Data Mining Tools
Testing and Validation of Mining Models
Exploring Data
Microsoft Association Algorithm
Model Usage
Concepts and Terminology
Data Mining Wizard
Data Source
Topics include:
The Mining Model Prediction Tab


• 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 ...
Flexible Background Images
Flexible Grids
Flexible Images and Other Media
Flexible Images and Other Media
jQuery Mobile
Swiping to Change Pages
The Viewport
The Case for Flexible
Media Queries
Other Devices
The GeoLocation API
Drag-and-Drop Code Builder
Google Maps
Accessing Camera, Contacts, Calendar, and More - But Not Yet
The Viewport
Local Storage


• 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 ...
Enabling Tracked Changes
Using the PivotChart Filter Field Buttons
Creating Subtotals
Adding a List Box Control
Adding Worksheet Comments
Working With a Protected Worksheet
Testing a Validation
Modifying an Inserted Picture Data Linking
Working With PivotTable Grand Totals
Understanding How Controls Work
Finding the Difference From
Editing Worksheet Comments
Using Relative Names for Subtotals Data Consolidation
Providing Total Access to Cells
Setting the Default File Location
Creating Relative Names for Subtotals
Using Formulas as Validation Criteria
Deleting a Macro
Protecting a Worksheet
Creating a One-Variable Table
Setting Save Options


• 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 ...
Adding Commands to the QAT
Using the Format Painter Cell Alignment
Worksheet Wisdom Sorting Data
Changing Fonts
Increasing and Decreasing Decimals Row and Column Formatting
Changing Background Colours
Formulas That Multiply and Divide
Selecting a Printer
Understanding the Charting Process
Understanding Number Formatting
The Print Options Creating Charts
Extracting With Flash Fill Moving Data
Summing Non-Contiguous Ranges
Growing and Shrinking Fonts
Inserting Cells Into a Worksheet
Recent Files and Folders Editing in a Workbook
Specifying the Number of Copies
Vertical Cell Alignment
Selecting Rows
Resizing a Chart


• 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 ...
Manipulative Functions
Freezing Rows and Columns
Using Shape Styles
Inserting Table Columns
Quick Tables Worksheet Tables
Applying Alternate Currencies
Extracting Dates and Numbers Worksheet Techniques
Using the More Borders Command
Modifying a Custom Fill List
Hiding a Worksheet
Applying a Bottom Border
The NOW Function
Printing Gridlines
Erasing Borders
Using the Name Manager
Deleting a Table Chart Elements
Customising the Display of Negative
Showing Gridlines
The More Borders Command
Unhiding Rows and Columns
Renaming a Table


• See Training Course Details...

---

Excel Power Pivot

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

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

• Some of the training topics covered include ...
Using Calculated Fields
Switching Visualisations
Creating a New Query From a File
Creating a Timeline
Filtering Data
Creating a Power View Sheet
Creating a Calculated Field
Updating a Power View Report
Using Related Power Pivot Fields
Adding a Data Column
Adding More Power Views
Managing Data Columns
Tiling Data in Power View
Adding Power View to the Ribbon
Understanding Get & Transform
Power Map
Working With a Power View Object
Changing the Look
Understanding the Query Editor
Understanding Power Map
Working With the Data Model


• See Training Course Details...

---

Excel Programming Using VBA

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

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

• Some of the training topics covered include ...
Understanding PivotTables
Using Debugging Tools
Assigning a Macro to the Quick Access Toolbar
Working with Properties
Determining the Value of Expressions
Working with the Combo Box Control
Setting Breakpoints
Introducing Visual Basic for Applications
Working with Inline Error Handling
Understanding Control-of-Flow Structures
Understanding Data Types
Adding Code to Controls
Using Visual Basic Help
Creating a PivotTable Using Worksheet Data
Writing an Error-Handling Routine
Using Break Mode during Run mode
Using the Toolbox
Working with Variable Scope
Using the Immediate Window to Call Procedures
Controlling Program Execution
Working with Boolean Expressions


• 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 ...
Start Attribute
Hidden Fields
Blocks and Inline Elements
Preformatted Text
Alternative Text
Type Selectors
The HTML Skeleton
Introduction to HTML
Exs (ex)
CSS Comments
HTML Elements
Making Images Accessible
Targeting New Windows
Image Links HTML Lists
The title Attribute HTML Images
Closing Tags
Form Elements
Submit and Reset Buttons
Phrase Elements
Checkboxes
Formatting 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 ...
Drag and Drop API
The video Element
autocomplete
Scripting Media Elements
datalist
Offline Application API
Modernizr
Laying out a Page with HTML5
HTML5 Canvas
Multiple Sources
url and email
The Problems XHTML Addresses
Browser Support
Display of HTML5 Structural Elements
The section Tag
Local Storage
Laying out a Page with HTML 4 - the "old" way


• See Training Course Details...

---

JavaScript

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

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

• Some of the training topics covered include ...
Validating Text areas
Validating Select Menus
Function Syntax
Strings
Passing Values to Functions
for in Loop Syntax
Basic Rules
do while Loop Syntax
typeof Operator
Image Rollover Function
A Loosely-typed Language
ParseFloat() and parseInt()
Conditionals
Switch / Case
JavaScript Syntax
Dot Notation
The this Object
Image Rollovers


• 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 ...
Optimize Selectors
Managing Effects
Namespacing Events
The for Loop
Working with JSONP
About Custom Events
Operations on Numbers and Strings
Managing Dependencies
Ajax Events
Chaining
Reserved Words
Effects-
ID-based Selectors
$.ajax Options
Triggering Event Handlers
Changing the Duration of Built-in Effects
Conclusion
Built-in Effects
Manipulating Attributes
Manipulating Elements


• 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
PhoneGap
Dialogs
Making Calls
Levels of Support
Data-role
Hosting vs. CDN
ThemeRoller
Sending Emails
Sliders
Progressive Enhancement
Virtual Integration with the Phone
Orientation (Portrait/Landscape)
Supported Devices/OSs/Browsers
Accessibility Support
Creating Your Own Plugin
Lists and Buttons
Video The Theme Framework


• See Training Course Details...

---

Microsoft Access

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

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

• Some of the training topics covered include ...
Adding Transactional Records
Action Queries
An Introduction to VBA
Creating a Relational Database
Database Security
Adding Records to a Table
Creating a Lookup Database
Creating and Using Reports
Creating and Using Macros
DIY Forms
Querying Techniques
Using a Navigation Form
Calculations in Queries
Sorting and Filtering
Modifying Forms
Designing a Lookup Database
Modifying Table Structures
Formatting Tables
Aggregation Queries
Data Validation
Multi Table Queries


• See Training Course Details...

---

Microsoft Access Programming Using VBA

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

• This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.

• Some of the training topics covered include ...
Using Message Boxes
Using the Select Case...End Select Structure
Handling Errors
Using Visual Basic Help
Working with Inline Error Handling
Creating a Function Procedure
Stepping through Code
Understanding the Form Object
Creating a Standard Module
Using the With Statement
Working with Methods
Setting Breakpoints
Understanding Modules
Using Input Boxes
Understanding the Order of Events
Working with the Application Object
Understanding Recordset Cursor Properties - Optional
Why Program in Access?
Using the CacheSize Property - Optional


• 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
Loading into Power BI Desktop
Summarising WORKING WITH THE POWER QUERY LANGUAGE “M”
Understand and utilize merges. LOADING YOUR DATA
Importing, Transforming, and Loading Data into Excel and Power Pivot
Understand working with relational data.
Understand the M interface.
Combining Worksheets
Understand and perform importing from SQL Server Analysis Services Multidimensional.
Transforming Data
Understand Power Query formulas.
Loading into Power Pivot
Loading Data
Appending Operations
Course topics include- INTRODUCTION TO POWER QUERY
Loading into Excel
Understand and perform importing from SQL Server Analysis Services Tabular. PERFORMING MERGES
Data Sources GROUPING AND SUMMARISING WITH POWER QUERY
Using PivotTables CONNECTING TO DATABASES
Importing Data
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
Logical Functions
Date Functions
Single Table Evaluation Context
Multiple Table Evaluation Context Working with Dates
Using Multiple Calendars Utilising Advanced DAX Functionality
Working with Calendars
Many-to-Many Relationships
Exploring Data Types
Utilizing Operators
Mathematical Functions
Information Functions
The CALCULATE Function
PowerPivot Data Model
Explaining Syntax
Relational Functions Understanding Evaluation Contexts
Conversion Functions
Introduction to DAX
Introduction to DAX
Handling Errors Using DAX 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 ...
Viewing reports from Excel files Shaping and Combining Data
Create relationships between data tables.
Using Excel as a data source for Power BI
Overview of the Power BI Data Model. Using Power BI
The developer API
Use Power BI with SQL Server Analysis Services data, including Analysis services models running in multidimentional mode. The Developer API
Power BI desktop queries
Create calculated columns, calculated tables and measures. Interactive Data Visualisations
Use Power Bi desktop to create interactive data visualisations. Direct Connectivity
Direct connectivity from Power BI desktop
Understand the DAX syntax and use DAX functions to enhance your dataset.
Create a Power BI dashboard
Using the Power BI mobile app
Topics covered include- Introducing Power BI
Shape data using formatting and transformations.
Importing different data sources into Power BI
Managing a Power BI solution
The Power BI Interface
Connecting to Power BI data
Creating Power BI reports
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
Merge datasets.
PowerPivot
Applying Filters
Creating Relationships
Use Bing maps.
Visualizing Power View Reports
Utilizing DAX Functions
Utilize themes.
Filter data.
Configuring Drill Through
Exploring the Power View Interface
Perform data cleaning.
Understand querying with natural language
Creating Charts
Load data.


• See Training Course Details...

---

Microsoft Project Integrated Course

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

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

• Some of the training topics covered include ...
Removing a Custom View and Its
Assignments
Understanding WBS Codes
Deleting an Unwanted Filter
Syncing Tasks With SharePoint
Steps in Creating a Project
Running an Edited Macro
Showing and Collapsing the Ribbon
Inserting Subprojects
Manipulating Report Data
Using a Lookup Table WBS Codes
Examining Task Information
Working With a Resource Master Downsizing Larger Projects
Working With Project Files
Entering Variable Costs
Formatting a Visual Report
Adding Simple Custom Fields
Understanding Project VBA
Scheduling


• 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 ...
Selecting a Printer
Working With Fixed Duration Tasks
Contouring Work Hours
Work Times for Multiple Assignments
Exiting From Project  Project Management
Working With Fixed Unit Tasks
Understanding the Backstage
Working With Split Screens
Project Operations
Adding Additional Resources
Checking Progress
Using the Ribbon
Entering File Properties Creating Tasks
Adding More of the Same Resource
Working With Non Effort Driven Tasks
Making Multiple Assignments
Navigating the Help Window
Working With Task Views
Creating a New Resource Calendar
Specifying Resource Usage
Understanding Scheduling Icons


• 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 ...
Checking Work For Materials Costs
Highlighting Tasks With Specific
Printing Specific Dates and Pages
Working With the Standard Views
Contouring Materials Usage
Formatting Table Fields
Hiding Open Files Tables
Viewing Task Slippage Project Views
Exporting to PDF
Rescheduling Tasks
Using a Custom Table
Using Elapsed Time
Understanding Gantt Chart Bars
Assigning Cost Resources
Keeping New Views Local
Changing Time Periods
Placing Printing Commands on the
Creating a New Table
Saving an Existing View
Creating Resource Problems
Adding Simple Custom Fields


• 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 ...
Applying a Newly Organised Item
Setting Project Links
Understanding Resource Sharing
Entering Lookup Table Values
Using Only Subproject Files
Running a Localised Macro
Breaking Subproject Links
Using a Lookup Table WBS Codes
Creating Custom Fields
Saving a Visual Report as a Template
Saving and Closing a Combined
Managing Shared Resources
Saving a Project as a Template
Using the Personal Template Folder
Removing a Custom View and Its
Opening Shared Resource Projects
Understanding Excel Visual Reports
How Graphical Reports Work
Formatting a Visual Report
Custom Fields


• 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 ...
Disaster Recovery - backup / restore 
Most-used Functions & Common tasks 
Excel Services 12 and AS (Web Services)
Actions - regular, drill-through and reporting 
SPS RS web parts & .NET 2.0 report viewer controls 
Cube Storage and Aggregation 
Cube processing options 
Intermediate SSAS
Refining Dimensions and Measures in BIDS 
Adding named sets 
Excel 2003 Pivot Tables 
OLAP Modeling 
Data Mining clients 
Understanding the development environment 
Beginning MDX 
Modeling intermediate fact tables 
MS BI is comprehensive - more than Analysis Services on SQL Server 
Adding scripts 
Understanding dimensional modeling - Dimensions (Type 1, 2, or 3) or rapidly changing 


• 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 ...
SSIS for DBAs: Using SQL Server Management Studio
The Execute SQL Task 
The Lookup Transformation 
The Properties window 
SSIS system variables 
The Data Mining Model Training Destination 
The Copy Column Transformation 
Control Flow: The OnError event handler 
Containers – grouping and looping 
Creating Database Maintenance Plans using SSMS 
The SSIS menu 
Launching BIDS 
The Aggregate Transformation 
Scheduling packages with SQL Server Agent
The Variables window 
The Slowly Changing Dimension Transformation 
Using variables in control flow 
Importing and Exporting Data 
Data Transformations 


• 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 ...
Introduction to MDX Queries
Understand the Calculation Subtab
Understand Writeback in Dimensions
Customize Aggregation Designs
Use the MDX Query Editor in SSMS
Understand SSAS Database Backup and Restore
Explore how to add MDX Script Commands
Review Semi-Additive Measures in OLAP Cubes
Understand the Cube Structure
Implement SSAS Security
Advanced Administration and Optimization
Discover how to add .NET Assemblies
Understand Data Mining Concepts
What Is Microsoft Business Intelligence?
Understand Performance Tuning and Optimization
Deploy and View a Sample Cube
Define Business Intelligence
Design Reports by using Report Builder
Model with SQL Server Business Intelligence Development Studio (BIDS)


• 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 ...
Data Flow Best Practices 
Control Flow
Understanding Variables 
Packaging Logging 
Transactions Support in Integration Services
Installing a Package 
Configurations 
Handling Slowly Changing Dimensions 
Using Variables in Control Flow 
Custom Integration Services Components 
Extending Integration Services Capabilities through Code 
Using Integration Services Beyond ETL 
Advanced Data Flow
Going Beyond ETL
Best Practices for Package Development and Design 
Advanced Control Flow Overview 
Using Advanced Transformations 
Exploring and Executing a Package Outside of BIDS 


• 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 ...
Understanding the Multidimensional Model
The Multidimensional Solution
Calculated Members.
Querying the Solution and Understanding DAX
Analysis Services Tools.
Common Analysis Services Solutions
Browsing the Model
Deploying
Understand and utilize security.
Understanding Perspectives
Handling Hierarchies.
Introduction to Microsoft SQL Server Analysis Services
Managing Measures
Deploy a multidimensional model.
Utilizing Translations
Choosing the Right 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 ...
Managing with Control Flow
Version Changes of SSIS From 2008-2012
Examining the SSIS Engine
Using the Workflow Tasks
Choosing the Script Task or Script Component
Understanding Variables
Utilizing Connection Managers SQL Server Integration Services Tasks
Understanding Packages
Utilizing Data Preparation Tasks
Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages
Coding the Script Task
Using Expressions in Packages Containers
Define and Use Variables and Parameters
Handling Errors Common SQL Server Integration Services Design Patterns
The SQL Server Integration Service
Data Loading with the Analysis Services Tasks
Administration of SQL Using the SQL Management Objects Tasks Data Flow
Using the Best Practices Debugging SQL Server Integration Services Packages
Designing to Troubleshoot: Using Precedence Constraints
Utilizing SQL Server Integration Services Data Typing
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 ...
Exploring Matrix
Utilizing Data Sources
Understanding HTML5 and Textboxes
SQL Server 2016 Report Builder Graphics
Planning Your Reports
Working with Map Wizard
Using the List Object to Combine Other Items
Formatting Reports
SQL Server 2016 Report Builder Basic Reports
SQL Server 2016 Report Builder Advanced Reporting
Filtering, Grouping, and Sorting
Utilizing Chart Wizard
Understanding Variances Between SQL Versions
Examining Management
Utilizing Charts
Exploring Subscriptions
Working with Expressions
Examining Maps
Utilizing Lists
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 ...
Error Configuration Roles and Permissions
Configure Analysis Services Project Properties
Designing Aggregations
Partition Writeback Calculations
KPIs Actions
Data Source object permissions
Change a Partition Source
Dimension permissions
Define a Referenced Relationship and Referenced Relationship Properties
Define Time Intelligence
Attach and Detach Analysis Services Databases
Create Measures and Measure Groups
Define a Data Source View
BI Wizard
Create Local Partitions
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Create a Dimension by Generating a Non-Time Table in the Data Source
Add or Remove Tables or Views in a Data Source View
Create a Dimension Using the Dimension Wizard
Use Aggregate Functions
Define Logical Primary Keys in a Data Source View


• 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 tabular 1400 models
Manage Roles by using SSMS
Test a model in DirectQuery mode
Delete Relationships
Enable DirectQuery mode in SSMS
Delete a Column
Create and Manage Measures KPIs
Analyze a tabular model in Excel Deploy tabular model solutions
Row filter mappings
Import from Power Pivot
Data sources supported in SSAS  tabular 2016 Create Tabular Models
Create and Manage Tabular Model Partitions
Import Data
Object-level security
Add columns to a table
Tabular model designer
Create a New Tabular Model Project
Import from Analysis Services
Change table, 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 ...
Sorting and grouping
Databars, sparklines, indicators, gauges, and maps
Secure access to reports by using authentication, permissions, and SSL encryption.
Publish a report to reporting services Working with Reporting Services Data
Drillthrough in mobile reports
Drilldown and drill through Sharing Reporting Services Reports
Preparing data for mobile reports
Overview of mobile reports
Schedules
Using Datasets Creating Paginated Reports
Data filters
Topics include Introduction to Reporting Services
Report parameters
Report caching, snapshots, and comments
Extend reporting services functionality with external assemblies.
Images and charts
Formatting data
Configuring data access with report builder
Configuring data access with report designer
Introduction to reporting services
Mobile report publisher


• See Training Course Details...

---

Oracle Business Intelligence - Create Reports and Interactive Dashboards

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

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

• Some of the training topics covered include ...
Legend View
Report Attributes
A Pivoting Scenario
Customizing the Table View
Using Dashboard Prompts
Adding Columns to a Request
View XML and SQL Calls Administering The Presentation Catalog
Logical Data Models
Previewing the Answers
Defining the Pivot View
Physical Data Models Data Warehousing and BI
Managing the Views Using Secondary Views
Navigating the Answers Interface
Sorting Data
Oracle BI Architecture
Downloading the Answers Report Formatting
Filtering Data
Reusing Filters
About Business Intelligence
Chart View
Creating a New Request


• See Training Course Details...

---

Oracle PL/SQL

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

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

• Some of the training topics covered include ...
Nesting Blocks 
PL/SQL Blocks and Programs 
Procedures and Functions 
Declaring and Opening Cursors 
Networking Packages 
Oracle-Supplied Packages 
Exception Handlers 
Cursor Parameters 
Dependencies and Validation 
Records and Collections
Oracle Directories 
The DBMS_UTILITY Package 
Creating a Stored Function 
Packages 
Creating a Stored Procedure 
External LOBs 
Maintaining Stored Programs
Stored Functions and SQL 


• 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 ...
Deleting a Table Definition 
Viewing Table Characteristics 
Intervals 
Compound Expressions 
SQL Queries 
Constraints 
Data Inconsistencies 
Datatypes 
The Aggregate Functions 
Oracle Pseudocolumns 
Oracle Versioning and History 
Combining SELECT Statements 
Other Database Objects 
Using Oracle SQL*Plus 
Using SQL Functions 
Updatable Views 
Connecting to a SQL Database 


• 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 ...
Authenticating Users 
PHP Statements and Whitespace
Opening a File 
Looping through Arrays 
Single Quotes vs. Double Quotes 
PHPMailer 
How HTML Forms Work 
Escape Character ( \ ) 
Writing to a File 
Code Organization 
Querying a Database 
Grouping ( [] ) 
Sessions 
Sending a Password by Email 
flock() 
Looping through Associative Arrays 
Superglobals 
PHP Operators 
Processing Form Input 
Array Manipulation 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 ...
Applying a Picture Style
Understanding the Chart Format
Applying Multiple Effects
Understanding Picture
Creating a Photo Album
Saving a Custom Template
Applying Colour Corrections
Using Presenter View
Applying a Theme
Using Quick Layouts
Inserting an Online Video
Resizing an Image
Chart Elements
Rehearsing Timings
Understanding Media in PowerPoint
Using a Custom Template
Saving and Sharing Presentations
Applying a Chart Style
Inserting a Screen Clip
Inserting Slide Numbers
Deleting a Customised Theme


• 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 ...
Presentation Methods and Hardware
Editing Shapes
Keyboard Shortcuts for Navigating
Arranging Shapes
Creating a Presentation
The PowerPoint Screen
Applying Paragraph Formatting
Creating a Hyperlink to Another
Inserting New Slides
Planning a Presentation
Adding Shapes Below
Understanding Font Formatting
Understanding the Status Bar
Printing Your Presentation
Understanding Dialog Boxes
Converting Text to SmartArt
Resizing Shapes
Printing Handouts


• See Training Course Details...

---

SQL

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

• This generic SQL course which is applicable to most databases assumes no prior knowledge. Participants will learn how to write queries which can extract required data from a relational database SQL also enables users to aggregate and group the filtered data. The course includes topics on to manipulating data with write insert, update and delete statements. On the second day delegates learn how to create tables, views and stored procedures.

• Some of the training topics covered include ...
Creating Tables
Table Aliases
Popular Databases
Dropping Tables
Benefits of Stored Procedures
Creating Views
Relationships
Aliases
The IN Operator
Sorting By Multiple Columns
The BETWEEN Operator
Foreign Keys
Sorting By a Single Column
CASE syntax
Aggregate Functions
Relational Database Management System
Creating Tables
Conditional Processing with CASE
NULL Values


• 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 ...
Settings
General
The Toolbox
Navigation
Tables Pane
Starting SQL Server Business Intelligence Development Studio
Creating a Chart Report
Design Area
Adding Fields to the Table Data Region
Reporting Services 2005 Client Components
The Main Components of the Design Environment
Using the Expression Editor Dialog
Filters
Static Subscription
Model Statistics
Data Output
Add Report Parameter to a Dataset
Explorer Pane
Designing the Layout
Reporting Services 2005 Distribution Options
Report Design Options


• 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 ...
Security
Managing Reporting Services
Find out how to use Report Manager to manage user accounts and roles 
Investigate how to manage Reporting Services projects using Report Manager 
Investigate how to use the Report Views controls inlocal mode to display reports that don’t involve Reporting Services 
Investigate the scheduling of report snapshots 
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 
Explore the potential deployment and security issues that might arise when working with custom assemblies 
Programming Reporting Services
Learn how to calculate group totals and percentages 
Find out how to display parameter values in report headers 
Explore how to create expressions in your reports using 
Learn how to enable and control report caching 
Learn about report variables and when you might need to use them 
Ad-Hoc Reporting with Report Builder 2.0
Learn how to create Report Model projects using Visual Studio and deploy them to a Reporting Services server 
Discover the various global collections that you can reference in your expressions 
Grouping and Sorting
Dig into the use of unbound, multivalued, and cascading 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 ...
Work with MDS Databases
Change Granularity Creating Fact Tables and Columnstore Indexes
Introduction to Data Warehouses
Debugging and Troubleshooting Packages
Add Script Tasks and Script Components to an SSIS Package
Configure MDS
Install Integration Services Working with Integration Services
Work with Windows Azure
Add Data Flow Components to a Data Flow Task
Cleanse Data Using DQS Managing SSIS Package Execution
Secure Packages
Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
Track Changed Data Managing Data Flow
Configure the Package Execution Strategy
Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
Create Dimensions
Create an SSIS Project
Add Packages to an SSIS Project Managing Control Flow
Profile OLTP Data
Deploy a Control Flow
Troubleshoot Package Failures Deploying 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 ...
Sharing Custom Code with Multiple Reports Calculations Using Expressions and Functions
Creating a Customer Contact List  Creating Ad Hoc Reports With Report Builder
Introduction to SQL Server Reporting Services
User Collection
Displaying the Parameter Value and Label for a Drop-Down List Parameter
Create a Custom Function  Managing Page Layout and Adding Interactivity
Reporting Services Modes
Create A Shared DataSet for Northwind
A Tour of the Report Builder Interface
Multivalued Parameters Dynamic Reports with Parameters
Report Project Configurations  Creating a New Report in the Report Designer
Create a Report Based on a Shared Data Set  Creating Reports With  SQL Server Data Tools
Sparkline
Formatting Text Boxes in the Text Box Properties Dialogue Box
Report Definition Language (RDL)
Indicators
Working with Maps and Spatial Data  Enhancing Reports with Data Visualisation
Building a Report with Report Builder
Create a  Parameterised Report
Creating a Custom Age Function
Installing and Configuring Reporting Services Reporting Services Architecture


• 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 ...
Analyze Data from Query Plans
Work with System Catalog Views Optimizing Query Performance
Manage Views
Filter the Queried Results
Create Queries Using Built-in Functions
Implement Error Handling
Work with Window Functions
Manage Triggers
Work with Binary Data Types
Work with System Databases
Work with Subqueries
Work with Data Access Technologies Implementing Stored Procedures
Assign Aliases Using Queries
Modifying Data
Update Data
Create Queries Using Join Algorithms
Work with Table Expressions Working with Set Operators, Conditional Operators, and Window Functions
Configure User-Defined Functions (UDF)
Work with SSMS Working with T-SQL
Control Program Flow
Work with Variables and Batches


• See Training Course Details...

---

Visio

• 2 day course
• Location: Uk
• Telephone on 01952 305730
• Course Outline
• Some of the training topics covered include ...
Drawing tools
Basic diagrams
Shape properties
Block, tree, and onion diagrams
Creating a basic diagram
Network diagrams
Windows, stencils, and objects
Getting started
Working with pages
Web site maps
Formatting shapes and lines
Drawing scales


• See Training Course Details...

---

Email us about this courses

---