Word: Advanced + VBA Macros

Goals


- Have an in-depth use of Word

- Work with reference tables

- Make a mail merge

- Discover programming via VBA

- Use Word VBA objects

Program

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).

Duration

4 days

Price

£ 2495

Audience

Word users

Prerequisites

Have followed the « Word: Initiation » course or have equivalent knowledge

Reference

BUR1145-F

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: Advanced

Goals


- Have an in-depth use of Word

- Work with reference tables

- Conduct a mail merge

Program

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).

Duration

2 days

Price

£ 2495

Audience

Word users

Prerequisites

Have followed the « Word: Initiation » course or have equivalent knowledge

Reference

BUR1144-F

Sessions

Contact us for more informations about session date

2013 : Advanced Solutions for Microsoft SharePoint Server 2013 (Course MS20332 – Exam 70-332)

Goals


- Describe the main features of SharePoint 2013

- Plan and design a SharePoint Server 2013 environment

- Plan and configure social networking features

- Manage solutions in a SharePoint 2013 deployment

Program

Main components of the SharePoint 2013 architecture
New features in SharePoint 2013
Introducing SharePoint Server 2013 and SharePoint Online

Practical workshops: Review the main concepts of SharePoint 

Design database topologies for high availability and
disaster recovery Design SharePoint infrastructure for high availability
Plan for disaster recovery

Practical Workshops: Plan and execute backups and restores

Plan application services
Design and configure a service application topology
Configure service application federation

Practical workshops: Planning an application service – Federating application services between SharePoint Server Farms

Plan and configure BCS connectivity services
Configure the « Secure information store » service
Manage BDC (Business Data Connectivity) models

Practical workshops: Configure BCS and the « Secure information bank » service – Manage BDC models

Manage user profiles
Activate social interactions
Create communities

Practical workshops: Configure profile synchronization and « My Sites » – Configure the community of sites

Aggregate Tasks
Plan and Configure Collaboration Features
Plan and Configure Composite Features

Practical Workshops: Configure « Project sites » and the workflow

Plan Business Intelligence
Plan, deploy and manage Business Intelligence services
Plan and configure advanced analysis tools

Practical workshops: Configure Excel services – Configure PowerPivot and Power View for SharePoint

Configure search for an enterprise environment
Configure the search experience
Optimize search

Practical Workshops: Planning an Enterprise Search Deployment – Managing Search Relevance in SharePoint Server 2013

Duration

5 days

Price

£ 2134

Audience

IT professionals responsible for the installation, configuration, deployment and management of SharePoint Server 2013

Prerequisites

Have followed the training « Course MS20331)

Experience required in the management of Microsoft Windows 2008 R2 or Windows Server 2012

Reference

WIN1197-F

Plan content management
Plan and configure content discovery (eDiscovery)
Plan records management

Practical Workshops: Configure eDiscovery in SharePoint Server 2013 – Configure Records Management in SharePoint Server 2013

Plan and implement the web content management infrastructure
Configure navigation and catalog sites
Support multiple languages ​​and localization
Enable design and customization
Support mobile users

Practical workshops: Configure browsing and catalog sites – Configure device channels

Understand the architecture of SharePoint solutions
Manage « sandbox » solutions

Practical workshops: Managing solutions

Understand the architecture of SharePoint Apps
Provide and manage Apps and application catalogs

Practical workshops: Configure and manage SharePoint applications

Introduction to planning governance
Key elements of a governance plan
Plan governance in SharePoint Server 2013
Implement governance in SharePoint Server 2013

Practical workshops: Develop a plan for governance – Manage the creation and deletion of site

Prepare for the update and migration environment
Implement the update process
Manage site collection updates

Sessions

Contact us for more informations about session date

2013 : Developing Advanced Solutions for Microsoft SharePoint Server 2013 (Course MS20489 – Exam 70-489)

Goals


- Describe the main features of SharePoint 2013

- Plan and design a SharePoint Server 2013 environment that meets high availability and disaster recovery requirements

- Plan and implement a service application architecture for the deployment of SharePoint 2013

- Configure and manage Apps in a SharePoint Server 2013 environment

Program

Main components of the SharePoint 2013 architecture
New features in SharePoint 2013
Introducing SharePoint Server 2013 and SharePoint Online

Practical Workshops: SharePoint Concepts Basics Exam – Configuring SharePoint Server 2013 Farms – Creating and Configuring Site Collections and Sites

Design database topologies for high availability and
disaster recovery Design SharePoint infrastructure for high availability
Plan for disaster recovery

Practical workshops: Planning and performing backups and restores – Create a backup and restore plan – Test the backup and restore process

Plan application services
Design and configure a service application topology
Configure service application federation

Practical Workshops: Federating Applications Services between SharePoint Server farms – Planning an application service topology – Creating an application service instance – Establishing trust relationships between SharePoint Farms – Publishing and consuming service applications – Planning an application service architecture

Plan and configure BCS connectivity services
Configure the « Secure information store » service
Manage BDC (Business Data Connectivity) models

Practical workshops: BCS configuration and the Secure Information Store Service – Configuration of the business data connectivity service application – Configuration of the secure Information Store service – Configuration of a Target Application secure service store – Import and configuration of BDC models – Business Connectivity data model management

Manage user profiles
Activate social interactions
Create communities

Practical workshops: Configuration of a synchronization profile and My Sites – Configuration of the synchronization of a profile – My Sites configuration – Creation of a community infrastructure for the site – Configuration of the community participation of the site – Configuration of community sites

Aggregate Tasks
Plan and Configure Collaboration Features
Plan and Configure Composite Features

Practical workshops: Configuration of project sites – Creation of project sites – Configuration of project sites – Engage project teams – Configure Windows Azure Workflow and SharePoint Workflow Services – Create and test a workflow – Configure workflows

Plan Business Intelligence   
Plan, deploy and manage Business Intelligence services
Plan and configure advanced analysis tools

Practical Workshops: Configuration Excel Services – Provisioning Excel Services – Configuration of external data access – Configuration of data links – Configuration of PowerPivot for SharePoint – Configuration of Power View for SharePoint – Configuration of PowerPivot and Power View for SharePoint

Configure search for an enterprise environment
Configure the search experience
Optimize search

Practical workshops: Planning an Enterprise Search deployment – Planning a search solution – Configuration of a Thesaurus – Configuration of extractors and refiners – Configuration of spelling correction queries – Configuration Company name Extraction – Manage the relevance of searches in SharePoint Server 2013

Plan content management
Plan and configure content discovery (eDiscovery)
Plan records management

Practical Workshops: Configuring document management in SharePoint Server 2013 – Creating and configuring an eDiscovery center – Discovering and preserving content – Querying and exporting content – Configuring in place case management – Configuring eDiscovery in SharePoint Server 2013

Plan and implement the web content management infrastructure
Configure navigation and catalog sites
Support multiple languages ​​and localization
Enable design and customization
Support mobile users

Practical workshops: Configuration of browsing sites and Managed Catalog – Configuration of product catalog sites – Configuration of Cross-Site publication – Configuration of publish sites – Configuration of device channels – Configuration of device channels

Understand the architecture of SharePoint solutions
Manage « sandbox » solutions

Practical Workshops: Solution Management – Configuration of management of sandboxed solutions at farm level – Configuration of management of sandboxed solutions at site collection level – Deployment of Agricultural solutions

Duration

5 days

Price

£ 2134

Audience

IT professionals responsible for installing, configuring, deploying and managing SharePoint Server 2013 in a datacenter or in the cloud

Prerequisites

Have followed the training « The main solutions of Microsoft SharePoint Server 2013 »

Good experience in analyzing business needs for the implementation of a logical and physical design

Good experience in managing Microsoft Windows 2008 R2 or Windows Server 2012 and knowledge of IIS, security, configuration of Active Directory, management of remote applications with Windows PowerShell 2.0 as well as applications connected to SQL Server

Reference

WIN1098-F

Understand the architecture of SharePoint Apps
Provide and manage Apps and application catalogs

Practical Workshops: Configuring and managing SharePoint applications – Configuring a SharePoint server farm to support applications – Creating and configuring an enterprise application catalog – Deploying and monitoring Applications

Introduction to planning governance
Key elements of a governance plan
Plan governance in SharePoint Server 2013
Implement governance in SharePoint Server 2013

Practical workshops: Manage the creation of sites and deletion – Creation of a governance plan – Creation and policies of Publishing Site – Activation and self-service management Site creation – Development of a plan for governance

Prepare for the update and migration environment
Implement the update process
Manage site collection updates

Practical workshops: Realization of a database extension -Attach – Import the SharePoint 2010 Databases – Migration and upgrade of a service application – Migration and upgrade of a content database – Preparing Collections for site upgrade – Upgrading site collections – Managing upgraded site collections

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

VBA: Advanced

Goals


- Communication Excel / Access

- Introduce yourself to SQL languages ​​and the ADO model

Program

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

2 days

Price

£ 2495

Audience

All

Prerequisites

Have taken the VBA Initiation course or have equivalent knowledge

Reference

BUR403-F

Sessions

Contact us for more informations about session date

Advanced iPhone / iPad with Objective-C

Goals


- Master the development of mobile applications on iPhone / iPad

Program

Reminders on iPhone / iPad development
Recurring problems, memory leaks Memory
management in a
Profiling application : Shark,
Panorama Instruments of advanced view controllers: Split View Controllers, Popovers, …
Advanced functions: mail, RSS feed, synchronization of threads

Workshop: Application Profiling – Using advanced controllers and functions

Presentation, APIs available Basic
concepts
Animations

Workshop: Integration of OpenGL animations in an application

Reminders of persistence methods: Xml, JSON
Structures CoreData
Access to SQLLite databases

Workshop: Access and storage of database data

Access to terminal information Certificates Management of notifications Management of updates
Optimizations

Workshop: Creation and management of notifications, access to the address book, optimizations

Duration

3 days

Price

£ 1922

Audience

IPhone / iPad application developers

Prerequisites

Have followed the iPhone / iPad training or equivalent knowledge

Reference

DEV623-F

Sessions

Contact us for more informations about session date

Advanced iPhone / iPad – iOS application development with Swift and COCOA

Goals


- Learn to use advanced features

- Manage notifications - Use sqlite with Core Data

- Introduce graphical tools (Sprite Kit, Metal)

Program

Operation reminder
Reorder cells
Delete data
Update data with a pull to refresh
Add a search field

Workshop: Create an editable TableView

Custom section
header and footer Add an image in the section header
Parallax effect
Create
custom cells Multiple custom view cell

Workshop: Create a TableView with several cells and custom header

Access the camera
Authorize access to the photos
Select a photo in the library
The delegate’s methods
Save the photos in the library

Workshop: Take a photo from the camera

Presentation of Core Data
Create a Core Data project
Create entities
Manage attributes and relationships
Import CoreData
Retrieve the context and the ManagedObject
Modify the values ​​of an entity
Save the data

Workshop: Backing up data with Core Data

The advantages of Multi Threading
The NSThread, NSOperation classes
Description of the Grand Central Dispatch
Asynchronous functions
The NSURLSession classes
The Resume , cancel, suspend methods

Workshop: Create a data upload system

Presentation of touchID
Import Local Authentication
Retrieve the context, manage errors
Test device compatibility
Manage authentication

Workshop: Using TouchID to Validate Data

Rotation, Pinch, Swipe
Single, long and multiple
touch Attach a movement to a graphic object

Workshop: Associate touch management with an image

Presentation of the notification tools
Understand how notifications work
Configure the push system
APN notification in JSON format
Local notification

Workshop: Add notifications to a project

The basic properties: backgroundColor, borderWith, borderColor, opacity, etc.
Associate a Layer to a View
Add and position an image
Display a portion of an image with CAScrollLayer
Customize a text (size, font, color) with CATextLayer
Make a drawing in 3D with CATransformLayer
Managing the asynchronous loading of an image with CATiledLayer

Workshop: Realize several examples to present the CALayer

Presentation of Core Graphics, Quartz 2D
The classes of Core Graphics: CGRect, CGSize, CGPoint Getting
the context Core Graphic
The methods drawRect (_ :), setNeedsDisplay (), setNeedsDisplayInRect
Use the class UIBezierPath ()
Best practices

Workshop: Draw a gauge

Introduction to Sprite Kit
Introduction to Metal

Duration

3 days

Price

£ 2547

Audience

IOS Developer Swift

Prerequisites

- Have taken the iPhone / Ipad training course
- iOS application development with Swift and COCOA

Reference

DEV100028-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

Excel : Advanced+ VBA Macros

Goals


- Be able to perform calculations and use formulas

- Know how to handle graphs and pivot tables

Program

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

3 days

Price

£ 2495

Audience

Excel users

Prerequisites

Have followed the course « Excel: Initiation » or have equivalent knowledge

Reference

BUR1148-F

Sessions

Contact us for more informations about session date

Exchange 2013 : Advanced Solutions (Course MS20342 – Exam 70-342)

Goals


- Design and implement Exchange Server 2013 unified messaging

- Design and implement site resiliency for Exchange Server 2013

- Plan a virtualization strategy for Exchange Server 2013 roles

- Design and implement message transport security

- Design and implement message retention in Exchange Server 2013

- Design and implement message compliance

- Design and implement administrative security in an Exchange Server 2013 environment

- Use Windows PowerShell 3.0 to manage Exchange Server 2013

- Design and implement integration with Exchange online

- Design and implement messaging coexistence

- Design and implement Exchange Server migrations from other messaging systems and updates up to date from previous versions of Exchange Server

Program

Overview of
Unified Messaging Telephony Technologies in Exchange Server 2013
The Components of Unified Messaging

Practical Workshop: Unified Messaging Overview – Identifying Unified Messaging Components 

Design the Unified Messaging Deployment
Deploy and Configure Unified Messaging Components
Integrate Exchange Server 2013 Unified Messaging with Lync

Practical Workshops: Designing and Implementing Exchange Server 2013 Unified Messaging – Designing the Unified Messaging Implementation – Configuring Unified Messaging Features – Configuring Unified Messaging Integration with Lync Server 2013

Site Resilience in Exchange Server 2013
Plan to Implement Site Resilience
Implement Site Resilience

Practical workshops: Design and implementation of site resilience – Design of a resilient solution for the site – Implementation of site resilience – Validation of resilience 

Hyper-V 3.0 Overview
Virtualize Server Roles

Practical Workshops: Planning Exchange Server Role Virtualization – Designing an Exchange Server 2013 Deployment for a Large Organization – Designing an Exchange Server 2013 Deployment for a Medium Organization – Designing an Exchange Server 2013 Deployment for a medium complex organization

Overview of Policy and Compliance Needs
Design and Implement Transport Compliance
Design and Implement AD RMS Integration with Exchange Server 2013

Practical Workshops: Designing and implementing message transport security – Planning a message transport implementation – Implementing message transport security – Implementing AD RMS and Exchange Server integration 

Manage message recordings and archiving overview
Design in-place archiving
Design and implement message retention

Practical Workshops: Design and implementation of message retention

Duration

5 days

Price

£ 2134

Audience

Email administrators, IT professionals and Help Desk professionals

Prerequisites

Experience required in network administration, Help-Desk and system administration

Good experience on Exchange Server 2013 or on previous versions of Exchange

Reference

WIN1078-F

Design and implement prevention against data loss
Design and implement management of legal registration
Design and implement legal research

Practical workshops: Design and compliance of messaging – Implementation of data loss prevention – The messaging policy comparison and compliance of options 

Design and implement RBAC role-based access control
Design and implement permission sharing
Plan and implement audit logging

Practical workshops: Design and implementation of administrative security and audit – Design of a solution to meet the requirements – Implementation of role-based access control – Implementation of access to the box letters and administrative logging

Power Shell 3.0 Overview
Use the Exchange Management Shell to Manage Exchange Server Recipients
Manage Exchange Server 2013 with the Exchange Management Shell

Practical Workshops: Managing Exchange Server 2013 and Exchange Management Shell – Exploring the Exchange Management Shell – Using the Exchange Management Shell to Manage Recipients 

Plan Exchange Online
Plan and implement the Exchange Online migration
Plan for coexistence with Exchange Online

Practical Workshops: Designing the integration with Exchange Online – Designing and implementing the integration with Exchange Online

Design and implement federation
Design coexistence between Exchange organizations
Design and implement mailbox movement across forests

Practical Workshops: Implementation of coexistence messaging – Implementation of Coexistence message routing – Migration of user mailboxes – Configuration of administrative coexistence 

Design migration from non-Exchange messaging systems
Plan to update from previous versions of Exchange
Implement migration from previous versions of Exchange

Practical Workshops: Designing and Implementing Exchange Server Migrations – Planning the Migration Strategy – Deploying Exchange Server 2013 to an Exchange 2007 Organization Server – Migrating All Mail Components to Exchange Server 2013 – Removing the Exchange Server 2007 

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

Excel : Advanced

Goals


- Be able to perform calculations and use formulas

- Know how to handle graphs and pivot tables

Program

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

Use formulas in Excel

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

Use formula audit tools

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

2 days

Price

£ 2495

Audience

Excel users

Prerequisites

Have followed the course « Excel: Initiation » or have equivalent knowledge

Reference

BUR1228-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 : Advanced

Goals


- To know how to make complete data backups in an Android application

- To be able to create the interface for modifying this data

- To know the techniques of connection to a third-party server.

Program

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

2 days

Price

£ 1092

Audience

All

Prerequisites

Have followed the Kotlin Android Initiation training or have equivalent knowledge

Reference

DEV100526-F

Sessions

Contact us for more informations about session date

Agile Scrum : Advanced

Goals


- Master the management of agile projects with the Scrum method

Program

Lifecycle of a Scrum project
  Roles defined by Scrum: Product Owner, Scrum Master, Team
  Time boxes: Sprint planning, Sprint Review, Sprint Retrospective, Daily Scrum

Serious Game: Distribution of tasks by role

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

2 days

Price

£ 1255

Audience

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

Prerequisites

Agile project management concepts

Reference

Mé100282-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

Advanced Android : Multimedia, video, sound, 2D, 3D

Goals


- Be able to use all graphics and sound solutions on an Android device

Program

Current state of technology
Presentation of the medium and embedded devices of Android
Versions, evolutions; emulator possibilities

Controls and activities available
Embedding sounds and videos
Sound: effects, transformation, generations

Practical workshop: an artistic application

Draw, Paints, Fonts, Colors
Transformations; feedback on the animations

Practical workshop: a diagram activity

Presentation of the standard, limits
Some ready-to-use engines
Summary of 3d, matrices, projection, light effects
Creation of a scene, import of objects
Lighting, camera and movements

Practical workshop: 3D presentation of an architecture

Widgets for display on the home
screen Live wallpapers
Manifesto: various groupings of applications

Practical workshop: a package of multiple applications

Duration

3 days

Price

£ 2120

Audience

All

Prerequisites

Have followed the Android initiation training or have equivalent knowledge

Reference

DEV485-F

Sessions

Contact us for more informations about session date

Advanced Android : Specific applications for tablets

Goals


- To be able to create a specific application for Android tablet, or to adapt an existing one

Program

State of the art, available and future equipment
Other special peripherals
Android versions concerned
The emulator for tablets
Various Android reminders

Honeycomb, Ice Cream Sandwich …: special graphic environment
Separation of resources between phone and tablet
The new Action Bar
Various graphic elements to be modified; the fragments
What to say to the graphic designer

Practical workshop: an application in multiple versions

Distinction between tablets from the Java code Missing
peripherals: taken into account
Specific devices for tablets, about USB

Practical workshop: improving the application

Duration

2 days

Price

£ 1494

Audience

All

Prerequisites

Have followed the Android initiation training or have equivalent knowledge

Reference

DEV488-F

Sessions

Contact us for more informations about session date

Advanced Android : Creating Complex Applications

Goals


- To be able to create applications with a complex structure in Android

- To know how to use third-party libraries in an Android application

Program

Reminders on the types of contexts
General principles of parallelism

Services, alarms and notifications – broadcast receiver
Various system services: notable points
Multithreading under Android: thread, handler, asynchronous tasks
Interest and method of creation of
AIDL services and services

Practical workshop: control and alarm service in one application

Hands-on workshop: scroll bar during a long task

Assessment of contexts (activity, service, content provider, contexts for broadcast receivers), and their relationship with multithreading: how to organize an application

Sensors, various connectors (battery, acceleration, bluetooth, NFC, …)
Location services (GPS, WiFi); emulator simulation
Add additional
API Maps and MapView library

Practical workshop: Google Maps in an application, with custom layers

Duration

3 days

Price

£ 2120

Audience

All

Prerequisites

Have followed the Android initiation training or have equivalent knowledge

Reference

DEV486-F

Sessions

Contact us for more informations about session date

Advanced Android : Annotations, ORM Framework, Tests, Network Management

Goals


- Improve productivity

- Optimize Android applications using the libraries provided by Google '' Make Android applications more reliable by setting up automated tests

Program

Presentation of the MVVM model: Model-View-ViewModel
Data binding: layouts, events, observable objects
Contribution of annotations in the Java code
Presentation of existing annotations for Android
Annotation framework for Android: AndroidAnnotations

Workshop: create an application using data-binding and annotations

Presentation of the principle of Object-Relational mapping
Integration of the Room library in an Android application
Realization of entity mapping: id, index, foreign keys, link between objects
Presentation of the DAO pattern: Data Access Object
Access to data via Room DAOs: CRUD
Simple queries, passing parameters, observable queries

Workshop: implementation of an ORM solution on an Android application

Presentation of network access in Android: advantages, disadvantages
Integration of the Volley library in an Android application
Volley’s operating principle: queue, requests, callback, fallback

Workshop: Access to an opendata service using the Volley library

Presentation of tests: unit tests, instrumentation tests
Presentation of Junit: use of assertions, generation of test classes
Presentation of the Espresso framework
Access to components
Carry out actions
Verification of results
Presentation of ADB to write automated test scripts

Workshop: Writing unit test classes and instrumentation tests, creation of test execution scripts

Duration

5 days

Price

£ 2548

Audience

Android Developers

Prerequisites

Mastery of Java, have Android development experience or have followed the Android Initiation / Deepening training

Reference

DEV100324-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 Advanced

Goals


- Learn how to configure IIS for HTTPS, FTP, SMTP

- Solve problems, improve IIS performance

Program

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

Duration

1 day

Price

£ 757

Audience

System administrators with good knowledge of IIS

Prerequisites

Have followed the initiation to IIS

Reference

WIN229-F

Sessions

Contact us for more informations about session date

Android : Advanced

Goals


- To know how to make complete data backups in an Android application

- To be able to create the interface for modifying this data

- To know the techniques of connection to a third-party server.

Program

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

2 days

Price

£ 1280

Audience

All

Prerequisites

Have followed the Android Initiation training or have equivalent knowledge

Reference

DEV484-F

Sessions

Contact us for more informations about session date

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

SolidWorks: Advanced Assembly Modeling

Goals


- Discover advanced assembly modeling methods

Program

Top-down assembly modeling
Steps in the process
Building virtual parts
Building parts in an assembly
Functions in context
Propagating changes
Saving virtual parts as external parts External
references
Breaking external references
Deleting external references

Assembly and Smart Fasteners
Steps in the process
of assembly features
intelligent fasteners

Advanced Constraints
Add Constraint References
Design Library Parts
Capture Constraint References
Smart Components
Mechanical and Advanced Constraint Types
Summary: Inserting and Applying Constraints to Components
Multiple Constraint Mode
Using Copy with Constraints
Options constraint

Using Configurations with Assemblies
Steps in the Process
Repeating Components
Configuration Properties
Using the Configure Component Feature
Creating Configurations Manually
Configuration Publisher

Display States
Bulk Selection Tools
Advanced Selection
Envelopes
Appearances, Materials, and Scenes

Modifying an assembly
Key
topics Modifying activities
Replacing and modifying components
Troubleshooting an assembly
Replacing components with the Save As command
Using symmetry on components
Aligning holes
Checking dimensions in an assembly
Sensors

schematic
Design of assemblies based on a schematic representation
Key
topics Blocks
Insertion of blocks
Creation of a part from a block

Large Assemblies
Key Topics Lightweight
Components Large
Assembly Mode
Selective Open and Hide
Using Quick View / Selective Open
Using SpeedPak
Using Configurations with Large Assemblies
Modifying the Structure of an Assembly
Viewing Assemblies
Tips for Designing Assemblies
Faster Considerations in terms of drawings

Duration

2 days

Price

£ 1000

Audience

Draftsmen – Engineers

Prerequisites

Basics of Solidworks

Reference

CAO974-F

Sessions

Contact us for more informations about session date

SolidWorks: Advanced Surface Modeling

Goals


- Discover advanced modeling techniques

Program

Chapter 1: How Surfaces Work

Solids and Surfaces
Working with Surface Bodies
Why Use Surfaces?
Continuity – information and explanation
Operations with surfaces

Chapter 2: Introduction to area management

Similarities Between Surface and Solid Modeling Surface
Management – Fundamentals

Chapter 3: Hybrid Solid-Surface Modeling

Hybrid Modeling
Use Surfaces to Modify Solids
Swap Solids and Surfaces
Performance Implications
Using Surfaces as Construction Geometry
Make Copies of Faces

Chapter 4: Repairing and Modifying Imported Geometry

Import data
Repair and modify imported geometry

Chapter 5: Modeling advanced surfaces

Ruled surfaces
Surface smoothness Filled surface
Conclusion
Design changes

Chapter 6: Connections and fittings

Complex
blends Smoothing of blends
Boundary surface
Free-form function
Corner blends

Duration

2 days

Price

£ 1000

Audience

Everyone

Prerequisites

Basics of Solidworks

Reference

CAO969-F

Sessions

Contact us for more informations about session date

SolidWorks: Advanced Part Modeling

Goals


- Discover advanced part modeling methods

Program

Multibody Solids
Blend
Introduction: Folder Solid Bodies
Extrude from
Localized Operations
Combined Bodies
Introduction: Combine
Frequently Used
Bodies Tool Body
Introduction: Insert Part
Introduction: Move / Copy Bodies
Introduction: Constraint Reference
Repetitions
Indent Function
Use the section functionality to create multiple bodies
Save solid bodies as parts and assemblies
Introduction: Insertion in new part
Action area of ​​the function
Introduction: Save bodies
Split a part into multiple bodies
Introduction: Split
Create an assembly
Introduction: Create an assembly
Use Explode part with data from previous versions

Introduction
Sweep


Case Study: Modeling a Spring
Sweep on a 3D
Path 3D Sketch
Introduction: Helix and Spiral
Introduction: Projected Curve
Introduction: Composite Curve
Introduction: Sweep
Introduction: Fit the Spline


Case Study: Bottle
Sweep and Smooth: What is the difference ?
Create a curve from a set of points
Introduction: Insert an ellipse
Sweep options Sweep
with guide curves
Label shape
Work with a non-planar path
Variable radius fillet
Introduction: Separation lines
Geometry Analysis
Introduction: Show Curvature
Introduction: Show Curvature Fields
Introduction: Intersection Curve
Introduction: Zebra
Rounding Label Contour
Select Edges
Introduction: Select Loop
Performance Considerations
Modeling of threads
Orientation / torsion control
Align with end surfaces
Sweep along model edges
Introduction: SelectionManager
Sweep tool body

Smoothing Basics
Introduction: Smoothing
Using Copied and Derived Sketches
Copy
Sketch Derived Sketches
Introduction: Insert Derived Sketch
Lofting with centerline
Introduction: Split entities
Clean up a model
Introduction: Remove face
Introduction: Analyze the deviation
Sketch splines
Introduction: Spline
Advanced smoothing
Introduction:
Sketch image Schematic representation sketches
Boundary function

Advanced fillet
function Wrap function
Introduction: Wrap Introduction:
Curves driven by an equation
Deformation function
Introduction: Stitched surface
Move / delete a face
Introduction: Move face
Use 3D Sketch with Hole Wizard

Duration

2 days

Price

£ 1000

Audience

Draftsmen – Engineers

Prerequisites

Good knowledge of Solidworks

Reference

CAO982-F

Sessions

Contact us for more informations about session date

SolidWorks Advanced

Goals


- Discover the advanced features of Solidworks

Program

Modeling in the context of a parameterized assembly 

3D sketches
Creation of wireframe skeletons
Mechanically welded elements
Creation of personalized profiles / libraries of personalized profiles

Equations
Configuration of parts
Families of parts

Smart fasteners
Library functions
Creating smart components

Sheet metal sketches Sheet metal
function
Using and creating sheet metal punches
DXF generation for unfolding and cutting 

Cartridge settings and nomenclatures

Duration

3 days

Price

£ 1510

Audience

Everyone

Prerequisites

Have basic knowledge of Solidwords

Reference

CAO979-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

Powershell Advanced

Goals


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

Program

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)

Duration

2 days

Price

£ 1303

Audience

Administrators, Developers

Prerequisites

Basic knowledge of Windows Server administration

Reference

WIN524-F

Sessions

Contact us for more informations about session date

Autocad LT 2D Advanced (ACN Atlas)

Goals


- Learn to master the advanced techniques of AutoCAD in 2D

- Use sheet sets, share and archive projects

- Learn by doing with two practical cases

Program

Reminders on the principles of CAD
Know the native file formats of AutoCAD: .DWG / .DWT, DXE, DXF, DWS and PNG, PDF
Understand the stakes of vector
Customize the interface (single or dual screens)

Understand network tools prior to associative networks
Use associative networks: polar / rectangular / along a path
Modify columns and rows
Modify the source element
Explode an associative network

Workshop: produce several drawings using these different networks

Reminders on the layer panel
Understand layer attributes
Manage texts and text styles
Manage dimensions, dimension styles and measurement tools
Use nnotations 
Use hatching
Modifiy hatching

Navigate in the layers:
   Define the current object’s layer
   Transfer an object to another object’s layer
   Return to the previous layer
Freeze or deactivate a layer according to objects
Browse the layers
State of the layers:
   Create new layer states
   Modify click states
Create a group filter
Create a layer state according to the filter
Manage and modify layer states
Manage properties of the layers to restore
Import / Export layer states
Create filter by group:
   Add / remove layers
   Impact in the drop-down menu
Filter creation by properties:
   Add / remove layers
   Impact in the drop-down menu
Purge commands
Search per keywords

Create a .dwt template file
Understand objects that can be included in a drawing template:
   Layer attributes
   Text styles
   Dimension styles
   Line types
   Blocks
   Presentations
   Views and UCS
Develop a drawing template

Workshop: create and develop a work environment in DWT

Reminders on the creation of blocks
Modify blocks
Insert blocks
Create dynamic blocks
Edit blocks
Know the different parameters: point, linear, polar, x, y, rotation, alignment, invert, visibility, consultation, base point
Know the different actions: move, scale, stretch, polar stretch, rotation, inversion, network, etc.
Cumulation of several actions and visibility
Lookup table
Understand attributes
Know the different types of attributes
Manage block attributes
Set the parameters of block attributes

Workshop: create the recurring elements of an architectural project: doors, double doors, windows, high / low current sockets, etc.

Reminder on the Design Center
Navigate in the treemap
Manage drawing properties
Filter the components of a drawing

Workshop: create a custom tool palette

Create a title block with automatic fields
Create automated field properties
Insert names and paths from .dwg and Xref
Create presentation templates
Create views
Create a sheet set
Work with multiple drawings
Work with a directory
Create sheet selection sets
Archive a sheet set
Check the file tree
Check the file table
Create a transfer on one or more .dwg
Check the file tree
Check the file table
Create a transfer on one or more .dwg

Workshop: create a set of sheets from a working directory, data synchronization. Porting of the project in relative via E-transmit.

Duration

3 days

Price

£ 957

Audience

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

Prerequisites

Have followed the "AutoCAD LT Initiation" course or have equivalent knowledge

Reference

CAO100818-F

Sessions

Contact us for more information about session dates

JasperReports Advanced

Goals


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

Program

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

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

2 days

Price

£ 1625

Audience

Developers

Prerequisites

Basic knowledge of JasperReports, knowledge of Java and XML

Reference

JAV219-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

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

Windows Server 2012 Administration : 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 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)

Duration

2 days

Price

£ 861

Audience

Network and systems administrators

Prerequisites

Have taken the Windows Server 2012 Administration initiation course or have equivalent knowledge

Reference

WIN133-F

Sessions

Contact us for more informations about session date

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 : Advanced

Goals


- Manage the security of Windows Server

- Protect and monitor your server

- Install and configure Terminal Server

Program

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)

Duration

2 days

Price

£ 1029

Audience

Systems Administrators

Prerequisites

Network knowledge

Reference

WIN1219-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 : Advanced

Goals


- Manage the security of Windows Server

- Protect and monitor your server

- Install and configure Terminal Server

Program

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)

Duration

2 days

Price

£ 1029

Audience

Systems Administrators

Prerequisites

Network knowledge

Reference

WIN100741-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 : Advanced

Goals


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

Program

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

2 days

Price

£ 1036

Audience

Web Developers - Webmasters - Integrators

Prerequisites

Have taken the Magento Initiation course or have equivalent knowledge

Reference

OPE100239-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 : Advanced

Goals


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

Program

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

2 days

Price

£ 1110

Audience

Confirmed POO-PHP developer

Prerequisites

Have followed the Drupal 8 developer training, expert PHP or equivalent knowledge

Reference

OPE100083-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 : Advanced

Goals


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

Program

The principle of hooks
Data structure PHP
Standard architecture of a module

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

2 days

Price

£ 1284

Audience

Confirmed PHP developer

Prerequisites

Have followed the Drupal training for initiation and intermediate PHP developers or equivalent knowledge

Reference

OPE745-F

Sessions

Contact us for more informations about session date

AutoCAD 3D Advanced

Goals


- Carry out advanced modeling and photo-realistic renderings

Program

Reminder of the different points seen in the Initiation module

Create 3D Blocks
Manage insertion points
Modify 3D blocks
Understand the 3D block editor special features
Create dynamic 3D blocks
Parameters and actions: visibility, state of inversion, rotation, alignment, etc.

Workshop: create dynamic window and door blocks

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

Workshop: create the elements of a kitchen in 3D and insert into the house

Mesh primitives
Box mesh
Cylinder mesh
Cone mesh
Sphere mesh
Pyramid mesh
Bevel mesh
Tore mesh
Revolution area
Left surface
Ruled surface
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 3D objects to 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 

Workshop: mesh options

Convert mesh objects
Convert mesh objects to solids
Convert mesh objects to surfaces
Manage conversion options

Workshop: model bathroom elements

Materials
Material browser
Presentation of the browser
Default material types
Presentation of the material editor
Adjustment parameters according to the type of
material:
    Generics
    Colors
    Textures
    Images
    Reflectivity
    Transparency
    Cutouts
    Self-lighting
    Etc.
Create materials and textures
Apply materials to a solid
Apply materials to a layer   
Create textures
Apply textures to materials
Texture mapping

Workshop: apply external textures to a wood table

Lights
Operation and types of lights / shadows
Natural light: sun
Choice of location: geographical location
Cardinal orientation
Date and time settings
Sun properties
No shadows
Shadows on the ground
Full shadows
Artificial lights
Light measurement units : lumen, candela and lux
Photometric properties
Light temperature
Point source
Directed source
Distant source
Star light
Positioning and target

Workshop: apply textures and highlight the kitchen

Camera and animation
Default camera properties
Custom settings: position, target point, focal length View manager
Save the settings
Camera animation from a trajectory
Position the target point
Number of frames per second
Animation duration
Choice of video format
Resolution

Workshop: Create an outdoor light atmosphere on a house and create an animation

Renderings
Basic configuration
Preset rendering quality
Resolution
Exposure
Environment
Rendering window presentation: menu, information

Workshop: render previously modeled elements

Advanced rendering configuration
Create, configure and save views
Render quality
General options
Ray tracing
Indirect illumination
Diagnosis
Renderings saving

Workshop: render of previously modeled elements with « presentation » quality

Model space sections
Sections in the Solid ribbon
Create a section plane
Reposition and orientate a section plane
Activate or deactivate the section
Generate a section
Create in block quality
Rename the section

Saved views, presentations and dimensions
Save views
Position the views in the object space
Create details (object)
Create sections (object)
Create views (paper)
Create projected views (paper)
Create sections (paper)
Modify the view appearance
Modify the view scale
Create section views styles 
Create detailed view styles
Modify sections and details styles
Modify the drawing
Update the presentations

Workshop: present the house on several paper formats by exploiting the views, sections, details and projections

Duration

5 days

Price

£ 2121

Audience

People with Autocad 3D Initiation knowledge

Prerequisites

Have followed "Autocad 3D Initiation" course or have the equivalent knowledge

Reference

CAO386-F

Sessions

Contact us for more informations about session dates

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