Microsoft SQL Server

Introduction to databases and creating T-SQL queries in Microsoft SQL Server

GOC276 | Duration 5 days | 8 terms

Kurz poskytuje účastníkům ucelený úvod do relačních databází na platformě Microsoft SQL Server. V úvodu se seznámíte se základními koncepty relačních databází. Následuje představení Microsoft SQL Serveru, na který se naučíte připojit [...]

Basics of Writing Queries in T-SQL Language on Microsoft SQL Server Platform

GOC277 | Duration 3 days | 10 terms

Introductory course provides students with all necesary technical skill to write T/SQL queries for Microsoft SQL Server. Targeted platform is broad range actually supported Microsoft SQL Servers. The course is intednded for junior [...]

Creation of advances T-SQL queries in Microsoft SQL Server

GOC278 | Duration 4 days | 10 terms

Kurz je určen pro databázové vývojáře, pokročilé uživatele, tvůrce reportů a administrátory, kteří mají základní znalosti jazyka T-SQL a chtějí se naučit pokročilé jazykové konstrukce pro efektivní dotazování a zpracování dat s [...]

Complete Administration of Microsoft SQL Server

GOC6345 | Duration 5 days | 11 terms

Kurz poskytuje účastníkům jedinečný kompletní přehled administrace celého Microsoft SQL Serveru. V úvodu se seznámíte s architekturou a komponentami Microsoft SQL Serveru a procesem instalace a upgradu Microsoft SQL Serveru na [...]

Microsoft Azure - implementing SQL Server relational databases

GOC212 | Duration 4 days | 5 terms

The three-days instructor-led course introduces IT PRO system and database administrators to the cloud environment of Aure SQL Server and compares its options with SQL Server hosted in Azure Virtual Machines.

Administering Microsoft Azure SQL Solutions

MOC DP-300 | Duration 4 days | 4 terms

In this course, you will learn how to administer Microsoft SQL Server databases in the Microsoft Azure cloud on your own infrastructure or in a hybrid environment. It will explain how to run SQL Server both within Azure Virtual [...]

Designing Relational Databases

NRD | Duration 2 days | 5 terms

Students design optimal structure of relational database, find out right number of entities, relations and atributes, they also define constraints (primary keys, foreign keys, unique, check, not null).

Programování databází v Microsoft SQL Serveru a Azure SQL Database

GOC632 | Duration 5 days | 5 terms

The course is designed for developers who want to learn in detail about the possibilities of database programming in Microsoft SQL Server, from creating a database, proper table design to the creation of very advanced objects and [...]

Non-Relational Data Types in Microsoft SQL Server

GOC628 | Duration 3 days | 4 terms

Přesto, že Microsoft SQL Server je relační databázový server, umožňuje nám ukládat a zpracovávat i data v oblíbených nerelačních formátech, kterými jsou: XML a JSON dokumenty, geografická a geometrická data, hierarchie, celé soubory [...]

News in Micrsoft SQL server 2016/2017 for Business Intelingence specialists

GOC629 | Duration 2 days | No scheduled terms

Kurz je určen pro Business Intelligence (BI) specialisty, kteří se chtějí seznámit s novinkami v SQL Server Integration Services, SQL Server Analysis Services a SQL Server Reporting Services, které přináší SQL Server 2016 a 2017. [...]

Monitoring and Performance Tuning T-SQL Queries

GOC631 | Duration 5 days | 8 terms

The primary audience for this course is individuals who develop and optimize SQL Server database solution and queries.

Microsoft SQL Server Monitoring and Performance Tuning

GOC630 | Duration 4 days | 9 terms

The course is designed for database professionals who have experience with the management or development of a database system and want to be able to effectively monitor and tune the performance of the database system.

Implementation of a data warehouse and ETL processes using Microsoft SQL Server Integration Services.

GOC645 | Duration 5 days | 4 terms

The course is designed for creators of data warehouses and ETL processes over Microsoft SQL Server, who want to learn to create data warehouses and ETL processes, which will load data from various data sources, transform them and [...]

Microsoft SQL Server Analysis Services Multidimensional

GOC6411 | Duration 2 days | 3 terms

This course is intended for anyone who wants to perform professional data analysis using SQL Server Analysis Services (SSAS) in multidimensional mode. Participants will learn how to use appropriate data sources, create cubes, [...]

Microsoft SQL Server Analysis Services Tabular

GOC6412 | Duration 2 days | 5 terms

This course is intended for anyone who wants to professionally analyze data using SQL Server Analysis Services (SSAS) in tabular mode and learn the basics of the DAX language. Participants will learn how to create their own tabular [...]

DAX language and data model creation for Power BI and SQL Server Analysis Services

GOC644 | Duration 2 days | 5 terms

As part of this training, you will become familiar with the DAX language in the context of Power BI Desktop and SQL Server Analysis Services Tabular. With knowledge of DAX, you will learn to fully leverage the capabilities of data [...]

Paginated Reports in Microsoft SQL Server Reporting Services and Microsoft Power BI

GOC640 | Duration 3 days | 5 terms

In this course, students will learn how to deploy and use Reporting Services in native mode, create reports, using the tools of their development and manage the entire solution. Students will learn the practical steps creation of [...]

Microsoft SQL Server – High Availability and replication

GOC638 | Duration 3 days | 4 terms

A high-availability solution masks the effects of a hardware or software failure and maintains the availability of applications so that the perceived downtime for users is minimized. On this course, students acquire knowledge that is [...]

Microsoft SQL Server

Top courses

GOPAS Praha

GOPAS Brno

GOPAS Bratislava

Business details