Character Animator: Initiation

Goals


- Understand and carry out character animation

- Prepare, carry out and finalize an animation project

Program

Positioning of Character Animator in the AV suite from Premiere Pro to After Effects
What is animation?
Understand the methodology
History, methods and techniques of animation

Start a new project
Discover the interface: the Project, Properties, Timeline, History, Scene panels …
Understand the work logic and the methodology of the software

Cut into sequences
Define and create the different planes
Create the environment

Define and configure the document
Define the « structure » of the puppet
Prepare and create the different parts on the layers
Define the hierarchical levels
Define the hinges and control points
Create dependencies and link the various elements to each other

Workshop: make a simple character illustration

Prepare your media
Adjust the properties of the different elements
Modify expressions
Retrieve or download new elements
Synchronize the mouth, eyes, eyebrows with facial recognition

Workshop: making a first puppet animation

Create an entire character in Photoshop or Illustrator
Create hinges and different control points
Import elements into Character Animator

Define the walking kinematics
Control the different elements
Add a behavior
Control the animation with the mouse and the keyboard
Use the physical parameters

Workshop: make a first puppet animation

Save the scene
Export the sequence to PNG or WAV file

Workshop: finalize and export the animation

Duration

2 days

Price

£ 1555

Audience

Graphic designers, motion designers, animation, web and audiovisual professionals

Prerequisites

Know and master Photoshop and Illustrator software. Having followed the After Effects Deepening training and / or having the equivalent knowledge is a plus

Reference

FOR100605-F

Sessions

Contact us for more informations about session date

Project Management: Initiation + Advanced

Goals


- Train consultants or company staff in the project management methodology, involved in IT projects for customers or in an internal structure

- Acquire best practices, in order to guarantee the quality of deliverables and monitoring of results

Program

Feasibility study
Specifications
Synoptic of the process
Implementation approach
Planning
Budget estimate
Development cycles

The project approach
Organization
Clarify the framework of the project
Build the organization chart of the tasks
Choose the development model
Anticipate the risks
Set up a team

Establish a provisional schedule
Establish a provisional budget
Make a launch meeting with the client
Write the Project Quality Plan (PQP)

Development cycle
Reception and control of deliverables
Management
Control costs
Control quality
Control risks
Control communication
Control requests and evolutions
Project assessment or how to capitalize

Module 1: the project manager’s toolbox   
Module 2: control complexity Illustration from standard
Microsoft Project software and overview of
existing tools

Duration

4 days

Price

£ 2550

Audience

Managers, Project managers

Prerequisites

Mastery of the basic concepts of project management

Reference

GES100271-F

Reminder of the principles of project management
Manage project schedules
Manage tasks
Control the schedule of tasks
Optimize resources

Manage costs
Analyze the project and optimize
Communicate
Monitor the project
Capitalize

Evaluate the dimension of the project
Identify the impacts on the processes
Control contractual relationships
Make effective reporting
Define multi-project dashboards
Allocate technical and functional resources between projects
Control advanced planning and scheduling techniques
Know the key points to reduce certain delays
Identify common pitfalls
Apply best practices
Define priority criteria
Make trade-offs

Choose indicators and units of work
Organize and consolidate progress Prepare management decisions
Prepare dashboards
Renegotiate deadlines and budgets
Validate the relevance of project deliverables
Re-frame deviations if necessary
Control software delivery
Know the fundamentals of an IT contract

Sessions

Contact us for more informations about session date

Project Management: Initiation

Goals


- Train consultants or company staff in the project management methodology, involved in IT projects for customers or in an internal structure

- Acquire best practices, in order to guarantee the quality of deliverables and monitoring of results

Program

Feasibility study
Specifications
Synoptic of the process
Implementation approach
Planning
Budget estimate
Development cycles

The project approach
Organization
Clarify the framework of the project
Build the organization chart of the tasks
Choose the development model
Anticipate the risks
Set up a team

Establish a provisional schedule
Establish a provisional budget
Make a launch meeting with the client
Write the Project Quality Plan (PQP)

Development cycle
Reception and control of deliverables
Management
Control costs
Control quality
Control risks
Control communication
Control requests and evolutions
Project assessment or how to capitalize

Module 1: the project manager’s toolbox   
Module 2: control complexity Illustration from standard
Microsoft Project software and overview of
existing tools

Duration

2 days

Price

£ 1367

Audience

Managers, Project managers

Prerequisites

Mastery of the basic concepts of project management

Reference

GES100277-F

Sessions

Contact us for more informations about session date

CMMI: The fundamentals

Goals


- Prepare to pass the ITIL Service Strategy (SS) certification exam Analyze the principles, techniques and relationships to create an SS Identify the purpose, scope and objectives of each SS process Assess governance IT to strategize and leverage governance frameworks and organizations

Program

– Definition and concepts Components of the CMMI model
– Return on investment
– Exercise: improvement objectives

– Use of the reference book
– CMMI component
– Process domain
– Nature and type of components

– Staged and continuous representation
– Level of maturity and aptitude
– Institutionalization
– Generic practices
– Exercise: process description

– Requirements development (RD)
– Requirements management (REQM)

– Project planning (PP)
– Project
monitoring (PMC) – Risk management (RSKM)
– Supplier contract management (SAM)

– Configuration Management (CM)
– Quality Assurance (PPQA)
– Measurement and Analysis (MA)
– Exercise: Gap Analysis
– Decision Making (DAR)
– Causal Analysis (CAR)

– Technical solution (TS)
– Product integration (PI)
– Verification (VER)
– Validation (VAL)
– Exercise: impact of an evolution

– Continuous improvement strategy (OPF)
– Definition of the standard process (OPD)
– Exercise: process library
– Integrated project management (IPM)
– Innovation and deployment (OID)
– Training (OT)
– Quantitative project management (QPM) )
– Fundamentals of quantitative management
– Process performance (PPO)
– Exercise: case study

– Causal analysis, innovation and deployment in quantitative mode
– Exercise: improvement objectives and measures

– IPPD concept – IPPD
impact on the definition of processes and integrated project management

– Representations
– Interrelation between components
– « Equivalent Staging »
– Exercise: correspondence between statements and CMMI practices

– Source of information on the CMMI
– IDEAL approach

Duration

3 days

Price

£ 1893

Audience

IT directors, managers, system administrators, developers, all those concerned by IS

Prerequisites

Have taken the ITIL Foundation course or equivalent concepts

Reference

GES101221-F

 

Sessions

Contact us for more informations about session date

Software Architecture: Fundamentals

Goals


- Understand the different software architectures

Program

Software development process, continuous integration
Software architecture: definition, representations (components, relationships, interactions)
Project stakeholders, application architecture in the life cycle of a project
Software architecture in an Agile context
Choice factors an architecture Architectural
view: concept, types of links, examples
Documentation of software architecture: Technical Architecture File, Component design guide
Packaging / deployment issues

Workshop: construction of a framework for a technical architecture file

Notion of style,
Panorama of architectural styles guide :
– Call-and-return
architecture
– Layered architecture
– Data-centric architecture – Data -flow
architecture
– Object -oriented architecture – Agent-oriented architecture

Quality attributes
Measurement scenarios and graphical representation
Software quality in an agile approach

Workshop: Choice of quality attributes

Notion of architectural
tactics User-oriented tactics : performance, usability, …
Developer-oriented tactics: testability, modifiability, …

Workshop: Choice of tactics in relation to the chosen quality attributes

Asynchronous request / response middleware
Component-based architectures: JavaEE or other
Multi-level architectures: clustering and load balancing
Rich applications (Rich Internet Applications)
Mobile applications: native vs hybrid
Cloud infrastructure: IaaS vs PaaS vs SaaS

Definition of
ESB
architecture RESTFul architectures
SOAP protocol vs REST architecture
Microservices
Web Services Message Router vs Enterprise Service Bus

Analysis models of an architecture
Design of an architecture
Evaluation of an architecture
UML modeling of an architecture:
– Functional analysis and use case
diagrams – Component and composite structure
diagrams – Deployment diagrams

Workshop: Finalization of the Technical Architecture File.

Duration

3 days

Price

£ 1914

Audience

Architects, Project managers, Developers

Prerequisites

Project management concepts

Reference

GES922-F

 

Sessions

Contact us for more informations about session date

PowerPoint Initiation + Advanced and passing of the TOSA certification

Goals


- Learn to create presentations with PowerPoint

Program

PowerPoint presentation
Different uses of the software
Presentation tips

Description of the ribbon
Interface management
Create a new slide show
Using slide show templates

Add / remove slides Slide
layouts
Group your slides into sections
Move a slide

Reserved areas
Inserting and formatting text
Inserting and customizing shapes
Inserting and modifying images
Creating a photo album
Inserting tables
Using WordArt
Graphics and organization charts
Organizing inserted content

Use slide themes
Add a background
Create your own theme

Animating content
Personalizing your animation
Timing of animations (start, duration, delay)
Transitions between slides
Timing of transitions

Launching the slideshow mode
Creating a personalized slideshow
Configure the slideshow
The other display modes
Inserting a header and footer
Adding comments

Adding hypertext links
Adding an action on an object
Inserting multimedia content: audio and video
Printing the document
Managing the slide master
Creating its presentation template

Duration

2 days

Price

£ 750

Audience

Everyone

Prerequisites

Knowledge of Word and Excel

Reference

BUR557-F

  

Compare two presentations
Protect a slide show
Check that there are no problems
Share your presentation
Customize the interface

Definition of presentation objectives
Creation and organization of the plan
Layout of the presentation
Creation of the mask
Creation of standard slides (new part, contents)
Creation of the presentation and animations
Proofreading and corrections

Workshop: Creation of a presentation for your personal or professional project

Synthesis
Questions / Answers

Review of the important elements Revisions before certification
Passing the TOSA certification on PowerPoint

Sessions

Contact us for more informations about session date

Word : Fundamentals + Advanced functions + VBA and Passage of the TOSA certification

Goals


- Discover the new features of Office

- Know the main features of Word

- Be able to write a simple letter

- Know how to send a mail merge

- Work in a group

- Introduction to VBA programming

- Know the word objects

Program

Presentation of Word
Description of the ribbon
The ruler
Windows
Display mode
Show / hide formatting marks

Create
Open, save, close
Use recent documents
Create a document based on a template
Save a document in Word 97-2003 format

Select text
Move around the document
Move and duplicate text
Find a character string
Perform a deep search
Replace one string with another
Use automatic spell checking
Replace formatting

The styles for a layout
Add, modify, delete a Style

How to use themes?
Mix themes
Printing and printing options

Design Resize
Insert, move or delete a row
Insert, move or delete a column
Define formatting and wrapping

Margins
Orientation format Page
numbering
Change the format of page numbers Page
borders
Custom header and footer
Print

Duration

5 days

Price

£ 1725

Audience

Everyone

Prerequisites

Knowledge of the PC environment

Reference

BUR410-F

  

Advice and Methodology for creating an attractive document
Application
A simple letter and its envelope
A simple report on 2 pages

Using WordArt
Putting the company logo on a document
Positioning photos
Using the header and footer
Create a new document from existing documents

Create and manage a document on several columns

Prepare Word to manage your templates
Create a template
Use, edit a template
Use templates on Office.com

Print
Fax
Send by email
Send by email in PDF format

Microsoft’s OneDrive service
Creating a OneDrive account
Using the OneDrive service

Create a table of contents
Create a custom table of contents
Update a table of contents
Save a custom table of contents
Define an index entry
Insert the index table
Update an index table

Create a table of figures

Create a form
Insert controls into a form
Use the merge wizard
Prepare to merge
Data source
Main document
Merge

Create a comment
Show / hide comments
Manage comments
Make a document available to several users
Merge documents

Customize the Quick Access Toolbar
Customize the Ribbon

Copy Excel data to Word
Insert an Excel spreadsheet into Word
Create hyperlinks to other applications
Save as HTML

Objectives of a macro
Displaying the Developer tab in the ribbon
Recording a macro
Running a macro
Running a macro via shortcuts (in ribbon, button, etc.)
Managing macros
Viewing the code of a macro

Objectives of the VBA language
Presentation of VBA
Some definitions
Use of VBA
Principle of operation of a macro

Modifying the code of a macro
Language syntax
Variables
Text, numeric or date data types
Arrays
Constants
Operators

The Application object
The Document
object
The Paragraphs object
The Range object The Characters object

Operating principles
Condition structures (If, Select Case)
Multiple conditions (And / Or)
Presentation of loops
Looping according to a counter (For Next)
Looping according to a condition (Do Loop)

Presentation of the form
Customize a form
Events of form objects
Running / closing a form

Synthesis
Questions / Answers

Review of the important elements Revisions before certification
Passing the TOSA certification on Word

Sessions

Contact us for more informations about session date

Word : Fundamentals + Advanced functions

Goals


- Discover the new features of Office

- Know the main features of Word

- Be able to write a simple letter

- Know how to send a mail merge

- Work in a group

Program

Presentation of Word
Description of the ribbon
The ruler
Windows
Display mode
Show / hide formatting marks

Create
Open, save, close
Use recent documents
Create a document based on a template
Save a document in Word 97-2003 format

Select text
Move around the document
Move and duplicate text
Find a character string
Perform a deep search
Replace one string with another
Use automatic spell checking
Replace formatting

The styles for a layout
Add, modify, delete a Style

How to use themes?
Mix themes
Printing and printing options

Design Resize
Insert, move or delete a row
Insert, move or delete a column
Define formatting and wrapping

Margins
Orientation format Page
numbering
Change the format of page numbers Page
borders
Custom header and footer
Print

Duration

3 days

Price

£ 1125

Audience

Everyone

Prerequisites

Knowledge of the PC environment

Reference

BUR503-F

   

Advice and Methodology for creating an attractive document
Application
A simple letter and its envelope
A simple report on 2 pages

Using WordArt
Putting the company logo on a document
Positioning photos
Using the header and footer
Create a new document from existing documents

Create and manage a document on several columns

Prepare Word to manage your templates
Create a template
Use, edit a template
Use templates on Office.com

Print
Fax
Send by email
Send by email in PDF format

Microsoft’s OneDrive service
Creating a OneDrive account
Using the OneDrive service

Create a table of contents
Create a custom table of contents
Update a table of contents
Save a custom table of contents
Define an index entry
Insert the index table
Update an index table

Create a table of figures

Create a form
Insert controls into a form
Use the merge wizard
Prepare to merge
Data source
Main document
Merge

Create a comment
Show / hide comments
Manage comments
Make a document available to several users
Merge documents

Customize the Quick Access Toolbar
Customize the Ribbon

Copy Excel data to Word
Insert an Excel spreadsheet into Word
Create hyperlinks to other applications
Save as HTML

Objectives of a macro
Displaying the Developer tab in the ribbon
Recording a macro
Running a macro
Running a macro via shortcuts (in ribbon, button, etc.)
Managing macros
Viewing the code of a macro

Sessions

Contact us for more informations about session date

Word : Fundamentals

Goals


- Discover the new features of Office

- Know the main features of Word

- Be able to write a simple letter

Program

Presentation of Word
Description of the ribbon
The ruler
Windows
Display mode
Show / hide formatting marks

Create
Open, save, close
Use recent documents
Create a document based on a template
Save a document in Word 97-2003 format

Select text
Move around the document
Move and duplicate text
Find a character string
Perform a deep search
Replace one string with another
Use automatic spell checking
Replace formatting

The styles for a layout
Add, modify, delete a Style

How to use themes?
Mix themes
Printing and printing options

Design Resize
Insert, move or delete a row
Insert, move or delete a column
Define formatting and wrapping

Margins
Orientation format Page
numbering
Change the format of page numbers Page
borders
Custom header and footer
Print

Duration

1 day

Price

£ 375

Audience

Everyone

Prerequisites

Knowledge of the PC environment

Reference

BUR411-F

  

Sessions

Contact us for more informations about session date

Excel : Fundamentals + Advanced functions + VBA and Passing of the TOSA certification

Goals


- Discover the new features of Office

- Know the main features of Excel

- Be able to perform calculations and use functions

- Know how to handle graphics and pivot tables

- Introduction to VBA programming

Program

Presentation of Excel
Description of the ribbon
Workbooks and worksheets
Rename, insert, move, delete a worksheet
Move around in the workbook (using the keyboard, menus, mouse)

The different ways of selecting cells
Modifying the height and width of rows / columns
Inserting rows and columns
Formatting the content of the cell (font, colors, etc.)
Borders
Alignment in the cell
Merge cells
Apply a format cell

Creating tables
Automatic formatting
Creating a custom style

The formula bar
Addition, subtraction, multiplication, division
Use of parentheses
Percentage format
Copy calculations

Layout Page
breaks
The printing area
Printing and printing options

The different display modes
Show / hide information
Zoom
Freeze the panes

Duration

5 days

Price

£ 1725

Audience

Everyone

Prerequisites

Knowledge of the PC environment

Reference

BUR407-F

   

Using a referent cell ($)
Basic
formulas Conditional formulas
Date and time
functions Other functions
Formula audits

Sorting, sorting options
Automatic filters

Custom filters

Select data
Choose a chart type according to needs
Insert a title, legend, data labels
3D charts
Modify values
Modify chart type

Structure of a PivotTable
The PivotTable and PivotChart wizard
Edit a PivotTable
Format a PivotTable

Convert and consolidate
Data validation
Scenario analysis

Adding and modifying comments
Protect your workbook and sheets
Using the Microsoft OneDrive service

Objectives of a macro
Displaying the Developer tab in the ribbon
Recording a macro
Running a macro
Running a macro via shortcuts (in ribbon, button, etc.)
Managing macros
Viewing the code of a macro

Objectives of the VBA language
Presentation of VBA
Some definitions
Use of VBA
Principle of operation of a macro

Modifying the code of a macro
Language syntax
Variables
Arrays
Constants
Operators

The Application object
The Workbook object
The Worksheet object

The Range object

Operating principles
Condition structures (If, Select Case)
Multiple conditions (And / Or)
Presentation of loops
Looping according to a counter (For Next)
Looping according to a condition (Do Loop)

Synthesis
Questions / Answers

Review of the important elements Revisions before certification
Passing of the TOSA certification on Excel

Sessions

Contact us for more informations about session date

Excel : Fundamentals + Advanced functions

Goals


- Discover the new features of Office

- Know the main features of Excel

- Be able to perform calculations and use functions

- Know how to handle graphics and pivot tables

Program

Presentation of Excel
Description of the ribbon
Workbooks and worksheets
Rename, insert, move, delete a worksheet
Move around in the workbook (using the keyboard, menus, mouse)

The different ways of selecting cells
Modifying the height and width of rows / columns
Inserting rows and columns
Formatting the content of the cell (font, colors, etc.)
Borders
Alignment in the cell
Merge cells
Apply a format cell

Creating tables
Automatic formatting
Creating a custom style

The formula bar
Addition, subtraction, multiplication, division
Use of parentheses
Percentage format
Copy calculations

Layout Page
breaks
The printing area
Printing and printing options

The different display modes
Show / hide information
Zoom
Freeze the panes

Duration

3 days

Price

£ 1125

Audience

Everyone

Prerequisites

Knowledge of the PC environment

Reference

BUR502-F

  

Using a referent cell ($)
Basic
formulas Conditional formulas
Date and time
functions Other functions
Formula audits

Sorting, sorting options
Automatic filters

Custom filters

Select data
Choose a chart type according to needs
Insert a title, legend, data labels
3D charts
Modify values
Modify chart type

Structure of a PivotTable
The PivotTable and PivotChart wizard
Edit a PivotTable
Format a PivotTable

Convert and consolidate
Data validation
Scenario analysis

Adding and modifying comments
Protect your workbook and sheets
Using the Microsoft OneDrive service

Objectives of a macro
Displaying the Developer tab in the ribbon
Recording a macro
Running a macro
Running a macro via shortcuts (in ribbon, button, etc.)
Managing macros
Viewing the code of a macro

Sessions

Contact us for more informations about session date

Excel : Fundamentals

Goals


- Know the main features of Excel

- Be able to perform calculations

Program

Presentation of Excel
Description of the ribbon
Workbooks and worksheets
Rename, insert, move, delete a worksheet
Move around in the workbook (using the keyboard, menus, mouse)

The different ways of selecting cells
Modifying the height and width of rows / columns
Inserting rows and columns
Formatting the content of the cell (font, colors, etc.)
Borders
Alignment in the cell
Merge cells
Apply a format cell

Creating tables
Automatic formatting
Creating a custom style

The formula bar
Addition, subtraction, multiplication, division
Use of parentheses
Percentage format
Copy calculations

Layout Page
breaks
The printing area
Printing and printing options

The different display modes
Show / hide information
Zoom
Freeze the panes

Duration

1 day

Price

£ 375

Audience

Everyone

Prerequisites

Knowledge of the PC environment

Reference

BUR408-F

   

Sessions

Contact us for more informations about session date

Lime Survey Initiation

Goals


- Learn how to create and administer surveys with Lime Survey

Program

What is LimeSurvey
Features
Upgrades
Use of help and related sites
Installation and connection to Limesurvey

Users
General settings
Database backup
Label
management Twig model management
Centralized contact database
Filtered list of surveys (started, deactivated, expired)
Import Export of a survey

The types of poll
Create a poll (the structure)
The different types of questions
Manage invitations
Create questions and groups
Multilingual questionnaire
Quotas
Assessments

On the groups
On the questions
Test the logic of the questionnaire

Validation equations
Min and max responses, table filters

Syntax of the expression handler
Why use the expression handler
Or use the expression handler

How the editor works
Print the paper version

Available resources (images / files / flash)
Export / import of resource zip files
Download of these resource files

Theme options Theme
editor
Personalization examples

Test the survey
Launch the survey
Send invitations
Send the link (without table)
Set up the captcha
Data entry screen
Email templates
Send reminders
Deactivate a survey

Answers and statistics
Simple and expert mode
Partial answers
Connection to Excel

Duration

2 days

Price

£ 2495

Audience

Everyone

Prerequisites

No prequesites

Reference

BUR100122-F

  

Sessions

Contact us for more informations about session date

Android: Using Android mobiles or tablets

Goals


- Master the use of an Android smartphone / tablet

Program

Switching on, charging, switching
on Phone desktop structure
Open, quit an application
Delete an application
Organization of applications: grouping in a folder
Managing blockages of an application

Workshop: Organization of mobile applications – visualization of multi-tasking applications

Locking the device with a password
Setting the date / time
Changing the screen brightness
Keyboards management; suggestions
Mobile network management: manual or automatic
Connection to a wireless network
Device reset
Notifications (alerts)

Workshop: Setting up the mobile and managing notifications

Consult the directory
Add contacts, associate photos
Synchronize contacts with Google Contacts or other

Workshop: Definition of contacts and synchronization

Consulting the calendar
Adding an appointment to its calendar
Managing alerts

Workshop: Consulting the agenda and adding appointments

Configuration of an email account (Hotmail, Gmail, Yahoo, etc …)
Setting of the number of messages displayed
Changing the signature of the email
Folders, Reading messages, opening attachments
Writing, replying or forwarding a message
Organization of messages: folders, deletion, …

Workshop: Setting up and using an email account

Writing and organizing notes
Sending by email

Workshop: Writing and sending notes

Consulting websites, multi-tabs
Performing a search
Adding bookmarks to favorites, viewing
Browsing history management

Workshop: Internet browsing and management of favorites

Find, install a third-party application
Settings, uninstall
Social network applications: Twitter, Facebook, …

Workshop: Installation of third-party applications

Take a photo or video
Settings: resolution, zoom, effects
Send as an attachment by message or email, compression

Workshop: Taking photos, videos and sending

Application permissions
Back up content

Workshop: Security management and data synchronization

Duration

1 day

Price

£ 2495

Audience

Everyone

Prerequisites

Office automation concepts

Reference

BUR886-F

  

Sessions

Contact us for more informations about session date

Windows 8 Initiation

Goals


- Master the new features of Windows 8

- Handle the environment

Program

What is an environment? 

Windows 8 history and versions
What’s new ?

Discover the Metro interface
Unification of PC, mobile and tablet
interfaces Dual interface
Use of the touch interface

Windows Store: operation, use of an application
Talismans: Research and sharing 
Communication between applications

Workshop: Install and use a Windows Store app

Importance of the Live account on Windows 8
Universal access to data, the Cloud
SkypDrive
Synchronization with PC Sync settings

Workshop: Configuring the Live account on Windows 8

Migration to Windows 8
Management of USB 3.0 devices
Visual passwords (Login-Picture) / Passwords to Code (Login-PIN)
Task management
Using ISO images

Workshop: Configuration of a visual password / Code

Passing the certification (if requested by the trainee)

Duration

2 days

Price

£ 745

Audience

Everyone

Prerequisites

Office automation skills: Windows XP / Vista / 7

Reference

BUR630-F

  

Sessions

Contact us for more informations about session date

Office Automation Initiation : Excel + Word + Powerpoint

Goals


- Navigate in the explorer

- Discover the Internet and emails

- Know the basics of Office tools (Word, Excel, PowerPoint)

Program

Presentation of Excel and the other tools of the Office suite
Examples of realization with Excel

Description of the interface (Ribbon, Quick Access Toolbar, etc.)
Structure of a file (workbooks, sheets and cells)
Create a workbook

Adding a sheet to the workbook
Rename a sheet
Move a sheet (on the same workbook or in another)
Identify a sheet using a tab color

The different ways to select cells
Insert rows and columns
Change the height and width of rows / columns

Format the content of a cell (font, colors …)
Apply borders
Manage alignment in a cell
Merge several cells
Apply a cell format

Workshop: Making a simple painting

Creating tables
Automatic formatting
Creating a custom style

Workshop: Creation of a personalized style and application on a board

Insert pictures (local or online)
Add and edit shapes
Insert organization chart

Define the application area
Use the predefined rules
Modify an existing rule
Create a new rule
Apply to an entire table

The formula bar
Addition, subtraction, multiplication, division
The value of parentheses
Applying a calculation to an entire column

Apply a sort on one or more columns
Modify sorting options
Apply filters on a table
Use advanced filters

Manage the page layout (margins, header and footer, etc.)
Scale your table
Manually manage page breaks
Define a print area
Define print options then print

Available display modes
Show / hide cells
Zoom
Freeze panes

Duration

5 days

Price

£ 1875

Audience

Everyone

Prerequisites

Knowledge of the PC environment

Reference

BUR100383-F

  

Presentation of Word and the other tools of the Office suite
Examples of realization with Word

Description of the interface (Ribbon, Quick Access Toolbar, etc.)
Structure of a file (pages, sections, paragraphs …)
Display the ruler, paragraph marks and gridlines

Create a document
Open, save and close
Use recent documents
Create a document based on a template
Save a document in Word 97-2003 format

Enter text
Move around the document
Select text to edit
Move and duplicate text
Change text formatting
Manage paragraph alignment
Use automatic spell checking

Search for a character string
Launch an in-depth search
Replace one string with another
Replace formatting

Define a hierarchy at the style level
Apply a predefined style to a text
Create a new text style

Workshop: Apply a style to all of its text content

Choose the theme of your document
Apply a variant of the active theme
Customize the colors, fonts and effects of a theme

Apply a watermark
Set a page color
Apply a border to the page

Define the type of document (classic, book, booklet)
Choose and customize the margins
Specify the size of the sheets and the orientation
Include predefined headers and footers
Insert the company logo
Add page numbering
Modify the format page numbers
Customize headers and footers
Insert page breaks
Split your document into several sections

Define the pages to print
Configure the printer options
Print your document

Presentation of PowerPoint and the other tools of the Office suite
Examples of realization with PowerPoint

Description of the interface (Ribbon, Quick Access Toolbar, etc.)
Structure of a file (slideshows, sections, slides)
Create a new slide show
Using slide show templates

Add / remove slides Slide
layouts
Group your slides into sections
Move a slide

Placeholders
Insert and format text
Insert and customize shapes
Insert and customize images
Create a photo album
Use WordArt
Organize inserted content

Use slide themes
Add a background
Create your own theme

Animating content
Personalizing your animation
Timing of animations (start, duration, delay)
Transitions between slides
Timing of transitions

Launching the slideshow mode
Creating a personalized slideshow
Configure the slideshow
The other display modes
Inserting a header and footer
Adding comments

Email
Overview Outlook

Software interface Basic
functions
Presentation of the mailbox
Presentation of the Address book
Presentation of the Agenda

Send an email
Read your emails
Reply or forward a message
Inserting attachments
Text format
Signing emails View
panel and virus rules
Create folders

Create a list of contacts
Add contacts to a list
Insert contacts in an e-mail Group
management
The diary
Presentation of the calendar
Display mode
Creation of tasks
Alerts

Keyboard shortcuts
Rules
Creating acknowledgment filters

Revisions
Questions / Answers
Passing the PCIE certification

Passing the certification (if provided for in the funding)

Sessions

Contact us for more informations about session date

Office Automation Initiation : Powerpoint

Goals


- Create simple presentations

- Integrate transitions and animations

Program

Presentation of PowerPoint and the other tools of the Office suite
Examples of realization with PowerPoint

Description of the interface (Ribbon, Quick Access Toolbar, etc.)
Structure of a file (slideshows, sections, slides)
Create a new slide show
Using slide show templates

Add / remove slides Slide
layouts
Group your slides into sections
Move a slide

Placeholders
Insert and format text
Insert and customize shapes
Insert and customize images
Create a photo album
Use WordArt
Organize inserted content

Use slide themes
Add a background
Create your own theme

Animating content
Personalizing your animation
Timing of animations (start, duration, delay)
Transitions between slides
Timing of transitions

Launching the slideshow mode
Creating a personalized slideshow
Configure the slideshow
The other display modes
Inserting a header and footer
Adding comments

Passing the certification (if provided for in the funding)

Duration

1 day

Price

£ 375

Audience

Everyone

Prerequisites

Knowledge of the PC environment

Reference

BUR100428-F

 

Sessions

Contact us for more informations about session date

Office Automation Initiation : Word

Goals


- Be able to write a simple letter

- Know how to manage the layout of a document

Program

Presentation of Word and the other tools of the Office suite
Examples of realization with Word

Description of the interface (Ribbon, Quick Access Toolbar, etc.)
Structure of a file (pages, sections, paragraphs …)
Display the ruler, paragraph marks and gridlines

Create a document
Open, save and close
Use recent documents
Create a document based on a template
Save a document in Word 97-2003 format

Enter text
Move around the document
Select text to edit
Move and duplicate text
Change text formatting
Manage paragraph alignment
Use automatic spell checking

Search for a character string
Launch an in-depth search
Replace one string with another
Replace formatting

Define a hierarchy at the style level
Apply a predefined style to a text
Create a new text style

Workshop: Apply a style to all of its text content

Choose the theme of your document
Apply a variant of the active theme
Customize the colors, fonts and effects of a theme

Apply a watermark
Set a page color
Apply a border to the page

Define the type of document (classic, book, booklet)
Choose and customize the margins
Specify the size of the sheets and the orientation
Include predefined headers and footers
Insert the company logo
Add page numbering
Modify the format page numbers
Customize headers and footers
Insert page breaks
Split your document into several sections

Define the pages to print
Configure the printer options
Print your document

Passing the certification (if provided for in the funding)

Duration

2 days

Price

£ 750

Audience

Everyone

Prerequisites

Knowledge of the PC environment

Reference

BUR100427-F

 

Sessions

Contact us for more informations about session date

Office Automation Initiation : Excel

Goals


- Know how to create a table in Excel

- Be able to configure the printing of your table

Program

Presentation of Excel and the other tools of the Office suite
Examples of realization with Excel

Description of the interface (Ribbon, Quick Access Toolbar, etc.)
Structure of a file (workbooks, sheets and cells)
Create a workbook

Adding a sheet to the workbook
Rename a sheet
Move a sheet (on the same workbook or in another)
Identify a sheet using a tab color

The different ways to select cells
Insert rows and columns
Change the height and width of rows / columns

Format the content of a cell (font, colors …)
Apply borders
Manage alignment in a cell
Merge several cells
Apply a cell format

Workshop: Making a simple painting

Creating tables
Automatic formatting
Creating a custom style

Workshop: Creation of a personalized style and application on a board

Insert pictures (local or online)
Add and edit shapes
Insert organization chart

Define the application area
Use the predefined rules
Modify an existing rule
Create a new rule
Apply to an entire table

The formula bar
Addition, subtraction, multiplication, division
The value of parentheses
Applying a calculation to an entire column

Apply a sort on one or more columns
Modify sorting options
Apply filters on a table
Use advanced filters

Manage the page layout (margins, header and footer, etc.)
Scale your table
Manually manage page breaks
Define a print area
Define print options then print

Available display modes
Show / hide cells
Zoom
Freeze panes

Passing the certification (if provided for in the funding)

Duration

2 days

Price

£ 750

Audience

Everyone

Prerequisites

Knowledge of the PC environment

Reference

BUR100425-F

 

Sessions

Contact us for more informations about session date

Google Apps: Fundamentals (Gmail, Calendar, Documents, …)

Goals


- Learn to use Google apps

Program

Overview of Google applications: architecture, services
Benefits of Google Apps
Data security and confidentiality
Google accounts and single sign-on

Creating an account
Organizing folders
Managing conversations
Managing attachments: viewing, printing
Tags, filters and searches
Hangout instant messaging: voice / video, phone, conference
Archiving

Workshop: Using a Google email account and advanced settings

Presentation of Google Contact Contact
management: creation, modification, deletion Group
management
Contact sharing
Restoring deleted contacts
Merge duplicates

Workshop: Organization of contacts

Google Calendar: interface presentation, features
Recording an appointment
Availability search
Event management: creation, searches
Definition of reminders
Calendar management: creation, shared resources, publication
Data export
Access management

Workshop: organization of a person / professional agenda

Google Documents: presentation, functionalities
Creation of documents
Import, export
Management of models
Creation of forms
Sharing of documents and collections
Collaborative work
Version management
Publishing
Storage capacities

Workshop: Document management – Creation of forms and collection of results

Google Apps Marketplace: available applications, operation
Activation of applications
Access to Google Apps from a mobile

Duration

2 days

Price

£ 2495

Audience

Everyone

Prerequisites

Office automation concepts

Reference

BUR697-F

  

Sessions

Contact us for more informations about session date

Computer Initiation

Crystal Reports : Initiation + Advanced

Goals


- Improve performance on Crystal Reports All versions

- Create reports

- Advanced functions

Program

Database concepts
Prototype development
Concept of Workbench

Creation of reports with the wizard or not
Connection to the data source
Selection of tables
Presentation of the development interface
Vocabulary
Using the wizard for creating reports
Creating reports without the wizard
Formatting fields
Report property
Recording

Practical workshop: Creating a report without the wizard

Using the selection
wizard Outer joins

Workshop: Record selection

Sorting records
Grouping data
Calculations
Summary

Practical workshop: Sorting and grouping

Adding graphic elements (lines, frames, images)
Using and formatting special fields

Practical workshop: Formatting the report

Creating and formatting sections

Practical workshop: Formatting sections

Definition and creation of formulas
Boolean type
formulas If Then Else type formulas
Calculations on dates and numbers
Handling character strings

Practical workshop: Simple formulas

Trends
Conditional formatting of data 

Workshop: Conditional formatting

Using the chart wizard
Creating the chart located in a Group or in the Report Header
Discovering the different tabs
Selecting the chart type
Example of chart by group
Displaying Legends and Data Labels
Formatting axis labels
Graph options
Formatting of the legend

Practical workshop: The Graphs

Export in other formats (pdf, html, xls …)
Export of the document on a Crystal server

Practical workshop: Distribution of reports

Duration

4 days

Price

£ 1878

Audience

Consultants, developers, business intelligence project managers

Prerequisites

SQL language

Reference

BUS100047-F

Using the Repository Explorer
Saving Files to the Repository
Adding Objects or Images to the Repository
Editing Repository Objects
SQL Commands

Using functions and operators
Using Crystal language and syntax (presentation)
Functions: Strings
Nested
functions Mathematical and Boolean
functions Miscellaneous functions

Practical workshop: Miscellaneous and nested functions

Using the Project Manager: The Workbench
Using Variables and Tables

Variables
Differences between Visual Basic and Crystal Report
syntax SWITCH function (Visual or Crystal syntax)

Practical workshop: Declaration and use of variables

Model expert
Building a model without a data source

Practical workshop: Using models

Add Parameter Fields
Conditional Formatting of Fields

Lab: Creating a Simple Parameter

Creating a crosstab
Modify the options of the
crosstab wizard Customizing a crosstab without an assistant
Using calculated fields in a TC (New)

Practical workshop: Cross tables

Section management

Multi-column management

Cumulative total fields

Practical workshop: Cumulative total

Export in other formats (pdf, html, xls …)
Export of the document on a Crystal server

Practical workshop: Distribution of reports

Practical workshop: Alert report 

Practical workshop: Report N Best

Practical workshop: Conditional management of dynamic images 

Practical workshop: Inserting Xcelsius elements

Sessions

Contact us for more informations about session date

Visio initiation

Goals


- Know the current use of Visio 2013

- Know how to choose and create any diagrams in relation to his activity

Program

Introduction

Presentation: history, versions
Available diagrams and areas of use
Alternatives
The diagram in the project: proposal, organization

Essential manipulations

Discovery of the interface
Indispensable basic concepts
Positioning of shapes and text
Organization of files
Printing and export formats
Relations between Visio and other software: import, export, …
Various options

Workshop: a first diagram, from paper to printer

The main diagrams

Basic and free
diagrams Block diagrams and 3D blocks

Workshop: making a diagram for brainstorming

Diagrams for the project

Time diagrams: chronology, calendar, Gantt, Pert
Organization diagrams: flows and workflows
Other diagrams available for projects
Summary of diagrams for projects

Workshop: coherent set of diagrams between several actors

Specialized diagrams

Diagrams for the software: networks, website, various UML
Plans: situation, site, office
Technical plans for the building: overview
Panorama of other diagrams

Workshop: realization of various diagrams

Duration

2 days

Price

£ 845

Audience

Everyone

Prerequisites

No prerequisites

Reference

GES330-F

 

Sessions

Contact us for more informations about session date

Crystal Reports : Initiation

Goals


- Discover Crystal Reports All versions

- Create reports

- Create formulas and charts

Program

Database concepts
Prototype development
Concept of Workbench

Creation of reports with the wizard or not
Connection to the data source
Selection of tables
Presentation of the development interface
Vocabulary
Using the wizard for creating reports
Creating reports without the wizard
Formatting fields
Report property
Recording

Practical workshop: Creating a report without the wizard

Using the selection
wizard Outer joins

Workshop: Record selection

Sorting records
Grouping data
Calculations
Summary

Practical workshop: Sorting and grouping

Adding graphic elements (lines, frames, images)
Using and formatting special fields

Practical workshop: Formatting the report

Creating and formatting sections

Practical workshop: Formatting sections

Definition and creation of formulas
Boolean type
formulas If Then Else type formulas
Calculations on dates and numbers
Handling character strings

Practical workshop: Simple formulas

Trends
Conditional formatting of data 

Workshop: Conditional formatting

Using the chart wizard
Creating the chart located in a Group or in the Report Header
Discovering the different tabs
Selecting the chart type
Example of chart by group
Displaying Legends and Data Labels
Formatting axis labels
Graph options
Formatting of the legend

Practical workshop: The Graphs

Export in other formats (pdf, html, xls …)
Export of the document on a Crystal server

Practical workshop: Distribution of reports

Duration

2 days

Price

£ 943

Audience

Consultants, developers, business intelligence project managers

Prerequisites

SQL language

Business function

Reference

BUS100045-F

Sessions

Contact us for more informations about session date

Business Objects BI 4.2 : Webi Initiation + Advanced

Goals


- Create simple WebI documents using BI Launch Pad

- Implement the query editor to feed its documents with the relevant data of your choice

- Enhance and format your business data with graphs

- Go further with functions

- Merge dimensions

- Create complex queries

Program

What is business intelligence?
What is Business Objects  ?
Other Business Objects software
The question: who does what?
The specificity of Business Objects  : the
Vocabulary semantic layer

View documents
Manage documents (rename, delete, file)
Schedule execution and delivery of documents
Change portal preferences
Create my InfoView (my home page)
Improved search

Know the elements available in a universe
Presentation of the query editor
Presentation of the data formatting interface
Modify an existing document / add data and display them
Managing the reports of a document
Create simple vertical, horizontal tables
Create forms
Create cross tables
Create charts

Create your query filters (express or advanced)
Use the different operators (« Equal to », « In list », « Corresponds to the model » …)
Query filter with prompt (dynamic choice of the values ​​of the criterion)
Query with prompt: purge data and automatic refresh, configuration of the operation of the prompt
Combine query filters: AND operator, OR operator, combine AND and OR operators
Concept of contexts
Properties of a query

Create sections
Create table breaks, table
formatting Cell
formatting Report formatting
Create fixed filters
Create dynamic filters by input controls
Create ranking
Apply conditional formatting

Create a query filter
Use the « Equal to »
operator Use the « In list »
operator Use the « Match the model
 » operator Use the « between » operator
Create a query filter with a prompt
Apply multiple query filters
Connect filters by « and »
Connect filters by « or »
Manage the priorities between the filters
Concept of context

Create variables
Create a simple calculation
Transform calculations into a variable

Duration

4 days

Price

£ 1887

Audience

Users, Business Intelligence Project Manager

Prerequisites

Spreadsheet knowledge

Reference

BUS989-F

Create simple graphs – practice
Turn a table into a graph – practice
Properties of graphs – practice
Stock market chart – practice
Bubble chart – practice
Keyword cloud chart – practice

Formatting cells (reminder)
Pre-programmed cells – Practice
Complete the data with your calculations, create variables
Create a simple calculation and transform it into a variable – practice
Use the functions
The functions and the writing rules
Functions – practice

Reminder on query filters
Combining query filters
Managing priorities between query filters
Using complex operators
Going beyond the limits of complex operators
Combining queries (Minus)
Combining queries (Intersection)
Combining queries (Union)
Usefulness of sub- queries
Create a subquery (InList, ALL)

Add a new request to a document
Automatic
synchronization Manual synchronization
Multi requests in a document: automatic synchronization or not
Delete synchronization
Practice: multi request document and synchronization

Limit of automatic calculations
Benefit of extended automatic syntax in formulas
Use the « where » operator to specify a context
Use the « in » operator to specify a context
Interpretation of the « #VALEURMULTI » error
Calculation context and context d ‘display
Use the « ForAll »
operator Use the « ForEach » operator

Passing the certification (if provided for in the funding)

Sessions

Contact us for more informations about session date

Business Objects BI 4.2 : Webi Initiation

Goals


- Create simple WebI documents using BI Launch Pad

- Implement the query editor to feed its documents with the relevant data of your choice

- Enhance and format your business data with graphs

Program

What is business intelligence?
What is Business Objects  ?
Other Business Objects software
The question: who does what?
The specificity of Business Objects  : the
Vocabulary semantic layer

View documents
Manage documents (rename, delete, file)
Schedule execution and delivery of documents
Change portal preferences
Create my InfoView (my home page)
Improved search

Know the elements available in a universe
Presentation of the query editor
Presentation of the data formatting interface
Modify an existing document / add data and display them
Managing the reports of a document
Create simple vertical, horizontal tables
Create forms
Create cross tables
Create charts

Create your query filters (express or advanced)
Use the different operators (« Equal to », « In list », « Corresponds to the model » …)
Query filter with prompt (dynamic choice of the values ​​of the criterion)
Query with prompt: purge data and automatic refresh, configuration of the operation of the prompt
Combine query filters: AND operator, OR operator, combine AND and OR operators
Concept of contexts
Properties of a query

Create sections
Create table breaks, table
formatting Cell
formatting Report formatting
Create fixed filters
Create dynamic filters by input controls
Create ranking
Apply conditional formatting

Create a query filter
Use the « Equal to »
operator Use the « In list »
operator Use the « Match the model
 » operator Use the « between » operator
Create a query filter with a prompt
Apply multiple query filters
Connect filters by « and »
Connect filters by « or »
Manage the priorities between the filters
Concept of context

Create variables
Create a simple calculation
Transform calculations into a variable

Passing the certification (if provided for in the funding)

Duration

2 days

Price

£ 943

Audience

Users, Business Intelligence Project Manager

Prerequisites

Spreadsheet knowledge

Reference

BUS990-F

Sessions

Contact us for more informations about session date

MS Project Initiation

Goals


- Know the main features of MS Project

- Know how to create and follow a project with MS Project

Program

Master the fundamentals of project management

Fundamentals of project management
Planning a project Scheduling
methods (PERT, Gantt and Potential-tasks)
Inter-task link: FD, DD, FF, DF
Earliest / latest dates and calculation of margins (free , totals)
Critical path
Project splitting into batches (WBS)
Presentation of MS Project

Workshop: Construction of a retro-planning and calculation of free and total margins – visualization of the critical path.

Discover MS Project and launch a project

Ms Project’s planning engine, operation and calculation rules
The working environment: panels and tools
The different views
Creation of a first project: simple, from a model, from an Excel table
Project properties
Definition of a calendar global for the project, working time and holidays.
Project and sub-projects


Workshop: Creation of a project – settings and calendar – different views of Ms Project.

Build the schedule

Task planning mode (automatic, manual planning)
Duration management: units, elapsed duration
Simple tasks
Links between tasks: early or late
Constraints on tasks: flexible, inflexible, semi-flexible
Grouping of tasks with a summary task
Definition of milestones
Periodic tasks, configuration
Definition of a due date
Splitting a task over a range
Moving a task
Viewing the margins and the critical path
Deactivating a task to view the impact on the schedule
Saving and comparing several schedules
Using the timeline bar

Workshop: Planning of a complete project.

Assign resources

Define the resources, types of resources available, specific calendar
Assign resources to tasks
Definition of several profiles for the same resource
Forecasts driven by the effort
Parameterization of the type of task and impact of the management by the effort
Delay in the start of allocation of a resource
Visualization of resource overloads
Audit of overuse
Team planner
Sharing of resources by several projects
Formatting and printing of a plan
Cost management for a resource
Overtime accounting
Visualization of costs, overruns budgets

Workshop: Definition and multiple resource allocation scenarios – effort management

Follow the progress of a project

Definition of initial planning and status date
Monitoring of progress, entry of actual data
Percentage of completion
Replanning during the project
Project control

Workshop: Planning of a complete project and allocation of resources.

Generate and print reports

Resource and cost control, EVM indicators
Generation and formatting of reports
Printing of diagrams
Import / export


Workshop: Printing reports, Excel exports

Passing the certification (if requested by the trainee)

Passing of the certification (if foreseen in the financing).

Duration

2 days

Price

£ 1085

Audience

Everyone

Prerequisites

Knowledge of project management

Reference

GES176-F

 

Sessions

Contact us for more informations about session date

Business Objects XI R3 : Webi Initiation + Advanced

Goals


- Discover Webintelligence XI

- Use data

- Generate graphs

- Create reports

- Go further with functions

- Merge dimensions

- Create complex queries

Program

What is business intelligence?
What is Business Objects  ?
Other Business Objects software
The question: who does what?
The specificity of Business Objects  : the
Vocabulary semantic layer

Connect to Infoview
Navigation
The homepage
Set InfoView and WebIntelligence
View / edit a document WebIntelligence
Save a public document in my files
Export a document to Excel or PDF
Configure  » My Infoview « 
Use with the Infoview

Create a new WebI document
Know the elements available in a universe
The java query editor
Description of the training universe
Create a query and run it
To the report! Manipulate data
Duplicate a report (manage document reports)
Transform a vertical table into a crosstab
Transform a vertical table into a graphic
Print a document
Save a document
Create a personal folder
Organize your documents

Handling blocks
The report editor
Create several blocks
Insert an object in an existing table
Modify the structure of a crosstab
Display the structure
Delete a column
Delete a table

Create a chart
Turn a table into a chart
Change the structure of a chart
Format a chart
Change properties

Create a query filter
Use the « Equal to »
operator Use the « In list »
operator Use the « Match the model
 » operator Use the « between » operator
Create a query filter with a prompt
Apply multiple query filters
Connect filters by « and »
Connect filters by « or »
Manage the priorities between the filters
Concept of context

The challenges of the multi-query
Create a new document
Add a second query
Introduction to the insertion
mode Choose the insertion mode of the new block
Name the queries and rerun them
Manage the queries
Presentation of merging dimensions

Create a new document with several blocks
Insert a break
Insert a simple calculation
Insert a sort
Insert a custom sort
Insert / Remove an express filter
Apply a global filter
Manage the report filters
Insert a section
Perform a calculation in a section
Insert a new block in a section
Modify the master
Insert alerters
Manage alerters
Insert a classification

Format tables
Modify the « general » and « display » properties of a table
Modify the « appearance » properties of a table
Modify the « page » and « position » properties of a table
Modify the « break » and « sorts » of a table
Format cells
Modify the « general » and « display » properties of a cell
Modify the « appearance » properties of a cell
Modify the number format of a cell
Modify the « break » properties « of a cell
Modify the » page « propertiesof a cell
Format sections
Modify the properties of a section

Insert a column in a table to place a calculation
Presentation of the formula editor
Create a formula
Transform a formula into a variable
Use functions (examples)
Manage variables

Define the scope of analysis
Explore in a table
Explore in a chart
Freeze an exploration level
Modify the scope of analysis
Insert exploration filters

Duration

4 days

Price

£ 1887

Audience

Users, Business Intelligence Project Manager

Prerequisites

Spreadsheet knowledge

Reference

BUS879-F

Reminders on formulas and variables
Create a formula
Transform a formula into a variable
Manage variables
User response function on a multi-query document
Replace function
Use of logical test Si
function
Use the if function to create groupings
Cumulative sum
function Date functions

Reminder on multi-query documents
Automatic synchronization
Display in a table of data coming from separate sources
Usefulness of synchronization
Case of objects that cannot be merged, problem solving

Reminder on query filters
Combine query filters
Manage priorities between query filters
Use complex operators (« at a time »)
Use complex operators (« except »)
Go beyond the limits of complex operators
Combine queries (« minus « )
Combine queries ( » intersection « )
Combine queries ( » union « )
Usefulness of subqueries
Create an » all « subquery
Create an » any « subquery

Limit of automatic calculations
Benefit of extended automatic syntax in formulas
Use the « where » operator to specify a context
Use the « in » operator to specify a context
Interpretation of the « #MULTIVALUE » error
Use the « ForAll operator « 
Use the » ForEach « operator

Sessions

Contact us for more informations about session date

Business Objects XI R3 : Webi Initiation

Goals


- Discover Webintelligence XI

- Use data

- Generate graphs

- Create reports

Program

What is business intelligence?
What is Business Objects  ?
Other Business Objects software
The question: who does what?
The specificity of Business Objects  : the
Vocabulary semantic layer

Connect to Infoview
Navigation
The homepage
Set InfoView and WebIntelligence
View / edit a document WebIntelligence
Save a public document in my files
Export a document to Excel or PDF
Configure  » My Infoview « 
Use with the Infoview

Create a new WebI document
Know the elements available in a universe
The java query editor
Description of the training universe
Create a query and run it
To the report! Manipulate data
Duplicate a report (manage document reports)
Transform a vertical table into a crosstab
Transform a vertical table into a graphic
Print a document
Save a document
Create a personal folder
Organize your documents

Handling blocks
The report editor
Create several blocks
Insert an object in an existing table
Modify the structure of a crosstab
Display the structure
Delete a column
Delete a table

Create a chart
Turn a table into a chart
Change the structure of a chart
Format a chart
Change properties

Create a query filter
Use the « Equal to »
operator Use the « In list »
operator Use the « Match the model
 » operator Use the « between » operator
Create a query filter with a prompt
Apply multiple query filters
Connect filters by « and »
Connect filters by « or »
Manage the priorities between the filters
Concept of context

The challenges of the multi-query
Create a new document
Add a second query
Introduction to the insertion
mode Choose the insertion mode of the new block
Name the queries and rerun them
Manage the queries
Presentation of merging dimensions

Create a new document with several blocks
Insert a break
Insert a simple calculation
Insert a sort
Insert a custom sort
Insert / Remove an express filter
Apply a global filter
Manage the report filters
Insert a section
Perform a calculation in a section
Insert a new block in a section
Modify the master
Insert alerters
Manage alerters
Insert a classification

Format tables
Modify the « general » and « display » properties of a table
Modify the « appearance » properties of a table
Modify the « page » and « position » properties of a table
Modify the « break » and « sorts » of a table
Format cells
Modify the « general » and « display » properties of a cell
Modify the « appearance » properties of a cell
Modify the number format of a cell
Modify the « break » properties « of a cell
Modify the » page « propertiesof a cell
Format sections
Modify the properties of a section

Insert a column in a table to place a calculation
Presentation of the formula editor
Create a formula
Transform a formula into a variable
Use functions (examples)
Manage variables

Define the scope of analysis
Explore in a table
Explore in a chart
Freeze an exploration level
Modify the scope of analysis
Insert exploration filters

Duration

2 days

Price

£ 943

Audience

Users, Business Intelligence Project Manager

Prerequisites

Spreadsheet knowledge

Reference

BUS880-F

Sessions

Contact us for more informations about session date

Django : Initiation

Goals


- Develop a robust web application with the Django framework

Program

Pattern MVC: structure, interest
Django framework: presentation, versions, documentation
Django vs other python web frameworks (pylons, turbogears, web2py)
Development environment
Django installation packages and dependencies
Web server configuration

Workshop: Installing Django (environment, dependencies)

Structure of a project
Controls / Essential components
Templating with Django: principle
Definition of modifiable regions
Inheritance of templates
Construction of views
Generic views

Workshop: Construction of a template and implementation of forms

Creation of forms and data retrieval
Validation of entries
Use of jQuery, yui
Data export (pdf, csv, …) Upload
management
Persistence contexts :
– use of the session
– global application variables
– use of cookies
– cache control
– browser-side persistence context exploitation: sessionStorage, localStorage
AJAX requests
URL routing

Workshop: Building a complete site with Django

Passing of the certification (if foreseen in the financing).

Duration

3 days

Price

£ 1922

Audience

Python Developers

Prerequisites

Mastery of object programming in Python

Reference

PYT606-F

Sessions

Contact us for more informations about session date

Django : Initiation + Advanced

Goals


- Develop a robust web application with the Django framework

Program

Pattern MVC: structure, interest
Django framework: presentation, versions, documentation
Django vs other python web frameworks (pylons, turbogears, web2py)
Development environment
Django installation packages and dependencies
Web server configuration

Workshop: Installing Django (environment, dependencies)

Structure of a project
Controls / Essential components
Templating with Django: principle
Definition of modifiable regions
Inheritance of templates
Construction of views
Generic views

Workshop: Construction of a template and implementation of forms

Creation of forms and data retrieval
Validation of entries
Use of jQuery, yui
Data export (pdf, csv, …) Upload
management
Persistence contexts :
– use of the session
– global application variables
– use of cookies
– cache control
– browser-side persistence context exploitation: sessionStorage, localStorage
AJAX requests
URL routing

Workshop: Building a complete site with Django

Access to data with Django
The ORM Django: configuration, features
Mapping of entities: management of keys, fields
Management of concurrency
Mapping of associations
Management of inheritance
Request the database  
Management of the cache
 
Workshop: implementation of a data access layer with Django

Site administration: objects, media, options
Customization of the interface
Sending emails
Authentication management
Internationalization (I18N)
Interconnection with social networks
Testing and deployment of the application

Workshop: I18N of the application and authentication management

Passing of the certification (if foreseen in the financing).

Duration

5 days

Price

£ 2564

Audience

Python Developers

Prerequisites

Mastery of object programming in Python

Reference

PYT100590-F

Sessions

Contact us for more informations about session date

Python Initiation

Goals


- Know the possibilities and limits of Python

- Master the essential syntax of Python

Program

History, alternatives
About Python 2 and Python 3
Presentation and installation of Python in a Windows or Linux environment
Implementation of Python: access to the terminal
Assisted development environments; association with known tools and practical editors

Workshop: Setting up a development environment

Basic syntax, in direct interpretation and in script
Declare variables in Python, internal types and their use
Use operators and expressions
Presentation and detail of control structures: tests, loops
Use loops and tests to perform algorithms
Use tables, various algorithms for processing big data
Types of data and advanced operations (sets, dictionaries, scheduling, etc.)
Exception management

Workshop: Multiple algorithms to master the basic syntax.

Interest of code structures in the project and for the group of projects
Create and organize functions
Return of functions, absence of return, multiple returns and interest in a complex algorithm
Namespaces, manipulation
Creation of function libraries, documentation
Operations strings number of characters
Calculate with Python
Manage dates, times, time intervals with Python
Various functions required

Workshop: Building a library of functions

Different programming styles, contributions of the object
Object and classes
Management of attributes and methods
Instantiation, destruction
Encapsulate data and use properties
Aggregation of objects
Single and multiple inheritance
Polymorphism
Introspection
Use of interfaces
UML modeling: class diagrams, d ‘objects

Workshop: UML design of an application and implementation of business classes

Passing of the certification (if foreseen in the financing).

Duration

3 days

Price

£ 1708

Audience

Developers

Prerequisites

No

Reference

PYT252-F

Sessions

Contact us for more informations about session date

Outlook Initiation

Goals


- Know how to use your email

- Get organized using contact lists, calendar, agenda …

Program

Email
Overview Outlook

Software interface Basic
functions
Presentation of the mailbox
Presentation of the Address book
Presentation of the Agenda

Send an email
Read your emails
Reply or forward a message
Inserting attachments
Text format
Signing emails View
panel and virus rules
Create folders

Create a list of contacts
Add contacts to a list
Insert contacts in an e-mail Group
management
The diary
Presentation of the calendar
Display mode
Creation of tasks
Alerts

Keyboard shortcuts
Rules
Creating
acknowledgment filters

Duration

1 day

Price

£ 2495

Audience

All

Prerequisites

No

Reference

BUR102-F

Sessions

Contact us for more informations about session date

Python Initiation + Advanced

Goals


- Know the possibilities and limits of Python

- Master the essential syntax of Python

- Be able to create and maintain complete and complex applications in Python

Program

History, alternatives
About Python 2 and Python 3
Presentation and installation of Python in a Windows or Linux environment
Implementation of Python: access to the terminal
Assisted development environments; association with known tools and practical editors

Workshop: Setting up a development environment

Basic syntax, in direct interpretation and in script
Declare variables in Python, internal types and their use
Use operators and expressions
Presentation and detail of control structures: tests, loops
Use loops and tests to perform algorithms
Use tables, various algorithms for processing big data
Types of data and advanced operations (sets, dictionaries, scheduling, etc.)
Exception management

Workshop: Multiple algorithms to master the basic syntax.

Interest of code structures in the project and for the group of projects
Create and organize functions
Return of functions, absence of return, multiple returns and interest in a complex algorithm
Namespaces, manipulation
Creation of function libraries, documentation
Operations strings number of characters
Calculate with Python
Manage dates, times, time intervals with Python
Various functions required

Workshop: Building a library of functions

Different programming styles, contributions of the object
Object and classes
Management of attributes and methods
Instantiation, destruction
Encapsulate data and use properties
Aggregation of objects
Single and multiple inheritance
Polymorphism
Introspection
Use of interfaces
UML modeling: class diagrams, d ‘objects

Workshop: UML design of an application and implementation of business classes

File handling
Parsing Xml, JSON
Log management with Python
Code documentation and HTML rendering generation
Use databases with Python, DBAPI

Workshop: Handling of files and operations linked to an SQLite database.

Graphics libraries in Python
Tkinter vs PyQT or other
graphics Widgets
Menus
Positioning of components
Window
management Event management

 Workshop: Implementation of a complete graphical interface of an application

Passing of the certification (if foreseen in the financing).

Duration

5 days

Price

£ 2564

Audience

All

Prerequisites

No

Reference

PYT211-F

Sessions

Contact us for more informations about session date

Fundamentals of VB.NET Development (Course 40361A, Exam 98-361)

Goals


- Knowing how to develop in VB.NET, create basic management interfaces and handle objects of the .NET platform, prepare for passing the MTA 98-361 certification

Program

Understanding of application lifecycle management
Presentation of .NET
The languages ​​of the .NET framework
Evolutions of VB / VB.Net, supported platforms
Development environment
Types of projects: console, library, WinForms, WPF, WCF, …
Minimum structure of a VB.Net program
Compiling, running and debugging

Workshop: Handling the development environment – examples of VB.Net programs

Variables: declaration, common types (Common Type System)
Organization in memory (primitive types / reference types)
Operators
Type conversion: implicit / explicit cast
Conditional
instructions Iteration instructions, loops

Workshop: Multiple examples of applications

Operating principle
Creation of arbitrary
arrays Multidimensional arrays and traversal

Workshop: Declaration and manipulation of tables

Introduction to procedural: definition, interest
Types and returns of functions
Passing parameters:
– by value (ByVal)
– by reference (ByRef)
– variable arguments (ParamArray)
Overloads of methods (Overloads)
Optional parameters (Optional)
Recursion: definition, implementation

Workshop: Breakdown of the application

Exception mechanism, types
Catch and handle an exception (try / catch / finally)
Throwing exceptions (throw)

Workshop: Management of data entry errors, escalation of exceptions

Notions on classes
Character strings, dates, …
Various lists and collections, algorithms
Access to files and streams

Workshop: Manipulation of collections and flows

WinForms: presentation, components and displays
Structure of a project, references
Creation of windows
Use of controls and management of events
Organization of the application

Workshop: a directory application

Presentation of the object for the ideal structuring of the code and notions of UML
Attributes and methods
Constructors, life cycle, general memory management
The aggregation of objects
Creation of properties, visibility, encapsulation
Inheritance in the application

Workshop: Implementation of several business classes

Use of namespaces and creation
Abstract classes and interfaces
Polymorphism: interest, use
Event mechanisms
Examples of modeling for complex applications

Workshop: Organization of an application based on complex objects – advanced use of graphic controls

ADO.NET: access to any database
Communication with .NET: the web and other protocols
Presentation of additional useful elements available and C # evolutions
Creation and use of
Multithreading and synchronization processes

Workshop: Complete Case Study – A Business Agenda in C #

Web page development: HTML, CSS, JavaScript
ASP.NET web applications: application structure, page lifecycle
Web
hosting : operation Understanding web services: access from a client application, SOAP and WSDL

Details of the content of the certification
Taking and correcting a mock test
Corrected workshops
Questions / answers, time management when taking the exam

Duration

5 days

Price

£ 2119

Audience

Developers

Prerequisites

Common use of a programming language

Reference

.NE100019-F

Sessions

Contact us for more informations about session date

Fundamentals of C # Development (Course 40361A, Exam 98-361)

Goals


- Know how to develop in C #, create basic management interfaces and handle objects of the .NET platform, prepare to pass the MTA 98-361 certification

Program

Understanding of application lifecycle management
Presentation of .NET
Languages ​​of the .NET framework
Particularities of C # C #
evolutions, supported platforms
Development environment
Types of projects: console, library, WinForms, WPF, WCF, …
Structure minimum of a C # program
Compile, run, and debug

Workshop: Manipulating the development environment – examples of C # programs

Variables: declaration, common types (Common Type System)
Organization in memory (primitive types / reference types)
Operators
Type conversion: implicit / explicit cast
Conditional
instructions Iteration instructions, loops

Workshop: Multiple examples of applications

Operating principle
Creation of arbitrary
arrays Multidimensional arrays and traversal

Workshop: Declaration and manipulation of tables

Introduction to procedural: definition, interest
Types and returns of functions
Passing of parameters:
– by value
– by reference: (ref, out)
– variable arguments (params)
Method overload
Recursion: definition, implementation

Workshop: Breakdown of the application

Exception mechanism, types
Catch and handle an exception (try / catch / finally)
Throwing exceptions (throw)

Workshop: Management of data entry errors, escalation of exceptions

Notions on classes
Character strings, dates, …
Various lists and collections, algorithms
Access to files and streams

Workshop: Manipulation of collections and flows

WinForms: presentation, components and displays
Structure of a project, references
Creation of windows
Use of controls and management of events
Organization of the application

Workshop: a directory application

Presentation of the object for the ideal structuring of the code and notions of UML
Attributes and methods
Constructors, life cycle, general memory management
The aggregation of objects
Creation of properties, visibility, encapsulation
Inheritance in the application

Workshop: Implementation of several business classes

Use of namespaces and creation
Abstract classes and interfaces
Polymorphism: interest, use
Event mechanisms
Examples of modeling for complex applications

Workshop: Organization of an application based on complex objects – advanced use of graphic controls

ADO.NET: access to any database
Communication with .NET: the web and other protocols
Presentation of additional useful elements available and C # evolutions
Creation and use of
Multithreading and synchronization processes

Workshop: Complete Case Study – A Business Agenda in C #

Web page development: HTML, CSS, JavaScript
ASP.NET web applications: application structure, page lifecycle
Web
hosting : operation Understanding web services: access from a client application, SOAP and WSDL

Details of the content of the certification
Taking and correcting a mock test
Corrected workshops
Questions / answers, time management when taking the exam

Duration

5 days

Price

£ 2119

Audience

Developers

Prerequisites

Common use of a programming language

Reference

.NE100018-F

Sessions

Contact us for more informations about session date

Talend Open Studio Data Integration : Initiation + Advanced

Goals


- Understand the data integration process

- Master the Talend Open Studio tool and the component library

Program

Data
integration issue Operational and Business Intelligence Integration
ETL (Extract Transform Load) tools available
Talend Open Studio: presentation, licenses, link with Eclipse
Support available: documentation, community, etc.

Workshop: Installation and presentation of the Talend Open Studio environment

Talend perspectives and views
Using the Business Modeler
Jobs: grid, palette of components
Main flows (main)
The notion of schema: types of columns
First components: input, output, flow generation

Practical workshop: creation and execution of a simple job, generation of content in a file

Input components (tFileInput, tMysqlInput,…)
Generation of content (tRowGenerator, tFixedFlowInput, …)
Outputs and display (tLogRow, tFileOutput, tMysqlOutput,…)
Logic and chaining of components
Step by step monitoring of execution traces of the Reject
management job
Simple transformations (filter, sort, replace, join)

Practical workshop: generation of content in a database, extraction and processing of data for display in console

Job versions and statuses
Metadata: properties and schemas.
Schema discovery for CSV files
Retrieving database schemas
Job updates from metadata

Practical workshop: inserting data sources and targets in the repository metadata

Use variables in a job (tSetGlobalVar)
Setting up a context local to the job
Context groups in the repository
Metadata as contexts

Practical workshop: use a variable in a job, contextualize the parameters of a metadata, create a test and production context

The ETL component par excellence
Managing inputs: main, secondary flows, naming of flows
Managing outputs: the integrated editor of tMap
Filtering data: input, output
Joint outputs, capture of output rejects, internal join
The expression editor
Performances

Practical workshop: multi-source, multi-destination extraction with a tMap, on a complete example

Parallel executions of sub-jobs
Talend triggers
Chaining of sub-jobs and components (OnSubjobOK, OnComponentOK)
Management of component errors, sub-job (OnComponentError, OnSubjobError)
Start and end component (tPreJob, tPostJob)
Catch and throw errors: tWarn, tDie, tLogCatcher

Practical workshop: assemble several jobs into one, factorize error management to generate a report file

Duration

5 days

Price

£ 2568

Audience

System administrators / BDD, Project managers, Developers

Prerequisites

Knowledge of Java

Reference

BUS305-F

Differentiate between main streams from iterate streams
Loops and programming via tLoop, tForeach
Switch from a main stream to an iterate stream, and vice versa (tFlowToIterate, tIterateToFlow) Job
synchronization with tWaitForFile, tWaitForSocket, tWaitForSQL

Lab: parallelize subjobs, synchronize jobs with external event

Use of advanced components: Java or regular expressions
The specificity of XML feeds in Talend
Code reuse: routines

Workshop: Using the tJavaRow, tJavaFlex components, using the embedded Java editor, deploying a custom routine

Reminders on debugging traces
Using the Java Debug mode: Debug perspective, step-by-step mode
Visualization and hot modification of variables

Workshop: Basic / advanced task debugging

Reminder on the contexts
Export of jobs for execution on a server
Passage of context between jobs, at runtime
Use of a file to load the context (tContextLoad)

Workshop: Deployment of tasks and dynamic loading of the context

Use of advanced components: Java or regular expressions
Creation of specific logs
Management of XML flows
Reuse of code

Workshop: Use of the tJavaRow, tJavaFlex components – creation of logs with tCatch, tDie … – use of the embedded Java editor

Essential concepts for extending Talend Open Studio
Creation of the component mockup with tJavaFlex / graphical interface
Discover the Talend forge and its community components
Integration into Talend Open Studio of the plugins created or downloaded

Workshop: Creation of a simple component via tJavaFlex, integration of components from the Talend forge

Sessions

Contact us for more informations about session date

Talend Open Studio Data Integration : Initiation

Goals


- Understand the data integration process

- Master the Talend Open Studio tool and the component library

Program

Data
integration issue Operational and Business Intelligence Integration
ETL (Extract Transform Load) tools available
Talend Open Studio: presentation, licenses, link with Eclipse
Support available: documentation, community, etc.

Workshop: Installation and presentation of the Talend Open Studio environment

Talend perspectives and views
Using the Business Modeler
Jobs: grid, palette of components
Main flows (main)
The notion of schema: types of columns
First components: input, output, flow generation

Practical workshop: creation and execution of a simple job, generation of content in a file

Input components (tFileInput, tMysqlInput,…)
Generation of content (tRowGenerator, tFixedFlowInput, …)
Outputs and display (tLogRow, tFileOutput, tMysqlOutput,…)
Logic and chaining of components
Step by step monitoring of execution traces of the Reject
management job
Simple transformations (filter, sort, replace, join)

Practical workshop: generation of content in a database, extraction and processing of data for display in console

Job versions and statuses
Metadata: properties and schemas.
Schema discovery for CSV files
Retrieving database schemas
Job updates from metadata

Practical workshop: inserting data sources and targets in the repository metadata

Use variables in a job (tSetGlobalVar)
Setting up a context local to the job
Context groups in the repository
Metadata as contexts

Practical workshop: use a variable in a job, contextualize the parameters of a metadata, create a test and production context

The ETL component par excellence
Managing inputs: main, secondary flows, naming of flows
Managing outputs: the integrated editor of tMap
Filtering data: input, output
Joint outputs, capture of output rejects, internal join
The expression editor
Performances

Practical workshop: multi-source, multi-destination extraction with a tMap, on a complete example

Parallel executions of sub-jobs
Talend triggers
Chaining of sub-jobs and components (OnSubjobOK, OnComponentOK)
Management of component errors, sub-job (OnComponentError, OnSubjobError)
Start and end component (tPreJob, tPostJob)
Catch and throw errors: tWarn, tDie, tLogCatcher

Practical workshop: assemble several jobs into one, factorize error management to generate a report file

Duration

3 days

Price

£ 1625

Audience

System administrators / BDD, Project managers, Developers

Prerequisites

Knowledge of Java

Reference

BUS875-F

Sessions

Contact us for more informations about session date

ASP.NET Core MVC : Initiation + Advanced

Goals


- Master the development of ASP.Net MVC Core applications with the Razor view engine and a data access layer driven by Entity Framework

Program

Pattern MVC: architecture, contributions
Creation of web applications .Net
.NET Core vs .NET Framework
ASP.Net MVC: presentation, versions, technologies used
Structure of an ASP.Net MVC project, choice of view engine
Global configuration: dependencies , bundles, filters, global configuration class
Available resources (documentation)

Workshop: Creation of an ASP.NET MVC Core project, detail of the structure

ASP.NET controller: implementation,
Route naming : default configuration, syntax
Passing and retrieving parameters in controller actions
Parameter mapping and routing modification in the RouteConfig
Choice of the result type of the action: ActionResult, FileContentResult,. ..
Download management

Workshop: Creating controllers, routing and retrieving parameters

Management of redirects from the controller: to a view, to an action, to a stream
Razor view engine: presentation, syntax
Templating views: _ViewStart (default template), custom _Layout
Access to bundles: styles, scripts
Creation of views: association with a template, structure of the
Bootstrap page : responsive design grid, main classes, available components
Management of CSS of the view
Creation of model classes, sending in the controller and retrieving in the view
Creation of forms: basic controls, restoration of values ​​after Postback
Validation of entries: management in the model and display of errors
Generation of views associated with a model with the
Internationalization of the view
Management of HTTP sessions, access in the view
Manipulation of global variables
Creation and retrieval of cookies
Management of the upload
Management of asynchronous AJAX requests
View debug: helpers (ServerInfo , ObjectInfo)

Workshop: Implementation of a complete MVC CRUD, validation of entries and imports / exports

Authentication management: available methods, selection criteria
Implementation of an authentication strategy, management of roles
Authentication filters
Security of forms against
AntiForgeryToken injections : interest, implementation

Workshop: Implementation of an authentication strategy, secure forms against injections

Setting up a cache
Traffic analysis
Resource management (Minify, Bundle) in a Razor view
Publishing the application

Workshop: Setting up a cache, multiple optimizations of the application

Architecture and technologies of access to data
Object relational mapping
Presentation of the framework, tools
Entity framework vs other ORMs (NHibernate)
Entity Data Model vs Code First
Context and connection chain

Workshop: Setting up the Entity Framework in a project in Visual Studio

Definition of the context class (DbContext), life cycle
Log management
Definition of model classes and addition in the context
Database initializers Available
conventions, additions, management of datetime2
Mapping of tables: Attributes and Fluent API
Management of primary keys: simple, compound
Concurrency management: Concurrency Check, Timestamp
Mapping of calculated columns
Relations: OneToMany / ManyToOne, OneToOne, ManyToMany Inheritance
mapping strategies: TPH, TPC, TPS
Generation of CRUD actions in a controller
Backup management in asynchronous mode

Workshop: Creation, modification of a complete data model

Migrations: definition, interests
Activation of migrations, initial migration
Adding a migration and modification of the code: SQL queries
Applying a migration: update or regression of version
Going into production at a specified migration

Workshop: Creation of database manipulation with migrations

Understand the execution of queries
Management of connections
Control of transactions
Passage of an existing connection
Methods available from the DbContext: Creation, update and deletion
Management of association loads: Lazy vs Eager
Generation of stored procedures for the entities of the model and use
Optimizing the context cache, mistakes to avoid

Workshop: Updating data and modifying the model

Overview of available data retrieval methods
Using LINQ to Entities, errors to avoid
Queries with Entity SQL
Stored procedures and handling multiple results
Queries and changes to data using ADO.Net commands
Using DataSets
Using LINQ to SQL
Managing performance

Workshop: Writing multiple queries and processing results – pagination management / creation of views

Build Optimized Solutions Using Object Services
Using Design-
Generated Entity Framework Views Performance Monitoring
Perform Asynchronous Data Changes
Offline Data Caching Using XML

Workshop: Query optimizations, offline data monitoring and caching

Duration

5 days

Price

£ 2750

Audience

.Net Developers (C # or VB.Net)

Prerequisites

Mastery of the object (C # or VB.Net), knowledge of HTML / CSS / JS

Reference

.NE100926-F

Sessions

Contact us for more informations about session date

PowerPoint : Initiation + Advanced

Goals


- Create complete presentations

- Make transitions and animations

- Know how to synthesize ideas

Program

Presentation of PowerPoint and the other tools of the Office suite
Examples of realization with PowerPoint

Description of the interface (Ribbon, Quick Access Toolbar, etc.)
Structure of a file (slideshows, sections, slides)
Create a new slide show
Using slide show templates

Add / remove slides Slide
layouts
Group your slides into sections
Move a slide

Placeholders
Insert and format text
Insert and customize shapes
Insert and customize images
Create a photo album
Insert tables
Use WordArt
Graphics and flowcharts
Insert audio and video
Organize inserted content

Use slide themes
Add a background
Create your own theme

Animating content
Personalizing your animation
Timing of animations (start, duration, delay)
Transitions between slides
Timing of transitions

Launching the slideshow mode
Creating a personalized slideshow
Configure the slideshow
The other display modes
Inserting a header and footer
Adding comments

Adding hypertext links
Adding an action on an object
Inserting multimedia content: audio and video
Printing the document
Managing the slide master
Creating its presentation template

Compare two presentations
Protect a slide show
Check that there are no problems
Share your presentation
Broadcast your slide show online

Integrate shortcuts into the Quick Access toolbar
Create a tab with your favorite tools

Definition of presentation objectives
Creation and organization of the plan
Layout of the presentation
Creation of the mask
Creation of standard slides (new part, contents)
Creation of the presentation and animations
Proofreading and corrections

Workshop: Creation of a presentation for your personal or professional project

Passing of the certification (if foreseen in the financing).

Duration

2 days

Price

£ 2495

Audience

All

Prerequisites

Knowledge of the PC environment

Reference

BUR1120-F

Sessions

Contact us for more informations about session date

PowerPoint : Initiation

Goals


- Create simple presentations

- Integrate transitions and animations

Program

Presentation of PowerPoint and the other tools of the Office suite
Examples of realization with PowerPoint

Description of the interface (Ribbon, Quick Access Toolbar, etc.)
Structure of a file (slideshows, sections, slides)
Create a new slide show
Using slide show templates

Add / remove slides Slide
layouts
Group your slides into sections
Move a slide

Placeholders
Insert and format text
Insert and customize shapes
Insert and customize images
Create a photo album
Use WordArt
Organize inserted content

Use slide themes
Add a background
Create your own theme

Animating content
Personalizing your animation
Timing of animations (start, duration, delay)
Transitions between slides
Timing of transitions

Launching the slideshow mode
Creating a personalized slideshow
Configure the slideshow
The other display modes
Inserting a header and footer
Adding comments

Passing of the certification (if foreseen in the financing).

Duration

1 day

Price

£ 2495

Audience

All

Prerequisites

Knowledge of the PC environment

Reference

BUR1150-F

Sessions

Contact us for more informations about session date

ASP.NET Web Forms Initiation

Goals


- Develop web database management applications with ASP.NET

Program

Technical choices and installation of tools
Operating principle
Architecture of an ASP.NET page
.NET programming languages ​​and their recent versions

Handling the Visual environment
Summary of VB.NET and C # syntaxes
Creating a simple project
Retrieving form data – why a dynamic website
An example: mailing and contact form
Principle of events

Common and common properties and events
The component toolbox
Form and general layout
components Complex components (calendars, views, imagemap, etc.)
Presentation of additional toolbox items (data, validation, etc.), including the display of databases
Case study: creation of multiple and various pages of a dynamic site

Principle of operation and general architecture of the pages
Detailed syntax of C # and VB.NET
Object-oriented programming: summary of what is needed for ASP.NET
Complete the dynamic site: forms and calculations, the job of the application

Handling of character strings and dates
Generalist lists and libraries of .NET
The lifecycle of the ASP.NET page
The ViewState, sessions and cookies
Increased persistence: the application, the cache
All request information and of responses
Additions to the case study: application status and user recognition

Duration

3 days

Price

£ 1625

Audience

All

Prerequisites

Notions of C # or VB.NET - Good knowledge of the object, XHTML and CSS

Reference

.NE63-F

Sessions

Contact us for more informations about session date

ASP.NET Web Forms Initiation + Advanced – 10264A

Goals


- Develop with ASP.NET Web database management applications

- Discover the different ASP.NET programming techniques for an Internet or Intranet site

Program

Technical choices and installation of tools
Operating principle
Architecture of an ASP.NET page
.NET programming languages ​​and their recent versions

Handling the Visual environment
Summary of VB.NET and C # syntaxes
Creating a simple project
Retrieving form data – why a dynamic website
An example: mailing and contact form
Principle of events

Common and common properties and events
The component toolbox
Form and general layout
components Complex components (calendars, views, imagemap, etc.)
Presentation of additional toolbox items (data, validation, etc.), including the display of databases
Case study: creation of multiple and various pages of a dynamic site

Principle of operation and general architecture of the pages
Detailed syntax of C # and VB.NET
Object-oriented programming: summary of what is needed for ASP.NET
Complete the dynamic site: forms and calculations, the job of the application

Handling of character strings and dates
Generalist lists and libraries of .NET
The lifecycle of the ASP.NET page
The ViewState, sessions and cookies
Increased persistence: the application, the cache
All request information and of responses
Additions to the case study: application status and user recognition

Internationalization (dates, texts, currencies …)
General configuration and summary of administration
Pages – a menu in a page
Information on security with ASP.NET and IIS
Deployment of an application
Application of these principles to the case study

About CSS with ASP.NET: the essential decoration of the site
Themes and master pages: organization of the presentation and time savings
Automatic validation of forms
Other points of javascript with ASP.NET
Example: the whole presentation of a dynamic site

Access to files from code-behind
Databases: SQL reminders and types of databases
Databases: business access to the database, reading, modification
Databases: advanced presentation (DataGrid and GridView, DataList , etc.)
XML: where and why
Presentation of access to XML from code-behind and web services
Multiple examples of persistent data in a dynamic site

Duration

5 days

Price

£ 2495

Audience

All

Prerequisites

Notions of C # or VB.NET - Good knowledge of the object, XHTML and CSS

Reference

.NE65-F

Sessions

Contact us for more informations about session date

ASP.NET MVC Initiation

Goals


- Master the development of ASP.Net MVC applications with the Razor view engine

Program

Pattern MVC: architecture, contributions
Creation of web applications .Net
ASP.Net MVC: presentation, versions, technologies used
Structure of an ASP.Net MVC project, choice of view engine
Global configuration: dependencies, bundles, filters, class of global configuration
Available resources (documentation)

Workshop: Creation of an ASP.Net MVC project, detail of the structure

ASP.Net controller: implementation,
Route naming : default configuration, syntax
Passing and retrieving parameters in controller actions
Parameter mapping and routing modification in RouteConfig
Choice of the type of result of the action: ActionResult, FileContentResult,. ..
Download management

Workshop: Creating controllers, routing and retrieving parameters

Management of redirects from the controller: to a view, to an action, to a stream
Razor view engine: presentation, syntax
Templating views: _ViewStart (default template), custom _Layout
Access to bundles: styles, scripts
Creation of views: association with a template, structure of the
Bootstrap page : responsive design grid, main classes, available components
Management of CSS of the view
Creation of model classes, sending in the controller and retrieving in the view
Creation of forms: basic controls, restoration of values ​​after Postback
Validation of entries: management in the model and display of errors
Generation of views associated with a model with the
Internationalization of the view
Management of HTTP sessions, access in the view
Manipulation of global variables
Creation and retrieval of cookies
Management of the upload
Management of asynchronous AJAX requests
View debug: helpers (ServerInfo , ObjectInfo)

Workshop: Implementation of a complete MVC CRUD, validation of entries and imports / exports

Authentication management: available methods, selection criteria
Implementation of an authentication strategy, management of roles
Authentication filters
Security of forms against
AntiForgeryToken injections : interest, implementation

Workshop: Implementation of an authentication strategy, secure forms against injections

Setting up a cache
Traffic analysis
Resource management (Minify, Bundle) in a Razor view
Publishing the application

Workshop: Setting up a cache, multiple optimizations of the application

Duration

3 days

Price

£ 1995

Audience

.Net Developers (C # or VB.Net)

Prerequisites

Mastery of the object (C # or VB.Net), knowledge of HTML / CSS / JS

Reference

.NE1104-F

Sessions

Contact us for more informations about session date

ASP.NET MVC Initiation + Advanced

Goals


- Master the development of ASP.Net MVC applications with the Razor view engine and a data access layer driven by Entity Framework

Program

Pattern MVC: architecture, contributions
Creation of web applications .Net
ASP.Net MVC: presentation, versions, technologies used
Structure of an ASP.Net MVC project, choice of view engine
Global configuration: dependencies, bundles, filters, class of global configuration
Available resources (documentation)

Workshop: Creation of an ASP.Net MVC project, detail of the structure

ASP.Net controller: implementation,
Route naming : default configuration, syntax
Passing and retrieving parameters in controller actions
Parameter mapping and routing modification in RouteConfig
Choice of the type of result of the action: ActionResult, FileContentResult,. ..
Download management

Workshop: Creating controllers, routing and retrieving parameters

Management of redirects from the controller: to a view, to an action, to a stream
Razor view engine: presentation, syntax
Templating views: _ViewStart (default template), custom _Layout
Access to bundles: styles, scripts
Creation of views: association with a template, structure of the
Bootstrap page : responsive design grid, main classes, available components
Management of CSS of the view
Creation of model classes, sending in the controller and retrieving in the view
Creation of forms: basic controls, restoration of values ​​after Postback
Validation of entries: management in the model and display of errors
Generation of views associated with a model with the
Internationalization of the view
Management of HTTP sessions, access in the view
Manipulation of global variables
Creation and retrieval of cookies
Management of the upload
Management of asynchronous AJAX requests
View debug: helpers (ServerInfo , ObjectInfo)

Workshop: Implementation of a complete MVC CRUD, validation of entries and imports / exports

Authentication management: available methods, selection criteria
Implementation of an authentication strategy, management of roles
Authentication filters
Security of forms against
AntiForgeryToken injections : interest, implementation

Workshop: Implementation of an authentication strategy, secure forms against injections

Setting up a cache
Traffic analysis
Resource management (Minify, Bundle) in a Razor view
Publishing the application

Workshop: Setting up a cache, multiple optimizations of the application

Architecture and technologies of access to data
Object relational mapping
Presentation of the framework, tools
Entity framework vs other ORMs (NHibernate)
Entity Data Model vs Code First
Context and connection chain

Workshop: Setting up the Entity Framework in a project in Visual Studio

Definition of the context class (DbContext), life cycle
Log management
Definition of model classes and addition in the context
Database initializers Available
conventions, additions, management of datetime2
Mapping of tables: Attributes and Fluent API
Management of primary keys: simple, compound
Concurrency management: Concurrency Check, Timestamp
Mapping of calculated columns
Relations: OneToMany / ManyToOne, OneToOne, ManyToMany Inheritance
mapping strategies: TPH, TPC, TPS
Generation of CRUD actions in a controller
Backup management in asynchronous mode

Workshop: Creation, modification of a complete data model

Migrations: definition, interests
Activation of migrations, initial migration
Adding a migration and modification of the code: SQL queries
Applying a migration: update or regression of version
Going into production at a specified migration

Workshop: Creation of database manipulation with migrations

Understand the execution of queries
Management of connections
Control of transactions
Passage of an existing connection
Methods available from the DbContext: Creation, update and deletion
Management of association loads: Lazy vs Eager
Generation of stored procedures for the entities of the model and use
Optimizing the context cache, mistakes to avoid

Workshop: Updating data and modifying the model

Overview of available data retrieval methods
Using LINQ to Entities, errors to avoid
Queries with Entity SQL
Stored procedures and handling multiple results
Queries and changes to data using ADO.Net commands
Using DataSets
Using LINQ to SQL
Managing performance

Workshop: Writing multiple queries and processing results – pagination management / creation of views

Build Optimized Solutions Using Object Services
Using Design-
Generated Entity Framework Views Performance Monitoring
Perform Asynchronous Data Changes
Offline Data Caching Using XML
Using Sync Framework

Workshop: Query optimizations, offline data monitoring and caching

Duration

5 days

Price

£ 2750

Audience

.NET Developers (C # or VB.Net)

Prerequisites

Mastery of the object (C # or VB.Net), knowledge of HTML / CSS / JS

Reference

.NE1257-F

Sessions

Contact us for more informations about session date

Windows Server 2008 Administration Initiation + Advanced

Goals


- Learn to install and administer Windows Server

- Manage users

- Discover NTFS

- Configure a network printer

- Manage Windows Server security

- Protect and monitor your server

- Install and configure Terminal Server

Program

Preparing for Installation
Installing Windows 2008 Server
Upgrading to Windows 2008 Server

Understanding User Accounts
Items Required for New User Accounts
Creating a User Account
Setting Criteria for Passwords
Setting Properties for Passwords
Customizing User Settings Using User Profiles ‘user
Management of user data by creating home directories

Overview of groups
Development of a security group creation policy
Use of predefined groups

Types of disk storage available in Windows Server
Partitioning a basic drive
Creating volumes on a dynamic drive
Performing common tasks to manage disks

Description of NTFS permissions
Applying NTFS permissions by Windows Server
Assigning NTFS permissions
Compressing data on an NTFS partition
Configuring disk quotas on NTFS volumes

Description of shared folders
Creating shared folders
Combination of NTFS permissions and shared folders: SMB, NFS, iSCSI
Setting up shared folders using the DFS system
Using the FSRM file server resource manager

Understanding Printing in Windows Server
Adding a Printer
Configuring a Network Printer
Configuring Support for a Web Browser Printer
Special Feature of Windows 2008 Print Server

Duration

5 days

Price

£ 1956

Audience

Network and systems administrators

Prerequisites

Network knowledge

Reference

WIN801-F

Windows Server Security Overview Windows Server Security
Policies
Implementing Security Policies
Auditing Access to System Resources

Classic network security tools
Implement an audit policy
Windows firewall configuration with advanced security: incoming and outgoing traffic rules

Practical work

Auditing file access. Administer the Windows firewall with advanced security. Creating rules with Netsh. Import a security template from another server

Monitoring system resources
Monitoring event logs
Optimizing performance
Troubleshooting monitoring and tuning issues

Installing, configuring and managing a DHCP server
Securing DHCP
Netsh commands for DHCP
Diagnosing and troubleshooting DHCP problems

Practical work

Installing, configuring and testing a DHCP server

Reminder on the WINS system
Reminder on the functioning of DNS
New features of DNS in Windows 2008
High availability for the DNS service
Troubleshooting and diagnostic tools

Practical work

Install and configure a DNS server. Perform functional checks with nslookup

Understanding Terminal Services
Planning the Installation
Configuring a Terminal Server
Installing Terminal Services
Installing the License Manager
Connecting to a Terminal Server
Installing Applications on a Terminal Server

Sessions

Contact us for more informations about session date

Visual Basic.Net – Initiation

Goals


- Learn to develop with VB.NET

Program

Presentation of .NET
The languages ​​of the .NET framework
Evolutions of VB / VB.Net, platforms supported
Development environment
Types of projects: console, library, WinForms, WPF, WCF, …
Minimum structure of a VB.Net program
Compilation, execution and debugging

Workshop: Manipulating the development environment – examples of VB.Net programs

Variables: declaration, common types (Common Type System)
Organization in memory (primitive types / reference types)
Operators
Type conversion: implicit / explicit cast
Conditional
instructions Iteration instructions, loops

Workshop: Multiple examples of applications

Operating principle
Creation of arbitrary
arrays Multidimensional arrays and traversal

Workshop: Declaration and manipulation of tables

Introduction to procedural: definition, interest
Types and returns of functions
Passing parameters:
– by value (ByVal)
– by reference (ByRef)
– variable arguments (ParamArray)
Overloads of methods (Overloads)
Optional parameters (Optional)
Recursion: definition, implementation

Workshop: Breakdown of the application

Exception mechanism, types
Catch and handle an exception (try / catch / finally)
Throwing exceptions (throw)

Workshop: Management of data entry errors, escalation of exceptions

Notions on classes
Character strings, dates, …
Various lists and collections, algorithms
Access to files and streams

Workshop: Manipulation of collections and flows

WinForms: presentation, components and displays
Structure of a project, references
Creation of windows
Use of controls and management of events
Organization of the application

Workshop: a directory application

Duration

3 days

Price

£ 1625

Audience

All

Prerequisites

Common use of a programming language

Reference

.NE118-F

Sessions

Contact us for more informations about session date

Windows Server 2008 Administration Initiation

Goals


- Learn to install and administer Windows Server

- Manage users

- Discover NTFS

- Configure a network printer

- Manage Windows Server security

- Protect and monitor your server

- Install and configure Terminal Server

Program

Preparing for Installation
Installing Windows 2008 Server
Upgrading to Windows 2008 Server

Understanding User Accounts
Items Required for New User Accounts
Creating a User Account
Setting Criteria for Passwords
Setting Properties for Passwords
Customizing User Settings Using User Profiles ‘user
Management of user data by creating home directories

Overview of groups
Development of a security group creation policy
Use of predefined groups

Types of disk storage available in Windows Server
Partitioning a basic drive
Creating volumes on a dynamic drive
Performing common tasks to manage disks

Description of NTFS permissions
Applying NTFS permissions by Windows Server
Assigning NTFS permissions
Compressing data on an NTFS partition
Configuring disk quotas on NTFS volumes

Description of shared folders
Creating shared folders
Combination of NTFS permissions and shared folders: SMB, NFS, iSCSI
Setting up shared folders using the DFS system
Using the FSRM file server resource manager

Understanding Printing in Windows Server
Adding a Printer
Configuring a Network Printer
Configuring Support for a Web Browser Printer
Special Feature of Windows 2008 Print Server

Duration

3 days

Price

£ 1184

Audience

Network and systems administrators

Prerequisites

Network knowledge

Reference

WIN802-F

Sessions

Contact us for more informations about session date

Visual Basic.Net – Initiation + Advanced

Goals


- Learn to develop with VB.NET

- To create basic management interfaces and to manipulate objects of the .NET platform

Program

Presentation of .NET
The languages ​​of the .NET framework
Evolutions of VB / VB.Net, platforms supported
Development environment
Types of projects: console, library, WinForms, WPF, WCF, …
Minimum structure of a VB.Net program
Compilation, execution and debugging

Workshop: Manipulating the development environment – examples of VB.Net programs

Variables: declaration, common types (Common Type System)
Organization in memory (primitive types / reference types)
Operators
Type conversion: implicit / explicit cast
Conditional
instructions Iteration instructions, loops

Workshop: Multiple examples of applications

Operating principle
Creation of arbitrary
arrays Multidimensional arrays and traversal

Workshop: Declaration and manipulation of tables

Introduction to procedural: definition, interest
Types and returns of functions
Passing parameters:
– by value (ByVal)
– by reference (ByRef)
– variable arguments (ParamArray)
Overloads of methods (Overloads)
Optional parameters (Optional)
Recursion: definition, implementation

Workshop: Breakdown of the application

Exception mechanism, types
Catch and handle an exception (try / catch / finally)
Throwing exceptions (throw)

Workshop: Management of data entry errors, escalation of exceptions

Notions on classes
Character strings, dates, …
Various lists and collections, algorithms
Access to files and streams

Workshop: Manipulation of collections and flows

WinForms: presentation, components and displays
Structure of a project, references
Creation of windows
Use of controls and management of events
Organization of the application

Workshop: a directory application

Presentation of the object for the ideal structuring of the code and notions of UML
Attributes and methods
Constructors, life cycle, general memory management
The aggregation of objects
Creation of properties, visibility, encapsulation
Inheritance in the application

Workshop: Implementation of several business classes

Use of namespaces and creation
Abstract classes and interfaces
Polymorphism: interest, use
Event mechanisms
Creation and use of processes
Examples of modeling for complex applications

Workshop: Organization of an application based on complex objects – advanced use of graphic controls

ADO.NET: access to any database
Communication with .NET: the web and other protocols
Presentation of additional useful elements available and VB.Net evolutions
Creation and use of
Multithreading and synchronization processes

Workshop: Complete Case Study – A Business Agenda in VB.Net

Passing of the certification (if foreseen in the financing).

Duration

5 days

Price

£ 2475

Audience

All

Prerequisites

Common use of a programming language

Reference

.NE173-F

Sessions

Contact us for more informations about session date