Popis Dnes můžete v Excelu postavit business intelligence řešení, které před ani ne 10 lety vyžadovalo servery a vývojáře. Bez kódování můžete mít v Excelu miliony řádků z mnoha heterogenních datových zdrojů, vzájemně provázaných a uspořádaných do smysluplných metrik a řezů. S trochou kódování (co zvládne každý, kdo má rád Excel) již postavíte ř ...

Big Data on AWS introduces you to cloud-based big data solutions such as Amazon Elastic MapReduce (EMR), Amazon Redshift, Amazon Kinesis and the rest of the AWS big data platform. In this course, we show you how to use Amazon EMR to process data using the broad ecosystem of Hadoop tools like Hive and Hue. We also teach you how to create big data environments, work with Amazon DynamoDB, Amazon Redshift, and Amazon Kinesis, and leverage best practices to design big data environments for securi ...

Security Operations on AWS demonstrates how to efficiently use AWS security services to stay secure and compliant in the AWS cloud. The course focuses on the AWS-recommended security best practices that you can implement to enhance the security of your data and systems in the cloud. The course highlights the security features of AWS key services including compute, storage, networking, and database services. This course also refers to the common security control objectives ...

The main purpose of this 3 day instructor led course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals. The course will very likely be well attended by SQL power users who aren’t necessarily database-focused; namely ...

In the Oracle Database 12c: New Features for Administrators Ed2 course, you’ll lea> about the new and enhanced features and options of Oracle Database 12c. Expert instructors will teach you how these features and options increase security, manageability and performance. Audience Administrator Cloud Administrator Database Administrators System Administrator ...

Study points for the exam To help you prepare, review the exam objectives, which highlight the task areas you can expect to see on the exam. Being able to manage Red Hat CloudForms Management Engine (CFME) requires some level of skill with one or more of the underlying cloud and virtualization technologies supported by CFME. In order to provide a defined and manageable scope for the exam, the Red Hat Certificate of Expertise in Hybrid Cloud Management exam is based on Red Hat Enterprise Virtualization Management, one of the several that CFME supports. Therefore, you should also be able to perform these ancillary tasks with Red Hat Enterprise Virtualization Management: Import virtual machine template images into a pre-configured Red Hat Enterprise Virtualization Management environment Import ISO image files and template VM images into Red Hat Enterprise Virtualization Management Create virtual machine images from templates and customize various attributes * Experienced Red Hat CloudForms administrators seeking validation of their skills Students who have attended Red Hat CloudForms Hybrid Cloud Management (CL220) Study points for the exam To help you prepare, review the exam objectives, which highlight the task areas you can expect to see on the exam. Being able to manage Red Hat CloudForms Management Engine (CFME) requires some level of skill with one or more of the underlying cloud and virtualization technologies supported by CFME. In order to provide a defined and manageable scope for the exam, the Red Hat Certificate of Expertise in Hybrid Cloud Management exam is based on Red Hat Enterprise Virtualization Management, one of the several that CFME supports. Therefore, you should also be able to perform these ancillary tasks with Red Hat Enterprise Virtualization Management: Import virtual machine template images into a pre-configured Red Hat Enterprise Virtualization Management environment Import ISO image files and template VM images into Red Hat Enterprise Virtualization Management Create virtual machine images from templates and customize various attributes of the virtual machine You will not be directly evaluated on your ability to perform those ancillary tasks, but the inability to do so will prevent you from being able to perform the actual exam tasks, which include: Perform initial CloudForms management engine configuration via virtual machine console Add Red Hat Enterprise Virtualization as a cloud service provider Configure basic CFME settings Create new CFME roles Add CFME users and groups Create and apply smart tags Configure CFME to be able to provision virtual systems via all supported mechanisms Use CFME to provision virtual systems Configure control policies Configure chargeback reporting Configure reporting Perform drift analyses Configure alerts Configure life cycle management provisioning request default values Save the output from reporting and analyses in an external format that can be parsed by other tools Scores and reporting Official scores for exams come exclusively from Red Hat Certification Central. Red Hat does not authorize examiners or training partners to report results to candidates directly. Scores on the exam are usually reported within 3 U.S. business days. Exam results are reported as section scores. Red Hat does not report performance on individual items, nor will it provide additional information upon request. Recommended course CL220 - Red Hat CloudForms Hybrid Cloud Management ...

Kurz Oracle 12c Security je určen pro správce Oracle databází, kteří dostali za úkol zajistit Server ze všech možných stran tak, aby se k daným datům nedostali neoprávněné osoby. Dozví se také jak zajistit data na více úrovních tak, aby je nepovolané osoby nemohly použít i v případě prolomení některých z ochran. Kurz obsahuje zabezpečení a šifrování na úrovni dat, tabulek, databází a databázových objektů, na úrovni serveru, na úrovni komunikace s aplikacemi. Věnuje se i auditu bezpečnosti, který se dá využít na nepřetržitý monitoring bezpečnosti. ...

Kurz Microsoft SQL Server 2012-2019 - Tento kurz je určen pro pokročilé analytiky a vývojáře, kteří se chtějí seznámit s pokročilejšími možnostmi analýzy dat v SQL Serveru. Zabývá se pokročilými technikami agregace dat, a zejména použitím pokročilých analytických funkcí, s důrazem na nové možnosti efektivní analýzy dat v SQL Serveru. Také pokrývá další funkcionalitu, jako jsou kurzory, CTE, hierarchické dotazy, stored procedury a funkce. Konec kurzu je věnován práci s SQL Server Analysis Services - nástroji na rychlou a flexibilní analýzu velkého objemu dat v reálném čase, a jeho integrace s existujícími aplikacemi. ...

• Duben 2025 Praha,Ostrava



• Květen 2025 Praha,Ostrava



• Březen 2025 Praha,Ostrava

Kurz SQL Server Analysis Services - jazyk MDX seznamuje účastníky se všemi možnostmi jazyka MDX pro dotazování se na OLAP kostky. Účastníci se dozvědí, jak fungují MDX dotazy, jaká je jejich logika, jak se naviguje v N-rozměrném prostoru, a jak na tom celém založit pokročilé analýzy. Projdeme si nejčastěji používané funkce, konstrukty a techniky. Zvláště se budeme věnovat i srovnávací analýze dat v časových obdobích, zda pokročilé agregaci a vylepšování kostek. Na konci kurzu budou účastníci schopni plně využít analytickou sílu OLAP kostek. Výuka bude probíhat na Analysis Services. ...

In the Oracle Database 12c: Performance Management and Tuning course, lea> about the performance analysis and tuning tasks expected of a DBA: proactive management through built-in performance analysis features and tools, diagnosis and tuning of the Oracle Database instance components, and diagnosis and tuning of SQL-related performance issues. In this course, you will be introduced to Oracle Database Cloud Service. Audience Data Warehouse Administrator ...