Indesign CC: Digital Publishing Advanced

Goals


- Know how to Create applications for smartphones and tablets from Indesign

- Know how to create EPUBS files for e-reader

Program

InDesign reminders
General principles

Hyperlinks, buttons and object states
Insert hyperlinks and HTML content
Creating navigation anchors
Insert a scrolling block of text
Insert and manage animations
Insert animation Adobe Edge Animate
Insert a surface allowing drag & drop ( drag and drop)
Insert an image carousel
Insert “click / tapping” features on images
Insert a video, a slide show or audio content
Insert pop-up windows
Insert an interactive map (Google Map type)

Workshop: Creation of a mobile application for s martphones and tablets.

Organize documents for the web
Create object animations
Add and create buttons
Manage object states
Export documents
Joint use with Adobe Edge Animate

Workshop: Export of documents already created in HTML5 for integration into a website.

Export for tablets and smartphones
Export in EPUB (reflow and fixed layout) format for e-readers
Export in SWF and HTML formats

Duration

2 days

Price

£ 860

Audience

Graphic designers

Prerequisites

Mastery of common InDesign functions: having taken the InDesign initiation + deepening training or equivalent knowledge. Have completed the Indesign CC and digital publication training or have equivalent knowledge

Reference

PAO937-F

Sessions

Contact us for more informations about session date

Delphi Initiation + Advanced

Goals


- Discover Delphi and develop database management applications

- Create complex applications with Delphi

- Understand processes and synchronization

Program

History and versions,
Delphi installation compared to C ++ Builder and Jbuilder
Structure of a project, files and directories
The development interface
Choice of particular solutions

The component palette; create a graphical interface
Object Inspector: complete the interface
Summary of event programming in Windows
Project manager: creation, deletion, reuse
Configuration of the environment
Debugging tools

General syntax
Types and code: basics of algorithms
Functions: organize the code
Fundamentals of the object: better organize the code
Advanced use of the object to accelerate development
General architecture of a complete software
Usual functions: texts, files, miscellaneous

Process and synchronization – Clean and optimal execution
Complex elements of user interfaces
Principles of creating new components and packages
Collections

Visual access to any database (components available)
SQL
callbacks Any queries on a database

Where to find and how to add an additional component
Printing
Data graphics
Presentation of direct access to the windows API: optimization and peripherals
Communication
– Sockets
– HTTP
– Mails
Introduction to .NET projects

Duration

5 days

Price

£ 2034

Audience

All

Prerequisites

Programming concepts

Reference

PRO60-F

Sessions

Contact us for more informations about session date

COBOL Advanced

Goals


- To be able to develop and maintain a complete and complex application in COBOL

Program

Setting up the development environment
COBOL reminders

Creation of paragraphs and sections
Calls from Perform (and comparison with Go To)
Presentation of subroutines
Calls between programs
Detailed syntax
Comparison report and common formats

Practical workshop: reorganization and completion of a management application

COBOL 74: functions
Usual functions: character strings, dates, math
COBOL 2002
Progressive depreciation and modern nonsense
Presentation of object-oriented programming with COBOL
Unicode, XML and other modernizations

Practical workshop: complex interactive application in COBOL

Duration

2 days

Price

£ 1070

Audience

Developers

Prerequisites

Have followed the « COBOL Initiation » course or have equivalent knowledge

Reference

PRO271-F

Sessions

Contact us for more informations about session date

FOG : Deployment of images Initiation + Advanced

Goals


- Knowing how to install FOG

- Understanding the challenges of system images

- Knowing how to clone and redeploy a Windows XP, Vista, 7 and Linux system

- Knowing how to manage FOG and its evolution over time

- Master the different components of FOG

- Optimization of FOG Complex scenarios installation

Program

Why deploy system images?
State of the art
Technologies usually involved
Presentation of the FOG project

Prerequisites
« Automated » installation
Use of ready-to-use virtual machines
Integration on an isolated network: DHCP, TFTP, PXE
Integration on a network already in place

Practical workshop: installing FOG on an Ubuntu server

Discovery of the interface
Preparing a workstation for cloning Workstation
management in the
Image management interface (types of images, types of OS, etc.)
Deploy an image

Practical workshop: adding positions in FOG, sending and redeploying images

Basic tasks: sending, deployment
Advanced tasks: debugging, antivirus, memory test, …
Managing groups of machines
Scheduling tasks
Performances
Using Wake On Lan functions

Practical workshop: discovery of advanced tasks, functional testing

Presentation of the client
Prerequisites
Discovery of the functionalities
Printers management
Scheduled
restart Automatic installation of software on the workstations: « Snap-ins »

Practical workshop: deployment of the client, installation of Firefox and a printer

Common problems
Advanced cleaning of a system before cloning
Using sysprep on Windows clients
Considerations on disk space, and client specificities (swap, hibernation, …)

User management
FOG backup FOG
updates
Deployment kernel updates
Report generation

Duration

4 days

Price

£ 2599

Audience

Network administrators

Prerequisites

System and network administration

Reference

Re578-F

DHCP
configuration TFTP
configuration Web server configuration (Apache + PHP)
mysql
configuration NFS configuration

Practical workshop: identification of all components, installation on an unsupported distribution

Review of classic unicast
deployment Massive multi-workstation deployment: multicast
Network & performance considerations
Modifying the deployment kernel and boot options
Modifying the PXE service

Practical workshop: setting up a multicast deployment, performance comparison

Feedback on the default installation
Configuration of storage nodes (NFS / FTP)
Adding nodes to an installation
Managing replication between nodes
Impacts on performance and resilience

Hands-on Workshop: Adding a Storage Node, Parallelized Image Deployment

General System Security Considerations
Permissions, NFS and FTP Server
Security Access Security for PHP and the Web Server

Sessions

Contact us for more informations about session date

FOG : Deployment of images Advanced

Goals


- Master the different components of FOG

- Optimization of FOG Complex installation scenarios

Program

DHCP
configuration TFTP
configuration Web server configuration (Apache + PHP)
mysql
configuration NFS configuration

Practical workshop: identification of all components, installation on an unsupported distribution

Review of classic unicast
deployment Massive multi-workstation deployment: multicast
Network & performance considerations
Modifying the deployment kernel and boot options
Modifying the PXE service

Practical workshop: setting up a multicast deployment, performance comparison

Feedback on the default installation
Configuration of storage nodes (NFS / FTP)
Adding nodes to an installation
Managing replication between nodes
Impacts on performance and resilience

Hands-on Workshop: Adding a Storage Node, Parallelized Image Deployment

General System Security Considerations
Permissions, NFS and FTP Server
Security Access Security for PHP and the Web Server

Duration

2 days

Price

£ 1303

Audience

Network administrators

Prerequisites

Linux system and network administration

FOG deployment: initiation

Reference

Re577-F

Sessions

Contact us for more informations about session date

COBOL : Developing applications – Advanced

Goals


- Effectively structure a Cobol program

- Learn advanced concepts

Program

Setting up the development environment
Reminders of the Cobol language

Creation of paragraphs and sections
Calls from Perform (and comparison with Go To)
Presentation of subroutines
Calls between programs
Detailed syntax
Comparison report and common formats

Workshop: complex structuring of Cobol programs.

COBOL 74: functions
Usual functions: character strings, dates, math
COBOL 2002
Progressive depreciation and modern nonsense
Presentation of object-oriented programming with COBOL
Unicode, XML and other modernizations

Workshop: Multiple applications of Cobol2002 appports

Practical workshop: a minimal management application

External subroutines
Internal
sorting Directives
Nested programs
Intrinsic functions
Language Environment
LE service programs
Compiler options
Debugging

Workshop: configuration of the compilation and debugging of Cobol programs – management of external subroutines

Duration

5 days

Price

£ 1605

Audience

COBOL Developers

Prerequisites

Have followed the Cobol initiation training or equivalent concepts

Reference

PRO101095-F

Sessions

Contact us for more informations about session date

COBOL Initiation + Advanced

Goals


- Know the use and possibilities of COBOL

- Be able to develop and maintain a complete and complex application in COBOL

Program

History and conditions of use
The current state of COBOL
Development environment
Presentation of COBOL for connoisseurs of other
COBOL 85 languages – detail and alternatives

Structure of a COBOL program
Declaration
Data, instructions
Compilation – minimal application

Workshop: a first COBOL application

Basic syntax, alignment
Creation of variables and edit variables
Arithmetic operators
Control structures: if, evaluate, « on » structures and condition variables
Perform for loops, and arrays;
Search in tables
Complete algorithms in COBOL

Practical workshop: a minimal management application

Read and write access to a console
Access to files from COBOL
Files: types of files and access
Consideration of performance and optimization; break, synchronizations, etc.

Practical workshop: recording and multiple readings; simulation of any errors

Creation of paragraphs and sections
Calls from Perform (and comparison with Go To)
Presentation of subroutines
Calls between programs
Detailed syntax
Comparison report and common formats

Practical workshop: reorganization and completion of a management application

COBOL 74: functions
Usual functions: character strings, dates, math
COBOL 2002
Progressive depreciation and modern nonsense
Presentation of object-oriented programming with COBOL
Unicode, XML and other modernizations

Practical workshop: complex interactive application in COBOL

Duration

5 days

Price

£ 2565

Audience

Developers

Prerequisites

Programming concepts

Reference

PRO270-F

Sessions

Contact us for more informations about session date

UI Design / XD : Initiation + Advanced

Goals


- Understand and master a UI interface for the web and application.

Program

Presentation of the user interface (UI)
The definition of the user interface.
Role of the UI Designer.
Different types of interface.

The difference in browsing the web, desktop, mobile, TV screen.
The evolution of interaction in our environment.
The ergonomics of a web user interface for desktop (Responsive design RWD) and mobile devices.

UX / UI
Zoning production principles .
wireframes, wireframe mockup.
Prototyping.
Analysis of the functionality of the interface, debriefing.
Guideline.
UI Kit.

Workshop: Creation of a Responsive Design (RWD) graphic model with guidelines and grids in Photoshop

Discovery of the interface.
Use work plans.
Draw shapes.
Responsive work plan.
Understand the assets.
Understand the components.
Create a high definition wireframe and prototype.
Animate your prototype.

Workshop: Make a prototype from the sketch you sketched the day before.

Discussions around other prototyping software.
Share its prototyping for validations.
Showcase your creations to make yourself known on social networks.
Watch on interface trends in different professions. (mobile application, automobile, VR, terminal, website, E-commerce, institutional site).
Accessibility of an interface.
Overview of the PWA Progressive web app.
Discovery of plugins to improve workflow, export and animations in XD.

Workshop: Prototyping models in XD with personalized animations.

Duration

5 days

Price

£ 2147

Audience

Web integrators / developers, graphic designers

Prerequisites

Use of Adobe Photoshop or Illustrator graphics software.

Reference

SIT101360-F

Sessions

Contact us for more informations about session date

UI Design / XD : Advanced

Goals


- Understand and master a UI interface for the web and application.

Program

UX / UI
Zoning production principles .
wireframes, wireframe mockup.
Prototyping.
Analysis of the functionality of the interface, debriefing.
Guideline.
UI Kit.

Workshop: Creation of a Responsive Design (RWD) graphic model with guidelines and grids in Photoshop

Discovery of the interface.
Use work plans.
Draw shapes.
Responsive work plan.
Understand the assets.
Understand the components.
Create a high definition wireframe and prototype.
Animate your prototype.

Workshop: Make a prototype from the sketch you sketched the day before.

Discussions around other prototyping software.
Share its prototyping for validations.
Showcase your creations to make yourself known on social networks.
Watch on interface trends in different professions. (mobile application, automobile, VR, terminal, website, E-commerce, institutional site).
Accessibility of an interface.
Overview of the PWA Progressive web app.
Discovery of plugins to improve workflow, export and animations in XD.

Workshop: Prototyping models in XD with personalized animations.

Duration

2 days

Price

£ 2147

Audience

Web integrators / developers, graphic designers

Prerequisites

Use of Adobe Photoshop or Illustrator graphics software.

Reference

SIT101359-F

Sessions

Contact us for more informations about session date

Website creation Initiation + Advanced

Goals


- Understand the principles of OpenSource and Linux

- Know how to install a Linux distribution

- Know the basics of using Linux.

- Discover PHP

- Understand and use CM

Program

Know the vocabulary: HTTP, FTP, URL, etc.
Know how to identify the main web languages: HTML, CSS, JS and PHP
Understand client / server operation
Know the evolution of websites over time

Understand the principle of HTML: tags and attributes
Know the two tag families: with and without content
Insert the essential tags: doctype, head, body, etc.

Insert text content: title or paragraph
Add media content: image, video and audio
Create hypertext links
Embed external content: video, cartography, etc.

Workshop: Create a complete page in HTML

Understand the principle of CSS: selectors and properties
Know the main selectors: tag, class and identifier
Define the font: font, size, weight and slant
Insert a border and a background
Apply a style on hover

Workshop: Create a navigation menu and apply a CSS style to it

Know the best web page layout practices
Use HTML layout tags: div, header, main, etc.
Use CSS layout properties: size, positioning and margins
Optimize the ergonomics of your website

Workshop: Create the complete template of a website

Go through a host: domain name and hosting space
Identify the hosting offer adapted to your needs
Check the implementation of the SSL certificate
Connect by FTP to your hosting space

Workshop: Upload the website created

Understanding the challenges of web referencing
Correctly tagging your content
Optimizing your images: formats, size, compression
Using analysis tools

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

Understand the functioning of a web form
Know the HTML tags to create a form
Apply a style to the elements of the form
Retrieve the data and send them by email using PHP

Workshop: Create a contact form on a web page

Split your web page into several PHP files Separate the content of the form: use a database
Know how to create a MySQL database via phpMyAdmin

Understand what a CMS is
Know the main CMS to make a blog, showcase site, e-commerce site, etc.
Know the prerequisites for installing a CMS

Install your WordPress site Set up
a WordPress site
Create your content: pages and articles
Choose a theme

Workshop: Create a new site with WordPress

Define the phases of a web project
Identify the actors of a web project
Choose the right technology to use according to your needs

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

Duration

5 days

Price

£ 1843

Audience

All

Prerequisites

Knowing how to navigate the web and use office / word processing tools

Reference

SIT273-F

Sessions

Contact us for more informations about session date

Graphic designer Affinity: Initiation + Advanced

Goals


- Master the basic functions of the Affinity suite, composed of Photo, Designer and Publisher to be able to create more or less complex graphic documents

Program

About the Affinity PAO suite, Photo, Designer, Publisher: History, Use, Features, Daily life, References.

Bitmap or Vector. Colorimetric modes: RGB, CMYK. The different representations of color. The native formats AFPHOTO, AFDESIGN, AFPUB.
Common formats: PSD, AI, EPS, SVG, PDF, TIFF, JPEG

Menu bar Options bar Toolbar Panel columns

Creation of a new “default” document
The workspace, preferences: performance and history

Workshop: the characteristics of an image

Open an image
Size and resolution of the document
Canvas
Margins
Rulers and marks
The « points of view »
Metadata

Workshop 1: Cropping, straightening an image
Workshop 2: Creating a document with bleed, adding margins

The basic selection tools
Creates a new layer from a selection
Rename layers
Pass a layer from one document to another
Play on the proportions and angle of a layer
Change the order of the layers
Activate the magnetism
Tools selection brush and selection by dispersion
Add / remove selection areas
Mask mode
Adjust selection

Workshops: cropping, layer manipulation, photomontages

Basic recording
Formats intended for paper printing
Formats intended for the WebDesigner, understanding the fundamentals

Creation of a new document
Predefined parameters: print, printing (proof), photo, web, devices
The workspace
Ruler, origin of rules, guides, guide manager, grid
Magnetism
Adding work planes
Navigation in the planes Workshop work
: creation of a simple illustration

Creating simple shapes
Color selection window
Selection
tool Node tool
Anchor points
Movements and transformations of simple shapes
The Rotation tool
Using layers and clipboard

Workshop: creating a simple illustration

Using the Bézier curve tools:
The Pen
tool Node tool
Options for converting points, actions, alignment

Workshop: squaring the circle

The Dynamic Control bar and the Layers panel
Outline
modifications Fill modifications
Color and Swatches panel
Generate a color palette from an image
Create and modify gradients
Fill
tool Transparency tool
Add an outline
Transform an object aspect into graphic style
Symbol Panel
Exchange of graphic styles and symbols

Workshop: redraw a logo in vector from an altered jpeg image

Free, captive and curvilinear
text Convert text to curves
Character and paragraph style
Exchange of character and paragraph styles

Workshop: Business card

Basic registration:
Formats intended for paper printing
Formats intended for Web
Export Persona

Creation of a new document
Predefined / personalized parameters
Creation of a predefined document
The workspace:
Display of rulers and grids, characteristics of rulers, origins and creation of guidelines.
The different shape tools
The selection tool
The attributes # 1: outline and fill
colors
Color selector Outline color and thickness
Transformation and movement of objects
Alignment and distribution of objects
Constraint keys
Creation of dimensional objects exact
Selection and precise positioning of objects
Duplication of objects and repeated operations

Workshop: Business card

Formats supported by Affinity Publisher
Image import from Affinity Publisher
Import multiple images
The Place Image panel
Choose images to pose on the fly
Import vector illustrations
Properties of image adjustments in relation to blocks
Properties of adjustments of the images in the blocks
Convert a shape into an image block
Graphic effects: drop shadow, internal, external glow …
Transparency and blending modes

Workshop: Make an A3 poster

Reminder on the types of fonts:
Serif / Sans Serif
Fixed width
Character
settings : font style, size, approach, kerning, line spacing … Text blocks and options
Texts in columns
Chaining
Texts on lines
Text formatting
List bulleted
Numbered list
Insertion of glyphs
Objects: text wrapping

Workshop: Make an A4 front – back 3 pane brochure

Export in pdf for printing
Settings and options
Export in pdf for the web
Settings and options

Using the Bézier curve tools
Reminder of the basics of geometry
The pen tool
Adding / removing an anchor
point Point conversion tool
Bézier workshop: the basics

Precise trimming of a complex shape using the pen tool
Converting curves to a selection area
Save its curves

Workshop: trimming using the pen tool

White
balance Dark tones / light tones
Analysis of the RGB / CMYK histogram
Analysis of the histogram of the separated layers
Adjustments according to the needs of the image:
Curves, levels, channel mixer

Workshop: correcting the colorimetry of an image

The Pages panel
Navigation between pages
Inserting pages
Moving pages
Deleting pages
Templates or standard pages
Creation and application of templates Page
numbering (folio)

Workshop: Formatting an article on 2 double pages

Use of paragraph styles
Creation of the table of contents
Layout and update of the table

Workshop: Create a table of contents on a multi-page document, update it after modifications

Default libraries Library
behavior
Create your own library
Delete libraries
Delete library items

Workshop: Create a library and share it

Duration

5 days

Price

£ 1620

Audience

Everyone

Prerequisites

Knowledge of the PC or Mac environment

Reference

PAO100553-F

Sessions

Contact us for more informations about session date

Graphic designer Affinity: Advanced

Goals


- Master the basic functions of the Affinity suite, composed of Photo, Designer and Publisher to be able to create more or less complex graphic documents

Program

Using the Bézier curve tools
Reminder of the basics of geometry
The pen tool
Adding / removing an anchor
point Point conversion tool
Bézier workshop: the basics

Precise trimming of a complex shape using the pen tool
Converting curves to a selection area
Save its curves

Workshop: trimming using the pen tool

White
balance Dark tones / light tones
Analysis of the RGB / CMYK histogram
Analysis of the histogram of the separated layers
Adjustments according to the needs of the image:
Curves, levels, channel mixer

Workshop: correcting the colorimetry of an image

The Pages panel
Navigation between pages
Inserting pages
Moving pages
Deleting pages
Templates or standard pages
Creation and application of templates Page
numbering (folio)

Workshop: Formatting an article on 2 double pages

Use of paragraph styles
Creation of the table of contents
Layout and update of the table

Workshop: Create a table of contents on a multi-page document, update it after modifications

Default libraries Library
behavior
Create your own library
Delete libraries
Delete library items

Workshop: Create a library and share it

Duration

2 days

Price

£ 777

Audience

Everyone

Prerequisites

Knowledge of the PC or Mac environment

Reference

PAO100552-F

Sessions

Contact us for more informations about session date

Adobe Graphic Designer Initiation + Advanced

Goals


- Master the basic functions of the Photoshop, Illustator and InDesign trilogy to be able to create more or less complex graphic documents

Program

The fundamentals of the Adobe Photoshop / Illustrator / InDesign Suite

About the DTP Adobe, Photoshop, Illustrator, InDesign suite: History, Use, Features, Day-to-day, References.

Discern Matrix or Vector
Understand the colorimetric modes: RGB, CMYK and the different representations of color.
Distinguish between working formats: .psd, .psb, .indd, .ai, .pdf, ect.

Menu
bar Options
bar Toolbar
Panel columns

Create a new “default” document
Open an image
Discover the characteristics of an image: Image size and resolution
Modify the work area

Workshop: Crop, straighten an image

Differentiate between quick selection tools and magic wand
Create a layer by copying
Pass a layer from one document to another
Apply a manual transformation
Rename the layers
Change the order of the layers
Basic recording

Photomontage workshops: Layers from one image to another the other, the basics of photomontage

Create a new document
Work with the rulers, rulers origin, guides and smart guides
Navigate the work plane
Create simple shapes Understand the
color picker
Differentiate the selection tool and direct selection tool
Understand the notion of anchor point
Move and transform simple shapes:
– The Rotate tool
– The Scale
tool – The deformation tools
Use layers
Discover the “Bézier curves” tools

Workshop: Create a pictogram with simple shapes

Modify the outline color
Modify the fill color
Work with the swatch panel
Add an outline
Work with the text in Illustrator
Configure the character formatting: font style, size, approach, kerning, line spacing … Free text, captive and curvilinear

Workshop: Create a vector logo

Create a new document
Work with rulers, rulers origin, guides and smart guides
Navigate the work plane
Understand graphics block tools
Differentiate selection tool and direct selection tool
Color outline and fill
Change outline thickness and color
Transform objects
Work with text in InDesign
Configure character formatting: font style, size, approach, kerning, line spacing …

Workshop: Business card

Import images from InDesign
Import multiple images
Import Photoshop compositions
Import Illustrator vector illustrations
Master the Links palette
Modify links
Embed an image

Workshop: Make an A3 poster

Work with text blocks and options: texts in columns, chaining
Import text: with formatting / without formatting
Link a text file

Workshop: Make a double-sided A4 brochure 3 pane

Handling the Pages panel
Navigating between pages
Inserting pages
Moving pages
Deleting pages

Workshop: Formatting an article on 2 double pages

Preflight and assembly
Export to pdf

 

Reminders on the basic selection tools
Create a layer by copying
Add / remove selection areas
Discover the photo editing tools
Fill with the content taken into account
Paint and change colors
Correct images: Corrector tool, localized corrector tool, part tool , Stamp tool

Workshop: Retouch a photo

Reminders on text formatting
Use paragraph styles
Define a character style
Define a paragraph style
Reminders on image imports
Dress up text with images

Workshop: Format a promotion brochure

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

Duration

5 days

Price

£ 2138

Audience

Everyone

Prerequisites

Knowledge of the PC or Mac environment

Reference

PAO942-F

Sessions

Contact us for more informations about session date

Adobe Graphic Designer Advanced

Goals


- Master the basic functions of the Photoshop, Illustator and InDesign trilogy to be able to create more or less complex graphic documents

Program

Reminders on the basic selection tools
Create a layer by copying
Add / remove selection areas
Discover the photo editing tools
Fill with the content taken into account
Paint and change colors
Correct images: Corrector tool, localized corrector tool, part tool , Stamp tool

Workshop: Retouch a photo

Reminders on text formatting
Use paragraph styles
Define a character style
Define a paragraph style
Reminders on image imports
Dress up text with images

Workshop: Format a promotion brochure

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

Duration

2 days

Price

£ 1015

Audience

Everyone

Prerequisites

Knowledge of the PC or Mac environment

Reference

PAO947-F

Sessions

Contact us for more informations about session date

Website creation Advanced

Goals


- Discover PHP

- Understand and use CMS

Program

Understand the functioning of a web form
Know the HTML tags to create a form
Apply a style to the elements of the form
Retrieve the data and send them by email using PHP

Workshop: Create a contact form on a web page

Split your web page into several PHP files 

Separate the content of the form: use a database
Know how to create a MySQL database via phpMyAdmin

Understand what a CMS is
Know the main CMS to make a blog, showcase site, e-commerce site, etc.
Know the prerequisites for installing a CMS

Install your WordPress site

Configure a WordPress site
Create your content: pages and articles
Choose a theme

Workshop: Create a new site with WordPress

Define the phases of a web project
Identify the actors of a web project
Choose the right technology to use according to your needs

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

Duration

2 days

Price

£ 863

Audience

Webmasters

Prerequisites

Have followed the "Webmaster: Initiation" course or have equivalent knowledge 

Reference

SIT274-F

Sessions

Contact us for more informations about session date

Graphist Initiation + Advanced

Goals


- Learn the basics of graphic design with free software

- Create business cards, flyers, brochures

- Discover the advanced functions

Program

About The Gimp, Inkscape and Scribus, history, use, functionalities and philosophy of Open Source DTP
Image types: Bitmap and Vectorial / Capture, display and print devices. Colorimetric modes: RGB, CMYK and pantone colors. The chromatic circle and the different representations of color.
How to organize the creation of a graphic document. Which tool to use, how are The Gimp, Inkscape and Scribus complementary?
Offers color, what color for what message.

Presentation of Gimp and its environment
Software preferences
Floating windows: configuration and use
Customization of the workspace
Document formats
Display and magnifying tool
Layers and history Fundamentals
Open a file
Crop
Straighten a photo
Modify the dimension
Modify the resolution
Color modes

Workshop: Modify the frame of an image

Rectangle and ellipse selection
tools Lasso and Smart scissors tools
Magic
wand Color
selection Selection editor
Reuse a selection
Alignment and distribution
Deformations: rotation, scale, shear, perspective

Workshop: Learn to use clipping tools according to your needs

The layer parameters
Floating layer
Manipulation of layers
Modification of names
Opacity / Blending modes

Workshop: Organize a composition, cut out areas of an image to pass them into another composition.

Text editor – GvD / DvG
Text block handles Text
attributes
Selection based on text Plain and gradient
color
Text on path

Workshop: Create a flyer in A5 format

Exports for printing
Exports for the web

Menu
bar Tool control
bar Tool
bar Command bar
Graphic area
Color
bar Information bar

Navigation in the workspace
The rectangle tool
The selection and transformation tool
Presentation of Bézier
The editing tool for nodes and handles
Logic of hard / soft nodes: Hard / soft nodes
/ add / delete / convert
L ‘ tool for adjusting objects and paths
The ellipse / arc and pie chart
tool The polygon
tool Connector tool

Workshop: Redraw a pixelated logo

Outlines
Outline style
Fill
Color
picker Paint
bucket Color gradient Gradient
editor
Alpha layer
Eyedropper

Workshop: color a vectorized logo

Why clones?
Paving
clones Workshop clone editing
: use a logo pattern to make a background for a business card

Presentation of the layer panel
Layers attributes
Hierarchy between slaps Blending
modes
Opacity
Free
text Captive
text Text on path

Workshop: Make a flyer in A5 format

Downloading and installing Scribus and Ghostscript
Presentation of the interface
Presentation of menus, tools and panels
Text blocks, images and objects

Creation of a new document: the different types of documents The different parameters of the document according to its destination: printing, web Document structure: templates and models Import formats Workshop: creation of different types of documents

The management of the different planes
The options of the layers
The parameters of the blending modes

Workshop: Organizing a document with the layers

Importing text
style sheets
Chaining text
The dressing

Workshop: realization pages maga s ine, use style sheets

The shapes and layouts vector
illustrations

Workshop: Realization of a multi-page brochure

Brush
Airbrush
Eraser
Use brushes
Use patterns
Duplication stamp

Workshop: Color a map, remove a disturbing element from the image

Reminder of the basics of geometry
The pen tool
Add / remove anchor
point Point conversion tool Bézier workshop: the basics

Precise clipping of a complex shape from a work path
Transformation of a work path into a selection area
Retrieve the work path
Creation of a new layer from the selection area
Manual transformation in several steps # 2

Workshop: trimming using the pen tool

Options for importing a .svg
Editing plots
Convert a plot into a selection

Workshop: color a map

Add background
Brightness and contrast
Correct exposure
Correct colors
Blur an area of ​​the image

Workshop: rework the colorimetry of a bland image

Object in path
Contour in path
Union
Difference
Intersection
Exclusion
Division
Decomposition
Combination
Separation
Discovery of filters
Adding filters
Editing filters

Workshop: create a complex logo

Formatting
Management of tables
Importing data
Importing images

Workshop: creation and formatting of tables

Automatic pagination
footnotes

Workshop: automation of pagination, creation

Exports for printing Exports for the web

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

Duration

5 days

Price

£ 2140

Audience

All beginners who are not familiar with creation techniques

Prerequisites

Knowledge of the PC or Mac environment

Reference

PAO943-F

Sessions

Contact us for more informations about session date

Graphist Advanced

Goals


- Learn the basics of graphic design with free software

- Create business cards, flyers, brochures

- Discover the advanced functions

Program

Brush
Airbrush
Eraser
Use brushes
Use patterns
Duplication stamp

Workshop: Color a map, remove a disturbing element from the image

Reminder of the basics of geometry
The pen tool
Add / remove anchor
point Point conversion tool Bézier workshop: the basics

Precise clipping of a complex shape from a work path
Transformation of a work path into a selection area
Retrieve the work path
Creation of a new layer from the selection area
Manual transformation in several steps # 2

Workshop: trimming using the pen tool

Options for importing a .svg
Editing plots
Convert a plot into a selection

Workshop: color a map

Add background
Brightness and contrast
Correct exposure
Correct colors
Blur an area of ​​the image

Workshop: rework the colorimetry of a bland image

Object in path
Contour in path
Union
Difference
Intersection
Exclusion
Division
Decomposition
Combination
Separation
Discovery of filters
Adding filters
Editing filters

Workshop: create a complex logo

Formatting
Management of tables
Importing data
Importing images

Workshop: creation and formatting of tables

Automatic pagination
footnotes

Workshop: automation of pagination, creation

Exports for printing
Exports for the web

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

Duration

2 days

Price

£ 1015

Audience

All beginners who are not familiar with creation techniques

Prerequisites

Knowledge of the PC or Mac environment

Reference

PAO945-F

Sessions

Contact us for more informations about session date

Informix Database Initiation + Advanced

Goals


- Perform any schemas and queries on Informix

- Describe the multi-tasking architecture IBM Informix Dynamic Server

- Install, maintain, administer and optimize an IDS server

Program

History, versions and licenses
Choice of platform (Windows / Unix or other)
Internal architecture of an Informix server

Installation Configuration
parameters
Configure an IBM Informix Dynamic Server database
Instance modes
Access principles
Configure Client-Server connectivity

Virtual Processors
Shared memory
Disks, chunks and tablespaces
Tables, views, indexes and schemas
SQL language; Informix standards and features
Multiple joins, stored procedures

Storage structures (raw device)
Management of dbspaces
Handling of chunks
Tables and temporary files
Users and security: authentication modes, accounts, roles, permissions
Various automation of administration tasks

Physical Logging
Logging activity
Logging logical
structure and logical log backup
utility onlog

Backup planning
Restoration strategy
Available tools:
* Ontape: configuration, backup, restore
* Onbar: configuration, verification, backup, restore

Manage and optimize index constructions and sorting space
Monitoring user activity
Event alarms
Incident management (Troubleshooting)

Duration

5 days

Price

£ 2435

Audience

Database administrators

Prerequisites

System administration concepts

Reference

BAS100548-F

Sessions

Contact us for more informations about session date

Informix Database Advanced

Goals


- Perform any schemas and queries on Informix

- Describe the multi-tasking architecture IBM Informix Dynamic Server

- Install, maintain, administer and optimize an IDS server

Program

Informix installation and general maintenance reminders
Presentation of an existing database

Physical Logging
Logging activity
Logging logical
structure and logical log backup
utility onlog

Backup planning
Restoration strategy
Available tools:
* Ontape: configuration, backup, restore
* Onbar: configuration, verification, backup, restore

Manage and optimize index constructions and sorting space
Monitoring user activity
Event alarms
Incident management (Troubleshooting)

Duration

2 days

Price

£ 1111

Audience

Database administrators

Prerequisites

System administration concepts

Reference

BAS296-F

Sessions

Contact us for more informations about session date

DB2 Universal Database Initiation + Advanced

Goals


- Perform any schemas and queries on DB2-UDB

- Know the main functions of the server

- Install, maintain, administer and optimize a DB2 UDB server

Program

History, versions and licenses of DB2-UDB
Other products in the UDB range
Choice of platform (Windows / Linux / Unix or Z / OS)
Roles and stakeholders of a database
Other concurrent systems

Installation and minimal configuration
Active DB2-UDB components
Primary users and access rights

Tablespace systems, instances and databases : definition, type, characteristics
Tables, views, indexes and schemas
SQL language; DB2 standards and features
Multiple joins, stored procedures
Elements of time optimization for queries
Wizards, Help and Information Center

Administration
tools available Scripting tools
Users and security: authentication modes, accounts, roles, permissions
Various automation of administration tasks

Presentation
Formats used: WSF, DEL, ASC, IXF files
Commands available and supervision by the control center

Presentation of the recovery unit
Logs (circular / linear logging )
Backup: images, installation and configuration of the BACKUP tool
The RESTORE and ROLLFORWARD utilities: use, optimization

Performance monitoring (RUNSTATS)
Server maintenance (REORGCHK)
Observation of limits and general optimization

Duration

5 days

Price

£ 2599

Audience

Database administrators

Prerequisites

Notions of Windows or UNIX system administration

Reference

BAS291-F

Sessions

Contact us for more informations about session date

DB2 Universal Database Advanced

Goals


- Perform any schemas and queries on DB2-UDB

- Know the main functions of the server

- Install, maintain, administer and optimize a DB2 UDB server

Program

DB2-UDB installation and general maintenance reminders
Presentation of an existing database

Presentation
Formats used: WSF, DEL, ASC, IXF files
Commands available and supervision by the control center

Presentation of the recovery unit
Logs (circular / linear logging )
Backup: images, installation and configuration of the BACKUP tool
The RESTORE and ROLLFORWARD utilities: use, optimization

Performance monitoring (RUNSTATS)
Server maintenance (REORGCHK)
Observation of limits and general optimization

Duration

2 days

Price

£ 1111

Audience

Everyone

Prerequisites

DB2 administration concepts

Reference

BAS293-F

Sessions

Contact us for more informations about session date

E-Marketing Expert

About Google Adwords scripts

Google has integrated its Google Apps scripts into Google Adwords and that’s really good news! Thanks to the scripts, you will be able to automate the distribution of ads when you make promotions for example.

It will be necessary to plan a specific campaign for that, to create groups of provisional advertisements according to the promotions to come and to write scripts (with a language close to javascript) which will automate the creations of advertisements. Of course, you can do a lot of other things with scripts and in particular automate the activation / deactivation of ads, increasing bids, changing ad texts, etc.

2 available trainings:

Photoshop advanced: Retouching, color corrections, Camera Raw

Goals


- Master the advanced features of Photoshop for photo editing, photomontage and color corrections

Program

Working with Pixel Layers Working with Vector Layers Working with Adjustment Layers Using Clipping Layers Using Smart Objects

Master the selection tools
Work with the different selection methods
Use the Improve the contour window
Master the selection by color range
Use the layers

Workshop: making complex outlines (hair, furs, etc.)

Master the precautions for use
Analyze the RGB histogram
Work with mid / dark / light tones
Analyze the histogram of the separated layers
Adjust according to the needs of the image:
Curves: automatic method, pipette method, histogram method
Levels: method automatic, eyedropper method, histogram method
Color balance – Hue saturation

Workshop: working on the colorimetry of an underexposed and dull photo

Work on the skin
texture Change the color of the eyes
Change the color of the hair
Change the color of the skin
Refine the features / contours of the face
Work on the general atmosphere of the composition

Workshop: retouching portraits

Use the puppet warp tool
Use the transformation functions (perspective, warp cage)
Use the perspective warp
tool Use the perspective buffer tool via the « vanishing point » filter
Use the scale tool based on the content

Workshop: making complex assemblies in perspective

Use diagram blur
Use depth of field blur
Create and apply a sharpness mask
Use path
blur
Use rotation blur Use Bokeh options

Workshop: putting into practice the different types of blur

Master the workflow options Analyze the color space of the native photo Simulate the print color space in perception / relative mode Simulate ink and paper Resize and master the resolution Work on output sharpness Open files in Photoshop as a dynamic object Control the information on the photo and the histogram

Use the white balance tool
Use the color sampling tool
Use the targeted adjustment tool
Crop and work the presets
Use the straighten and auto straighten
tool Use the blemish removal tool and options
Retouch red eye
Use the retouch brush and its options
Use the graduated filters, handles and options / mask
Use the radial filter, the handles and options / mask

Workshop: work on the basic development of a .dng

Work on white balance Use preset settings Work on temperature and tint Work on exposure Use fill light Work on blacks / brightness / contrast Work on clarity / vibrance and saturation

Use curves « parametric » mode:
Tons clear
bright shades
Dark shades
Shadows

Use the curves in « points » mode:
Linear
Medium
contrast Strong contrast
Personalized

Work on sharpness and options:
Gain, radius, detail, masking
Reduce noise:
Luminance, detail and contrast of luminance
Color, detail and smoothing of colors

Use TSI / Grayscale and Partial
Toning : Convert to Grayscale
Adjust Hue, Saturation and Luminance
Highlights:
Hue Saturation
Balance
Dark Tones:
Hues
Saturation

Duration

5 days

Price

£ 1620

Audience

Experienced Photoshop users

Prerequisites

Master the main functions of the software: have followed the Photoshop initiation + in-depth training or have equivalent knowledge

Reference

PAO693-F

Sessions

Contact us for more informations about session date

Advanced Photoshop with Adobe certification preparation

Goals


- Master the advanced features of Photoshop and preparation for certification

Program

Prepare a project

Define the needs, the expected audience and the objectives pursued

Update on current legislation

Prepare, set up, distribute tasks, monitor and deliver the project

The image: the building blocks

Images for the Web
Images for presentation
Images for video
Images for professional printing

RGB and CMYK color spaces Definition and resolutions of images Common formats of graphic documents / images and their uses Open, import, save, export

Knowledge of Photoshop

The interface
The tools
The layers
The layers The layer
masks
The adjustment
layers
The fill layers The import of documents: dynamic objects
The settings of the workspace
Layer compositions Layer
styles or effects

Use Bridge: sort, organize, manage documents
Synchronize color spaces of Creative Cloud applications

The tools
The other methods: « Selection by color range »
Use of layers
Improvement of the selection contour

Workshops: Cropping complex images

The predefined shapes
Configure the shape of the tip
Create and use patterns

Workshop: create a tip shape for illustration

Actions
Batch processing

Workshop: create and use actions for processing a series of images

Image work: manipulate and transform

The color charts The color
spaces of the color charts
Use, manage, import and export color charts
Exchange color charts between the different software in the suite

Advanced and non-destructive colorimetric corrections
Adjustment layers Blending
modes
Levels Hue / saturation
curves,
color balance, selective corrections

Retouch a photo
Create a photomontage and an advanced image fusion
Use the layer masks
Modify the outline of the layer mask
Workshop: retouch a portrait

Overlay elements in the perspective of an image
Correct and modify a perspective plane
Workshops:
Create a photomontage in a defined perspective plane
Redefine and correct a perspective plane of an image

Copy, clone, fill
Retouch
tools Duplication tools
Replace an element in an image
Fill and move content with the « Content-based move » tool
Workshop: remove an element from an image

Create text
Manage formatting: use styles
Graphically enrich text: layer styles
Deformations of the envelope

Workshop: create a poster

The pen tool and Bézier curves
Principle and uses
Options and modifications of vector paths

Vector shapes and layers
Combine vector shapes: addition, subtraction, intersection, etc.
Use vector paths for clipping
Use vector paths for the graphic enrichment of an image

Workshops:
Crop an image using a vector path
Create an illustration with vector shapes

Correction filters: blur, sharpness, optical distortion
Galleries of blur effects
Galleries of creation filters: artistic, textures, etc.
Camera RAW
Vanishing Point

End use of the document

Export to PDF for printing
Export to PDF for web or screen presentation
Other export formats

Slices
GIF animation
Workshops:
Create the graphical interface of a website page
Create a GIF animation

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

Duration

5 days

Price

£ 1944

Audience

Experienced Photoshop users

Prerequisites

Mastery of the main functions of the software. Have followed the Photoshop initiation + deepening training or have equivalent knowledge

Reference

PAO1081-F

Sessions

Contact us for more informations about session date

SQL Server Advanced

Goals


- Optimally create and maintain an MS SQL server

Program

Reminders of installation and general maintenance of MS SQL Server
Presentation of an existing database

Monitoring by alerts and triggers
Various automation of administrative tasks
Maintain multiple servers
High availability points

Data transfers; presentation of SSIS
Backup: reminders and supplement
Retrieve a backup
Observation of limits and general optimization

Duration

2 days

Price

£ 1564

Audience

Database administrators

Prerequisites

Typical use of MS SQL server

Reference

BAS287-F

Sessions

Contact us for more informations about session date

Photoshop initiation + Advanced

Goals


- Master the main features of Photoshop

- Know how to touch up an image

- Design compositions and create effects using layers and filters

- Master non-destructive work in Photoshop

- Know how to create complex edits and clipping

- Use automation tools in batch processing

Program

Learn its history
Know the features
Understand the different uses

Differentiate the types of images: Bitmap and Vector
Differentiate the color modes: RGB, CMYK and Pantone colors
Use the chromatic circle and the different representations of color
Understand the main graphics formats: Photoshop native formats, PSD, PSB, PDF, PSDT
Understand the other common formats: AI, EPS, PNG, TIFF, JPEG…

Become familiar with menu bars, options, tools, windows, interface customization using workspaces

Create new documents using Photoshop basic templates (print, web, etc.)
Open an image
Check the size and resolution of the image
Correct the work area
Create and manage the layers
Rename the layers
Modify the order of the layers
Use the lasso and selection tools via geometric shapes
Configure object selection, quick selection, select subject and magic wand
Add or remove selection areas
Improve the selection area with the appropriate tools

Workshop: create photomontages, make simple and complex deep etchings of various visuals

Master the clone stamp, patch, healing tools
Manage the history brush and art history brush tools
Use and differentiate eraser, background eraser and magic eraser

Workshop: cleaning up parasites in pictures

Discover the duplication stamp tool and its settings
Use the Blur, sharpen and smudge tools

Use the dodge, burn and sponge tools

Workshop: give a new look to old photos

Protect the background layer
Choose the appropriate selection tools
Navigate through the layers
Use the deep etching tools to refine the photomontage
Group and sort the layers
Transform a group of layers
Discover and browse the layer blending modes

Workshop: remove prominent elements from images

Understand how adjustment layers work
Use adjustment layer layer masks
Apply a layer mask to an image layer

Workshop: create non-destructive photomontages with multiple possible corrections

Manage text tools
Master the text layer and layer styles
Use the text mask tool with a textured document
Clip a text layer on an image

Workshop: create texts with different visual effects

Understand the benefits of vector elements
Use the shape tools
Draw shapes
Draw vector masks

Workshop: create graphic visuals using vector tools

Use Bézier curves
Add / remove anchor points
Convert points
Cut out from work paths
Transform a work path into a selection area
Retrieve the work path
Create a new mask from the selection area

Workshop: precisely deep etch visuals using the pen tool

Use the « select and mask » window to improve a complex selection
Work on the skin texture via the healing brush tool
Change the eye color via the adjustment layers
Change the hair color via the adjustment layers
Modify the skin tone via the adjustment layers
Refine the facial features and contours via the liquify filter
Work on the general atmosphere of the composition with the appropriate tools

Workshop: retouch complex portraits with non-destructive techniques

Discover the transformation options
Discover the vanishing point and perspective tool
Modify elements in the image
Highlight elements in the image
Work on the general atmosphere of the composition

Workshop: retouch a complex urban landscape with non-destructive techniques

Perform actions
Use batch processing
Set up custom methods
Create PDF contact sheets

Workshop: automate repetitive action tasks on a large number of files

Animate in video
Animate frame by frame
Manage layers
Configure editing
Use the timeline
Master keyframes
Export
Choose the right formats

Workshop: create animations in animated gifs

Discover the constraints of the web
Use the slice and slice select tool
Save for the web
Use the dialog box
Use the correct predefined parameters
Manage the options
Know the formats

Workshop: save images optimized for the web

Understand the different ICC profiles
Know the sampling methods
Know the correct print settings
Export to PDF

Optimal use of cross-functionalities with the softwares of the Adobe suite:
Adobe Illustrator
Adobe InDesign
Adobe After Effects
Adobe Premiere pro

Duration

5 days

Price

£ 1125

Audience

Everyone

Prerequisites

Knowledge of the PC or Mac environment

Reference

PAO79-F

Sessions

Contact us for more informations about session date

Photoshop Advanced

Goals


- Master non-destructive work in Photoshop

- Know how to create complex edits and clipping

- Use automation tools in batch processing

Program

Use the « select and mask » window to improve a complex selection
Work on the skin texture via the healing brush tool
Change the eye color via the adjustment layers
Change the hair color via the adjustment layers
Modify the skin tone via the adjustment layers
Refine the facial features and contours via the liquify filter
Work on the general atmosphere of the composition with the appropriate tools

Workshop: retouch complex portraits with non-destructive techniques

Discover the transformation options
Discover the vanishing point and perspective tool
Modify elements in the image
Highlight elements in the image
Work on the general atmosphere of the composition

Workshop: retouch a complex urban landscape with non-destructive techniques

Perform actions
Use batch processing
Set up custom methods
Create PDF contact sheets

Workshop: automate repetitive action tasks on a large number of files

Animate in video
Animate frame by frame
Manage layers
Configure editing
Use the timeline
Master keyframes
Export
Choose the right formats

Workshop: create animations in animated gifs

Discover the constraints of the web
Use the slice and slice select tool
Save for the web
Use the dialog box
Use the correct preset parameters
Manage the options
Know the formats

Workshop: save images optimized for the web

Understand the different ICC profiles
Know the sampling methods
Know the correct print settings
Export to PDF

Learn optimal use of cross-functionalities with the softwares of the Adobe suite:
Adobe Illustrator
Adobe InDesign
Adobe After Effects
Adobe Premiere pro

Duration

2 days

Price

£ 495

Audience

Everyone

Prerequisites

Have taken the « Photoshop Initiation » course or have equivalent knowledge

Reference

PAO77-F

Sessions

Contact us for more informations about session date

PostgreSQL : Advanced administration

Goals


- Master the advanced administration actions of PostgreSQL

Program

Concept of execution plan
– Estimated plan and real plan
– Optimizer parameters
Visualization of the execution plan
– EXPLAIN command
– Estimated costs and real costs
Execution phases of a query
– Browsing of tables
– Sorting
– Joins
– Aggregates
– Functions

Workshop: Understand the execution plan of a query with a view to its optimization

The SQL / MED standard
Notion of Foreign Data Wrapper
– Remote server
– User correspondence
– Foreign table
– Import of schemas
Notion of pushdown of requests

Workshop: Access to a remote PostgreSQL server

Checkpoints
– Concept of checkpoints
– Bgwriter process – Checkpoint
statistics
– Logging of checkpoints
– Configuration of checkpoint activity
– Linux kernel and checkpoints
Transaction logs
– Principle of operation
– Unit size, minimum and maximum space
– Archiving of transaction

Workshop: Optimized configuration of checkpoints and transaction logs

Presentation of declarative partitioning
Types of partitioning
Managing a partitioned table
Restrictions, joins, aggregates and partitions
Limitations according to versions

Lab: Implement a partitioned table

Presentation of the types of replications
Global principle of replication
Data
retention – Retention of transaction logs
– Infrastructure of replication slots
Physical replication
– Log-Shipping and Streaming Replication
– Synchronization of instances: pg_basebackup
Logical replication

Problem
Choice of Pg-Pool II (Linux)
– Presentation
– Features
Installation of Pg-Pool II
Configuration

Workshop: Implementing a load balancing cluster

Passing of the certification (if foreseen in the financing)

Duration

3 days

Price

£ 1956

Audience

PostgreSQL database administrators

Prerequisites

Have taken the PostgreSQL Administration course or equivalent knowledge

Reference

BAS100677-F

Sessions

Contact us for more informations about session date

Access : Initiation + Advanced

Goals


- Learn to design a database and tables

- Improve the ergonomics of a database

- Learn about VBA and SQL languages

Program

Presentation of Access and the other tools of the Office suite
Examples of implementation with Access

The vocabulary to use
Description of the interface (Ribbon, Quick Access Toolbar, etc.)
Structure of a file (database, tables, fields and records)
Create a database
The different editing modes of ‘Access

Create a table
Define the primary key of the new table
Integrate fields and apply a data type to them
Configure field properties
Index a table
field Calculated fields

Creation of the relational model
Create a relation manually
Define a type of relation
The different joins
Check the object dependencies
Automatic relation thanks to the drop-down lists on a field

Workshop: Creation of a complete database with tables and relations

Query creation
Gather fields from several tables
Filter the data to display
Introduce regular expressions
Use query parameters
Use functions (sum, average, concatenation, etc.) in queries
Group data

Identify duplicates in a table
Perform a crosstab
Find non-matches on records

Workshop: Data extraction in order to produce statistics

Create a form via a table or a query
Use the wizard for form creation
The different areas (header, details and footer)
Modify the visual of a form
Adapt the properties
Insert action buttons
Integrate sub -forms

Workshop: Improve the user interface of your database

Create an independent form
Display the form when opening the database
Integrate various controls (text zone, drop-down list, checkbox

Workshop: Create a navigation system within your Access database

Create a report via a table or a query
Use the report creation wizard
Modify the visual of a report
Adapt the properties
Perform groupings and sorts

Open a report via a form
Integrate a filter on a report via a form

Create labels using Access data
Integrate a table or query for a Word mail merge

Import an Excel table into an Access table
Import a CSV file
Export data to Excel, Word or in PDF format
Save all import / export steps

Bulk add data
Apply a change to an entire field
Quickly delete a large amount of data

Passing of the certification (if foreseen in the financing)

Duration

5 days

Price

£ 2174

Audience

Everyone

Prerequisites

Knowledge of office software such as Word and Excel

Reference

BAS1102-F

Analyze the performance of the database or of a table
Split the database
Compact and repair the database
Encrypt its database with a password

The interest of macros
Principle of operation of a macro
Concept of event
Macros on command button
Start a macro when opening the database

Condition Notions
Error Handling
User Interface
Macros Data Macros

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

See and modify the code of a macro
Language syntax
Variables
Constants
Operators
Integrating a VBA function in an Access macro

The DoCmd
object The Form 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)

Discover the basics of SQL language
Retrieve the SQL code of an existing query

Integrate VBA objects from Excel
Use the ADO method
Transfer data to Excel
Retrieve data from Excel

Revisions on Access
Questions / Answers
Passing the PCIE certification

Passing of the certification (if foreseen in the financing)

Sessions

Contact us for more informations about session date

Access : Advanced

Goals


- Discover programming via VBA

- Use Access VBA objects

- Integrate SQL into macros

Program

Analyze the performance of the database or of a table
Split the database
Compact and repair the database
Encrypt its database with a password

The interest of macros
Principle of operation of a macro
Concept of event
Macros on command button
Start a macro when opening the database

Condition Notions
Error Handling
User Interface
Macros Data Macros

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

See and modify the code of a macro
Language syntax
Variables
Constants
Operators
Integrating a VBA function in an Access macro

The DoCmd
object The Form 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)

Discover the basics of SQL language
Retrieve the SQL code of an existing query

Integrate VBA objects from Excel
Use the ADO method
Transfer data to Excel
Retrieve data from Excel

Revisions on Access
Questions / Answers
Passing the PCIE certification

Passing of the certification (if foreseen in the financing)

Duration

2 days

Price

£ 980

Audience

Everyone

Prerequisites

Have followed the course "Access Training : Initiation" or have equivalent knowledge

Reference

BAS1142-F

Sessions

Contact us for more informations about session date

Quark Xpress Advanced

Goals


- Discover the advanced features of Quark Xpress

Program

Creating a table
Changing cell attributes
Gridlines in a table
Merging cells
Splitting cells

Creating a text synchronization Text
desynchronization

Create the library
Store items in a library
Use a library

Create chapters
Create book
Synchronize chapters

Creating an entry
Generate the index
Style sheets and indexes

Design
Table properties

Gather information
Check visuals and fonts used
Check links
Save formats
Printing
Export as PDF

Duration

2 days

Price

£ 860

Audience

Everyone

Prerequisites

Have taken the Quark Xpress Initiation course or have equivalent knowledge

Reference

PAO360-F

Sessions

Contact us for more informations about session date

Quark Xpress Initiation + Advanced

Goals


- Discover Quark Xpress and its advanced functions

Program

The layout
The resolution
The color mode: RGB, CMYK

The working window
The tool
palette
The specification palette The ruler and markers
Creating a project
Managing shortcuts

Tools and block types
Converting a block
Grouping and locking a block
Move blocks tool
Sizing a block
Rotating a block
Text wrapping

Creating a text block
Division of a block into columns
Withdrawal of the text
Angle and inclination of the text
Vertical or horizontal
flipping Baseline position
Vertical alignment type
Bilateral text
wrapping Text block chaining

Use the default bulleted list styles
Customize the bulleted list styles
Management of the tab bar
Management of the levels of numbered outlines
Export and import to and from World of bulleted lists

Draw lines
Thicknesses and styles

Creating and applying a color
Four- color process and pantone colors
Managing gradients
Applying a tint, opacity
Béziers curve creation tools

Import compatible formats
Managing images in blocks
Image effects
Managing layers of Photoshop files
Managing blending modes and transparency of Photoshop files
Importing native Illustrator files

Creation of a page
Layout of pages
Insertion of pages
Navigation from one page to another
Notion of facing
pages Layout of pages
Move pages
Delete a page

Creation of a mockup
Visualization
Page icons and mockups Page
numbering (folio)

Creation from a selection
Creation from the edit menu
Application
Modification
Import of stylesheets

Presentation of the Shape Maker dialog box
Creation of simplified shapes
Creation of complex polygons
Presentation of the Clone dialog box
Duplication of pages from one document to another
Duplication of blocks from one document to another

Creating a table
Changing cell attributes
Gridlines in a table
Merging cells
Splitting cells

Creating a text synchronization Text
desynchronization

Create the library
Store items in a library
Use a library

Create chapters Create book Synchronize chapters

Creating an entry
Generate index
Style sheets and index
Table of contents
Design Table
properties

Gather information
Check visuals and fonts used
Check links
Save formats
Printing
Export as PDF

Duration

5 days

Price

£ 2140

Audience

Everyone

Prerequisites

No prerequisites

Reference

PAO478-F

Sessions

Contact us for more informations about session date

Inkscape Advanced

Goals


- Discover the advanced functions of Inkscape

Program

Move, copy
Contract, expand
Create dynamic
offset
Create linked offset Create symmetry
Rotate
Decompose
Transform
Align, distribute
Organize
Group, ungroup

Exploiting cloning
Creating a tiling of clones
Editing cloned objects

Workshop: creating a background illustration using a tiling of clones

Modify an object along the way
Modify a contour along the way

Unite, subtract
Create an intersection, exclude
Divide, cut
Combine, separate
Use Boolean operations adaptable

Workshop: create a complex illustration from simple shapes

Add an image to a document
Vectorize an image: paint bucket tool or vectorize the image

Workshop: create a page layout for a document including images

Use distortion
filters
Use blur filters
Use image effect filters Use texture
filters Add filters
Edit filters

Workshop: download and use new plugins

Create a cutout mask Insert an image in a text Insert an image in a shape Workshop: make an illustration with transparency and cutout mask effects Work in 3D Create a cavalier or isometric grid Define shapes in perspective Workshop: make a simple illustration of 3d objects

Export for screen display or website
Export for printing
Export for plotters, cutting, CAD / DAO software, etc.

Workshop: export your project in different formats: SVG, PDF, PNG, DXF …

Duration

2 days

Price

£ 972

Audience

Everyone

Prerequisites

Have taken the Inkscape initiation

Reference

PAO383-F

Sessions

Contact us for more informations about session date

Inkscape Initiation + Advanced

Goals


- Produce complex vector illustrations: logos, pictograms, illustrations, iconography, layout

Program

About Inkscape, open source software
History, use, features
What is « DAO »?

Integrate Inkscape into the graphic chain (GIMP-Inkscape-Scribus trilogy)

Differentiate between the types of images: bitmap and vector / capture, display and printing devices
RGB and CMYK color modes
The chromatic circle and the different representations of color

Master the main graphics formats: Inkscape’s native file formats, .svg / svgz. Other common graphic formats: PDF, EPS, PNG, etc.

Discover the interface and tools
Use the menu bar, the command bar and the snap command bar, the toolbox
Customize the workspace or the canvas
Use the default color palette
Use the toolbar status and information
Navigate the workspace

Use the selection and transformation
tool Use the shape and path creation tools
Use the Bézier curve tool
Use the node and handle editing tool
Understand the logic of nodes: hard / soft nodes, add / remove / node conversion
Modify segments: add / delete / transform

Workshop: create and manipulate simple vector paths

Create and use primitive shapes and paths
Use the object and path adjustment
tool Use the rectangles tool and squares
Use the 3D box tool
Use the ellipses / arcs and pie charts tool
Use thestars and polygons
tool Use the spiral tool
Use the pencil tool or freehand line drawing
Use the calligraphy tool

Workshop: make a simple illustration

Modify the background: colors, gradients, patterns, opacity
Modify the contours: colors, gradients, patterns, opacity
Use The default color palette
Adapt the colors according to its mode: RGB, CMYK, HSL, color wheel
Create a personalized swatch (.gpl)
Exploit swatch exchange with GIMP

Exploit color gradients
Use the gradient editor
Create and save gradients

Use the paint
bucket tool Use the eyedropper tool

Create flowcharts
Connect shapes to each other
Modify and adapt the connections
Create and use arrows for your Workshop flowcharts

:make an advanced illustration

Understand and use layers
Modify layer parameters
Organize layers: define hierarchical levels and planes
Modify blending modes
Modify opacity

Create a free text
Create a captive text: text blocks
Create a text on a path
Format the text
Define its parameters: font, styles, sizes, alignments …
Vectorize a text
Distort a text (interpolation)

Workshop: make an A4 poster document

Move, copy
Contract, expand
Create dynamic
offset
Create linked offset Create symmetry
Rotate
Decompose
Transform
Align, distribute
Organize
Group, ungroup

Exploiting cloning
Creating a tiling of clones
Editing cloned objects

Workshop: creating a background illustration using a tiling of clones

Modify an object along the way
Modify a contour along the way

Unite, subtract
Create an intersection, exclude
Divide, cut
Combine, separate
Use Boolean operations adaptable

Workshop: create a complex illustration from simple shapes

Add an image to a document
Vectorize an image: paint bucket tool or vectorize the image

Workshop: create a page layout for a document including images

Use distortion
filters
Use blur filters
Use image effect filters Use texture
filters Add filters
Edit filters

Workshop: download and use new plugins

Create a cutout mask Insert an image in a text Insert an image in a shape Workshop: make an illustration with transparency and cutout mask effects Work in 3D Create a cavalier or isometric grid Define shapes in perspective Workshop: make a simple illustration of 3d objects

Export for screen display or website
Export for printing
Export for plotters, cutting, CAD / DAO software, etc.

Workshop: export your project in different formats: SVG, PDF, PNG, DXF …

Duration

5 days

Price

£ 2140

Audience

raphic designers, illustrators, designers, architects, decorator, publishing professionals …

Prerequisites

Mastery of PC and Mac interfaces. Notions of graphics are a plus

Reference

PAO382-F

Sessions

Contact us for more informations about session date

Scribus Advanced

Goals


- Master the advanced features of Scribus 1.3.5 to design complex document models.

Program

For objects
For text

Workshop: deepening of the options for managing and manipulating vector objects

Formatting and managing tables
Importing data
Importing images

Workshop: making complex paintings

Automatic pagination
Footnotes
Scripts

Hands-on Workshop: Automating Paging, Creating and Using Scripts

Generation of the table of contents
Management of non-breaking spaces, hyphenation, etc.
Color and font management aids

Workshop: making a long document

Calibration of the graphic chain and import of ICC profiles

Settings for the different document destinations
Export to EPS and PDF formats

Workshop: in-depth study of document management and configuration options

Workshop: making a booklet ready to be printed

Duration

2 days

Price

£ 972

Audience

Everyone

Prerequisites

Have followed the « Scribus Initiation » training or have equivalent knowledge

Reference

PAO351-F

Sessions

Contact us for more informations about session date

Scribus Initiation + Advanced

Goals


- Master the tools and features of Scribus

- Design models of various documents

- Layout: manipulate texts, graphics and photos to design mock-ups of complex documents.

Program

Presentation of « Open Source » and Scribus
The layout and layout

Downloading and installing Scribus and Ghostscript
Presentation of the interface
Presentation of menus, tools and panels
Text blocks, images and objects

The two modes: bitmap and vector
Color spaces
The resolution of the images
The different formats of image files

Hands-on workshop: changing the size and resolution of an image

Creation of a new document: the different types of documents
The different parameters of the document according to its destination: printing, interactive presentation …
The structure of a document: templates and models
Import formats

Workshop: creating different types of papers

The management of the different planes
The options of the layers
The parameters of the blending modes

Workshop: management and manipulation of layers

Text import
Style sheets
Text chaining
Dressing

Workshop: creation of magazine pages, use of style sheets

Vector shapes and paths
Illustrations
Printing and exporting
Color management Exporting
to EPS and PDF formats

Workshop: management and handling of objects

For objects
For text

Workshop: deepening of the options for managing and manipulating vector objects

Formatting and managing tables
Importing data
Importing images

Workshop: making complex paintings

Automatic pagination
Footnotes
Scripts

Hands-on Workshop: Automating Paging, Creating and Using Scripts

Generation of the table of contents
Management of non-breaking spaces, hyphenation, etc.
Color and font management aids

Workshop: making a long document

Calibration of the graphic chain and import of ICC profiles

Settings for the different document destinations
Export to EPS and PDF formats

Workshop: in-depth study of document management and configuration options

Workshop: making a booklet ready to be printed

Duration

5 days

Price

£ 2140

Audience

Everyone

Prerequisites

Knowledge of the PC or Mac environment

Reference

PAO352-F

Sessions

Contact us for more informations about session date

Linux Security

Goals


- Know how to secure a server under Linux

Program

Security at the operating system level
Security at the application
level Security at the network level

Reminders on standard Unix permissions
Extensions on ext3 / 4 filesystems
Set permissions on programs (capabilities)
New technologies: SELinux and AppArmor

Authentication and the execution environment with PAM
SSL / TLS technologies
Espionage and decryption of data exchanged
The TCP-Wrapper application firewall

Theory: how does it work?
The possibilities offered
Setting up in the Linux Kernel
Checking rules with IpTable

Practical setup with netfilter / iptables
Review of the security options of the Apache web server
Review of the security options of the postfix mail server
Review of the security options of the bind nameserver
Transparency http

Setting up internal / external access
Proxy server web cache squid / squid guard
Installation, load balancing
Squidguard url filtering

The different types of tunnels
Remote access on a linux machine: ssh
VPN via GRE protocol: pptpd
VPN with IPSec

Positioning of intrusion detection
Snort review
Log management

The tools available in Open Source
Presentation of NESSUS
Architecture components
Results formats

Backup management
Response to intrusions

Duration

3 days

Price

£ 1416

Audience

Senior system administrators

Prerequisites

System and network administration

Reference

LIN40-F

Sessions

Contact us for more informations about session date

Linux cluster

Goals


- Introduce yourself to Cluster technologies available on Linux

Program

A load balancing
system A fault tolerant system (High Avaibility)
A computing cluster

Theory
Technical solutions under linux
Heartbeat / Linux Virtual Server

Why synchronize the nodes? What are the needs in terms of administration?
The capital role of NTP (Network Time Protocol) and its implementation
Centralize node logs with a Syslogd server

Principle of operation

Practical workshop : Setup

Operating principle
The different modes of LVS
– NAT
– DR
– TUN

Practical workshop : Setting up with two DR nodes
Practical workshop : Using Heartbeat

Duration

2 days

Price

£ 1634

Audience

Everyone

Prerequisites

Knowledge of advanced Linux administration

Reference

LIN39-F

Sessions

Contact us for more informations about session date

Postfix : Implementing a mail server

Goals


- Be able to implement a Postfix mail server

Program

MUA, MTA, MDA : what is it?
SMTP, POP and IMAP : what is it?

Operating principle and architecture of the service
Configuration: principles and basics
* main.cf file
* master.cf file * Postconf
and postfix commands
* Basic configuration
* Logging and error messages
* First test: mail and sendmail commands

Lab : Basic Postfix implementation

Local distribution
Mailbox format
Remote recovery: POP and IMAP protocols

Workshop : configuration of the distribution in Maildir format 

Presentation
Installation and initial configuration
Example of an IMAP session

Workshop : implementation of Dovecot

Presentation
Prerequisites: HTTP and PHP server
Installation
Service configuration

Workshop : implementation of RoundCube 

Mail alias
management Queue management
Multi-domain
hosting System accounts and virtual accounts
Storage spaces by domains

Workshop : manage aliases and configure a second email domain

Concept of spam
cases open relays
Detection and Action
* Postscreen
* Access Restrictions (immediate and delayed)
* SpamAssassin
* SPF, DKIM

Duration

3 days

Price

£ 1808

Audience

Experienced Linux administrators

Prerequisites

Mastery of the Linux environment

Reference

LIN100842-F

Sessions

Contact us for more informations about session date

Samba

Goals


- Know how to set up a Samba server

Program

SMB protocol
Origin of SaMBa
Security modes
– Stand
– alone server – Server member of an Active Directory domain
– Controller server of an Active Directory domain

Workshop : Installing samba and configuring the service

Configuration principle Global
configuration Configuration of shares
– Folders
– Printers
Concept of dynamic shares
Configuration validation
User management in stand-alone mode
Samba utilities

Workshop : Configuration of a share and its accesses

Prerequisite
– NTP synchronization
– Configuration of the Kerberos library
Configuration of Samba
Integration in the domain
User management
– AD and Winbind accounts
– PAM and NSS configuration

Workshop : Putting integration into practice in a domain

Prerequisite : NTP synchronization
Samba configuration
DNS
validation Kerberos validation
Adding a member to the domain
Installing RSAT
RSAT: Managing members and RSAT
OUs: Creating a GPO

Lab: Configuring an Active Directory controller and a member

Principle of access to an SMB share
Automatic mounting
– File / etc / fstab
– Problem of authentication

Workshop : Setting up a Samba share

Duration

2 days

Price

£ 1285

Audience

Linux administrators

Prerequisites

Knowledge of the concept of Windows sharing, that of domain controller

Reference

LIN100800-F

Sessions

Contact us for more informations about session date

Samba / LDAP

Goals


- Understanding how Samba works

- Understanding how LDAP works

- Knowing how to use them together

Program

Understand how Samba works
Understand how LDAP works
Know how to use them together

Introduction
– Directory concept
– Principle of distributed directories
– Standard LDAP
Architecture of LDAP
– LDAP models
– Information
model
– Designation model – Service
model Security model
Distributed management of LDAP directories

Installation under Debian GNU / Linux
Set up the necessary schemas
Set up a data structure.
Using ldapsearch
Setting up replication
Setting up a PAM structure
Installation in PAM
Samba / LDAP interface

Practical workshop : a PDC server

Presentation of SMB networks
Presentation of the SMB protocol
Presentation of samba
Useful samba commands
Basic configuration
User
management Access management Sharing
configuration
Sharing the printer (s)

Duration

3 days

Price

£ 1738

Audience

Everyone

Prerequisites

Linux Administration, LDAP directory concepts

Reference

LIN38-F

Sessions

Contact us for more informations about session date

OpenLDAP

Goals


- Master the implementation and administration of an OpenLDAP server

Program

Notion of directory
LDAP protocol
– Presentation
– Notion of Distinguished Name
– Notion of Classes, Attributes, Objects and Schemas
– Notion of distributed directory

Lab : Planning an LDAP directory

Connection parameters: base, scope and filters
Types of authentication
Concept and syntax of LDAP filters
LDIF format
LDAP utilities
Case of file utilities

Workshop : Querying an LDAP server

Principle of dynamic configuration
– Global Configuration
– Setting up directory
Management Access Control
Concept of Overlays
Server Maintenance
– Global Logging
– Logging access
– Import / export LDIF
– Audit

Workshop : Installation of an OpenLDAP directory 

Referral concept
Configuration of a distributed directory

Workshop : Configuration of a distributed directory

Presentation
Configuration of the master server
Configuration of the slave server

Workshop : Putting replication into practice 

Authentication server
– Presentation
– Password
management – Group management
Linux system authentication : PAM and NSS
HTTP authentication, PostgreSQL, POP, IMAP, …

Workshop : Example of HTTP / LDAP authentication

Duration

2 days

Price

£ 1285

Audience

Linux system administrators

Prerequisites

Mastery of the Linux system

Reference

LIN100799-F

Sessions

Contact us for more informations about session date

Advanced Linux : Web servers with Nginx, Apache and Tomcat

Goals


- Administer Apache, Nginx and Tomcat applications

Program

Course objectives
References and resources

Organizations: W3C and IETF
Resource naming conventions (URI, URL, URN)
http protocol versions (http v1.1, SPDY, http v2, http via quick)
Main type codes (20x, 30x, 40x, 50x)
The https protocol: TLS / SSLv3

Presentation of the main players
Operating modes
Securing web services: NIDS, WAF, DPI

Presentation of the technology
Use of « virtual hosts »
Redirection and URL Rewriting
Access controls : ACL
External management of rights and options (.htaccess)

Practical workshop : Installation and configuration of Apache. Creation of several « virtual hosts » incorporating access controls.

The context of use
Presentation of the technology
Reminders on servlets, JSP

Practical workshop : deployment of a JAVA application.

Presentation of the technology
Use of « servers blocks »
Redirection and URL Rewriting
The reverse proxy
Load balancing and failover
Presentation of naxsi

Practical workshop : Configuration of several « server blocks » by activating the reverse proxy mode to expose the Tomcat application.

Duration

3 days

Price

£ 1900

Audience

Linux system administrators

Prerequisites

Knowledge on Linux system administration

Reference

LIN100648-F

Sessions

Contact us for more informations about session date

Illustrator Initiation + Advanced

Goals


- Master the main features of Illustrator

- Know how to create and manipulate vector graphics (illustration, plans, diagrams, etc.) for DTP and the web

Program

Learn its history
Know its features
Understand its different uses

Differentiate the types of images: Bitmap and Vector
Differentiate the color modes: RGB, CMYK and Pantone colors
Use the chromatic circle and the different representations of color
Understand the main graphics formats: native Illustrator formats, AI, EPS, PDF, SVG, SVGZ, AIT

Become familiar with menu bars, options, tools, windows, interface customization
Use workspaces and customize the toolbar

Create a new document using the basic Illustrator templates
Use the predefined settings: print, web, mobile devices, video, etc.
Manage workspaces
Use rulers, rule origin, guides and commented guides
Navigate within the workspace
Add artboards
Navigate between artboards

Use simple geometric shapes: rectangles, ellipses, etc.
Discover the selection tools
Differentiate the selection and direct selection tools
Use the anchor points
Move and transform simple shapes
Use the swatch panel
Discover the options of the colors window, the general colors
Create and edit linear, radial, and freeform gradients
Use the rotate tool
Use the scale tool
Use the eyedropper tool
Manage layers

Workshop: create simple illustrations using basic shapes

Use Bézier curve tools
Discover the pen tool
Add / remove anchor points
Use the convert points tool

Workshop: create simple illustrations using the pen tool

Discover the different types of text: free text, captive, curvilinear, etc.
Discover the text modificators
Convert text into vector outlines
Use the character and paragraph styles
Create text blocks with columns
Create linked text boxes

Workshop: create different graphic effects of text, layout texts

Discover the tool settings
Differentiate the concepts of stroke and fill
Master the stroke panel and its options
Work with the lines tool and its variants
Use the width tool
Apply colors and gradients

Workshop: draw simple illustrations using brush and pencil tools

Use the shape designer tool
Discover the different reshaping and their options:
Twirl
Pucker
Bloat
Scallop
Crystallize
Wrinkle
Use the eraser, scissors and knife tools

Workshop: modify, correct and refine illustrations using reshaping modifiers

Create and tweak graphs
Import data from Excel into graphs

Use formats intended for paper printing
Use and configure formats intended for the Web

Use the different Illustrator libraries
Save symbols and graphic styles

Discover the functions of spraying, sliding, spacing, resizing, etc.
Customize the options of the tool, intensity and density

Workshop: make a complex illustration from symbols

Create gradient meshes
Modify or move the points of the mesh
Create gradients of shapes
Edit gradients of shapes via isolation

Workshop: making complex illustrations from photos

Discover the principles of patterns
Use the different mosaics
Control overlaps
Save or duplicate patterns

Workshop: making graphic patterns or materials

Manage layer transparency
Understand and use blend modes

Understand the different types of vectorization
Adjust the vectorization according to the initial document
Decompose and clean the vectorization

Workshop: vectorize complex illustrations from photos, create graphic effects

Use the perspective grid tool
Define perspective planes
Adjust perceptuality according to needs

Workshop: create a complex illustration in perspective

Create extrusions or revolutions from shapes
Control the positions
Set the extrusion or revolution options
Apply symbols on the faces
Use lighting

Workshop: create a 3D illustration

Share libraries of shapes, symbols and patterns
Share swatches with Photoshop and InDesign
Import DWG-type documents (sometimes exports in .PDF)
Prepare DWG documents or PDF exports to work in Photoshop
Import this document as dynamic objects and rework them via Photoshop
Integrate the Illustrator document into InDesign

Duration

5 days

Price

£ 1125

Audience

Everyone

Prerequisites

Knowledge of the PC or Mac environment

Reference

PAO249-F

Sessions

Contact us for more informations about session date

Illustrator Advanced

Goals


- Master the advanced features of Illustrator

- Know how to create complex illustrations

Program

Combine several shapes with Pathfinder
Use the gradient mesh tool
Repeat operations
Manage layers
Manage layer transparency and blending modes 
Create a clipping mask
Understand contour modeling
Create fill patterns

Workshop: create a first complex illustration

Vectorize sketched illustrations
Adjust the vectorization according to the initial document
Decompose and clean the vectorization
Adjust and manage options of paths
Use the live paint tool

Workshop: create a second complex illustration, live trace

Combine multiple shapes
Decompose shape and background
Use the blend tool
Copy path segments and layer
Use symbols with the symbol sprayer tool
Manage symbol sprayer options
Create symbols

Workshop: create a third complex illustration, blend tool, decomposition of shapes, masks, transparency, blending mode

Share libraries of shapes, symbols and patterns
Share swatches with Photoshop and InDesign
Import DWG-type documents (sometimes exports in .PDF)
Prepare DWG documents or PDF exports to work in Photoshop
Import this document as dynamics objects and rework them via Photoshop in Illustrator
Integrate the Photoshop document into InDesign

Workshop: work on the transversality between different Illustrator compositions, DTP software and with CAD software (AutoCad, ArchiCad, etc.)

Create, extrude and revolve 3D objects
Create lights and texture applications

Know the formats intended for paper printing
Manage trapping and overprinting
Add print marks and bleeds
Know the formats intended for the web

Duration

2 days

Price

£ 495

Audience

Everyone

Prerequisites

Have followed the « Illustrator Initiation » course or have equivalent knowledge

Reference

PAO263-F

Sessions

Contact us for more informations about session date

Advanced Linux : Enterprise server with Samba / LDAP / Netfilter / Squid

Goals


- Know how to install, configure and maintain a file / authentication / router / firewall server for a company

Program

Personal Linux and Business Linux
Presentation of practical cases

RAID and LVM technologies
Choice of file systems
Backup management: the different possible solutions

Practical workshop : setting up backups

Quota management

Practical workshop : setting up quotas

Introduction

The notion of directory
Principle of distributed directories
The LDAP standard

LDAP Architecture

LDAP models
Information
model Designation
model Service
model Security model
Distributed management of LDAP directories

Practical workshop : theoretical creation of an LDAP directory

OpenLDAP

Installation on a GNU / Linux distribution
Set up the necessary schemas
Setting up a data structure
Using Ldapsearch
Setting up replication

Practical workshop : installation and implementation of an LDAP directory

General principles
Introduction to the PAM architecture

Hands-on Workshop : Using LDAP as an Authentication Database

Presentation of the protocol
The different servers available under Linux
Setup
Why it requires LDAP or NIS

Practical workshop : setting up NFS

Introducing the SMB protocol
Introducing
Samba Useful Samba commands
Implementing a basic configuration
Managing users
Configuring shares
Sharing printers

Practical workshop : setting up Samba shares

Understand the different levels of tunnels
Protocols and their implementations
Presentation of OpenVPN

Practical workshop : setting up OpenVPN

Security at the level of the IP protocol
Operation of the Netfilter software
Configuration tools (Iptables and interfaces)

Practical workshop : Netfilter configuration

Problems answered by a cache server
Presentation of SQUID
Presentation of Dansguardian

Practical workshop : installation & configuration of Squid

Anticipate to avoid breakdowns
Good reflexes to have in the event of breakdowns
Methodology for resolving breakdowns

Duration

5 days

Price

£ 2148

Audience

Administrators

Prerequisites

Linux Administration: the basics

Reference

LIN239-F

Sessions

Contact us for more informations about session date

Advanced Linux : Web server with Apache / Bind / PHP / MySQL

Goals


- Know how to set up a dedicated hosting server with all the services to be autonomous

Program

Management of Internet domain
names Host name resolution mechanisms
Understanding the problem of DNS and its architecture
Understanding the organization of the Internet

Checking that the network is operating correctly
Accessibility of hosts, diagnostics in the event of failure
Configure the resolvers on the client side

Getting started and launching Bind
for the first time Minimal configuration file

Practical workshop : setting up Bind

Notion of domain, zone, and zone type
Format of articles (RR),
primary and secondary DNS configuration files , cache, forwarder
Security, access authorizations
Client debugging and configuration

Practical workshop : reconstitution of an « Internet » type network, with primary, secondary and root-server DNS

History
Theory of the functioning of an HTTP server
Management of MIME types
Use within the framework of PHP
Start / stop the server – modification of the configuration
Hardware requirements – processor / Memory / Hard disk
Speed ​​required (Internet)

Configuration file base
Mandatory directives
General configuration
Tests with a browser

Practical workshop : setting up Apache Advanced use

Virtual hosts (VirtualHost)
Access controls (ACL)
External management of rights and options (.htaccess)
Authentication (specific to one or more directories)
Performance consequences
Index management
Redirections
Rewriting (URL Rewriting)

Practical workshop : various exercises on each point covered

Log storage (multisite)
Management with logrotate
Log analysis : AWStats

Practical workshop : setting up AWStats

Implementation
Consequence of installing PHP on Apache 2
Classic configuration

Practical workshop : installing PHP 5

Installing, stopping and starting servers
Configuring the INI file
Activating InnoDB

Practical workshop : installing MySQL

Rights
management Network access
management Database management
Online backup (mysqldump) Offline
backup (mysql files)

Practical workshop : MyISAM table / InnoDB table, creation and use

Practical workshop : technical and practical differences

Practical workshop : PhpMyAdmin

Duration

5 days

Price

£ 2148

Audience

Linux system administrators

Prerequisites

Have followed the "Linux Administration: bases and services" training or have equivalent knowledge

Reference

LIN238-F

Sessions

Contact us for more informations about session date

Gimp Advanced

Goals


- Carry out complex work using the advanced features of The Gimp

Program

Vector paths
Tools and shapes
Define a selection from a path
Create a path from a selection

Advanced image editing
Correction layer
Use filters to enhance the image
Color replacement

Photo montage
Using layer masks
Overlay, edit layer mask, clone;
Change the perspective of an image
Mapping

Web
Image optimization
Using filters
Creating Effects

Animation
Create animations
Export animations

Export
Export settings for printing
Export settings for the web

Passing the certification (if provided for in the funding)

Duration

2 days

Price

£ 972

Audience

Everyone

Prerequisites

Knowledge of the PC or Mac environment. Have followed an initiation on The Gimp

Reference

PAO475-F

Sessions

Contact us for more informations about session date

Gimp Initiation and Advanced

Goals


- Carry out complex work using the advanced features of Gimp

Program

About Gimp, history, use, functionalities and philosophy of the Open Source P.A.O.

The different types of images: Bitmap and Vector
Capture, display, and print devices
RGB and CMYK color spaces
The chromatic circle and the different representations of color
Presentation of the main graphic document formats: native Gimp files and other common formats

Download and install GIMP
Presentation of Gimp and its environment
Change software preferences
Calibrate the workspace
Customize the workspace
Tool palette and tool parameters
Dockable windows: configure and use
The display and the magnifying glass tool
Layers and history

Create a new document
Define its parameters according to the end use
Define units
Define the resolution
Define the color depth

Open a file
Crop an image
Straighten a photo
Modify its dimensions
Change its resolution
Change the color mode

The selections
Use the rectangle and ellipse selection tools
Use freehand selection tools and Smart Scissors
Use the contiguous selection tool and the Select by color tool
Edit and modify a selection: add, delete parts of the selection
Invert a selection
Save a selection for later use

Use layers
Layer properties and settings
Edit name
Use a floating layer
Manipulate layers: modify the planes of the image
Manage opacity and rendering modes

Align, edit, and warp layers
Align and distribute layers
Distort: ​​rotate, scale, shear, change perspectives
Use the unified transformation tool

Painting tools
Use the brush: edit brushes
Using the Airbrush
Use the Eraser
Use and create brushes
Use and create patterns

Use the color selection dialog
Use the gradient tool
Define a custom gradient

Text tools
The text editor – GvD / DvG
Modify the handles of the text block
Define text attributes
Create a selection from text
Color – solid and gradient
Use a text on a path

Color retouching
Adapt levels
Make color corrections
Change brightness and contrast
Correct exposure
Correct colors
Use the color picker tool

Editing Image Elements
Eliminate dust
Eliminate unwanted elements
Add background
Use the corrector tool
Use the cloning tool

Use filters
Create a blur
Create distortions
Change rendering mode
Use depth overlay modes

Create vector paths
Create curves with the paths tool
Use primitive forms
Define a selection from a path
Create a path from a selection

Advanced image editing
Use filters to enhance the image
Replace colors

Advanced photomontage
Create an alpha channel
Create a non-destructive photomontage
Using layer masks: principle and implementation
Overlay, modify layer mask, clone
Change the perspective of an image

Web use
Optimize images for websites
Use filters
Create effects

Create animation
Create GIF animation
Export animations

Définir les paramètres d’exportation pour l’impression
Définir les paramètres d’exportation pour le Web

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

Duration

5 days

Price

£ 2140

Audience

Everyone

Prerequisites

Knowledge of the PC or Mac environment

Reference

PAO476-F

Sessions

Contact us for more informations about session date

Affinity Publisher: Initiation + Advanced

Goals


- Master the main features of Affinity Publisher

- Know how to design a model, manipulate objects, text and images, and put all these tools into production.

Program

About Affinity Publisher, history, use, features.

Image types: Bitmap and Vector / Capture, display and print devices. Colorimetric modes: RGB, CMYK and pantone colors. The chromatic circle and the different representations of color.

Presentation of the main graphic formats: Native file formats Affinity Publisher, AFPUB Other common formats: AFPHOTO, AF DESIGN, PSD, AI, EPS, SVG, PDF, TIFF, JPEG.

Upstream work, railroad and layout.

Menu bars, options, tools, panel columns

Creation of a new document
Preset / custom settings
Creation of a predefined document
The workspace:
Display of rules and grids, characteristics of rules, origins and creation of guidelines.
The different form tools
The selection tool
Attributes # 1: outline and fill colors
Color picker
Outline color and thickness
Transformation and movement of objects
Alignment and distribution of objects
Constraint keys
Creation of objects with exact dimensions
Precise selection and positioning of objects
Duplication of objects and repeated operations

Workshop: Learn to perform basic manipulations and appropriate the interface

Addition
Substraction
Intersection
Division
Combination

Workshop: Start working with vector objects

Vector drawing tools:
The node selection tool
Object modifications
Using the Bézier curve tools:
The pen tool
Add / remove anchor point
Converting hard knots to soft knots and vice versa
Opening / closing / joining of paths

Workshop: Getting to grips with bezier curves

Formats supported by Affinity Publisher
Importing an image from Affinity Publisher
Importing multiple images
The Place Image panel
Choice of images to pose on the fly
Importing vector illustrations
Adjustment properties of images relative to blocks
Adjustment properties of images in blocks
Convert a shape to an image block
Graphic effects: drop shadow, internal, external glow …
Transparency and blending modes

Workshop: Get started with image management tools, create an A3 poster

Reminder on the types of fonts:
Serif / Sans Serif
Fixed width
Character settings: font style, size, approach, kerning, line spacing …
Text blocks and options
Column texts
Chaining
Texts on paths
Formatting texts
Bulleted List
Numbered list
Inserting glyphs
Objects: text wrapping

Workshop: Formatting an interview on 2 pages

The Pages panel
Navigating between pages
Inserting Pages
Moving pages
Deleting Pages
Templates or standard pages
Creation and application of templates
Page numbering (folio)

Workshop: Setting up a document of several using different templates

Export to pdf for printing
Settings and options
Export to pdf for the web
Settings and options

Create a table
Insert columns / rows
Table formatting tools
Table and cell styles

The Image Manager panel
Image properties
Updating an image after modifying it
Differences between Linked and Embed
Importing Affinity Photo compositions
Publisher behavior with Affinity Photo compositions
Importing Affinity Designer compositions
Publisher behavior with Affinity Designer publications
Graphic effects: drop shadow, progressive contour, ect. embedded layers
Transparency and blending modes
Importing Photoshop compositions
Importing Illustrator vector illustrations
Adjustment properties of images relative to blocks
Adjustment properties of images in blocks
Convert a shape to an image block
Convert a plot to an image block
Creation of clipping mask

Workshop: Editing Affinity Photo and Affinity Designer Compositions in Affinity Publisher

Define a character style
Define a paragraph style
Working with drop caps
Working with paragraph rules
Create a dedicated character style
Nested styles
Modifications of column lengths
Column covers

Color charts by default
Create your own color chart
from document
from a document
Save your color chart for the document / for the application
Export a color chart
Import a color chart

Workshop: Creation and exports / imports of color charts

Default libraries
Library behavior
Create your own library
Remove Libraries
Remove items from libraries

Workshop: Putting all these techniques into practice on the production of a multipage document

Using paragraph styles
Creation of the table of contents
Layout and update of the table

Workshop: Create the TDM of our document, modify the content of the document, the order of the pages, update the TDM

Benchmarks and bleeds
Export to pdf for printing
Settings and options
Export to pdf for the web
Settings and options

Duration

5 days

Price

£ 1620

Audience

Everyone

Prerequisites

Knowledge of the PC or Mac environment

Reference

PAO100544-F

Sessions

Contact us for more informations about session date