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 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

Nyon 28-30.09.2021
Basel 26-28.10.2021
OnSite/InSite On demand
3 days
CHF 2700.- *

Trainers

  • StĂ©phane Haby
    Stéphane Haby
  • Nathan Courtine
    Nathan Courtine

By booking a dbi services’ InSite workshop, the customer commits to respecting the Sales and Service General Conditions

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

-5% for SOUG, SwissPUG, or DOAG members
Members of the SOUG (Swiss Oracle User Group), SwissPUG (Swiss PostgreSQL User Group) or DOAG (Deutsche Oracle-Anwendergruppe) are entitled to a discount of 5% on our trainings

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 - book now!

    You want to book a dbi InSite Workshop or get more information on our IT trainings? Please fill in the entry form below. We will confirm your participation or come back to you as soon as possible. If, to our regret, the workshop is already fully booked, we will inform you on other dates or alternative solutions.

    Training sessions :




    Please contact me via :

    E-mailPhone

    Where did you know dbi services ?


      dbi InSite Workshop on-site - request & information

      You want dbi services to hold an "on-site" (in your premises) workshop for you ? 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-mailPhone

      Where did you know dbi services ?