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 ... Creating Multiple Groups in a Report
- See Training Course Details...
Using Parameters in Conditional
Working with Cross-Tab Reports
Processes the Data
Browsing Field Data
Changing Background Colors
Unlinked versus Linked Subreports
Creating Hyperlinks
Group Sorting with a Parameter
Group and Sort Direction
Using the Section Expert to Work with Sections
Modifying Groups
The Formula Editor Toolbar
Changing the Summary Operation
Using Bookmarks to Navigate Through Formulas
Creating a Dynamic Value List for Parameter Values
Starting a New Report
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 ... Placing Fields on the Report
- See Training Course Details...
Using Evaluation Time Functions
Expert
Creating String Formulas
Grouping Data in Date/Time Intervals
Filter Types of the Select Expert
Creating a Simple Report
Using an Edit Mask to Limit String
Creating Custom Groups
Using Alias Names for Column and Row Headings
Sorting Records within a Group
Viewing and Editing the Select Formula
Declaring a Variable
Applying the Drill Down Feature
Creating Text Objects
Formatting Objects
Applying the DrillDownGroupLevel
Combining Multiple Tables
Using Multiple Sections in Reports
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 ... The Fields Dialog Box
- See Training Course Details...
Using Guides and Guidelines to Move and Align Objects
Using Group Selection to Filter the Records in the Report
Browsing Field Data
Linking a Subreport
Creating Multiple Groups in a Report
Inserting Lines and Boxes
Moving and Aligning Objects
When and Why to Group Records
Record Selection Formula Templates Grouping and Sorting Data
Creating a Cross-Tab Report
Formatting Sections Conditionally
Viewing and Editing the Select Formula
Using a Parameter Field
Format Painter
Using the Chart Options
Using Multiple Parameter Fields in Reports
Creating String Formulas
Group and Sort Direction
Customizing Cross-Tab Group Names Report Alerts
Adding Fields into a Text Object
Crystal Reports 2016
- 2 day course
- Location: Uk
- Telephone on 01952 305730
- Course Outline
-
This two day course introduces delegates the Crystal Reports 2016 design interface and report writing process. Participants will learn how to connect to an underlying database, extract filtered data, sort, group and aggregate data, add conditional formatting, use sub reports and parameters. The course also explores how users can determine which database tables need to be joined to create meaningful reports.
No prior Crystal Reports knowledge is assumed.
- Some of the training topics covered include ... Drawing a Line
- See Training Course Details...
The Record Selection Dialog Box
The Fields Dialog Box
Managing Resources with Explorers
Understanding Export Formats and Destinations
Group and Sort Direction
Selecting Records with Multiple Criteria
Grouping Data in Date/Time Intervals
Conditional Running Totals Prompting with Parameters
Customize Group Name Field
Modifying Individual Objects in the Chart
Calculating Percentages
Understanding How Crystal Reports Processes the Data
Cascading Parameter Fields Using Advanced Formula Features
Applying the Drill-Down Feature
Creating Boolean (True/False) Formulas
Unlinked versus Linked Subreports
Exporting to Windows Applications
Editing Charts
Using a Parameter to set N in a Top N or Bottom N report
Variable Scope
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 ... Group Sorting with a Parameter
- See Training Course Details...
Creating Multiple Groups in a Report
Inserting Special Fields Selecting Specific Records From the Database
Conditional Running Totals Prompting with Parameters
Creating Text Objects
Pass #2
Placing Fields on the Report
Assigning a Value to a Variable
Formatting Individual Cells
Understanding How Crystal Reports Processes the Data
Grouping Data in Date/Time Intervals
Using the Formula Workshop
Creating a Summary Report
Applying a Formatting Style to the Cross-Tab
Creating a Dynamic Value List for Parameter Values
Refreshing the Data
Pass #3
About the Formula Workshop
Template Considerations
Creating Running Totals for a List of Numbers
Using a Parameter Field
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 ... The Opacity Property
- See Training Course Details...
Responsive Images and the viewport Metatag
background-origin, and background-size Borders and Box Effects
Browser Support
Introducing CSS3
The Target Pseudo-Class
Fonts on the Web
Strategies
Transitions and Transforms
The @font-face Rule
Flexible Box Model Vendor Prefixes
Text Shadow
The History of CSS
Attribute Selectors
Video Formats
Backgrounds
What is CSS3?
HTML5 Selectors and Pseudo Classes
Structural Pseudo-Classes Fonts and Text Effects
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 ... Compare Mining Structures
- See Training Course Details...
Microsoft Linear Regression Algorithm
Microsoft Association Algorithm
Microsoft Naïve Bayes Algorithm
Data Preparation
Microsoft Sequence Clustering Algorithm
Data Mining Concepts
Model Usage
Data Mining and Results
Accuracy and Validation
Excel PowerPivot Data Mining Add-ins
Models, Induction and Prediction SQL Server Analysis Services Data Mining Tools
Types of Data Mining Algorithms
Data Mining Tab
Management
Data Mining Wizard
Creating Reports Using Reporting Services
The Mining Model Prediction Tab
Saving Queries
The User Interface
Concepts and Terminology
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 ... Consolidating the Web with Native Extensions
- See Training Course Details...
Media Queries
Foundation: A Responsive Grid Framework
Video Formats
PhoneGap
jQuery Mobile
Using max-device-width
Controlling the Video through JavaScript
HTML5: Mobile Specific
Local Storage
Accessing Camera, Contacts, Calendar, and More - But Not Yet
Integrating with the Home Screen
Building Responsive Sites
Optimizing for Mobile
Designing for Mobile Devices
Flexible Background Images
Media Queries
Flexible Images and Other Media
Embedding from YouTube or Vimeo
Excel Advanced
- 1 day course
- Location: Uk
- Telephone on 01952 305730
- Course Outline
-
A one-day course covering Microsoft Excel advanced topics.
- Some of the training topics covered include ... Creating Running Totals
- See Training Course Details...
Merging Scenarios PivotTables
Adding Worksheet Comments
Viewing a Macro
Consolidating From Different Layouts
Using Subtotals With AutoFilter
Using Formulas as Validation Criteria
Using a Subtotalled Worksheet
Adding a Group Box Control
Modifying an Inserted Picture Data Linking
Importing From an Earlier Version
Assigning a Macro to the Ribbon
Creating an Input Message
Understanding Grouping and Outlining
Adding Option Button Controls
Creating a Scenario Summary Report
Understanding Advanced Filtering
Displaying Scenarios
Creating Nested Subtotals
Assigning a Keyboard Shortcut to a Macro
Sharing Workbooks via OneDrive
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 ... Viewing the Formula Bar
- See Training Course Details...
Vertical Cell Alignment
Using the Blank Workbook Template
Creating Mixed References Font Formatting
Selecting Non Contiguous Ranges
Finding a Maximum Value
Making Basic Changes
Specifying the Number of Copies
Understanding the Backstage View
Changing the Chart Style
Checking the Spelling
Formulas That Multiply and Divide
Getting to Know Excel
The Print Options Creating Charts
Clearing a Filter
Using Wildcards Printing
Understanding Cells and Ranges
Navigating the Help Window
Understanding Copying in Excel
Repositioning a Chart
Formatting as Fractions
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 ... Adding More Operations
- See Training Course Details...
Showing Data Labels
Customising the Display of Negative
Preparing for Complex Formulas
Formulas
Understanding Number Formatting
Applying Alternate Currencies
Renaming a Table
Selecting Chart Objects
Quick Sparklines
Documenting Formulas Defined Names
The CHOOSE Function
Removing Borders
Setting Custom Margins
Grouping Worksheets
Quick Formatting
The More Borders Command
Formatting Text
Understanding the Format Pane
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 ... Understanding Get & Transform
- See Training Course Details...
Working With a Power View Object
Working With Scenes
Adding Power View to the Ribbon
Viewing and Editing a Tour
Working With Power View Fields
Understanding the Query Editor
Reducing Data Rows
Exporting a Tour as a Video
Using Related Power Pivot Fields
Displaying the Query Editor
Working With Data Model Fields
Creating a New Query From the Web
Changing the Look
Saving and Sharing Queries
Merging Queries
Enabling Power View
Power View
Navigating a Data Map
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 ... Editing a Macro in the Visual Basic Editor
- See Training Course Details...
Displaying the Developer Tab in the Ribbon
Understanding Data Types
Working with the Text Box Control
Launching a Form in Code
Creating a PivotTable Using Worksheet Data
Understanding PivotTables
Working with the PivotFields Collection
Running a Macro
Setting Control Properties in the Properties Window
Using Expressions, Variables, and Intrinsic Functions
Adding Code to Controls
Working with the Combo Box Control
Using the With Statement
Understanding Controls
Setting the Tab Order
Working with UserForm Properties, Events, and Methods
Working with the Code Editor
Working with the Command Button Control
Creating an Event Procedure
Understanding Collections
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 ... Adding a Caption
- See Training Course Details...
Get vs. Post
Paragraphs
Default Pages
Alternative Text
Id and Name Attributes
XHTML vs. HTML
Exs (ex)
Media Types and Units of Measurement
Password Fields
Relative Paths
Inserting Images
Picas (pc)
Inline Styles
Nesting Ordered Lists
Merging Cells HTML Forms
Documenting Changes
Unordered Lists
Creating Tables
Targeting New Windows
Benefits of Cascading Style Sheets
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 ... Some Other New Form Field Attributes
- See Training Course Details...
HTML5 Web Storage
Integrated APIs
Session Storage
Indexed Database API
Graceful Degradation
Other Storage Methods
New Features of HTML5
Getting Started with Canvas
novalidate
Multiple Sources
Accessibility
Additional Changes
min, max, and step attributes
progress and meter
Audio Tag Attributes
required
autocomplete
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 ... Variables, Arrays and Operators
- See Training Course Details...
Arrays
A Loosely-typed Language
Conditionals and Loops
Validating Select Menus
Storing User-Entered Data
for Loop Syntax
JavaScript Operators
Image Rollover Function
Properties
do while Loop Syntax
ParseFloat() and parseInt()
JavaScript Objects, Methods and Properties
JavaScript Functions
JavaScript Syntax
Square Bracket Notation
Backward Compatibility
Preloading
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 ... $.ajax Options
- See Training Course Details...
Objects
Triggering Event Handlers
The Setup
Creating New Elements
Use Stylesheets for Changing CSS on Many Elements
jQuery.fx.speeds
Working with Selections
Chaining
Best Performance Practices-
Using Functions
Connecting Events to Elements
Attributes
GET vs. Post
Doing Something When an Effect Is Done
Operators
Data Types
Self-executing Anonymous Functions
The while Loop
Disconnecting Events
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 ... Making Calls
- See Training Course Details...
plugin Architecture
Page Transitions
Buttons and Linking Pages
Virtual Integration with the Phone
What Is jQuery Mobile?
Video The Theme Framework
Ajax-driven Page Navigation
PhoneGap
Sending SMS Texts
Progressive Enhancement
Overview
Sliders
ThemeRoller
Dialogs
Supported Devices/OSs/Browsers
Dialogs Widgets and UI
Microsoft Access
- 2 day course
- Location: Uk
- Telephone on 01952 305730
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Action Queries
- See Training Course Details...
Calculations in Queries
Database Security
Adding Transactional Records
Multi Table Queries
Database Wellness
Modifying Table Structures
Modifying Forms
DIY Forms
Creating a Relational Database
Querying Techniques
Adding Records to a Table
Parameter Queries
Creating a Lookup Database
Creating and Using Forms
Designing a Lookup Database
Creating and Using Macros
Relational Database Design
Working With Records
Macros on Forms
Sorting and Filtering
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 the If...End If Decision Structures
- See Training Course Details...
Debugging Code
Setting Break Expressions
Using the Immediate Window to Call Procedures
Working with Boolean Expressions
Creating a Standard Module
Understanding Collections
Understanding VBA's Error Trapping Options
Creating a Function Procedure
Working with Variable Scope
Using the Select Case...End Select Structure
Guidelines for use of Branching Structures
Working with Recordsets
Organizing Code and Procedures
Controlling Program Execution
Using Intrinsic Constants
Using Debugging Tools
Considering Variable Scope and Lifetime Together
Working with the Code Editor
Understanding Data Types
Microsoft Excel Power Query
- 1 day course
- Location: Uk
- Telephone on 01952 305730
- Course Outline
-
This course familiarises the participant with Microsoft Power Query, a revolutionary data tool for Excel that allows you to intuitively discover and automate the import, transformation, and combination of data across a variety of data sources for use in Excel and Microsoft Power BI. Power Query is a free add-in for Excel that enhances the self-service Business Intelligence experience in Excel. The course uses Excel 2016, however Power Query works with Excel 2010 and above.
Participants should be familiar with Excel and the concepts of datasets and basic reporting including the use of PivotTables.
- Some of the training topics covered include ... Understand and perform importing from SQL Server Analysis Services Tabular. PERFORMING MERGES
- See Training Course Details...
Performing Merges
Understanding and Handling Special Situations
Grouping Options
Loading into Power Pivot
Loading into Power BI Desktop
Summarising WORKING WITH THE POWER QUERY LANGUAGE “M”
Loading into Excel
Power Query Interface
Course topics include- INTRODUCTION TO POWER QUERY
Understanding Data Types WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
Understand Power Query formulas.
Appending Operations
Using Ranges in Excel
Combining Worksheets
Transforming Data
Using PivotTables CONNECTING TO DATABASES
Importing, Transforming, and Loading Data into Excel and Power Pivot
Understand and perform importing from SQL Server Analysis Services Multidimensional.
Understanding the Issues
Working with Folders and Files
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 ... Date Functions
- See Training Course Details...
Logical Functions
Statistical Functions
Filter Functions
Many-to-Many Relationships
Understanding Values
Mathematical Functions
Introduction to DAX
Exploring Data Types
Multiple Table Evaluation Context Working with Dates
The CALCULATE Function
Conversion Functions
Information Functions
Aggregation Functions
Introduction to DAX
Single Table Evaluation Context
Using Multiple Calendars Utilising Advanced DAX Functionality
PowerPivot Data Model
Utilizing Operators
Explaining Syntax
Relational Functions Understanding Evaluation Contexts
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 ... Custom visuals Power BI mobile app
- See Training Course Details...
Topics covered include- Introducing Power BI
Shape data using formatting and transformations.
Understand the DAX syntax and use DAX functions to enhance your dataset.
Importing different data sources into Power BI
Use Power Bi desktop to create interactive data visualisations. Direct Connectivity
Viewing reports from Excel files Shaping and Combining Data
Connecting to Power BI data
Power BI desktop queries
Use Power BI direct connectivity to access data in Azure SQL data warehouse
Power BI embedded
Create relationships between data tables.
Overview of the Power BI Data Model. Using Power BI
Managing a Power BI solution
Direct connectivity from the Power BI service
Create calculated columns, calculated tables and measures. Interactive Data Visualisations
Direct connectivity from Power BI desktop
Combine data together from tables in your dataset. Modeling data
Using the Power BI mobile app
The developer API
Creating Power BI reports
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 ... Calculated Columns and Calculated Fields
- See Training Course Details...
Exploring the Power View Interface
Creating PivotTables
Introduction to Power BI
Load data.
Hiding Columns, Change Data Type, Sorting, and Filtering
Navigate the Power Map interface.
Theming Reports
Creating Charts
Filter data.
Add time to a presentation.
Examining Tiles
Manage modifications.
Use Bing maps.
Using Cards
Understanding DAX
Utilizing Matrix
Understand querying with natural language
Drill Through
Adding Slicers to Reports
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 ... Working With Tables
- See Training Course Details...
Checking Work For Materials Costs
Simple Resource Assignments
Using Print Preview
Creating a New Report
Preparing for the Master Project
Using a Custom Visual Report
Showing and Collapsing the Ribbon
Running an Edited Macro
Creating the Resource File
Tasks and Resources
Creating a Deadline
Other Sources of Assistance Resource Levelling
Working With Gridlines
Opening the Resource Pool Only
Understanding Overtime
Formatting Chart Objects
Using Only Subproject Files
Understanding Graphical Reports
Setting Project Links
Working With Fixed Unit Tasks
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 ... Critical Path and Project Slack
- See Training Course Details...
Entering Public Holidays
Inactivating a Task Resourcing a Project
Using the Ribbon
Understanding the Gantt Chart
Using Google to Get Help
Resource Assignment Summary Assigning Resources
Adding Additional Resources
Examining Task Information
Gantt Chart View
Creating Dependencies in Task Entry
Understanding Sheet Views
Tasks and Resources
Entering File Properties Creating Tasks
Creating a New Resource Calendar
Working With Fixed Unit Tasks
Calendar Options
Printing a Gantt Chart
Task Types and Work Effort
Understanding the Backstage
Adding More of the Same Resource
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 ... Rescheduling Tasks Assigning Materials
- See Training Course Details...
Consumption
Manually Updating Tasks
Using a Custom Table
Using a Custom Filter
More Highlight Filters
Tracking Down Over Allocations
Changing Bar Styles Advanced Printing
Reviewing Our Project
Formatting for Non-Working Time
Creating a Custom Combination View
Customising the View Menus
Entering Delayed Tasks
Creating a Deadline
Printing Headers
Using Custom Views
Using The Tracking Box
Rescheduling Tasks
Assigning Material Costs
Editing Existing Filters
Exploring Tables
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 ... Running an Edited Macro
- See Training Course Details...
Combining Projects
Importing Data From Excel Working Collaboratively
Running a Report
Checking for Resource Links
Copying to Microsoft Excel
Creating the Custom View
Creating Smaller Projects
Organising the Global Template
Filtering a Visual Report
Setting Project Links
Understanding Custom Fields
Localising a Macro
Cloning an Existing Report
Creating the Downsized Master File
Creating a Custom Group for the View
Creating a Custom Table for the View
Formatting a Visual Report
Creating WBS Codes
Removing Unwanted Reports Visual Reports
Copying a Gantt Chart Image
Microsoft SQL Server 2005 Analysis Services SSAS
- 2 day course
- Location: Uk
- Telephone on 01952 305730
- Course Outline
-
In this course participants learn how to use Microsoft SQL Server 2005 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2005 developer the tools to build data warehousing and decision support system solutions. This course also provides information on end-user tools including Microsoft Excel 2003/2007 and Microsoft SQL Server 2005 Reporting Services.
- Some of the training topics covered include ... Understanding fact (measures) and cube modeling
- See Training Course Details...
Business Scorecards 2005 & ProClarity
Demonstration of SQL Reporting Services with cube as data source
Modeling intermediate fact tables
Welcome to the Real Time - Proactive Caching
Modeling changing dimensions - Dimension Intelligence w/ Wizard
Intermediate MDX
Data Mining dimensions
Adding named sets
KPIs
Partitions - relational and Analysis Services partitions
Refining Dimensions and Measures in BIDS
Data Mining clients
Future Directions & Integration with Office 12
Excel 2003 Pivot Tables
Cube Storage and Aggregation
Understanding the development environment
Examples of using each of the 9 algorithms (MS Clustering, MS Decision Trees, Naïve Bayes, MS Sequence Clustering, MS Time Series, MS Association Rules, MS Neural Network)
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
- See Training Course Details...
SSIS Package Deployment
The Conditional Split Transformation
The Variables window
The Data Conversion Transformation
Data Transformations
Data Flow Overview
Deploying and Managing SSIS Packages
The Web Service Task
The FTP Task
The Lookup Transformation
Using variables in control flow
Breakpoints in SSIS
Database Maintenance Plans
Configuration options
The Execute SQL Task
The Send Mail Task
Solution Explorer
Property expressions
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 ... What Is Microsoft Business Intelligence?
- See Training Course Details...
Review the Algorithms that SSAS Includes
Introduction to MDX Queries
Create Data Sources
Explore Scalability Options
Implement SSAS Security
Create Data Source Views
Explore Clustering
Learn how to Create Key Performance Indicators (KPIs)
Explore how to add MDX Script Commands
Understand Basic MDX Syntax
Introduction to SSAS Clients
Discover how to add .NET Assemblies
Deploy and Synchronize Databases
Understand the Calculation Subtab
Understand Data Mining Concepts
Implement SSIS to Manage SSAS Datbases
MDX Expressions
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 ... Deployment and Management Best Practices
- See Training Course Details...
Exploring and Executing a Package Outside of BIDS
Exploring and Executing an Integration Services Package in BIDS
Using Variables and Configurations between Packages
Working with Windows Management Instrumentation
Data Viewers
Overview of Control Flow in Integration Services
Going Beyond ETL
Using Integration Services Beyond ETL
Control Flow
Package Management
Installing a Package
The Data Flow Task
Event Handling
Error Handling and Logging
Best Practices for Package Development and Design
When Things Go Wrong
Transactions Support in Integration Services
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 ... Calculated Members.
- See Training Course Details...
Managing Measures
Analysis Services Installation and Architecture: One Product, Two Models
Browsing Perspectives and Translations
The Multidimensional Solution
Creating a Cube
Examining Deployment Options
Understand and utilize security.
Configuring Cube Options
Choosing the Right Model
Version Changes of SSAS from 2008-2014
Handling Hierarchies.
Processing Strategies
Common Analysis Services Solutions
Understanding the Multidimensional Model
Exploring Security
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 ... Choosing the Script Task or Script Component
- See Training Course Details...
Looping and Sequence Tasks
Using Package Hierarchies: Parent Child
Define and Use Variables and Parameters
Designing to Troubleshoot: Using Precedence Constraints
Data Loading with the Analysis Services Tasks
Performing Joins with the Merge Transformation
Utilizing Connection Managers SQL Server Integration Services Tasks
Examining the Transformation and Other Tasks Variables, Parameters and Expressions
Utilizing the Import/Export Wizard
Performing Joins with the Lookup Transformation
Utilizing Data Preparation Tasks
Administration of SQL Using the SQL Management Objects Tasks Data Flow
Overview of Containers
Understanding Parameters SQL Server Integration Services Tools
Working in the Explore Window
Using Expressions in Packages Containers
Managing SQL with the SQL Tasks
Managing with Control Flow
Using the Workflow Tasks
Version Changes of SSIS From 2008-2012
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 ... Working with Expressions
- See Training Course Details...
Exploring Matrix
Exploring Table or Matrix Wizard
Utilizing Lists
Utilizing Chart Wizard
Working with Datasets
Utilizing Dynamic Headers and Footers
Examining Parameters
Understanding Variances Between SQL Versions
Introduction to SQL Server 2016 Report Builder
SQL Server 2016 Report Builder Graphics
Using Tables
Mastering Data Region(s)
SQL Server 2016 Report Builder Advanced Reporting
Understanding HTML5 and Textboxes
Filtering, Grouping, and Sorting
Examining Security
Visualizing Your Company Report Templates
Understanding Visualizations
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
- See Training Course Details...
Delete a Data Source
Define Assignments and Other Script Commands
Overview of SSAS Multidimensional Modelling
Delete a Data Source View Dimensions
Processing Options and Settings
Create a Dimension by Using an Existing Table
KPIs Actions
Database permissions
Rename a Multidimensional Database Processing a multidimensional model
Define Time Intelligence
Use Aggregate Functions
Create Named Sets
Test an Action
Define Named Queries in a Data Source View
Define Attribute Relationships
Change a Partition Source
Backup Options Restore Options
Define Named Calculations in a Data Source View
Define a Referenced Relationship and Referenced Relationship Properties
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Microsoft SQL Server 2016/2017 Analysis Services Tabular Modelling
- 2 day course
- Location: Uk
- Telephone on 01952 305730
- Course Outline
-
A two day intensive course detailing how to create, deploy, use and manage tabular models in Microsoft SQL Server Analysis Services (SSAS) 2016 – 2017. The course is aimed at Data Analysts and SQL professionals. No prior knowledge of SSAS is assumed.
- Some of the training topics covered include ... Create a Relationship Between Two Tables
- See Training Course Details...
Add sample data to DirectQuery models
Delete Relationships
Delete a Column
Understanding DAX in Tabular Models Measures
Manage Roles by using SSMS
Row filter mappings
Import from Power View
Object-level security
Data sources supported in SSAS tabular 2017
Enable DirectQuery mode in SSDT
Analyze a tabular model in Excel Deploy tabular model solutions
Topics include- Overview of SSAS Tabular models
Analyze in Excel
Hide or freeze columns
Create and Manage Roles
Import from Power Pivot
Database Process Partitions in the Workspace Database Perspectives
Bi-directional cross filters Calculations
Create a New Tabular Model Project
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 ... Formatting data
- See Training Course Details...
Introduction to reporting services
Publish a report to reporting services Working with Reporting Services Data
Report sub-reports
Use report services configuration manager to reconfigure SSRS servers.
Topics include Introduction to Reporting Services
Preparing data for mobile reports
Mobile report publisher
Work with expressions and embedded code.
Drillthrough in mobile reports
Secure access to reports by using authentication, permissions, and SSL encryption.
Implementing report filters and parameters Visualizsng Data with Report Services
Creating a report with the report wizard
Data filters
Reporting services components
Report caching, snapshots, and comments
Sorting and grouping
Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
Reporting services tools Reporting Services Data Sources
Using Datasets Creating Paginated Reports
Add a drillthrough to a custom URL
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 ... Physical Data Models Data Warehousing and BI
- See Training Course Details...
Miscellaneous Tasks Building a Dashboard
Downloading the Answers Report Formatting
Narrative View
Variable References
OLAP, BI, DSS Introduction to Oracle BI Answers and Dashboards
Controlling the Report Definition
Managing Saved Content
View Selector View
Creating a New Request
Pivot Table Concepts
Managing Presentation Catalog Objects Deploying Requests to Dashboards
BI and Presentation Catalog Security
Previewing the Answers
Set Operations
Sorting Data
Viewing Supplementary Content
Gauge View
Legend View
No Results View Using Pivot Table Views
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 ... Overloading Package Functions and Procedures
- See Training Course Details...
Oracle Directories
Cursors
Triggers
Using VARRAYs
Types of Triggers
Calling a Stored Function
Maintaining PL/SQL Code
The Cursor FOR Loop
Associative Array Collections
PL/SQL Blocks and Programs
Named Parameter Notation
The DBMS_UTILITY Package
Calling a Stored Procedure
Using the %ROWTYPE Attribute
REF CURSOR Variables
External LOBs
Subtypes
Iterating Through Collections
Other Supplied Packages
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 ... Sequences
- See Training Course Details...
Date Functions
Joining Tables
Oracle Versioning and History
Self Joins
Transaction Management
Loading Tables From External Sources
Creating Views
Subqueries
SQL*Plus
Nulls and DISTINCT
Datatypes
Date Formats
Tailoring Your SQL*Plus Environment
Defining Tables
Using SQL Functions
Review of Relational Database Terminology
Sample Database
Oracle Pseudocolumns
The CASE...WHEN Expression
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 ... Sending Email with PHP
- See Training Course Details...
fwrite()
Reusing Code and Writing Functions
Array Manipulation Functions
Basic PHP Syntax
Negation ( ^ )
PHP Tags
Regular Expressions
Session Control and Cookies
PHPMailer
Perl-compatible Regular Expression Functions
How PHP Works
Authentication with PHP and SQL
mysqli() Overview
Using PEAR DB
Session Functions
Passing Variables via the Query String
Why use a database abstraction layer?
Creating a Customer Report
User Functions
PowerPoint Advanced
- 1 day course
- Location: Uk
- Telephone on 01952 305730
- Course Outline
-
Microsoft PowerPoint - Advanced Level is designed for users who are keen to extend their understanding and knowledge of the software beyond creating basic presentations.
- Some of the training topics covered include ... Inserting an Online Picture
- See Training Course Details...
Media and Action Buttons
Elements
Adjusting Row Heights
Positioning an Image
Inserting Action Buttons
Saving to OneDrive
Changing the Theme Colours
Presenting a Slide Show Online
Recording a Slide Show
Understanding the Chart Format
The Format Picture Pane
Setting Up a Self Running
Applying Multiple Effects
Enhancing Images
Understanding Chart Buttons
Adjusting Column Widths
Templates
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 ... Creating a New Blank Presentation
- See Training Course Details...
Understanding SmartArt
The Save As Place
Resizing Shapes
Opening a Presentation
Understanding How Help Works
Drawing Shapes
Inserting a Section Header Slide
Typing Text Using the Outline Pane
Previewing a Slide Show
How Microsoft PowerPoint Works
Printing Notes Pages
Slide Shows
Copying Shapes
Using Shortcut Menus
Using Google to Get Help
Arranging Shapes
Inserting a Picture With Caption Slide
The PowerPoint Screen
Inserting a Title Slide
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 ... The WHERE Clause and Operator Words
- See Training Course Details...
Creating Views
Relational Database Management System
Aggregate Functions
The BETWEEN Operator
Common Math Functions
Selecting All Columns in All Rows
Multi-table Joins
Sorting Records
Checking for Equality
Sorting By Multiple Columns
The LIKE Operator
WHERE and ORDER BY
Aliases
Adding and Dropping Columns
Concatenation
DELETE
The IN Operator
Tables
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 ... Building a Table Report
- See Training Course Details...
Dynamic Parameter Values (From Query)
Entities
Linked Reports
Deploy Sample Reports to Report Server
Creating a Report Model File
Report Model Generation Rules
Reporting Services 2005 Data Processing Extensions
Creating a New Report Project
Visibility
Formatting Reporting Services 2005 Reports
Creating a Report Model Data Source
Quick Formatting using Toolbar and Menu Options
Model Statistics
Chart Options
Managing Parameters
Understanding What Just Happened
Visibility
Report Builder Design Layout
Rendering Extensions
General
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 how to use the Report Views controls inlocal mode to display reports that don’t involve Reporting Services
- See Training Course Details...
Find out how to display parameter values in report headers
Explore the use of the Report Viewer controls to create Web pages and Windows Forms that render Reporting Services reports in place
Learn how to create Report Model projects using Visual Studio and deploy them to a Reporting Services server
Explore the basic architecture of SQL Server Reporting Services
Creating Tabular and List Reports
Learn how to create custom functions using the Code window
Discover interactive sorting
Investigate how to manage Reporting Services projects using Report Manager
Security
Managing Reporting Services
Learn how to use URL to integrate Reporting Services reports into your applications
Working with Parameters
Learn about datasets and data regions
Explore creating linked reports
Learn how to create a tabular report from scratch
Investigate what SQL Server Reporting Services can do
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Uk
- Telephone on 01952 305730
- Course Outline
-
Participants will learn to perform ETL (Extraction Transformation and Loading) operations by creating SSIS packages, managing a control flow and data flow, executing packages, and troubleshooting errors. To ensure the smooth functioning of the ETL operations, you will manage SSIS packages and secure them. Delegates will use SSIS packages to design and build a Data Warehouse.
The course requires a working knowledge of SQL.
- Some of the training topics covered include ... Add Data Flow Components to a Data Flow Task
- See Training Course Details...
Examine MSI Packages
Add Script Tasks and Script Components to an SSIS Package
Deploy a Control Flow
Introduction to Data Warehouses
Add Packages to an SSIS Project Managing Control Flow
Cleanse Data Using DQS Managing SSIS Package Execution
Create Package Templates Implementing Data Flow
Debugging and Troubleshooting Packages
Create Fact Tables
Debug Package Execution Components
Track Changed Data Managing Data Flow
Configure MDS
Secure Packages
Configure the Package Execution Strategy
Overview of Data Warehouse Components
Overview of Data Warehouses
Profile OLTP Data
Examine Data Warehousing Concepts
Secure Databases Working with MDS and Windows Azure
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 ... Introduction to SQL Server Reporting Services
- See Training Course Details...
Displaying the Parameter Value and Label for a Drop-Down List Parameter
Working with Maps and Spatial Data Enhancing Reports with Data Visualisation
The Global Collections
Designing the Page Layout
Writing and Using Report Expressions
Drilldown Reports Managing Page Layout and Adding Interactivity
Creating a Shared Data Source and Data Sets
Shared Dataset Design View Creating Ad Hoc Reports with Report Builder
Native Mode Architecture
Work with Multivalued Parameters Enhancing Reports with Data Visualisations
Rein in the Length of a Text Field
Using the Expression Editor Using Built-in Report Operators and Functions
Create a Drop-Down List Parameter
Report Parameters
Groups before Row Headers
Preview Performance
Report Project Files and Folders
Using Report Parts Shared Data Sets
The Report Designer Creating Reports with SQL Server Data Tools
Transact SQL
- 2 day course
- Location: Uk
- Telephone on 01952 305730
- Course Outline
-
This two day Transact SQL course introduces delegates to querying and manipulating data in Microsoft SQL Server. The course explores how to write select statements, join tables, create subqueries, write update, delete and insert statements. It differs from the generic SQL course in that if explores Microsoft SQL Server product specific functions and the notation associated with creating Microsoft SQL Server User Defined Functions, Stored Procedures and Triggers.
The course id practical, hands on and does not assume prior SQL or programming experience.
- Some of the training topics covered include ... Work with Table Expressions Working with Set Operators, Conditional Operators, and Window Functions
- See Training Course Details...
Update Data
Work with Grouping Sets Managing Error Handling and Transactions
Manage Triggers
Work with System Catalog Views Optimizing Query Performance
Work with Binary Data Types
Manage Transactions Querying SQL Server System Metadata
Work with Variables and Batches
Create Queries to Test Nullability
Work with Date and Time Data Types
Perform Advanced Filtering Querying Data from Multiple Tables
Filter the Queried Results
Work with the XML Data Type Sorting and Filtering Data
Work with String and Numeric Data Types
Work with Predicates
Overview of SQL Server
Getting Started with SQL Server 2012
Group and Aggregate Data Programming in T-SQL
Delete Data
Control Program Flow
Create Queries Using Built-in Functions
Visio
- 2 day course
- Location: Uk
- Telephone on 01952 305730
- Course Outline
- Some of the training topics covered include ... Sharing diagrams using a browser
- See Training Course Details...
Custom themes and templates
Integration with PowerPoint
Reporting
Organization charts
Brainstorming diagrams
Compound lines
Drawing tools
Business diagrams and Web site mapping
Presentation Mode
Rack diagrams
Database model diagrams
Working with Web-enabling features
Drawing scales
Organization charts
with background pages
Working with text
Email us about this courses