Relational databases

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 | 9 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 | 6 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 | 3 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 | 7 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 | 9 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 | 6 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 | 7 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 | 4 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 | 3 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 | 6 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 [...]

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

GOC277 | Duration 3 days | 10 terms

Creation of advances T-SQL queries in Microsoft SQL Server

GOC278 | Duration 4 days | 9 terms

Microsoft Azure - implementing SQL Server relational databases

GOC212 | Duration 4 days | 6 terms

Data Engineering on Microsoft Azure

MOC DP-203 | Duration 4 days | No scheduled terms

In this course, the student will learn about the data engineering as it pertains to working with batch and real-time analytical solutions using Azure data platform technologies. Students will begin by understanding the core compute [...]

Administering Microsoft Azure SQL Solutions

MOC DP-300 | Duration 4 days | 3 terms

Designing Relational Databases

NRD | Duration 2 days | 7 terms

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

GOC632 | Duration 5 days | 9 terms

Non-Relational Data Types in Microsoft SQL Server

GOC628 | Duration 3 days | 6 terms

Monitoring and Performance Tuning T-SQL Queries

GOC631 | Duration 5 days | 7 terms

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

Azure Data Factory

GOC647 | Duration 3 days | 9 terms

Kurz je určen pro datové inženýry a tvůrce ETL/ELT procesů v cloudovém prostředí Microsoft Azure, kteří se chtějí naučit efektivně implementovat ETL/ELT procesy s využitím služby Azure Data Factory, kterými budou načítat data z [...]

Introduction into Databases and SQL Language in the Oracle

OFUN | Duration 5 days | 10 terms

Kurz poskytuje účastníkům ucelený úvod do relačních databází na platformě databázového systému ORACLE. Stručně se probírají základy návrhu relačních databází, jazyka SQL (neprocedurální jazyk, standard pro komunikaci s relační [...]

Oracle Database: SQL Workshop

ORSQL | Duration 5 days | 6 terms

The course is intended for everyone who needs to know SQL. In addition to an introduction to what SQL is, participants will learn to write SQL queries from simple SELECT for data retrieval, through various conditions of conditions, [...]

Oracle Database: Program with PL/SQL

ORPL | Duration 5 days | 7 terms

Kurz Oracle Database: Programování s PL/SQL začíná úvodem do PL/SQL a následně představuje výhody tohoto mocného programovacího jazyka. Prostřednictvím praktických instrukcí od zkušeného lektora se naučíte vyvíjet uložené procedury, [...]

Oracle Database: Administration Workshop

ORADM1 | Duration 5 days | 6 terms

Oracle Database: Administration Workshop vás naučí kompletně administrovat databázový systém ORACLE od architektury přes vytváření uživatelů a nastavování práv, správu disku a úložných prostor, základy zálohování a obnovy, síťové [...]

Oracle Database: Administration Workshop II - Backup and Recovery

ORADM2 | Duration 5 days | 2 terms

Oracle Database: Workshop Zálohování a obnova vás naučí, jak vytvořit bezpečnou zálohovací strategii vašeho databázového systému, a v případě potřeby, jak úspěšně obnovit databázový systém bez ztráty dat. V kurzu budou probírány [...]

Introduction to SQL in MySQL

GOC660 | Duration 3 days | 7 terms

The course Introduction to SQL in MySQL is designed for anyone who wants to learn techniques for working with data in a MySQL database system. Students will gain a comprehensive overview of SQL syntax and acquire practical skills to [...]

MySQL administration

GOC661 | Duration 5 days | 6 terms

Students will acquire important information about the properties of the database system MySQL and acquire skills of effective management and maintenance. Among the important topics of the course include the setup process in Windows [...]

Advanced SQL in MySQL

GOC663 | Duration 3 days | 9 terms

If you want to expand your knowledge of SQL language, this course is for you. Students will be introduced to advanced techniques using SQL, such as subqueries, regular expressions, advanced functions and complex structure queries to [...]

Optimizing SQL queries in MySQL

GOC664 | Duration 2 days | 6 terms

The course Optimizing SQL queries in MySQL contains all important information and techniques to ensure optimal performance of your queries or used MySQL database system functionality.

Pokročilá administrace MySQL

GOC665 | Duration 2 days | 3 terms

Důležité projekty a aplikace běžně vyžaduji použití technik pro zajištění vysoké dostupnosti, odolnosti proti chybám, distribuci dat nebo zajištěný požadovaného výkonu. Toto jsou pokročilé techniky, se kterými vás na tomto kurzu [...]

PostgreSQL Essentials

PostgreSQL3 | Duration 4 days | 7 terms

Learn the essentials of administering enterprise-scale data solutions using the different tools available in PostgreSQL; providing the skills required to design, implement, and manage PostgreSQL This understanding will prepare you to [...]

Advanced PostgreSQL Administration

PostgreSQL4 | Duration 3 days | 4 terms

Learn how to best fulfill the more advanced DBA responsibilities including database tuning and benchmarking, monitoring, and more. The concepts and architecture that support these more in-depth topics, along with the options [...]

Relational databases

Top courses

GOPAS Praha

GOPAS Brno

GOPAS Bratislava

Business details