IBM SPSS Schulungen finden - Das passende Seminar in Ihrer Nähe

Sie haben eine Einführung in das Thema Data Science, Data Analytics erhalten und können mit KNIME Daten extrahieren, transformieren, laden und visualisieren. Sie erhalten einen Data Science - Überblick und kennen wesentliche Konzepte und Begriffe rund um das Thema Data Science und Co.

Sie haben eine Einführung in das Thema Data Science, Data Analytics erhalten und können mit KNIME Daten extrahieren, transformieren, laden und visualisieren. Sie erhalten einen Data Science - Überblick und kennen wesentliche Konzepte und Begriffe rund um das Thema Data Science und Co.

Overview

This course equips experienced database administrators with the skills needed to analyze, tune, and optimize the performance of IBM Db2 12 for Linux, UNIX, and Windows. 

Participants will learn how to interpret and influence the Db2 query optimization process using statistical metadata, develop efficient indexing strategies for high-performance workloads, and apply advanced tools such as EXPLAIN, db2pd, and the Db2 Data Management Console to evaluate and refine SQL access paths. 

The course also introduces the Db2 AI Optimizer and automation techniques that simplify statistics collection and performance diagnostics. Emphasis is placed on real-world use cases, practical monitoring methods, and proactive tuning practices to ensure scalable and efficient database operations in enterprise environments.

The goal of the 3-day training course in Data Science and Data Analytics  with KNIME is to equip participants with the knowledge and skills  needed to effectively use KNIME for data preparation, visualization,  modeling, and reporting. By the end of the course, participants should  be able to design and implement data workflows using KNIME, apply  machine learning techniques to solve analytical problems, and automate  and deploy workflows using KNIME Server. The course aims to provide a  comprehensive understanding of the concepts, techniques, and tools used  in Data Science and Data Analytics using KNIME.

The goal of the 3-day training course in Data Science and Data Analytics  with KNIME is to equip participants with the knowledge and skills  needed to effectively use KNIME for data preparation, visualization,  modeling, and reporting. By the end of the course, participants should  be able to design and implement data workflows using KNIME, apply  machine learning techniques to solve analytical problems, and automate  and deploy workflows using KNIME Server. The course aims to provide a  comprehensive understanding of the concepts, techniques, and tools used  in Data Science and Data Analytics using KNIME.

Overview

This course provides relational DBAs with essential and advanced skills to manage, secure, recover, and optimize IBM Db2 v12.1 environments. Beginning with foundational concepts, participants will learn how to install Db2, configure instances, manage storage, and create database objects using both command-line and GUI tools. The course then expands into practical techniques for data movement, backup and recovery, and high availability configurations, equipping learners to maintain data integrity and ensure business continuity.

Security and concurrency are addressed in depth, including the implementation of user access controls, role-based permissions, encryption methods, Row and Column Access Control (RCAC), Label-Based Access Control (LBAC), and Trusted Contexts for multi-tiered architectures. Participants will also explore Db2’s locking mechanisms and isolation levels to troubleshoot contention issues and manage concurrent workloads effectively.

Performance tuning and optimization are emphasized through detailed instruction on the query optimizer, indexing strategies, monitoring tools, and the use of EXPLAIN utilities. Learners will leverage the Db2 AI Optimizer, Design Advisor, and Data Management Console to analyze SQL access plans and improve system responsiveness across transactional and analytical workloads.

Through hands-on lab exercises and real-world scenarios, learners will gain the proficiency to manage Db2 en...

Overview

This course introduces the student to advanced database administration skills, including program preparation and the use of packages, online schema changes, partition management, and stored procedures as well as performance and availability features of utilities (including LOAD, REBUILD INDEX, REORG, and UNLOAD). This course does not cover distributed data processing, nor does it cover data sharing.

Overview

This course introduces the student to advanced database administration skills, including program preparation and the use of packages, online schema changes, partition management, and stored procedures as well as performance and availability features of utilities (including LOAD, REBUILD INDEX, REORG, and UNLOAD). This course does not cover distributed data processing, nor does it cover data sharing.

CCSE Check Point Certified Security Expert

Overview

This course covers fundemental and advanced SQL techniques for efficient data management, optimization, and analytics in Db2 12. Participants will learn how to navigate the Db2 system catalog and explore query performance optimization techniques, including indexing strategies, predicate pushdown, and query access plans to improve efficiency.

The course also introduces advanced SQL functions, such as LISTAGG, PERCENTILE_CONT, and PERCENTILE_DISC. Participants will learn how to create and manage database objects and gain expertise in utilizing advanced join techniques such as inner and outer joins, hash joins, lateral joins, and set operators like UNION, INTERSECT, and EXCEPT to merge and analyze data from multiple tables.

The course also covers the use of subqueries and query optimization techniques, including correlated subqueries, EXISTS/NOT EXISTS, and quantified predicates to enhance data retrieval efficiency. 

Through hands-on exercises and real-world scenarios, they will develop the skills necessary to handle large datasets efficiently and implement best practices for high-performance database management.