25 Application Performance Monitoring (APM) courses

Duration 5 Days 30 CPD hours This course is intended for Application DevelopersBusiness AnalystsBusiness Intelligence DeveloperData ModelersData Warehouse AdministratorData Warehouse AnalystReports DeveloperTechnical Consultant Overview Build and run analyses to test and validate a repositorySet up query logging for testing and debuggingSet up a multiuser development environmentUse the Administration Tool wizards and utilities to manage, maintain, and enhance repositoriesEnable usage tracking to track queries and database usage, and improve query performancePerform a patch merge in a development-to-production scenarioDescribe Exalytics machine and the Summary Advisor tool used in the machineBuild simple and calculated measures for a fact tableCreate logical dimension hierarchies and level-based measuresCheck the model and then model aggregate tables to speed query processingModel partitions and fragments to improve application performance and usabilityUse variables to streamline administrative tasks and modify metadata content dynamicallyUse time series functions to support historical time comparison analysesSet up security to authenticate users and assign appropriate permissions and privilegesBuild the Physical, Business Model and Mapping, and Presentation layers of a repositoryApply cache management techniques to maintain and enhance query performance This Oracle BI 11g R1: Build Repositories training is based on OBI EE release 11.1.1.7. Expert Oracle University instructors will teach you step-by-step procedures for building and verifying the three layers of an Oracle BI repository. This Oracle BI 11g R1: Build Repositories training is based on OBI EE release 11.1.1.7. Expert Oracle University instructors will teach you step-by-step procedures for building and verifying the three layers of an Oracle BI repository. ADDITIONAL COURSE DETAILS: Nexus Humans Oracle BI 11g R1 - Build Repositories training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Oracle BI 11g R1 - Build Repositories course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 3 Days 18 CPD hours This course is intended for This intermediate course is for application programmers who need to write embedded SQL COBOL or PL/I programs in either a DB2 9 or DB2 10 for z/OS environment. Overview Incorporate static SQL statements in an application program Prepare the program for execution Validate execution results are correct Produce code to support multiple rows being returned from the database manager using cursors Identify considerations regarding units of work, concurrency, and restart of programs Identify differences between static and dynamic SQL Provide test data for applications Discuss program and DB2 options relative to performance of static SQL This course enables you to acquire the skills necessary to produce application programs that manipulate DB2 databases. Emphasis is on embedding Structured Query Language (SQL) statements and preparing programs for execution. CV720G;CF82G;DB2 CONCEPTS * Identify DB2 family products * Explain DB2 workstation component functions * Identify DB2 objects * Identify the key differences between static SQL and other application alternatives for accessing DB2 data PROGRAM STRUCTURE I * Embed INSERT, UPDATE, DELETE and single-row SELECT statements in application programs * Effectively communicate with DB2 when processing NULL values and determining success of statement execution * Demonstrate use of DB2 coding aids * Code CONNECT statements within an application program * Identify connection types and impacts on a unit of work * Program for the Call Attach Facility (CAF) PROGRAM PREPARATION * Identify the additional steps necessary to prepare a program that contains embedded SQL for execution * Describe the functions of the DB2 PRECOMPILE and BIND processes * Describe factors relevant to the BIND process, including RUNSTATS positioning, package status, parameters, and authorization requirements * PROGRAM STRUCTURE II * Use DECLARE, OPEN, FETCH, and CLOSE CURSOR statements to handle select criteria that may return multiple rows in application programs * Issue positioned UPDATE and DELETE statements * Identify how scrollable cursors can be used RECOVERY AND LOCKING CONCEPTS * Define a unit of recovery * Identify the basic locking strategies used by DB2 DYNAMIC SQL INTRODUCTION * Describe the difference between static and dynamic SQL * List the types of dynamic statements * Code dynamic SQL in a program MANAGING TEST DATA * Identify methods to insert data into a table * Use the LOAD or IMPORT utility * Identify the purpose of the RUNSTATS utility * Identify the purpose of the REORG utility PERFORMANCE CONSIDERATIONS * Use programming techniques that enhance DB2 application performance by following general guidelines, using indexable predicates, and avoiding unnecessary sorts * Identify the access paths available to DB2 * List common causes of deadlocks and avoid such causes when possible * Use the EXPLAIN tools as aids to develop applications that emphasize performance ADDITIONAL COURSE DETAILS: Nexus Humans CV722 IBM DB2 11 for z/OS Application Programming Workshop training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the CV722 IBM DB2 11 for z/OS Application Programming Workshop course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 3 Days 18 CPD hours This course is intended for Application developers who want to build cloud-native applications or redesign existing applications that will run on Google Cloud Platform Overview This course teaches participants the following skills: Use best practices for application development. Choose the appropriate data storage option for application data. Implement federated identity management. Develop loosely coupled application components or microservices. Integrate application components and data sources. Debug, trace, and monitor applications. Perform repeatable deployments with containers and deployment services. Choose the appropriate application runtime environment; use Google Container Engine as a runtime environment and later switch to a no-ops solution with Google App Engine flexible environment. Learn how to design, develop, and deploy applications that seamlessly integrate components from the Google Cloud ecosystem. This course uses lectures, demos, and hands-on labs to show you how to use Google Cloud services and pre-trained machine learning APIs to build secure, scalable, and intelligent cloud-native applications. BEST PRACTICES FOR APPLICATION DEVELOPMENT * Code and environment management. * Design and development of secure, scalable, reliable, loosely coupled application components and microservices. * Continuous integration and delivery. * Re-architecting applications for the cloud. GOOGLE CLOUD CLIENT LIBRARIES, GOOGLE CLOUD SDK, AND GOOGLE FIREBASE SDK * How to set up and use Google Cloud Client Libraries, Google Cloud SDK, and Google Firebase SDK. * Lab: Set up Google Client Libraries, Cloud SDK, and Firebase SDK on a Linux instance and set up application credentials. OVERVIEW OF DATA STORAGE OPTIONS * Overview of options to store application data. * Use cases for Google Cloud Storage, Cloud Firestore, Cloud Bigtable, Google Cloud SQL, and Cloud Spanner. BEST PRACTICES FOR USING CLOUD FIRESTORE * Best practices related to using Cloud Firestore in Datastore mode for:Queries, Built-in and composite indexes, Inserting and deleting data (batch operations),Transactions,Error handling. * Bulk-loading data into Cloud Firestore by using Google Cloud Dataflow. * Lab: Store application data in Cloud Datastore. PERFORMING OPERATIONS ON CLOUD STORAGE * Operations that can be performed on buckets and objects. * Consistency model. * Error handling. BEST PRACTICES FOR USING CLOUD STORAGE * Naming buckets for static websites and other uses. * Naming objects (from an access distribution perspective). * Performance considerations. * Setting up and debugging a CORS configuration on a bucket. * Lab: Store files in Cloud Storage. HANDLING AUTHENTICATION AND AUTHORIZATION * Cloud Identity and Access Management (IAM) roles and service accounts. * User authentication by using Firebase Authentication. * User authentication and authorization by using Cloud Identity-Aware Proxy. * Lab: Authenticate users by using Firebase Authentication. USING PUB/SUB TO INTEGRATE COMPONENTS OF YOUR APPLICATION * Topics, publishers, and subscribers. * Pull and push subscriptions. * Use cases for Cloud Pub/Sub. * Lab: Develop a backend service to process messages in a message queue. ADDING INTELLIGENCE TO YOUR APPLICATION * Overview of pre-trained machine learning APIs such as Cloud Vision API and Cloud Natural Language Processing API. USING CLOUD FUNCTIONS FOR EVENT-DRIVEN PROCESSING * Key concepts such as triggers, background functions, HTTP functions. * Use cases. * Developing and deploying functions. * Logging, error reporting, and monitoring. MANAGING APIS WITH CLOUD ENDPOINTS * Open API deployment configuration. * Lab: Deploy an API for your application. DEPLOYING APPLICATIONS * Creating and storing container images. * Repeatable deployments with deployment configuration and templates. * Lab: Use Deployment Manager to deploy a web application into Google App Engine flexible environment test and production environments. EXECUTION ENVIRONMENTS FOR YOUR APPLICATION * Considerations for choosing an execution environment for your application or service:Google Compute Engine (GCE),Google Kubernetes Engine (GKE), App Engine flexible environment, Cloud Functions, Cloud Dataflow, Cloud Run. * Lab: Deploying your application on App Engine flexible environment. DEBUGGING, MONITORING, AND TUNING PERFORMANCE * Application Performance Management Tools. * Stackdriver Debugger. * Stackdriver Error Reporting. * Lab: Debugging an application error by using Stackdriver Debugger and Error Reporting. * Stackdriver Logging. * Key concepts related to Stackdriver Trace and Stackdriver Monitoring. * Lab: Use Stackdriver Monitoring and Stackdriver Trace to trace a request across services, observe, and optimize performance.

Duration 3 Days 18 CPD hours This course is intended for The ideal audience for this course includes database enthusiasts, IT professionals, and developers who are eager to expand their knowledge and skill set in database management and optimization. Roles that would greatly benefit from attending this course include: Database Developers: Those who design, implement, and maintain databases as part of their primary responsibilities and want to improve their expertise in schema design, query optimization, and advanced database features. Backend Developers: Professionals who work on server-side application logic and require a strong understanding of database management to integrate data storage and retrieval processes into their applications. Overview Upon completing this course, database developers will be able to: Design and implement efficient database schemas by employing normalization techniques, appropriate indexing strategies, and partitioning methods to optimize data storage and retrieval processes. Develop advanced SQL queries, including joining multiple tables, utilizing subqueries, and aggregating data, to extract valuable insights and facilitate decision-making processes. Implement stored procedures, functions, and triggers to automate common database tasks, enforce data integrity, and improve overall application performance. Apply database performance tuning techniques, such as query optimization, index management, and transaction control, to ensure optimal resource usage and enhanced system responsiveness. Integrate databases with various programming languages and platforms, enabling seamless data access and manipulation for web, mobile, and desktop applications. PostgreSQL is a powerful, open-source object-relational database management system that emphasizes extensibility, data integrity, and high performance. Its versatility and robust feature set make it an ideal choice for developers working on projects of all sizes, from small-scale applications to enterprise-level systems. By learning PostgreSQL, developers can tap into its advanced capabilities, such as full-text search, spatial data support, and customizable data types, allowing them to create efficient and scalable solutions tailored to their unique needs. PostgreSQL for Database Developers is a three-day hands-on course that explores the fundamentals of database management, covering everything from installation and management to advanced SQL functions. Designed for beginners and enthusiasts alike, this course will equip you with the knowledge and skills required to effectively harness the power of PostgreSQL in today's data-driven landscape. Throughout the course you?ll be immersed in a variety of essential topics, such as understanding data types, creating and managing indexes, working with array values, and optimizing queries for improved performance. You?ll gain valuable hands-on experience with real-world exercises, including the use of the psql client, writing triggers and stored procedures with PL/pgSQL, and exploring advanced SQL functions like Common Table Expressions (CTE), Window Functions, and Recursive Queries. You?ll exit this course with a solid foundation in PostgreSQL, enabling you to confidently navigate and manage your databases with ease and efficiency. INSTALLING & MANAGING POSTGRESQL * PostgreSQL installation process * Optimal configuration settings * User and role management * Database backup and restoration OVERVIEW OF POSTGRESQL DATABASE * PostgreSQL architecture overview * Understanding database objects * Efficient data storage * Transaction management basics USING THE PSQL CLIENT * Introduction to psql * Essential psql commands * Executing queries effectively * Managing databases with psql UNDERSTANDING POSTGRESQL DATA TYPES * Numeric data types explored * Character and binary types * Date, time, and boolean values * Array and other types UNDERSTANDING SEQUENCES * Sequence creation and usage * Customizing sequence behavior * Implementing auto-increment columns * Sequence manipulation and control CREATING & MANAGING INDEXES * PostgreSQL index fundamentals * Designing partial indexes * Utilizing expression-based indexes * Index management techniques USING COPY TO LOAD DATA * COPY command overview * Importing and exporting data * Handling CSV and binary formats * Performance considerations WORKING WITH ARRAY VALUES * Array value basics * Array manipulation functions * Querying arrays efficiently * Multidimensional array handling ADVANCED SQL FUNCTIONS * Mastering Common Table Expressions * Utilizing Window Functions * Regular Expressions in SQL * Crafting Recursive Queries WRITING TRIGGERS & STORED PROCEDURES WITH PL/PGSQL * PL/pgSQL variables usage * Implementing loop operations * PERFORM and EXECUTE statements * Developing PostgreSQL triggers USING THE POSTGRESQL QUERY OPTIMIZER * Query analysis and optimization * EXPLAIN command insights * PostgreSQL query operators * Identifying performance bottlenecks IMPROVING QUERY PERFORMANCE * Query performance tuning * Index optimization strategies * Efficient database partitioning * Connection and resource management WRAP UP & ADDITIONAL RESOURCES * Further learning opportunities * Staying up-to-date with PostgreSQL * Community engagement and support ADDITIONAL COURSE DETAILS: Nexus Humans PostgreSQL for Database Developers (TTDB7024) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the PostgreSQL for Database Developers (TTDB7024) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 5 Days 30 CPD hours Overview By the end of the course, you should be able to meet the following objectives: List the operational challenges for rolling out and operating telco services including 5G. Identify the role of VMware Telco Cloud products in supporting telco services. Discuss the role of VMware technologies such as vSphere, NSX, and Tanzu etc. in implementing telco services. Outline the role of native tools and other VMware monitoring tools such as vRealize Operations and vRealize Log Insight in maintaining network services. Choose the VMware Telco Cloud products that meet your application requirements. Deploy a solution architecture that meet VMware best practices for delivering services using VMware Telco Cloud products. Implement and maintain VMware Telco Cloud products in a secure manner. Identify the tools and remediation pathways for maintaining the availability and performance of your applications and infrastructure using VMware Telco Cloud and vRealize Suite products. Follow specific steps to resolve application performance and availability problems Scale your VMware Telco Cloud products to meet operational requirements in line with VMware best practices. Optimize the operation of VMware Telco Cloud products to ensure SLAs are met. This five-day, hands-on training course provides the knowledge to operate and scale VMware Telco Cloud version 2.x products in a Telco cloud provider environment. In this course, you are exposed to the entire VMware Telco Cloud portfolio, and the tools and methodologies available to ensure they operate effectively. In addition, you are presented with various scenarios where you will be guided through the process of identifying, analyzing, and formulating solutions to performance and other problems. COURSE INTRODUCTION * Introductions and course logistics * Course objectives OVERVIEW OF NETWORK TRANSFORMATION * Reviews the technologies that enable modern networks * Lists the components of modern service provider networks * Outlines characteristics of modern service provider networks in meeting customer application needs SERVICE DELIVERY WITH VMWARE TELCO CLOUD * Outlines the components of the VMware Telco Cloud portfolio * Reviews the role each VMware Telco Cloud product plays in delivering telco services * Specifies the dependencies each product has on underlying technologies SUPPORTING VMWARE TELCO CLOUD SERVICE DELIVERY * Reviews the products that implements the virtualization, management, platform, and orchestration layers * Outlines the role played by other VMware products such as NSX in delivering cloud services * Outline opensource integration options with VMware Telco Cloud products SECURING VMWARE TELCO CLOUD * Reviews security threats that affect telco services * Identifies the critical telco assets that are prone to attack * Outlines best practice for securing VMware Telco Cloud products and underlying technology * Provides overview of appropriate security controls for VMware Telco Cloud products ASSESSING SERVICE PROVISION * Reviews tools and methodologies used to gather requirements * Outlines how to assess cloud-native capabilities * Documenting findings * Identifying security vulnerabilities with Helm. * Reviews VMware?s Customer Engagement process * Capturing infrastructure requirements from TCA DESIGNING A VMWARE TELCO CLOUD SOLUTION * Selecting appropriate deployment topology * Pros and cons of design choices * How a design choice might be affected by other factors such as NSX and TKG deployment, or data center architecture * Outlines typical scenarios where specific products align with identified requirements * Documenting a design * Designing for availability * Ensuring a design aligns with best practice * Specifying monitoring options IMPLEMENTING VMWARE TELCO CLOUD PRODUCTS * Review deployment options for VMware products * Integrating new products with existing ones * Outline post-installation tasks * Adding the new products as data sources in monitoring tools such as vRealize Operations and vRealize Operations Network Insight * Ensuring products meet security requirements * Configuring monitoring software * Outlines the xNF onboarding process in TCA MAINTAINING TELCO SERVICES * Outlines typical administrative tasks in ensuring services are maintained * Use of native and other VMware performance monitoring tools * Reviewing performance data * Role of SLAs in service maintenance * Reviews scenarios where known behaviors indicate problems TROUBLESHOOTING DEPLOYED TELCO SERVICES * Reviews the troubleshooting tools available * Using tools to gather useful data * Outlines how event correlation can be used to isolate problems * Using a methodology to determine the root cause of a problem * Steps to identify and resolve a problem * Reviews scenarios where known problems are isolated and resolution steps identified SCALING VMWARE TELCO CLOUD PRODUCTS * Assessing if operations are impacted by lack of resources now or will be in the future * Reviews performance optimization options * Identifies implications for other products if you scale VMware Telco Cloud products * Reviews VMware sizing guidelines ADDITIONAL COURSE DETAILS: Notes Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC) Nexus Humans VMware Telco Cloud: Day 2 Operate and Scale [V2.x] training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the VMware Telco Cloud: Day 2 Operate and Scale [V2.x] course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.