Training program

Before the face-to-face

• A self-diagnosis.

Identify new uses of digital

• Internet users as actors of their communication.
• Define the notions of Web 2.0, social Web, collaborative Web and collective intelligence.

Social media overview

• Definition, uses and key figures of social networks and media: Facebook, Twitter, Linkedin, Viadeo, Pinterest, Instagram, Snapchat,…
• Blogs, wikis: what uses for business ?

Use networks and social media

• Facebook: The different formats: profile, page, group. How brands use business pages. Facebook's Edge Rank. Advertising on Facebook.
• Instagram: How it works and specifics . What use by companies? Create an effective publication and choose your hashtags.
• Twitter: Features and uses: tweet, hashtag, followers... Interest for a company.
• Linkedin and Slideshare: Individual professional uses: how to optimize your profile? Interest and uses by companies. Use Slideshare to find professional content.
• YouTube channel: what place in companies' social media systems?
• Picture marketing: communicate through images with Instagram, Pinterest, Snapchat.
• Live video: Twitter (Periscope), Facebook Live, YouTube Live,...

E-reputation and online monitoring

• Digital identity, personal branding and e-reputation: the importance of the search engine.
• Set up a monitoring system.

After face-to-face - Implementation in a work situation

• A strengthening program: "One challenge per week for 7 weeks", to help you implement your training.

Description

Faced with new digital practices, synergy between marketing and sales force is more necessary than ever to strengthen performance. How to optimize the sharing of information or put the marketing strategy into practice on the ground? This training allows you to integrate operational tools and the most recent practices.

Who is this training for ?

Training objectives

• Identify marketing-sales collaboration opportunities
  
• Use marketing tools to develop effective and appropriate sales support materials
  
• Integrate new digital practices for the benefit of efficiency
  

Training program

Marketing-sales synergy at the heart of company performance

• The place of customers and the evolution of professions.
• The
• The key points of collaboration.

Collection and sharing of key information: market, customers, competition

• The needs of each actor for a better contribution.
• Use the best sources, off and on line.
• The key digital tools to facilitate collaboration and sharing.

Translate the marketing plan into a commercial action plan

• Marketing-sales alignment: sharing the issues and objectives.
• Getting the sales force to adhere to the marketing plan.
• Ensuring consistency between the marketing plan operational and commercial action plan.
• Optimize customer acquisition with the conversion tunnel and social selling.
• Define and share indicators for monitoring marketing activity- sale.

Develop impactful sales support materials

• Build the commercial argument: CAB, REPERES.
• Arguments, product sheets and marketing-sales book.
• Use the power of digital tools: digital book, exploitation of virtual or augmented reality, interactive arguments, audio or video supports, dashboards.
• Provide salespeople with the content necessary for brand advocacy and social selling.

Description

Innovation is the driving force of a sustainable company. Marketing plays a driving role: generating new ideas, detecting opportunities, selecting and validating value-bearing innovations, defining the launch strategy, etc. This training in innovation marketing aims to structure a complex approach to maximize its chances of success.

Who is this training for ?

Training objectives

Acquire the innovation marketing approach.
Adapt the marketing tools that allow you to generate new ideas.
Know how to define new business areas.

Training program

Before the face-to-face

• A self-diagnosis.

Challenges

• The different typologies of innovation.
• Innovation seen by innovators.
• The challenges of innovation: why innovate? The marketing approach of innovation.

Encourage the generation of new ideas

• Challenging paradigms: from product to customer experience.
• Identifying discontinuities in the environment.
• Marketing monitoring and analysis tools.
• Take inspiration from consumer or customer insights.
• Observe the customer journey.
• Discover simple ideation and cross-fertilization.

Seize growth and business opportunities Evaluation of innovations and strategic choice: validation criteria.

• From the analysis of the activity portfolio to the choice of new business areas.
• Define the development plan: opportunity mapping.

After face-to-face, implementation in a work situation

• A reinforcement program to help you implement your training.

Description

Thanks to this marketing training, you will be able to master marketing processes and practices adapted to new trends and developments in the digital world. You will thus be able to play an informed role in the marketing process and implement relevant action plans for your business.

Who is this training for ?

Training objectives

• Identify the role and contribution of marketing within the company
  
• Become an actor in the marketing process and performance
  
• Imagine new areas of value creation
  

Training program

Before the face-to-face

• A self-diagnosis.

Marketing: what for?

• The key stages of the marketing process.
• The levers of value creation.
• The contributions of digital.

Marketing in a digital world

• New customer behaviors.
• New interactions.
• Technologies serving marketing performance.

Le diagnostic marketing

• The stages of marketing diagnosis.
• The 3 pillar practices of marketing analysis.
• From analysis to diagnosis: the SWOT matrix.

The marketing strategy

• Segment and target your priority markets.
• Keys of differentiation and positioning.

The marketing mix in the digital age

• The new drivers of the price-product strategy.
• The omnichannel distribution mix.
• Write the communication plan.

Le plan marketing

• Be involved in the marketing plan.
• Identify the right management tools.

Contribute to marketing

• Adopt a transversal approach to marketing.
• Become a contributor to marketing performance.

Description

CRM is making a comeback in organizations. This training provides tools and methods to improve their customer relationship action plan and strengthen their customer capital throughout their journey. So that relationship marketing contributes to the objectives of loyalty and development of customer relationships, this training takes into account the constraints relating to data confidentiality (“first data party”) and also focuses on automated marketing.

Who is this training for ?

Training objectives

• Use a strategic approach to CRM to improve the practical use of the CRM tool
  
• Learn the methods and approaches to segment relationship marketing actions
  
• Design automated marketing scenarios for each important stage of the customer journey
  

Training program

Identify the customer journey

• The “customer centrics” approach: analysis and 360° knowledge of the customer.
• Determine customer value.
• Identify the criteria linked to customer loyalty.

Building multi-channel relationship marketing

• Segment your customers throughout their journey.
• Segmentations, typologies and behaviors.
• The RADAR decision-making matrix: identify targets and define actions.

Focus on Databases and CRM

• Taking advantage of customer data in the era of GDPR and
• Assessing the challenges of CRM.
• A unique vision of the customer , what data to use?
• The different modules of CRM tools.

Automate your campaigns to develop value

• Marketing automation in addition to the CRM tool to:
• generate content
• meet customer expectations
• script the 'sending emails/sms and creating workflows at key moments in the customer journey.
• Distil and distribute valuable content throughout the customer journey.
• Automate management of its campaigns to identify leads and develop customer relationships.
• Develop campaign automation scenarios.

Strengthen multichannel actions

• Choose your digital media.
• Monitor the main performance indicators.
• Build your dashboards.

Description

Mobile applications, blogs, social networks... Customers have more and more tools to get to know and connect with brands. He is increasingly informed, wise and demanding. These changes brought about by the advent of digital tools transform marketing and bring new marketing reflexes such as customer experience (UX), the notion of commitment or customer centric management. This training allows you to understand the impacts of this transformation in order to identify the key success factors of a customer-oriented marketing strategy as well as its management tools.

Who is this training for ?

Training objectives

Identify and understand the challenges of digital.
Identify the impact of digital on the BtoB and BtoC customer.
Master the challenges of omnichannel customer journeys.
Understand the challenges of customer experience and the notion of commitment .

Training program

Before the face-to-face

• A self-diagnosis.

The impact of digital for customers The end of the 4 Ps for more relational and emotional marketing. The impact of digital on the customer journey and touchpoints. New professions for customer experience: CX/UX. The diagnosis of the experience

• Choice of strategies in terms of customer experience: focus on case studies.
• Differences with customer relationship strategies.

The components of the digital customer experience

• Understanding customer emotions and needs to generate engagement.
• Priority digital contact points and channels.
• A brand message adapted to the relationship with the customer.
• Useful tools at each stage (e-mailing; telephone; mobile app; connected store; e-merchandising; social media;...).

Managing the customer experience

• KPI's to be defined.
• Data (CX, Net Promoter Score...) and dashboards.
• Implement a satisfaction barometer.
• The co-construction of new customer experiences.

After face-to-face, implementation in a work situation

• A reinforcement program to help me implement the training.

Description

The training teaches the methods and tools necessary to build effective customer journeys, in line with growing customer expectations. Participants will discover new techniques such as Customer Journey, Experience Map, Blue Print and best practices to adopt. Remote workshops and co-construction tools will facilitate practical implementation.

Who is this training for ?

Training objectives

• Understand the new challenges of Customer Experience, the methods to implement and the mistakes to avoid
  
• Identify on which axes to structure your Customer Experience approach in order to initiate and sustain a human-centered Customer Experience approach
  
• Master new challenges and know where, when and how to optimize new phygital customer journeys in order to increase customer engagement and performance
  
• Concretely adopt the latest collaborative design methods from Persona, and map customer journeys “Customer Journey / Experience Mapping”
  

Training program

MODULE 1: Mastering the pillars of customer expertise transformation (3h30)

• 1. Use Design Thinking and agility to design your future experience
• Understand the contribution of each universe: UX, UI, Design Thinking, Service Design to Experience Design .
• What methods to prioritize your CX projects?
• Method for designing future courses: The story board, the Blue Print, ...
• Workshop 6: Workshop of Prioritization of CX projects
• 2. Manage your customer experience and KPIs to implement
• Implement the key Customer Experience indicators
• Manage the experience customer in real time
• Final workshop: Determine your personal action plan

MODULE 2: Knowing how to diagnose your customer experience and journey (3h30)

• 1. Use Design Thinking and agility to design your future experience
• Understand the contribution of each universe: UX, UI, Design Thinking, Service Design to Experience Design .
• What methods to prioritize your CX projects?
• Method for designing future courses: The story board, the Blue Print, ...
• Workshop 6: Workshop of Prioritization of CX projects
• 2. Manage your customer experience and KPIs to implement
• Implement the key Customer Experience indicators
• Manage the experience customer in real time
• Final workshop: Determine your personal action plan

MODULE 3: Transform with the customer journey and the experience map (3h30)

• 1. Use Design Thinking and agility to design your future experience
• Understand the contribution of each universe: UX, UI, Design Thinking, Service Design to Experience Design .
• What methods to prioritize your CX projects?
• Method for designing future courses: The story board, the Blue Print, ...
• Workshop 6: Workshop of Prioritization of CX projects
• 2. Manage your customer experience and KPIs to implement
• Implement the key Customer Experience indicators
• Manage the experience customer in real time
• Final workshop: Determine your personal action plan

MODULE 4: Designing your future experience with experience design & design thinking (3h30)

• 1. Use Design Thinking and agility to design your future experience
• Understand the contribution of each universe: UX, UI, Design Thinking, Service Design to Experience Design .
• What methods to prioritize your CX projects?
• Method for designing future courses: The story board, the Blue Print, ...
• Workshop 6: Workshop of Prioritization of CX projects
• 2. Manage your customer experience and KPIs to implement
• Implement the key Customer Experience indicators
• Manage the experience customer in real time
• Final workshop: Determine your personal action plan

Description

Pilot a Web project, manage the creation or redesign of a Website, know how to make the right decisions, develop your site, analyze customer behavior, monitor investments, interact with service providers... This internship will help you will allow you to acquire a real general culture of website management with a global digital approach (web, social media, mobile, etc.).

Who is this training for ?

Training objectives

• Manage the creation or redesign of a website
  
• Measure investments, understand the vocabulary, work well with a service provider
  

Training program

The scope of a digital project

• An evolution of customer relations and the omnichannel approach (website, social media, mobile equipment, etc.).
• Understand the evolution of the business world to lead an internal digital project.
• The Web eco-system and its new professions.

Design the web project Write the specifications.

• Project planning (Gantt chart, subdivision, sprints, etc.).
• Carry out the call for tenders.
• Choice of service provider and the contract.
• Financial approach.

Manage the web project V-cycle methodology and method

• Agile (advantages and disadvantages).
• Adapting agility to its context.
• The actors of a Digital project (working with service providers).
• Predictive analysis (KPI, indicators, TdB, ROI...).
• Visibility and SEO (SEM, SEA, SEO, SMO).

Technology

• The major trends (DevOps, Big Data, IOT, AI, Chat Bots, ...).
• The fundamentals of the Web and its languages.
• The mobile strategy (mobile application, WebApp and Responsive Web Design Site).
• CMS and information processing workflow.
• Collaborative tools (co-creation of content, management collaborative project, CSR...).
• Cloud and SaaS hosting solutions.

Description

Digital is shaking up the economic situation and only well-prepared companies will succeed. Companies need an identified and well-trained contact person to lead their transformation towards digital. This training cycle allows the person responsible for digital to appropriate new economic models, to identify the skills and technologies necessary for the company, to equip managers to deploy a digital strategy that will drive growth for the company. .

Who is this training for ?

Training objectives

Understand the challenges of the digital transformation of the company
Define the new business model and deploy the associated strategy
Identify the skills needed to successfully transition to digital
Identify digital technologies that generate competitiveness for the company
Lean on the new role of the manager in digital transformation

Training program

PART 1: Impact of digital on the business model (3 days)

• 1 - Identify the challenges of digital transformation for your company
• Analyze the trends of a changing economy.
• Understand the disruptions caused by digital.
• Identify the impact of sustainable development and CSR in digital transformation.
• Clarify the role of digital technologies: mobile, social media, analytics, cloud computing, connected objects, blockchain, NFT, metaverse…
• Enter the dematerialization of processes and services.
• Manage data: the main indicators (KPI), setting up a table of edge, ROI.
• 2 - Place project management at the center of digital transformation
• The fundamentals of digital project management.
• Take advantage contributions from design thinking.
• Adopt agile methods.
• Risk analysis of digital transformation.
• 3 - Develop a digital strategy that brings growth
• Understand the different digital strategies.
• Distinguish between possible economic models and their sources of income.
• Locate the degree of maturity of your company in the face of digital transformation.
• Rethink your Business Model in the digital age: the Business Model Canvas.
• Take inspiration from successful examples of digital transformation.
• Scenario: Practical case: practice defining a digital transformation project based on a brief.
• Practical application: Before part 2, identify the multi-device journey of your clients.

PART 2: Impact of digital on marketing and information systems (3 days)

• 1 - Focus on the customer experience
• New customer behaviors.
• Customer experience: purchasing journey and touchpoints.
• Identify winning practices in terms of customer experience.
• The challenges of customer experience on the marketing vision.
• 2 - Integrate digital marketing
• Digital marketing in an acquisition and loyalty strategy.
• Natural referencing (SEO): a determining asset.
• Audience measurement (analytics ) to optimize marketing actions.
• Landing pages: a customer-centric approach.
• CRM at the service of performance: function, objectives and available solutions.
• Personalization of customer relations and marketing automation.
• The key invoices for successful customer conversion.
• Aim for the convergence of marketing, sales, customer relations and IT functions .
• New commercial approaches (social selling, remote selling).
• 3 - Addressing digital business technologies
• The central role of the IT department in the digitalization of the company.
• Principle of urbanization of IS: technical fundamentals.
• Digitalize the workstation: digital workplace and digital collaborator.
• The cybersecurity of a company: risks and analysis study.
• Adapt the IS to digital challenges (BYOD, shadow IT, data opening, etc.).
• Integrate the mobile terminals in digital transformation.
• Deploy Cloud and SaaS solutions.
• Business Analytics and Optimization (BAO) technologies.
• Practical application : Before part 3, identify the obstacles and levers of digital transformation in the company.

PART 3: Impact of digital on management (3 days)

• 1 - Activate the key success factors in a digital transformation project
• The role of HR in digital transformation.
• The integration of a new skills framework.
• Develop the digital agility of employees.
• Identify the obstacles to digital transformation, decipher cultural inhibitions.
• New generations, new values.
• Role and responsibilities of management in digital transformation.
• Establish a digital governance system.
• 2 - Manage the impacts of collaboration on management
• Managing with collaborative tools.
• Animating internal communities.
• Using corporate social networks.
• Management collaborative, hybrid management.
• Scenario: Exercise to simulate collaborative work with an online tool.
• 3 - Rely on new management methods
• The principles of agile culture and “test and learn”.
• From agile project to agile management.
• Instill an entrepreneurial spirit.
• New modes of collaboration: partnership and collective relationship, right to fail, new work spaces.
• The influence of start-ups in the functioning of the company.
• The contributions of leadership to management.
• The new organizational models.

Description

The e-commerce manager faces several major challenges, such as technology, big data, marketing and sales. The “E-commerce Manager” training cycle is made up of three parts which follow each other logically: the first part addresses e-commerce strategies and economic models as well as e-commerce project management; the second part deals with traffic generation and conversion levers throughout the customer's purchasing journey; and finally, the third part develops the tools and resources for omnichannel e-commerce. Throughout these sessions, participants are encouraged to share and exchange their practices, which encourages emulation within the promotion.

Who is this training for ?

Training objectives

This training aims to provide the key knowledge, approaches and tools necessary to increase the sales of an e-commerce site
Participants will be able to familiarize themselves with economic models and functionalities specific to e-commerce, as well as learn how to manage the key stages of an e-commerce project
In addition, they will discover the main levers to generate traffic, increase conversions and retain customers
Participants will also understand the essential elements of an omnichannel strategy, covering channels such as smartphones, tablets, web, social media and point of sale
Finally, the importance of data collection and analysis will be highlighted, with a particular emphasis on the use of performance indicators to improve the customer experience

Training program

Acquire knowledge of e-commerce and omnichannel business models.

• The essential measures of the profitability of an e-commerce site include
• When modeling and planning an e-commerce site, it is important to consider
• Key performance indicators (KPIs) and return on investment ( ROI) are important measures both quantitative and qualitative.

Implement e-commerce site functionality into e-commerce platforms.

• Logistics challenges include sourcing, storage and delivery of goods.
• Online payment solutions are important for securing electronic transactions.
• Legal considerations are key to complying with GDPR regulations and understanding its impact.
• Mobile interfaces, such as smartphones, tablets, wearables and chatbots, are playing an increasingly important role increasingly important in e-commerce.

Manage the e-commerce and omnichannel project The functional specifications.

• Organizational arrangements for an e-commerce site.
• The design of e-commerce interfaces (UX/CX).
• The management of flows and data with the company's IS to provide a personalized customer experience.
• The key stages of e-commerce project management.

Analyze the customer's purchasing journey

• The different stages and key moments of the purchasing decision (ZMOT) for an online customer.
• Use geolocation tools to attract customers by generating traffic to locations where they are located.
• Best practices for online businesses, including pure players, distributors, B2B and B2C companies.
• Important information to provide to each stage of the purchasing journey and how to measure customer satisfaction.
• The challenges of e-CRM and social-CRM for online businesses.

Pull the levers to generate traffic

• Search engine marketing (SEM): paid referencing (SEA), Adwords and Google Shopping, natural referencing (SEO).
• The levers of traffic creation: display, e-mail and competitions...
• Affiliation and partnerships

Use the keys to e-merchandising

• E-merchandising to promote your products and develop the average basket.
• Site navigation strategy: the rules of e-merchandising.
• The phenomenon of the 'long tail': advantages, key principles The basket: management and activation.
• Dashboards, indicators and KPIs

Promote conversion and loyalty

• Sales promotion mechanisms in e-commerce.
• Three fundamental rules of e-commerce: personalization, reassurance and responsiveness.
• The order funnel. Commercial reactivation.
• E-loyalty programs

Deploy m-commerce on smartphones and tablets

• M-commerce infrastructure: specificities.
• Payment solutions. Economic models.
• Commerce on smartphones, tablets and connected objects: challenges, evolution and performance levers.
• Generate point-of-sale traffic via mobile

Develop social commerce on social media

• Social shopping: experiences and best practices.
• Retail on social networks: state of play.
• Development of a community of online buyers.

Define omnichannel commerce strategies

• Omnichannel distribution strategies: business point of view versus customer point of view.
• Complementarity: physical sales channel and e-channel, web and mobile.
• Associate e-commerce with traditional commerce
• Enrich it. consumer experience thanks to the connected point of sale.
• Use recent trends: geolocation, augmented reality, social selling, chatbot, voice recognition...

Build e-commerce and omnichannel action plans

• Definition of e-shopper targets: average basket, potential, channel affinity, RFM.
• The pure web action plan: complete your site with a mobile version and applications.
• The omnichannel action plan.
• The web to store action plan.
• Dashboards and ROI assessment

Description

The position of Digital Marketing Manager has become essential within the marketing and communications departments. This training cycle offers both a strategic and operational approach to a constantly evolving profession.

The first part addresses the digital marketing strategy, with an overview of the approach, the marketing e-mix, SEO techniques, as well as traffic and conversion generation.

The second part focuses on the optimization of digital communication campaigns (display, e-mailing, etc.) and the implementation of a strategy on mobile media.

Finally, the third part explores digital marketing on social media and social networks. Participants are encouraged to share their experiences throughout the cycle, thus promoting a stimulating group dynamic within the promotion.

Who is this training for ?

Training objectives

• Understand the challenges and strategies of digital marketing
  
• Master traffic generation and conversion techniques
  
• Implement an omnichannel web marketing strategy
  
• Understand how to integrate mobile marketing into your campaigns
  
• Acquire tools and methods to develop your presence on social media
  

Training program

Digital Marketing Strategies

• Technological advances and changes in user habits: the importance of CX and UX design, connected objects, big data, chatbots, etc.
• New segmentation approaches in response to the behaviors and attitudes of Internet and mobile users.
• Compliance with rules for the protection of personal data on the Web, in particular the impact of the European GDPR regulation.
• The key roles in the field of digital marketing: product owner, data scientist, data analyst, traffic manager, community manager, etc.
• The responsibilities and missions of the Webmarketing manager.
• Digital marketing strategies: inbound marketing and brand content.
• Practical workshop: prospective monitoring of current trends.

SEO: define marketing strategies and solutions

• The study provides an overview of the players and tools used for online search. It discusses search engine marketing (SEM) techniques, which include search engine optimization (SEO) and paid search via AdWords (SEA).
• The methodology proposed to improve natural referencing emphasizes social network optimization (SMO). The article also highlights the complementarity between SEO and sponsored links.
• Finally, the practical workshop offers an SEO campaign to illustrate the concepts covered.

Optimize the performance of your web marketing actions.

• It is essential to harmonize communication and the digital marketing plan.
• The digital communication strategy is described in detail, presenting its structure and the key steps to follow.
• The levers of digital communication are explained to enable them to be used effectively.
• Different promotional techniques are presented for the web, such as games and competitions.
• The practical workshop presents the design of an omnichannel operation to apply the concepts seen previously.

Develop the use of mobile to strengthen the effectiveness of its omni-channel campaigns.

• Different email marketing techniques are presented, such as email marketing, newsletter and online magazine, as well as the use of mobile email and SMS.
• Display advertising is discussed, with the formats and models of native ads and programmatic advertising, as well as mobile display.
• The article discusses the impact and future prospects of mobile.
• Mobile applications and WebMobile are explored to understand their use in digital marketing.
• The question of referencing mobile applications on stores is addressed.
• The practical workshop offers a business case to allow the concepts mentioned previously to be put into practice.

Pilot and manage Web, Mobile, offline campaigns

• Mobile channels and technologies.
• Mobile multichannel: measuring results: web and mobile tracking and ROI.
• Key performance factors (KPI) web and mobile. Google analytics: the main audience measurement indicators.
• Mobile offline strategies.
• Practical workshop: Web marketing plan

The social web: new uses

• The challenges for the company; new purchasing behaviors (ZMOT).
• Practical workshop scenario: Create and manage your Twitter account.

Design a social media strategy

• Structure a social media diagnosis (3C model, POEM model, SWOT).
• Facebook page, Twitter or Instagram account, LinkedIn page, YouTube channel, blogs... which media to choose?
• Build your operational action plan: editorial line, recruitment strategy...
• Scenario Practical workshop: Establish the editorial line of a space

Design and manage communities on social networks.

• This part of the course covers different aspects of using Facebook for digital marketing, including creating a page, Edge Rank, measuring results, and advertising on Facebook (social ads).
• Participants will learn the vocabulary and key objectives for an effective Twitter account, as well as the different metrics to measure results.
• The course explores the opportunities offered by LinkedIn in terms of employee advocacy, social selling, thought leadership and employer branding, as well as the keys to success for effective use of this platform.
• Visual social media like YouTube , Instagram, Snapchat and Pinterest are studied to understand how to use them in a digital marketing strategy.
• The treatment of negative customer reviews is discussed, with a reflection on their impact and advice for dealing with them efficient manner.

Set up an influencer program

• Who are the influencers?
• Define and identify the typologies of relevant influencers.
• Design a truly sustainable influencer program.
• Mise in situation Practical workshop: Identify your influencers

Organize your digital marketing system on social networks.

• Choose the right social media management tools (SMMS).
• Define your dashboards.
• Social media governance and charter.
• Practical workshop setting: Implement your tools.
• Evaluation of acquired knowledge

Description

The social media manager's mission is to define and manage the company's digital communications policy. His activity is upstream of that of the Community manager he supervises, or can also constitute the operational part of his mission in a company or agency. Today, the functions of social media manager and community manager are often combined. This Community manager training prepares you to practice this new profession in the best conditions by allowing you to define a social media strategy, develop community management in the company and implement media planning on social media. During the cycle, participants are invited to share their experiences, thus creating emulation within the promotion.

Who is this training for ?

Training objectives

Acquire the levers to propose a communication strategy on social media
Understand and monitor the components of e-reputation
Learn the key principles of community leadership
Identify and know how to implement the modalities of Brand Content
Integrate the POEM model with social media
Lead, manage actions and analyze the results obtained

Training program

The social Web: new uses, new professions

• New purchasing behaviors (ZMOT) in BtoC and BtoB, the uses of employees.
• Opportunities and risks for companies.
• New professions communication: social media manager, social media manager, community manager, brand content manager, asset manager...

Social media overview

• Key uses of social media by socionauts and by businesses.
• Social networks: Facebook, LinkedIn. Twitter: micro-blogging.
• The media visual social networks: Instagram, Snapchat, Pinterest.
• Content sharing platforms: YouTube, DailyMotion, SlideShare, ...
• The role of Blogs
• Crowdsourcing platforms, self-care community....

Design a social media strategy

• Structure a social media diagnosis (3C model, POEM model).
• Integrate social media into your overall communication strategy.
• Facebook page, Twitter account or Instagram, LinkedIn page, YouTube channel, blogs... how to make your choices.
• ]Build your operational action plan: recruitment plan, influencer program

Secure the company's e-reputation

• Analysis and monitoring of the company's e-reputation: analysis and control tools; Managing negative customer reviews; Review sites and the employer brand.
• From failure to crisis management: crisis typologies on the Internet.
• Anticipating a crisis on the Internet.

Organize a social media system

• E-reputation monitoring, community management... know and choose Social Media Management (SMM) tools.
• Internalize or outsource your system and resources.
• Media governance and social media guidelines

Effectively animate the main social media

• Running a Facebook page: key success factors.
• How to optimize engagement on a Twitter account.
• Running a company page on LinkedIn.
• Optimize the SEO of your YouTube or SlideShare channel.
• Use Picture marketing: Pinterest, Instagram, Snapchat

Brand content, Curation, UGC: developing impactful content

• Key success factors of a content strategy.
• Define your mix: brand content, curation, UGC.
• Branded content in BtoB and BtoC: the mechanics of virality: emotion, socialproof, newsjacking, story telling,...; content format: rich media, video, live video, animated gif, augmented reality, infographics, white papers...
• Differentiate your content, think about snacking content and evergreen content.
• Live video: Facebook live, YouTube Live.
• What content to create during real events.

Implement a digital influencer program (earned media)

• Define the types of influencers relevant to you.
• Identify the reference influencers.
• Design a truly sustainable influencer program.
• Synergies between press relations, Twitter and the influencer program

Motivate and mobilize a network of ambassadors (earned media)

• Mobilize customers and fan ambassadors (Customer Advocacy).
• Create an employee ambassador program (Employee Advocacy).

Remote activity

• To discover a new tool/a new technique: a virtual class.

Understanding the challenges of social ads

• What objectives for advertising on social media?
• Why reinforce and complement the editorial strategy with advertising?
• What impact on shared media and earned media ?,
• Audience and influence tools and indicators

Set up advertising campaigns

• Understand the advertising offerings of the main social media: Facebook, Twitter, LinkedIn, Instagram, Snapchat, YouTube.
• Know their advertising platforms (Ads manager).
• Use behavioral targeting.
• Set up an advertising campaign.
• Ads on mobile.
• Practical workshop: design a campaign for a Facebook page.

Enrich your content for social networks

• Organize a communication campaign on social networks.
• Define an editorial line.
• Optimize natural referencing (SMO).
• Monitor, analyze indicators and calculate ROI (audience, influence, post clicks).
• Create value-added content to generate engagement
• Use the main tools to create. images, videos and infographics (Canva, Quik,...).
• Evaluation of acquired knowledge

Description

Smartphones and tablets offer 'mobile users' another, more intuitive and more human way of navigating. However, many sites are not optimized for mobile devices and do not use 'responsive design' resources. Today, the vast majority of connections to the Web are made from mobile devices; for businesses, mobile ergonomics has become a major issue for improving the user experience.

Who is this training for ?

Training objectives

Define the criteria for mobile ergonomics
Improve the user experience
Design a mobile interface
Integrate the gestures of touch interfaces
Become familiar with responsive emailing

Training program

Define the criteria for mobile ergonomics The added value of responsive web design (RWD).

• The key figures to know.
• The different approaches: Mobile first, Responsive, mobile site.
• Responsive design and SEO.

Improve the user experience

• Anticipate and hold the visitor's attention.
• Guarantee a coherent identity.
• Optimize the graphics.

Design a mobile interface

• Identify the types of resolution.
• The characteristics of the different devices.
• Design the templates.
• The principle of fluid grids.
• Blocks and contents.
• Technical specifications.

Develop adaptive content Organization and hierarchy of content.

• Hidden content.
• Adaptive image management.

Design steps and tools

• Paper models and sketching.
• The use of Photoshop for the model (principle).
• Digital design tools (mockup, axure.. .).

Integrate the gestures of touch interfaces

• Basic gestures for touch interfaces.
• Support user actions.
• Multi-touch touch interfaces.

Become familiar with the

• Responsive emailing The technical basics of e-mailing.
• HTML tables and integrated styles.
• The principle of media queries.
• The specificities of responsive e-mailing.

Description

Digital affects all functions of the company, it is one of the levers of innovation and development and breaks down silos by management. The company no longer has a choice: the need to adapt to a new connected economy, to get ahead in a changing environment. This training meets the needs of managers who wish to tackle the digital transformation of their company or business unit.

Who is this training for ?

Training objectives

Understand the challenges of the company's digital transformation
Acquire an overview of digital transformation and key skills
Activate organizational, managerial and human levers
Rethink your Business Model in the digital age

Integrate the challenges and opportunities of digital transformation for the company

Training program

Identify the challenges of digital transformation

• Trends in a changing economy.
• The role of digital technologies: mobile, social media, analytics, cloud computing, connected objects.
• Knowledge of customers: E-CRM and Big data.
• The convergence of marketing, sales, customer relations functions (0° and multi-channel vision).
• The challenges for IT departments: security , BYOD, digital workplace...

Develop a digital strategy

• Digital transformation strategies
• Identify the levers and obstacles of digital transformation
• Examples of successful digital transformations
• Select and organize key projects
• Locating the degree of digital maturity of your company
• Rethinking your Business Model in the digital age

Digitize management and organization

• The new role of managers
• Digital governance
• Digitalize the company's state of mind
• Measuring the impact on professions (HR, marketing, sales, customer relations, etc.)

Description

Video has become the predominant information format on the web and social networks. Pages, messages and posts containing video are much more likely to be seen and have an impact than content limited to text. This training will help you develop a video marketing strategy to boost the effectiveness of your digital communication.

Who is this training for ?

Training objectives

Integrate video into your digital marketing strategy
Develop your live video production
Generate traffic around your video

Training program

Before the face-to-face

• A self-diagnosis.

The challenges and opportunities of video

• POEM logic, virality.
• Brand content and video.

Formats and uses of video marketing

• The uses of video for a brand.
• Story telling.
• The different types of content: fun, expert...
• Typology of formats (web series, snacking content, live videos, stories...).
• Hosting of its videos.

Create and run your channel

• Youtube Create and configure your channel.
• Organize your channel.
• Optimize the referencing of your videos: SEO.
• Optimize the impact of his video: end image, still image, call to action.

Develop and succeed in your live video Choose your platform.

• Set up the technical aspects: filming, editing, encoding, conductor.
• Estimate the necessary resources.
• Create interaction and manage comments.

Diffuser ses videos

• Optimize natural referencing.
• Launch your videos using advertising purchases.
• Estimate the necessary resources.

After face-to-face, implementation in a work situation

• A reinforcement program to help me implement the training.

Description

A successful email campaign requires more and more expertise given 'marketing permission' and new technical and legal constraints. This training in creating effective e-mailing campaigns takes place in the form of a practical workshop and allows you to work on your own responsive e-mailing campaigns.

Who is this training for ?

Training objectives

Learn the key principles and rules for building effective emails
Know how to carry out an e-mail campaign from A to Z
Acquire the reflexes to create and deliver your BtoB and BtoC emails
Practice directly on your own case

Training program

Define your e-mailing strategy Current use of e-mails in

• BtoC and BtoB.
• From outbound marketing strategy to inbound marketing strategy.
• Prospecting and promotion approaches in BtoC and BtoB.

Design a responsive email Editorial: key rules, benefits of personalization and targeting.

• Responsive Design: case of emails read on mobile or tablet.
• Improve opening rates, reactivity rates, landing page performance.

Set up and measure your email campaigns

• Brief, check-list et planning type.

Optimize deliverability

• Key metrics: analyzes and decisions Benchmarks Deliverability issues.
• What parameters affect the deliverability of your emails.
• Measure the deliverability of your emails e-mails.
• Database: hygiene rules, how to manage inactive people.

Develop your email address potential Mechanisms for capturing emails on your site or at the point of sale. Competitions, draws and co-registration (co-subscription).

• Rent email addresses: reference budgets in BtoB and BtoC.
• Evaluate the interest of social media to capture addresses.

Plan your e-mailing campaigns Define your plan by integrating a test logic (split runs) and follow-up.

• Optimize the rhythm of routing to preserve its bases.
• Choose a routing solution.

Description

Communication services today must take into account social media. This training in digital communication strategy offers those responsible for the company's brand image the opportunity to appropriate these new communication tools as part of a digital strategy.

Who is this training for ?

Training objectives

Know how to develop a digital communication strategy.
Integrate social media into your communication strategy.
Acquire the levers for success: events, advertising, links with blogs and crisis communication on social media.

Training program

Develop your digital communications strategy

• Evaluate the company's e-reputation and listen to communities.
• Build a communication plan: which media and social networks for which objectives?
• Choose the tone of your communication.
• Understand the different uses of social media (POEM matrix).
• Build the team: the new professions.

Overview of networks and social media

• Update on the evolution of different social media: Facebook; Twitter; LinkedIn; Instagram; Snapchat; YouTube...

Establish a social media setup for an event

• Increase the visibility of your event thanks to social media.
• Create an omnichannel system to promote an event.
• Use events to produce content.

Identify advertising opportunities

• Business models of social networks and media.
• What objectives for Social Ads?
• Overview of the advertising solutions offered by Facebook, Twitter, LinkedIn, Instagram, Snapchat.

Measure digital communication actions

• Know the different metrics: like, share, reach, impressions, RT, followers...
• Measuring engagement, concept of ROE and ROI.
• Community management tools - Social Media Management Systems (SMMS).

Managing online crisis communication

• Evaluate crises: understand the types of crisis on the Internet (fail, bad buzz, crisis, etc.).
• Understand the importance of managing negative customer reviews on the Internet.

Certification

• Assessment of skills to be certified via an online questionnaire incorporating role-playing scenarios (40 minutes).

Description

This training allows you to know the printing techniques and methods in order to carry out your job as a contractor according to the rules of the art.

Who is this training for ?

Training objectives

Understanding the graphic chain from design to delivery: the chronology of the stages
Acquire technical, precise and current vocabulary to communicate with professionals
Issue a call for tenders and decipher a quote
Optimize manufacturing budgets
Anticipate printing constraints
Innovate in your printed matter (paper choice, finishing, etc
)

Training program

Understanding Print File Preparation

• Software, file formats, digital images: size, resolution, screen ruling and raster, contractual proofs.
• Color: color spaces, spot colors and four-color process, solid color.
• The control stages: the vouchers to ...
• (BAT, BAG, BAR).
• Taxation, CTP.

Innovate in your printed documents

• The choice of paper: coated paper, uncoated paper and creative paper.
• Technical characteristics of the paper.
• Give the print its final form: online shaping (rotary).
• The shaping steps: trimming, folding, inserting, stitching, sewing, system binding...
• The finishing of your printed documents: special inks and surfacing: varnish, lamination, embossing, hot and cold stamping.

Description

A successful site is one that is consulted intuitively. This training will help you organize information in a logical and rational way. It will allow you to design or improve the ergonomics of your site in order to make navigation simple, pleasant and accessible.

Who is this training for ?

Training objectives

Evaluate the ergonomic quality of a website
Improve the organization and interface of a site
Optimize navigation
Know the criteria for evaluating a site

Training program

Aim for the quality of the ergonomics of a site

• Web Identify the behavior of Internet users.
• The principles of ergonomics and UX design.
• Define objective evaluation criteria.
• Analyze navigation processes.
• Know the key success factors of a site.
• The main mistakes to avoid.

Improve organization and interface

• Navigation and reading contract.
• Visual identity and ergonomics: the importance of the home page.
• Develop a navigation charter.
• Know how to structure your information.
• Determine your heading.
• Develop your functional masks.
• Offer the best tools.
• Integrate the notions of identification, location and orientation.

Key concepts and tools of UX design Define personas, design the sheets.

• The card sorting method.
• Brainstorming and six-to-one.
• User groups and A/B testing.

Optimize navigation and content management

• Texts/photos: the keys to navigation.
• Text links: naming rules.
• Data relationship and indexing.
• Use of different media: texts, photos, infographics & videos.

Learn the graphic rules The basics of composition.

• Colors and their influences.
• Shapes for navigation.
• Graphics for ergonomics and UX.

Improve accessibility

• Take into account legislation on digital accessibility.
• Comply with WC standards.
• Adapt content for visually impaired people.

Description

For Marketing and Sales monitoring and foresight to go beyond the scope of surveillance and participate in the company's strategic decisions, the approach must be professionalized and marketing and sales work in synergy. This training in marketing and competitive monitoring provides methodology and concrete tools for monitoring and foresight.

Who is this training for ?

Training objectives

Acquire a methodology in your marketing and competitive monitoring approach
Know the marketing and competitive intelligence tools available, particularly on the web and social networks

Training program

Anticipate customer demand and competitive strategies

• Marketing monitoring monitoring fields.
• Marketing and commercial foresight: from information to decision-making.
• Optimization of monitoring: marketing/sales structures and synergy.
• The key principles: proactivity; weak signals; ethics;

Marketing monitoring and surveillance areas Appropriate competition analysis tools.

• Identify customer analysis methodologies.
• Monitor the evolution of market segments.
• Spot trends and measure their influence.

Collect information

• Identify available external and internal sources.
• Run a network of sensors.
• Information categories.
• Monitoring sites: RSS feeds.
• Social media as a source of monitoring.

Watch over

• Internet and social networks The ABC approach.
• Search semantics.
• Adopt good internet search practices.
• Monitoring tools (RSS feed, monitoring platform, etc.).

To process information

• Sort, validate, synthesize information.
• Structure and prioritize messages.
• Pay attention to weak signals.
• Visualize 'competition information.'}

Share and disseminate information

• Types of publication.
• Publication vectors.
• The distribution plan.
• Branding takes care.

Description

The increasing digitalization of customer relations now makes effective management of measurement and data on the Internet essential. Collecting digital data, analyzing it correctly and activating it on different channels is today a daily concern for marketing, digital marketing, communication and IT departments. This seminar will give you a complete vision, from consolidated reporting to specific measures: fixed sites, mobile sites, applications, media investments, social media. An essential seminar in the era of data marketing.

Who is this training for ?

Training objectives

Master the concepts and terminologies linked to Web measurement Master the key Internet indicators Understand the different worlds of digital data (site-centric, e-reputation, campaign report, etc
) Acquire the keys to managing your investments and optimize the customer journey on your digital device Know the different types of data that you can use (first party data, second party data, etc
) Know the new opportunities for using data (A/B test, personalization, relationship customer


)

Training program

The challenges of data in digital strategies

• Digital management: carefully evaluate the customer journey, have a synthetic and transversal vision of your strategy.
• Performance indicator, optimization indicator: prioritize your indicators to make the right decisions.
• Internet dashboards: have an integrated and interactive vision, zoom on the new BI tools in the Web era.
• DMP, the new databases in cookie mode, understand the building blocks of a "Data Management Platform".
• DMP, the entry point for new media strategies: for what uses and for what advantages?.
• A different site for each visitor, data to personalize the experience of Internet users on your site.
• Data to optimize customer relations in real time, new customer relations tools.
• Manage your site optimization projects in "test and learn" mode: A/B or multi-variable testing tools to know.
• Point on cookie legislation, how to be in compliance phase with the regulations imposed on the use of cookies?

Management and exploitation of data from its website

• The fundamentals of "site-centric" measurement.
• Tags and cookies, understanding how data is collected and the limits of "site-centric" measurement.
• Which "site-centric" solutions to choose?.
• Panorama of market solutions: Adobe Analytics, AT internet, Universal Analytics, Comscore...
• Properly configure your objectives and conversion funnels, to give meaning to your "site-centric" measurement.
• Campaign coding and URL Tracking: a prerequisite for analyzing the performance of your investments .
• TMS, Tag Management System tool, the new essential component in Internet data collection.
• Container, tag, trigger: understanding the components of a "Tag Management System" to centralize all your tags.
• Define your Datalayer, how TMS facilitate data collection on your site.
• ? Choose a "Tag Management System" solution.
• Panorama of market solutions (Tag Comander, Adobe Tag Manager, Google Tag Manager...).

Data for the optimization of your advertising investments

• Indicators to monitor your emailing campaigns: deliverability, opening rate, reactivity rate, hard bounce.
• Natural referencing: manage your presence on the engines (visibility, number of impressions, click-through rate...).
• Paid SEO, indicators to optimize your campaigns: click-through rate, quality score, lost impressions.
• Display campaigns, performance indicators: adversing indicators, completion rate, visibility rate...
• Campaign arbitration, the end of attribution to the last click?.
• What indicators to better evaluate the role and contribution of each lever on the customer journey?.
• Mediaplanning, the evolution of panels: how Médiametrie has adapted to uses (mobile panel, tablet panel, etc.)?.
• Evolution of calculation methods.
• Specific programmatic tools.
• What new tools and indicators to evaluate banner campaigns?

Social networks: management and social data

• Measure your reputation on the Web: share of buzz, net sentiment...
• What indicators to evaluate your reputation on the Internet?.
• E-tools -reputation (listening consumer): operation.
• What settings to implement? Focus on the different market players.
• Facebook Insight: evaluate the performance of your community management (number fans, reach, virality of posts...).
• Twitter Analytics, Youtube Analytics, Simply measured...; monitor your presence on social networks.
• Advertising on social media: new targeting and management of advertising campaigns on social networks.
• Social management platform (Bringr, Hootsuite, etc.): properly manage your speeches on social networks.

IT security combined with digital

• Reminder of the mandatory rules regarding the security of personal data.
• Security documentation and its necessary evolution.
• The necessary awareness of security issues.
• Reflections on the case law defining security law.
• Some practical advice in terms of organization, documentation and measures for risk departments.
• Computer fraud, the Godfrain law in the digital age.
• Notification of security breaches.
• Security certifications.

Description

Requirements engineering is fundamental in projects. It helps clarify and validate needs, ensuring that what is provided is what was needed to be achieved. This training provides you with all the necessary knowledge on the IREB standard and prepares you for Foundation certification.

Who is this training for ?

Training objectives

Know the fundamental concepts of requirements engineering
Understand requirements engineering practices
Pass the Foundation IREB® Certified Professional for Requirements Engineering certification

Training program

Introduction and fundamentals

• General presentation.
• The interest of requirements engineering.
• The basic concepts.

Define the scope and context of the system

• Define the context of the system and its limits.
• Define the perimeter of the system and its limits.

Elucidate requirements

• The sources of requirements.
• The categorization of requirements according to the Kano model.
• The elucidation techniques.

Document requirements

• The different documentary forms.
• The different types of documents.
• The structure of documents.
• The use of documents requirements.
• The quality criteria of the requirements document.
• The quality criteria of the requirements.
• The notion of a glossary.

Document requirements in natural language, using models

• The effect of natural language.
• Writing requirements using a template.
• Models in general, goal models , use case models.
• The three perspectives on requirements.
• Requirements modeling in the structural perspective.
• Requirements modeling from the functional perspective.
• Requirements modeling from the behavioral perspective.

Validate and negotiate requirements

• The fundamentals of requirements validation.
• The fundamentals of requirements negotiation.
• The facets of requirements quality.
• The principles of requirements validation.
• Requirements validation techniques.
• How to negotiate requirements.

Manage and equip requirements

• The characterization of requirements with attributes.
• The different views on requirements.
• The prioritization of requirements.
• The traceability of requirements.
• Requirements versioning.
• Managing requirements changes.
• The different types of tools.
• The implementation and evaluation of a tool.

CPRE Fundamental Exam

• Tips for the exam.
• Mock exam with commented correction.
• Mock test.
• Taking the exam .

Description

This seminar presents the fundamental principles necessary for setting up and administering a storage network. It addresses the key points of all phases of a SAN/NAS implementation project: collection of storage needs for company applications, choice of a supplier, definition of the architecture, migration of applications on the SAN, and finally administration. The main aspects of the course concern both technical and organizational aspects. Technological developments are evaluated from the point of view of their use by the company.

Who is this training for ?

Training objectives

Discover the key points of managing a storage network Understand the different components of a storage network Define a storage type for a specific application Manage a SAN/NAS implementation project Organize the administration of a storage network

Training program

Which storage for which application?

• Storage seen as a new paradigm.
• Application storage needs.
• How are SAN and NAS different from each other? the other? What are the candidate applications for migration to the SAN? What are the applications intended for the NAS? Is the RDBMS data intact on a NAS? What applications for SAN and for NAS? Advantages and disadvantages of SAN and NAS.
• What is ROI, TCO? Can we justify the cost of a storage network?

The components of a storage network

• The basics of the Fiber Channel protocol.
• Why move from SCSI to Fiber Channel? Description of the limitations of SCSI.
• What is Fiber Channel does it represent progress compared to SCSI? Fibre Channel terminology.
• Choice and construction of an ISCSI storage network.
• Evolution of Ethernet hardware towards 10 Gb, specific architecture and configuration for ISCSI.
• The price/performance gap between Fiber Channel and ISCSI depending on the architectures and hardware used.
• Backup architectures: client traditional backup.
• Lanfree and Serverfree Backup.

The hardware components of a storage network

• Cables: description of the different single-mode and multi-mode types, and maximum distances.
• GBICS: optical converters and the new generation (SFP).
• HBA: the Host Bus Adapters and the dual access path allowing fail-over, load balancing.
• Hub: shared bandwidth, 'bypass' mode.
• Topologies based on Hubs.
• Switch: aggregate bandwidth.
• FSPF path optimization protocols and limits.
• Monitor inter-switch links.
• Network topologies/arbitrated loop and switched Fabric.
• Why choose a director rather than numerous departmental switches? Storage bay: comparison of the main internal architectures, main operating principles.
• How do the latest developments meet the needs of applications? NAS head: main characteristics of a NAS head, SAN/NAS convergence architecture.

Software components of a storage network

• Business Continuance Volume: mode of operation, data consistency constraints, types of use.
• Suitability of applications with BCV.
• Snapshots: operation, advantages and disadvantages.
• Snapclones: description of operation.
• Continuous Data Protection: management of reverting volumes to a previous state.
• Data replication between arrays : mechanisms in synchronous/asynchronous mode, choice in environments.
• How far can data be replicated? High availability.
• Data deduplication.
• Impacts on application performance.
• New asynchronous technologies.
• Storage virtualization.
• Add the flexibility and mobility of your data on a site or between sites.

Fiber Channel Protocol

• Fiber Channel layers: list of their functions.
• Classes of service: concept of Buffer to Buffer, credit and main uses.
• Naming and usage convention addressing (WWN).
• Conversion to internal address.
• Arbitrated loop: description of the topology and the arbitration procedure.
• Manufacturer: description of 'a logical network.
• How to establish redundancy in the SAN? FCoE (Fibre Channel over Ethernet) standard, CNA (Converged Network Adapter).

Implementation

• Inventory and collection of needs.
• Criteria for selecting candidate machines.
• Evaluate the necessary volume.
• Should we calculate the IO load? To what extent should we detail the components of the architecture? The specifications: the elements to integrate.
• The choice of supplier: the pitfalls to avoid.
• Procedure for defining the SAN/NAS architecture.
• Migration: the different options for migration.

Organization of administration

• In-band and outband administration: administration outside the storage network and in the Fiber Channel.
• Alert devices: Snmp, Http, Telnet, call-home.
• When should you implement a monitoring system? Security issues.
• Adding servers or volumes: Zoning, Lun Masking, Persistent Binding.
• Monitor SAN performance.
• Conduct a performance audit, key elements to monitor depending on the components.
• Data distribution modes.
• Analysis of the consequences of the drop in access density.
• Quality of service concepts.
• Build a team of Storage Managers: define processes and procedures, Service Level Objectives.
• Storage management by attribute and the different service levels.

Description

Geolocated data have become essential elements in decision-making processes. This seminar will teach you how to better exploit the spatial component of your data and will give you the necessary keys to implement a geomarketing project within your company.

Who is this training for ?

Training objectives

Understand the principles and applications of GIS software Identify how to better promote the spatial component of your data Discover the possibilities of cartography and data visualization for decision support Understand the essential stages of implementing a geomarketing project

Training program

Geolocalized data for decision support

• Geolocation is a strategic component of direct marketing.
• Geomarketing: from mapping to spatial analysis.
• The current challenges of geomarketing, localizing to contextualize, Geographic Big Data.
• Example Concrete examples of applications and feedback.
• Exchanges with participants.

Geolocalized data and Geographic Information Systems (GIS)

• Definitions and concepts.
• Geolocating information, reference systems and projections.
• Geographic repositories: sources and producers of data.
• Demonstration Demonstration of GIS software and how it works.

What are the uses of the spatial component? Better use of your data

• Geocoding, location models, meshes and grids.
• Business to Business: customer sectors, distribution networks.
• Business to Consumer: market potential, catchment areas.
• Crossing heterogeneous data: contextualization of contracts, activities and files.
• Customer analysis.
• Case study Each participant identifies how to better promote the spatial component of its own data through the proposed case studies.

Mapping and data visualization for decision support

• Basics and principles of graphic semiology.
• Data processing for cartography: fundamentals.
• Geolocated data in dashboards: prospective in data- visualization.
• Collective reflection Critical approach to cards for decision-making: discussions with participants around a selection of cards.

Implementation of a geomarketing project

• The different stages of a GIS project.
• Functional specifications.
• Costs and human resources.
• Panorama of technical solutions (geomarketing-oriented GIS software, Web portals).
• Geo Business Intelligence tools.
• Demonstration Demonstration of tools and technical solutions for geomarketing.

Description

Data mining is based on the mastery of fundamental data exploration techniques: descriptive, predictive or exploratory statistics. This practical course will introduce you to methods such as regressions and PCA and teach you how to implement them with R software.

Who is this training for ?

Training objectives

Understand the principle of statistical modeling Choose regression type based on data type Making predictions Create selections and rankings in large volumes of data to identify trends

Training program

Introduction to modeling

• Modeling: regression.
• Statistical modeling: reminders of statistical tests.
• Data analysis.
• Introduction to R software.
• Practical work Presentation of several modeling examples.
• Installation of R and the packages to be used.
• Applications on R, tests and interpretations on examples .

Linear regression analysis

• Principle of linear regression.
• Simple regression, when the model has a single parameter for continuous data.
• Multiple regression, when there are more than 'a parameter.
• Other types of models for continuous data.
• Practical work Practical application in R.
• Case of simple regression and regression multiple.

Logistic regression analysis

• Presentation of the different types of logistic regression.
• Binary logistic regression.
• Ordinal logistic regression.
• Multinomial logistic regression.
• Practical work Application on R with practical cases for cases of non-continuous data.
• Processing on data with two modalities, then with ordinal modalities, then nominal modalities.

Component analysis

• Presentation of the different types of analyzes and selection.
• Principal Component Analysis (PCA).
• Multiple Correspondence Analysis (MCA).
• Hierarchical Classification on Principal Components (CHCP).
• Practical work The principal components make it possible to understand the covariance structure of the initial variables and/or to create a smaller number of variables to using this structure.
• Applications on R.

Factor analysis of data

• Understand the principle of factor analysis: summarize the structure of data into a fewer number of dimensions.
• Factor Correspondence Analysis (CFA).
• Analysis Multiple Factor Analysis (AFM).
• Factor Analysis for Mixed Data (AFDM).
• Practical work Factor analysis exercises on R.
• Identification underlying "factors" of dimensions associated with significant variability.

Description

After discovering the basic concepts and techniques related to visual representation of data, you will learn to develop data visualization applications based on DataVisualisation's main Java/JavaScript tools and frameworks.

Who is this training for ?

Training objectives

Find out what data visualization is Understanding the keys to designing data visualizations Use APIs for data visualization Develop with the main data visualization frameworks

Training program

Introduction to Information Visualization

• Definition, notions and objectives.
• Role of the user and interaction.
• Common diagrams: histograms, pie chart, 3D.
• Multidimensional visualization: point clouds, Inselberg diagrams.
• Multi-level visualization: hierarchical data, full zoom.
• Visualization techniques: fisheyes, hyperbolic view.
• Visualization of networks: hierarchical, radial.
• Visualization by force model: energy model, spring.
• Exchanges Discussions and exchanges on techniques processing.

Graphic semiology: the basis of visualization

• The human visual system.
• Visual variables.
• Perceptual properties.
• Extension of semiology: movement.
• Case study Use of different visual variables.

Animated transitions and interactive captions

• Definition, notions and goals.
• Animations and interactive captions in visualizations.
• Manipulation of visual variables.
• Rules to respect.
• Added values.
• Practical work Manipulation of visual variables.

Tools for information visualization

• DataVisualisation JavaScript frameworks.
• DataVisualisation Java frameworks.
• Some additional tools.
• Practical work Getting started with Frameworks.

Network visualization

• Types of networks (scale-free, small world.
• ).
• Analysis of a network (lexical network, social network, corpus of texts.
• ).
• Creation of a network-oriented visualization (in Java/JavaScript).
• Setting up and choosing the different interaction levers: full zoom , selection.
• Usage experiences.
• Practical work Development of network-oriented visualization applications.

Viewing diagrams

• Study of a data set.
• Creation of several interactive diagram-oriented visualizations (in Java/JavaScript).
• Setting up and choosing different interaction levers: interactive legends, hover etc.
• Usage experiences.
• Practical work Development of diagram-oriented visualization applications.

Description

A summary presentation of the technical characteristics of the Oracle offering and its recent developments intended for all those who wish to understand the principles and operating mechanisms of the DBMS.

Who is this training for ?

Training objectives

Understand the key elements of an Oracle database

Discover the relational model

Evaluate SQL and PL/SQL data manipulation languages

Analyze the elements making up the architecture of an Oracle database

Training program

Data Server Overview

• Relational model.
• Integrity constraints.
• Data types.
• Object-relational model.
• Data manipulation.

Database access languages

• SQL language: ANSI.
• Structure of the SQL language.
• PL/SQL language.
• Procedural functionalities.
• Oracle and XML.
• Embedded SQL.
• ODBC.
• Oracle Objects for OLE.
• Java , JDBC and SQLJ Driver.

Oracle Server Features

• Security features.
• User identification and privileges.
• Data dictionary.
• Query optimization.
• Event management and alerts.
• Transaction management.
• Globalization (NLS).
• Real Application Cluster.
• Symmetric Replication.
• Advanced Security.
• Standby Database and Oracle Data Guard.
• Virtual Private Database.
• Recovery Manager tool .

Database architecture

• Composition of the database.
• Architecture of an instance.
• Structure of the database.
• Tablespaces.
• Data partitioning

Net Services

• Connectivity and security.
• High activity support.
• Connection Manager and Multiplexing.
• Extended security services.
• Net Configuration Assistant.
• Native Hostname Adapter.

Data versioning

• Oracle Flashback Query.
• Restitution of data deleted by mistake.
• Workspace Manager.
• Creation of Workspaces.
• Declaring versioned tables.
• Visualizing data differences.

The Objects extension

• Object support.
• Using LOBs.
• The BFILE type.
• Collections: nested tables and VARRAY.
• Operators and methods on objects.
• Object Type Translator.

Oracle 11g contributions

• Performance.
• Simplifying maintenance.
• Security.
• Tools and Oracle Grid Infrastructure.
• Oracle Restart.
• Database migration.

Description

This very practical training aims to develop advanced aspects of the SQL language such as set operators, management of LOBs, Bfiles and XML, aggregation and statistics functions.

Who is this training for ?

Training objectives

Training program

Additional functions

• Transformation functions.
• Analytical functions: Rank, Dense_Rank.
• Hierarchical function.
• Other functions: Rowid, etc.
• Practical work Formatting disparate data (dates, numerics), list of a hierarchy at several levels.

The assembly operators

• Union and Union ALL.
• Difference Minus.
• Exists, Some, Any, All.
• Practical work Research of differences between several tables.

Management of LOBs and Bfiles

• Possible uses.
• Definition of tables.
• Insertion and updates of LOBs.
• Management of a Bfile.
• Practical work Adding a photo to a table, adding a CV to a table.

Aggregation, joins and sub-select

• Aggregation and statistical functions: Group By Rollup.
• Group by Cube.
• Group by Sets.
• Recalling joins "classics".
• Self-join.
• FULL, RIGHT, LEFT.
• Sub-select correlated/uncorrelated with Insert, Update , Delete.
• Practical work Statistics and groupings based on several criteria.
• Creating a table from other tables.

Integrity management

• Reminder of definitions: uniqueness, referential, consistency.
• Implementation: Primary Key, Foreign Key, Increment, Check.
• Principles of use.
• Good practices and limits.
• Practical work Creation of referential integrity tables.
• Addition/removal of integrity constraints and checks by Check.

XML management

• Storing XML.
• Using advanced XML functions.
• Practical work Managing an XML document.

Data partitioning

• The different types of possible partitioning.
• Implementation of data partitioning.
• Practical work Creation of partitioned tables, reloading of data.

Managing remote tables

• Reminder of the principles: schemas, ODBC, DRDA.
• Access to a remote table.
• Joins with remote tables.
• Work practices Reading tables from other comics.

Description

This course is essential for anyone who wants to establish an effective backup strategy for Oracle 12c database. They will mainly see operation in ARCHIVELOG mode, RMAN, specific backup/restore scenarios, LogMiner and the use of Flashback Database.

Who is this training for ?

Training objectives

Establish a backup and restoration management strategy for an Oracle 12c database Apply RMAN tool features Restore an Oracle database following file loss Duplicate an Oracle database Move an Oracle database

Training program

Reminders

• The redo log, control and data files.
• ARCHIVELOG mode.
• The DBNEWID utility.
• Exercise: Save the control file and change the database name.

RMAN Components and Features

• Configuration and commands.
• Automatic backup of the control file.
• Compression, encryption and parallelism of backups.
• Save a CDB and PDB database.
• Incremental backup.
• Multisection backups.
• Exercise: Compressed and parallelized backup of the database.

Maintenance de RMAN

• Creating the catalog and virtual catalogs.
• Enrolling in the catalog.
• Adding or removing catalog backups.
• Stored scripts and saving the catalog.
• Exercise: Creation of the catalog and registration of the database.

Maintenance de RMAN

• Creating the catalog and virtual catalogs.
• Enrolling in the catalog.
• Adding or removing catalog backups.
• Stored scripts and saving the catalog.
• Exercise: Creation of the catalog and registration of the database.

File loss and recovery

• Losing control files.
• Rebooting with missing files.
• Losing files from the UNDO tablespace or a read-only tablespace.
• Use RMAN.
• The RESTORE and RECOVER commands.
• Validating backups and the database.
• Checks and list of failures.
• Exercise: Restoring the database after losing files.

Duplicate a database

• Duplicate a database.
• Choose the PDB databases.
• Duplicate a database without stopping it.
• Exercise: Clone a hot database.

Incomplete recovery

• Configure and use LogMiner.
• Incomplete recovery of a tablespace or an inserted PDB database.
• Restore a database to a previous incarnation.
• Exercise: Find the deletion SCN of a deleted object and recover the object.

Flashback Database

• Flashback Database and backup of the quick recovery area.
• Flashback on a table deleted in PDB.
• Exercise: Recovering a user with Flashback Database and a tablespace with RMAN.

Data movement

• Data Pump and transport of a tablespace or the database.
• Use external tables.
• Transport a database to another OS.
• Exercise: Transporting a tablespace from one database to another.

Description

This course will allow you to master RMAN tools, advanced features such as using a catalog, stored scripts, duplication and transport of cross-platform databases.

Who is this training for ?

Training objectives

Training program

Introduction and reminders

• Network configuration.
• Redo log files.
• Control files.
• Data files.
• Archivelog mode.
• The quick recovery area.
• Practical work Configuring the database in Archivelog mode.
• Start the database remotely.

Introduction to RMAN

• Architecture.
• Client utility.
• Basics.
• The control file.
• The memory usage.
• The quick recovery area.
• Persistent configuration in the target database control file.
• Channel concept and use of channels.
• Practical work Configuration of the control file.

Media managers

• Magnetic tapes.
• Media Manager.
• Media Management Library.
• Tape backup/restore.
• Oracle Secure Backup.
• User interface.

Backup with RMAN

• Cold/hot backup.
• Image copies vs. backup sets.
• Backup compression.
• Full backup/ incremental.
• Processing read-only files.
• Corruption test.
• Using command groups.
• RUN command.
• SET command.
• Backup of tablespaces, files, archived redo log files, control file, SPFILE file.
• Practical work Using commands BACKUP and RUN.

Restoration/recovery with RMAN

• RESTORE command.
• Restoring the SPFILE file and the control file.
• Restoring a specific/old backup.
• Restoration with renaming.
• The RECOVER command.
• Partial/incremental recovery.
• Practical work Restoration to a new location.
• Recovering a database following file loss.

Maintenance de RMAN

• The catalog database.
• Creation of the catalog.
• Registration of target databases.
• Addition of catalog backups.
• Using stored scripts.
• Saving the catalog database.
• The LIST command.
• The REPORT command.
• Views.
• CROSSCHECK, CHANGE and DELETE commands.
• Practical work Creating the catalog.
• Using stored scripts and LIST commands and REPORT.
• Checking backups.

Advanced Features

• Block corruption.
• TableSpace Point-In-Time Recovery (TSPITR).
• Cloning a database.
• Practical work Recovery of corrupted blocks.

Description

administration, security, development, performance, high availability: there are many new features in the SQL Server 2016 database engine. This course will provide you with knowledge of the most useful new features for an informed and efficient implementation of SQL Server 2016.

Who is this training for ?

Training objectives

Review the additions of the 2016 version of SQL Server Know the new features for administration, security and performance monitoring Know what’s new for database development and design Understand major enhancements to In-Memory and Index Column Store technologies

Training program

Overview of SQL Server 2016

• Review of the contributions of the 2012 and 2014 versions.
• Overview of the contributions of the 2016 version.
• Migrate from previous versions.
• Practical work Migrate a database from a previous version.

New features for administration and security

• New features and improvements for installation and configuration.
• Best practices.
• Scenarios with the Cloud: Stretch Databases, to archive historical data in Azure .
• Backup to Azure.
• Encryption from the client to the database: Always Encrypted (or "full encryption").
• Multi-tenant architectures and Row Level Security.
• Masking sensitive data from unauthorized users, with Dynamic Data Masking.
• High-end improvements AlwaysOn availability.
• Basic availability groups with the Standard version.
• Practical work Use Always Encrypted, use row-level security, mask data with Dynamic Data Masking.

What's new for development and design

• Automatic preservation of a history of table data, with temporal tables ("Temporal tables").
• JSON support.
• Functions to use data in JSON format.
• New features of the TSQL language, new commands and functions.
• Practical work Implement temporal tables.

What's new in the In-Memory and Index Column Store

• Reminder about In-Memory OLTP and Column Store Indexes with SQL Server 2014.
• The new capabilities of In-Memory OLTP with SQL Server 2016.
• Real-Time Operational Analytics: the new possibilities of Index Column Store reading/writing.
• Practical work Experimenting with In-Memory tables and Index Column Store.

New for performance

• Optimizer behavior with SQL 2016/2014.
• New commands and directives with ALTER DATABASE SCOPED CONFIGURATION.
• Track and improve performance with the Query Store.
• Practical work Configure the Query Store.

Description

This course offers you a focus on the new features of SQL Server 2014 that are essential for efficient and secure use. You will see in particular the latest developments in terms of administration, optimization, security, high availability as well as the new components of the SQL Server BI solution.

Who is this training for ?

Training objectives

Discover the main contributions of the 2014 version of SQL Server Understand major improvements for administration and security Get an overview of new features intended to improve performance Understand the purpose of using In-Memory OLTP in 2014 and how it works Understand the principles and purposes of high availability with SQL Server 2014 See the new components of the SQL Server BI solution in 2014

Training program

Overview of SQL Server 2014

• Overview of the main features of version 2014.
• Migrate from previous versions.
• Integration with Windows Server 2012.
• What's new in SQL Server Management Studio.
• Practical work Migrating from a previous database.

New features for administration and security

• New features in backups: encryption and integration with Windows Azure.
• New features in extended events (Xevents).
• New features in the resource governor for inputs/outputs.
• Using Storage Spaces with Windows Server 2012.
• Improvements to support network shares in SMB 3: SMB Transparent Failover, SMB Direct.
• New permissions.
• Practical work Use of extended events, encryption of backups.

New for performance

• Clustered ColumnStore index: columnstore indexes on write-enabled tables.
• The new cardinality estimation engine.
• Controlling the durability of the transaction.
• Extending the data cache on SSD disk.
• Incremental statistics calculation.
• Practical work Creation of a table with index ColumnStore, Checking the durability of the transaction.

In-Memory OLTP

• What is In-Memory OLTP? What are the use cases? Creating in-memory tables.
• Interoperability with traditional tables.
• Creation of hash indexes and b-tree indexing.
• Creation of native compiled stored procedures.
• Practical work Creation and use of In-Memory tables .

High availability

• The principles of high availability with SQL Server 2014.
• Always On Availability Groups.
• Enhancements since SQL Server 2012.
• Integration with Windows Azure.

New features for business intelligence

• A few reminders about business intelligence with SQL Server.
• The tabular model.
• Integration with Hadoop, HDInsight connectors.
• Power View for Excel.
• Power BI for Office 365.
• Power Query for Excel 2013.
• Power Map for Excel 2013.
• Practical work Demonstration of an HDInsight connection.

Description

This course will provide you with the knowledge necessary to install, configure and administer a SQL Server 2014 or 2012 database server. You will discover the architecture of the server, learn how to configure it and monitor its operation, manage storage spaces, automate tasks and perform backups and restores.

Who is this training for ?

Training objectives

Install and configure the Microsoft SQL Server DBMS Create a database and organize data file storage Define permissions and access controls on the database and manage certificates Automate and schedule routine administration tasks Create data backup and recovery plans Implement continuous monitoring of the database on modifications and its performance

Training program

Installation et configuration

• The tasks of the administrator and the means at his disposal.
• General architecture of SQL Server 2012.
• Installation, migration.
• Configuration tools.
• SQL Server Configuration Manager.
• Service and network management tool.
• Presentation of client tools.
• System objects and databases.
• Practical work Installation of SQL Server.
• Using dynamic consultation tools.
• Configuration using Policy Based Management (PBM).

Storage space management

• Storage engine and physical storage.
• Object allocation.
• Table partitioning and indexes.
• Partition function.
• Partition scheme.
• Calculated columns.
• Managing database size and growth.
• Database dumps ( SNAPSHOT).
• Snapshot operationsrnInserting and importing data.
• Main options for BULK INSERT or BCP.
• Practical workr nCreating a database.
• File management.
• Creating snapshots.

Security and encryption

• External and internal security.
• Secure connection and sessions, internal security model.
• Authentication modes.
• Resolution names.
• Roles: server roles, fixed database roles, user-created roles, application roles.
• Assignment of privileges (Grant, Revoke , Deny .
• .
• ).
• Ownership chaining.
• Contained Databases.
• Context of 'execution.
• Data encryption (symmetric, asymmetric).
• Encryption architecture.
• Database master key.
• Backing up and restoring keys.
• Extensible Key Management.
• SQL Server certificates, example usage.
• Encryption metadata.
• Transparent Data Encryption.
• Database audit, syntax for creating events to audit.
• Practical work Manipulation of permissions and access controls.
• Certificate management.

Administrative tasks

• Task scheduling by the SQL Server agent.
• Job organization: job categories, step types, precedence rules and errors, notifications.
• Job scheduling, MSDB specific roles.
• Execution log, monitor.
• SQL Agent settings.
• Configuring alerts and of notifications.
• Managing operators.
• Sending emails from SQL Server: configuration of Database Mail and Agent parameters for sending emails.
• Configuring multi-server jobs.
• Event redirection DDL triggers.
• SQL Server events: performance, WMI, WQL.
• Physical integrity check.
• Retrieve low-level information about the SQL Server (DBCC) engine.
• Index structure reminders and index maintenance.
• Indexed views.
• Full text index.
• Recalculation of statistics.
• The maintenance plan tool.
• Use SQL Server Data Tools.
• Practical work Automation and scheduling of administrative work.

Backups and restores

• The different types of backup (full, differential, journal.
• .
• ) Recovery mode (full, simple, bulk journaled.
• .
• ) and influence on data recovery.
• Establishment of a backup strategy.
• Backup security .
• T-SQL backups: integrity.
• Multi-file, multi-family backups.
• Scheduling backups.
• Base restoration, repairing damaged environments.
• Log restoration.
• Restoration in a different database.
• Page restoration.
• Base backup system.
• Master restoration.
• Practical work Creation of backup and restoration configurations.

Monitoring and performance

• The profiler and the eXtended Events (XEvents) to trace usage.
• Extended events.
• DDL triggers to trace structure modifications.
• Metadata views and dynamic management views.
• Metadata stored procedures.
• Windows performance monitor.
• Counters and user events.
• Database Tuning Advisor.
• Visualization of locks and blocks, detection and treatment of deadlocks.
• Configuration of the server and databases.
• The resource governor.
• Practical work Setting up monitoring on structure modifications.
• Using the views of dynamic management.
• Management of a deadly lock.

Description

This course will teach you how to choose and implement the best high availability and disaster recovery strategy with SQL Server 2012/2014. You will see the different types of replicas, the latest enhancements as well as the geographically dispersed server cluster solution.

Who is this training for ?

Training objectives

Understand the principles of high availability solutions offered in SQL Server Know the prerequisites and essential conditions for setting up an AlwaysOn failover cluster Configure a disaster recovery solution with Always On availability groups Implement a log shipping solution Identify the advantages and limitations of other availability solutions offered in SQL Server

Training program

Comparison of high availability solutions

• Definition of HADR, High Availability and Disaster Recovery.
• Comparison of the solutions offered in SQL Server.

AlwaysOn Failover Cluster Instances (Clustering Services)

• AlwaysOn Failover Cluster Instances (Clustering Services)

Always On Availability Groups, disaster recovery solution

• Operating principles, difference with the mirror in previous versions.
• The different types of replicas.
• Synchronous-asynchronous validation modes.
• Using the listener for client redirection.
• Securing the TCP channel.
• Monitoring with dynamic management views and performance counters.
• Improvements in SQL Server 2014.
• Manage manual failover.
• Practical work Setting up an Always On availability group.

Other high availability methods

• Using replication for high availability.
• Copying backup files with log shipping.
• Using the Broker service with AlwaysOn availability groups.
• Hardware solutions.
• Third-party software offers.
• Geo-cluster, geographically dispersed server clusters.
• Practical work Implementation of a log shipping solution.

Description

This training will teach you to master the MDX (Multi-Dimensional eXpressions) language to query your multidimensional data. You will see how to design scripts, query SQL Server 2005/2008 Analysis Services cubes and add business calculations to these cubes.

Who is this training for ?

Training objectives

Write basic queries in MDX
language Develop advanced indicator calculation formulas in MDX
language Use sorting and classification instructions for data with MDX
Modify data in a cube with MDX language

Training program

General overview of the MDX

• Reminder of the principles of OLAP.
• Definition of the language.
• The underlying mechanisms.
• The different uses of MDX with Analysis Services.
• Presentation of the basic concepts of the language (member, tuple, set, hierarchy.
• ).
• Practical work Examples of queries and use cases.

MDX Query Design

• Using the query development tool.
• Statement syntax ?'SELECT'.
• Writing complex queries.
• Use of key words and functions of the MDX language.
• Practical work Getting started with the development tool.
• Writing simple and complex MDX queries.

Calculated Members and Named Games

• Definition and usage scenarios for calculated members.
• Definition and usage scenarios for named sets.
• Syntax for writing calculated members and named sets .
• Practical work Example of creating business calculations (margin, relative contribution, reallocation).

Navigation and selection

• Navigation in dimension hierarchies.
• Handling NULL and division by 0.

Sorting and classification of data

• Perform sorting, ranking, rankings on members via the MDX.
• Usage scenario.
• Practical work Use of sorting and sorting instructions classification of data with MDX.

Scripting de cubes SQL Server Analysis Services avec MDX

• Adding business calculations and functionalities to OLAP cubes with MDX.
• Usage scenarios.
• Practical work Writing a script for customize a cube.

Changing the multidimensional environment

• Writing to OLAP cubes (Writeback): creation, update.
• Modification, deletion of a cube with MDX.
• Using transactions.
• Practical work Updating data with MDX.

Description

Who is this training for ?

Training objectives

Training program

The emergence of the Object approach

• Problems in development projects.
• The emergence of Object concepts and their impact.
• The qualities expected from Object development.

Basic concepts

• The similarities and differences between the common sense object and the computer object.
• The notions of classes, encapsulation, inheritance, abstraction, polymorphism.
• Objects, properties, operations and bindings.
• The separation of interfaces and implementations.
• The advantages: extensibility, reusability, speed of design, myth or reality?

Analysis and design by objects, UML

• Reminders about the software life cycle.
• The object and the iterative approach.
• Modeling, development, actors and roles.
• History of Object methods.
• Comparison.
• Need for a universal formalism for representing concepts.
• The genesis of UML.
• The essential characteristics.
• The presentation of the unified process.
• The analysis of the specifications.
• The cases of usage.
• Scenarios and sequence diagrams.
• Domain analysis.
• Class, state-transition and collaboration diagrams.
• Design.
• Algorithmics seen through activity diagrams.
• Production with object languages.
• L 'architecture.
• Component and deployment diagrams.
• A summary comparison between Merise and UML.

The principles of successful modeling

• Reification? Why and when to put information in the form of objects? How to translate business concepts into objects? Objects as autonomous entities.
• Interaction between objects.
• Interfaces.
• Abstraction from analysis.
• Extensibility and adaptability of designs abstract.
• Reuse.
• Production by concrete classes.

The object in programming

• The major object languages.
• Which language to choose? The fundamental characteristics of the languages.
• Comparison: C++, Java, etc.
• The approaches of these object languages.
• The impact of execution modes.
• Development tools, the market, players, categories and trends.
• The characteristics of the Java language.
• The interest of a virtual machine.
• The importance of class libraries.
• The organization of a Java project.
• The "all of Java".
• From the intranet to the smart card, from mobile phones to the workstation.
• Strategies around Java.
• What attitude to adopt?

Organizing reuse with Design Patterns

• Promote reuse through the industrialization of the design process.
• Implementation of standard reusable solutions: Design Patterns.
• The work of the GOF (Gang Of Four) and the main categories of Design Patterns.

Business objects, frameworks

• What is a framework, how to use it? Relationship with software components.
• The pitfalls to avoid when designing frameworks.
• Differences between Design Patterns and frameworks.

Object-based client-servers

• Distributed object-based architectures.
• CORBA, Microsoft COM-DCOM, Java RMI.
• Contributions and limits.
• Support for technical services in order to move towards an assembly of business objects.

Business objects, application servers and n-tier architectures

• The limits of the 2-tier in terms of modularity, scalability and capacity to support an increase in load.
• The contributions of multilevel architectures.
• Opening up to the Internet.
• Security.
• Business components.
• Offers: JEE, .
• NET, Corba Component Model .
• The JEE standard.
• Extending the notions of JavaBeans components to distributed architectures.
• The players in the JEE server market, from Sun to JBoss.
• Integration.
• Object/relational mapping.
• The different types of EJB: session, entity, message.
• The architecture.
• NET.
• Portability and interoperability.
• Evolution from COM to .
• NET.
• C#, a new component-oriented Object language.
• Comparison with Java.
• The CLR infrastructure.
• The base classes of.
• NET, ADO.
• NET, WebServices.
• The Model Driven Architecture approach.
• The concepts.
• Tooling.
• Profiles and metamodel.

Object-based web infrastructures

• Web service-based architectures, operation, constituents.
• SOAP, WSDL, UDDI.
• SOA (Service Oriented Architecture), concepts.
• Business process management standards.
• The offers available.

Description

This seminar will allow you to understand the contributions of the .NET framework, particularly the latest versions, as well as its impacts on the design and development of applications. You will see the components of the .NET architecture and how to use them to develop applications.

Who is this training for ?

Training objectives

Training program

Introduction to the .NET environment

• Presentation of the framework.
• NET.
• Languages, CLR/CLI.
• Framework version 3.
• 5 and 4.
• 0.
• Principles of Just In Time compilation.
• CIL.
• Development offer Microsoft.
• Integration of .
• NET into Microsoft's product offering.
• Presentation of the main components of the framework: ASP.
• NET, ADO.
• NET, Web Services.
• Demonstration Programs developed in C# and VB.
• NET.
• JIT and CIL compilation mechanisms.

The .NET framework and .NET languages

• Presentation of the main languages: C#, VB.
• NET.
• Development approach for .
• NET: Object approach.
• Important notions in languages.
• Redistributable framework: role of the CLR in cross-language execution, execution in native code.
• Framework classes: important elements of the framework , homogeneity of classes.
• Demonstration Object and multilanguage programs.

Divers types d'applications

• Rich client application with Windows Forms.
• Thin client application with ASP.
• NET.
• Understanding the life cycle of the 'application.
• HTML control, Server control.
• Browser compatibility.
• Tracing and debugging tools with .
• NET and VS.
• Demonstration Application of Windows Forms and ASP.
• NET.
• Embedded application.

Data access in .NET

• Overview of XML and integration into the .
• NET.
• Serialization of data in XML.
• Definition of the XSD schema.
• Principle of ADO.
• NET: data access classes.
• Integration of a database connection, query generation.
• Creating lists.
• Debugging and tracing tools in SQL.
• DataBinding model and use in .
• NET.
• Demonstration Implementing DataBinding.

Web Services

• Web Services operating principle.
• Execution architecture (WSDL, SOAP, XML, UUDI, etc.
• ).
• Web Services with .
• NET.
• Remoting Objects: .
• NET Remoting.
• Execution environment.
• Demonstration Programming with ASP.
• NET and implementing a Web service.

Web Services

• Web Services operating principle.
• Execution architecture (WSDL, SOAP, XML, UUDI, etc.
• ).
• Web Services with .
• NET.
• Remoting Objects: .
• NET Remoting.
• Execution environment.
• Demonstration Programming with ASP.
• NET and implementing a Web service.

Application architecture and security

• Security management: authentication, encryption.
• Overall application architecture in .
• NET.
• Support for intelligent devices in .
• NET.
• Demonstration User identity control in .
• NET and runtime security management.

Description

The design of real-time and embedded systems requires an appropriate analysis and object design approach. In this course, you will implement, in addition to the specificities of UML modeling allowing you to respond to new problems, the best practices of associated software design.

Who is this training for ?

Training objectives

Carry out the different activities of a software development process using UML Master the specificities of UML modeling of real-time and embedded systems Acquire good software design practices

Training program

Object concepts and UML presentation

• Object approach: qualities and advantages.
• Presentation of the fundamentals: class, member, encapsulation, inheritance, polymorphism.
• Introduction to UML.
• Modeling language.
• Development process.
• Assets and tools.
• UML and real time.
• Mechanism of 'extension.
• The UML meta-model.

Expression of needs

• Need-oriented expression.
• Actors, use cases and scenarios.
• Expression of constraints: OCL.
• Identification of domain objects.
• Architecture of the future computer system.

Analysis: object model

• Objectives.
• Classes and instances.
• Identify objects.
• Associations, inheritance and generalization, composition and aggregation.
• Identify relationships, attributes and operations.
• Annotations and constraints, meta-model, stereotype, interfaces.
• OCL (Object Constraint Language).

Use case

• Business processes and use cases.
• High-level or developed, essential or real use cases.
• "include" and relationships

Static and dynamic models

• Association, roles, qualifiers, constraints.
• Aggregation, composition, inheritance.
• Packages.
• Static class diagrams, d 'objects, components, deployment.
• Dynamic collaboration, sequence, state-transition, activity diagrams.
• Typical design errors.

Design of a real-time system

• Specificity of real-time projects.
• Principle of extensions in UML.
• Profile concepts.
• Parallelism and synchronization of processes.
• Representation of protocols, connectors and ports.

Conception et design patterns

• Introduction to Design Patterns.
• Areas of use and uses of Design Patterns.
• The GOF catalog.
• Design patterns and architecture (Singleton, Template method, Factory, DAO, Transfert Object.
• ).

From design to completion

• Associations, aggregations, composition, dependence.
• UML extension (stereotype, label.
• ) and interpretation in C++.

Description

SysML, the variant of UML 2 standardized by the OMG, is particularly suited to the field of industry and the modeling of complex systems (aeronautics, automobiles, energy, weapons, etc.). You will see how to use it effectively and discover the new SysML specific diagrams.

Who is this training for ?

Training objectives

Use block diagrams for structural modeling of complex systems
Master the sequence diagram, the state diagram and the activity diagram for dynamic modeling
Model system requirements and relate them to the structural and dynamic elements of the modeling
Represent system constraints using the parametric diagram

Training program

Introduction

• Objectives and origin of SysML.
• Positioning of SysML in relation to UML 2.
• Presentation of SysML diagrams.
• Presentation of a possible approach to use.

Requirements modeling

• How to start analyzing a complex system? Start with the SysML requirements diagram, use case and sequence diagrams of UML 2.
• Use of requirements diagrams.
• Manage requirements.
• Relationships between requirements.
• Traceability.
• Use of requirements diagrams. 'usage (Use Case).
• The actors, the relationships between actors.
• Define scenarios based on use cases.
• The diagrams of sequence.
• Usage.
• Components.
• Temporal constraints.
• Practical work On the case study, identification of requirements and use cases.
• Creation of diagrams.

Structural modeling

• Describe the architecture of a complex system in the form of interconnected subsystems using block diagrams.
• The concept of blocks.
• Part.
• Composition.
• Aggregations, associations, generalization, operations.
• Internal block diagram.
• Objectives.
• Interfaces.
• Use of the package diagram.
• Packages.
• Relationships between packages.
• Work practices Division of the system into blocks.

Dynamic modeling

• Describe the dynamics of a complex system using state and activity diagrams from UML 2.
• States, events, transitions, conditions.
• Usage of the activity diagram.
• Execution semantics.
• Interruptible region.
• Expansion region.
• Reuse.
• System additions.
• Practical work Creation of state and activity diagrams.

Transversal modeling

• Describe the constraints that govern the system using the SysML parametric diagram.
• Detail of the parametric diagram.
• Constraints.
• The link with the requirements.
• The notion of allocation.
• The tabular representation.
• Return to the requirements.
• Practical work Creation of a parametric diagram.

Conclusion

• Links between the different diagrams.
• Available tools.
• Useful resources.
• The need to use SysML with a Steps.

Description

This internship will allow you to master all the administration tasks of a MariaDB database server. You will see how to install the server, configure it, perform backups/restores and manage production.

Who is this training for ?

Training objectives

Learn about the MariaDB SGDB
Be able to install and configure MariaDB
Understand how to manage security
Be able to maintain the MariaDB server
Learn how to manage backups and restores

Training program

Introduction et installation de MariaDB

• Versions and license types.
• MariaDB tools (client and administration).
• Server configuration: configuration files and parameters.
• Startup/stop.
• Installations (binary, from sources).
• Practical work Installation of MariaDB under Linux/Windows and use of client and software tools 'administration.

Objects of a MariaDB database

• Table types (MyISAM/Aria, XtraDB/InnoDB, FederatedX, Cassandra, SphinxSE, HandlerSocket.
• ).
• Changing the definition of a table.
• Index and view management.
• Base information_schema and performance_schema.
• Practical work Creation and use of views.
• Creation, modification of the definition of a table.
• Creation of indexes.
• Use of catalog databases.

Connections, access rights, security

• User authentication.
• MariaDB system databases and their contents.
• Management of users and their privileges.
• Rights on stored views and processing.
• Using SSL.
• Practical work Complete post-installation security.
• Creating MariaDB accounts .
• Security management under MariaDB.

Storage engines and plug-ins

• Engines: MyISAM/Aria, XtraDB/InnoDB, Memory, Archive CSV, FederatedX, Blackhole, CassandraSE, SphinxSE, HandlerSocket.
• Transactional operation of the XtraDB/InnoDB engine.
• Table locking.
• MyISAM/Aria query cache and index cache.
• Practical work Changing the XtraDB/InnoDB settings.
• Implementing transactions.

Maintaining a MariaDB server

• Session status (variables, "show status" command), forced termination of a session.
• Loading: LOAD DATA, myimport, SELECT INTO OUTFILE, mysqldump.
• Logs (general, errors, slow queries.
• ).
• Backup strategies.
• Backup methods and available tools.
• Backup and incremental recovery.
• Statistics update and defragmentation.
• Practical work Activation of logs.
• Tools loading/unloading.
• Backups and restores with "mysqldump".
• Using the binary log.
• Incremental backup.
• Incremental recovery.

Description

The PostgreSQL DBMS has the majority of features that can be found in commercial products like Oracle or DB2. This training will teach you how to use it effectively, in particular how to create and operate a database, or how to program with the PL/pgSQL language.

Who is this training for ?

Training objectives

Training program

Introduction

• PostgreSQL presentation, versions.
• The relational model, the schema.
• Tables, constraints.
• User interfaces.

SQL avec PostgreSQL

• The SQL standard.
• Positioning PostgreSQL.
• Setting up a database schema.
• PostgreSQL data type.
• Tables.
• Sequences.
• Views.
• Integrity constraints on tables.
• Addition , modification and deletion of data.
• Querying the schema of a database.
• Selection, restriction, sorting, joining.
• Complex extractions.
• Using operators.
• PostgreSQL SQL specificities.
• Advanced PostgreSQL features.
• Transactions.
• Views.
• Tables.
• Table inheritance.
• Practical work Creating a schema.
• SQL DDL script.
• Creating views.
• Transaction scenarios.

Le langage PL/pgSQL

• Instructions, types of the language.
• Code blocks.
• Control structures.
• Errors and exceptions.
• Cursors.
• Declare, move and close.
• Procedures and functions.
• Adding subroutines to a database.
• Triggers, triggers.
• Structure.
• Practical work Stored functions.

Data maintenance

• Import/export data.
• With COPY TO and COPY FROM.
• With Psql.
• Backup and restore data.
• pg_dump tools.
• Query optimization.
• Indexes.
• The optimizer.
• EXPLAIN and VACUUM.
• Practical work Importing/exporting data.
• Creating indexes and analyzing query execution plans.

User and group management

• Creation.
• Authentication.
• Granting privileges.
• Practical work Creation of users, allocation of rights.
• Authentication tests.

Configuration de PostgreSQL

• Installing and starting a database.
• The Postmaster.
• The Postgresql file.
• conf.
• System tables.
• Practical work Installation of a base and configuration.

Supplements

• Programming interfaces.
• Connecting PostgreSQL with PHP, JDBC, ODBC.

Description

At the end of this course, you will know the advanced notions of administering a PostgreSQL database such as the fine configuration of an instance for better performance, the efficient management of connections and the use of scripts to facilitate operation.

Who is this training for ?

Training objectives

Understand MySQL SDBG measurement and diagnostic tools.
Master application optimization techniques.
Analyze and optimize server and application performance.
Optimize the relational schema and SQL queries.

Training program

PostgreSQL Overview

• Brief reminders about PostgreSQL administration.
• Managing multiple instances on the same machine.

Creating and administering an instance

• Data directories.
• Transaction and activity logs.
• Installation of automatic tasks.
• Volume management.
• Using storage spaces.
• Defining the transaction log space.
• Loading data with pgLoader.
• Partitioning tables.
• Materialized views.
• Administering an instance.
• Using the system catalog.
• Tracking volumes.
• Connection tracking.
• Transaction tracking.

Administrator contributions

• pgbench: installation, configuration and use.
• pg_stattuple: status of tables and indexes.
• pg_freespacemap: status of free spaces.
• pg_buffercache: memory status.
• pg_stat_statments: information on executed SQL statements.

Performance and settings (reminders)

• Limit connections.
• Shared memory sizing.
• Sort and hash operations.
• Optimize data deletions.
• Optimize transaction log management.
• Refine auto-vacuum with thresholds.
• Practical work

Supervision of an instance

• Activity statistics.
• PgBadger.
• Analysis of activity logs and Vacuum messages.
• Munin, presentation.
• Practical work.

Advanced connection management

• Connection strings, connection attributes, multi-host connections.
• Pgbouncer.
• Installation and configuration of the pool manager.
• The use case.
• Definitions of connection pools.
• Practical work

Supplements (overall vision)

• Defining replication and high availability.
• Warm Standby overview.
• Slony overview.

Description

This course will teach you the different techniques to optimize your PostgreSQL servers and database applications. You will see how to improve the performance of SQL queries as well as that of your server through better configuration.

Who is this training for ?

Training objectives

Training program

Main parameters

• The different optimization parameters (connections, memory.
• ).
• Exercise: Modifying the memory parameters and analyzing the result.

Processing algorithms

• The PostgreSQL engine.
• Details of the different query processing mechanisms.
• Exercise: Comparison of performance by applying different processing algorithms for the same request.

Query algorithms

• Query processing method (statistics.
• ).
• The different types of algorithm (join, LOOP.
• ).
• Exercise: Comparison of performance by applying different query algorithms.

Memory optimization

• Configuration of memory parameters (shared_buffers.
• ).
• Method for calculating the value of shared_buffers.

Cache mechanisms and access performance

• Disk cache for data files.
• Transaction log cache.
• Free space cache.
• Cache for temporary objects.
• Exercise: Modification of different caches, memory and behavior analysis.

Performance through APIs and connectors

• Use of APIs (Java, PHP.
• ).
• Use of connectors (example: TranQL).
• Optimize the management of resources.
• Organization of tables with CLUSTER.
• Configuration of operating system kernel resources.
• Data distribution.
• Free space management.
• PostgreSQL isolation level (READ COMMITED.
• ).
• Lock levels.
• Lock method under PostgreSQL (record, table.
• ).
• Stack size.

Description

The Apache Hadoop platform makes it easier to create distributed applications. This internship will allow you to understand its architecture and give you the knowledge necessary to install, configure and administer a Hadoop cluster. You will also learn how to optimize it and maintain it over time.

Who is this training for ?

Training objectives

Discover the concepts and issues related to Hadoop Understand how the platform and its components work Install the platform and manage it Optimize the platform

Training program

Overview of the Apache Hadoop Framework

• Big Data challenges and contributions of the Hadoop framework.
• Presentation of the Hadoop architecture.
• Description of the main components of the Hadoop platform.
• Presentation of the main market distributions and complementary tools (Cloudera, MapR, Dataiku.
• ).
• Advantages/disadvantages of the platform.

Hadoop cluster preparations and configuration

• Hadoop Distributed File System (HDFS) working principles.
• MapReduce working principles.
• Cluster "type" design.
• Hardware selection criteria.
• Practical work Configuration of the Hadoop cluster.

Installing a Hadoop platform

• Deployment type.
• Installation of Hadoop.
• Installation of other components (Hive, Pig, HBase, Flume.
• ).
• Practical work Installation of a Hadoop platform and main components.

Managing a Hadoop cluster

• Management of Hadoop cluster nodes.
• TaskTracker, JobTracker for MapReduce.
• Management of tasks via schedulers.
• Management of logs.
• Using a manager.
• Practical work List jobs, queue status, job status, task management, access to the web UI.

Data management in HDFS

• Import of external data (files, relational databases) to HDFS.
• Handling of HDFS files.
• Practical work Import external data with Flume, consult relational databases with Sqoop.

Advanced configuration

• Authorization and security management.
• Recovery from name node failure (MRV1).
• NameNode high availability (MRV2/YARN).
• Practical work Configuration of a service-level authentication (SLA) and an Access Control List (ACL).

Monitoring et optimisation Tuning

• Monitoring (Ambari, Ganglia.
• ).
• Benchmarking/profiling of a cluster.
• Apache GridMix tools, Vaaidya .
• Choose block size.
• Other tuning options (use of compression, memory configuration.
• ).
• Practical work Understand cluster monitoring and optimization commands as they come.

Description

This course teaches object programming in Java, gradually addressing all the constructs of the language and also presenting UML notation and the main standard libraries such as input/output, collections and graphical interfaces. Students will learn to develop robust and efficient Java programs by becoming familiar with the basic concepts of object-oriented programming and their implementation in Java.

Who is this training for ?

Training objectives

• Implement the principles of object-oriented programming
  
• Master the syntax of the Java language
  
• Master the main Java standard libraries
  
• Master an integrated development environment to program in Java
  

Training program

Object techniques

• The general principles of Object modeling and programming.
• Abstraction and encapsulation: interfaces.
• The different forms of inheritance, polymorphism.
• Introduction to UML modeling: the static model, the dynamic model, the cooperation model, scenarios.
• Practical work The UML specification of a case study which will be one of the guiding threads of the following exercises.

Basic language constructs

• Variables: declaration and typing.
• The definition of fields.
• Methods: definition.
• Expressions.
• Control instructions: conditional, loop, branch instructions.
• Arrays.
• Enumerated types, autoboxing.
• Compilation units and packages: controlling the visibility of classes, the import mechanism.
• Static imports.
• Practical work Suite of simple exercises allowing you to get to grips with the development environment and create a simple program.
• Using packages.

The definition and instantiation of classes

• Classes and objects.
• Fields, methods.
• Constructors.
• Self-reference.
• Static fields and methods.
• Methods with variable number of arguments.
• Methodological aspects: class design.
• Practical work Case study programming.

The legacy

• The different forms of inheritance: extension and implementation.
• Interfaces and the implementation of interfaces.
• Pomorphism and its implementation work.
• The extension.
• The definition of derived classes, constructors, references.
• Methodological aspects.
• The construction of class hierarchies.
• Code factorization: abstract classes.
• The simultaneous use of the implementation and the extension.
• Abstract classes.
• Methodological aspects: the grouping of constants, the specification of services.
• The construction of hierarchies of classes and interfaces.
• Genericity.
• Practical work Design and construction of a hierarchy of classes and interfaces.
• Implementation of polymorphism and genericity in the study of cases.

The exceptions

• The Try blocks, the generation of exceptions.
• The catch() selection algorithm.
• Methodological aspects: the construction of a hierarchy exception, the use of exceptions.
• Practical work Introduction of exceptions in the case study.

Programming inputs/outputs

• The hierarchy of input/output classes.
• Some classes for handling file systems.
• Some input/output classes working on the byte flows, on the Char flows.
• Keyboard inputs/outputs.
• Practical work Reading/writing in files.

Graphical programming

• Basic concepts: the principles of visualization and event management from jdk1.
• 1.
• Visualization of graphical components: containers and Layouts.
• Some graphic components: labels, buttons, text boxes.
• Event management: Listeners and Adapters.
• The association of managers with graphic components.
• Practical work Construction of a GUI.

Some utility classes

• System classes.
• Container classes.
• Practical work Implementation of utility classes.

Description

This training will allow you to understand and practice the new features of version 8 of Java. You will discover lambda expressions and exploit the possibilities of functional programming. You will learn how to interact JavaScript code with Java code and discover new APIs.

Who is this training for ?

Training objectives

Use lambda expressions
Exploit the possibilities of functional programming
Use JavaScript codes from Java 8
Know the new date and time management API

Training program

Synthèse des nouveautés de Java 8

• Vue d'ensemble des ajouts : 195 nouvelles entités (classes, interfaces).
• Les expressions lambda.
• Ecrire du code SQL dans un code Java 8.
• Les implémentations par défaut des interfaces et
• FunctionalInterface, les nouvelles annotations.
• Les évolutions des streams.
• La nouvelle API de gestion des dates et des heures.
• Les évolutions d'API de java.
• lang, java.
• util, java.net.
• La possibilité d'exécuter du code JavaScript avec Java 8 Nashorn.
• Travaux pratiques Vérification de l'installation du JDK 8 (outils, javadoc).

Lambda expressions

• Notion of nested anonymous class, improvements brought by the concept of lambda expression.
• Syntactic aspects (declaration, implementation, passing parameters, scope of variables.
• ).
• The concept of "functor" through "functional" interfaces and the java package.
• util.
• function .
• Using lambda-expressions to manipulate collections.
• Contributions in writing SQL code The Listeners.
• Practical work Discovery of lambda-expressions.

Advanced functional programming

• The use of
• FunctionalInterface.
• The functional interfaces provided by JDK 8.
• Predicate, Function, Supplier, Consuler.
• References to methods and constructors.
• Practical work Implementation of advanced aspects.

Java 8 rhino

• JavaScript within Java? From Rhino present in Java 7 to Oracle Nashorn, ECMAScript-262 engine of Java 8.
• Using the jjs command line.
• Call JavaScript code from a Java application, either directly or using a separate file.
• js.
• Call Java code from a JavaScript script.
• Practical work JavaScript calls from Java.

New Date and Time API

• The difficulties caused by the Date and GregorianCalendar APIs, the JodaTime alternative and the JSR 310.
• The concepts of machine time and human time, the basic principles of the new API .
• Machine time management with java.
• time.
• Instant and java.
• time.
• Duration.
• Human time with java.
• time.
• LocalDate, java.
• time.
• LocalTime, java.
• time.
• LocalDateTime.
• Practical work Using the new date and time management API.

Other new features

• New streams.
• Map-reduce.
• Practical work Implementation of new features.

Description

Software quality is a major challenge today. You will implement Open Source tools to industrialize your developments and ensure this quality. You will learn to manage the sources, documentation, anomalies and developments of an application as well as all related tests.

Who is this training for ?

Training objectives

Industrialization of software development

Management of development sources using a centralized or decentralized system

Management of anomalies and functional changes in an application

Implement coding standards and software documentation

Implement different types of tests (unit, functional, robust and performance tests)
Automation of defined tasks

Training program

General Introduction

• What is software quality? Why do it? How to industrialize software development?

Source management

• Definition, interest in the organization of work, uniqueness of the development environment.
• Practical work Presentation of free CVS and/or Subversion source management software (SVN).

Tool for managing bugs, anomalies and functional developments

• Functional description, interest for developers, users, managers.
• Definition and interest in sorting bugs, anomalies and functional developments.
• Practical work rnPresentation of free software for managing bugs, anomalies and functional developments Bugzilla and/or Mantis.

Coding rules and documentation

• Interest (beyond clan oppositions).
• Beyond style: file organization rules.
• Interest of documentation, documentation code and other documentation (HOWTO.
• ).
• Practical work Review of Sun's recommendations and coding rules.
• Presentation and configuration of CheckStyle.
• Code documentation exercises.

Tests

• Why do tests? Presentation of the different types of tests: unit, functional, robustness and performance tests.
• Which tests to run and when? Use of "Mock" and "Fake" objects during unit tests.
• Coverage of unit tests.
• Practical work Practice of unit testing with JUnit (free software ) and other tools.
• Overview of functional testing with Mercury tools (commercial software), HttpUnit (free software).

Delivery procedures

• Interest of delivery procedures.
• Classic and non-traditional steps (manual, robustness tests).

Task automation

• Presentation of tasks to be automated.
• Practical work Presentation and introduction to Ant (free software).

Overall conclusion: quality measures

• Summary of quality measures: coding convention, documentation, test coverage, automation of procedures.
• Establishment of a quality dashboard.