Home>Initiation (Page 2)

Étiquette : Initiation

For beginners

C # Initiation : Programming as an object

Goals


- Learn to develop with C #, to create management interfaces and to manipulate objects of the .NET platform

Program

Presentation of .NET
The languages ​​of the .NET framework
Particularities of C #
Evolutions of C #, platforms supported
Development environment
Types of projects: console, library, WinForms, WPF, WCF, …
Minimum structure of a C # program 

A telier: creation of a first minimalist project

Creation of a solution / of a project: the generated files
The usual windows (solution explorer, team explorer, exit, call stack, spies …)
The debug (step by step, stack, spies, point of conditional stop …)
Version management with Git (creation of a local repository, a remote repository, basic actions – add, commit, push, pull, historization)

A telier: Manipulating the Development Environment – C # examples of programs

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

A telier: Multiple examples of applications

Operating principle
Creation of arbitrary
arrays Multidimensional arrays and traversal

A telier: Declaration and manipulation of arrays

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

A telier: Breakdown of the application

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

Workshop: Management of data entry errors, escalation of exceptions

Definition of classes
Declaration of instance / class members (static)
Constructors and instantiation
Lifecycle of an object in memory
Class diagram (UML)
Aggregation of objects (association)
Encapsulation: attributes and properties
Extension of classes (Inheritance )
Object comparison
Abstract classes
Interfaces and implementation
Polymorphism

Workshop: Modeling of problems into objects

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

Workshop: Handling of collections and flows

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

Duration

5 days

Price

£ 2475

Audience

All

Prerequisites

Programming concepts

Reference

.NE101051-F

Sessions

Contact us for more informations about session date

C # – Initiation

Goals


- Learn to develop with C #

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

Program

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

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

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

Workshop: Multiple examples of applications

Operating principle
Creation of arbitrary
arrays Multidimensional arrays and traversal

Workshop: Declaration and manipulation of tables

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

Workshop: Breakdown of the application

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

Workshop: Management of data entry errors, escalation of exceptions

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

Workshop: Manipulation of collections and flows

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

Workshop: a directory application

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

Duration

3 days

Price

£ 1625

Audience

All

Prerequisites

Programming concepts

Reference

.NE142-F

Sessions

Contact us for more informations about session date

Group of 5 people therefore quite small, which is preferable for understanding. Content conforms to the description. Training can be a little too basic for me, having already basic programming c, c ++, java, powerbuilder, ... Presentation of the course, explanation, listening to the trainer perfect.
Christophe M.
Christophe M.

C # – Initiation + Advanced

Goals


- Know how to develop in C#

- Create basic management interfaces and manipulate objects of the .NET platform

Program

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

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

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

Workshop: Multiple examples of applications

Operating principle
Creation of arbitrary
arrays Multidimensional arrays and traversal

Workshop: Declaration and manipulation of tables

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

Workshop: Breakdown of the application

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

Workshop: Management of data entry errors, escalation of exceptions

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

Workshop: Manipulation of collections and flows

Understanding Windows Forms (WinForms) Understanding
WPF Building
Windows and Communicating
Using Controls
Binding Controls with Data
Using User Controls
Using Tasks

Workshop: a directory application

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

Workshop: Implementation of several business classes

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

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

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

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

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

Duration

5 days

Price

£ 2475

Audience

All

Prerequisites

Common use of a programming language

Reference

.NE144-F

Sessions

Contact us for more informations about session date

Recent equipment and pleasant premises. The contact at reception with the trainer has always been warm. The course was brilliantly adapted for me by the trainer. He was able to provide very comprehensive content while meeting my different needs. Trainer: Perfect!
François L.
François L.
Very satisfied with the course, with its scope. Dense training for me not having the practice of object programming. Good match. The trainer responded with patience and courage to the various questions asked, while ensuring the progression and logic of the course.
Hélène F.
Hélène F.
The training took place in excellent conditions. The welcome was impeccable, the equipment impeccable. Very dense and rich C # initiation and in-depth training. Perhaps a little too much sometimes for the neophite, but very interesting. The course perfectly matches my future needs. Trainer: Mohamed has a perfect command of his subject and knows how to make his course come alive. I admire his patience and kindness in addition to his professionalism.
Christian A.
Christian A.
Very good introduction to C #. All the parts are correctly detailed with a theoretical part followed by a practical part. Clear explanations and interesting practical exercises. Trainer: Listening, adapts to everyone to progress at their own pace.
Corentin C.
Corentin C.
Impeccable conditions, reassuring environment and high performance computer. Everything is gathered for a great training! A deepening focused on my shortcomings, adapted to my needs. I come out of it much more efficient and with self-confidence regarding the various subjects discussed. Exactly what I was looking for, a powerful training in .NET with an approach that is both very professional and fun in the examples. Trainer: I hope we will meet again one day, Mohamed Derkaoui brought me a lot throughout this training. A big thanks to him. Thank you again to Mohamed for his involvement this week, I come out of the training with good skills and especially with a big smile! 🙂
Axel D.
Axel D.
Good progress in the course Good start to understand C # Trainer: Availability and re-explanation of exercises very appreciated
Monique P.
Monique P.
4 years of .NET practice previously, the training was not really adapted to my profile, I only followed it for the initiation to WPF Trainer: Very good interpersonal skills, clear explanations
Jules M.
Jules M.
Distance training difficult to judge the state of the room But the means implemented are correct for distance training. The support looks quite rich and I think it will allow me to review and deepen all of the points seen this week. The trainer being attentive the whole was of a very good level. Trainer: Nothing to say, Mr Derkaoui is an excellent technician, teacher, conscientious and respectful of his students. I warmly thank him for his patience and kindness.
Patrice R.
Patrice R.
Very intense course. Fast pace the first days then allowing to take the time to use the concepts seen the following days. Training well organized in terms of timetables and content. The program has been adjusted to suit our needs. The Trainer (Mr. Derkaoui) has perfectly adapted to our needs by remaining attentive and by using the various elements within his reach (current application, technical notes) in order to systematically propose examples related to our needs. He was able to respond with great clarity to all of our questions, sometimes in areas bordering on the framework of the training initially planned.
Simon O.
Simon O.
very good environment and good atmosphere Very didactic, speed adapted to each one, very pleasant to follow Exactly the basics which I needed Trainer: very pleasant, very competent
Mathieu M.
Mathieu M.
Précédent
Suivant

Word: Initiation + Advanced + VBA Macros

Goals


- To be able to produce a structured letter

- To know how to manage the layout of a document

- To carry out a mail merge

- To work with reference tables

- To learn about VBA language on Word

Program

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

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

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

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

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

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

Workshop: Apply a style to all of its text content

Duration

5 days

Price

£ 2495

Audience

All

Prerequisites

Knowledge of the PC environment

Reference

BUR1119-F

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

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

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

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

Workshop: Create a layout for printing a book

Insert a table (define a number of rows and columns)
Manage the table layout (add / remove cells)
Apply a style to its table
Merge or split cells

Insert and customize a picture
Embed an inline picture
Add shapes to your document
Using WordArt
Add a SmartArt
Create and customize a graphic

Workshop: Enrich your document with several illustrations

Split paragraphs into columns
Configure spaces between these columns
Display a separator line

Prepare Word to manage your templates
Use existing templates
Get a template from Office.com
Create a custom template

Insert and configure a table of contents
Update its table of contents
Insert a footnote
Add citations
Insert captions to illustrations
Add a table of illustrations
Define entries in the index
Insert the index table and put it up to date

Workshop: Integrate several reference tables into your document

Define the type of mail merge (label, envelope, letter …)
Select the source of the recipients
Match the fields between the source and Word
Filter the recipients of a mail merge
Prepare your mail
merge template Insert merge fields
Define rules
Preview the results
Finish and merge

Workshop: Prepare a standard letter for several recipients

Create a comment
Show / hide comments
Manage comments
Enable track changes
Compare two Word documents
Restrict changes

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

Workshop: Import a table and a chart from Excel

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

Objectives of a macro
Display the Developer tab in the ribbon
Record a macro
Run a macro
Run a macro via shortcuts (in ribbon, button, etc.)
Manage macros

Objectives of the VBA language
Presentation of the VBA
Using the VBA Operating
principle of the VBA

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

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

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

Introducing the form
Integrating form controls in Word
Linking a macro to a form event

Integrate Excel’s VBA objects
Drive an Excel file from Word
Import Excel data into Word

Revisions on Word
Questions / Answers
Passing the PCIE certification

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

Sessions

Contact us for more informations about session date

Word: Initiation + Advanced

Goals


- To be able to produce a structured letter

- To know how to manage the layout of a document

- To work with reference tables

- To carry out a direct mail

Program

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

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

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

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

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

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

Workshop: Apply a style to all of its text content

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

Duration

3 days

Price

£ 2495

Audience

All

Prerequisites

Knowledge of the PC environment

Reference

BUR1146-F

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

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

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

Workshop: Create a layout for printing a book

Insert a table (define a number of rows and columns)
Manage the table layout (add / remove cells)
Apply a style to its table
Merge or split cells

Insert and customize a picture
Embed an inline picture
Add shapes to your document
Using WordArt
Add a SmartArt
Create and customize a graphic

Workshop: Enrich your document with several illustrations

Split paragraphs into columns
Configure spaces between these columns
Display a separator line

Prepare Word to manage your templates
Use existing templates
Get a template from Office.com
Create a custom template

Insert and configure a table of contents
Update its table of contents
Insert a footnote
Add citations
Insert captions to illustrations
Add a table of illustrations
Define entries in the index
Insert the index table and put it up to date

Workshop: Integrate several reference tables into your document

Define the type of mail merge (label, envelope, letter …)
Select the source of the recipients
Match the fields between the source and Word
Filter the recipients of a mail merge
Prepare your mail
merge template Insert merge fields
Define rules
Preview the results
Finish and merge

Workshop: Prepare a standard letter for several recipients

Create a comment
Show / hide comments
Manage comments
Enable track changes
Compare two Word documents
Restrict changes

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

Workshop: Import a table and a chart from Excel

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

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

Sessions

Contact us for more informations about session date

Word: Initiation

Goals


- Be able to write a simple letter

- Know how to manage the layout of a document

Program

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

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

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

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

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

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

Workshop: Apply a style to all of its text content

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

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

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

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

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

Duration

1 day

Price

£ 2495

Audience

All

Prerequisites

Knowledge of the PC environment

Reference

BUR1143-F

Sessions

Contact us for more informations about session date

VBA: Initiation + Advanced

Goals


- Learn to develop an application with VBA

- Know the objects of Word and Excel

- Learn about SQL languages ​​and the ADO model


Program

Presentation of VBA
Interest of the VBA language
Design of a program
Principle of operation of a macro

Create a first macro (Sub)
Use the macro recorder
View the code of a recorded macro
Language syntax

Workshop: Practice with the macro recorder

What is an object?
The interest of objects in Office
Use the Object Explorer and Office Help

Access the cells (Range)
Access the sheets (Worksheet)
Access the workbooks (Workbook)
Access the software (Application)

Workshop: Perform operations on a workbook using Excel objects

Understand and use variables
Assign data types to variables (text, number, date, etc.)
Operators (arithmetic, comparison, logic, etc.)
Save a list of information with arrays
Create and use constants

Insert buttons in a sheet
Add shortcuts in the Office ribbon
Use event macros
Nest macros in others (Private / Public)

Presentation and interest of conditions
Conditions If
Tests Select Case
Nesting conditional tests

Workshop: Complete a table differently depending on several scenarios

Presentation and interest of loops
Perform a loop following a counter (For Next)
Adapt a loop to a condition (Do While)
Retrieve all the elements of a group (For Each)

Workshop: Creating a summary at the start of an Excel workbook

Presentation of forms
Add controls (text fields, drop-down lists, check boxes, etc.)
Customize the graphical interface of a form
Define the actions to be performed

Workshop: Create a form to automatically fill in a table

Definition and syntax of a function
Predefined functions
Create a function
Use a function as a formula in Excel

Workshop: Create a conversion function

Integration of a personalized error management
Define your error message
Resume the execution of the macro once the errors have been handled

The object system in Word
The Document
object
The Paragraph object The Selection object

Workshop: Exporting data from Excel to Word

The object system in Outlook
The mailItem
object The contactItem object

Workshop: Retrieve data from an Excel workbook and send it automatically by email

The DoCmd
object The Form object

The ADO data access model
Getting started with SQL queries
Retrieving Access records in Excel (SELECT)
Editing information in Access using Excel (INSERT, UPDATE, DELETE)

Revisions on the VBA
Questions / Answers
Passing the TOSA certification

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

Duration

5 days

Price

£ 2495

Audience

All

Prerequisites

Programming concepts – Knowledge of Excel

Reference

BUR104-F

Sessions

Contact us for more informations about session date

To take notes on it I thought VBA code was the most important to progress. We took the time to explain everything that was possible in recording. I had underestimated the possibilities in recording. Excellent approach to know how to learn on your own (ex: step by step) Trainer: excellent knowledge, does not hesitate to take the time to answer all questions (even if they are not directly related to the training) ex: excel question for a VBA
Kristell L.
Kristell L.
Very good working supervision with very welcoming trainers. Very interesting course based on practice. The training allowed me to acquire new knowledge and a certain mastery of vba in a well adapted rhythm. The trainer masters his subject very well and listens.
Sylvain A.
Sylvain A.
The trainer is interested in the purpose of the training and provides relevant advice for future applications of the methods taught.
Samir B.
Samir B.
Great trainer !!! Very kind, very clear in these explanations, take the time to help us understand !!! In Lyon, great restaurant !!!
Marion K.
Marion K.
Very friendly environment with good trainers. Very good atmosphere. Suitable premises. Trainer: Very good teacher, Friendly and dynamic. Very satisfied with these 3 days of training. Very good service in general.
Alexis G.
Alexis G.
The trainer adapted to my request, this training motivated my interest in VBA, available rigorous and conscientious, the latter has always been positive. I think I have all the keys to succeed with macros, it is now a question of applying these skills without support. I was able to benefit from an exceptional welcome both professionally and personally. I get an excellent impression of the service.
Anne marie M.
Anne marie M.
Very good conditions Very complete, in line with my expectations Fully in line with my professional needs Very pleasant week, very competent and attentive trainer.
Ludovic E.
Ludovic E.
Précédent
Suivant

VBA: Initiation

Goals


- Learn to develop an application with VBA

- Know Excel objects

Program

Presentation of VBA
Interest of the VBA language
Design of a program
Principle of operation of a macro

Create a first macro (Sub)
Use the macro recorder
View the code of a recorded macro
Language syntax

Workshop: Practice with the macro recorder

What is an object?
The interest of objects in Office
Use the Object Explorer and Office Help

Access the cells (Range)
Access the sheets (Worksheet)
Access the workbooks (Workbook)
Access the software (Application)

Workshop: Perform operations on a workbook using Excel objects

Understand and use variables
Assign data types to variables (text, number, date, etc.)
Operators (arithmetic, comparison, logic, etc.)
Save a list of information with arrays
Create and use constants

Insert buttons in a sheet
Add shortcuts in the Office ribbon
Use event macros
Nest macros in others (Private / Public)

Presentation and interest of conditions
Conditions If
Tests Select Case
Nesting conditional tests

Workshop: Complete a table differently depending on several scenarios

Presentation and interest of loops
Perform a loop following a counter (For Next)
Adapt a loop to a condition (Do While)
Retrieve all the elements of a group (For Each)

Workshop: Creating a summary at the start of an Excel workbook

Presentation of forms
Add controls (text fields, drop-down lists, check boxes, etc.)
Customize the graphical interface of a form
Define the actions to be performed

Workshop: Create a form to automatically fill in a table

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

Duration

3 days

Price

£ 2495

Audience

All

Prerequisites

Programming concepts – Knowledge of Excel

Reference

BUR402-F

Sessions

Contact us for more informations about session date

Excel : Initiation + Advanced + VBA Macros

Goals


- Know the main Excel tools

- Be able to perform calculations and use formulas

- Know how to handle graphics and pivot tables

Program

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

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

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

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

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

Workshop: Making a simple painting

Creating tables
Automatic formatting
Creating a custom style

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

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

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

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

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

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

Available display modes
Show / hide cells
Zoom
Freeze panes

Use of a referent cell ($)
Reminder on the basic formulas (SUM, AVERAGE, MAX …)
Formulas with condition (IF, NB.SI, SUM.SI …)
Date and time formulas ( TODAY, WEEKDAY …)
Text formulas (SMALL, LEFT, CONCATENATE …)
Search formulas ( VLOOKUP, HLOOKUP )

Workshop: Realization of a summary document with the main Excel formulas

Create named areas and integrate them into formulas
Find antecedents and dependents to formulas
Check formulas for errors
Change the way your workbook is calculated

Select the data to integrate into the graph
Choose a type of graph according to needs (histogram, curve, sector in 2D or 3D)
Define a quick layout for its graph
Add additional information to the graph (axis title, data labels, curve trend …)
Choose the visual aspect of your graphic via the styles

Apply table updates to associated charts
Change the chart type
Move a chart within its workbook
Customize the style of its chart
Integrate a chart into an external document (Word, PowerPoint)

Workshop: Generate a graph according to your needs

The principle of a pivot table
Define which calculation and label fields will be
Select the source of its pivot table
Place the fields to analyze
Apply a style to the pivot table

Integrate multiple calculations
Define grouping and sorting criteria
Insert segments
Integrate custom calculation fields

Workshop: Highlight the desired statistics from your table

Integrate subtotals into a table
Convert and consolidate
Data validation
Scenario analysis

Adding and modifying comments
Enable tracking of changes
Protect your workbook and sheets

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

Modifying the code of a macro
Language syntax
Variables
Operators

The Application object
The Workbook
object
The Worksheet object The Range object

Principle of conditions
Presentation of the If condition
Principle of loops
Presentation of For and Do loops

Revisions on Excel
Questions / Answers
Passing the PCIE or TOSA certification

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

Duration

5 days

Price

£ 2495

Audience

All

Prerequisites

Knowledge of the PC environment

Reference

BUR1044-F

Sessions

Contact us for more informations about session date

For my part this training allowed me to develop hundreds of knowledge that I needed professionally at first. I can only improve with practice. Trainer: Very attentive and eager to pass on his know-how and very passionate about what he does.
David A.
David A.
Course very well conducted, with good progress and which allows you to take the tool in hand. Excellent trainer who conducted his course very well, with good progress over the days. Great availability to the participants, very clear in his explanations. Thank you !
Valerie S.
Valerie S.
rewarding week, allowed me to discover Excel! I learned several things because I had never practiced. friendly and attentive trainer, masters his subject, good atmosphere.
Nicole R.
Nicole R.
The level of training was adapted to my professional needs. I will be able to reuse much of what has been seen. Very good trainer. The training was easily understood, well explained. He took the time to explain everything to us, come back to certain points if necessary. Perfect training. The course was interesting, the trainer great, very welcome.
Marine B.
Marine B.
The topics covered are very interesting. They can be used to enhance the knowledge and skills on our current profession and possibly future Trainer: Available, attentive. Transmits knowledge well, and friendly.
Ismael A.
Ismael A.
Précédent
Suivant

Agile Scrum : Understanding the fundamentals

Goals


- Learn the fundamentals of the agile Scrum method

Program

Adhere to agility

Project management: predictive vs agile
Why agility?
The agile manifesto
Overview of agile methods
Approach to adopting agility

Master the agile Scrum method

The Scrum framework / Guide
Lifecycle of a Scrum project
Roles defined by Scrum: Product Owner, Scrum Master, Team
Time boxes: Sprint planning, Sprint Review, Sprint Retrospective, Daily Scrum
Artifacts: Product Backlog, Sprint Backlog, Burndown chart
Rules and key principles of Scrum
Responsibilities / role
Choice of the size of the sprint
Constitution of the team
Weaknesses of the method

Duration

0.25 day

Price

£ 234

Audience

Anyone to be involved in a Scrum project: ScrumMaster, Product Owner, Scrum Developer, DSI

Prerequisites

Project management concepts

Reference

Mé100943-F

  

Sessions

Contact us for more informations about session date

Excel : Initiation + Advanced

Goals


- Know the main Excel tools

- Be able to perform calculations and use formulas

- Know how to handle graphics and pivot tables

Program

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

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

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

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

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

Workshop: Making a simple painting

Creating tables
Automatic formatting
Creating a custom style

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

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

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

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

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

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

Available display modes
Show / hide cells
Zoom
Freeze panes

Use of a referent cell ($)
Reminder on the basic formulas (SUM, AVERAGE, MAX …)
Formulas with condition (IF, NB.SI, SUM.SI …)
Date and time formulas ( TODAY, WEEKDAY …)
Text formulas (SMALL, LEFT, CONCATENATE …)
Search formulas ( VLOOKUP, HLOOKUP )

Workshop: Realization of a summary document with the main Excel formulas

Create named areas and integrate them into formulas
Find antecedents and dependents to formulas
Check formulas for errors
Change the way your workbook is calculated

Select the data to integrate into the graph
Choose a type of graph according to needs (histogram, curve, sector in 2D or 3D)
Define a quick layout for its graph
Add additional information to the graph (axis title, data labels, curve trend …)
Choose the visual aspect of your graphic via the styles

Apply table updates to associated charts
Change the chart type
Move a chart within its workbook
Customize the style of its chart
Integrate a chart into an external document (Word, PowerPoint)

Workshop: Generate a graph according to your needs

The principle of a pivot table
Define which calculation and label fields will be
Select the source of its pivot table
Place the fields to analyze
Apply a style to the pivot table

Integrate multiple calculations
Define grouping and sorting criteria
Insert segments
Integrate custom calculation fields

Workshop: Highlight the desired statistics from your table

Integrate subtotals into a table
Convert and consolidate
Data validation
Scenario analysis

Adding and modifying comments
Enable tracking of changes
Protect your workbook and sheets

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

Duration

4 days

Price

£ 2495

Audience

All

Prerequisites

Knowledge of the PC environment

Reference

BUR1240-F

pleasant environment. welcoming and pleasant people. Good atmosphere. All data for basic training has been shown. Very good to be able to do exercises. Needs met. Very good trainer. Complete training for basic excel training. Respect for rhythm and take care to check everyone's understanding. Training in line with my expectations.
Christine D.
Christine D.
Trainer: Professional, Competent, Friendly, Patient, Conscientious ... In short, Perfect.
Kalthoum B.
Kalthoum B.
rewarding week, allowed me to discover Excel! I learned several things because I had never practiced. friendly and attentive trainer, masters his subject, good atmosphere.
Nicole R.
Nicole R.
Précédent
Suivant

Excel: Initiation

Goals


- Know how to create a table in Excel

- Be able to configure the printing of your table

Program

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

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

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

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

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

Workshop: Making a simple painting

Creating tables
Automatic formatting
Creating a custom style

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

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

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

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

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

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

Available display modes
Show / hide cells
Zoom
Freeze panes

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

Duration

2 days

Price

£ 2495

Audience

All

Prerequisites

Knowledge of the PC environment

Reference

BUR1241-F

Sessions

Contact us for more informations about session date

Agile Scrum Initiation + Advanced

Goals


- Master the management of agile projects with the Scrum method

Program

Project management: predictive vs agile
Why agility?
The agile manifesto
Overview of agile methods
Approach to adopting agility

Lean Management: objective,
Kanban principles : principle, advantage, life cycle of a label
XP Practices (eXtreme Programming)

The Scrum framework / Guide
Lifecycle of a Scrum project
Roles defined by Scrum: Product Owner, Scrum Master, Team
Time boxes: Sprint planning, Sprint Review, Sprint Retrospective, Daily Scrum
Artifacts: Product Backlog, Sprint Backlog, Burndown chart
Rules and key principles of Scrum
Responsibilities / role
Choice of the size of the sprint
Constitution of the team
Weaknesses of the method

Workshop: analysis of the Scrum guide and passage of the Open Assessment PSM I

Product vision: definition, interest
Form of a vision: Lean Canvas
Toolbox
Complete example of Product Vision Board

Workshop: Construction and analysis of a product vision

Bring out the need
Data collection techniques
Organization of the roles of actors (RACI)
Formalize the need: IEEE vs Use Cases vs User Stories

Workshops:
– Construction of a RACI matrix to organize the roles of a project.
– conduct of a collection interview (9-box technique)
– Animation of a brainstorming workshop and construction of mind maps.

Construction of a Roadmap
From objectives to functionalities: Impact mapping
Identify and structure the functionalities: Story mapping
Deduce the roadmap from the story map
Product backlog construction process
Writing user stories: form, INVEST specification
Complements of a user stories: constraints operational, models, ..
Writing of acceptance tests (Behavior Driven Development method)
Test automation tools

Workshops:
– Construction of an impact map from the product vision.
– Construction of a story map, identification of MMFs (Minimum Marketable Features).
– Construction of the roadmap.
– Writing user stories and three amigos workshops for acceptance tests.

Estimation techniques: ideal days vs story points
Implementation of the story points method
Reliability of the estimation
Factors for prioritization of needs
Prioritization methods: Kano vs MOSCOW vs Relative weights
Prioritization by themes: themes screening / scoring
Management of risks
Grouping and final order of stories in the product backlog

Workshops:
– Poker planning game for the estimation of stories.
– Calculation of the priority with the method of relative weights.
– Redesign of the product backlog.

Roadmap and release plan
Sprint planning meeting, construction of the sprint backlog
Daily Scrum meeting
Performance indicators: Burn Down and Burn Up chart
Progress monitoring: Kanban board, Parking Lots
Team checkpoint tool: ROTI, One Word,. ..
Sprint review
Sprint review

Workshops:
– Animation of a sprint planning meeting, division of stories into tasks.
– Sprint review: actors, demonstration, validation of stories.
– The art of retrospective: speed car / boat, Turn the tables, Jeopardy
– Use of agile project management tools.

Different forms of an agile contract
Implementation of a Quality Assurance Plan (QAP)
Contracting by Sprint

Duration

3 days

Price

£ 1851

Audience

Anyone to be involved in a Scrum project: ScrumMaster, Product Owner, Scrum Developer, DSI

Prerequisites

Project management concepts

Reference

Mé100283-F

  

Sessions

Contact us for more informations about session date

Kotlin Android : Initiation

Goals


- Discover the functionalities of the Android platform for smartphones and tablets

- Create simple applications with Android, with a complete UI

Program

Presentation of the Android platform Android
model and its architecture
Other market players

Development environment
Structure of an Android project: cutting, libraries
Activities: presentation
Life cycle of an application
Packaging, signature and deployment; presentation of the publication on Google Play
Presentation of the emulator

Practical workshop: installation of the environment: Android Studio / Android SDK, creation of a first application and management of the emulator

Communication with the hardware or the emulator by ADB with ADT
Debug windows; memory, threads, logcat
Add debug information
The toasts

Practical workshop: start of the application

Activity and other contexts
Declaration of Intents and resolution
Application configuration (AndroidManifest.xml)
Communication between activities: parameters, result
Activities in their task, ordering and reordering
Exit an Android application?

Practical workshop: sequence of activities and their communication

Code organization (Kotlin / XML)
Textual resources,
Panorama internationalization of different Android components: buttons, text, etc.
Event and order management

Practical workshop: construction of several user interfaces and event management

Units of measurement, adaptations to phone screens
Available layouts
Styles and themes
Various theme limits

Practical workshop: precise design of existing windows

Duration

3 days

Price

£ 2120

Audience

All

Prerequisites

Mastery of the Kotlin language, notions of XML

Reference

DEV100525-F

Sessions

Contact us for more informations about session date

Agile Scrum: Initiation

Goals


- Discover the management of agile projects with the Scrum method

Program

Adhere to agility

Project management: predictive vs agile
Why agility?
Agility adoption process
The agile manifesto
Overview of agile methods

Learn agile practices

Lean Management: objective,
Kanban principles : principle, advantage, life cycle of a label
XP Practices (eXtreme Programming)

Master the agile Scrum method

The Scrum framework / Guide
Lifecycle of a Scrum project
Roles defined by Scrum: Product Owner, Scrum Master, Team
Time boxes: Sprint planning, Sprint Review, Sprint Retrospective, Daily Scrum
Artifacts: Product Backlog, Sprint Backlog, Burndown chart
Rules and key principles of Scrum
Responsibilities / role
Choice of the size of the sprint
Constitution of the team
Weaknesses of the method

Workshops:
– Analysis of the Scrum guide and passage of the Open Assessment PSM I
– Estimation of stories (load, complexity) and planning poker
– Retrospective animation: Speed ​​boat, Turn the tables, …

Duration

1 day

Price

£ 745

Audience

Anyone to be involved in a Scrum project: ScrumMaster, Product Owner, Scrum Developer, DSI

Prerequisites

Project management concepts

Reference

Mé100281-F

  

Sessions

Contact us for more informations about session date

Kotlin Android : Initiation + Advanced

Goals


- Discover the features of the Android platform for smartphones and tablets

- Create applications with Android

Program

Presentation of the Android platform Android
model and its architecture
Other market players

Development environment
Structure of an Android project: cutting, libraries
Activities: presentation
Life cycle of an application
Packaging, signature and deployment; presentation of the publication on Google Play
Presentation of the emulator

Practical workshop: installation of the environment: Android Studio / Android SDK, creation of a first application and management of the emulator

Communication with the hardware or the emulator by ADB with ADT
Debug windows; memory, threads, logcat
Add debug information
The toasts

Practical workshop: start of the application

Activity and other contexts
Declaration of Intents and resolution
Application configuration (AndroidManifest.xml)
Communication between activities: parameters, result
Activities in their task, ordering and reordering
Exit an Android application?

Practical workshop: sequence of activities and their communication

Code organization (Kotlin / XML)
Textual resources,
Panorama internationalization of different Android components: buttons, text, etc.
Event and order management

Practical workshop: construction of several user interfaces and event management

Units of measurement, adaptations to phone screens
Available layouts
Styles and themes
Various theme limits

Practical workshop: precise design of existing windows

Organization of a menu
Activity menu and
Action bars contextual menu to replace the
option Backup and recovery menus in preferences
Sharing preferences

Practical workshop: a functional menu

Files: SDCard, internal, shared or reserved
Creation and access to files
Use of the embedded SQLite database
Handling of web services: presentation of XML
Handling of web services: use of JSON / REST
Management of shared data (ContentProvider)

Practical workshop: multiple storage, and checks in the DDMS

Duration

5 days

Price

£ 2976

Audience

Kotlin Developers

Prerequisites

Mastery of the Kotlin language, notions of XML

Reference

DEV100524-F

Sessions

Contact us for more informations about session date

IIS Initiation + Advanced

Goals


- Learn how to install and configure IIS

Program

Presentation and history
Installation of the Web server
Configuration of functionalities

Overview
Creating a Website
Creating an Application Pool
Maintaining an Application Pool
Configuring Application
Settings
Configuring ASP.NET Security Configuring Native and Managed Modules

Configuring remote
administration
Configuring delegated administration Configuring feature delegation
Tools for performing command-line administration tasks
Running scripts for administration
tasks Managing web server administration tasks

Configuring secure servers and websites
Configuring other aspects of web server security
Configuring logging

Duration

2 days

Price

£ 980

Audience

Everyone

Prerequisites

Knowledge of Windows Server administration

Reference

WIN228-F

Reminder: the security of a server on the internet and web applications. Typical attacks
Encryption of data flows via SSL
Installation of client-side and server-side SSL certificates
Configure and troubleshoot access permissions and authentication
Security of hosted applications. The exhibition area
Reduce risk thanks to the modularity of IIS 7.0

Configuring the FTP service
Managing users, groups and permissions
Configuring the SMTP service
Manage the security of the SMTP server. Relaying

Best practices for improving performance
Configuring options to improve performance
Optimizing application pools
Backing up and restoring websites
Using shared configurations
Configuring network load balancing

Using logs for troubleshooting
Authentication and authorization
issues Configuration issues

Sessions

Contact us for more informations about session date

IIS Initiation

Goals


- Learn how to install and configure IIS

Program

Presentation and history
Installation of the Web server
Configuration of functionalities

Overview
Creating a Website
Creating an Application Pool
Maintaining an Application Pool
Configuring Application
Settings
Configuring ASP.NET Security Configuring Native and Managed Modules

Configuring remote
administration
Configuring delegated administration Configuring feature delegation
Tools for performing command-line administration tasks
Running scripts for administration
tasks Managing web server administration tasks

Configuring secure servers and websites
Configuring other aspects of web server security
Configuring logging

Duration

2 days

Price

£ 980

Audience

Everyone

Prerequisites

Knowledge of Windows Server administration

Reference

WIN228-F

Android : Initiation

Goals


- Discover the functionalities of the Android platform for smartphones and tablets

- Create simple applications with Android, with a complete UI

Program

Presentation of the Android platform Android
model and its architecture
Other market players

Development environment
Structure of an Android project: cutting, libraries
Activities: presentation
Life cycle of an application
Packaging, signature and deployment; presentation of the publication on Google Play
Presentation of the emulator

Practical workshop: installation of the environment: Android Studio / Android SDK, creation of a first application and management of the emulator

Communication with the hardware or the emulator by ADB with ADT
Debug windows; memory, threads, logcat
Add debug information
The toasts

Practical workshop: start of the application

Activity and other contexts
Declaration of Intents and resolution
Application configuration (AndroidManifest.xml)
Communication between activities: parameters, result
Activities in their task, ordering and reordering
Exit an Android application?

Practical workshop: sequence of activities and their communication

Code organization (java / XML)
Textual resources,
Panorama internationalization of different Android components: buttons, text, etc.
Event and order management

Practical workshop: construction of several user interfaces and event management

Units of measurement, adaptations to phone screens
Available layouts
Styles and themes
Various theme limits

Practical workshop: precise design of existing windows

Download PDF

Duration

3 days

Price

£ 1708

Audience

All

Prerequisites

Mastery of java language, notions of XML

Reference

DEV483-F

Sessions

From 06/04/2021 to 08/04/2021 (example)

Dates ?

Dates ?

Machines are made available to the trainee which avoids wasting time configuring his environment (especially having a Linux environment is recommended for android development) Progress occurs naturally as and when the environment is enriched. 'android application developed by the trainees At the end of the training, good understanding of the concepts Good distribution between practice and theory The friendly trainer who adapts to the trainees' expectations with regard to the training I come away very satisfied with this training
Fleurine A.
Fleurine A.
Sustained pace and allowing to address the points announced. The trainer does not leave us stuck on a point of detail and moves his subject forward. Trainer: Very good mastery of his subject, corrects our mistakes and answers our questions without any hesitation: perfect. Very happy to discover DAWAN with this first training which is very well conducted.
Yann H.
Yann H.
Sustained pace and allowing to address the points announced. The trainer does not leave us stuck on a point of detail and moves his subject forward. Trainer: Very good mastery of his subject, corrects our mistakes and answers our questions without any hesitation: perfect. Very happy to discover DAWAN with this first training which is very well conducted.
Yann H.
Yann H.
Content adapted to your needs
Cyril D.
Cyril D.
Very educational Trainer: Good knowledge and professional
Alexandre F.
Alexandre F.
Very good trainer, very pedagogue
Volkan K.
Volkan K.
just a problem with the laptop the 1st day still excellent Not having all the prerequisites, the training was fairly fast but very rich Trainer: Perfect
Yann D.
Yann D.
Précédent
Suivant

Android : Initiation + Advanced

Goals


- Discover the features of the Android platform for smartphones and tablets

- Create applications with Android

Program

Presentation of the Android platform Android
model and its architecture
Other market players

Development environment
Structure of an Android project: cutting, libraries
Activities: presentation
Life cycle of an application
Packaging, signature and deployment; presentation of the publication on Google Play
Presentation of the emulator

Practical workshop: installation of the environment: Android Studio / Android SDK, creation of a first application and management of the emulator

Communication with the hardware or the emulator by ADB with ADT
Debug windows; memory, threads, logcat
Add debug information
The toasts

Practical workshop: start of the application

Activity and other contexts
Declaration of Intents and resolution
Application configuration (AndroidManifest.xml)
Communication between activities: parameters, result
Activities in their task, ordering and reordering
Exit an Android application?

Practical workshop: sequence of activities and their communication

Code organization (java / XML)
Textual resources,
Panorama internationalization of different Android components: buttons, text, etc.
Event and order management

Practical workshop: construction of several user interfaces and event management

Units of measurement, adaptations to phone screens
Available layouts
Styles and themes
Various theme limits

Practical workshop: precise design of existing windows

Organization of a menu
Activity menu and
Action bars contextual menu to replace the
option Backup and recovery menus in preferences
Sharing preferences

Practical workshop: a functional menu

Files: SDCard, internal, shared or reserved
Creation and access to files
Use of the embedded SQLite database
Handling of web services: presentation of XML
Handling of web services: use of JSON / REST
Management of shared data (ContentProvider)

Practical workshop: multiple storage, and checks in the DDMS

Duration

5 days

Price

£ 2565

Audience

Java developers

Prerequisites

Mastery of java language, notions of XML

Reference

DEV489-F

Sessions

Contact us for more informations about session date

Creation of the working environment and writing of the code at the same time as the trainer allows to understand and assimilate the concepts Excellent overview to help me in the management / understanding of an Android project
Vanessa L.
Vanessa L.
Machines are made available to the trainee which avoids wasting time configuring his environment (especially having a Linux environment is recommended for android development) Progress occurs naturally as and when the environment is enriched. 'android application developed by the trainees At the end of the training, good understanding of the concepts Good distribution between practice and theory The friendly trainer who adapts to the trainees' expectations with regard to the training I come away very satisfied with this training
Fleurine A.
Fleurine A.
Very good general presentation of Android application development. The training allows you to start the development of an application by adopting the right habits. Very satisfied. The trainer met our expectations by presenting the fundamentals of Android application development to us, then by going into more technical subjects related to our professional activities. We appreciated the effort to condense all our requests and meet our expectations over 5 days of training.
Guillaume A.
Guillaume A.
Convenient and welcoming city center location (restaurant, etc.) Start-up of a real prototype at the end of training. This made it possible to consolidate the training and to start this prototype in the best conditions. Trainer: Nothing to say, it was perfect.
Philippe M.
Philippe M.
Convenient and welcoming city center location (restaurant, etc.) Start-up of a real prototype at the end of training. This made it possible to consolidate the training and to start this prototype in the best conditions. Trainer: Nothing to say, it was perfect.
Philippe M.
Philippe M.
Sustained pace and allowing to address the points announced. The trainer does not leave us stuck on a point of detail and moves his subject forward. Trainer: Very good mastery of his subject, corrects our mistakes and answers our questions without any hesitation: perfect. Very happy to discover DAWAN with this first training which is very well conducted.
Yann H.
Yann H.
Room a bit small but it was not really a problem. The material provided was very good. Thank you for organizing the lunch, I was very happy not to have to worry about this and the meals were also very adequate. Good introduction to the subject. It's better than I expected. Trainer: Mohamed knows how to set a steady pace in training while keeping a flow of words adapted to the time needed for everyone to understand. I was reassured by his technical mastery. I was able to tackle a lot of concepts in a short time and I am delighted. Thank you for this training. I recommend her and your organization.
Frederic M.
Frederic M.
+++ Perfectly adapted machines, stable and functional environment +++ Use of the last tool released: Android Studio (and not Eclipse) +++ Use of VNC (or equivalent) for corrections and help for trainees --- Small non air-conditioned room. Patient trainer, attentive, and who masters his subject perfectly. No complaints. Very pleasant training. Thanks to the trainer for his patience.
Tahsin I.
Tahsin I.
very good course which allowed us to see a set of fundamental concepts the course material was not used, to see if it is useful and in relation to the notes that I took corresponding very well to what I expected, this will allow me to independently develop an excellent trainer who has a very good knowledge of java / android development. pleasant, attentive and accessible. a real pleasure to have followed this training during these 5 days. too bad there is an end!
Christophe L.
Christophe L.
Having already developed an application, I knew a few points discussed during the initiation but reviewing them allowed me to understand their uses. The advanced training should also be useful for my professional needs. I would come back ... A very attentive and very pedagogical trainer.
Pauline M.
Pauline M.
Good training for a first approach on Android programming and roughing up the concepts. But there is still some work to be done on your own on advanced concepts. Trainer: Very good. It is appreciable that midday meals are included in the training and taken together with the trainer.
Stephane C.
Stephane C.
It was home \ o / It was complex because there were two kinds of need, on a personal level, less ihm and more service would have been fine for me but part of the public had to be more interested in ihm ... Trainer: Very available and competent.
Yves-gaël C.
Yves-gaël C.
Good training for a first approach on Android programming and roughing up the concepts. But there is still some work to be done on your own on advanced concepts. Trainer: Very good. It is appreciable that midday meals are included in the training and taken together with the trainer.
Stephane C.
Stephane C.
Précédent
Suivant

SolidWorks Initiation

Goals


- Discover the software

- Create volumes and assemblies

- Manage configurations

Program

Introduction to the SolidWorks Interface
Menu Bar
Command Manager
Design Tree FeatureManager
PropertyManager Heads-up
Display Toolbar
Task Pane
Mouse Functionality Keyboard
Shortcuts
Display Pane
Customizing the SolidWorks Interface

Techniques for creating sketches
Presentation of sketching tools (line, rectangles, fillet …)
Methodology for creating sketch entities
Feedback from the sketch Sketch
relationships
The different states of a sketch
Selecting objects in a sketch
Dimensioning methodology for a sketch
Creating an Extrusion feature
Editing a sketch, editing a feature, and editing a sketch plane
Application exercises

Analysis of the geometry of the modeled part
Choice of best first outline
Choosing the appropriate sketch plane
design intend analysis
extruding Service Option
Use of a flat face as the sketch plane
Function removing material
Using the drilling assistance function
Display options
Using the fillet function
Saving the part
Creating the
drawing 3 Drawing views
The different dimensioning techniques
Handling dimensions
Associativity between the 3D model and the drawing
Application exercises

The Benefits of Patterns
The Different Types of Patterns Available in SolidWorks
Linear
Pattern Circular
Pattern Sketch-
Driven
Repetition Table- Driven
Repetition Curve-Driven Pattern Repetition in Zone
Feature Symmetry and Solid Body Symmetry Repeat
Options Practice
Exercises

Analysis of the geometry of the part to be modeled Revolve
function
Notion of multibody volumes
Sweep function
Applying a material
Mass
properties File properties
SolidWorks Simulation Express (pre-sizing of parts)
Application exercises

Analysis of the geometry of the part to be treated
Presentation of the shell function
Analysis and addition of draft functions
Presentation of the ribs function and its options
Use of fillets with removal of faces
Thin functions
Application exercises

Message Analysis
Error Correction Methodology
Sketch Problem
Analysis , Feature Problem Analysis
Correction of Sketch
Plane Problems
Using the FeatureXpert Function Using the FilletXpert Option
Using the DraftXpert Option Application
Exercises

Analysis of the design intent of the part to be achieved
Design modification methodology
Use of Instant 3D technology to make modifications
Application exercises

Configurations
Working with Configurations
Creating Configurations
Link Values
Equations
Configure Dimension / Feature
Modeling Strategies for Configurations
Editing Parts with Configurations
Design Library

Learn more about creating drawings Section
view
Model views Broken
view
Detail views Drawing
sheets and background
drawings Projected views
Annotations

Bottom-up assembly
Creating a new assembly
Position of the first component
FeatureManager design tree and signage
Adding components
Using part configurations in
assemblies
Subassemblies Smart constraints
Inserting subassemblies
Takeout composition

Use of assemblies
assembling Analysis
Verification games
Changing odds values
assemblies exploded
sketch with bursting lines
Nomenclature
Featured assembly plane

Duration

5 days

Price

£ 2123

Audience

Draftsmen – Engineers

Prerequisites

CAD basics

Reference

CAO909-F

Sessions

Contact us for more informations about session date

Powershell Initiation + Advanced

Goals


- Implement Powershell to automate operations on Windows Server and Active Directory

Program

Install PowerShell
Object overview
Working with the
Completion, Alias, and History cmdlets
Variables and types
Present information with specific formatting

Use the arrows and the history
Use the « pipe »
Sequential execution of the commands
Filter and iteration through the « pipe »

Writing PowerShell scripts
Security in Windows PowerShell
Digitally signing these scripts Scripting
methodologies
Presentation of scripting tools

Variables, arrays, literals and operators
Scope of variables
Constructions used in scripts
Interception and handling of errors
Debugging techniques
Modularization

The if statement
The switch
statement The Where-Object statement

The for loop
The while and do loops … while and do … until
The foreach loop

Control the flow of execution in scripts
Control the flow of loops
Develop and use functions
Advanced functions: validation block, documentation, parameter sets, pipeline management

The concept of system and user
profiles Create generic profiles
Target profiles by application

Manage data with Powershell
Manage registry and certificates with Powershell
Filter and select with regular expressions
Manage event logs
Import and export objects

Duration

5 days

Price

£ 2599

Audience

Administrators, Developers

Prerequisites

Basic knowledge of Windows Server administration

Reference

WIN525-F

Presentation of the available PowerShell modules
RSAT Server Manager Cmdlets
Install modules from the Powershell Gallery

Workshop: Using PSWindowsUpdate, Carbon, NTFSSecurity, PSExcel

Examination of a sample script
replay scripts
Refactoring code and adding features

The global options of the Warning, Error and WhatIf commands
The redirects of the error
output
The exit codes The debugging and spying of variables in IDEs and with Powershell
The throw and exit commands
The try catch finally directives

Principles of use
The main useful classes

Workshop: Using the Math and FileIO classes

Presentation of techniques: WinForm or WPF
Create forms
Manage events and associated actions

Workshop: Creation of a group interface for creating accounts

Introduction to WMI objects
Protocol and cmdlets: WMI or CIM
Use for monitoring: WMI and performance counter
Use for remote administration

Administering domains and forests
Managing user accounts and groups
Managing relationships between users and groups

Workshop: Importing automated accounts

Passing of the certification (if foreseen in the financing)

Sessions

Contact us for more informations about session date

Good progress of the course or we start from the base to more developed scripts. Good adaptation of the examples to the profile of the participants. Very competent trainer, mastering his subject well and listening to participants.
Alban G.
Alban G.
Very good. Enriched by the trainer's experience! Beyond my expectations. Great ! Trainer: Great skill and good humor !!
Eric K.
Eric K.
Very good pedagogy of the trainer.
Stephane T.
Stephane T.
Corresponded perfectly to my expectations and to my professional needs Trainer: Excellent exchange; Total mastery. To date the best training I have received Microsoft orsys m2i globalknowledge... Were well below the training I have just followed
Loïc R.
Loïc R.
The trainer is very patient in view of my technical level.
Sabine L.
Sabine L.
Précédent
Suivant

Powershell Initiation

Goals


- Implement Powershell to automate operations on Windows Server and Active Directory

Program

Install PowerShell
Object overview
Working with the
Completion, Alias, and History cmdlets
Variables and types
Present information with specific formatting

Use the arrows and the history
Use the « pipe »
Sequential execution of the commands
Filter and iteration through the « pipe »

Writing PowerShell scripts
Security in Windows PowerShell
Digitally signing these scripts Scripting
methodologies
Presentation of scripting tools

Variables, arrays, literals and operators
Scope of variables
Constructions used in scripts
Interception and handling of errors
Debugging techniques
Modularization

The if statement
The switch
statement The Where-Object statement

The for loop
The while and do loops … while and do … until
The foreach loop

Control the flow of execution in scripts
Control the flow of loops
Develop and use functions
Advanced functions: validation block, documentation, parameter sets, pipeline management

The concept of system and user
profiles Create generic profiles
Target profiles by application

Manage data with Powershell
Manage registry and certificates with Powershell
Filter and select with regular expressions
Manage event logs
Import and export objects

Passing of the certification (if foreseen in the financing)

Duration

3 days

Price

£ 1634

Audience

Administrators, Developers

Prerequisites

Basic knowledge of Windows Server administration

Reference

WIN348-F

Sessions

Contact us for more informations about session date

AutoCAD 2D LT Initiation (ACN Atlas)

Goals


- Create or modify a 2D drawing, mechanical or architectural, by developing a drawing strategy according to the tools made available by AutoCAD

- Adapt these jobs to export them as a file or to a plotter

- Customize, automate and optimize production tools in AutoCAD

Program

ACN Autocad Atlas eligible training course Contact us

About AutoCAD MAP 3D
History
Usage
Features

Presentation of CAD
Presentation of work logic in AutoCAD
Collaborative work logic
The native file format of AutoCAD: .DWG
The template file format: .DWT
The format of exchange file: .DXF
The standard file format: .DWS
Commonly used formats for logos PNG, JPEG, etc.
Export format: PDF and its peculiarities

The workspace
The menu bar
The ribbon
The graphics area
The importance of hardware acceleration
The command window
Presentation of the drawing assistance tools
Configuration of units and standards
General options and user preferences
Customization of the interface
Recording of the user interface

Creation of a new document
Definition of the workspace limits
Navigation in the work plane
Selection modes (green, blue, select similar, quick selection)
Grid adjustment and display
Resolve mode: grid magnetism
Tracking: orthogonal / polar / object
Object snaps: endpoint, midpoint, intersection, extension, etc.
Selection cycle

Workshop: understand, configure and save the user interface

The origin
The abscissa and the ordinate
Absolute Cartesian coordinates
Relative Cartesian coordinates
Relative / polar Cartesian coordinates
Dynamic input
Line and polyline
Rectangle
Arc
Circle
Ellipse
Polygon
Xline and ray
Ring
Properties panel and objects characteristics
Measuring tools: length, angle, radius, etc.

Workshops: each drawing tool is subject to manipulations and observations of the options offered

Move
Copy
Offset
Symmetry
Rotation
Align
Stretch
Scale
Fit / Extend
Decompose / Join

The modification workshops above correspond to the production of small architectural elements or mechanical parts

Presentation of the layer panel
Layer attributes: color, type and line thickness
Activate, freeze, draw the layers
Definition of the current layer
Activate / deactivate the line weights and transparency of the layers in model space
Change a layer object
Property copy tool

General information on the text and annotation tool
Formatting of characters
Formatting of current paragraphs, bulleted and numbered lists, column options
Text styles
Creation and modification of text styles
Insertion of symbols and fields
General information on the associative sizing tools
Quick sizing tool 
Continuous sizing
Basic line sizing
Adjusting spaces
Formatting dimensions
Creation and modification of sizing styles for different scales

General information on the hatching tool
Outlines and hatching
Different types of fill: pattern, gradient and solid
Modifying the scale and orientation of the hatching
Adding / removing areas
Recovering the hatch surface

Workshop: each drawing tool is subject to manipulations and observations of the options offered

General information on the .dwt template file
Creation of a .dwt template file and best practices
Creation of a new drawing from the template
Example of updates to a template

Workshop: create a drawing template and realize several drawings with dimensions, hatching and annotations

Creation of a title block with attribute definitions (static block)
Model space / paper space
Layout configuration
Choice of plotter type and configuration
Creation of a rectangular or polygonal presentation window
Scale of the presentation window
Creation of custom scales
Insertion of the title block

Workshop: layout and export presentations in PDF

Principle of the use of networks
Presentation of the different types of networks
Copy with networking
Network tools prior to 2013: classical, rectangular and polar networks
Associative networks: polar, rectangular, along of a path
Modification of columns and rows
Modification of the source element
Decomposition of an associative network

Workshop: produce 4 drawings using these different networks / putting into perspective with concrete cases with sprinklers, lights, etc.

General information on blocks
Dynamic blocks / parametric blocks
Creation of blocks: choice of objects, insertion point, description, etc.
Modification of blocks
Insertion of blocks
Dynamic blocks with options for rotation, stretching, scale, etc.
Dynamic blocks with visibility / consultation options
The different types of attributes
Definition of attributes
Insertion of fields
Modification and properties of attributes
Presentation of the Design Center
Navigation in: folders, open drawings, history
Tree structure of a DWG
Use of blocks, styles, presentations, etc. from one drawing to another
Understanding custom palettes
Creation and use of a custom palette

Workshop: create the recurring elements of a house: doors, double doors, windows, etc.

Principle of external references
Xref management panel
File information
Attach work / status files
Path requirements
Modification of one of the files / status and update
Adjust the visible area of ​​files / delete it
Good and bad practices with respect to Xrefs
General coordinate system and user coordinate system
Position a user coordinate system according to the Xref
Creation of views in a large project and use of UCS

Workshop: create views using GCS or UCS in a large project

Object space and presentation space
Presentation ribbon
Document configuration
Presentation configuration
Use of views in presentations
Creation of a title block with variable and constant attribute definitions
Reminders on plotting options
Exports in files
Plotter prints

Workshop: layout of the plans made in the previous steps with title blocks

Duration

5 days

Price

£ 1595

Audience

Manufacturing technicians, designers, planners, engineers, design office managers

Prerequisites

Mastery of the PC environment
Basic knowledge of technical drawing

Reference

CAO100758-F

Sessions

Contact us for more informations about session date

AutoCAD 3D Initiation

Goals


- Perform 3D work from 2D work and renderings

Program

History
Different uses and functionalities

Use the main Autocad formats: .DWG / .DWT, DXF, DWS, PNG and PDF

Use the menu bar
Use the ribbon
Work in the graphics area
Use the command line

Create a new document
Use the workspace
Define the limits of the work plane
Configure the units
Know the difference between the different selection modes
Adjust the grid
Use the resol mode: grid magnetism
Use the coordinate systems: orthogonal, polar, object
Use object snaps

Zoom in / out
Use the pan
Use the orbit, free and continuous orbit
Master the 3D compass
Use the navigation disc
Use the predefined views

2D wireframe
Conceptual
Hidden
Realistic
Shaded
Shaded with edges
Grayscale
Sketches
Wireframe
X-rays

Use the rectangle tool
Use the ellipse tool
Use the lines tool
Use the polyline tool
Master the 2D object snaps
Master the general coordinate system
Master the user coordinate system
Define a new UCS: 3-point UCS, Z-axis UCS

Use the rectangle
Use the ellipse
Use the arc
Use the polygon
Master the offset tool
Master the copy tool
Master the rotation tool
Master the 2D object snap

Master the dynamic user coordinate system
Use polyline
Use offset
Use copy
Master 2D object snap

Use the line tool
Use the 3D polylines tool
Use the spline tool
Use the helix tool

Use the rectangle tool
Use the ellipse tool
Use the offset tool
Use the copy tool
Use the rotation tool
Control the 2D object snap
Move in 3D
Use 3D rotation
Scale

Presentation of the Gizmo: move / rotate / scale 3D
Position the Gizmo
Select modification axes
Select modification planes

Workshop: build a 3D element with rudimentary forms

Move, move in 3D
Rotate, rotate in 3D
Copy
Offset
Mirror
Align
Stretch
Master rectangular array
Master polar array
Master array along a path
Control the peculiarities of associative arrays in 3D

Workshop: design a simple building with existing forms

Use 3D primitives
Use the box
Use the cylinder
Use the cone
Use the sphere
Use the pyramid
Use the wedge
Use the torus
Master the solids

Unite
Subtract
Intersect

Workshop: make an architect’s desk and lamp

Press or pull
Section
Thicken
Make an indentation
Make an imprint
Extract edges
Create a shell
Create fillet edges
Create chamfer edges
Extrude faces
Offset faces

Workshop: design mechanical parts from 2D drawings

Add 3D in 2D drawings
Master the nuances between solids and surfaces
Create regions
Manage the different types of extrusions
Make a revolution of a path
Master the different types of path sweeps 
Smooth paths
Control the associative properties of surfaces
Manage surface types :
Smoothing with cuts only
Nurbs
Use handles

Workshop: make a straight staircase and a spiral staircase

Manage basic configuration
Choose a predefined rendering quality
Use the resolution
Use the exposure
Use the environment
Control the rendering window: information, menu

Workshop:  produce renderings from previously created volumes

Duration

5 days

Price

£ 2215

Audience

Everyone

Prerequisites

Master AutoCad

Reference

CAO384-F

Sessions

Contact us for more informations about session date

qualified trainer and very attentive to people. responds in simple language to make themselves understood which facilitates learning.
Thibaut M.
Thibaut M.
Very good trainer. Listening to our problems.
Sébastien M.
Sébastien M.
Very welcoming team, very attentive trainer Very complete training, course adapted to the level of the participants Very educational trainer, and patient Excellent week of training
Muriel R.
Muriel R.
small group of 3 people allowing the trainer to be more available. sustained pace because many elements to address. A bit of trouble to all assimilate for my part, but still satisfied. Trainer: very friendly, pedagogue and available
David T.
David T.
good trainer, serious, patient and attentive to our expectations
Jean-marie O.
Jean-marie O.
Précédent
Suivant

JasperReports Initiation

Goals


- Be able to create, modify, produce reports from any data thanks to JasperReports and Studio

Program

The report generation
tools Various tools from JasperSoft
Similar alternatives, comparison
Limits and additional possibilities

Presentation of the
Comparison tool with iRports
Setting up test data
Creating a report
Complete export process
Formatting complex data

Workshop: some representative states

Duration

1 day

Price

£ 1675

Audience

All

Prerequisites

No

Reference

JAV218-F

Sessions

Contact us for more informations about session date

JasperReports Initiation + Advanced

Goals


- To be able to create, modify, produce complex reports from any data thanks to JasperReports, from a Java application or thanks to Studio

Program

The report generation
tools Various tools from JasperSoft
Similar alternatives, comparison
Limits and additional possibilities

Presentation of the
Comparison tool with iRports
Setting up test data
Creating a report
Complete export process
Formatting complex data

Workshop: some representative states

Presentation of working methods with JasperReports
Principles and possibilities without / with iReport
Reminders of XML and Java

Presentation of the distribution
Setting up a complete environment for JasperReports
Data and test status: presentation, positioning

Workshop: carrying out a first report from a Java console application

The reporting language: fundamental elements XML
files: advanced elements (expressions, sections, variables, groups)
Fonts
The subreports (« subreports »)
Scriptlets for JasperReports
Increase JasperReports in any way: method, possibilities, references
Review of usage and generated files

Workshop: many complementary states

Duration

3 days

Price

£ 2995

Audience

Developers

Prerequisites

Knowledge of Java and XML

Reference

JAV217-F

Sessions

Contact us for more informations about session date

Blockchain: Initiation

Goals


- This training aims to present in detail the ecosystem of Blockchain technology

- Taught by a Blockchain specialist with more than 3 years of experience this one-day session is intended for Top Management and managers who are considering Blockchain solutions, or simply wish to learn more in detail about this new technology

Program

The essentials of the
Bitcoin Blockchain and other implementations
The challenges
The ecosystem
Trends and current projects
Questions and Answers

Duration

1 day

Price

£ 2495

Audience

Top Management, IT and Finance Managers, Project Managers

Prerequisites

No

Reference

FOR100084-F

Sessions

Contact us for more informations about session date

Windows Server 2012 Administration : Initiation + Advanced

Goals


- Learn to install and administer Windows Server

- Manage users

- Discover NTFS

- Configure a network printer

- Manage Windows Server security

- Protect and monitor your server

- Install and configure Terminal Server

Program

Windows Server

Preparing for installation
Different editions of Windows Server 2012
Installing Windows 2012 Server
Upgrading to Windows 2012 Server

Overview and use
Managing server clusters
Support for virtual servers
Exporting DashBoard settings

Understanding user accounts
Required items for new user accounts
Creating a user account
Defining criteria for passwords
Defining properties for passwords
Customizing User Settings Using User Profiles
Managing User Data by Creating Home Directories

Understanding Groups
Developing a Policy for Creating Security Groups
Using predefined groups

Types of disk storages available in Windows Server
Partitioning a basic drive
Creating volumes on a dynamic drive
Performing common tasks to manage disks
Solving configuration issues disks and partitions

Description of NTFS Permissions
Applying NTFS Permissions by Windows Server
Assigning NTFS Permissions
Compressing Data on an NTFS Partition
Configuring Disk Quotas on NTFS Volumes

Description of Shared Folders
Creating Shared Folders
Combination of NTFS Permissions and Shared Folders: SMB, NFS, iSCSI
Configuring Shared Folders
Using DFS Using the FSRM File Server Resource Manager
Configure Storage Spaces in Windows Server 2012
Backup / Restore of Windows Server

Duration

5 days

Price

£ 1956

Audience

Network and systems administrators

Prerequisites

Network knowledge

Reference

WIN134-F

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

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

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

Practical work: Audit of file access. Administer the Windows firewall with advanced security. Creating rules with Netsh. Import a security template from another server

Monitoring system resources
Monitoring event logs
Optimizing performance

Installing, configuring and managing a DHCP server
Securing DHCP
Netsh commands for DHCP
Diagnosing and troubleshooting DHCP problems
Implementing IP address management (IPAM)

Practical work: Installing, configuring and testing a DHCP server

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

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

Overview of Remote Desktop Services
Planning the Installation
Configuring a Session Host Server
Installing an RDS Farm with a Connection Broker
Installing the License Manager
Using Remote App and Web Access
Installing Applications on a RDS server

Passing the certification (if provided for in the funding)

Sessions

Contact us for more informations about session date

Being alone during the training, Richard was able to listen to me and was able to adapt his course to my requests and my needs in the field. Very competent / attentive trainer - He was able to explain things to me throughout the training in simple and understandable words.
Stéphane I.
Stéphane I.
The trainer is very competent and obliging, perfect.
Franck R.
Franck R.
Good, Impeccable trainer. Excellent, aware of our shortcomings in reality and corrected by + 90% for my future needs. Thanks to the Trainer. On the other hand, there were few people during the lessons and I find that wonderful because the Trainer has more time devoted to us. Good because I really needed it to face reality a little better once on the pitch. In line with my expectations. Very good as a Trainer compared to what I have seen and had so far on all my other trainings.
Pierre N.
Pierre N.
Trainer: Friendly, pedagogue, very available, very good level.
Jérôme B.
Jérôme B.
Friendly trainer very available and attentive. Do not hesitate to resume if the concepts are blurry.
Gabriel B.
Gabriel B.
Précédent
Suivant

Windows Server 2012 Administration : Initiation

Goals


- Learn to install and administer Windows Server

- Manage users

- Discover NTFS

- Configure a network printer

- Manage Windows Server security

- Protect and monitor your server

- Install and configure Terminal Server

Program

Windows Server

Preparing for installation
Different editions of Windows Server 2012
Installing Windows 2012 Server
Upgrading to Windows 2012 Server

Overview and use
Managing server clusters
Support for virtual servers
Exporting DashBoard settings

Understanding user accounts
Required items for new user accounts
Creating a user account
Defining criteria for passwords
Defining properties for passwords
Customizing User Settings Using User Profiles
Managing User Data by Creating Home Directories

Understanding Groups
Developing a Policy for Creating Security Groups
Using predefined groups

Types of disk storages available in Windows Server
Partitioning a basic drive
Creating volumes on a dynamic drive
Performing common tasks to manage disks
Solving configuration issues disks and partitions

Description of NTFS Permissions
Applying NTFS Permissions by Windows Server
Assigning NTFS Permissions
Compressing Data on an NTFS Partition
Configuring Disk Quotas on NTFS Volumes

Description of Shared Folders
Creating Shared Folders
Combination of NTFS Permissions and Shared Folders: SMB, NFS, iSCSI
Configuring Shared Folders
Using DFS Using the FSRM File Server Resource Manager
Configure Storage Spaces in Windows Server 2012
Backup / Restore of Windows Server

Duration

3 days

Price

£ 1190

Audience

Network and systems administrators

Prerequisites

Network knowledge

Reference

WIN132-F

SQL Server

History, versions and licenses of SQL Server
Roles and stakeholders of a SQL Server database
Other concurrent systems
Tools associated with SQL Server
Installation process: planning, updating
Methods of authentication
Verification of the installation
Type of files: .mdf, .ndf, .ldf
Administrative objects

Workshop: Installation and configuration of SQL Server – Discovery of the SQL Server Management Studio tool

General organization: tables, views, constraints, index, procedures, …
Specification and modeling methods
Types and particular specifications of tables and fields
Creation of data structures
Management of storage spaces: files, groups of files
Insertion and import of data

Workshop: Creation of databases and management of files

SQL language; MS SQL standards and particularities
Data definition statements
Index types
Constraint management
Data manipulation: insertion, updates, restriction, projection, calculations
Advanced structures, multiple joins, views, stored procedures
Transact SQL programming: functions, procedures
Elements of temporal optimization of queries
The documentation available

Workshop: Creation and manipulation of database data

Users and security: authentication modes, accounts, roles, permissions
Logs, possible backups and tools
Work on history and cancellations
Monitoring by alerts and triggers
Various automation of administration tasks

Workshop: User management – Backups and restores

Passing the certification (if provided for in the funding)

Sessions

Contact us for more informations about session date

Good, Impeccable trainer. Excellent, aware of our shortcomings in reality and corrected by + 90% for my future needs. Thanks to the Trainer. On the other hand, there were few people during the lessons and I find that wonderful because the Trainer has more time devoted to us. Good because I really needed it to face reality a little better once on the pitch. In line with my expectations. Very good as a Trainer compared to what I have seen and had so far on all my other trainings.
Pierre N.
Pierre N.
Trainer: Friendly, pedagogue, very available, very good level.
Jérôme B.
Jérôme B.
Précédent
Suivant

Windows Server 2016 Administration : Initiation + Advanced

Goals


- Learn to install and administer Windows Server

- Manage users

- Discover NTFS

- Configure a network printer

- Manage Windows Server security

- Protect and monitor your server

- Install and configure Terminal Server

Program

Preparing for installation
What’s new in Windows Server 2016
The different editions of Windows Server 2016
Installing Windows 2016 Server, Windows 2016 Core and Nano Core

Presentation and use
Management of server clusters
Support for virtual servers
Export of DashBoard settings
Administer servers with graphical interface, Core and NanoCore
Installation of local and remote roles and features
Nano Server Recovery console

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

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

Types of disk storage available in Windows Server (NTFS and ReFS)
Partitioning a basic drive
Creating volumes on a dynamic drive
Storage pools to simplify storage management
Perform common tasks to manage disks
Remote Unified Management for file services and storage pool

Description of Shared Folders
Creating Shared Folders
Combination of NTFS Permissions and Shared Folders: SMB, NFS, iSCSI
Configuring Shared Folders
Using DFS Using the FSRM File Server Resource Manager
Configure Storage Spaces in Windows Server 2016
Configure BranchCache in Windows Server 2016

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

Duration

5 days

Price

£ 1375

Audience

Systems Administrators

Prerequisites

Network knowledge

Reference

WIN1218-F

Windows Server Security Overview Windows Server Security
Policies
Implementing Security Policies on Objects
Managing ACLs and DACs
Auditing Access to System Resources
Windows Defender Malware Protection
Securing Partitions with Bitlocker

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

Practical work: Audit of file access. Administer the Windows firewall with advanced security. Creating rules with Netsh. Import a security template from another server

Monitoring system resources
Monitoring event logs
Optimizing performance

Installing, configuring and managing a DHCP server
Securing DHCP
Netsh commands for DHCP
Diagnosing and troubleshooting DHCP problems
Implementing IP address management (IPAM)

Practical work: Installing, configuring and testing a DHCP server

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

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

Overview of Remote Desktop Services
Planning the Installation
Configuring a Session Host Server
Installing an RDS Farm with a Connection Broker
Installing the License Manager
Using Remote App and Web Access
Installing Applications on a RDS server

What’s New in PowerShell 5 PowerShell
Basics
Performing Administration and Scripting Tasks with Powershell and CorePowerShell

Passing of the certification (if foreseen in the financing)

Sessions

Contact us for more informations about session date

Windows Server 2016 Administration : Initiation

Goals


- Learn to install and administer Windows Server

- Manage users

- Discover NTFS

- Configure a printer

Program

Preparing for installation
What’s new in Windows Server 2016
The different editions of Windows Server 2016
Installing Windows 2016 Server, Windows 2016 Core and Nano Core

Presentation and use
Management of server clusters
Support for virtual servers
Export of DashBoard settings
Administer servers with graphical interface, Core and NanoCore
Installation of local and remote roles and features
Nano Server Recovery console

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

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

Types of disk storage available in Windows Server (NTFS and ReFS)
Partitioning a basic drive
Creating volumes on a dynamic drive
Storage pools to simplify storage management
Perform common tasks to manage disks
Remote Unified Management for file services and storage pool

Description of Shared Folders
Creating Shared Folders
Combination of NTFS Permissions and Shared Folders: SMB, NFS, iSCSI
Configuring Shared Folders
Using DFS Using the FSRM File Server Resource Manager
Configure Storage Spaces in Windows Server 2016
Configure BranchCache in Windows Server 2016

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

Passing of the certification (if foreseen in the financing)

Duration

3 days

Price

£ 1375

Audience

Systems Administrators

Prerequisites

Network knowledge

Reference

WIN1218-F

Sessions

Contact us for more informations about session date

Windows Server 2019 Administration : Initiation + Advanced

Goals


- Learn to install and administer Windows Server

- Manage users

- Discover NTFS

- Configure a network printer

- Manage Windows Server security

- Protect and monitor your server

- Install and configure Terminal Server

Program

Preparing for installation
What’s new in Windows Server 2019
The different editions of Windows Server 2019
Installing Windows 2019 Server, Windows 2019 Core

Workshop: Choice of installation and automation mode

Presentation and use
Management of server clusters
Support for virtual servers
Administer the servers with the graphical interface and Core
Installation of roles and features (local and remote)

Workshop: Multiple administration tasks using the dashboard

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

Workshop: Creation and configuration of user accounts

Overview of groups
Developing a policy for creating security groups
Using predefined groups

Workshop: Managing security groups

Types of disk storage available in Windows Server (NTFS and ReFS)
Partitioning a basic drive
Creating volumes on a dynamic drive
Storage pools to simplify storage management
Perform common tasks to manage disks
Remote Unified Management for file services and storage pool

Lab: Partitioning and creating volumes – common storage management tasks

Description of Shared Folders
Creating Shared Folders
Combination of NTFS Permissions and Shared Folders: SMB, NFS, iSCSI
Configuring Shared Folders
Using DFS Using the FSRM File Server Resource Manager
Configure Storage Spaces in Windows Server 2019
Configure Branch Cache in Windows Server 2019

Workshop: Managing access to disk resources

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

Lab: Configuring a print server in Windows Server 2019

Duration

5 days

Price

£ 2148

Audience

Network and systems administrators

Prerequisites

Network knowledge

Reference

WIN100737-F

Windows Server security policies
Implementation of security policies on Objects
ACL and DAC management 
Auditing access to system resources
Securing partitions with Bitlocker

Workshop: Setting up a security policy

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

Workshops: Auditing file access – Administering Windows firewall with advanced security – Importing a security model from another server

Monitoring system resources
Monitoring event logs
Optimizing performance

Workshop: Monitoring resources and optimizing performance

Installing, configuring and managing a
DHCP server Securing DHCP
Powershell commands for DHCP
Diagnosing and troubleshooting DHCP problems
Implementing IP address management (IPAM)

Workshop: Installing, configuring and testing a DHCP server

Reminder on
DNS operation New features of DNS in Windows 2019
High availability for the DNS service
Troubleshooting and diagnostic tools

Workshop: Install and configure a DNS server – Perform operational checks with nslookup

Overview of Remote Desktop Services
Planning the Installation
Configuring a Server Session Host
Installing an RDS Farm with a Connection Broker
Installing the License Manager
Using Remote Apps and Web Access
Installing Applications on an RDS Server

Workshop: Complete management of RDS services

What’s New in PowerShell
Basic PowerShell Concepts Performing
Administration and Scripting Tasks with Powershell Lab

Workshop : Multiple Administration Scripts

Passing of the certification (if foreseen in the financing)

Sessions

Contact us for more informations about session date

Windows Server 2019 Administration : Initiation

Goals


- Learn to install and administer Windows Server

- Manage users

- Discover NTFS

- Configure a printer

Program

Preparing for installation
What’s new in Windows Server 2019
The different editions of Windows Server 2019
Installing Windows 2019 Server, Windows 2019 Core

Workshop: Choice of installation and automation mode

Presentation and use
Management of server clusters
Support for virtual servers
Administer the servers with the graphical interface and Core
Installation of roles and features (local and remote)

Workshop: Multiple administration tasks using the dashboard

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

Workshop: Creation and configuration of user accounts

Overview of groups
Developing a policy for creating security groups
Using predefined groups

Workshop: Managing security groups

Types of disk storage available in Windows Server (NTFS and ReFS)
Partitioning a basic drive
Creating volumes on a dynamic drive
Storage pools to simplify storage management
Perform common tasks to manage disks
Remote Unified Management for file services and storage pool

Lab: Partitioning and creating volumes – common storage management tasks

Description of Shared Folders
Creating Shared Folders
Combination of NTFS Permissions and Shared Folders: SMB, NFS, iSCSI
Configuring Shared Folders
Using DFS Using the FSRM File Server Resource Manager
Configure Storage Spaces in Windows Server 2019
Configure Branch Cache in Windows Server 2019

Workshop: Managing access to disk resources

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

Lab: Configuring a print server in Windows Server 2019

Passing of the certification (if foreseen in the financing)

Duration

3 days

Price

£ 1375

Audience

Systems Administrators

Prerequisites

Network knowledge

Reference

WIN100740-F

Sessions

Contact us for more informations about session date

Magento Initiation + Advanced

Goals


- Discover Magento

- Know how to use, as a shop manager, a ready installation of Magento

- Know how to set up and maintain a complete and personalized shop

Program

Presentation and versions
Installation needs, hosting, domain names – costs and consequences
Alternatives to Magento

Who to call, budgets and possibilities
Communication with a service provider; end of project checklist
A ready-to-use installation
Data structure in Magento
Migrate from an existing system / collaboration with another system

Workshop: use of a standard Magento installation

Connection – essential elements of security
Configuration: presentation and important modifications
Complete management of users and interactions
Presentation of web services
Backup and general information in collaboration with the system

Workshop: user creation and configuration manipulation

Summaries of the operating principles of the appearance of Magento
Static elements (pages, blocks, widgets)
Automatic emails

Workshop: creation of classic pages of a site

Types of products: attributes
Products and their categories
Special products in detail (batches, downloads, etc.)
Taxes
Payment and delivery methods
Various promotions

Workshop: set up of a complete catalog

Shopping cart and purchase
The complete order cycle
Document
issuance Customer management and customer groups
Referencing: control elements

Workshop: various tests; unexpected situations

Essential technologies – HTML, CSS, JavaScript
Installation requirements, hosting, domain names and their suppliers
Summary of maintenance of data and workflow of the store

Workshop: complete installation and thoughtful implementation of categories, products, promotions and various pages

Complete management of users and interactions
Presentation of web services
Backup and general information in collaboration with the system

Workshop: identification of potential problems, special cases

Reminders of HTML, JavaScript, CSS
Installation of decoration and other static elements (the « skin » directory)
Principles and limits of the presentation system; themes, interfaces, blocks and layouts
Preparation of a model
Implementation of a complete design
Designs specific to products, categories, etc.

Workshop: multiple changes in appearance, from details to the general layout

General PHP reminders, including object
General architecture and database
Direct modification of Magento
Principle of modules, types of modules
Creation of a minimal module and use
Modules for delivery and payment

Workshop: manufacture of a complete extension

Duration

5 days

Price

£ 2433

Audience

All

Prerequisites

Knowledge of HTML and CSS, notions of PHP

Reference

OPE732-F

Sessions

Contact us for more informations about session date

Magento 2 : Initiation + Advanced

Goals


- Discover Magento

- Know how to use, as a shop manager, a ready installation of Magento

- Know how to set up and maintain a complete and personalized shop

Program

Presentation and versions
Installation needs, hosting, domain names
Alternatives to Magento

Management of product categories
Manage products from a category
Add a category to the navigation
Create a product catalog (Name, price, description, tax, etc.)
Manage attribute sets
Add media to a product (image, video)
Use custom options for a product

Manage user groups
Add a new user
Associate addresses with a user

Manage promotion rules (basket & catalog)
Optimize referrals and search
Manage url rewrites
Modify email
templates Create templates for Newsletters

Static elements: pages, blocks and widgets
Design parameters
See installed themes
Schedule the modification of a theme
Modify the design parameters
Management of store caches

The general configuration of the store
Configure the email, address, location of the store
Payment methods
Define the tax rules and authorized currencies
Write the General conditions of sale Order
statuses

Create backups of the site and the database
Manage the cache and indexing of the site
Management of back office users and their rights

Declare a Magento theme (theme.xml)
Register the theme in the Magento system: the registration.php file
The notion of Vendor and Theme
Configure the theme images: the etc / directory and the view.xml file
The tree structure of theme folders (web, css, js, fonts, images)
Declare and add a logo (layout / default.xml)
Layout compositions, layout overload

Declare a module (namespace and module name)
Register the module in the Magento system: registration.php
Activate a module
Declaration of the router
The MVC model
Create controllers and actions
Customize the urls of the module
Add views (.phtml) and blocks

Duration

5 days

Price

£ 2607

Audience

All

Prerequisites

Knowledge of HTML and CSS, notions of PHP

Reference

OPE100237-F

Sessions

Contact us for more informations about session date

Magento 2 : Initiation

Goals


- Know how to use, as a store manager, a ready installation of Magento

- Discover Magento

Program

Presentation and versions
Installation needs, hosting, domain names
Alternatives to Magento

Management of product categories
Manage products from a category
Add a category to the navigation
Create a product catalog (Name, price, description, tax, etc.)
Manage attribute sets
Add media to a product (image, video)
Use custom options for a product

Manage user groups
Add a new user
Associate addresses with a user

Manage promotion rules (basket & catalog)
Optimize referrals and search
Manage url rewrites
Modify email
templates Create templates for Newsletters

Static elements: pages, blocks and widgets
Design parameters
See installed themes
Schedule the modification of a theme
Modify the design parameters
Management of store caches

The general configuration of the store
Configure the email, address, location of the store
Payment methods
Define the tax rules and authorized currencies
Write the General conditions of sale Order
statuses

Create backups of the site and the database
Manage the cache and indexing of the site
Management of back office users and their rights

Duration

3 days

Price

£ 1632

Audience

Web Developers - Webmasters - Integrators

Prerequisites

Knowledge of HTML and CSS, notions of PHP

Reference

OPE100238-F

Sessions

Contact us for more informations about session date

Drupal 8 Developer : Initiation + Advanced

Goals


- Know how to develop modules for Drupal, interact with the core, manage the router, forms, data model

Program

A resolutely Object-Oriented in-depth overhaul
The Symfony components included in Drupal

Presentation of the Drupal Console and Drush command line tools
Organization of Drupal 8
Multi-sites directories

YAML syntax: typing, escaping, sequence and mapping
Declare your module for Drupal with .info.yml
Declare your project with composer
Hook principle: hook_help in the .module file
Declare permissions
Declare your first page via a controller
Link our page to a URL via routing.yml
Create a menu link via links.menu.yml
Workshop: develop a first Drupal 8 page module

Return a rendering table
Define its template files via the theme hook
Pre-process the data to be injected into the template
Write the template for the Twig Atelier engine
: define the views of its module

Manage menus and
links Specific types of links: actions, local task, contextual

The plugin manager
The different types of plugins

Declare a block class
Make it available via the @Block annotation
Expose its configuration in the administration
Support the block configuration form
Workshop: develop the block

Create a configuration form
Define the form fields via Form API
Data validation and submission
Workshop: set up its administration page

Create a form
Configure the different types of fields
Validate the data submitted by the user
Alter the other forms

Alter existing services
Define own services
Inject dependencies

Presentation of Schema API
Declare a schema installation
Manage version upgrades
Presentation of Database API
Interact with database data via the QueryBuilder

Organization of test classes
Create a test user and assign him permissions
Set up a functional test
Workshop: test the configuration page

Principles of entities, generic, configuration and content
Entity type verification
CRUD operations
Access control

Define its entity interface
Create entity class
Link associated resources via annotations
Define configuration forms
Define controller actions

Validation API
Create custom constraints

Translate the configuration
Translate in the views
Inject the translation service into the controller

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

Duration

5 days

Price

£ 2607

Audience

Confirmed POO-PHP developer

Prerequisites

Have followed the Drupal webmaster training, expert PHP or equivalent knowledge

Reference

OPE1056-F

Sessions

Contact us for more informations about session date

Drupal 8 Developer : Initiation

Goals


- Know how to develop modules for Drupal, interact with the core, manage the router, forms, data model

Program

A resolutely Object-Oriented in-depth overhaul
The Symfony components included in Drupal

Presentation of the Drupal Console and Drush command line tools
Organization of Drupal 8
Multi-sites directories

YAML syntax: typing, escaping, sequence and mapping
Declare your module for Drupal with .info.yml
Declare your project with composer
Hook principle: hook_help in the .module file
Declare permissions
Declare your first page via a controller
Link our page to a URL via routing.yml
Create a menu link via links.menu.yml

Workshop: develop a first Drupal 8 page module

Return a rendering table
Define its template files via the theme hook
Pre-process the data to be injected into the template
Write the template for the Twig Atelier engine

: define the views of its module

Manage menus and
links Specific types of links: actions, local task, contextual

The plugin manager
The different types of plugins

Declare a block class
Make it available via the @Block annotation
Expose its configuration in the administration
Support the block configuration form

Workshop: develop the block

Create a configuration form
Define the form fields via Form API
Data validation and submission

Workshop: set up its administration page

Create a form
Configure the different types of fields
Validate the data submitted by the user
Alter the other forms

Alter existing services
Define own services
Inject dependencies

Presentation of Schema API
Declare a schema installation
Manage version upgrades
Presentation of Database API
Interact with database data via the QueryBuilder

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

Duration

3 days

Price

£ 1736

Audience

Confirmed POO-PHP developer

Prerequisites

Have followed the Drupal webmaster training, expert PHP or equivalent knowledge

Reference

OPE100082-F

Sessions

Contact us for more informations about session date

Drupal 7 Developer : Initiation + Advanced

Goals


- Know how to develop modules for Drupal, interact with the core, manage the router, forms, data model

Program

Presentation of Drupal and history of versions
IDE and development tools for Drupal
Installation and implementation of the working environment
Documentation and other resources Drupal.org

Workshop: Installation and basic configuration of Drupal

General architecture
Organization of directories and files
Multi-site management

Workshop: Use of third-party modules

Declaration of the module: the info file
Interacting with the heart: the principle of hooks
Declaring a hook
Best practices: help page, administration, rights
Save module settings

Workshop: Creation of the first module

How Drupal manages URL routing
Matching a URL to a page
Managing access control to a URL
Using « wild cards » in URLs
Modifying URLs declared by other modules

The database abstraction layer
Connect to the database
Make queries
Manage transactions
Presentation of the Schema API
Manage schema versions
Connect to several DBs

The global object $ user
Introduction to hook_user ()
User account creation
process The login process
Add fields to the $ user object

Create your own forms
Submission and validation of a form
Presentation of a form
Complex forms

The File API
Manipulating taxonomy
Cache
management by Drupal Session management by Drupal
Use javascript and jQuery in Drupal

Understanding the theme engine
Increasing and overloading display elements
Template files
Theme functions

How entities and bundles work
Creating a new entity type
Managing entity metadata
Using the Entity API wizard
Setting up the Entity class and its controller

Declare a new type of control
Manage persistence in the database
Validate a field
Create a custom widget

Main evolutions of Drupal 8

Duration

5 days

Price

£ 2607

Audience

Confirmed PHP developer

Prerequisites

Have followed the Drupal webmaster and intermediate PHP training or equivalent knowledge

Reference

OPE725-F

Sessions

Contact us for more informations about session date

Drupal 7 Developer : Initiation

Goals


- Know how to develop modules for Drupal, interact with the core, manage the router, forms, data model

Program

Presentation of Drupal and history of versions
IDE and development tools for Drupal
Installation and implementation of the working environment
Documentation and other resources Drupal.org

Workshop: Installation and basic configuration of Drupal

General architecture
Organization of directories and files
Multi-site management

Workshop: Use of third-party modules

Declaration of the module: the info file
Interacting with the heart: the principle of hooks
Declaring a hook
Best practices: help page, administration, rights
Save module settings

Workshop: Creation of the first module

How Drupal manages URL routing
Matching a URL to a page
Managing access control to a URL
Using « wild cards » in URLs
Modifying URLs declared by other modules

The database abstraction layer
Connect to the database
Make queries
Manage transactions
Presentation of the Schema API
Manage schema versions
Connect to several DBs

The global object $ user
Introduction to hook_user ()
User account creation
process The login process
Add fields to the $ user object

Create your own forms
Submission and validation of a form
Presentation of a form
Complex forms

The File API
Manipulating taxonomy
Cache
management by Drupal Session management by Drupal
Use javascript and jQuery in Drupal

Understanding the theme engine
Increasing and overloading display elements
Template files
Theme functions

Main evolutions of Drupal 8

Duration

3 days

Price

£ 1632

Audience

Confirmed PHP developer

Prerequisites

Have followed the Drupal webmaster and intermediate PHP training or equivalent knowledge

Reference

OPE744-F

Sessions

Contact us for more informations about session date

AutoCAD 3D Initiation + Advanced

Goals


- Perform modeling, cuts, presentations and quality renderings

Program

History
Different uses and functionalities

Use the main Autocad formats: .DWG / .DWT, DXF, DWS, PNG and PDF

Use the menu bar
Use the ribbon
Work in the graphics area
Use the command line

Create a new document
Use the workspace
Define the limits of the work plane
Configure the units
Know the difference between the different selection modes
Adjust the grid
Use the resol mode: grid magnetism
Use the coordinate systems: orthogonal, polar, object
Use object snaps

Zoom in / out
Use the pan
Use the orbit, free orbit and continuous orbit
Master the 3D compass
Use the navigation disc
Use the predefined views

2D Wireframe
Conceptual
Hidden
Realistic
Shaded
Shaded with edges
Grayscale
Sketches
Wireframe
X-rays

Use the rectangle tool
Use the ellipse tool
Use the lines tool
Use the polyline tool
Master the 2D object snaps
Master the general coordinate system
Master the user coordinate system
Define a new UCS: 3-point UCS, Z-axis UCS

Use the rectangle
Use the ellipse
Use the arc
Use the polygon
Master the offset tool
Master the copy tool
Master the rotation tool
Master the 2D object snap

Master the dynamic user coordinate system
Use polyline
Use offset
Use copy
Master 2D object snap

Use the line tool
Use the 3D polylines tool
Use the spline tool
Use the helix tool

Use the rectangle tool
Use the ellipse tool
Use the offset tool
Use the copy tool
Use the rotation tool
Control the 2D object snap
Move in 3D
Use 3D rotation
Scale

Presentation of the Gizmo : move / rotate / scale 3D
Position the Gizmo
Select axes of modifications
Select planes of modifications

Workshop: build a 3D element with rudimentary forms

Move, move in 3D
Rotate, rotate in 3D
Copy
Offset
Mirror
Align
Stretch
Master rectangular array
Master polar array
Master array along a path
Control the peculiarities of associative arrays in 3D

Workshop: design a simple building with existing forms

Use 3D primitives
Use the box
Use the cylinder
Use the cone
Use the sphere
Use the pyramid
Use the wedge
Use the torus
Master the solids

Unite
Subtract
Intersect

Workshop: make an architect desk and lamp

Press or pull
Section
Thicken
Make an indentation
Make an imprint
Extract edges
Create a shell
Create fillet edges
Create chamfer edges
Extrude faces
Offset faces

Workshop: design mechanical parts from 2D drawings

Add 3D in 2D drawings
Master the nuances between solids and surfaces
Create regions
Manage the different types of extrusions
Make path revolutions
Master the different types of path sweeps 
Smooth paths
Control the associative properties of surfaces
Manage surface types: smoothing with cuts only / nurbs
Use handles

Workshop: make a straight staircase and a spiral staircase

Basic configuration
Choose a predefined rendering quality
Use the resolution
Use the exposure
Use the environment
Control the rendering window: menu, information

Workshop: produce renderings from previously created volumes

Use 3D blocks
Create 3D blocks
Manage insertion points
Modify 3D blocks
Master the peculiarities of the 3D block editor

Use parameters and actions: visibility, inversion state, rotation, alignment

Workshop: create dynamic windows and doors blocks

Master the interests of 3D Xref
Create / insert
Edit the external reference: in the drawing, in the original
Link the external reference

Workshop: create elements of a kitchen in 3D and insert them into a building

Mesh primitives
Use the mesh box
Use the mesh cylinder
Use the mesh cone
Use the mesh sphere
Use the mesh pyramid
Control the mesh bevel
Use the mesh torus
Control the surface of revolution
Control the left surface
Control the ruled surface
Control the extruded surface

Workshop: create mesh surfaces from tracings

Edit mesh objects
Work on vertices
Work on edges
Work on faces
Split faces
Merge faces

Workshop: model mesh objects

Convert a solid to a mesh object
Convert a surface to a mesh object
Smooth more / less
Refine the mesh
Add and remove folds

Convert mesh objects to solids
Convert mesh objects to surfaces
Use conversions options

Workshop: model elements

Material browser
Use the browser 
Use default material types

Configure the settings according to the type of material:
Generics
Colors
Textures
Images
Reflectivity
Transparency
Cutouts
Self-illuminating

Apply materials to a solid
Apply materials to a layer
Create textures
Apply textures to materials
Map textures

Workshop: apply external textures to objects

Master the functioning of the types of lights and shadows
Use natural light: sun
Choose the location: the geographical location
Orient cardinal
Set the date and time
Use the sun properties
No shadows
Shadows on the ground
Complete shadows
Use the artificial lights
Master the units of measurement of light: lumen, candela and lux
Use the photometric properties
Use the light temperature
Use the point source
Use the directed source
Use the distant source
Use the star light
Use the positioning and target

Workshop: apply textures and highlight a building

Control the properties of the default camera
Control the personalized settings: position, target point, focal length
Manage views
Save settings
Animate the camera according to a trajectory
Position the target point
Control the shadow of frames per second
Manage the duration of the animation
Choose video format

Workshop: create an outdoor light atmosphere on a building and create an animation

Configure
Choose the predefined rendering quality
Choose the resolution
Choose the exposure
Manage the environment
Control the rendering window: information, menu

Workshop: make simple renderings of previously modeled elements

Create, configure and save views
Choose the rendering quality
Control the general options
Control the indirect illumination
Manage the diagnosis
Save renderings

Workshop: create renderings of previously modeled elements with « presentation » quality

Use the sections in the solid ribbon
Create a section plane
Reposition, orient a section plane
Activate or deactivate the section
Generate a section
Create as a block
Rename the section

Save views
Position views in the object space
Create details
Create sections
Create projected views
Modify the appearance of views
Modify the scale of views
Create section views styles
Create detail views styles
Modify sections and details styles
Modify the drawing
Update the presentations

Workshop: present a building on several paper formats by exploiting the views, the cuts, the details and projections

Duration

10 days

Price

£ 3817

Audience

Everyone

Prerequisites

Master AutoCad

Reference

CAO384-F

Sessions

Contact us for more informations about session date

qualified trainer and very attentive to people. responds in simple language to make themselves understood which facilitates learning.
Thibaut M.
Thibaut M.
VERY WELL ORGANIZED COURSES THE EXERCISES ARE GOING WELL IN PROGRESS IN THE LOGIC OF WHAT WE LEARN. A VERY LISTENING TRAINER OFTEN COMES TO SEE US WHEN A PROBLEM ARISES AND WE DO NOT UNDERSTAND. VERY TEACHER AND PATIENT TO RECOMMEND
Isabelle G.
Isabelle G.
Very welcoming team, very attentive trainer Very complete training, course adapted to the level of the participants Very educational trainer, and patient Excellent week of training
Muriel R.
Muriel R.
small group of 3 people allowing the trainer to be more available. sustained pace because many elements to address. A bit of trouble to all assimilate for my part, but still satisfied. Trainer: very friendly, pedagogue and available
David T.
David T.
good trainer, serious, patient and attentive to our expectations
Jean-marie O.
Jean-marie O.
Précédent
Suivant

AutoCAD 2D Initiation

Goals


- Carry out or modify a 2D drawing, mechanical or architectural, by developing a drawing strategy according to the tools made available by AutoCAD

- Adapt these jobs to export them as a file or to a plotter

- Customize, automate and optimize production tools in AutoCAD

Program

History
Different uses and functionalities

Use the main Autocad formats: DWG / DWT, DXF, DWS, PNG and PDF

Use the menu bar
Use the ribbon
Work in the drawing area
Use the command line

Create a new document
Configure the workspace
Configure units and conventions
Define the limits of the drawing
Navigate into the drawing
Use the different selection modes
Adjust the grid and display
Use the grid magnetism
Use the markings: orthogonal / polar / object
Use object snaps

Work in abscissa and ordinate
Use the origin
Use absolute coordinates
Use relative coordinates 
Use relative / polar coordinates

Workshop: handling and familiarization exercises

Draw with line and polyline
Use the rectangle tool
Use the arc tool
Use the circle tool
Use the ellipse tool
Use the polygon tool
Use the xline and ray
Use the ring tool

Workshop: make small architectural elements or mechanical parts

Use the move function
Use the copy function
Use the offset function
Use the mirror function
Use the rotation function
Use the stretch function
Use the scale function
Use the trim / extend functions
Use the explode function

Workshop: make small architectural elements or mechanical parts

Understand the layers panel
Manage layer attributes
Use texts and text styles
Use dimensions, dimension styles and measurement tools
Use annotations
Use hatching
Create a .DWT template file

Workshop: carry out the layout plan of a building

Use model / paper space
Configure the page layout
Choose the plotter type and configure
Create rectangular or polygonal layouts
Control the presentation window scales
Create custom scales
Insert a title block

Workshop: layout and export in PDF presentations

Duration

3 days

Price

£ 625

Audience

Everyone

Prerequisites

Mastery of the PC environment
Basic knowledge of technical drawing

Reference

CAO495-F

Sessions

Contact us for more informations about session date

clean room, fairly large workstation. very lively course with a lot of practice training that exceeds my expectations trainer who masters his subject, and who switches the exercises to reality.
Aurélien G.
Aurélien G.
Listening and available trainer knows his software very well and very pedagogue.
Eric R.
Eric R.
suitable and functional working environment. course adapted to my expectations, very interesting training and rich in information.
Pascal H.
Pascal H.
Logical progression, calling on the basics throughout the advancement, thus allowing them to be mastered. No shadow point on the different software features. Part of the end of training time dedicated to questions / answers leaving no questions unanswered. Trainer: Has all the qualities of a good teacher (patience, discernment, involvement, motivating and approachable)
Loïc R.
Loïc R.
Clear and rich explanation. Understanding and quick. Trainer: Very good explanation and very understandable.
Mathis B.
Mathis B.
Précédent
Suivant

WordPress : initiation

Goals


- Create and manage a dynamic website or blog with the WordPress CMS

- Learn the main concepts of site administration

- Learn to customize a WordPress theme or template

Program

What is a CMS?
The main CMS
Principle and functioning of WordPress
History and version

The different tools required: web server, database, editor …
Update procedures
Define the title of your WordPress site
Create an administrator account

Practical workshop: installing WordPress on a web server

Navigation between public and private section
Presentation of the dashboard
Organization of administration menus
Difference between article and page

Manage articles: creation, modification, archiving
Presentation of WYSIWYG
Organize articles via categories
Assign categories to a menu
Add media: images, videos and audio
Schedule the publication of an article

Prohibit or allow comments
Put a comment on hold for moderation
Correct a comment
Consider a comment as unwanted
Protect yourself from spam comments

Create static pages
Manage multiple page levels
Define the visibility of a page
Use the WordPress text editor properly
Assign a page to a menu
Create a static home page

Practical workshop: publication and formatting of content

SEO constraints
Choose your keywords
Work well your text content
Refer your images

Customize the basic WordPress theme
Configure the header and menu
Define a background
Manage widgets: location, deactivation …

How to choose a good theme?
Download another theme via WordPress
Change the installed theme

Practical workshop: change of theme

Install a « Page Builder » extension
Understand how the grid works
Integrate a layout
Create layout templates

Create picture and video slideshows
Use custom fonts

Practical workshop: Install and test several extensions

Duration

3 days

Price

£ 1284

Audience

Beginner webmasters

Prerequisites

Basic knowledge of HTML and website building

Reference

OPE230-F

Sessions

Contact us for more informations about session date

Google Cloud Platform : Fundamentals (Core Infrastructure)

Goals


- Know the usefulness and strengths of Google Cloud Platform products and services

- Interact with Google Cloud Platform services

- Choose and use application deployment environments and storage options on Google Cloud Platform

- Know the basics of using BigQuery, Cloud Deployment Manager, and Google Stackdriver

Program

Google Cloud Platform: overview, advantages
Components of the Google network infrastructure: points of presence, data centers, regions and zones
IaaS (Infrastructure-as-a-Service) vs PaaS (Platform-as-a-Service)
Google Cloud projects Platform: Objects
Authentication and Access Management
Interactions with Google Cloud Platform

Workshop: creation of a project and management of objects

Google Compute Engine: presentation, functionalities Use
case of Google Compute Engine
Operational tools and services
Google Cloud Platform networking

Workshop: Compute Engine

Google Cloud Storage: presentation, uses
Google Cloud SQL:
Google Cloud Bigtable functionalities
Google Cloud Datastore
Choice between the different storage options offered by Google Cloud Platform

Workshop: Using Google Cloud Storage and Google Cloud SQL

Containers: definition,
Kubernetes use case: presentation,
Google Kubernetes Engine features

Lab: Building and deploying containers with Google Kubernetes Engine

Google App Engine: presentation, features
Contributions of the App Engine environment
Google Cloud Endpoints

Workshop: Using Google App Engine

Host the source code of an application
Creation based on deployment models
Resource
management Monitoring and alert management

Workshop: Handling applications with Google Deployment Manager and Stackdriver

Big Data: presentation, use cases
Panorama of data warehouse operating solutions
Machine learning
Google Cloud Big Query: presentation, functionalities

Workshop: Manipulating data with Google BigQuery

Duration

1 day

Price

£ 850

Audience

System administrators - Developers

Prerequisites

Basic knowledge of Linux command line and web servers

Reference

CLO100679-F

Sessions

Contact us for more informations about session date

WordPress : Initiation + Advanced

Goals


- Create and manage a dynamic website or blog with the WordPress CMS

- Learn the main concepts of site administration

- Learn to customize a WordPress theme or template

- Know how to use wordpress templates

- Learn how to use and create plug-ins

Program

What is a CMS?
The main CMS
Principle and functioning of WordPress
History and version

The different tools required: web server, database, editor …
Update procedures
Define the title of your WordPress site
Create an administrator account

Practical workshop: installing WordPress on a web server

Navigation between public and private section
Presentation of the dashboard
Organization of administration menus
Difference between article and page

Manage articles: creation, modification, archiving
Presentation of WYSIWYG
Organize articles via categories
Assign categories to a menu
Add media: images, videos and audio
Schedule the publication of an article

Prohibit or allow comments
Put a comment on hold for moderation
Correct a comment
Consider a comment as unwanted
Protect yourself from spam comments

Create static pages
Manage multiple page levels
Define the visibility of a page
Use the WordPress text editor properly
Assign a page to a menu
Create a static home page

Practical workshop: publication and formatting of content

SEO constraints
Choose your keywords
Work well your text content
Refer your images

Customize the basic WordPress theme
Configure the header and menu
Define a background
Manage widgets: location, deactivation …

How to choose a good theme?
Download another theme via WordPress
Change the installed theme

Practical workshop: change of theme

Install a « Page Builder » extension
Understand how the grid works
Integrate a layout
Create layout templates

Create picture and video slideshows
Use custom fonts

Practical workshop: Install and test several extensions

Install a form extension
Create a contact form
Define validation criteria (mandatory field, correct e-mail …)
Consult the submissions made
Other types of form (newsletter subscription, request for quotation …)

Authorize the creation of a user account
Create registration and connection forms
Manage the members of your site

The information of a user account
The default roles of WordPress
Create additional roles
Offer a user to register on his WordPress site

Create a multilingual site
Implement a forum section to your site
Add special fields

Manage the backup of your WordPress site
Manage caching
Improve the loading time of pages and images
Check the health of the site

HTML5 / CSS reminders
Architecture of a WordPress theme
Presentation of the theme editor
Principle and advantage of child themes

Workshop: Create a child theme

 

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

Duration

5 days

Price

£ 2154

Audience

Webmasters, Integrators, Project managers

Prerequisites

Basic knowledge of HTML and website building, knowledge of PHP

Reference

OPE581-F

Sessions

Contact us for more informations about session date

AutoCAD 2D Initiation + Advanced

Goals


- Carry out a 2D plan, mechanical or architectural, by developing a drawing strategy according to the tools made available by AutoCAD

- Adapt these jobs to export them as a file or to a plotter

Program

History
Different uses and functionalities

Use the main Autocad formats: DWG / DWT, DXF, DWS, PNG and PDF

Use the menu bar
Use the ribbon
Work in the drawing area
Use the command line

Create a new document
Configure the workspace
Configure units and conventions
Define the limits of the drawing
Navigate into the drawing
Use the different selection modes
Adjust the grid and display
Use the magnetism of the grid
Use the markings: orthogonal / polar / object
Use object snaps

Work in abscissa and ordinate
Use the origin
Use absolute coordinates
Use relative coordinates 
Use relative / polar coordinates

Workshop: handling and familiarization exercises

Draw with line and polyline
Use the rectangle tool
Use the arc tool
Use the circle tool
Use the ellipse tool
Use the polygon tool
Use the xline and ray
Use the ring tool

Workshop: make small architectural elements or mechanical parts

Use the move function
Use the copy function
Use the offset function
Use the mirror function
Use the rotation function
Use the stretch function
Use the scale function
Use the trim / extend functions
Use the explode function

Workshop: make small architectural elements or mechanical parts

Understand the layers panel
Manage layer attributes
Use texts and text styles
Use dimensions, dimension styles and measurement tools
Use annotations
Use hatching
Create a .DWT template file

Workshop: carry out the layout plan of a building

Use model / paper space
Configure the page layout
Choose the plotter type and configure
Create rectangular or polygonal layouts
Control the presentation window scales
Create custom scales
Insert a title block

Workshop: layout and export in PDF presentations

Master the principles of arrays
Use the different arrays: polar, rectangular, along a path, associative array
Modify the columns and rows
Modify the source element
Explode an associative array

Workshop: realise drawings with each array tool

Create blocks
Modify blocks
Insert blocks
Use dynamic blocks
Master the different types of attributes
Define attributes
Modify attributes

Workshop: create dynamic and recurring blocks for a building : doors, double doors, windows

Master the principles of external references
Use the Xref management panel
Use information relating to files
Attach work / status files
Master the requirements related to paths
Modify files / status and update
Adjust the visible area of ​​files / delete it
Position the User Coordinate System based on the Xref

Workshop: Position the house in the external reference and orient it in relation to the plot

Master model and presentation spaces
Use the presentation ribbon
Configure a document
Configure presentations
Create a title block with variables and constants
Export files
Print with plotter

Workshop: make a layout with title blocks

Duration

5 days

Price

£ 1175

Audience

Everyone

Prerequisites

Mastery of the PC environment
Basic knowledge of technical drawings

Reference

CAO199-F

Sessions

Contact us for more informations about session date

Good office location. The course totally met my expectations. The training met my expectations and even beyond. Very good pedagogy, listening knows how to adapt. Very good relationship with high trainer, the training is pleasant and goes all at once.
Joel S.
Joel S.
Very clean premises Equipment in good working order Good organization, and good logic in discovering Autocad's functionalities. Discovery of orders in line with my needs (architectural plans). Trainer: Good pedagogy.
Ahmed E.
Ahmed E.
Very good working environment, very welcoming team Very good training for an initiation and first handling but not enough advanced for my demand for perfection in drawing (designer training?) The training is more a training of handling and discovery of the software. I think I was at the wrong level, I thought more training on clean drawing rather than software discovery Very good patient trainer who takes the time to interest everyone. very welcoming and available!
Thibault G.
Thibault G.
The working conditions are very comfortable. Discovering for the first time the content "Autocad", the technicality of the software induces a condensed and rhythmic program which makes it difficult to follow the courses. / The quality of the trainer is indisputable. He juggles according to these possibilities between the program to be transmitted to the trainees and the additional time to be devoted to additional explanations. New to "Autocad", an additional day will have favored better learning conditions. This program is intended above all for informed people.
Lionel D.
Lionel D.
Perfect individual equipment, bright and spacious classroom, few trainees, therefore very good conditions. The sustained pace was very good since it allowed us to learn about the many possibilities, and that afterwards we can automate certain practices. The trainer responded to each of our requests, without exception, while remaining very well organized and cordial. I had a good experience, a little stressful at the time but already profitable.
Maryse B.
Maryse B.
Précédent
Suivant

Zend Framework 2 : Initiation

Goals


- Know the possibilities and alternatives to Zend Framework 2

- Be able to plan, implement, maintain an application using Zend Framework 2

Program

Presentation, version
Principle of a Framework
Installation, general organization
Reminder 5.3, namespace
Composer
Zend skeleton

Workshop: Download and install Zend skeleton

Architecture of a zf2 project Naming
rules
MVC modules and models
Configure a module and the application
Route the pages of the application
Communication controllers and views

Workshop: Create the first pages of the application

Example of a simple isolated component, Zend \ Barcode
Use Zend \ Config for project configuration
Practice debugging and handling various errors, including Zend \ Log and Zend \ Exceptions
Organize other needs in the site: Zend \ Helper

Workshop: Using multiple components

Use Zend \ Navigation for menus and similar elements
Setting up the service manager
Using view helpers

Workshop: Create a general navigation, a breadcrumb and a sitemap

Setting up the service manager
Setting up a translation file
Translate the output strings

Workshop: Translate our application

Set up a Form
Use the Form class associated with the forms
Add form tags
Insert a captcha
Set up a validation model
Translate the
HelperView data to display the form

Workshop: Realization of a contact form with Zend \ Mail

Connect to the database (local, global)
Use PDO to any type of server
Setting up a Model
Using service_manager

Workshop: Store, modify and delete database data
from the interface.

Duration

3 days

Price

£ 1937

Audience

Experienced PHP developers

Prerequisites

Proficiency in PHP, from syntax to object-oriented programming

Reference

PHP765-F

Sessions

Contact us for more informations about session date

Zend Framework 2 : Initiation + Advanced

Goals


- Know the possibilities and alternatives to Zend Framework 2

- Be able to plan, implement, maintain an application using Zend Framework 2

Program

Presentation, version
Principle of a Framework
Installation, general organization
Reminder 5.3, namespace
Composer
Zend skeleton

Workshop: Download and install Zend skeleton

Architecture of a zf2 project Naming
rules
MVC modules and models
Configure a module and the application
Route the pages of the application
Communication controllers and views

Workshop: Create the first pages of the application

Example of a simple isolated component, Zend \ Barcode
Use Zend \ Config for project configuration
Practice debugging and handling various errors, including Zend \ Log and Zend \ Exceptions
Organize other needs in the site: Zend \ Helper

Workshop: Using multiple components

Use Zend \ Navigation for menus and similar elements
Setting up the service manager
Using view helpers

Workshop: Create a general navigation, a breadcrumb and a sitemap

Setting up the service manager
Setting up a translation file
Translate the output strings

Workshop: Translate our application

Set up a Form
Use the Form class associated with the forms
Add form tags
Insert a captcha
Set up a validation model
Translate the
HelperView data to display the form

Workshop: Realization of a contact form with Zend \ Mail

Connect to the database (local, global)
Use PDO to any type of server
Setting up a Model
Using service_manager

Workshop 1: Store, modify and delete database data
from the interface.

Workshop 2: Create a pagination

Identification from a database
Encrypt data
Error
handling Store data
Disconnect and destroy data (Zend \ Session)

Workshop: Create an identification form

Define roles
Define resources
Define rights

Workshop: Associating rights with a user

Declaration and use of web services: REST and JSON
WS- * Web services: DOM, SOAP 

Workshop: Using Zend \ SOAP or Zend \ REST

Duration

5 days

Price

£ 2607

Audience

Experienced PHP developers

Prerequisites

Proficiency in PHP, from syntax to object-oriented programming

Reference

PHP763-F

Sessions

Contact us for more informations about session date

ZWCAD 2D: Initiation and Advanced

Goals


- Carry out a 2D plan, mechanical or architectural, by developing a drawing strategy according to the tools made available by zwcad.

- Adapt these jobs to export them as a file or to a plotter

Program

Presentation of the main graphic formats: The formats: .DWG / .DWT, DXF, PNG, PDF.

The menu bar
The Ribbon  
The
command line graphics area

Creation of a new document
The workspace
Configuration of units and conventions
Definition of the limits of the work plane
Navigation in the work plane
Operation of the selection modes
Adjustment of the grid and display
Resolve mode: grid magnetism Registration
: Orthogonal / Polar / Object
Hanging of objects

The abscissa and the ordinate
Origin
Absolute
Cartesian
coordinates Relative Cartesian coordinates Relative / polar Cartesian coordinates

Workshops: each type of coordinate is the subject of several handling and familiarization exercises.

Line and polyline (workshop)
Rectangle (workshop)
Arc (workshop)
Circle (workshop)
Ellipse (workshop)
Polygon (workshop)

The above drawing workshops correspond to the production of small architectural elements or mechanical parts.

Move (workshop)
Copy (workshop)
Offset (workshop)
Symmetry (workshop)
Rotation (workshop)
Stretch (workshop)
Scale (workshop)
Adjust / extend (workshop)
Decomposition (workshop)

The above modification workshops correspond to the production of small architectural elements or mechanical parts.

Presentation of the layer panel
Layers attributes
Texts and text styles
Dimensions, dimension styles and measurement tools
Annotations
Hatching
Creation of a template file .dwt

Workshop: realization of an implantation plan of a house as well as its ground floor of the road.

Principle of the use of networks
Presentation of the different networks:
Polar
network Rectangular network

Workshops: production of drawings using these different networks

Creation of blocks
Modification of blocks
Insertion of blocks

Workshop: creation of the recurring elements of the house drawn in the previous step – doors, double doors, windows, etc.

Principle of external references (dwg, jpeg or tif)
Xref management panel File
information
Attach work / status files
Path requirements
Modification of one of the files / status and update
Position the User coordinate system depending on the Xref

Object space and presentation space Presentation
ribbon
Document
configuration Presentation configuration
Exports in files
Plotter prints

Workshop: Layout of the plans made in the previous steps

Duration

5 days

Price

£ 2114

Audience

Engineers, Draftsmen

Prerequisites

Mastery of the PC environment. Notions of technical drawings

Reference

CAO100873-F

Sessions

Contact us for more informations about session date