Colombus Suisse
  • Home
  • Formations
    • Microsoft >
      • Windows Server 2019 >
        • Windows Server 2019 Administration
        • Windows Server 2019 Hybrid and Azure IaaS
      • 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)
        • Automating Administration with Windows PowerShell 3.0 (cours 10961)
      • 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)
      • 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)
        • Quick Microsoft SQL Server 2012-2014 Integration Services (55120)
        • SQL Server 2014 Performance Tuning and Optimization (55144)
        • Analyzing Data with Power BI (20778)
      • Exchange 2016/2019 >
        • Administering Microsoft Exchange Server 2016/2019 (20345-1)
        • Designing and Deploying Microsoft Exchange Server 2016/2019 (20345-2)
      • Skype For Business 2016 >
        • Core Solutions of Skype for Business 2015 (20334)
        • Deploying Voice Workloads for Skype for Business Online and Server 2015 (40409)
      • 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 2019 >
        • SharePoint End User 2019
        • SharePoint 2019 Power User
        • SharePoint 2019 Site Owner Training
      • VisualStudio >
        • 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)
      • Développement Cloud avec Azure >
        • Developing Windows Azure and Web Services (Cours 20487)
        • Windows Azure Solutions with Microsoft Visual Studio 2010 (cours 50466)
        • Advanced SQL Azure (Cours 50592)
      • Dynamics 365 >
        • Dynamics 365 Fundamentals (CRM)
      • CRM 2016 >
        • Introduction to Microsoft Dynamics CRM 2016 (cours 80442)
        • Extending Microsoft Dynamics CRM 2016 (cours 80295)
        • Microsoft Dynamics CRM 2016 Installation and Deployment (cours 80296)
        • Reporting in Microsoft Dynamics CRM 2016 (cours 80445)
        • Workflow and Dialog Processes in Microsoft Dynamics CRM 2016 (cours 80444)
        • Marketing Automation in Microsoft Dynamics CRM 2016 (cours 80290)
        • Sales Management in Microsoft Dynamics CRM 2016 (cours 80291)
        • Service Management in Microsoft Dynamics CRM 2016 (cours 80292)
        • Service Scheduling in Microsoft Dynamics CRM 2016 (cours 80293)
      • System Center 2018 >
        • Monitoring and Operating a Private Cloud with System Center 2018 (cours 10750)
        • Configuring and Deploying a Private Cloud with System Center 2018 (cours 10751)
        • Administering System Center 2018 Configuration Manager (cours 10747)
        • Deploying System Center 2018 Configuration Manager (cours 10748)
        • System Center 2018 Service Manager (cours 55009)
      • Office >
        • PowerPoint >
          • Introduction to Microsoft PowerPoint (55176)
          • Advanced Microsoft PowerPoint (55177)
        • Excel >
          • Introduction to Microsoft Excel (55165)
          • Intermediate Microsoft Excel (55166)
          • Advanced Microsoft Excel (55167)
          • Maximizing PivotTable (50448)
          • Useful Formulas & Functions (50449)
          • Solutions with Complex Formulas and Functions (50576)
          • Amazing Macros (50476)
          • PowerPivot for End Users (50433)
        • Word >
          • Introduction to Microsoft Word (50173)
          • Intermediate Microsoft Word (55174)
          • Advanced Microsoft Word (55175)
        • Access >
          • Learn Microsoft Access Step by Step, Level 1 (cours 50532)
          • Learn Microsoft Access Step by Step, Level 2 (cours 50533)
          • Learn Microsoft Access Step by Step, Level 3 (cours 50534)
        • Outlook >
          • Introduction to Microsoft Outlook (55178)
          • Advanced Microsoft Outlook (55179)
        • Project >
          • Introduction to Microsoft Project: Getting Started (55180)
          • Microsoft Project: Digging Deeper (55181)
        • Visio Step by Step (cours 50107)
        • OneNote Step by Step (cours ON2010F)
        • Publisher Step by Step (cours PUB2010F)
      • 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 (Cours 50588)
        • Office 365 for IT Professionals (Cours 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
    • Cours de Management, Vente et Gestion de Clients >
      • L'Esprit d'équipe au service de l'efficacité (EESE) (cours MOT0001)
      • Séminaire des dirigeants d'entreprise (cours MOT0002)
      • Progresser par insights discovery (cours MOT0003)
      • Le management des hommes et des femmes (cours MOT0004)
      • L'attitude intérieure positive (cours MOT0005)
      • Le Management de soi-même et de son temps (cours MOT0006)
      • L'orientation client (cours MOT0007)
      • La vente des biens et des services (cours MOT0008)
    • Photographie >
      • 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)
      • Maîtrise du système de Flash sans fil Nikon i-TTL , CLS (cours PHO006)
      • Utiliser les produits d'ArcSoft (cours PHO007)
  • Développement
    • Accords sur l’imposition à la source : 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
    • Accords sur l’imposition à la source : Rubik
    • Qu'est ce qui nous rend différent ?
  • Outsourcing
    • Outsourcing complet de l'IT
    • Infrastructure
    • Cloud Computing
    • Gestion des applications
    • Gestion des processus d'affaires >
      • Gestion des documents
  • 3D
    • Vidéos
    • Réalité augmentée
  • Qui sommes-nous ?
    • Chiffres et données
    • Pourquoi nous ?
    • Business Continuity
    • Quality Management
    • Méthodologie
  • Contact
  • English site

Administering a SQL Database Infrastructure (20764)

​Administering a SQL Database Infrastructure (20764)
Cours disponible en français ou en anglais - Training available in French or in English

Durée: 5 jours 

Objectifs du cours : 
This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.

​Compétences acquises :
 
Module 1: SQL Server Security
Protection of data within your Microsoft SQL Server databases is essential and requires a working knowledge of the issues and SQL Server security features. This module describes SQL Server security models, logins, users, partially contained databases, and cross-server authorization.
Lessons
  • Authenticating Connections to SQL Server
  • Authorizing Logins to Connect to databases
  • Authorization Across Servers
  • Partially Contained Databases
 
Module 2: Assigning Server and Database Roles
Using roles simplifies the management of user permissions. With roles, you can control authenticated users’ access to system resources based on each user’s job function—rather than assigning permissions user-by-user, you can grant permissions to a role, then make users members of roles. Microsoft SQL Server includes support for security roles defined at server level and at database level.
Lessons
  • Working with server roles
  • Working with Fixed Database Roles
  • Assigning User-Defined Database Roles
 
Module 3: Authorizing Users to Access Resources
In the previous modules, you have seen how Microsoft SQL Server security is organized and how sets of permissions can be assigned at the server and database level by using fixed server roles, user-defined server roles, fixed database roles, and application roles. The final step in authorizing users to access SQL Server resources is the authorization of users and roles to access server and database objects. In this module, you will see how these object permissions are managed. In addition to access permissions on database objects, SQL Server provides the ability to determine which users are allowed to execute code, such as stored procedures and functions. In many cases, these permissions and the permissions on the database objects are best configured at the schema level rather than at the level of the individual object. Schema-based permission grants can simplify your security architecture. You will explore the granting of permissions at the schema level in the final lesson of this module.
Lessons
  • Authorizing User Access to Objects
  • Authorizing Users to Execute Code
  • Configuring Permissions at the Schema Level
 
Module 4: Protecting Data with Encryption and Auditing
When configuring security for your Microsoft SQL Server systems, you should ensure that you meet any of your organization’s compliance requirements for data protection. Organizations often need to adhere to industry-specific compliance policies, which mandate auditing of all data access. To address this requirement, SQL Server provides a range of options for implementing auditing. Another common compliance requirement is the encryption of data to protect against unauthorized access in the event that access to the database files is compromised. SQL Server supports this requirement by providing transparent data encryption (TDE). To reduce the risk of information leakage by users with administrative access to a database, columns containing sensitive data—such as credit card numbers or national identity numbers—can be encrypted using the Always Encrypted feature. This module describes the available options for auditing in SQL Server, how to use and manage the SQL Server Audit feature, and how to implement encryption.
Lessons
  • Options for auditing data access in SQL Server
  • Implementing SQL Server Audit
  • Managing SQL Server Audit
  • Protecting Data with Encryption
 
Module 5: Recovery Models and Backup Strategies
One of the most important aspects of a database administrator's role is ensuring that organizational data is reliably backed up so that, if a failure occurs, you can recover the data. Even though the computing industry has known about the need for reliable backup strategies for decades—and discussed this at great length—unfortunate stories regarding data loss are still commonplace. A further problem is that, even when the strategies in place work as they were designed, the outcomes still regularly fail to meet an organization’s operational requirements. In this module, you will consider how to create a strategy that is aligned with organizational needs, based on the available backup models, and the role of the transaction logs in maintaining database consistency.
Lessons
  • Understanding Backup Strategies
  • SQL Server Transaction Logs
  • Planning Backup Strategies
 
Module 6: Backing Up SQL Server Databases
In the previous module, you learned how to plan a backup strategy for a SQL Server system. You can now learn how to perform SQL Server backups, including full and differential database backups, transaction log backups, and partial backups. In this module, you will learn how to apply various backup strategies.
Lessons
  • Backing Up Databases and Transaction Logs
  • Managing Database Backups
  • Advanced Database Options
 
Module 7: Restoring SQL Server 2016 Databases
In the previous module, you learned how to create backups of Microsoft SQL Server 2016 databases. A backup strategy might involve many different types of backup, so it is essential that you can effectively restore them. You will often be restoring a database in an urgent situation. You must, however, ensure that you have a clear plan of how to proceed and successfully recover the database to the required state. A good plan and understanding of the restore process can help avoid making the situation worse. Some database restores are related to system failure. In these cases, you will want to return the system as close as possible to the state it was in before the failure. Some failures, though, are related to human error and you might wish to recover the system to a point before that error. The point-in-time recovery features of SQL Server 2016 can help you to achieve this. Because they are typically much larger, user databases are more likely to be affected by system failures than system databases. However, system databases can be affected by failures, and special care should be taken when recovering them. In particular, you need to understand how to recover each system database because you cannot use the same process for all system databases. In this module, you will see how to restore user and system databases and how to implement point-in-time recovery.
Lessons
  • Understanding the Restore Process
  • Restoring Databases
  • Advanced Restore Scenarios
  • Point-in-Time Recovery
 
Module 8: Automating SQL Server Management
The tools provided by Microsoft SQL Server make administration easy when compared to some other database engines. However, even when tasks are easy to perform, it is common to have to repeat a task many times. Efficient database administrators learn to automate repetitive tasks. This can help to avoid situations where an administrator forgets to execute a task at the required time. Perhaps more importantly, the automation of tasks helps to ensure that they are performed consistently, each time they are executed. This module describes how to use SQL Server Agent to automate jobs, how to configure security contexts for jobs, and how to implement multiserver jobs.
Lessons
  • Automating SQL Server management
  • Working with SQL Server Agent
  • Managing SQL Server Agent Jobs
  • Multi-server Management
 
Module 9: Configuring Security for SQL Server Agent
Other modules in this course have demonstrated the need to minimize the permissions that are granted to users, following the principle of “least privilege.” This means that users have only the permissions that they need to perform their tasks. The same logic applies to the granting of permissions to SQL Server Agent. Although it is easy to execute all jobs in the context of the SQL Server Agent service account, and to configure that account as an administrative account, a poor security environment would result from doing this. It is important to understand how to create a minimal privilege security environment for jobs that run in SQL Server Agent.
Lessons
  • Understanding SQL Server Agent Security
  • Configuring Credentials
  • Configuring Proxy Accounts
 
Module 10: Monitoring SQL Server with Alerts and Notifications
One key aspect of managing Microsoft SQL Server in a proactive manner is to make sure you are aware of problems and events that occur in the server, as they happen. SQL Server logs a wealth of information about issues. You can configure it to advise you automatically when these issues occur, by using alerts and notifications. The most common way that SQL Server database administrators receive details of events of interest is by email message. This module covers the configuration of Database Mail, alerts, and notifications for a SQL Server instance, and the configuration of alerts for Microsoft Azure SQL Database.
Lessons
  • Monitoring SQL Server Errors
  • Configuring Database Mail
  • Operators, Alerts, and Notifications
  • Alerts in Azure SQL Database
 
Module 11: Introduction to Managing SQL Server by using PowerShell
This module looks at how to use Windows PowerShell with Microsoft SQL Server. Businesses are constantly having to increase the efficiency and reliability of maintaining their IT infrastructure; with PowerShell, you can improve this efficiency and reliability by creating scripts to carry out tasks. PowerShell scripts can be tested and applied multiple times to multiple servers, saving your organization both time and money.
Lessons
  • Getting Started with Windows PowerShell
  • Configure SQL Server using PowerShell
  • Administer and Maintain SQL Server with PowerShell
  • Managing Azure SQL Databases using PowerShell
 
Module 12: Tracing Access to SQL Server with Extended events
Monitoring performance metrics provides a great way to assess the overall performance of a database solution. However, there are occasions when you need to perform more detailed analysis of the activity occurring within a Microsoft SQL Server instance—to troubleshoot problems and identify ways to optimize workload performance. SQL Server Extended Events is a flexible, lightweight event-handling system built into the Microsoft SQL Server Database Engine. This module focuses on the architectural concepts, troubleshooting strategies and usage scenarios of Extended Events.
Lessons
  • Extended Events Core Concepts
  • Working with Extended Events
 
Module 13: Monitoring SQL Server
The Microsoft SQL Server Database Engine can run for long periods without the need for administrative attention. However, if you regularly monitor the activity that occurs on the database server, you can deal with potential issues before they arise. SQL Server provides a number of tools that you can use to monitor current activity and record details of previous activity. You need to become familiar with what each of the tools does and how to use them. It is easy to become overwhelmed by the volume of output that monitoring tools can provide, so you also need to learn techniques for analyzing their output.
Lessons
  • Monitoring activity
  • Capturing and Managing Performance Data
  • Analyzing Collected Performance Data
  • SQL Server Utility
 
Module 14: Troubleshooting SQL Server
Database administrators working with Microsoft SQL Server need to adopt the important role of troubleshooter when issues arise—particularly if users of business-critical applications that rely on SQL Server databases are being prevented from working. It is important to have a solid methodology for resolving issues in general, and to be familiar with the most common issues that can arise when working with SQL Server systems.
Lessons
  • A Trouble Shooting Methodology for SQL Server
  • Resolving Service Related Issues
  • Resolving Connectivity and Log-in issues
 
Module 15: Importing and Exporting Data
While a great deal of data residing in a Microsoft SQL Server system is entered directly by users who are running application programs, there is often a need to move data in other locations, to and from SQL Server. SQL Server provides a set of tools you can use to transfer data in and out. Some of these tools, such as the bcp (Bulk Copy Program) utility and SQL Server Integration Services, are external to the database engine. Other tools, such as the BULK INSERT statement and the OPENROWSET function, are implemented in the database engine. With SQL Server, you can also create data-tier applications that package all the tables, views, and instance objects associated with a user database into a single unit of deployment. In this module, you will explore these tools and techniques so that you can import and export data to and from SQL Server.
Lessons
  • Transferring Data to and from SQL Server
  • Importing and Exporting Table Data
  • Using bcp and BULK INSERT to Import Data
  • Deploying and Upgrading Data-Tier Application

Connaissances requises : 
In addition to their professional experience, students who attend this training should already have the following technical knowledge:
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of Transact-SQL.
  • Working knowledge of relational databases.
  • Some experience with database design.
 

© Colombus SA 2022  -   Contactez-nous   -   info@colombus.ch   -   Tél : +41 21 661 1675
  • Home
  • Formations
    • Microsoft >
      • Windows Server 2019 >
        • Windows Server 2019 Administration
        • Windows Server 2019 Hybrid and Azure IaaS
      • 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)
        • Automating Administration with Windows PowerShell 3.0 (cours 10961)
      • 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)
      • 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)
        • Quick Microsoft SQL Server 2012-2014 Integration Services (55120)
        • SQL Server 2014 Performance Tuning and Optimization (55144)
        • Analyzing Data with Power BI (20778)
      • Exchange 2016/2019 >
        • Administering Microsoft Exchange Server 2016/2019 (20345-1)
        • Designing and Deploying Microsoft Exchange Server 2016/2019 (20345-2)
      • Skype For Business 2016 >
        • Core Solutions of Skype for Business 2015 (20334)
        • Deploying Voice Workloads for Skype for Business Online and Server 2015 (40409)
      • 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 2019 >
        • SharePoint End User 2019
        • SharePoint 2019 Power User
        • SharePoint 2019 Site Owner Training
      • VisualStudio >
        • 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)
      • Développement Cloud avec Azure >
        • Developing Windows Azure and Web Services (Cours 20487)
        • Windows Azure Solutions with Microsoft Visual Studio 2010 (cours 50466)
        • Advanced SQL Azure (Cours 50592)
      • Dynamics 365 >
        • Dynamics 365 Fundamentals (CRM)
      • CRM 2016 >
        • Introduction to Microsoft Dynamics CRM 2016 (cours 80442)
        • Extending Microsoft Dynamics CRM 2016 (cours 80295)
        • Microsoft Dynamics CRM 2016 Installation and Deployment (cours 80296)
        • Reporting in Microsoft Dynamics CRM 2016 (cours 80445)
        • Workflow and Dialog Processes in Microsoft Dynamics CRM 2016 (cours 80444)
        • Marketing Automation in Microsoft Dynamics CRM 2016 (cours 80290)
        • Sales Management in Microsoft Dynamics CRM 2016 (cours 80291)
        • Service Management in Microsoft Dynamics CRM 2016 (cours 80292)
        • Service Scheduling in Microsoft Dynamics CRM 2016 (cours 80293)
      • System Center 2018 >
        • Monitoring and Operating a Private Cloud with System Center 2018 (cours 10750)
        • Configuring and Deploying a Private Cloud with System Center 2018 (cours 10751)
        • Administering System Center 2018 Configuration Manager (cours 10747)
        • Deploying System Center 2018 Configuration Manager (cours 10748)
        • System Center 2018 Service Manager (cours 55009)
      • Office >
        • PowerPoint >
          • Introduction to Microsoft PowerPoint (55176)
          • Advanced Microsoft PowerPoint (55177)
        • Excel >
          • Introduction to Microsoft Excel (55165)
          • Intermediate Microsoft Excel (55166)
          • Advanced Microsoft Excel (55167)
          • Maximizing PivotTable (50448)
          • Useful Formulas & Functions (50449)
          • Solutions with Complex Formulas and Functions (50576)
          • Amazing Macros (50476)
          • PowerPivot for End Users (50433)
        • Word >
          • Introduction to Microsoft Word (50173)
          • Intermediate Microsoft Word (55174)
          • Advanced Microsoft Word (55175)
        • Access >
          • Learn Microsoft Access Step by Step, Level 1 (cours 50532)
          • Learn Microsoft Access Step by Step, Level 2 (cours 50533)
          • Learn Microsoft Access Step by Step, Level 3 (cours 50534)
        • Outlook >
          • Introduction to Microsoft Outlook (55178)
          • Advanced Microsoft Outlook (55179)
        • Project >
          • Introduction to Microsoft Project: Getting Started (55180)
          • Microsoft Project: Digging Deeper (55181)
        • Visio Step by Step (cours 50107)
        • OneNote Step by Step (cours ON2010F)
        • Publisher Step by Step (cours PUB2010F)
      • 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 (Cours 50588)
        • Office 365 for IT Professionals (Cours 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
    • Cours de Management, Vente et Gestion de Clients >
      • L'Esprit d'équipe au service de l'efficacité (EESE) (cours MOT0001)
      • Séminaire des dirigeants d'entreprise (cours MOT0002)
      • Progresser par insights discovery (cours MOT0003)
      • Le management des hommes et des femmes (cours MOT0004)
      • L'attitude intérieure positive (cours MOT0005)
      • Le Management de soi-même et de son temps (cours MOT0006)
      • L'orientation client (cours MOT0007)
      • La vente des biens et des services (cours MOT0008)
    • Photographie >
      • 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)
      • Maîtrise du système de Flash sans fil Nikon i-TTL , CLS (cours PHO006)
      • Utiliser les produits d'ArcSoft (cours PHO007)
  • Développement
    • Accords sur l’imposition à la source : 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
    • Accords sur l’imposition à la source : Rubik
    • Qu'est ce qui nous rend différent ?
  • Outsourcing
    • Outsourcing complet de l'IT
    • Infrastructure
    • Cloud Computing
    • Gestion des applications
    • Gestion des processus d'affaires >
      • Gestion des documents
  • 3D
    • Vidéos
    • Réalité augmentée
  • Qui sommes-nous ?
    • Chiffres et données
    • Pourquoi nous ?
    • Business Continuity
    • Quality Management
    • Méthodologie
  • Contact
  • English site