Subsidized course „Jsem v kurzu“

Installing, Administering and Maintaining a Microsoft SQL Server and Database Infrastructure

The five-day course is designed for all who need the knowledge to effectively deploy, configure, manage, and maintain the latest version of Microsoft SQL Server 2019. The course focuses on deployment, configuring, administration, maintenance, tracing, monitoring, use SQL Server services and tools related to database management. The course is an alternative to the authorized courses M20764 and M20765.

Code
DB-ADM

Course length
5 days (8:30 – 16:00)

Form
In our classroom or online

Main course tutor

Ing. David Kovařovic

Ing. David Kovařovic

Cisco a Linux instructor

More about tutor

List price: 27 500 CZK (without VAT)

This course has no dates set. If you are interested in setting a new one, please contact skoleni@oksystem.cz.

This course is intended for

  • SQL Server administrators, database specialists, IT managers, and developers.

Syllabus

Module 1: Introduction to SQL Server

  • Lesson 1: Introduction to SQL Server
  • Lesson 2: Overview of SQL Server architecture, services, tools, editions and licensing
  • Lesson 3: Configuring SQL Server

Module 2: Installing and configuring SQL Server

  • Lesson 1: Preparing to install SQL Server
  • Lesson 2: Installing SQL Server
  • Lesson 3: Configuring SQL Server
  • Lesson 4: Installation automation
  • Lab: Installing and configuring SQL Server

Module 3: Working with databases

  • Lesson 1: Introduction to creating and managing databases
  • Lesson 2: Managing system databases
  • Lesson 3: Managing user databases
  • Lesson 4: Move, copy and work with databases
  • Lab: Working with databases

Module 4: Database maintenance

  • Lesson 1: Database integrity and data repair
  • Lesson 2: Maintaining indexes, statistics and tables
  • Lesson 3: Automate tasks
  • Lab: Database maintenance

Module 5: SQL Server Security

  • Lesson 1: Authentication
  • Lesson 2: Authorization, logins, users
  • Lesson 3: Contained Databases
  • Lab: SQL Server security

Module 6: Server and database roles

  • Lesson 1: Working with server roles
  • Lesson 2: Working with database roles
  • Lab: Server and database roles

Module 7: Permissions and Access

  • Lesson 1: Object permissions
  • Lesson 2: Code permissions
  • Lesson 3: Rights and approaches at each level
  • Lab: Permissions and Access

Module 8: Data security using data encryption, classification and audit

  • Lesson 1: SQL Server audit, data classification
  • Lesson 2: Implementing SQL Server audit
  • Lesson 3: Encrypt and mask data
  • Lab: Audit, encryption and classification of data

Module 9: Data backup

  • Lesson 1: Backup data, log, backup strategy and settings
  • Lesson 2: Backup management
  • Lesson 3: Advanced backup options
  • Lab: Data backup

Module 10: Restore data

  • Lesson 1: Recovery process
  • Lesson 2: Data recovery
  • Lesson 3: Advanced Data Recovery and ADR
  • Lesson 4: Point-in-time recovery
  • Lab: Restore data

Module 11: SQL Server Agent

  • Lesson 1: Working with SQL Server Agent
  • Lesson 2: Automate tasks
  • Lesson 3: Tasks, alerts, notifications, Database Mail
  • Lesson 4: Multi-Server Management
  • Lab: SQL Server Agent

Module 12: Tracing and monitoring SQL Server

  • Lesson 1: Trace tools
  • Lesson 2: Extended Events
  • Lesson 3: Monitoring tools
  • Lab: Tracing and monitoring SQL Server

Module 13: Troubleshooting SQL Server

  • Lesson 1: Methodology
  • Lesson 2: Service and setup issues
  • Lesson 3: Connectivity problems and approaches
  • Lesson 4: Permissions and performance issues
  • Lab: Troubleshooting SQL Server

Module 14: Import and export of data

  • Lesson 1: Data transfers and tools
  • Lesson 2: Guides, utilities, transfer services
  • Lesson 3: Bcp, BULK INSERT and OPEN functions
  • Lesson 4: Data-Tier Applications, Integration Services
  • Lab: Import and export of data

Students will be able to

  • Prepare, install, and configure the database server.
  • Create, manage and maintain databases and database files.
  • Work with SQL Server security models, roles, logins, users, permissions and contained databases.
  • Use SQL Server audit and use data encryption.
  • Backup and restore SQL Server databases.
  • Import and export data using wizards, bulk copy utilities, SSIS and data-tier applications.
  • Use the SQL Server Agent service.
  • Monitor and trace SQL Server.
  • Perform troubleshooting.

Course requirements

  • Basic knowledge of the Microsoft Windows operating system and its core functionality
  • Working knowledge of Transact-SQL and relational databases

Hardware

Classrooms are equipped with high-performance computers with Internet access and the possibility of wireless connection.

Literature

All participants will get internal OKsystem materials.

PDF to download

Prices do not include VAT. OKsystem a.s. reserves the right to change dates and prices of courses.

Similar courses

Take a look at some similar courses from our wide range.

Subsidized course „Jsem v kurzu“

Fundamentals of SQL Language for Users SQL-Jazyk 0


11 800 CZK Course detail
Subsidized course „Jsem v kurzu“

Writing Queries Using SQL SQL-Jazyk 1


17 700 CZK Course detail
Subsidized course „Jsem v kurzu“

Performance Tuning and Optimizing SQL Databases DB-TUNING


22 000 CZK Course detail

Need some advice?

Do not hesitate to contact us. We are at your disposal and will be happy to help you.

Mgr. Barbora Záhlavová

Mgr. Barbora Záhlavová

More information about courses


+420 734 525 195
zahlavova@oksystem.cz

Ing. Lumír Vojtěchovský

Ing. Lumír Vojtěchovský

More information about courses


+420 724 332 135
vojtechovsky@oksystem.cz

Why OKškolení?

What are the main advantages of our training centre?

About us

Contact us

Do not hesitate to contact us with any questions you may have.

Simona Dianová

Simona Dianová

Training and test organization


+420 236 072 251
dianova@oksystem.cz

Ing. Dana Černá

Ing. Dana Černá

Certification tests


+420 236 072 318
cernad@oksystem.cz

Do you need to know more about us or would you prefer to contact us using the form?

Contact page

OKškolení is part of OKsystem a.s.