SQL Cookbook


Book Description

A guide to SQL covers such topics as retrieving records, metadata queries, working with strings, data arithmetic, date manipulation, reporting and warehousing, and hierarchical queries.




Applied Incident Response


Book Description

Incident response is critical for the active defense of any network, and incident responders need up-to-date, immediately applicable techniques with which to engage the adversary. Applied Incident Response details effective ways to respond to advanced attacks against local and remote network resources, providing proven response techniques and a framework through which to apply them. As a starting point for new incident handlers, or as a technical reference for hardened IR veterans, this book details the latest techniques for responding to threats against your network, including: Preparing your environment for effective incident response Leveraging MITRE ATT&CK and threat intelligence for active network defense Local and remote triage of systems using PowerShell, WMIC, and open-source tools Acquiring RAM and disk images locally and remotely Analyzing RAM with Volatility and Rekall Deep-dive forensic analysis of system drives using open-source or commercial tools Leveraging Security Onion and Elastic Stack for network security monitoring Techniques for log analysis and aggregating high-value logs Static and dynamic analysis of malware with YARA rules, FLARE VM, and Cuckoo Sandbox Detecting and responding to lateral movement techniques, including pass-the-hash, pass-the-ticket, Kerberoasting, malicious use of PowerShell, and many more Effective threat hunting techniques Adversary emulation with Atomic Red Team Improving preventive and detective controls




Getting Started with SQL


Book Description

Businesses are gathering data today at exponential rates and yet few people know how to access it meaningfully. If you’re a business or IT professional, this short hands-on guide teaches you how to pull and transform data with SQL in significant ways. You will quickly master the fundamentals of SQL and learn how to create your own databases. Author Thomas Nield provides exercises throughout the book to help you practice your newfound SQL skills at home, without having to use a database server environment. Not only will you learn how to use key SQL statements to find and manipulate your data, but you’ll also discover how to efficiently design and manage databases to meet your needs. You’ll also learn how to: Explore relational databases, including lightweight and centralized models Use SQLite and SQLiteStudio to create lightweight databases in minutes Query and transform data in meaningful ways by using SELECT, WHERE, GROUP BY, and ORDER BY Join tables to get a more complete view of your business data Build your own tables and centralized databases by using normalized design principles Manage data by learning how to INSERT, DELETE, and UPDATE records




Flexible Views for View-based Model-driven Development


Book Description

Modern software development faces the problem of fragmentation of information across heterogeneous artefacts in different modelling and programming languages. In this dissertation, the Vitruvius approach for view-based engineering is presented. Flexible views offer a compact definition of user-specific views on software systems, and can be defined the novel ModelJoin language. The process is supported by a change metamodel for metamodel evolution and change impact analysis.




Mastering Autodesk Inventor 2020


Book Description

Autodesk Inventor was introduced in 1999 as an ambitious 3D parametric modeler based not on the familiar AutoCAD programming architecture but instead on a separate foundation that would provide the room needed to grow into the fully featured modeler it now is almost a decade later. Inventor 2009 marks a change of focus in the development of Inventor from an up-and-coming application to the current release with the inclusion of the design accelerator wizards and with refined core functions. The maturity of the Inventor tools happily coincides with the advancement of the CAD market’s adoption of 3D parametric modelers as a primary design tool. And although it is important to understand that 2D CAD will likely never completely disappear from the majority of manufacturing design departments, 3D design will increasingly become a requirement for most. With this in mind, we have set out to fill the following pages with detailed information on the specifics of the tools, while addressing the principles of sound parametric design techniques.




T-SQL Window Functions


Book Description

Use window functions to write simpler, better, more efficient T-SQL queries Most T-SQL developers recognize the value of window functions for data analysis calculations. But they can do far more, and recent optimizations make them even more powerful. In T-SQL Window Functions, renowned T-SQL expert Itzik Ben-Gan introduces breakthrough techniques for using them to handle many common T-SQL querying tasks with unprecedented elegance and power. Using extensive code examples, he guides you through window aggregate, ranking, distribution, offset, and ordered set functions. You’ll find a detailed section on optimization, plus an extensive collection of business solutions — including novel techniques available in no other book. Microsoft MVP Itzik Ben-Gan shows how to: • Use window functions to improve queries you previously built with predicates • Master essential SQL windowing concepts, and efficiently design window functions • Effectively utilize partitioning, ordering, and framing • Gain practical in-depth insight into window aggregate, ranking, offset, and statistical functions • Understand how the SQL standard supports ordered set functions, and find working solutions for functions not yet available in the language • Preview advanced Row Pattern Recognition (RPR) data analysis techniques • Optimize window functions in SQL Server and Azure SQL Database, making the most of indexing, parallelism, and more • Discover a full library of window function solutions for common business problems About This Book • For developers, DBAs, data analysts, data scientists, BI professionals, and power users familiar with T-SQL queries • Addresses any edition of the SQL Server 2019 database engine or later, as well as Azure SQL Database Get all code samples at: MicrosoftPressStore.com/TSQLWindowFunctions/downloads




Artificial Intelligence in HCI


Book Description

This double volume book set constitutes the refereed proceedings of 4th International Conference, AI-HCI 2023, held as part of the 25th International Conference, HCI International 2023, which was held virtually in Copenhagen, Denmark in July 2023. The total of 1578 papers and 396 posters included in the HCII 2023 proceedings was carefully reviewed and selected from 7472 submissions. The first volume focuses on topics related to Human-Centered Artificial Intelligence, explainability, transparency and trustworthiness, ethics and fairness, as well as AI-supported user experience design. The second volume focuses on topics related to AI for language, text, and speech-related tasks, human-AI collaboration, AI for decision-support and perception analysis, and innovations in AI-enabled systems.




Creo Parametric 4.0 for Designers, 4th Edition


Book Description

Creo Parametric 4.0 for Designers book is written to help the readers effectively use the modeling and assembly tools by utilizing the parametric approach of Creo Parametric 4.0 effectively. This book provides detailed description of the tools that are commonly used in modeling, assembly, sheetmetal as well as in mold. This book also covers the latest surfacing techniques like Freestyle and Style with the help of relevant examples and illustrations. The Creo Parametric 4.0 for Designers book further elaborates on the procedure of generating the drawings of a model or assembly, which are used for documentation of a model or assembly. The examples and tutorials used in this book will ensure that the users can relate the knowledge of this book with the actual mechanical industry designs. Every chapter begins with a tools section that provides a brief information of the Creo Parametric tools. This approach allows the user to use this book initially as a learning tool and then as a reference material. Salient Features: Consists of 16 chapters that are organized in a pedagogical sequence. Comprehensive coverage of concepts and techniques. Tutorial approach to explain the concepts. Detailed explanation of all commands and tools. Summarized content on the first page of the topics that are covered in the chapter. Hundreds of illustrations for easy understanding of concepts. Step-by-step instructions that guide the users through the learning process. More than 40 real-world mechanical engineering designs as tutorials, 40 as exercises, and projects with step-by-step explanation. Additional information throughout the book in the form of notes and tips. Self-Evaluation Tests and Review Questions at the end of each chapter so that the users can assess their knowledge. Technical support by contacting '[email protected]'. Additional learning resources at 'http://allaboutcadcam.blogspot.com'. Table of Contents Chapter 1: Introduction to Creo Parametric 4.0 Chapter 2: Creating Sketches in the Sketch Mode-I Chapter 3: Creating Sketches in the Sketch Mode-II Chapter 4: Creating Base Features Chapter 5: Datums Chapter 6: Options Aiding Construction of Parts-I Chapter 7: Options Aiding Construction of Parts-II Chapter 8: Options Aiding Construction of Parts-III Chapter 9: Advanced Modeling Tools Chapter 10: Assembly Modeling Chapter 11: Generating, Editing, and Modifying the Drawing Views Chapter 12: Dimensioning the Drawing Views Chapter 13: Other Drawing Options Chapter 14: Working with Sheetmetal Components Chapter 15: Surface Modeling (For free download) Chapter 16: Introduction to Mold Design (For free download) Student Projects (For free download) Index







SOLIDWORKS 2020 Reference Guide


Book Description

• A comprehensive reference book for SOLIDWORKS 2020 • Contains 260 plus standalone tutorials • Starts with a basic overview of SOLIDWORKS 2020 and its new features • Tutorials are written for each topic with new and intermediate users in mind • Includes access to each tutorial’s initial and final state • Contains a chapter introducing you to 3D printing The SOLIDWORKS 2020 Reference Guide is a comprehensive reference book written to assist the beginner to intermediate user of SOLIDWORKS 2020. SOLIDWORKS is an immense software package, and no one book can cover all topics for all users. This book provides a centralized reference location to address many of the tools, features and techniques of SOLIDWORKS 2020. This book covers the following: • System and Document properties • FeatureManagers • PropertyManagers • ConfigurationManagers • RenderManagers • 2D and 3D Sketch tools • Sketch entities • 3D Feature tools • Motion Study • Sheet Metal • Motion Study • SOLIDWORKS Simulation • PhotoView 360 • Pack and Go • 3D PDFs • Intelligent Modeling techniques • 3D printing terminology and more Chapter 1 provides a basic overview of the concepts and terminology used throughout this book using SOLIDWORKS 2020 software. If you are completely new to SOLIDWORKS, you should read Chapter 1 in detail and complete Lesson 1, Lesson 2 and Lesson 3 in the SOLIDWORKS Tutorials. If you are familiar with an earlier release of SOLIDWORKS, you still might want to skim Chapter 1 to become acquainted with some of the commands, menus and features that you have not used; or you can simply jump to any section in any chapter. Each chapter provides detailed PropertyManager information on key topics with individual stand-alone short tutorials to reinforce and demonstrate the functionality and ease of the SOLIDWORKS tool or feature. The book provides access to over 260 models, their solutions and additional support materials. Learn by doing, not just by reading. Formulate the skills to create, modify and edit sketches and solid features. Learn the techniques to reuse features, parts and assemblies through symmetry, patterns, copied components, design tables, configurations and more. The book is designed to complement the Online Tutorials and Online Help contained in SOLIDWORKS 2020. The goal is to illustrate how multiple design situations and systematic steps combine to produce successful designs. The author developed the tutorials by combining his own industry experience with the knowledge of engineers, department managers, professors, vendors and manufacturers. He is directly involved with SOLIDWORKS every day and his responsibilities go far beyond the creation of just a 3D model.