Register   |  Login      
Rejuvenating Business:
Training | Consulting | Certification | Security | VoIP
CHAT LIVE WITH ITPLANIT Follow us on Twitter Follow us on Facebook Google+ Followers will receive 10% off any public course at Itplanit Follow us on Linkedin Follow us on YouTube Course Catalogue 2013-2014
Suggest a Course New Search


9189:   6231B: Maintaining a Microsoft SQL Server 2008 R2 Database
Event Date : 03/11/13   09:00 AM Duration (days) : 5
Instructor : Charles Bourgon Price (CAD) : 2400.00
Make us an offer
Name
Email
Phone
Co.Name
Co.Name Address
Venue:

Your Offer is (please indicate $ amount)
   

 
  Outline

6231B: Maintaining a Microsoft SQL Server 2008 R2 Database

In Partnership with MMBC

About this Course
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 R2 database. The course focuses on teaching individuals how to use SQL Server 2008 R2 product features and tools related to maintaining a database.
Audience Profile
The primary audience for this course is individuals who administer and maintain SQL Server databases. This course can also be helpful for individuals who develop applications that deliver content from SQL Server databases.
At Course Completion
After completing this course, students will be able to:
  • Explain SQL Server 2008 R2 architecture, resources requirements and perform pre-checks of I/O subsystems
  • Plan, install and configure SQL Server 2008 R2
  • Backup and restore databases
  • Import and export wizards and explain how they relate to SSIS
  • Use BCP and BULK INSERT to import data
  • Manage security
  • Assign, configure fixed database roles and create and assign user defined database roles
  • Configure and assign permissions
  • Implement SQL Server 2008 R2 Audits
  • Manage SQL Server 2008 R2 Agent and Jobs
  • Configure database mails, alerts and notifications
  • Maintain databases
  • Configure SQL Profiler Traces and Use the Database Tuning Advisor
  • Monitor data by using Dynamic Management Views
  • Execute multi-server queries and configure a central management server
  • Deploy a data-tier-application
  • Troubleshoot common issues

Course OutlineModule 1: Introduction to SQL Server 2008 R2 and its Toolset

This module introduces you to the entire SQL Server platform and its major tools. This module also covers editions, versions, basics of network listeners, and concepts of services and service accounts.

Lessons

  • Introduction to SQL Server Platform
  • Working with SQL Server Tools
  • Configuring SQL Server Services

Lab : Introduction to SQL Server 2008 R2 and its Toolset

  • Verify SQL Server Component Installation
  • Alter Service Accounts for New Instance
  • Enable Named Pipes Protocol for Both Instances
  • Create Aliases for AdventureWorks and Proseware
  • Ensure SQL Browser is Disabled and Configure a Fixed TCP/IP Port
  • Describe the SQL Server Platform
  • Work with SQL Server Tools
  • Configure SQL Server Services

Module 2: Preparing Systems for SQL Server 2008 R2

This module covers planning for an installation related to SQL Server I/O requirements, 32 bit vs 64 bit, memory configuration options and I/O subsystem pre-installation checks using SQLIOSim and SQLIO.

Lessons

  • Overview of SQL Server 2008 R2 Architecture
  • Planning Server Resource Requirements
  • Pre-installation Testing for SQL Server 2008 R2

Lab : Preparing Systems for SQL Server 2008 R2

  • Adjust memory configuration
  • Perform Pre-installation Stress Testing
  • Check Specific I/O Operations
  • Describe the SQL Server architecture
  • Plan for server resource requirements
  • Conduct pre-installation stress testing for SQL Server

Module 3: Installing and Configuring SQL Server 2008 R2

This module details installing and configuring SQL Server 2008 R2.

Lessons

  • Preparing to Install SQL Server 2008 R2
  • Installing SQL Server 2008 R2
  • Upgrading and Automating Installation

Lab : Installing and Configuring SQL Server 2008 R2

  • Review installation requirements
  • Install the SQL Server instance
  • Perform Post-installation Setup and Checks
  • Configure Server Memory
  • Prepare to install SQL Server
  • Install SQL Server
  • Upgrade and automate the installation of SQL Server

Module 4: Working with Databases

This module describes the system databases, the physical structure of databases and the most common configuration options related to them.

Lessons

  • Overview of SQL Server Databases
  • Working with Files and Filegroups
  • Moving Database Files

Lab : Working with Databases

  • Adjust tempdb configuration
  • Create the RateTracking database
  • Attach the OldProspects database
  • Add multiple files to tempdb
  • Describe the role and structure of SQL Server databases
  • Work with files and filegroups
  • Move database files within servers and between servers

Module 5: Understanding SQL Server 2008 R2 Recovery Models

This module describes the concept of the transaction log and SQL Server recovery models. It introduces the different backup strategies available with SQL Server 2008 R2.

Lessons

  • Backup Strategies
  • Understanding SQL Server Transaction Logging
  • Planning a SQL Server Backup Strategy

Lab : Understanding SQL Server 2008 R2 Recovery Models

  • Plan a backup strategy
  • Configure recovery models
  • Review recovery models and strategy
  • Describe the critical concepts surrounding backup strategies
  • Explain the transaction logging capabilities within the SQL Server database engine
  • Plan a SQL Server backup strategy

Module 6: Backup of SQL Server 2008 R2 Databases

This module describes SQL Server 2008 R2 Backup and the backup types.

Lessons

  • Backing up Databases and Transaction Logs
  • Managing Database Backups
  • Working with Backup Options

Lab : Backup of SQL Server 2008 R2 Databases

  • Investigate backup compression
  • Transaction log backup
  • Differential backup
  • Copy only backup
  • Partial backup
  • Back up databases and transaction logs
  • Manage database backups
  • Work with more advanced backup options

Module 7: Restoring SQL Server 2008 R2 DatabasesThis module describes the restoration of databases.Lessons

  • Understanding the Restore Process
  • Restoring Databases
  • Working with Point-in-time Recovery
  • Restoring System Databases and Individual Files

Lab : Restoring SQL Server 2008 R2 Databases

  • Determine a restore strategy
  • Restore the database
  • Using STANDBY mode
  • Understand the restore process
  • Restore databases
  • Work with Point-in-time Recovery
  • Restore system databases and individual files

Module 8: Importing and Exporting DataThis module covers the use of the import/export wizards and explains how they relate to SSIS. Also introduces BCP.Lessons

  • Transferring Data To/From SQL Server 2008 R2
  • Importing & Exporting Table Data
  • Inserting Data in Bulk

Lab : Importing and Exporting Data

  • Import the Excel spreadsheet
  • Import the CSV file
  • Create and test an extraction package
  • Compare loading performance
  • Transfer data to and from SQL Server
  • Import and export table data
  • Insert data in bulk and optimize the bulk insert process

Module 9: Authenticating and Authorizing Users

This module covers SQL Server 2008 R2 security models, logins and users.

Lessons

  • Authenticating Connections to SQL Server
  • Authorizing Logins to Access Databases
  • Authorization Across Servers

Lab : Authenticating and Authorizing Users

  • Create Logins
  • Correct an Application Login Issue
  • Create Database Users
  • Correct Access to Restored Database
  • Describe how SQL Server authenticates connections
  • Describe how logins are authorized to access databases
  • Explain the requirements for authorization across servers

Module 10: Assigning Server and Database Roles

This module covers fixed server roles, fixed database roles and user-defined database roles.

Lessons

  • Working with Server Roles
  • Working with Fixed Database Roles
  • Creating User-defined Database Roles

Lab : Assigning Server and Database Roles

  • Assign Server Roles
  • Assign Fixed Database Roles
  • Create and Assign User-defined Database Roles
  • Check Role Assignments
  • Work with server roles
  • Work with fixed database roles
  • Create user-defined database roles

Module 11: Authorizing Users to Access Resources

This module covers permissions and the assignment of permissions.

Lessons

  • Authorizing User Access to Objects
  • Authorizing Users to Execute Code
  • Configuring Permissions at the Schema Level

Lab : Authorizing Users to Access Resources

  • Assign Schema-level Permissions
  • Assign Object-level Permissions
  • Test Permissions
  • Authorize user access to objects
  • Authorize users to execute code
  • Configure permissions at the schema level

Module 12: Auditing SQL Server Environments

This module covers SQL Server Audit.

Lessons

  • Options for Auditing Data Access in SQL Server
  • Implementing SQL Server Audit
  • Managing SQL Server Audit

Lab : Auditing SQL Server Environments

  • Determine audit configuration and create auditCreate server audit specificationsCreate database audit specificationsTest audit functionality
  • Describe the options for auditing data access in SQL Server
  • Implement SQL Server Audit
  • Manage SQL Server Audit

Module 13: Automating SQL Server 2008 R2 Management

This module covers SQL Server Agent, jobs and job history.

Lessons

  • Automating SQL Server Management
  • Working with SQL Server Agent
  • Managing SQL Server Agent Jobs

Lab : Automating SQL Server 2008 R2 Management

  • Create a Data Extraction Job
  • Schedule the Data Extraction Job
  • Troubleshoot a Failing Job
  • Automate SQL Server Management
  • Work with SQL Server Agent
  • Manage SQL Server Agent jobs

Module 14: Configuring Security for SQL Server Agent

This module covers SQL Server agent security, proxy accounts and credentials.

Lessons

  • Understanding SQL Server Agent Security
  • Configuring Credentials
  • Configuring Proxy Accounts

Lab : Configuring Security for SQL Server Agent

  • Troubleshoot job execution failure
  • Resolve the security issue
  • Perform further troubleshooting
  • Explain SQL Server Agent security
  • Configure credentials
  • Configure Proxy accounts

Module 15: Monitoring SQL Server 2008 R2 with Alerts and NotificationsThis module covers the configuration of database mail, alerts and notifications.Lessons

  • Configuration of Database Mail
  • Monitoring SQL Server Errors
  • Configuring Operators, Alerts and Notifications

Lab : Monitoring SQL Agent Jobs with Alerts and Notifications

  • Configure Database Mail
  • Implement Notifications
  • Implement Alerts
  • Configure database mail
  • Monitor SQL Server errors
  • Configure operators, alerts and notifications

Module 16: Performing Ongoing Database Maintenance

This module covers database maintenance plans.

Lessons

  • Ensuring Database Integrity
  • Maintaining Indexes
  • Automating Routine Database Maintenance

Lab : Ongoing Database Maintenance

  • Check database integrity using DBCC CHECKDB
  • Correct index fragmentation
  • Create a database maintenance plan
  • Investigate table lock performance
  • Ensure database integrity
  • Maintain indexes
  • Automate routine database maintenance

Module 17: Tracing Access to SQL Server 2008 R2This module covers SQL Profiler and SQL Trace stored procedures.Lessons

  • Capturing Activity using SQL Server Profiler
  • Improving Performance with the Database Engine Tuning Advisor
  • Working with Tracing Options

Lab : Tracing Access to SQL Server 2008 R2

  • Capture a trace using SQL Server Profiler
  • Analyze a trace using Database Engine Tuning Advisor
  • Configure SQL Trace
  • Capture activity using SQL Server Profiler
  • Improve performance with the Database Engine Tuning Advisor
  • Work with tracing options

Module 18: Monitoring SQL Server 2008 R2

This module introduces DMVs and the configuration of data collection.

Lessons

  • Monitoring Activity
  • Capturing and Managing Performance Data
  • Analyzing Collected Performance Data

Lab : Monitoring SQL Server 2008 R2

  • Investigating DMVs
  • Configure Management Data Warehouse
  • Configure Instances for Data Collection
  • Work with Data Collector Reports
  • Monitor current activity
  • Capture and manage performance data
  • Analyze collected performance data

Module 19: Managing Multiple Servers

This module covers Central Management Servers and Multi-Server queries, Virtualization of SQL Server and Data-Tier Applications.

Lessons

  • Working with Multiple Servers
  • Virtualizing SQL Server
  • Deploying and Upgrading Data-Tier Applications

Lab : Managing Multiple Servers

  • Configure CMS and execute multi-server queries
  • Deploy a data-tier application
  • Register and extract a data-tier application
  • Upgrade a data-tier application
  • Work with multiple servers
  • Describe options for virtualizing SQL Server
  • Deploy and upgrade Data-Tier Applications

Module 20: Troubleshooting Common SQL Server 2008 R2 Administrative Issues

This module covers common issues that require troubleshooting and gives guidance on where to start looking for solutions.

Lessons

  • SQL Server Troubleshooting Methodology
  • Resolving Service-related Issues
  • Resolving Concurrency Issues
  • Resolving Login and Connectivity Issues

Lab : Troubleshooting Common Issues

  • Troubleshoot and resolve SQL Server administrative issues
  • Explain SQL Server troubleshooting methodology
  • Resolve service-related issues
  • Resolve concurrency issues
  • Resolve login and connectivity issues

Prerequisites

  • 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.
  • Completed Course 2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
  •  

     

    You choose how you wish to attend the course and we'll deliver:

    1. Live instructor-led at Itplanit's Ottawa facility
    2. Live instructor-led online at Itplanit's Ottawa facility - Streamed live to Itplanit (save up to 15%)
    3. Live instructor-led online to your home, your office...Streamed live to you (save up to 25%)

    Note: If multiple discounts apply, you will automatically receive the largest qualifying discount.


      Hours, prices, bundles, policies, guarantees, how to pay and fundraising
     

    Typical public course Training Hours
    Orientation/snacks and beverages: 8:30 a.m. - 9:00 a.m.
    Standard class hours: 9:00 a.m. - 4:00 p.m. (note: Start and end times are approximate and depend on the number of student and pace of the class.  We may need to run a little longer or finish a bit sooner than anticipated.)
    Last day class hours (multiple day sessions): 9:00 a.m. - 3:30 p.m.
    Course exam (if purchased): 2:30 p.m. - 3:30 p.m. (last day).
    Each class day: Informal discussion with instructor about your projects:4:00 p.m. - 4:30 p.m.


     
     

     

    ItplaniteKits and eCerts - A Dynamic New Way to Study and Learn
    Why be burdened with logging a book around...When you can access it from Itplanit wherever you are. Itplanit has replaced printed student guides with downloadable eKits for each Itplanit Instructor-Led Live Online (IILLO) class and certain classroom courses. Electronic student guides represent a dynamic new way to study and learn. The flexibility, interactivity, and portability of eKits cannot be matched by traditional printed material.

    Our eKits are available online one week prior to the start of your class so that you can outline key points, prepare questions, and print important concepts and procedures. Following training, online access to download the eKit continues for 1 month or more. This new method of online delivery supports Itplanit’s initiative to be more environmentally responsible by conserving natural resources.

    Benefits

    • Your own copy of Itplanit or one of our vendor course materials on your own computer—to take wherever you like
    • PDF format with search capabilities
    • Early review and preparation
    • Savings of millions of printed pages every year

    If your class includes an eKit and eCert, you will see the following icons displayed in the online course description:

    A paper kit can be requested upon registration. An additional fee may apply.
    For additional details about eKits and eCerts, call your Itplanit representative. 


     
    LEARN FOR FREE -  You can redeem your Microsoft vouchers in exchange for free training
     
    You can pay for your Microsoft Certified Training with your Microsoft training vouchers (Microsoft Software Assurance Training Vouchers). You probably qualify for the exchange of training SATV bills if your organization has purchased Microsoft volume license program. If you need help determining your eligibility, contact the team of SATV at Itplanit at (877) 842-9772.
    Attend free classroom or virtual Microsoft at Itplanit training, by exchanging your training vouchers.
    You can activate your SATV in the (CSLV) volume licensing service Centre on this site:
    https://licensing.Microsoft.com/eLicense/L1033/Default.asp
    For instructions on how to activate and manage your SATV visit this site:
    http://www.Microsoft.com/licensing/sa/activate.mspx
    You need help to manage your SATV?
    If you need help to manage your SATV, our operations team can do it for you. Activation management, registration of courses for you and your employees.
    For more information about the exchange of your SATV call us at (877) 842-9772, or by e-mail at info@itplanit.com.

    Training Policies and Guarantees
     
    Tuition fees entitle you to: team workshops, course materials with exercises, snacks, refreshments and a certificate at the end of the course.
     
    Public course cancellation policy:
    Cancellation of courses by Itplanit: Itplanit Services Corp. reserves the right to cancel or modify the scheduled dates, places, and the hosting of all regular training courses. Itplanit will make every effort to inform the participants of the course within a reasonable time. However, Itplanit is not responsible for personal travel, accommodation, or other charges incurred for changes or cancellations. Where Itplanit must cancel a specific course, a full refund of the costs of courses and registration will be done or a reservation in a future courses will be offered (choice of the registrant). Registrants will be notified of any cancellation by phone, e-mail or by fax. After the cancellation of the course, registrants will have the choice of a refund or book a place in a future course.
    Cancellations of public courses by the students can be made more than 2 working weeks from the date of scheduled course, without penalty. Cancellations of courses made within 2 business weeks before the date of scheduled course will have a penalty of 50%. However, if the student provides a future date and reserves at the same time of the cancellation, Itplanit will apply 100% of this amount to the cost of the newly reserved course (choice of the registrant). Cancellation made within a working week before the date of planned delivery of the course will be a penalty of 75%. However, if the student provides a date confirmed for the change of course and reserves at the same time of the cancellation, Itplanit will apply 100% of this amount to the cost of the newly reserved course. Credit notes are transferable in the same organization. Cancellation penalty transfers to future courses can only be made once. Upon second cancellation for the same course the cancellation fee of 100% applies. Please, send your notice of cancellation to info@itplanit.com or by fax to the 613.842.9772.
     
    Dedicated course cancellation policy:
    Cancellation policy for courses dedicated to a company or off-site training: Itplanit Services Corp. reserves the right to cancel or modify the scheduled dates, places, and the hosting of all dedicated training courses. Itplanit will make every effort to inform the organization within a reasonable time. However, Itplanit is not responsible for personal travel, accommodation, or other charges incurred for changes or cancellations. Where Itplanit must cancel a specific course, a full refund of course registration fees shall be made or a reservation in a future courses will be offered (choice of the client). The registered client will be notified of any cancellation by phone, e-mail or by fax. Cancellations of courses conducted by the organization may be made for more than 3 working weeks from the date of scheduled course, without penalty. Cancellation of courses made within 3 working weeks before the scheduled course date will be charged 50% of the course fees. Cancellation of less than one working week prior to the date of expected delivery of the course will pay a penalty of 100%. However, if the customer provides a confirmed date for the change of course and reserves at the same time of the cancellation, Itplanit will be 25% of this amount to the cost of the newly reserved course. Credit notes are transferable in the same organization. Please, send your notice of cancellation to info@itplanit.com or by fax to the 613.842.9772.

    Guarantees:
    Courses Likely to Run (listed on the home page)
    The list of the courses likely to occur are listed on our home page: all entries are pending approval by Itplanit Services Corp.. Once your registration is approved, the course is moved to our list of courses likely to run on our home page. But we still cannot guarantee that we will not cancel your registration. Itplanit reserves the right to personalize all courses with two participants or less. The customization of the course will focus on the same material, but may be of shorter duration. In these circumstances, Itplanit reserves the right to choose if the learning materials are printed, or snacks are included. In any circumstance, Itplanit reserves the right to change the date of course.
     
    Guaranteed 100% - at Itplanit, our goal is to offer the best possible training. We are so confident that you will be completely satisfied that if at the end of the first morning of a course of one or two days, or at the end of the first day of class for a training course of three to five days, you are not satisfied with the course and you want to leave for this reason, you should; (i) notify the trainer (ii) return all materials (course material must be non-marked for a full credit) (iii) contact the Cancellation Department at 613.842.9772 at the latest at noon for courses 1 and 2 days or before the close of our offices for training of several days to receive a 100% refund or to receive a credit for a future course. The 100% guarantee applies only if the student has signed the attendance list, completed the first half of the morning of the course of a one or two day course, or finished the first day of the course of three to five days. All course materials must remain with the instructor at the time of leaving. The guarantee does not apply to the Partner Delivered Courses, such as Microsoft Certified Training, IBM, VMware, etc.... (It is the responsibility of students to confirm with Itplanit in advance to ensure that the course is part of the 100% guarantee).

    How to Pay for your course
    We accept payment on delivery, cheques, company or Government purchase order, Visa and MasterCard. Due to fraudulent credit card charges increase, to protect our customers, we do not have automatic processing online. There is no fee to pay to process a credit card payment. However a 4% charge from the total invoice (without HST) in addition to a fee of $10.50 is applicable for the reversal of your payment.
    To pay by credit card, call us at the 613.842.9772 or visit one of our centres of learning.
    --------------------------------------------------------------------------------
    Fund Raising
    From September to December 2013 Itplanit is again raising funds for the "SnowSuit Fund". Itplanit offers you opportunity to win a Surface Table to each student who attends a public course, a private session or writes a certificate exam but you must make a donation to the Snowsuit fund at Itplanit. Every penny counts.

     

    Make an offer on these likely to run courses and save money.
    Oracle WebLogic Server 10g R3 Advanced System Administration (Live Virtual)
    ($2850.00) 13 May 13
    Make Offer
    20331: Core Solutions of Microsoft SharePoint Server 2013
    ($2000.00) 13 May 13
    Make Offer
    Microsoft® Office Publisher 2007 Level 2
    ($265.00) 17 May 13
    Make Offer
    Microsoft® Office Word 2010: Level 1
    ($265.00) 21 May 13
    Make Offer
    50557: Microsoft Jump Start: Office 365 for IT Professionals
    ($1500.00) 21 May 13
    Make Offer
    10747: Administering System Center 2012 Configuration Manager
    ($2000.00) 27 May 13
    Make Offer
    Desktop Virtualization with VMware View 5.1
    ($2800.00) 28 May 13
    Make Offer
    10748: Deploying System Center 2012 Configuration Manager
    ($1250.00) 03 Jun 13
    Make Offer
    Linux Administration Advanced
    ($1950.00) 03 Jun 13
    Make Offer
    50470B: Microsoft SharePoint Server 2010 for the Site Owner/Power User
    ($950.00) 04 Jun 13
    Make Offer
    Microsoft® Office OneNote 2010
    ($265.00) 04 Jun 13
    Make Offer
    Microsoft® Office Outlook® 2010: Level 1
    ($365.00) 05 Jun 13
    Make Offer
    Microsoft® Office Access® 2010: Level 1
    ($650.00) 06 Jun 13
    Make Offer
    Microsoft® Office Excel® 2010: Level 2
    ($265.00) 07 Jun 13
    Make Offer
    Microsoft® Office Excel® 2010: Level 1
    ($300.00) 14 Jun 13
    Make Offer
    DB2 for z/OS Database Administration
    ($2625.00) 17 Jun 13
    Make Offer
    Microsoft® Office Word 2010: Level 2
    ($265.00) 21 Jun 13
    Make Offer
    Microsoft® Office Visio® Professional 2007: Level 1
    ($365.00) 27 Jun 13
    Make Offer
    Microsoft® Office Access® 2010: Level 2
    ($365.00) 03 Jul 13
    Make Offer
    Microsoft® Office Outlook® 2010: Level 2
    ($365.00) 09 Jul 13
    Make Offer
    Microsoft® Office Excel® 2010: Level 4
    ($265.00) 19 Aug 13
    Make Offer
    Tomcat Administration for Windows
    ($1500.00) 28 Aug 13
    Make Offer
    Microsoft® Office Word 2010: Level 3
    ($265.00) 29 Aug 13
    Make Offer
    Certified Ethical Hacker: Ethical Hacking and Countermeasures v7
    ($3750.00) 23 Sep 13
    Make Offer

     

    CHAT LIVE WITH ITPLANIT

    Follow us on YouTubeFollow us on LinkedinFollow us on TwitterFollow us on FacebookGoogle+ Followers will receive 10% off any public course at Itplanit

    Course Catalogue 2013-2014

     

    1.877.842.9772 613.842.9772

    Heures de bureau | Hours of Operation: 9h à | to 17h EST Mon/Lun à | to fri/ven


    Centre de formation d’Ottawa | Ottawa Training Centre:
    151 rue Slater Street, Suite 301, Ottawa, Canada K1P 5H3


    Holiday Closure | Fermeture: Mar 29-1, May 20, Jul 1, Aug 5-10, Sept 2, oct 14

    FORMATION HALIFAX - MONTREAL - OTTAWA - TORONTO - CALGARY - EDMONTON - VANCOUVER TRAINING

     

     

     

     

     

    MICROSOFT CERTIFIED-MICROSOFT CERTIFIÉ

     

    BIZTALK SERVER

    DYNAMICS

    EXCHANGE SERVER 2007

    EXCHANGE SERVER 2010

    FOREFRONT

    INTERNET INFORMATION SERVICES

    LYNC SERVER

    PRIVATE CLOUD

    SHAREPOINT SERVER 2010

    SQL SERVER 2008

    SQL SERVER 2012

    SYSTEM CENTRE »VIRTUALIZATION

    VISUAL STUDIO

    WINDOWS (END USER)

    WINDOWS 8

    WINDOWS 8 METRO

    WINDOWS AZURE

    WINDOWS POWERSHELL

    WINDOWS SERVER 2008

    WINDOWS SERVER 2012

    SMALL BUSINESS SERVER 2011

    IT TECHNOLOGY - PROFESSIONNELS EN IT

     

    AJAX

    APACHE/TOMCAT

    C AND C++ PROGRAMMING

    CISCO

    Cloud cOMPUTING

    COMPTIA

    ETHICAL HACKER EC-CounciL

    INFORMATION SECURITY

    JAVA - JEE - J2EE

    JQUERRY

    LINUX

    MOBILE WEB DEVELOPMENT

    ORACLE

    PERL

    PHP

    SQL

    TCP/IP

    UNIX

    VMWARE

    VOIP

    WATCHGUARD

    XML

    Weblogic

    WebSphere

    GOOGLE

    OFFICE AUTOMATION - BUREAUTIQUE

     

    CRYSTAL REPORTS

    MICROSOFT LYNC

    OFFICE 2010 New FEATURES

    MICROSOFT ACCESS

    MICROSOFT EXCEL

    EXPRESSION WEB

    MICROSOFT INFOPATH

    MICROSOFT ONENOTE

    MICROSOFT OUTLOOK

    MICROSOFT POWERPOINT

    MICROSOFT PROJECT

    MICROSOFT PUBLISHER

    SHAREPOINT DESIGNER

    SHAREPOINT SERVICES

    MICROSOFT VISIO

    MICROSOFT WORD

    MICROSOFT PROJECT SERVER

    NUANCE

    OPEN OFFICE

    ORGPLUS

    QUICKBOOKS

    SOFT SKILLS AND MANAGEMENT - CAPITAL HUMAIN

     

    Administrative assistant

    Creativity training NEW

    critical thinking

    CUSTOMER SERVICE

    mba

    PRESENTATION SKILLS

    PROBLEM SOLVING AND DECISION MAKING

    star management

    sUPERVISION

    time management

    TRAIN THE TRAINER

    WRITING SKILLS

     

     

     

    GRAPHIC DESIGN & MULTIMEDIA - INFOGRAPHIE ET CONCEPTION WEB

     

    ADOBE

    APPLE

    AUTODESK

    CSS

    HTML

     

    BUSINESS AND PROJECT MANAGEMENT - GESTION D'AFFAIRES ET DE PROJET

     

    BUSINESS ANALYSIS

    BUSINESSCONTINUITY PLAN AND MANAGE

    BUSINESS PROCESS MANAGEMENT

    PROJECT MANAGEMENT

     

    SERVICE MANAGEMENT - GESTION DE SERVICE

     

    ENTERPRISE BUSINESS ARCHITECTURE

    ITIL®

    AGILE

    COBIT VAL-IT

    TOGAF

    ISO

    AIMM