This course will expose the beginning z/OS DBAs (Database Administrators) to fundamentals of Database Administration for a Db2 13 for z/OS. This course will teach the students how to physically implement a logical database design using DDL, and teaches considerations of referentially related tables. This course discusses the use of basic utilities, program preparation, serialization, and basic database security. This course does not cover distributed data processing, nor does it cover data sharing.
Learn about the new features and enhancements of Db2 for z/OS (v13), including the technical detail of the functional enhancements of this significant new version of Db2 for z/OS.
Db2 12 for z/OS DBAs can develop fundamental skills or recognition through lectures and hands-on exercises of: TSO/E and ISPFData setsDb2 ObjectsStructured Query LanguageDb2 CommandsJCL and SDSFDb2 UtilitiesDb2 LoggingDb2 Program PreparationThe course materials cover Db2 12 for z/OS.
This course is designed to teach students about a key availability and capacity enhancement to Information Management System (IMS) - the Shared Queues facility, which offers the ability to share full function message queues within a parallel sysplex environment. Also, learn about sharing Fast Path Expedited Message Handler (EMH) queues within a parallel sysplex environment.
Learn about Information Management System (IMS) data sharing capabilities. Examine how multiple IMS systems on different processors can access and update the same databases with complete integrity.
Database Control (DBCTL) is an Information Management System (IMS) facility that provides CICS access to an IMS database subsystem. DBCTL provides access for CICS transactions to IMS managed databases. Get a detailed description of the activities required to install, tailor, maintain, and support an IMS DBCTL system. Additionally, learn about aspects of the IMS architecture that apply to database management and attaching to CICS systems and transactions.
This course teaches how to make use of advanced SQL techniques. This course utilizes IBM Data Studio on a Windows 11 operating system, but the SQL queries are appropriate for Linux, UNIX, and Windows environments. Along with a review of some basic relational database concepts, this course covers some of the OLAP features of Db2, including GROUP and RANK functions. Learners will explore coding joins, using the CASE expressions, the CAST function, and code advance SQL constructs, such as recursive SQL and table expressions.Learners will also participate in hands-on exercises to practice writing complex queries and subqueries.
This course provides an introduction to the SQL language. This course utilizes IBM Data Studio on a Windows 11 operating system, but the SQL queries are appropriate for Linux, UNIX, and Windows environments. This course introduces SQL, including syntax, retrieving data from a Db2 table, coding inner joins, arithmetic operations, and scalar and columnar functions. Learners will also explore the UNION function, inserting, updating, and deleting rows, and will use the create table and create view statements.Students will participate in hands-on exercises to practice what they have learned.
This course provides you with information about the functions of IBM's Db2, a relational database manager which may be installed under a variety of operating systems on many hardware platforms. Db2 runs under a number of operating systems, such as z/OS, VM, Linux, UNIX, and Windows operating systems. The course includes discussion of how the Db2 products provide services. The focus is on the services Db2 provides and how users work with Db2, not on its internal workings. This course does not include hands-on labs.
Learn how to detect insider threats triggered by anomalous or malicious user behavior. Get ready to install, configure, and tune IBM Security® QRadar UBA and the Machine Learning app. Improve your skill to investigate user behavior with UBA and expand your threat detection capabilities across your network with the QRadar® Advisor with Watson™ app.
Gain knowledge on how to integrate IBM Security® QRadar® EDR and SIEM by creating an API application in QRadar EDR and by adding a new log source in QRadar SIEM to add endpoint detection and alerts to QRadar SIEM. Having advanced and automated response capabilities enables analysts to focus on the fight in front of them. This course applies to version 3.12 of the on-premises QRadar EDR offering.
In this course you learn how to integrate QRadar EDR and SIEM by creating an API application in QRadar EDR and by adding a new log source in QRadar SIEM to add endpoint detection and alerts to QRadar SIEM. Integrating QRadar EDR and SIEM amplifies the power of QRadar XDR (extended detection and response) by leveraging AI and automation opportunities. Having advanced and automated response capabilities enables analysts to focus on the fight in front of them.This course applies to version 3.12 of the on-premises IBM Security QRadar EDR offering.
When deploying IBM Security® QRadar® EDR into production, you must configure important details, such as notifications, alerts, and policies. After QRadar EDR is deployed successfully, you must set up your users, groups, and clients, configure your Hive-Cloud score, and define how to handle downloaded and quarantined files from endpoints. Another important maintenance task revolves around monitoring audit logs. This course applies to version 3.12 of the on-premises QRadar EDR offering as well as the January 2024 SaaS-based offering.
In this course, you gain hands-on experience with the IBM Security® QRadar® EDR user interface with a focus on threat hunting, learn how to investigate threats on your endpoints, and manage your endpoints to stay secured and up-to-date. You also observe a detailed demonstration about how to detect malware attacks, and how to remediate these threats.This course applies to version 3.12 of the on-premises QRadar EDR offering as well as the January 2024 SaaS-based offering.
In this course, you learn about the IBM Security® QRadar® EDR architecture and how to position the product within your company’s landscape of security solutions. You gain skills around how to install the QRadar EDR Hive on your premises and the EDR Agents on your endpoints. You can review the user interface and how to navigate the EDR Dashboard while investigating endpoint threats.This course applies to version 3.12 of the on-premises QRadar EDR offering.
Are you ready to explain how QRadar processes data in your organization's environment?Interpret QRadar log sources (events) and network activity (flows) so you can investigate security incidents with ease. Knowing how to search the data from QRadar events, flows, and assets means you can streamline your analysis.
This course is designed and built on IBM Security® QRadar® 7.4.3. and QRadar 7.5.0. The lab is built on QRadar 7.5.0 update 8. What you learn:Create custom log sourcesWork with reference data collections and custom rulesUse X-Force data and Threat Intelligence appUse the Use Case Manager appUse User Behavior Analytics (UBA) and QRadar AdvisorDiscover and perform tuningExplore custom action scriptsIntegrate QRadar with IBM SOAR Skills you gain:Threat investigationQRadar data searchingQRadar X-Force integrationQRadar incident response
QRadar SIEM provides deep visibility into network, user, and application activity. It provides collection, normalization, correlation, and secure storage of events, flows, assets, and vulnerabilities. Suspected attacks and policy breaches are highlighted as offenses. This 2-day instructor-led course walks you through various advanced topics about QRadar such as custom log sources, reference data collections and custom rules, X-Force data and the Threat Intelligence app, UBA and QRadar Advisor, tuning and custom action scripts. The course also discusses integration with IBM SOAR. Hands-on exercises reinforce the skills learned. The lab environment for this course uses the IBM QRadar SIEM 7.5 platform.
This course is designed and built on QRadar 7.4.3 and QRadar 7.5.0. The lab is based on QRadar 7.5.0 update 8. What you learn:Describe how QRadar collects data to detect suspicious activitiesDescribe the QRadar architecture and data flowsNavigate the user interfaceDefine log sources, protocols, and event detailsDiscover how QRadar collects and analyzes network flow informationDescribe the QRadar Custom Rule EngineUtilize the Use Case Manager appDiscover and manage asset informationLearn about a variety of QRadar apps, content extensions, and the App FrameworkAnalyze offenses by using the QRadar UI and the Analyst Workflow appSearch, filter, group, and analyze security dataUse AQL for advanced searchesUse QRadar to create customized reportsExplore aggregated data managementDefine sophisticated reporting using Pulse DashboardsDiscover QRadar administrative tasks Skills you gain:Threat investigationQRadar data searching
IBM Security QRadar enables deep visibility into network, endpoint, user, and application activity. It provides collection, normalization, correlation, and secure storage of events, flows, assets, and vulnerabilities. Suspected attacks and policy breaches are highlighted as offenses. In this course, you learn about the solution architecture, how to navigate the user interface, and how to investigate offenses. You search and analyze the information from which QRadar concluded a suspicious activity. Hands-on exercises reinforce the skills learned. In this 3-day instructor-led course, you learn how to perform the following tasks:Describe how QRadar collects data to detect suspicious activitiesDescribe the QRadar architecture and data flowsNavigate the user interfaceDefine log sources, protocols, and event detailsDiscover how QRadar collects and analyzes network flow informationDescribe the QRadar Custom Rule EngineUtilize the Use Case Manager appDiscover and manage asset informationLearn about a variety of QRadar apps, content extensions, and the App FrameworkAnalyze offenses by using the QRadar UI and the Analyst Workflow appSearch, filter, group, and analyze security dataUse AQL for advanced searchesUse QRadar to create customized reportsExplore aggregated data managementDefine sophisticated reporting using Pulse DashboardsDiscover QRadar administrative tasksExtensive lab exercises are provided to allow learners an insight into the routine work of an IT Security Analyst operating the QRadar SIEM platform. The exercises cover the following topics:Architecture exercisesUI Overview exercisesLog Sources exercisesFlows and QRadar Network Insights exercisesCustom Rule Engine (CRE) exercisesUse Case Manager app exercisesAssets exercisesApp Framework exercisesWorking with Offenses exercises.Search, filtering, and AQL exercisesReporting and Dashboards exercisesQRadar Admin tasks exercisesThe lab environment for this course uses the IBM QRadar SIEM 7.5 platform.