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.

Mathematical Formulas and Scientific Data. Master the Foundations of Mathematics and Physics with This Comprehensive Guide

Mercury Learning and Information, C. P. Kothandaraman

This course serves as a comprehensive reference guide for engineers, mathematicians, scientists, and industry professionals, covering essential mathematical formulas and key scientific data. It is divided into two parts: mathematical formulas including algebra, trigonometry, analytic geometry, differential and integral calculus, and vectors; and scientific data covering units, properties of gases, elements, acoustics, materials, thermodynamics, radioactivity, and more.Understanding these concepts is crucial for professionals, providing a solid foundation for their work. The course explains technical terms, theorems, and applicable laws in detail, ensuring clarity and practical understanding. Each chapter provides valuable insights and data fundamental for scientific and engineering applications.Starting with algebra and geometry, the course advances through calculus and vectors, then explores scientific data in various fields. By the end, users will have a thorough reference of critical formulas and data, making it indispensable for students and professionals. This structured approach ensures learners gain both theoretical knowledge and practical applications essential for their careers.

Game Development Using Python. Mastering Interactive Game Creation and Development through Python

Mercury Learning and Information, James R. Parker

This book guides you through the basic game development process using Python, covering essential topics such as graphics, sound, artificial intelligence, animation, and game engines. Real games are created as you progress through the text, and significant parts of a game engine are built and made available for download. New chapters on card games and a side-scroller are included. The companion files contain all the resources described in the book, including example code, game assets, video/sound editing software, and color figures.The course begins with an introduction to how games work, followed by in-depth chapters on graphics and images, the game loop, and game AI, specifically focusing on collision detection. It then moves on to navigation, control, and sound, guiding you through creating a jet boat race game. Advanced topics such as animation, networking, and platformers are covered, providing a comprehensive understanding of game development.Designed for both beginners and those with some experience, this book equips readers with the skills needed to develop their own games. It emphasizes practical application, ensuring you can implement what you learn. By the end of the course, you will have a solid foundation in game development and the ability to create engaging, interactive games using Python.

Classic Game Design. From Pong to Pac-Man with Unity: Crafting Timeless Retro Games with Expert Techniques

Mercury Learning and Information, Franz Lanzinger

This book teaches you to design and develop classic arcade video games. Using modern, free software tools like Unity, you’ll create five retro games inspired by the classics. All source code, art, and sound files are provided in the companion files. You'll enjoy customizing graphics, adjusting scoring, coding AI, and creating sound effects, gaining a deep understanding of the roots of modern video game design from the '70s and '80s.The course begins with an introduction and essential tools, then guides you through creating various retro games. Each chapter builds on the previous one with detailed instructions, exercises, and classic game design rules. The book includes historical anecdotes from a former Atari programmer and insights on applying classic game design concepts to modern games.Understanding these design elements is crucial for developing engaging video games. This book transitions readers from beginners to proficient game developers, blending theoretical knowledge with practical skills. Companion files enhance the learning experience, making this book an invaluable resource for mastering classic game design with modern tools.

TensorFlow 2 Pocket Primer. A Quick Reference Guide for TensorFlow 2 Developers

Mercury Learning and Information, Oswald Campesato

As part of the best-selling *Pocket Primer* series, this book introduces beginners to basic machine learning algorithms using TensorFlow 2. It provides a fast-paced introduction to TensorFlow, covering core features and machine learning basics with Python code samples. An appendix includes Keras-based code samples and explores MLPs, CNNs, RNNs, and LSTMs. The chapters illustrate how to solve various tasks, encouraging further reading to deepen your knowledge.The journey begins with an introduction to TensorFlow 2, followed by essential APIs and datasets. You'll explore linear regression and classifiers, learning to apply TensorFlow to practical problems. The comprehensive appendix covers advanced topics like NLPs and deep learning architectures, enhancing your understanding of machine learning.Understanding these concepts is crucial for modern AI applications. This book transitions readers from basic TensorFlow use to advanced machine learning techniques, blending theory with practical examples. Companion files with source code and figures enhance learning, making this an essential resource for mastering TensorFlow and machine learning.

Text Analytics for Business Decisions. Mastering Techniques for Insightful Data Interpretation through a Case Study Approach

Mercury Learning and Information, Andres Fortino

This book leverages advanced techniques and tools in data science to extend data analysis from numeric and categorical data to textual data. Designed for business analysts, it uses a case study approach to teach skills in extracting insights from text data, supporting business decision-making. Exercises primarily use Excel and R, covering techniques from basic text analytics to sophisticated methods like topic extraction and text similarity scoring.The course begins with framing analytical questions and exploring analytical tool sets. It progresses through preparing data files, performing word frequency and keyword analysis, and conducting sentiment analysis. Advanced topics include visualizing text data, coding, named entity recognition, and topic recognition in documents. The book also covers text similarity scoring and the analysis of large datasets by sampling.Throughout this journey, readers will apply the CRISP-DM data mining standard, using companion files with numerous datasets for practical exercises. By the end, participants will have a comprehensive understanding of text analytics, enabling them to derive meaningful insights from textual data to inform business strategies.

Angular and Deep Learning Pocket Primer. A Comprehensive Guide to AI and Expert Systems for Professionals

Mercury Learning and Information, Oswald Campesato

As part of the Pocket Primer series, this book introduces basic deep learning concepts and integrates them into Angular 10 applications. It offers a fast-paced introduction to deep learning features and popular classifiers. Covering Angular 10 functionality, deep learning concepts, and key classification algorithms, the book includes code samples and figures. Topics such as TensorFlow and Keras are also explored.The book begins with an introduction to AI and its applications, followed by state space search and heuristic search strategies. You will delve into expert systems, their development life cycle, knowledge acquisition, and representation. These topics lead to a deeper understanding of neural networks, the learning process, and fuzzy logic systems, ensuring a comprehensive grasp of AI and deep learning principles.Understanding these concepts is essential for developing sophisticated AI applications and enhancing Angular 10 projects. This book transitions you from a novice to a proficient developer, equipped with practical skills and knowledge. Advanced topics like fuzzy expert systems and logic programming are covered, culminating in advanced Prolog. Companion files with source code and color figures enhance the learning experience, making this book an invaluable resource for integrating deep learning with Angular 10.

Discrete Mathematics With Cryptographic Applications. A Self-Teaching Guide to Unlocking the Power of Advanced Concepts and Computational Techniques

Mercury Learning and Information, Alexander I. Kheyfits

This book offers a comprehensive guide to discrete mathematics and its applications to cryptography. It is designed for students and professionals in fields such as discrete mathematics and finite mathematics, with all necessary prerequisites clearly explained and illustrated. The text introduces key concepts in number theory, coding theory, and information theory, which are essential for understanding cryptography.Understanding discrete mathematics is crucial for anyone working in cryptography and related fields. The book begins with a survey of elementary functions and moves on to propositional algebra, set theory, and algebraic structures like groups, rings, and fields. It covers binary relations, combinatorics, and elements of number theory, which are fundamental to cryptographic methods.Readers will explore topics such as Boolean functions, hashing functions, cryptographic maps, combinatorial circuits, and graph theory. The book also delves into advanced areas like finite automata, game theory, and Turing machines. Through numerous examples, problems, and solutions, readers will gain a solid foundation in discrete mathematics and its cryptographic applications.

Applying Artificial Intelligence in Project Management. Harness the power of AI to transform project management practices

Mercury Learning and Information, Paul Boudreau

Artificial intelligence is reshaping the way projects are managed, offering unprecedented opportunities to improve efficiency, accuracy, and outcomes. This course begins with an introduction to AI’s role in project management, exploring how machine learning, natural language processing, and predictive algorithms can transform traditional approaches. You’ll learn about the key components of AI-driven projects and how to develop a strong business case for adopting these innovations.As you progress, the course delves into practical applications of AI in automating project tasks, analyzing data, and predicting results. Participants will gain hands-on experience with tools that leverage machine learning to forecast project success, improve productivity, and resolve potential failures. Additionally, you’ll discover how generative AI and large language models can enhance communication, planning, and decision-making throughout the project lifecycle.Finally, the course examines the broader implications of integrating AI into project management. You’ll explore strategies for acquiring AI solutions, implementing them within teams, and navigating the ethical challenges they present. By the end of the course, participants will have a clear understanding of how to leverage AI to optimize projects and stay competitive in a rapidly evolving technological landscape.