Microsoft SQL Server DBA Essential

Microsoft SQL Server DBA Essential Training

You have little or no experience in Microsoft SQL Server database administration and want to know all about installation, configuration and maintenance? Then the Microsoft SQL Server DBA Essential Skills Training is for you. Upon completion of this course, you will be able to install a DBMS instance and administer an SQL Server database in line with best practices.

Objectives

Understand SQL Server concepts (operation, storage, security, administration)
Install & configure a GUI or command line instance, following best practices
Create and configure databases
Maintain an MSSQL environment: maintenance plan (indexes, data integrity, backups), SQL agent jobs and alerts, error log optimization
SQL Server prerequisites and best practices

Method

Presentations, practical exercises, case studies and question-oriented demonstrations
Discussion and networking during breaks and lunch (included)

Target groups

This Microsoft SQL Server DBA Essentials course is designed for Database Administrators (DBAs) as well as network, system and application administrators responsible for SQL Server databases or their support.

Prerequisites

Basic knowledge of Windows Server.

5% discount for SOUG, SwissPUG and DOAG members.

Trainers

Nathan Courtine

Technology Leader & Senior Consultant

Stéphane Haby

Delivery Manager & Principal Consultant

Cookie	Duration	Description
cf_use_ob	past	Cloudflare sets this cookie to improve page load times and to disallow any security restrictions based on the visitor's IP address.
cookielawinfo-checkbox-advertisement	1 year	Set by the GDPR Cookie Consent plugin, this cookie is used to record the user consent for the cookies in the "Advertisement" category .
cookielawinfo-checkbox-analytics	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional	11 months	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
CookieLawInfoConsent	1 year	Records the default button state of the corresponding category & the status of CCPA. It works only in coordination with the primary cookie.
viewed_cookie_policy	11 months	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.

Cookie	Duration	Description
_pk_id.1.3dc2	1 year 27 days	No description
_pk_ses.1.3dc2	30 minutes	No description
wp-wpml_current_language	session	This cookie is used to know which language of the website you are currently browsing.

Microsoft SQL Server DBA Essential Training

Objectives

Method

Target groups

Prerequisites

HEADQUARTER

OUR OFFICES NEARBY

Course registration