SQL Pocket Primer. A Comprehensive Guide to SQL and MySQL for Data Professionals

Mercury Learning and Information, Oswald Campesato

As part of the best-selling Pocket Primer series, this book is designed for data scientists and machine learning engineers seeking to deepen their SQL knowledge using MySQL as the primary RDBMS. It features Python-based code samples for accessing data from MySQL tables in Pandas data frames and Java-based samples for data access in MySQL, along with handling XML and JSON documents.The book also introduces NoSQL, with an overview of MongoDB, and SQLite, an open-source RDBMS for mobile devices. The final section covers diverse topics like normalization, schemas, database optimization, and performance. This comprehensive approach ensures a well-rounded understanding of SQL and related technologies, enhancing data manipulation and database management skills.Numerous code samples and listings throughout the book support the various topics covered. Companion files with source code and figures are available from the publisher, making this an essential resource for advancing your SQL proficiency and database management expertise.

3D Printing. The Complete Guide to Mastering 3D Printing Techniques

Mercury Learning and Information, Stephanie Torta, Jonathan Torta

This book offers a comprehensive introduction to the field of 3D printing, covering its applications in industry, education, and the DIY community. It delves into common 3D printers, materials, and software, guiding you through setting up your own printer and performing essential calibration tasks. Through full-color images, you’ll learn about various printing methods, best practices, and how to finish your projects successfully.The book is divided into three parts: the first part provides a history and evolution of 3D printers, highlighting their industrial and personal use. The second part walks you through setting up a 3D printer, from initial hardware calibration to software functionalities and acquiring 3D objects. You’ll also find step-by-step guides for three different projects.The final part helps you choose the right printer, explains common features, and explores post-market modifications. Understanding 3D printing is crucial as it revolutionizes manufacturing and prototyping processes, enabling creativity and innovation in various fields. This book ensures a smooth journey from a novice to a confident 3D printing enthusiast, equipped with practical skills and knowledge. Companion files with videos, printable objects, and additional lessons enhance your learning experience.

AutoCAD 2025 3D Modeling. Master essential 3D modeling techniques with AutoCAD 2025

Mercury Learning and Information, Munir Hamad

Master the art of 3D modeling with this comprehensive book tailored for AutoCAD 2025. Designed for beginners and experienced users alike, this book begins with an introduction to the AutoCAD 3D environment, providing clear and concise instructions for navigating its interface and essential tools. By building a strong foundation, it sets the stage for more advanced techniques.As the chapters progress, readers are introduced to creating and editing solids, meshes, and surfaces, exploring AutoCAD’s powerful commands and features. Learn how to apply realistic materials, incorporate lighting, and generate stunning 3D renderings to bring your designs to life. The guide also delves into converting and sectioning tools, enabling you to create detailed and precise outputs for professional use.By the end of this book, readers will have acquired a deep understanding of AutoCAD’s 3D capabilities, empowering them to tackle complex design challenges with confidence. Whether you are an architect, engineer, or CAD enthusiast, this guide will equip you with the skills to enhance productivity and deliver outstanding results.

Excel 2021 / Microsoft 365 Programming By Example. A Comprehensive Guide to Mastering Excel VBA

Mercury Learning and Information, Julitta Korol

Updated for Excel 2021, this book is a practical guide for those proficient with the Excel user interface and looking to automate routine tasks. It introduces programming concepts through numerous hands-on exercises, progressing to advanced topics via custom projects. The journey begins with recording and editing macros, writing VBA code, and extends to programming the Ribbon interface and working with XML documents. The course covers automating operations on files, folders, and other Microsoft Office applications. It also delves into event procedures, testing, and debugging. Advanced features include working with VBA classes and raising custom events in standalone class modules. By mastering these skills, users can significantly enhance their productivity and efficiency in Excel.The book's structure, with 29 chapters and over 275 examples, ensures comprehensive learning. Companion files with source code, projects, and figures further support the user. This course is essential for anyone aiming to streamline their Excel tasks and harness the full power of Excel programming.

Natural Language Processing Fundamentals for Developers. A Practical Guide to Building NLP Applications

Mercury Learning and Information, Oswald Campesato

This book is for developers seeking an overview of basic concepts in Natural Language Processing (NLP). It caters to those with varied technical backgrounds, offering numerous code samples and listings to illustrate the wide range of topics covered. The journey begins with managing data relevant to NLP, followed by two chapters on fundamental NLP concepts. This foundation is reinforced with Python code samples that bring these concepts to life.The book then delves into practical NLP applications, such as sentiment analysis, recommender systems, COVID-19 analysis, spam detection, and chatbots. These examples provide real-world context and demonstrate how NLP techniques can be applied to solve common problems. The final chapter introduces advanced topics, including the Transformer architecture, BERT-based models, and the GPT family, highlighting the latest state-of-the-art developments in the field.Appendices offer additional resources, including Python code samples on regular expressions and probability/statistical concepts, ensuring a well-rounded understanding. Companion files with source code and figures enhance the learning experience, making this book a comprehensive guide for mastering NLP techniques and applications.

Python 3 Using ChatGPT / GPT-4. Harnessing AI for Efficient Python Programming

Mercury Learning and Information, Oswald Campesato

This book is for people who want to learn Python 3 and how to use ChatGPT with Python. It starts with an introduction to Python programming, covering data types, number formatting, Unicode handling, and text manipulation. The book then covers loops, conditional logic, reserved words, user input, exception management, and command-line arguments.The journey continues into Generative AI, discussing its distinction from Conversational AI. Popular platforms like ChatGPT and GPT-4 are explored, along with their strengths, weaknesses, and potential applications. The book shows how to generate Python 3 code samples via ChatGPT using the “Code Interpreter” plugin.Understanding these concepts is crucial for navigating Python and AI. This book transitions readers from basic Python programming to advanced AI applications, blending theory with practical skills. Companion files with code samples and figures enhance learning, making this an essential resource for mastering Python and ChatGPT.

C Programming Pocket Primer. An Essential Guide to C Programming Basics

Mercury Learning and Information, Oswald Campesato

As part of the Pocket Primer series, this book provides an overview of major concepts in C programming. It covers essential techniques, including up-to-date information on the C11 standard and comprehensive chapters on pointers. Companion files with source code and figures from the book are included.The course begins with an introduction to C, moving through conditional logic, loops, and arrays. It then delves into functions and provides detailed coverage of pointers, essential for mastering C programming. Miscellaneous topics are also addressed to ensure a well-rounded understanding.Understanding these concepts is crucial for developing efficient C programs. This book transitions readers from beginners to proficient C programmers, combining theoretical knowledge with practical skills. Companion files enhance the learning experience, making this book an invaluable resource for mastering C programming.

Combating Cyberattacks Targeting the AI Ecosystem. Strategies to secure AI systems from emerging cyber threats, risks, and vulnerabilities

Mercury Learning and Information, Aditya K. Sood

Artificial intelligence is transforming industries, but it also exposes organizations to new cyber threats. This course begins by introducing the foundational concepts of securing large language models (LLMs), generative AI applications, and the broader AI infrastructure. Participants will explore the evolving threat landscape, gaining insights into how attackers exploit vulnerabilities in AI systems and the risks posed by trust and compliance failures.The course provides real-world case studies to highlight attack vectors like adversarial inputs, data poisoning, and model theft. Participants will learn practical methods for identifying and mitigating vulnerabilities in AI systems. These insights prepare learners to proactively safeguard their AI infrastructures using advanced security assessment techniques.Finally, the course equips participants with actionable strategies to defend AI systems. You’ll learn to protect sensitive data, implement robust security measures, and address ethical challenges in AI. By the end, you’ll be ready to secure AI ecosystems and adapt to the fast-evolving AI security landscape.