A selection of learning guides

Beginning Perl Programming

Welcome to Beginning Perl Programming, your comprehensive guide to mastering the basics of Perl. This booklet is designed for beginners who are eager to dive into the world of Perl programming. Whether you are new to programming or looking to expand your skills, this booklet will provide you with the foundational knowledge you need to get started.

This booklet is not only a learning resource but also a handy reference guide that you can return to whenever you need a quick refresher on Perl concepts. With “Beginning Perl Programming,” you’ll be well-equipped to tackle real-world programming challenges and continue your journey towards becoming a proficient Perl programmer.

Beginning Python Programming

This booklet is a resource for anyone looking to embark on their programming journey. This booklet provides a introduction to Python, covering fundamental concepts such as variables, data types, control flow, loops, functions, and data structures. With clear explanations and practical examples, readers will gain an understanding of Python’s syntax and capabilities. Additionally, the booklet explores a few advanced topics like object-oriented programming, file handling, and working with external libraries. By the end of this guide, readers will be equipped with the knowledge and skills to write efficient Python code and tackle real-world programming challenges.

Preventing SQL Injection Attacks

This booklet will cover best practices for preventing SQL Injection attacks, including input validation, parameterized queries, stored procedures, and the principle of least privilege. By following these guidelines, developers can significantly reduce the risk of SQL Injection and ensure the security and integrity of their applications.

Python Examples

This booklet is designed to provide readers with a practical and hands-on approach to learning Python programming through numerous examples and use cases. Whether you are a beginner looking to get started with Python or an experienced developer seeking to enhance your skills, this booklet offers valuable insights and code samples to help you achieve your goals.

SQL Server Programming

This booklet is written to advance your skills with SQL Server programming.  It introduces the reader to advanced JOIN strategies and query design, Dynamic SQL with Safe Parameterization, and performance hardening, among many other topics.

Learning SQL Server

This booklet is written to advance your skills with SQL Server. It introduces you to SQL Server itself, shows some installation and configuration best practices, as well as advanced features like system-versioned temporal tables and dynamic sql.

Introduction to Autosys Job Scheduling System

With its multi-platform support, AutoSys Workload Automation is an automated job control system that excels in scheduling, monitoring, and reporting AutoSys jobs, making it essential for enterprise applications.

Introduction to ActiveBatch Job Scheduling System

ActiveBatch is a comprehensive workload automation and job scheduling solution designed to streamline IT operations and enhance efficiency across various industries. With its intuitive low-code/no-code interface, ActiveBatch empowers users to automate complex workflows without extensive coding knowledge, making it accessible to both technical and non-technical users. The platform offers advanced job scheduling, event-driven automation, and a vast library of pre-built job steps, simplifying the creation and management of automated processes. ActiveBatch's robust integration capabilities support a wide range of applications, databases, and platforms, ensuring seamless end-to-end automation. Additionally, the platform provides real-time monitoring, customizable alerts, and detailed reporting tools, offering complete visibility and control over job statuses and service level agreements (SLAs). Security is a top priority, with features such as multi-factor authentication, granular permissions, and data encryption ensuring the protection of automated processes and data. ActiveBatch also supports high availability configurations, ensuring continuous operation and minimizing downtime. With its user-friendly design, extensive integration options, and powerful automation capabilities, ActiveBatch is an invaluable tool for organizations looking to optimize their IT operations and drive business success.

Oracle ETL Overview

Oracle ETL Processing: A Practical Guide with Real-World Application

This booklet is a comprehensive, hands-on guide to designing, building, and optimizing ETL (Extract, Transform, Load) pipelines using Oracle technologies. Written for data engineers, developers, and architects, it combines technical depth with practical insight—anchored by a real-world case study: the MediSure claims processing pipeline.

Over 14 chapters, the guide walks readers through every stage of the ETL lifecycle—from architectural planning and PL/SQL development to job scheduling, error handling, and cloud migration. Each chapter builds on the last, culminating in a reusable, metadata-driven ETL framework that can be adapted across industries and use cases.

Beginning Java

This book is a comprehensive, hands-on guide to mastering Java programming—from foundational syntax to advanced application development. It is designed for aspiring developers, backend engineers, and software professionals who want to build robust, scalable, and modern Java applications.

Beginning Java

This booklet guides you through integrating Python applications with SQL Server using SQLAlchemy. It starts by setting up your development environment, including Python virtual environments and required drivers. You’ll learn both the Core and ORM layers of SQLAlchemy, from defining tables and executing raw SQL to modeling complex relationships and performing migrations with Alembic.

Each chapter provides concrete, laptop-ready examples tailored for SQL Server, complete with connection strings, code snippets, and step-by-step instructions. By the end, you’ll be equipped to build robust, maintainable data-driven Python applications, optimize performance, and adopt best practices for testing and deployment.

Learning R Programming

"Mastering R: From Fundamentals to Real-World Solutions" is a comprehensive and practical guide designed for developers and data scientists seeking to harness the full power of the R programming language. In today's data-driven world, R stands out as an indispensable tool for statistical computing, data analysis, visualization, and machine learning, lauded for its open-source accessibility, vast ecosystem of packages, and robust capabilities. This book serves as a roadmap for readers to navigate the R landscape, from initial setup to advanced application development.This booklet guides you through integrating Python applications with SQL Server using SQLAlchemy. It starts by setting up your development environment, including Python virtual environments and required drivers. You’ll learn both the Core and ORM layers of SQLAlchemy, from defining tables and executing raw SQL to modeling complex relationships and performing migrations with Alembic.

Learning C# Programming

This booklet aims to provide a comprehensive yet accessible introduction to C# programming for beginners. The focus will be on core concepts, building a strong foundation, and equipping the reader to confidently explore more advanced topics.

Learning APIs and SOAP with Python

Building and Using APIs & SOAP Messages: A Practical Guide is a hands-on, example-driven booklet designed to help software engineers, technical educators, and integration professionals master the art of API development and interoperability. Blending clarity, warmth, and depth, this guide demystifies both modern RESTful services and enterprise-grade SOAP messaging through real-world scenarios, fully functional round-trip code examples, and step-by-step integration workflows.

Introduction to BASH Scripts

In today’s complex IT environments, automation isn’t a luxury—it’s a necessity. From scheduled data pulls to listener health checks, BASH scripting remains a foundational skill for systems engineers, database admins, and developers alike. Yet many resources still treat shell scripting as an isolated skill, disconnected from the real workflows it powers.

This booklet cuts through that limitation. It delivers a practical, example-rich guide to building and deploying BASH scripts that solve actual problems—across database layers, APIs, operating systems, and messaging protocols. Whether you're triggering Oracle sqlplus jobs, parsing HL7 payloads, or recovering from ORA-12541 errors mid-deploy, these scripts demonstrate how BASH becomes the glue in enterprise environments.

Mastering BASH for Development

Mastering BASH for Development is a comprehensive guide designed for developers seeking to enhance their proficiency in Bash scripting. This booklet covers fundamental concepts, advanced techniques, and practical applications, making it an invaluable resource for both beginners and experienced users.

Oracle with Java

This booklet, "Oracle with Java", serves as a comprehensive guide for experienced Java developers seeking to master the art of building scalable, secure, and performant enterprise applications leveraging the powerful synergy of Oracle Database and the Java ecosystem.

In today's rapidly evolving digital landscape, organizations are under constant pressure to deliver robust and efficient applications that can handle ever-increasing data volumes and user demands. Oracle Database, renowned for its reliability, security, and advanced features, provides an ideal backend for enterprise applications. Complementing this, Java stands out with its platform independence, strong performance, extensive ecosystem of libraries and frameworks (such as JDBC, JPA, and Spring Boot), and inherent security capabilities, making it the premier choice for enterprise-level application development.

Oracle Embedded Java

This book serves as an essential resource for developers, database administrators, and technology professionals interested in leveraging the power of Java within Oracle Database environments. With the growing demand for robust and efficient database applications, understanding how to effectively integrate Java stored procedures into Oracle systems is crucial.

Key Objectives

Introduction to Oracle Embedded Java: The book begins with a foundational overview of Oracle Embedded Java, explaining its significance in modern database applications. It covers the benefits of using Java stored procedures, including improved performance, enhanced maintainability, and seamless integration with existing Java applications.