Colombus USA
  • Home
  • Training
    • Microsoft >
      • Windows Server 2016 >
        • Installation, Storage, and Compute with Windows Server 2016 (20740)
        • Networking with Windows Server 2016 (20741)
        • Identity with Windows Server 2016 (20742)
        • Upgrading Your Skills to Windows Server 2016 (20743)
        • Securing Windows Server 2016 (20744)
      • Windows Server 2012 >
        • Windows Server 2012 : First Look (cours WIN2012-3)
        • Windows Server 2012: A Comprehensive Hands-On Introduction (cours WIN2012-1)
        • Installing and Configuring Windows Server 2012 (Cours 20410)
        • Administering Windows Server 2012 (Cours 20411)
        • Configuring Advanced Windows Server 2012 Services (Cours 20412)
        • Configuring and Administering Hyper-V in Windows Server 2012 (course 55021)
        • Implementing an Advanced Server Infrastructure (course 20414)
        • Implementing a Desktop Infrastructure (course 20415)
        • Implementing Desktop Application Environments (course 20416)
        • Automating Administration with Windows PowerShell 3.0 (course 10961)
        • Fundamentals of a Windows Server Infrastructure (course 10967)
        • Designing and Implementing a Server Infrastructure (course 20413)
      • Windows 10 >
        • Implementing and Managing Windows 10 (20697-1)
        • Deploying and Managing Windows 10 Using Enterprise Services (20697-2)
        • Supporting and Troubleshooting Windows 10 (10982)
      • Windows 8 >
        • Windows 8 : A Comprehensive Hands-On Introduction (cours WIN8001)
        • Deploying and Managing Windows 8 (cours WIN8002)
        • Configuring Windows 8 (course 20687)
        • Programming in HTML5 with JavaScript and CSS3to develop Windows Store apps (course 20480)
        • Advanced Windows Store App Development Using HTML5 and JavaScript (course 20482)
        • Essentials of Developing Windows Store Apps Using C# (course 20484)
        • Programming Windows 8 Metro style Apps using HTML5 (course 40003)
        • Programming Windows 8 Metro style Apps using C# (course 40004)
      • SQL Server 2016/2014 >
        • Updating Your Skills to SQL Server 2016 (10986)
        • Querying Data with Transact-SQL (20761)
        • Developing SQL Databases (20762)
        • Administering a SQL Database Infrastructure (20764)
        • Provisioning SQL 2016 Databases (20765)
        • Implementing a SQL Data Warehouse (20767)
        • Developing SQL Data Models (20768)
        • Analyzing Data with SQL Server Reporting Services (10990)
        • Querying Microsoft SQL Server 2014 (20461)
        • Administering SQL Server 2014 Databases (20462)
        • Implementing a Data Warehouse with Microsoft SQL Server 2014 (20463)
        • Developing Microsoft SQL Server 2014 Databases (20464)
        • Designing Solutions for Microsoft SQL Server 2014 (20465)
        • Implementing Data Models and Reports with SQL Server 2014 (20466)
        • Designing Business Intelligence Solutions with Microsoft SQL Server 2014 (20467)
        • SQL Server 2014 Performance Tuning and Optimization (55144)
        • Quick Microsoft SQL Server 2012-2014 Integration Services (55120)
        • Analyzing Data with Power BI (20778)
      • SQL Server 2012 >
        • Querying Microsoft SQL Server 2012 (cours 10774)
        • Implementing a Data Warehouse with Microsoft SQL Server 2012 (cours 10777)
        • Implementing Data Models and Reports with Microsoft SQL Server 2012 (cours 10778)
        • The Microsoft Business Intelligence 2010 Stack (course 50511)
      • Exchange 2016 >
        • Administering Microsoft Exchange Server 2016 (20345-1)
        • Designing and Deploying Microsoft Exchange Server 2016 (20345-2)
      • Exchange 2013 >
        • Core Solutions of Microsoft Exchange Server 2013 (course 20341)
        • Advanced Solutions of Microsoft Exchange Server 2013 (course 20342)
      • Skype For Business 2016 >
        • Core Solutions of Skype for Business 2015 (20334)
        • Deploying Voice Workloads for Skype for Business Online and Server 2015 (40409)
      • Lync 2013 >
        • What’s New for IT Professionals in Microsoft Lync Server 2013 (course 40029)
        • Planning and Designing a Microsoft Lync Server 2013 Solution (cours 10534)
        • Deploying, Configuring, and Administering Microsoft Lync Server 2013 (cours 10533)
      • SharePoint 2016 >
        • Microsoft SharePoint Server 2016 for the Site Owner/Power User (55197)
        • SharePoint 2016 End User Training (55199)
        • SharePoint 2016 Power User Training (55200)
        • Planning and Administering SharePoint 2016 (20339-1)
        • Advanced Technologies of SharePoint 2016 (20339-2)
        • No-Code SharePoint 2013-2016 Workflows With SharePoint Designer 2013 (55048)
      • SharePoint 2013 >
        • What's New for Developers in Microsoft SharePoint 2013 (cours 40027)
        • What’s New for IT Professionals in Microsoft SharePoint Server 2013 (Course 40028)
        • Using ShareGate Migration Tools (cours SPS1301)
        • Upgrading your End User Skills to SharePoint 2013 (course 55026)
        • Core Solutions of Microsoft SharePoint Server 2013 (course 20331)
        • Advanced Solutions of Microsoft SharePoint Server 2013 (course 20332)
        • SharePoint 2013 End User (cours 50575)
        • SharePoint 2013 End User - Level II (cours 50469)
        • Microsoft SharePoint Server 2013 for the Site Owner/Power User (cours 50470)
        • SharePoint 2013 Advanced Power User (cours SPS288)
        • SharePoint 2013 Overview for IT Professionals (cours 50353)
        • SharePoint 2013 Advanced Foundation Development (cours 50478)
        • Designing a Microsoft SharePoint 2013 Infrastructure (cours 10231)
        • Configuring and Administering Microsoft SharePoint 2013 (cours 10174)
        • Microsoft SharePoint 2013 Site Collection and Site Administration (cours 50547)
        • SharePoint 2013 Business Intelligence (cours 50429)
        • SharePoint 2013 SharePoint Designer (cours 50354)
        • SharePoint 2013 Overview for Developers (cours 50351)
        • Microsoft SharePoint 2013, Application Development (cours 10175)
        • Taxonomy and Metadata Training Program (cours SPS0010)
        • Designing and Developing Microsoft SharePoint Server 2013 Applications (cours 10232)
        • SharePoint Branding (cours SHB001)
        • SharePoint for ECM Introduction
        • SharePoint for ECM Specialist
        • SharePoint for ECM Master
        • SharePoint for Collaboration Introduction
        • SharePoint for Collaboration Specialist
        • SharePoint for Collaboration Master
      • VisualStudio >
        • Developing Windows Applications with Microsoft Visual Studio 2010 (cours 10262)
        • Developing Windows Communication Foundation Solutions with Microsoft Visual Studio 2010 (cours 10263)
        • Developing Web Applications with Microsoft Visual Studio 2010 (cours 10264)
        • Developing Data Access Solutions with Microsoft Visual Studio 2010 (cours 10265)
        • Programming in C# with Microsoft Visual Studio 2010 (cours 10266)
        • Introduction to Web Development with Microsoft Visual Studio 2010 (cours 10267)
        • Programming in Visual Basic with Microsoft Visual Studio 2010 (cours 10550)
        • Windows Azure Solutions with Microsoft Visual Studio 2010 (cours 50466)
        • Administering Team Foundation Server 2010 (cours 50430)
        • Creating Object-Oriented Solutions Using C# (cours 50211)
        • Introduction to HTML5 (cours 50564)
        • HTML5 Programming (cours 10953)
        • Fundamentals of XAML and Microsoft Expression Blend (cours 10553)
      • Cloud Development with Azure >
        • Developing Windows Azure and Web Services (course 20487)
        • Windows Azure Solutions with Microsoft Visual Studio 2010 (cours 50466)
        • Advanced SQL Azure (course 50592)
      • CRM 2015 >
        • Introduction to Microsoft Dynamics CRM 2011 (cours 80442)
        • Extending Microsoft Dynamics CRM 2011 (cours 80295)
        • Microsoft Dynamics CRM 2011 Installation and Deployment (cours 80296)
        • Reporting in Microsoft Dynamics CRM 2011 (cours 80445)
        • Workflow and Dialog Processes in Microsoft Dynamics CRM 2011 (cours 80444)
        • Marketing Automation in Microsoft Dynamics CRM 2011 (cours 80290)
        • Sales Management in Microsoft Dynamics CRM 2011 (cours 80291)
        • Service Management in Microsoft Dynamics CRM 2011 (cours 80292)
        • Service Scheduling in Microsoft Dynamics CRM 2011 (cours 80293)
      • System Center 2012 >
        • Monitoring and Operating a Private Cloud with System Center 2012 (cours 10750)
        • Configuring and Deploying a Private Cloud with System Center 2012 (cours 10751)
        • Administering System Center 2012 Configuration Manager (cours 10747)
        • Deploying System Center 2012 Configuration Manager (cours 10748)
        • System Center 2012 Service Manager (course 55009)
      • Office 2016 >
        • PowerPoint 2016 >
          • Introduction to Microsoft PowerPoint 2016 (55176)
          • Advanced Microsoft PowerPoint 2016 (55177)
        • Excel 2016 >
          • Introduction to Microsoft Excel 2016 (55165)
          • Intermediate Microsoft Excel 2016 (55166)
          • Advanced Microsoft Excel 2016 (55167)
          • Maximizing PivotTable (50448)
          • Useful Formulas & Functions (50449)
          • Solutions with Complex Formulas and Functions (50576)
          • Amazing Macros (50476)
          • PowerPivot for End Users (50433)
        • Word 2016 >
          • Introduction to Microsoft Word 2016 (50173)
          • Intermediate Microsoft Word 2016 (55174)
          • Advanced Microsoft Word 2016 (55175)
        • Access 2016 >
          • Learn Microsoft Access 2016 Step by Step, Level 1 (50532)
          • Learn Microsoft Access 2016 Step by Step, Level 2 (50533)
          • Learn Microsoft Access 2016 Step by Step, Level 3 (50534)
        • Outlook 2016 >
          • Introduction to Microsoft Outlook 2016 (55178)
          • Advanced Microsoft Outlook 2016 (55179)
        • Project 2016 >
          • Introduction to Microsoft Project 2016: Getting Started (55180)
          • Microsoft Project 2016: Digging Deeper (55181)
        • Visio 2016 Step by Step (50107)
        • InfoPath 2013 Step by Step (cours IP2010F)
        • OneNote 2013 Step by Step (cours ON2010F)
        • Publisher 2013 Step by Step (cours PUB2010F)
        • MapPoint 2013 Step by Step (cours MAP2011F)
      • Forefront 2010 >
        • Implementing Forefront Unified Access Gateway 2010 (cours 50402)
        • Implementing Forefront Identity Manager 2010 (cours 50382)
        • Implementing Forefront Threat Management Gateway 2010 (cours 50357)
        • Implementing Forefront Protection 2010 for Exchange and SharePoint (cours 50360)
        • Implementing Forefront Endpoint Protection 2010 (cours 50509)
      • BizTalk 2010 >
        • What's New in BizTalk Server 2010
        • BizTalk Server 2010 Administrator
        • BizTalk Server 2010 Developer
      • WebMatrix >
        • Introduction to ASP.NET Web Matrix (WebX001)
        • HTML5 Programming (cours 10953)
      • Office 365 >
        • Office 365: A day in the life of the End-User (course 50588)
        • Office 365 for IT Professionals (course 50557)
    • Adobe >
      • Photoshop >
        • Photoshop Initiation (cours PHO5501)
        • Photoshop Perfectionnement (cours PHO5502)
        • Photoshop Expert (cours PHO5503)
        • Photoshop Calibrage et Colorimétrie (cours PHO5504)
        • Photoshop détourage et montage complexe (cours PHO5505)
        • Photoshop pour les photographes (cours PHO5506)
        • Photoshop retouche, photomontage & chromie (cours PHO5507)
      • Lightroom >
        • Photoshop Lightroom 4 (cours LIG4001)
      • InDesign >
        • InDesign initiation (cours IND5501)
        • InDesign perfectionnement (cours IND5502)
        • InDesign expert (cours IND5503)
        • InDesign epub, ebook (cours IND5504)
        • InDesign animation et interactivité (cours IND5505)
        • InDesign et les documents longs (cours IND5506)
        • InDesign pour les secrétaires de rédaction (cours IND5507)
      • Illustrator >
        • Illustrator CS 6 initiation (cours ILL6001)
        • Illustrator CS 6 perfectionnement (cours ILL6002)
        • Illustrator CS 6 - le packaging (cours ILL6003)
        • Illustrator CS 6 - la 3D (cours ILL6004)
      • Dreamweaver >
        • Dreamweaver CS 5.5 initiation  (cours DRE5501)
        • Dreamweaver CS 5.5 perfectionnement (cours DRE5502)
        • Dreamweaver CS 5.5 - CSS (cours DRE5503)
      • Flash Profesionnal >
        • Flash Animation CS 5.5 - initiation  (cours FLA5501)
        • Flash Animation CS 5.5 - perfectionnement (cours FLA5502)
        • Flash Catalyst CS 5.5 (cours FLA5503)
        • Flash CS 5.5 actionscript initiation (cours FLA5504)
        • Flash CS 5.5 actionscript perfectionnement (cours FLA5505)
        • Flash CS 5.5 actionscript expert (cours FLA5506)
        • Flash CS 5.5 et vidéo (cours FLA5507)
      • Premiere Pro >
        • Premiere Pro CS 5.5 (cours PRE5501)
    • Informatique financière >
      • Thomson Reuters - VBA Basic Training (cours KOB001)
      • Thomson Reuters - VBA Advanced Training (cours KOB002)
    • ITIL >
      • ITIL : ITIL Foundation v3 (cours ITIL001)
    • Cisco >
      • Interconnecting Cisco Networking Devices Part 1 (cours ICND1)
      • Interconnecting Cisco Networking Devices Part 2 (cours ICND2)
      • Designing for Cisco Internetwork Solutions (DESGN)
      • Implementing Cisco IOS Network Security (IINS)
      • Building Cisco Service Provider Next-Generation Networks, Part 1 (SPNGN1)
      • Building Cisco Service Provider Next-Generation Networks, Part 2 (SPNGN2)
      • Introducing Cisco Voice and Unified Communications Administration (ICOMM)
      • Implementing Cisco Unified Wireless Networking Essentials (IUWNE)
    • Oracle >
      • Oracle Database 11g: Administration Workshop I (ORA001)
      • Oracle Database 11g : Administration Workshop II (ORA002)
      • Oracle Database 11g : Tuning (ORA003)
      • Oracle Database 11g : Nouvelles fonctionnalités d'administration (ORA004)
      • Oracle 11g: RAC and Grid Infrastructure Administration Accelerated (ORA005)
      • Oracle Grid Infrastructure 11g : Gestion des clusters et ASM (ORA006)
      • Oracle Database 11g: Backup and Recovery Workshop (ORA007)
      • Oracle Database 11g : Administration de Data Guard (ORA008)
      • Oracle Database 11g : Sécurité (ORA009)
      • Oracle Database 11g : Administrer un data warehouse (ORA010)
    • Enterprise Content Management >
      • ECM Beginners
      • ECM Intermediate
      • ECM Master
      • Taxonomy and Metadata Training Program (cours SPS0010)
      • SharePoint for ECM Introduction
      • SharePoint for ECM Specialist
      • SharePoint for ECM Master
    • Electronic Records Management >
      • ERM Beginners
      • ERM Intermediate
      • ERM Master
    • Business Process Management >
      • BPM Beginners
      • BPM Intermediate
      • BPM Master
    • Social Media Governance
    • Training in management, sales and customer orientation >
      • Team spirit for efficiency (course MOT0001)
      • Company Leader Seminar (course MOT0002)
      • Progress through insights discovery (course MOT0003)
      • Men and women management (course MOT0004)
      • Positive Inner Attitude (course MOT0005)
      • Management of yourself and your time (course MOT0006)
      • Customer orientation (course MOT0007)
      • Sales of goods and services (course MOT0008)
    • Photography >
      • Photoshop pour les photographes (cours PHO5506)
      • Photoshop Lightroom 4 (cours LIG4001)
      • Automatiser son flux de travail (cours PHO001)
      • Comprendre l'imagerie numérique (cours PHO002)
      • Capture NX2 (cours PHO003)
      • Autodesk Stitcher Unlimited - Introduction à la création de Panoramas (cours PHO004)
      • PhaseOne Media Pro 1 photo manager (cours PHO005)
      • Using ArcSoft Products (cours PHO007)
  • Development
    • Withholding tax agreements : Rubik
    • Web Application Development
    • Application Integration
    • Mobile Application Development
    • Application Security Consulting
    • Website Design and Development
    • Usability and user Interface Design
    • Independant QA and Testing
    • Maintenance and Support
    • Dedicated Development Teams
  • Consulting
    • Consulting Services
    • Software Security Consulting >
      • Software Security Services
      • Security Training
      • Security Advisory
    • Cloud Computing
    • Withholding tax agreements : Rubik
    • What makes us different?
  • Outsourcing
    • Full IT Outsourcing
    • Infrastructure services
    • Cloud Computing
    • Application management
    • Business process services >
      • Document management services
  • 3D Modeling
    • Videos
    • Augmented Reality
  • Who we are
    • Facts and Figures
    • Why us ?
    • Business Continuity
    • Quality Management
    • Methodology
  • Contact
  • Site en français

Implementing a Data Warehouse with Microsoft SQL Server 2014 (20463)

​Implementing a Data Warehouse with Microsoft SQL Server 2014 (20463) 
Cours disponible en français ou en anglais - Training available in French or in English

Duration: 5 days

Objectives :
 
This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.
Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
 
Course Details : 
Module 1: Introduction to Data Warehousing
This module provides an introduction to the key components of a data warehousing solution and the high-level considerations you must take into account when you embark on a data warehousing project.
 
After completing this module, you will be able to:
  • Describe the key elements of a data warehousing solution
  • Describe the key considerations for a data warehousing project
 
Module 2: Data Warehouse Hardware Considerations
This module discusses considerations for selecting hardware and distributing SQL Server facilities across servers.
 
After completing this module, you will be able to:
  • Describe key considerations for BI infrastructure.
  • Plan data warehouse infrastructure.
 
Module 3: Designing and Implementing a Data Warehouse
This module describes the key considerations for the logical design of a data warehouse, and then discusses best practices for its physical implementation.
 
After completing this module, you will be able to:
  • Describe a process for designing a dimensional model for a data warehouse
  • Design dimension tables for a data warehouse
  • Design fact tables for a data warehouse
  • Design and implement effective physical data structures for a data warehouse
 
Module 4: Creating an ETL Solution with SSIS
This module discusses considerations for implementing an ETL process, and then focuses on Microsoft SQL Server Integration Services (SSIS) as a platform for building ETL solutions.
 
After completing this module, you will be able to:
  • Describe the key features of SSIS.
  • Explore source data for an ETL solution.
  • Implement a data flow by using SSIS
 
Module 5: Implementing Control Flow in an SSIS Package
This module describes how to implement ETL solutions that combine multiple tasks and workflow logic.
 
After completing this module, you will be able to:
  • Implement control flow with tasks and precedence constraints
  • Create dynamic packages that include variables and parameters
  • Use containers in a package control flow
  • Enforce consistency with transactions and checkpoints
 
Module 6: Debugging and Troubleshooting SSIS Packages
This module describes how you can debug packages to find the cause of errors that occur during execution. It then discusses the logging functionality built into SSIS that you can use to log events for troubleshooting purposes. Finally, the module describes common approaches for handling errors in control flow and data flow.
 
After completing this module, you will be able to:
  • Debug an SSIS package
  • Implement logging for an SSIS package
  • Handle errors in an SSIS package
 
Module 7: Implementing an Incremental ETL Process
This module describes the techniques you can use to implement an incremental data warehouse refresh process.
 
After completing this module, you will be able to:
  • Plan data extraction
  • Extract modified data
 
Module 8: Enforcing Data Quality
This module introduces Microsoft SQL Server Data Quality Services (DQS), and describes how you can use it to cleanse and deduplicate data.
 
After completing this module, you will be able to:
  • Describe how Data Quality Services can help you manage data quality
  • Use Data Quality Services to cleanse your data
  • Use Data Quality Services to match data
 
Module 9: Using Master Data Services
Master Data Services provides a way for organizations to standardize data and improve the quality, consistency, and reliability of the data that guides key business decisions. This module introduces Master Data Services and explains the benefits of using it.
 
After completing this module, you will be able to:
  • Describe key Master Data Services concepts
  • Implement a Master Data Services model
  • Use Master Data Services tools to manage master data
  • Use Master Data Services tools to create a master data hub
 
Module 10: Extending SQL Server Integration Services
This module describes the techniques you can use to extend SSIS. The module is not designed to be a comprehensive guide to developing custom SSIS solutions, but to provide an awareness of the fundamental steps required to use custom components and scripts in an ETL process that is based on SSIS.
 
After completing this module, you will be able to:
  • Include custom scripts in an SSIS package
  • Describe how custom components can be used to extend SSIS
 
Module 11: Deploying and Configuring SSIS Packages
In this module, students will learn how to deploy packages and their dependencies to a server, and how to manage and monitor the execution of deployed packages.
 
After completing this module, you will be able to:
  • Describe considerations for SSIS deployment.
  • Deploy SSIS projects.
  • Plan SSIS package execution.
 
Module 12: Consuming Data in a Data Warehouse
This module introduces business intelligence (BI) solutions and describes how you can use a data warehouse as the basis for enterprise and self-service BI.
 
After completing this module, you will be able to:
  • Describe BI and common BI scenarios
  • Describe how a data warehouse can be used in enterprise BI scenarios
  • Describe how a data warehouse can be used in self-service BI scenarios

 
Requirements: 
This course requires that you meet the following prerequisites:
  • At least 2 years’ experience of working with relational databases, including:
    • Designing a normalized database.
    • Creating tables and relationships.
    • Querying with Transact-SQL.
    • Some exposure to basic programming constructs (such as looping and branching).
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
 
© Colombus SA 2018  -   Contact us   -   info@colombus.com   -   Tel : +41 21 661 1675  -  Fax : +41 21 661 1673
  • Home
  • Training
    • Microsoft >
      • Windows Server 2016 >
        • Installation, Storage, and Compute with Windows Server 2016 (20740)
        • Networking with Windows Server 2016 (20741)
        • Identity with Windows Server 2016 (20742)
        • Upgrading Your Skills to Windows Server 2016 (20743)
        • Securing Windows Server 2016 (20744)
      • Windows Server 2012 >
        • Windows Server 2012 : First Look (cours WIN2012-3)
        • Windows Server 2012: A Comprehensive Hands-On Introduction (cours WIN2012-1)
        • Installing and Configuring Windows Server 2012 (Cours 20410)
        • Administering Windows Server 2012 (Cours 20411)
        • Configuring Advanced Windows Server 2012 Services (Cours 20412)
        • Configuring and Administering Hyper-V in Windows Server 2012 (course 55021)
        • Implementing an Advanced Server Infrastructure (course 20414)
        • Implementing a Desktop Infrastructure (course 20415)
        • Implementing Desktop Application Environments (course 20416)
        • Automating Administration with Windows PowerShell 3.0 (course 10961)
        • Fundamentals of a Windows Server Infrastructure (course 10967)
        • Designing and Implementing a Server Infrastructure (course 20413)
      • Windows 10 >
        • Implementing and Managing Windows 10 (20697-1)
        • Deploying and Managing Windows 10 Using Enterprise Services (20697-2)
        • Supporting and Troubleshooting Windows 10 (10982)
      • Windows 8 >
        • Windows 8 : A Comprehensive Hands-On Introduction (cours WIN8001)
        • Deploying and Managing Windows 8 (cours WIN8002)
        • Configuring Windows 8 (course 20687)
        • Programming in HTML5 with JavaScript and CSS3to develop Windows Store apps (course 20480)
        • Advanced Windows Store App Development Using HTML5 and JavaScript (course 20482)
        • Essentials of Developing Windows Store Apps Using C# (course 20484)
        • Programming Windows 8 Metro style Apps using HTML5 (course 40003)
        • Programming Windows 8 Metro style Apps using C# (course 40004)
      • SQL Server 2016/2014 >
        • Updating Your Skills to SQL Server 2016 (10986)
        • Querying Data with Transact-SQL (20761)
        • Developing SQL Databases (20762)
        • Administering a SQL Database Infrastructure (20764)
        • Provisioning SQL 2016 Databases (20765)
        • Implementing a SQL Data Warehouse (20767)
        • Developing SQL Data Models (20768)
        • Analyzing Data with SQL Server Reporting Services (10990)
        • Querying Microsoft SQL Server 2014 (20461)
        • Administering SQL Server 2014 Databases (20462)
        • Implementing a Data Warehouse with Microsoft SQL Server 2014 (20463)
        • Developing Microsoft SQL Server 2014 Databases (20464)
        • Designing Solutions for Microsoft SQL Server 2014 (20465)
        • Implementing Data Models and Reports with SQL Server 2014 (20466)
        • Designing Business Intelligence Solutions with Microsoft SQL Server 2014 (20467)
        • SQL Server 2014 Performance Tuning and Optimization (55144)
        • Quick Microsoft SQL Server 2012-2014 Integration Services (55120)
        • Analyzing Data with Power BI (20778)
      • SQL Server 2012 >
        • Querying Microsoft SQL Server 2012 (cours 10774)
        • Implementing a Data Warehouse with Microsoft SQL Server 2012 (cours 10777)
        • Implementing Data Models and Reports with Microsoft SQL Server 2012 (cours 10778)
        • The Microsoft Business Intelligence 2010 Stack (course 50511)
      • Exchange 2016 >
        • Administering Microsoft Exchange Server 2016 (20345-1)
        • Designing and Deploying Microsoft Exchange Server 2016 (20345-2)
      • Exchange 2013 >
        • Core Solutions of Microsoft Exchange Server 2013 (course 20341)
        • Advanced Solutions of Microsoft Exchange Server 2013 (course 20342)
      • Skype For Business 2016 >
        • Core Solutions of Skype for Business 2015 (20334)
        • Deploying Voice Workloads for Skype for Business Online and Server 2015 (40409)
      • Lync 2013 >
        • What’s New for IT Professionals in Microsoft Lync Server 2013 (course 40029)
        • Planning and Designing a Microsoft Lync Server 2013 Solution (cours 10534)
        • Deploying, Configuring, and Administering Microsoft Lync Server 2013 (cours 10533)
      • SharePoint 2016 >
        • Microsoft SharePoint Server 2016 for the Site Owner/Power User (55197)
        • SharePoint 2016 End User Training (55199)
        • SharePoint 2016 Power User Training (55200)
        • Planning and Administering SharePoint 2016 (20339-1)
        • Advanced Technologies of SharePoint 2016 (20339-2)
        • No-Code SharePoint 2013-2016 Workflows With SharePoint Designer 2013 (55048)
      • SharePoint 2013 >
        • What's New for Developers in Microsoft SharePoint 2013 (cours 40027)
        • What’s New for IT Professionals in Microsoft SharePoint Server 2013 (Course 40028)
        • Using ShareGate Migration Tools (cours SPS1301)
        • Upgrading your End User Skills to SharePoint 2013 (course 55026)
        • Core Solutions of Microsoft SharePoint Server 2013 (course 20331)
        • Advanced Solutions of Microsoft SharePoint Server 2013 (course 20332)
        • SharePoint 2013 End User (cours 50575)
        • SharePoint 2013 End User - Level II (cours 50469)
        • Microsoft SharePoint Server 2013 for the Site Owner/Power User (cours 50470)
        • SharePoint 2013 Advanced Power User (cours SPS288)
        • SharePoint 2013 Overview for IT Professionals (cours 50353)
        • SharePoint 2013 Advanced Foundation Development (cours 50478)
        • Designing a Microsoft SharePoint 2013 Infrastructure (cours 10231)
        • Configuring and Administering Microsoft SharePoint 2013 (cours 10174)
        • Microsoft SharePoint 2013 Site Collection and Site Administration (cours 50547)
        • SharePoint 2013 Business Intelligence (cours 50429)
        • SharePoint 2013 SharePoint Designer (cours 50354)
        • SharePoint 2013 Overview for Developers (cours 50351)
        • Microsoft SharePoint 2013, Application Development (cours 10175)
        • Taxonomy and Metadata Training Program (cours SPS0010)
        • Designing and Developing Microsoft SharePoint Server 2013 Applications (cours 10232)
        • SharePoint Branding (cours SHB001)
        • SharePoint for ECM Introduction
        • SharePoint for ECM Specialist
        • SharePoint for ECM Master
        • SharePoint for Collaboration Introduction
        • SharePoint for Collaboration Specialist
        • SharePoint for Collaboration Master
      • VisualStudio >
        • Developing Windows Applications with Microsoft Visual Studio 2010 (cours 10262)
        • Developing Windows Communication Foundation Solutions with Microsoft Visual Studio 2010 (cours 10263)
        • Developing Web Applications with Microsoft Visual Studio 2010 (cours 10264)
        • Developing Data Access Solutions with Microsoft Visual Studio 2010 (cours 10265)
        • Programming in C# with Microsoft Visual Studio 2010 (cours 10266)
        • Introduction to Web Development with Microsoft Visual Studio 2010 (cours 10267)
        • Programming in Visual Basic with Microsoft Visual Studio 2010 (cours 10550)
        • Windows Azure Solutions with Microsoft Visual Studio 2010 (cours 50466)
        • Administering Team Foundation Server 2010 (cours 50430)
        • Creating Object-Oriented Solutions Using C# (cours 50211)
        • Introduction to HTML5 (cours 50564)
        • HTML5 Programming (cours 10953)
        • Fundamentals of XAML and Microsoft Expression Blend (cours 10553)
      • Cloud Development with Azure >
        • Developing Windows Azure and Web Services (course 20487)
        • Windows Azure Solutions with Microsoft Visual Studio 2010 (cours 50466)
        • Advanced SQL Azure (course 50592)
      • CRM 2015 >
        • Introduction to Microsoft Dynamics CRM 2011 (cours 80442)
        • Extending Microsoft Dynamics CRM 2011 (cours 80295)
        • Microsoft Dynamics CRM 2011 Installation and Deployment (cours 80296)
        • Reporting in Microsoft Dynamics CRM 2011 (cours 80445)
        • Workflow and Dialog Processes in Microsoft Dynamics CRM 2011 (cours 80444)
        • Marketing Automation in Microsoft Dynamics CRM 2011 (cours 80290)
        • Sales Management in Microsoft Dynamics CRM 2011 (cours 80291)
        • Service Management in Microsoft Dynamics CRM 2011 (cours 80292)
        • Service Scheduling in Microsoft Dynamics CRM 2011 (cours 80293)
      • System Center 2012 >
        • Monitoring and Operating a Private Cloud with System Center 2012 (cours 10750)
        • Configuring and Deploying a Private Cloud with System Center 2012 (cours 10751)
        • Administering System Center 2012 Configuration Manager (cours 10747)
        • Deploying System Center 2012 Configuration Manager (cours 10748)
        • System Center 2012 Service Manager (course 55009)
      • Office 2016 >
        • PowerPoint 2016 >
          • Introduction to Microsoft PowerPoint 2016 (55176)
          • Advanced Microsoft PowerPoint 2016 (55177)
        • Excel 2016 >
          • Introduction to Microsoft Excel 2016 (55165)
          • Intermediate Microsoft Excel 2016 (55166)
          • Advanced Microsoft Excel 2016 (55167)
          • Maximizing PivotTable (50448)
          • Useful Formulas & Functions (50449)
          • Solutions with Complex Formulas and Functions (50576)
          • Amazing Macros (50476)
          • PowerPivot for End Users (50433)
        • Word 2016 >
          • Introduction to Microsoft Word 2016 (50173)
          • Intermediate Microsoft Word 2016 (55174)
          • Advanced Microsoft Word 2016 (55175)
        • Access 2016 >
          • Learn Microsoft Access 2016 Step by Step, Level 1 (50532)
          • Learn Microsoft Access 2016 Step by Step, Level 2 (50533)
          • Learn Microsoft Access 2016 Step by Step, Level 3 (50534)
        • Outlook 2016 >
          • Introduction to Microsoft Outlook 2016 (55178)
          • Advanced Microsoft Outlook 2016 (55179)
        • Project 2016 >
          • Introduction to Microsoft Project 2016: Getting Started (55180)
          • Microsoft Project 2016: Digging Deeper (55181)
        • Visio 2016 Step by Step (50107)
        • InfoPath 2013 Step by Step (cours IP2010F)
        • OneNote 2013 Step by Step (cours ON2010F)
        • Publisher 2013 Step by Step (cours PUB2010F)
        • MapPoint 2013 Step by Step (cours MAP2011F)
      • Forefront 2010 >
        • Implementing Forefront Unified Access Gateway 2010 (cours 50402)
        • Implementing Forefront Identity Manager 2010 (cours 50382)
        • Implementing Forefront Threat Management Gateway 2010 (cours 50357)
        • Implementing Forefront Protection 2010 for Exchange and SharePoint (cours 50360)
        • Implementing Forefront Endpoint Protection 2010 (cours 50509)
      • BizTalk 2010 >
        • What's New in BizTalk Server 2010
        • BizTalk Server 2010 Administrator
        • BizTalk Server 2010 Developer
      • WebMatrix >
        • Introduction to ASP.NET Web Matrix (WebX001)
        • HTML5 Programming (cours 10953)
      • Office 365 >
        • Office 365: A day in the life of the End-User (course 50588)
        • Office 365 for IT Professionals (course 50557)
    • Adobe >
      • Photoshop >
        • Photoshop Initiation (cours PHO5501)
        • Photoshop Perfectionnement (cours PHO5502)
        • Photoshop Expert (cours PHO5503)
        • Photoshop Calibrage et Colorimétrie (cours PHO5504)
        • Photoshop détourage et montage complexe (cours PHO5505)
        • Photoshop pour les photographes (cours PHO5506)
        • Photoshop retouche, photomontage & chromie (cours PHO5507)
      • Lightroom >
        • Photoshop Lightroom 4 (cours LIG4001)
      • InDesign >
        • InDesign initiation (cours IND5501)
        • InDesign perfectionnement (cours IND5502)
        • InDesign expert (cours IND5503)
        • InDesign epub, ebook (cours IND5504)
        • InDesign animation et interactivité (cours IND5505)
        • InDesign et les documents longs (cours IND5506)
        • InDesign pour les secrétaires de rédaction (cours IND5507)
      • Illustrator >
        • Illustrator CS 6 initiation (cours ILL6001)
        • Illustrator CS 6 perfectionnement (cours ILL6002)
        • Illustrator CS 6 - le packaging (cours ILL6003)
        • Illustrator CS 6 - la 3D (cours ILL6004)
      • Dreamweaver >
        • Dreamweaver CS 5.5 initiation  (cours DRE5501)
        • Dreamweaver CS 5.5 perfectionnement (cours DRE5502)
        • Dreamweaver CS 5.5 - CSS (cours DRE5503)
      • Flash Profesionnal >
        • Flash Animation CS 5.5 - initiation  (cours FLA5501)
        • Flash Animation CS 5.5 - perfectionnement (cours FLA5502)
        • Flash Catalyst CS 5.5 (cours FLA5503)
        • Flash CS 5.5 actionscript initiation (cours FLA5504)
        • Flash CS 5.5 actionscript perfectionnement (cours FLA5505)
        • Flash CS 5.5 actionscript expert (cours FLA5506)
        • Flash CS 5.5 et vidéo (cours FLA5507)
      • Premiere Pro >
        • Premiere Pro CS 5.5 (cours PRE5501)
    • Informatique financière >
      • Thomson Reuters - VBA Basic Training (cours KOB001)
      • Thomson Reuters - VBA Advanced Training (cours KOB002)
    • ITIL >
      • ITIL : ITIL Foundation v3 (cours ITIL001)
    • Cisco >
      • Interconnecting Cisco Networking Devices Part 1 (cours ICND1)
      • Interconnecting Cisco Networking Devices Part 2 (cours ICND2)
      • Designing for Cisco Internetwork Solutions (DESGN)
      • Implementing Cisco IOS Network Security (IINS)
      • Building Cisco Service Provider Next-Generation Networks, Part 1 (SPNGN1)
      • Building Cisco Service Provider Next-Generation Networks, Part 2 (SPNGN2)
      • Introducing Cisco Voice and Unified Communications Administration (ICOMM)
      • Implementing Cisco Unified Wireless Networking Essentials (IUWNE)
    • Oracle >
      • Oracle Database 11g: Administration Workshop I (ORA001)
      • Oracle Database 11g : Administration Workshop II (ORA002)
      • Oracle Database 11g : Tuning (ORA003)
      • Oracle Database 11g : Nouvelles fonctionnalités d'administration (ORA004)
      • Oracle 11g: RAC and Grid Infrastructure Administration Accelerated (ORA005)
      • Oracle Grid Infrastructure 11g : Gestion des clusters et ASM (ORA006)
      • Oracle Database 11g: Backup and Recovery Workshop (ORA007)
      • Oracle Database 11g : Administration de Data Guard (ORA008)
      • Oracle Database 11g : Sécurité (ORA009)
      • Oracle Database 11g : Administrer un data warehouse (ORA010)
    • Enterprise Content Management >
      • ECM Beginners
      • ECM Intermediate
      • ECM Master
      • Taxonomy and Metadata Training Program (cours SPS0010)
      • SharePoint for ECM Introduction
      • SharePoint for ECM Specialist
      • SharePoint for ECM Master
    • Electronic Records Management >
      • ERM Beginners
      • ERM Intermediate
      • ERM Master
    • Business Process Management >
      • BPM Beginners
      • BPM Intermediate
      • BPM Master
    • Social Media Governance
    • Training in management, sales and customer orientation >
      • Team spirit for efficiency (course MOT0001)
      • Company Leader Seminar (course MOT0002)
      • Progress through insights discovery (course MOT0003)
      • Men and women management (course MOT0004)
      • Positive Inner Attitude (course MOT0005)
      • Management of yourself and your time (course MOT0006)
      • Customer orientation (course MOT0007)
      • Sales of goods and services (course MOT0008)
    • Photography >
      • Photoshop pour les photographes (cours PHO5506)
      • Photoshop Lightroom 4 (cours LIG4001)
      • Automatiser son flux de travail (cours PHO001)
      • Comprendre l'imagerie numérique (cours PHO002)
      • Capture NX2 (cours PHO003)
      • Autodesk Stitcher Unlimited - Introduction à la création de Panoramas (cours PHO004)
      • PhaseOne Media Pro 1 photo manager (cours PHO005)
      • Using ArcSoft Products (cours PHO007)
  • Development
    • Withholding tax agreements : Rubik
    • Web Application Development
    • Application Integration
    • Mobile Application Development
    • Application Security Consulting
    • Website Design and Development
    • Usability and user Interface Design
    • Independant QA and Testing
    • Maintenance and Support
    • Dedicated Development Teams
  • Consulting
    • Consulting Services
    • Software Security Consulting >
      • Software Security Services
      • Security Training
      • Security Advisory
    • Cloud Computing
    • Withholding tax agreements : Rubik
    • What makes us different?
  • Outsourcing
    • Full IT Outsourcing
    • Infrastructure services
    • Cloud Computing
    • Application management
    • Business process services >
      • Document management services
  • 3D Modeling
    • Videos
    • Augmented Reality
  • Who we are
    • Facts and Figures
    • Why us ?
    • Business Continuity
    • Quality Management
    • Methodology
  • Contact
  • Site en français