Infrastructure at your Service

SQL Server DBA essentials workshop

dbi InSite Workshops

You have little or no experience in Microsoft SQL Server database administration and want to know how to install, configure, and maintain an SQL Server 2008/2012 database? Then you should attend our SQL Server DBA essentials workshop training. In this three-day course, you will learn how to install the RDBMS instance as well as to create, configure, and maintain the SQL Server database and its various objects – schema, function, trigger, etc.

 

Training’s dates

3 days
CHF 2700.- *

Trainers

  • Stéphane Haby
    Stéphane Haby
  • David Barbarin
    David Barbarin
  • Nathan Courtine
    Nathan Courtine

(*) Prices are to be considered per participant and without VAT

SOUG (Swiss Oracle User Group) The members of the SOUG (Swiss Oracle User Group) benefit from a 5 % reduction.

Training objectives

  • Understand the SQL Server design
  • Install & configure instances
  • Create & configure databases
  • Maintaining databases: maintenance plan, re-indexing, SQL agent jobs & alerts, troubleshooting, high availability basics

Topics

  • Server requirements and best practice
  • Installation with the wizard and using script
  • Firewall & services configuration
  • Instance configuration
  • Database creation with the wizard and by script
  • Database security: roles & logins
  • Databases objects: table, view, trigger, function, stored procedures, etc.
  • Maintenance plan: backup, history cleanup, integrity test, reorganize and rebuild indexes
  • Using the SQL agent

Method

  • Presentation with countless practical exercises and trainings
  • Case studies, live demos, discussions
  • Networking during coffee break, lunch, and apéro on last day (included in price, except for on-site workshop courses)

Target groups

  • Database administrators (DBA) as well as network, system, and application administrators responsible for or supporting SQL Server databases

Related Trainings & Events

Language & documentation

  • Workshop training normally held in English; French or German possible instead as course languages
  • Documentation: content details, scripts, case study solutions as PDF file (in English)
 

dbi InSite Workshop on-site - request & information

You want dbi services to hold an "on-site" workshop inside your organisation? You have special requirements, e. g. regarding the content, the duration, the date, or the number of participants?
We have good news for you: Our dbi InSite Workshops can be flexibly adapted to your needs! Please just fill in the form below and we will come back to you as soon as possible. You may also use this form to inquire on the future dates of our dbi InSite Workshops.





Please contact me via :

 E-mail Phone

Where did you know dbi services ?


captcha

Pierre-Yves Brehier
Pierre-Yves Brehier

Region Manager







captcha