Allgemein
Introduction to Dependent Types with Idris
Dependent types are a concept that allows developers to write proof-carrying code. Idris is a programming language that supports dependent types. This book will teach you the mathematical foundations of Idris as well as how to use it to write software and mathematically prove properties.The first part of the book serves as an introduction to the language's underlying theories. It starts by reviewing formal systems and mathematical logical systems as foundational building blocks, then gradually builds up to dependent types. Next, you'll learn type theory for dependent types. Following this, you'll explore the Idris programming language and conclude by exploring the depths of formal systems and type checkers by implementing them.Introduction to Dependent Types with Idris will walk you through simple examples through more advanced techniques, stepping up the difficulty as you gain more knowledge. Every chapter includes a set of exercises based on what it covered to further cement your learning. No specialized knowledge of mathematics is expected beyond the basics, so it is perfect for novices.WHAT YOU WILL LEARNUnderstand Lambda calculus and dependent types* Gain insight into functional programming* Write mathematical proofs with IdrisWHO THIS BOOK IS FORProgrammers, mathematicians, academics, and anyone else interested learning dependent types and lambda calculus.BORO SITNIKOVSKI has over ten years of experience working professionally as a software engineer. He started programming with assembly on an Intel x86 at the age of ten. While in high school, he won several prizes in competitive programming, varying from 4th, 3rd, and 1st place. He is an informatics graduate - his bachelor’s thesis was titled “Programming in Haskell using algebraic data structures”, and his master’s thesis was titled “Formal verification of Instruction Sets in Virtual Machines”. He has also published a few papers on software verification. Other research interests of his include programming languages, mathematics, logic, algorithms, and writing correct software. He is a strong believer in the open-source philosophy and contributes to various open-source projects. In his spare time, he enjoys some time off with his family.Chapter 1: Formal Systems.- Chapter 2: Classical Mathematical Logic.- Chapter 3: Type Theory.- Chapter 4: Programming in Idris.- Chapter 5: Proving in Idris.
Making Your CAM Journey Easier with Fusion 360
Downloading a piece of 3D software and shaping concepts and ideas is quite easy. However, designing feasible and cost-effective real parts from 3D models can be challenging with traditional production technologies, or even additive manufacturing. This book will give you the know-how and skills to develop your projects from ideas to physical products, and overcome these obstacles.In ‘Making Your CAM Journey Easier with Fusion 360’, you'll discover how to set up a CAM program, pick the right tool, and optimize production. You'll learn the pros and cons of different production technologies, including turning, milling, laser cutting, and 3D printing, and understand how to choose the best option based on your needs. You’ll also explore the important computer-aided manufacturing tools that Fusion 360 offers through the use of examples and best practices.By the end of this book, you’ll understand the potential issues and drawbacks of different design components and apply workarounds to avoid design flaws.
Privacy in the Age of Big Data
A thorough update to a classic in the field of privacy and big data.We have a global privacy problem. The average person provides more information about themselves to more outsiders than any time in history. Corporations, governments and even our neighbors can know where we are at times, can quickly learn our preferences and priorities and see who we meet.The past decade has brought deep changes in the collection of our private information, the regulation of that collection, and in people’s sensitivity to loss of privacy. The nascent privacy-threatening technology trends of a decade ago have blossomed into relentless data-capturing systems that police and companies have come to rely on. To address the expansion of personal data capture, entire data regulatory regimes have arisen throughout the world, with new regulations added each year.People are more concerned, regulators are more aggressive, yet data collection continues to increase with consequences around the world. Social media use has fragmented in the past five years, spreading personal information over dozens of platforms. Even most of our new televisions have started collecting second-by-second information about our households recently, and some of those televisions can recognize the individuals watching and the devices they carry. Amazon just activated a new worldwide network using bandwidth from personal wifi of Echo devices and Ring security systems. The beat of new intrusions never seems to end.These data trends are relentless, and yet response to the pandemic accelerated them. Rapid development of “contactless everything” became the norm. Contact tracing apps became acceptable. QR codes for everything from menus to contact information were created quickly. Businesses are faced with hybrid in office and remote workforces. More people are dependent on online and mobile technologies for food, medicine, and even human connection. And each of these contacts can be captured somewhere and logged in a file for marketing or surveillance. People want to keep their lives private, but they don’t know how.The second edition of Privacy in the Age of Big Data addresses the significant advances in data-driven technology, their intrusion deeper in our lives, the limits on data collection newly required by governments in North America and Europe, and the new security challenges of world rife with ransomware and hacking. This thoroughly updated edition demonstrates personal privacy vulnerabilities and shows ways to live a safer, more private life. Other privacy books tend to focus deeply on the evils of large tech companies or more academic and technical concerns. But Privacy in the Age of Big Data, second edition, helps regular people understand the privacy threats and vulnerabilities in their daily lives and will provide solutions for maintaining better privacy while enjoying a modern life. Unlike other books, this one shows what you can do to make a difference to understand your current digital footprint and what you need to do to claw back your privacy and secure it in the future.While PRIVACY IN THE AGE OF BIG DATA will have cross-sectional appeal to many demographics, working adults 25-60 and CEOs and Boards of businesses are the primary demographic--young enough to know we need to do something to protect privacy and old enough to remember what happens when we haven’t in the past. With down-to-earth prose and examples pulled from daily life, the writing style will attract buyers of all education levels.Ted Claypoole is a partner at the law firm of Womble Bond Dickinson, practicing in Atlanta, Georgia. He has co-authored with Theresa Payton the book Protecting Your Internet Identity. He wrote the book Technology, Data and Law and also edited and co-wrote The Law of Artificial Intelligence and Smart Machines. He lives in Atlanta, GA.Theresa Payton runs Fortalice Solutions, a globally recognized cybersecurity and business intelligence firm headquartered in Charlotte where she resides. A reality TV star from the CBS hit show, “Hunted”, Payton addresses Boards, CEOs, and individuals on security and privacy matters and is regularly featured on global news media outlets discussing privacy and security issues. She lives in Charlotte, NC.Introduction: Your Life on TechnologyChapter 1. The Intersection of Privacy, Law and TechnologySection I: Your Computer and the InternetChapter 2. Your Computer is Watching YouChapter 3. How the Government Follows Your Electronic TracksChapter 4. Criminals and SnoopsChapter 5. Just Hanging Out OnlineChapter 6. The Spy in Your PocketSection II: Risk in the StreetsChapter 7. Cameras EverywhereChapter 8. When Your Car is Just Another ComputerChapter 9. When Your Own Body Gives You AwayChapter 10. DNA and Health RecordsSection III: Home is Where the Heart (of Surveillance) IsChapter 11. Home Sweet Home: Spies in Your Living RoomChapter 12. Risks of Computer and Phone NetworksSection IV: Where Do We Go from Here?Chapter 13. Reality Meets the Metaverse PlusChapter 14. Judging You by Your DataChapter 15. The Future of Technology and PrivacyChapter 16. Laws and Regulations That Could Help Preserve PrivacyIndexAbout the Authors
Handbuch IT-Management (8. Auflg.)
Konzepte, Methoden, Lösungen und Arbeitshilfen für die PraxisIT-Management ist einer der wichtigsten Erfolgsfaktoren für alle Unternehmen und Dienstleistungsorganisationen. Deshalb nehmen IT-Verantwortliche eine zunehmend zentrale Rolle ein. Gestützt durch leistungsfähige Technologien wie Big Data und Data Analytics, Cloud Computing, durch mobile Endgeräte und neue Formen der Vernetzung (IoT u. a.) sowie weitere digitale Innovationen (KI, AR u. a.) werden völlig neue Geschäftsmodelle, Produkte und Prozesse entwickelt und erfolgreich realisiert bzw. implementiert.Damit Sie als IT-Manager für die Praxis gerüstet sind, bietet Ihnen dieses Handbuch umfassendes und unverzichtbares Wissen zu allen wichtigen Handlungsfeldern der IT sowie Unterstützung für die erfolgreiche Nutzung bewährter Methoden und Instrumente.Diese Auflage wurde umfassend aktualisiert und durch innovative Managementthemen, wie z.B. IT-Sourcing, IT-Relationship-Management oder Digitale Transformation erweitert.Mit Beiträgen von Robert Bergmann, Matthias Farwick, Vanessa Greger, Torsten Groll, Norbert Gronau, Christiana Klingenberg, Michael Klotz, Dietmar Kopperger, Helmut Krcmar, Jörg Kunsmann, Klaus Schmidt, Tobias Schmidt, Ernst Tiemeyer, Thomas Trojer, Kristin Weber, Anette Weisbecker, Walter Wintersteiger und Helmut ZsifkovitsInhalt:Strategisches IT-ManagementDigitalisierung managenEnterprise Architecture ManagementDaten- und InformationsmanagementGeschäftsprozessorientierte SoftwaresystemeCloud ComputingIT-SourcingIT-AnforderungsmanagementIT-System- und IT-ServicemanagementDigital Workplace ManagementIT-OrganisationPersonalmanagement im IT-BereichIT-ControllingLizenzmanagement in der ITEnterprise IT-GovernanceInformation Security ManagementIT-CompliancePartnermanagement in der ITEnterprise IT-ProjektmanagementDigitale TransformationAutor:Dipl.-Hdl. Ernst Tiemeyer ist seit mehr als 25 Jahren in leitenden Projektfunktionen sowie als IT-Consultant und im Bildungsbereich bzw. Managementtraining tätig. Schwerpunktmäßig befasst er sich in der Praxis mit Projektmanagement, strategischem IT-Management, Enterprise IT-Architekturmanagement, Enterprise IT-Governance, IT-Controlling sowie BPM. Seine Lehrtätigkeit führt er unter anderem an der EU-FH in Hamburg, am FH Joanneum Kapfenberg/Graz sowie an der FOM (Hochschule für Berufstätige) in verschiedenen Bachelor- und Masterstudiengängen aus.
KI für das Gute
Während die Technologie im Zeitalter des maschinellen Lernens rasant voranschreitet, mangelt es an klaren Absichten und der Formulierung akzeptabler ethischer Standards. Dieses Buch fasst das komplexe Thema der "guten" Technologie bereichsübergreifend zusammen und wechselt zwischen Theorie und Praxis. Die Autoren gehen auf die sich ständig ausweitende Diskussion über Künstliche Intelligenz (KI) und Ethik ein und geben eine Orientierung. Dabei werden insbesondere pragmatische und aktuelle Fragestellungen berücksichtigt, wie z.B. die Kollateralwirkungen der COVID19-Pandemie. Ein aktueller Überblick über die Digitalisierung - an sich schon ein sehr weites Feld - wird ebenso vorgestellt wie eine Analyse der Ansätze von KI aus ethischer Perspektive. Darüber hinaus werden konkrete Ansätze zur Berücksichtigung angemessener ethischer Prinzipien in KI-basierten Lösungen angeboten. Das Buch richtet sich sowohl an Wissenschaftler aus geistes- und wirtschaftswissenschaftlichen oder technischen Disziplinen als auch an Praktiker, die eine Einführung in das Thema und eine Orientierung mit konkreten Fragen und Hilfestellungen suchen.
Requirements Engineering für die agile Softwareentwicklung
Das Handbuch für agile Requirements Engineers- Umfassend und anwendungsbezogen- Ein Buch aus der Praxis für die Praxis- Mit durchgängigem Projektbeispiel und wertvollen Hinweisen für pragmatische LösungenDieses Buch gibt einen praxisorientierten Überblick über die am weitesten verbreiteten Techniken für die Anforderungsspezifikation und das Requirements Management in agilen Projekten. Es beschreibt sowohl sinnvolle Anwendungsmöglichkeiten als auch Fallstricke der einzelnen Techniken.Behandelt werden im Einzelnen:- Grundlagen und die fünf Grundprinzipien des Requirements Engineering in der agilen Softwareentwicklung- Requirements-Ermittlung und -Dokumentation- Requirements-Validierung und -Abstimmung- Qualität im Requirements Engineering- Requirements Management- Organisatorische Aspekte- Rollen im Requirements EngineeringDarüber hinaus werden rechtliche und wirtschaftliche Themen erläutert sowie auf die Herausforderungen in größeren Organisationen eingegangen.Das Buch ist Hilfestellung und Nachschlagewerk, um in der täglichen Praxis der agilen Projekte Requirements Engineering und Requirements Management professionell und mit nachhaltigem Nutzen umzusetzen.Die 3. Auflage wurde vollständig überarbeitet und berücksichtigt den Lehrplan "RE@Agile Primer" des International Requirements Engineering Board (IREB) sowie die neue Fassung des Scrum Guide von November 2020.Johannes Bergsmann hat technische Informatik studiert und arbeitete ca. 11 Jahre als Softwareentwickler, Projektleiter, Technischer Leiter, Architekt, Produktmanager und Berater in einem internationalen Systemhaus und als selbstständiger Unternehmer. Im März 2003 gründete er "Software Quality Lab" und begleitet seither als Berater und Trainer viele Unternehmen im Bereich Requirements Engineering und Prozessgestaltung. Johannes Bergsmann ist zertifizierter Scrum Master, Sachverständiger für Informatik bei Gerichten, als Lehrbeauftragter an Fachhochschulen im Bereich Softwarequalitätsmanagement tätig, ist Autor vieler Fachartikel und hält Fachvorträge bei verschiedenen Veranstaltungen und Konferenzen. Unter Mitwirkung von Markus Unterauer: Markus Unterauer hat Wirtschaftsinformatik studiert. In seiner Berufspraxis war er in vielen Bereichen der Softwareentwicklung wie Architektur, Entwurf, Entwicklung, Testen, Testautomatisierung bis zu Deployment tätig. Er lernte dabei sowohl klassische als auch agile Projekte und Methoden intensiv kennen. Seit 2012 arbeitet Markus Unterauer bei Software Quality Lab als Berater und Trainer. Er ist zertifizierter Scrum Master und hat sich auf die Bereiche Softwareprozesse und Anforderungsmanagement spezialisiert. Markus Unterauer ist auch als Vortragender in diesen Themenbereichen immer wieder auf Konferenzen tätig.
SnowPro™ Core Certification Companion
This study companion helps you prepare for the SnowPro Core Certification exam. The author guides your studies so you will not have to tackle the exam by yourself. To help you track your progress, chapters in this book correspond to the exam domains as described on Snowflake’s website. Upon studying the material in this book, you will have solid knowledge that should give you the best shot possible at taking and passing the exam and earning the certification you deserve.Each chapter provides explanations, instructions, guidance, tips, and other information with the level of detail that you need to prepare for the exam. You will not waste your time with unneeded detail and advanced content which is out of scope of the exam. Focus is kept on reviewing the materials and helping you become familiar with the content of the exam that is recommended by Snowflake.THIS BOOK HELPS YOU* Review the domains that Snowflake specifically recommends you study in preparation for Exam COF-C02* Identify gaps in your knowledge that you can study and fill in to increase your chances of passing Exam COF-C02* Level up your knowledge even if not taking the exam, so you know the same material as someone who has taken the exam* Learn how to set up a Snowflake account and configure access according to recommended security best practices* Be capable of loading structured and unstructured data into Snowflake as well as unloading data from Snowflake* Understand how to apply Snowflake data protection features such as cloning, time travel, and fail safe* Review Snowflake’s data sharing capabilities, including data marketplace and data exchangeWHO THIS BOOK IS FORThose who are planning to take the SnowPro Core Certification COF-C02 exam, and anyone who wishes to gain core expertise in implementing and migrating to the Snowflake Data CloudMAJA FERLE is a seasoned data architect with more than 30 years of experience in data analytics, data warehousing, business intelligence, data engineering, data modeling, and database administration. As a consultant, she has delivered data projects in diverse environments across the globe, always seeking to get her hands on the latest technologies and methodologies. Since embarking on the Snowflake Data Cloud, Maja has served as data architect and data engineer on several successful cloud migration projects. She holds the SnowPro Core Certification and is a Snowflake Subject Matter Expert and a Snowflake Data Superhero. 1. Exam Overview2. Snowflake Data Platform Features3. Snowflake Architecture4. Account Access and Security5. Storage and Performance Concepts6. Virtual Warehouses7. Data Loading and Unloading8. Data Transformation9. Data Protection10. Data Sharing11. SQL Scripting and Snowpark
Getting Started with Angular
Immerse yourself in the architecture of an Angular application, starting with an introduction to TypeScript and ES6, and progressing to modules and components used to build complex applications. This book presents a hands-on approach to becoming a proficient Angular developer by building three complete applications.You’ll start with an overview of the Angular framework where TypeScript and ES6 are introduced. Next you’ll see how to build an application (RestApp) using the in-memory module to mock an API that communicates with a rest API performing crud operations. This is followed by an application (AuthApp) that uses a third party service to provide authentication and authorization capabilities to handle registrations. You’ll then build an application (BlogApp) that communicates with a MongoDB database in six parts.Part 1 covers MongoDB, how to install bootstrap, login service, and adding the logic of the form. Part 2 covers how to start the project on the server, create the database and AuthService, and save the user in the session. In Parts 3 and 4 you will learn to create the post collection, post component, and sharpen details. In Parts 5 and 6 you will study adding, editing, and deleting posts with testing.By the end of the book you'll have the necessary knowledge to write and execute automated tests on your applications, and deploy them to a server.WHAT YOU’LL LEARN* Divide the logic of an application into components* Communicate with an API* Release the power of the observables to solve asynchronous programming problems * Include Bootstrap so that your application looks great on different devicesWHO THIS BOOK IS FORWeb developers with basic knowledge of JavaScript, HTML, and CSS.Victor has more than twelve years as a full-stack developer, using different frameworks such as Angular, Laravel, Yii, Zend, Cake, and Vue. He has developed multiple web and mobile applications for various organizations. He has also developed various courses on web development for Udemy. He loves teaching, reading, and writing technical and fantasy books.GETTING STARTED WITH ANGULARChapter 1: Introduction to Angular FrameworkChapter 2: Introduction to TypeScript and ES6Chapter 3: First Application: RestAppChapter 4: RestAppChapter 5: AuthAppChapter 6: Blog App Part IChapter 7: Blog App Part IIChapter 8: Blog App Part III Showing PostsChapter 9: Blog App Part IV Filtering PostsChapter 10: Blog App Part V Adding PostsChapter 11: Blog App Part VI Editing PostsChapter 12: Blog App Part VII Deleting PostsChapter 13: Testing
Build Your Own Test Framework
Learn to write better automated tests that will dramatically increase your productivity and have fun while doing so. This book is a build-your-own adventure designed for individual reading and for collaborative workshops.You will build an xUnit automated test framework using JavaScript: initially a clone of Jest, but adding a couple of neat features borrowed from RSpec, the genre-defining tool for behavior-driven development (BDD). Along the way, you will explore the philosophy behind automated testing best practices. The automated test runner is one of the most important innovations within software engineering. But for many programmers, automated testing remains a mystery, and knowing how to write good tests is akin to sorcery.As the chapters of this book unfold, you will see how the humble test runner is an elegant and simple piece of software. Each chapter picks a single feature to build, like the "it" function or the "beforeEach" block. It picks apart the theory of why the feature needs to exist, and how to use it effectively in your own test suites. Every chapter ends with a set of ideas for extension points should you wish to explore further, alone or in groups. The book culminates in an implementation of test doubles and mocks—one of the most difficult and misunderstood concepts within automated testing.By the end of the book, you will have gained a solid understanding of automated testing principles that you can immediately apply to your work projects.WHAT YOU'LL LEARN* Build an xUnit automated test framework* See how an automated test runner works* Understand the best practices for automated unit testing* Effectively use test doubles and mocksWHO THIS BOOK IS FORSoftware developers with JavaScript experience who are seeking to master the art of automated testing.Daniel Irvine is a freelance software developer based in London. He works with a variety of languages including C#, Clojure, JavaScript, and Ruby. When he’s not working, he spends time cooking, gardening and practicing yoga. He co-founded the Queer Code London meetup and is an active member of the European software craft community. PART 1: BUILDING THE CORE OF A TEST FRAMEWORKIn this part we build a barebones implementation of a test runner.CHAPTER 1: CREATING AN NPM PACKAGE OF MY VERY OWN,You will create a new NPM package for concise-test, including an entry-point for the test runner.CHAPTER 2: BUILDING IT TO DEFINE A TESTwe’ll implement the it function for defining tests, and start printing out some useful test run information on screen.CHAPTER 3: GROUPING TESTS WITH DESCRIBE,we’ll add support for grouping tests with the describe function, and we’ll continue to build out test reporting on screen.CHAPTER 4: PROMOTING CONCISENESS WITH BEFOREEACH AND AFTEREACHWe continue our quest for concise testing facilities with the addition of beforeEach and afterEach functions.CHAPTER 5: IMPROVING LEGIBILITY WITH EXPECT,We finish off the core of our API by building an abstraction over throw new Error.PART 2: CONSTRUCTING A USABLE FRAMEWORKIn this part we add features that you’ll use on a daily basis.CHAPTER 6: FORMATTING EXPECTATION ERRORSWe write a formatter for stack traces to help pinpoint failures quickly.CHAPTER 7. AUTOMATICALLY DISCOVERING TEST FILESWe’ll add test file discovery to our test runner, and add support for running a single file through a command line argument.CHAPTER 8: FOCUSING ON TESTS WITH IT.ONLY AND DESCRIBE.ONLY,We split out runner into two phases: a discovery phase and an execution phase. In between them, we insert a filter phase to support running only a subset of phases.CHAPTER 9: SUPPORTING ASYNCHRONOUS TESTS,We add the ability to wait on tests that return Promise objects, and timing out tests with it.timesOutAfter.CHAPTER 10: REPORTINGwe use a pub-sub model to build a plug-in system for reporters.PART 3: EXTENDING FOR POWER USERSIn this part we continue to add advanced features.CHAPTER 11: SHARING BEHAVIOR WITH IT.BEHAVESLIKE,We borrow an important feature from Ruby: inheritance for describe blocks, which gives us a flexible mechanism for removing duplication between test groups.CHAPTER 12: TAGGING TESTSWe create a mechanism for running a group of tests based on their tag.CHAPTER 13 : SKIPPING TESTSwe introduce a number of ways to skip tests, including tests without bodies, and it.skip plus describe.skip functions.CHAPTER 14 : RANDOMIZING TESTSWe add a runtime flag for randomizing the order of tests, which is a useful technique for catching invisible dependencies between tests.PART 4: TEST DOUBLES AND MOCKSChapter 15. Understanding test doubleswe create a function that can be used as a test spy and stub.CHAPTER 16. MODULE MOCKSWe create a system for mocking out entire modules, which is a useful technique when creating component doubles when testing React.
Practical OpenTelemetry
Learn the value that OpenTelemetry can bring to organizations that aim to implement observability best practices, and gain a deeper understanding of how different building blocks interact with each other to bring out-of-the-box, vendor-neutral instrumentation to your stack. With examples in Java, this book shows how to use OpenTelemetry APIs and configure plugins and SDKs to instrument services and produce valuable telemetry data. You’ll learn how to maximize adoption of OpenTelemetry and encourage the change needed in debugging workflows to reduce cognitive load for engineers troubleshooting production workloads.Adopting observability best practices across an organization is challenging. This book begins with a discussion of how operational monitoring processes widely followed for decades fall short at providing the insights needed for debugging cloud-native, distributed systems in production. The book goes on to show how the Cloud Native Computing Foundation’s OpenTelemetry project helps you standardize instrumentation and transport of telemetry signals, providing a common language for all observability tooling.YOU WILL LEARN* Why observability is a necessity in modern distributed systems* The value of OpenTelemetry for engineers and organizations * OpenTelemetry component specification and general design* Tracing, metrics, and logs APIs and SDKs, with examples in Java* OpenTelemetry Collectors and recommended transport and processing pipelines* How to adopt observability standards across an organizationWHO THIS BOOK IS FORSoftware engineers familiar with cloud-native technologies and operational monitoring who want to instrument and export telemetry data from their services; observability leads who want to roll out OpenTelemetry standards and best practices across their organizations; and Java developers who want a book with OpenTelemetry examples in that languageDANIEL GOMEZ BLANCO is a Principal Engineer at Skyscanner, leading their observability transformation across hundreds of services to ensure that travelers get a reliable and performant experience when booking their next holiday. He is an advocate of open standards and CNCF projects such as OpenTelemetry to back the instrumentation and collection of operational data. Daniel has experience working in organizations of all sizes, from international institutions such as CERN in Geneva, to London startups such as SKIPJAQ. His main focus has always been building software and adopting solutions to minimize the cognitive load required for engineers to support and operate production services. PART I. THE NEED FOR OBSERVABILITY WITH OPENTELEMETRY1. The Need for Observabilitya. Why Observability Mattersb. Context and Correlation2. How OpenTelemetry Enables Observabilitya. OpenTelemetry’s Missionb. The Power of Open Standardsc. The Shift In Vendor Added ValuePART II. OPENTELEMETRY COMPONENTS AND BEST PRACTICES3. OpenTelemetry Fundamentalsa. OpenTelemetry Specificationb. Semantic Conventions4. Auto-Instrumentationa. Resource SDKb. Instrumentation Libraries5. Context, Baggage, and Propagatorsa. Telemetry Context and the Context APIb. Baggage APIc. Cross-Service Context and the Propagators API6. Tracinga. What is a Distributed Trace?b. Tracing APIc. Tracing SDKd. Trace Context Propagation7. Metricsa. Measurements, Metrics and Time Seriesb. Metrics APIc. Metrics SDK8. Logginga. The Purpose of Logs for Observabilityb. Logging APIc. Logging SDKd. Integrations with Logging Frameworks9. Protocol and Collectora. Protocolb. Collector10. Sampling and Common Deployment Modelsa. Common Deployment Modelsb. Trace SamplingPART III. ROLLING OUT OPENTELEMETRY ACROSS YOUR ORGANISATION11. Maximizing Adoption by Minimizing Frictiona. Investing in Telemetry Enablementb. Adopting OpenTelemetry12. Adopting Observabilitya. Shifting Debugging Workflowsb. Expanding Contextc. Keeping Telemetry Valuable
Machine Learning for Business Analytics
MACHINE LEARNING FOR BUSINESS ANALYTICSMACHINE LEARNING—ALSO KNOWN AS DATA MINING OR DATA ANALYTICS—IS A FUNDAMENTAL PART OF DATA SCIENCE. IT IS USED BY ORGANIZATIONS IN A WIDE VARIETY OF ARENAS TO TURN RAW DATA INTO ACTIONABLE INFORMATION.Machine Learning for Business Analytics: Concepts, Techniques and Applications in RapidMiner provides a comprehensive introduction and an overview of this methodology. This best-selling textbook covers both statistical and machine learning algorithms for prediction, classification, visualization, dimension reduction, rule mining, recommendations, clustering, text mining, experimentation and network analytics. Along with hands-on exercises and real-life case studies, it also discusses managerial and ethical issues for responsible use of machine learning techniques. This is the seventh edition of Machine Learning for Business Analytics, and the first using RapidMiner software. This edition also includes:* A new co-author, Amit Deokar, who brings experience teaching business analytics courses using RapidMiner* Integrated use of RapidMiner, an open-source machine learning platform that has become commercially popular in recent years* An expanded chapter focused on discussion of deep learning techniques* A new chapter on experimental feedback techniques including A/B testing, uplift modeling, and reinforcement learning* A new chapter on responsible data science* Updates and new material based on feedback from instructors teaching MBA, Masters in Business Analytics and related programs, undergraduate, diploma and executive courses, and from their students* A full chapter devoted to relevant case studies with more than a dozen cases demonstrating applications for the machine learning techniques * End-of-chapter exercises that help readers gauge and expand their comprehension and competency of the material presented* A companion website with more than two dozen data sets, and instructor materials including exercise solutions, slides, and case solutions This textbook is an ideal resource for upper-level undergraduate and graduate level courses in data science, predictive analytics, and business analytics. It is also an excellent reference for analysts, researchers, and data science practitioners working with quantitative data in management, finance, marketing, operations management, information systems, computer science, and information technology. GALIT SHMUELI, PHD, is Distinguished Professor at National Tsing Hua University’s Institute of Service Science, College of Technology Management. She has designed and instructed business analytics courses since 2004 at University of Maryland, Statistics.com, The Indian School of Business, and National Tsing Hua University, Taiwan. PETER C. BRUCE, is Founder of the Institute for Statistics Education at Statistics.com, and Chief Learning Officer at Elder Research, Inc. AMIT V. DEOKAR, PHD, is Associate Dean of Undergraduate Programs and an Associate Professor of Management Information Systems at the Manning School of Business at University of Massachusetts Lowell. Since 2006, he has developed and taught courses in business analytics, with expertise in using the RapidMiner platform. He is an Association for Information Systems Distinguished Member Cum Laude. NITIN R. PATEL, PHD, is cofounder and lead researcher at Cytel Inc. He was also a co-founder of Tata Consultancy Services. A Fellow of the American Statistical Association, Dr. Patel has served as a visiting professor at the Massachusetts Institute of Technology and at Harvard University. He is a Fellow of the Computer Society of India and was a professor at the Indian Institute of Management, Ahmedabad, for 15 years. Foreword by Ravi Bapna xxiPreface to the RapidMiner Edition xxiiiAcknowledgments xxviiPART I PRELIMINARIESCHAPTER 1INTRODUCTION 31.1 What Is Business Analytics? 31.2 What Is Machine Learning? 51.3 Machine Learning, AI, and Related Terms 51.4 Big Data 71.5 Data Science 81.6 Why Are There So Many Different Methods? 91.7 Terminology and Notation 91.8 Road Maps to This Book 121.9 Using RapidMiner Studio 14CHAPTER 2OVERVIEW OF THE MACHINE LEARNING PROCESS 192.1 Introduction 192.2 Core Ideas in Machine Learning 202.3 The Steps in a Machine Learning Project 232.4 Preliminary Steps 252.5 Predictive Power and Overfitting 322.6 Building a Predictive Model with RapidMiner 372.7 Using RapidMiner for Machine Learning 452.8 Automating Machine Learning Solutions 472.9 Ethical Practice in Machine Learning 52PART II DATA EXPLORATION AND DIMENSION REDUCTIONCHAPTER 3DATA VISUALIZATION 633.1 Introduction 633.2 Data Examples 653.3 Basic Charts: Bar Charts, Line Charts, and Scatter Plots 663.4 Multidimensional Visualization 753.5 Specialized Visualizations 873.6 Summary: Major Visualizations and Operations, by Machine Learning Goal 92CHAPTER 4DIMENSION REDUCTION 974.1 Introduction 974.2 Curse of Dimensionality 984.3 Practical Considerations 984.4 Data Summaries 1004.5 Correlation Analysis 1034.6 Reducing the Number of Categories in Categorical Attributes 1054.7 Converting a Categorical Attribute to a Numerical Attribute 1074.8 Principal Component Analysis 1074.9 Dimension Reduction Using Regression Models 1174.10 Dimension Reduction Using Classification and Regression Trees 119PART III PERFORMANCE EVALUATIONCHAPTER 5EVALUATING PREDICTIVE PERFORMANCE 1255.1 Introduction 1255.2 Evaluating Predictive Performance 1265.3 Judging Classifier Performance 1315.4 Judging Ranking Performance 1465.5 Oversampling 151PART IV PREDICTION AND CLASSIFICATION METHODSCHAPTER 6MULTIPLE LINEAR REGRESSION 1636.1 Introduction 1636.2 Explanatory vs. Predictive Modeling 1646.3 Estimating the Regression Equation and Prediction 1666.4 Variable Selection in Linear Regression 171CHAPTER 7K-NEAREST NEIGHBORS (K-NN) 1897.1 The k-NN Classifier (Categorical Label) 1897.2 K-NN for a Numerical Label 2007.3 Advantages and Shortcomings of K-NN Algorithms 202CHAPTER 8THE NAIVE BAYES CLASSIFIER 2098.1 Introduction 2098.2 Applying the Full (Exact) Bayesian Classifier 2118.3 Solution: Naive Bayes 2138.4 Advantages and Shortcomings of the Naive Bayes Classifier 223CHAPTER 9CLASSIFICATION AND REGRESSION TREES 2299.1 Introduction 2299.2 Classification Trees 2329.3 Evaluating the Performance of a Classification Tree 2409.4 Avoiding Overfitting 2459.5 Classification Rules from Trees 2559.6 Classification Trees for More Than Two Classes 2569.7 Regression Trees 2569.8 Improving Prediction: Random Forests and Boosted Trees 2599.9 Advantages and Weaknesses of a Tree 261CHAPTER 10 LOGISTIC REGRESSION 26910.1 Introduction 26910.2 The Logistic Regression Model 27110.3 Example: Acceptance of Personal Loan 27210.4 Logistic Regression for Multi-class Classification 28310.5 Example of Complete Analysis: Predicting Delayed Flights 286CHAPTER 11 NEURAL NETWORKS 30511.1 Introduction 30611.2 Concept and Structure of a Neural Network 30611.3 Fitting a Network to Data 30711.4 Required User Input 32111.5 Exploring the Relationship Between Predictors and Target Attribute 32211.6 Deep Learning 32311.7 Advantages and Weaknesses of Neural Networks 334CHAPTER 12 DISCRIMINANT ANALYSIS 33712.1 Introduction 33712.2 Distance of a Record from a Class 34012.3 Fisher’s Linear Classification Functions 34112.4 Classification Performance of Discriminant Analysis 34612.5 Prior Probabilities 34812.6 Unequal Misclassification Costs 34812.7 Classifying More Than Two Classes 34912.8 Advantages and Weaknesses 351CHAPTER 13 GENERATING, COMPARING, AND COMBINING MULTIPLE MODELS 35913.1 Automated Machine Learning (AutoML) 35913.2 Explaining Model Predictions 36713.3 Ensembles 37313.4 Summary 381PART V INTERVENTION AND USER FEEDBACKCHAPTER 14 INTERVENTIONS: EXPERIMENTS, UPLIFT MODELS, AND REINFORCEMENT LEARNING 38714.1 A/B Testing 38714.2 Uplift (Persuasion) Modeling 39314.3 Reinforcement Learning 40014.4 Summary 405PART VI MINING RELATIONSHIPS AMONG RECORDSCHAPTER 15 ASSOCIATION RULES AND COLLABORATIVE FILTERING 40915.1 Association Rules 40915.2 Collaborative Filtering 42415.3 Summary 438CHAPTER 16 CLUSTER ANALYSIS 44516.1 Introduction 44516.2 Measuring Distance Between Two Records 44916.3 Measuring Distance Between Two Clusters 45516.4 Hierarchical (Agglomerative) Clustering 45716.5 Non-Hierarchical Clustering: The k-Means Algorithm 466PART VII FORECASTING TIME SERIESCHAPTER 17 HANDLING TIME SERIES 47917.1 Introduction 48017.2 Descriptive vs. Predictive Modeling 48117.3 Popular Forecasting Methods in Business 48117.4 Time Series Components 48217.5 Data Partitioning and Performance Evaluation 486CHAPTER 18 REGRESSION-BASED FORECASTING 49718.1 A Model with Trend 49818.2 A Model with Seasonality 50418.3 A Model with Trend and Seasonality 50818.4 Autocorrelation and ARIMA Models 509CHAPTER 19 SMOOTHING AND DEEP LEARNING METHODS FOR FORECASTING 53319.1 Smoothing Methods: Introduction 53419.2 Moving Average 53419.3 Simple Exponential Smoothing 54119.4 Advanced Exponential Smoothing 54519.5 Deep Learning for Forecasting 549PART VIII DATA ANALYTICSCHAPTER 20 SOCIAL NETWORK ANALYTICS 56320.1 Introduction 56320.2 Directed vs. Undirected Networks 56420.3 Visualizing and Analyzing Networks 56720.4 Social Data Metrics and Taxonomy 57120.5 Using Network Metrics in Prediction and Classification 57720.6 Collecting Social Network Data with RapidMiner 58420.7 Advantages and Disadvantages 584CHAPTER 21 TEXT MINING 58921.1 Introduction 58921.2 The Tabular Representation of Text: Term–Document Matrix and “Bag-of-Words’’ 59021.3 Bag-of-Words vs. Meaning Extraction at Document Level 59221.4 Preprocessing the Text 59321.5 Implementing Machine Learning Methods 60221.6 Example: Online Discussions on Autos and Electronics 60221.7 Example: Sentiment Analysis of Movie Reviews 60721.8 Summary 614CHAPTER 22 RESPONSIBLE DATA SCIENCE 61722.1 Introduction 61722.2 Unintentional Harm 61822.3 Legal Considerations 62022.4 Principles of Responsible Data Science 62122.5 A Responsible Data Science Framework 62422.6 Documentation Tools 62822.7 Example: Applying the RDS Framework to the COMPAS Example 63122.8 Summary 641PART IX CASESCHAPTER 23 CASES 64723.1 Charles Book Club 64723.2 German Credit 65323.3 Tayko Software Cataloger 65823.4 Political Persuasion 66223.5 Taxi Cancellations 66523.6 Segmenting Consumers of Bath Soap 66723.7 Direct-Mail Fundraising 67023.8 Catalog Cross-Selling 67223.9 Time Series Case: Forecasting Public Transportation Demand 67323.10 Loan Approval 675Index 685
Artificial Intelligence for Business Analytics
While methods of artificial intelligence (AI) were until a few years ago exclusively a topic of scientific discussions, today they are increasingly finding their way into products of everyday life. At the same time, the amount of data produced and available is growing due to increasing digitalization, the integration of digital measurement and control systems, and automatic exchange between devices (Internet of Things). In the future, the use of business intelligence (BI) and a look into the past will no longer be sufficient for most companies.Instead, business analytics, i.e., predictive and predictive analyses and automated decisions, will be needed to stay competitive in the future. The use of growing amounts of data is a significant challenge and one of the most important areas of data analysis is represented by artificial intelligence methods.This book provides a concise introduction to the essential aspects of using artificial intelligence methods for business analytics, presents machine learning and the most important algorithms in a comprehensible form using the business analytics technology framework, and shows application scenarios from various industries. In addition, it provides the Business Analytics Model for Artificial Intelligence, a reference procedure model for structuring BA and AI projects in the company.This book is a translation of the original German 1st edition Künstliche Intelligenz für Business Analytics by Felix Weber, published by Springer Fachmedien Wiesbaden GmbH, part of Springer Nature in 2020. The translation was done with the help of artificial intelligence (machine translation by the service DeepL.com). A subsequent human revision was done primarily in terms of content, so that the book will read stylistically differently from a conventional translation. Springer Nature works continuously to further the development of tools for the production of books and on the related technologies to support the authors.Felix Weber is a scientist at the University of Duisburg-Essen with a research focus on digitalization, artificial intelligence, price, promotion and assortment management, and transformation management. At the Chair of Information Systems and Integrated Information Systems, he is the founder of the Retail Artificial Intelligence Lab (retAIL) and at the same time a senior consultant for SAP systems in wholesale and retail. He thus combines current practice with scientific research in this subfield.Business Analytics - Artificial Intelligence - AI and BA platforms - Technology framework and procedure model as reference - Case studies on the use of AI-based Business Analytics
Beginning Azure Functions
Start creating highly scalable apps and monitoring your Azure functions in production using Azure Functions 4.0. This book thoroughly explains durable functions for statefulness, covering the basics all the way through how to create bindings in durable functions. It’s a deep dive into the Azure Functions serverless API and will guide you through the process of converting monolithic applications to use Azure Functions.This updated edition is revised to cover changes to Azure Portal and delves into Azure Functions runtime versions, the Isolated Process model, and offers a comparison of Azure Functions and Azure Logic Apps. You’ll also learn how to register binding extensions and gain an introduction to Azure Functions binding expression patterns, along with best practices for using Azure Functions. Beginning Azure Functions will provide you with the foundational knowledge to work with Azure Functions and teach you practical skills, such as how to create Azure Functions using different triggers and bindings. You’ll also see how to monitor your Azure Functions in production with live monitoring, and how to perform remote debugging and how to secure your functions.Upon completing this book, you’ll understand Azure Functions and how to create them using the Azure portal and Visual Studio.WHAT YOU WILL LEARN* Use triggers and bindings in an Azure function * Create a serverless API using Azure Functions * Understand durable Azure functions, including scalability, disaster recovery, and geo-distribution* Deploy Azure Function and monitor it in productionWHO THIS BOOK IS FORDevelopers who want to get started with Azure Functions, as well as DevOps developers, who are looking for guidance in how to deploy and monitor functions.RAHUL SAWHNEY works as a software developer with Microsoft, India, and has more than five years of experience delivering cloud solutions using technologies such as .NET Core, Azure Functions, microservices, AngularJS, Web API, Azure AD, Azure Storage, ARM templates, App Service, Traffic Manager, and more. He is a Microsoft Certified Azure Developer and Architect. He loves learning new technologies and is passionate about Microsoft technologies. In his free time, he loves playing table tennis, watching movies, and reading books.KALYAN CHANUMOLU is a Senior Technical Program Manager at Microsoft. He works on building the engineering systems that power the world's computer - Azure. He is a technical reviewer for books on ASP.Net Blazor, Microservices etc. and is extremely passionate about distributed systems and cloud computing. He has vast experience in software development, consulting, and migrating large customer workloads to the cloud. He loves cycling, swimming and reading books.CHAPTER 1: INTRODUCTION TO AZURE FUNCTIONSCHAPTER GOAL: INTRODUCTION TO BOOK AND TOPICS TO BE COVEREDNO OF PAGES 5-10SUB -TOPICS1. Overview of serverless architecture2. Overview of Azure Function3. Azure Functions Runtime Versions4. Azure Function Vs Azure Web Jobs.5. Azure Functions vs Azure Logic Apps6. Azure Functions Pricing PlanCHAPTER 2: CREATING AZURE FUNCTIONCHAPTER GOAL: THIS CHAPTER COVERS THE BASIC OF AZURE FUNCTION AND TAKES AUDIENCE THROUGH CREATING THEIR FIRST AZURE FUNCTIONNO OF PAGES: 10 - 20SUB - TOPICS1. Creating Azure Function Using Azure Portal2. Creating Azure Function Using Visual Studio3. File Hierarchy, Configuration & Settings in Azure FunctionsCHAPTER 3: UNDERSTANDING AZURE FUNCTIONS TRIGGERS AND BINDINGSCHAPTER GOAL: TO UNDERSTAND TRIGGERS AND BINDINGS IN AZURE FUNCTIONNO OF PAGES : 20-30SUB - TOPICS:1. Overview of Trigger and Bindings2. Azure Functions3. Register Binding Extensions4. Azure Functions Binding Expression patterns5. Creating a Blob Storage Triggered Azure FunctionCHAPTER 4: SERVERLESS API USING AZURE FUNCTIONCHAPTER GOAL: THIS CHAPTER TAKES AUDIENCE THROUGH CREATING SERVERLESS API’S AND ALSO, MIGRATING EXISTING APPLICATION TO AZURE FUNCTIONNO OF PAGES: 30-40SUB - TOPICS:1. Monolithic Architecture vs Microservice Architecture2. Converting Monolithic Applications to Highly Scalable API’s Using Azure Functions2. Creating Http Triggered Azure Function.3. Serverless API using Azure Functions and Azure Cosmos DBCHAPTER 5: SECURING AZURE FUNCTIONS WITH API MANAGEMENT1. Create API Management Instance2. Create API Management API3. Configure API management4. Verify the API in Azure.CHAPTER 6: AZURE DURABLE FUNCTIONS FOR STATEFULNESSCHAPTER GOAL: This chapter covers Durable Functions in AzureNO OF PAGES: 40-50SUB - TOPICS:1. Overview Of Durable Function2. Bindings for Durable Function3. Performance and Scalability of Durable Functions4. Creating Durable Functions Using Azure Portal5. Disaster Recovery & Geo-Distribution of Durable FunctionsCHAPTER 7: DEVOPS FOR AZURE FUNCTIONSCHAPTER GOAL: This chapter takes you through the deployment process of Azure FunctionNO OF PAGES: 20-30SUB - TOPICS:1. Deploying Azure Function Using Continuous Deployment3. Configuring Your Azure Functions4. Build and deploy using Azure Pipelines5. Build and deploy using Github Actions6. Automate Deployment of Function App in Azure FunctionsCHAPTER 8: GETTING FUNCTIONS PRODUCTION-READYCHAPTER GOAL: To understand how to monitor Azure Functions in ProductionNO OF PAGES: 20-30SUB - TOPICS:1. Using Built-In Logging2. Using Application Insights to Monitor Azure Functions3. Securing Azure Function4. Configuring CORS for Azure FunctionCHAPTER 9: BEST PRACTICES OF WORKING WITH AZURE FUNCTIONSCHAPTER GOAL: Making users know about the best practices to follow while developing Azure FunctionsNO OF PAGES: 20-30SUB - TOPICS:1. Organize your functions2. Write robust functions3. Maximize Availability4. Build in redundancyCHAPTER 10: CHOOSING THE BEST AZURE SERVERLESS TECHNOLOGY FOR YOUR BUSINESSChapter Goal: In this chapter we will briefly talk about the Serverless Universe in Azure and which serverless technology suites which scenario’sNO OF PAGES: 20-30
Internet-Modellierung mit Julia
Das Buch verbindet die Internetmodellierung mit der neuen Programmiersprache Julia. Die Eignung von Julia für die Modellierung sowohl etablierter Internet-Modelle als auch für forschungsnahe Themen wie die Car-to-Infrastructure-Kommunikation und von Blackbox-Modellen für Lastprognosen mit neuronalen Netzen wird vermittelt. Nach dem Studium des Buches und den Anregungen für weitere selbständige Analysen ist der Leser in der Lage, auch komplexere Modellierungsaufgaben in Forschung und Entwicklung mit Julia zu bearbeiten. ULRICH HOFMANN hat über 30 Jahre in Wirtschaft, Lehre und Forschung am Thema der Internet-Technologien mit den Schwerpunkten QoS (Quality of Service) gearbeitet. Einleitung.- Leistungsparameter, Optimierung Ressourceneinsatz.- Modellmodule.- Lastgeneratoren.- Bedienmodule.- Simulation von Bediensystemen.- Simulationsbasierte Optimierung mit KI.
Beginning Database Design Solutions
A CONCISE INTRODUCTION TO DATABASE DESIGN CONCEPTS, METHODS, AND TECHNIQUES IN AND OUT OF THE CLOUDIn the newly revised second edition of Beginning Database Design Solutions: Understanding and Implementing Database Design Concepts for the Cloud and Beyond, Second Edition, award-winning programming instructor and mathematician Rod Stephens delivers an easy-to-understand guide to designing and implementing databases both in and out of the cloud. Without assuming any prior database design knowledge, the author walks you through the steps you’ll need to take to understand, analyze, design, and build databases.In the book, you’ll find clear coverage of foundational database concepts along with hands-on examples that help you practice important techniques so you can apply them to your own database designs, as well as:* Downloadable source code that illustrates the concepts discussed in the book* Best practices for reliable, platform-agnostic database design* Strategies for digital transformation driven by universally accessible database designAn essential resource for database administrators, data management specialists, and database developers seeking expertise in relational, NoSQL, and hybrid database design both in and out of the cloud, Beginning Database Design Solutions is a hands-on guide ideal for students and practicing professionals alike.ROD STEPHENS is a professional programmer, sought-after technical speaker, instructor, and author. He’s written 37 books and over 250 magazine articles on C#, Java, and other programming languages. He runs the popular C# Helper and VB Helper websites which have helped millions of programmers with tips, tricks, and useful example code. Introduction xxvPART 1: INTRODUCTION TO DATABASES AND DATABASE DESIGNChapter 1: Database Design Goals 3Chapter 2: Relational Overview 29Chapter 3: NoSQL OVERVIEW 47PART 2: DATABASE DESIGN PROCESS AND TECHNIQUESChapter 4: Understanding User Needs 83Chapter 5: Translating User Needs Into Data Models 111Chapter 6: Extracting Business Rules 145Chapter 7: Normalizing Data 163Chapter 8: Designing Databases to Support Software 203Chapter 9: Using Common Design Patterns 215Chapter 10: Avoiding Common Design Pitfalls 241PART 3: A DETAILED CASE STUDYChapter 11: Defining User Needs and Requirements 263Chapter 12: Building a Data Model 283Chapter 13: Extracting Business Rules 303Chapter 14: Normalizing and Refining 313PART 4: EXAMPLE PROGRAMSChapter 15: Example Overview 327Chapter 16: MariaDB IN PYTHON 339Chapter 17: MariaDB IN C# 355Chapter 18: PostgreSQL IN PYTHON 369Chapter 19: PostgreSQL IN C# 389Chapter 20: Neo4j AuraDB IN PYTHON 401Chapter 21: Neo4j AuraDB IN C# 417Chapter 22: MongoDB ATLAS IN PYTHON 431Chapter 23: MongoDB ATLAS IN C# 453Chapter 24: Apache Ignite in Python 467Chapter 25: Apache Ignite in C# 477PART 5: ADVANCED TOPICSChapter 26: Introduction to Sql 489Chapter 27: Building Databases with Sql Scripts 519Chapter 28: Database Maintenance 533Chapter 29: Database Security 545Appendix A: Exercise Solutions 557Appendix B: Sample Relational Designs 649Glossary 671Index 683
Software Engineering
Das Handbuch fürs Selbststudium, für den Job oder vorlesungsbegleitend* erfahrungsbasierter Über- und Einblick ins Software Engineering, der sowohl die Theorie als auch die Praxis abdeckt* umfassend, verständlich und praxiserprobtDas Buch vermittelt die Grundlagen, Erfahrungen und Techniken, die den Kern des Software Engineerings bilden. Es ist als Material zu Vorlesungen über Software Engineering konzipiert. Auch für Praktiker, die mit der Softwareentwicklung und -bearbeitung und den dabei auftretenden Problemen vertraut sind, ist das Buch sehr gut geeignet, um die Kenntnisse im Selbststudium zu ergänzen und zu vertiefen. Der Inhalt des Buches ist in fünf Hauptteile gegliedert:- Grundlagen- Menschen und Prozesse- Daueraufgaben im Softwareprojekt- Techniken der Softwarebearbeitung- Verwaltung und Erhaltung von SoftwareAuch auf die Ausbildung zukünftiger Software Engineers wird eingegangen. Ergänzende Informationen sind auf der Webseite der Autoren verfügbar: https://se-buch.de.Prof. Dr. rer. nat. Jochen Ludewig geboren 1947 in Hannover. Studium der Elektrotechnik (TU Hannover) und Informatik (TU München); Promotion 1981. 1975 bis 1980 Gesellschaft für Kernforschung, Karlsruhe, dann Brown Boveri Forschungszentrum in Baden/Schweiz. 1986 Assistenzprofessor an der ETH Zürich, 1988 Ruf auf den neuen Lehrstuhl Software Engineering an der Universität Stuttgart. Arbeitsgebiete: Softwareprojekt-Management, Software-Prüfung und Software-Qualität, Software-Wartung. Ab 1996 Konzeption und Aufbau des Diplomstudiengangs Softwaretechnik, der inzwischen in einen Bachelor- und einen Masterstudiengang umgewandelt wurde. Seit 2009 Fellow der Gesellschaft für Informatik (GI). Prof. Dr. rer. nat. Horst Lichter geboren 1960 in Trier. Studium der Informatik und Betriebswirtschaftslehr (TU Kaiserslautern). Wissenschaftlicher Mitarbeiter (ETH Zürich und Universität Stuttgart), Promotion 1993. Anschließend Schweizerische Bankgesellschaft Zürich und ABB Forschungszentrum Heidelberg. 1998 Ruf an die RWTH Aachen University, Leiter des Lehr- und Forschungsgebiets Software-Konstruktion. Arbeitsgebiete: Software-Architektur, Qualitätssicherung, Software-Evolution. Seit 2005 Lecturer an der Thai German Graduate School of Engineering (TGGS) in Bangkok. Von 2018-2021 Adjunct Lecturer an der Universiti Teknologi Petronas (UTP) Malaysia.
Developing Web Components with Svelte
Leverage the power of Svelte to quickly produce the foundations of a framework-agnostic component library that can extend and develop over time. This is a project-oriented book that simplifies setting up the skeleton of the library and adding components, using little more than a text editor or free software.You'll gain a starting baseline that can be used to develop future projects or incorporated into an existing workflow. You'll take development to the next level and can use this knowledge to create components with any framework, such as React, Angular or Vue.js, not just Svelte. Developing Web Components with Svelte is an excellent resource for getting acquainted with creating and maintaining a component library using a phased approach. It takes the view that you don't have to create something complex and unwieldy. Instead, you can start building something quickly, then extend it as needs dictate over time, without sacrificing speed or features.You'll see how to develop cleaner components in a quick, clear and straightforward way. The components you create in this project can be made available in one of the world's most extensive component ecosystems to be usable by other frameworks, making them genuinely reusable. In short, Svelte offers plenty of opportunities as it is based on Node.js and JavaScript making Svelte a powerful package to work from.WHAT YOU'LL LEARN* Use the Svelte framework to rapidly create and deploy the foundation of a component library that is versatile and performant* Review developing and customizing components based on our needs* Work through a real-world project to help solidify skills learned from the book and put them into practiceWHO THIS BOOK IS FOR* Website developers, familiar with JavaScript, who are keen to learn how to leverage the Svelte framework fast* Agile development teams, where time is of the essence, and the pressure is on to deliver results quickly* Developers who want to focus on simplicity, to produce efficient and optimized content in modern browsers using tools readily availableALEX LIBBY is a frontend engineer and seasoned book author who hails from England. His passion for all things Open Source dates back to the days of his degree studies, where he first came across web development and has been hooked ever since. His daily work involves extensive use of React, NodeJS, JavaScript, HTML, and CSS; Alex enjoys tinkering with different open source libraries to see how they work. He has spent a stint maintaining the jQuery Tools library and enjoys writing about Open Source technologies, principally for front end UI development.1: Getting Started2: Creating Basic Components3: Building Action Components4: Building the Navigation Components5: Creating Notification Components6: Creating Grid Components7: Writing Documentation8: Documenting More Components9. Testing Components10: Deploying into Production11: Taking Things Further
Microsoft Power BI Data Analyst Certification Companion
Use this book to study for the PL-300 Microsoft Power BI Data Analyst exam. The book follows the “Skills Measured” outline provided by Microsoft to help focus your study. Each topic area from the outline corresponds to an area covered by the exam, and the book helps you build a good base of knowledge in each area. Each topic is presented with a blend of practical explanations, theory, and best practices.Power BI is more than just the Power BI Desktop or the Power BI Service. It is two distinct applications and an online service that, together, enable business users to gather, shape, and analyze data to generate and present insights. This book clearly delineates the purpose of each component and explains the key concepts necessary to use each component effectively. Each chapter provides best practices and tips to help an inexperienced Power BI practitioner develop good habits that will support larger or more complex analyses.Many business analysts come to Power BI with a wealth of experience in Excel and particularly with pivot tables. Some of this experience translates readily into Power BI concepts. This book leverages that overlap in skill sets to help seasoned Excel users overcome the initial learning curve in Power BI, but no prior knowledge of any kind is assumed, terminology is defined in non-technical language, and key concepts are explained using analogies and ideas from experiences common to any reader. After reading this book, you will have the background and capability to learn the skills and concepts necessary both to pass the PL-300 exam and become a confident Power BI practitioner.WHAT YOU WILL LEARN* Create user-friendly, responsive reports with drill-throughs, bookmarks, and tool tips* Construct a star schema with relationships, ensuring that your analysis will be both accurate and responsive* Publish reports and datasets to the Power BI Service, enabling the report (and the dataset) to be viewed and used by your colleagues * Extract data from a variety of sources, enabling you to leverage the data that your organization has collected and stored in a variety of sources* Schedule data refreshes for published datasets so your reports and dashboards stay up to date* Develop dashboards with visuals from different reports and streaming contentWHO THIS BOOK IS FORPower BI users who are planning to take the PL-300 exam, Power BI users who want help studying the topic areas listed in Microsoft’s outline for the PL-300 exam, and those who are not planning to take the exam but want to close any knowledge gaps they might haveJESSICA JOLLY, MCT, MCSE, DA-100, PL-100, PL-300, DP-500, is a Microsoft certified trainer who helps businesses, non-profits, and individuals improve their business intelligence skills, bit by byte. She runs her own business, ALT-Enter, LLC. Before her reinvention as an entrepreneur (after 50!), she worked for Unilever, a global consumer products company, for 27 years, in a variety of managerial roles. Her business practice focuses on data visualization tools, specifically Microsoft's Power BI platform. She is living proof that you can cry through every math class you ever had, and still fashion a career that focuses on data, charts, visuals, and code. When she is not training other adults, she is knitting and quilting (a refuge from all of the technology!), reading about the Civil War, swimming, gardening, biking, hiking, and canoeing.PART I. PREPARE TO STUDY1. Exam Overview2. PL-300 CoveragePART II. PREPARE THE DATA3. Get Data from Different Data Sources4. Clean, Transform, and Load the DataPART III. MODEL THE DATA5. Design a Data Model6. Develop a Data Model7. Create Model Calculations using DAX8. Optimize Model PerformancePART IV. VISUALIZE AND ANALYZE THE DATA9. Create Reports10. Enhance Reports11. Identify Patterns and TrendsPART V. DEPLOY AND MAINTAIN ASSETS12. Manage Files and Datasets13. Create Dashboards14. Manage WorkspacesPART VI. CONTINUE YOUR LEARNING15. Where Do You Go From Here?
Practical Highcharts with Angular
Learn to create stunning animated and interactive charts using Highcharts and Angular. This updated edition will build on your existing knowledge of HTML, CSS, and JavaScript to develop impressive dashboards that will work in all modern browsers.You will learn how to use Highcharts, call backend services for data, and easily construct real-time data dashboards so you can club your code with jQuery and Angular. This book provides the best solutions for real-time challenges and covers a wide range of charts including line, area, maps, plot, and much more. You will also learn about arc diagrams, bubble series, dependency wheels, and error bar series. After reading this book, you'll be able to export your charts in different formats for project-based learning.Highcharts is one the most useful products worldwide for developing charting on the web, and Angular is well known for speed. Using Highcharts with Angular developers can build fast, interactive dashboards. Get up to speed using this book today.WHAT YOU’LL LEARN* Create interactive animated styling themes and colors for a dashboard* Work on a real-time data project using Web API and Ajax calls through different data sources* Export charts in various formatsWHO THIS BOOK IS FORDevelopers, dev leads, software architects, students or enthusiasts who are already familiar with HTML, CSS, and JavaScript.Sourabh Mishra is an Entrepreneur, Developer, Speaker, International Author, Corporate Trainer, and Animator. He is a Microsoft guy; he is very passionate about Microsoft technologies and a true .Net Warrior. Sourabh started his career when he was just 15 years old. He’s loved computers from childhood. His programming experience includes C/C++, Asp.Net, C#, Vb.net, WCF, Sqlserver, Entity Framework, MVC, Web API, Azure, Jquery, Highcharts, and Angular. Sourabh has been awarded a Most Valuable Professional (MVP) status. He has the zeal to learn new technologies, sharing his knowledge on several online community forums.He is a founder of “IECE Digital” and “Sourabh Mishra Notes”, an online knowledge-sharing platform where one can learn new technologies very easily and comfortably.1. Getting Started with Highcharts.- 2. Concept of Highcharts.- 3. Integrating Highcharts with Angular.- 4. Different Charting Types.- 6. Working with Real-time Data.- 6. Themes and Additional Features in Highcharts.- 7. Building a Real-time Dashboard.
Beginning Database Design Solutions
A CONCISE INTRODUCTION TO DATABASE DESIGN CONCEPTS, METHODS, AND TECHNIQUES IN AND OUT OF THE CLOUDIn the newly revised second edition of Beginning Database Design Solutions: Understanding and Implementing Database Design Concepts for the Cloud and Beyond, Second Edition, award-winning programming instructor and mathematician Rod Stephens delivers an easy-to-understand guide to designing and implementing databases both in and out of the cloud. Without assuming any prior database design knowledge, the author walks you through the steps you’ll need to take to understand, analyze, design, and build databases.In the book, you’ll find clear coverage of foundational database concepts along with hands-on examples that help you practice important techniques so you can apply them to your own database designs, as well as:* Downloadable source code that illustrates the concepts discussed in the book* Best practices for reliable, platform-agnostic database design* Strategies for digital transformation driven by universally accessible database designAn essential resource for database administrators, data management specialists, and database developers seeking expertise in relational, NoSQL, and hybrid database design both in and out of the cloud, Beginning Database Design Solutions is a hands-on guide ideal for students and practicing professionals alike.ROD STEPHENS is a professional programmer, sought-after technical speaker, instructor, and author. He’s written 37 books and over 250 magazine articles on C#, Java, and other programming languages. He runs the popular C# Helper and VB Helper websites which have helped millions of programmers with tips, tricks, and useful example code. Introduction xxvPART 1: INTRODUCTION TO DATABASES AND DATABASE DESIGNCHAPTER 1: DATABASE DESIGN GOALS 3The Importance of Design 4Information Containers 6Strengths and Weaknesses of Information Containers 8Desirable Database Features 9Crud 10Retrieval 10Consistency 11Validity 11Easy Error Correction 12Speed 13Atomic Transactions 13Acid 14Base 16NewSQL 17Persistence and Backups 17Low Cost and Extensibility 18Ease of Use 19Portability 19Security 20Sharing 21Ability to Perform Complex Calculations 21CAP Theorem 22Cloud Considerations 22Legal and Security Considerations 23Consequences of Good and Bad Design 24Summary 26CHAPTER 2: RELATIONAL OVERVIEW 29Picking a Database 30Relational Points of View 31Table, Rows, and Columns 32Relations, Attributes, and Tuples 34Keys 34Indexes 36Constraints 37Domain Constraints 37Check Constraints 37Primary Key Constraints 38Unique Constraints 38Foreign Key Constraints 38Database Operations 40Popular RDBs 41Spreadsheets 43Summary 44CHAPTER 3: NOSQL OVERVIEW 47The Cloud 47Picking a Database 50NoSQL Philosophy 50NoSQL Databases 50Document Databases 51Key- Value Database 52Column- Oriented Databases 53Graph Databases 53Street Networks 54Communication Networks 55Social Media Apps 55E- Commerce Programs 55Algorithms 56Hierarchical Databases 56Less Exotic Options 59Flat Files 59XML Files 60XML Basics 61XML Practices 64XML Summary 66JSON Files 67Spreadsheets 69More Exotic Options 70Object 70Deductive 70Dimensional 70Temporal 71Database Pros and Cons 72Relational 72General NoSQL 73Quick Guidelines 74Summary 76PART 2: DATABASE DESIGN PROCESS AND TECHNIQUESCHAPTER 4: UNDERSTANDING USER NEEDS 83Make a Plan 84Bring a List of Questions 85Functionality 85Data Needs 86Data Integrity 86Security 87Environment 88Meet the Customers 88Learn Who’s Who 89Pick the Customers’ Brains 93Walk a Mile in the User’s Shoes 93Study Current Operations 94Brainstorm 94Look to the Future 95Understand the Customers’ Reasoning 96Learn What the Customers Really Need 97Prioritize 98Verify Your Understanding 99Create the Requirements Document 101Make Use Cases 102Decide Feasibility 106Summary 106CHAPTER 5: TRANSLATING USER NEEDS INTO DATA MODELS 111What Are Data Models? 112User Interface Models 114Semantic Object Models 118Classes and Objects 119Cardinality 120Identifiers 120Putting It Together 121Semantic Views 122Class Types 124Simple Objects 124Composite Objects 124Compound Objects 125Hybrid Objects 125Association Objects 126Inherited Objects 128Comments and Notes 129Entity- Relationship Models 130Entities, Attributes, and Identifiers 131Relationships 132Cardinality 133Inheritance 134Additional Conventions 136Comments and Notes 137Relational Models 137Converting Semantic Object Models 138Converting ER Diagrams 140Summary 142CHAPTER 6: EXTRACTING BUSINESS RULES 145What Are Business Rules? 145Identifying Key Business Rules 147Extracting Key Business Rules 152Multi- Tier Applications 154Summary 158CHAPTER 7: NORMALIZING DATA 163What Is Normalization? 163First Normal Form (1NF) 164Second Normal Form (2NF) 173Third Normal Form (3NF) 177Stopping at Third Normal Form 181Boyce- Codd Normal Form (BCNF) 181Fourth Normal Form (4NF) 185Fifth Normal Form (5NF) 190Domain/Key Normal Form (DKNF) 193Essential Redundancy 195The Best Level of Normalization 197NoSQL Normalization 197Summary 199CHAPTER 8: DESIGNING DATABASES TO SUPPORT SOFTWARE 203Plan Ahead 204Document Everything 204Consider Multi- Tier Architecture 205Convert Domains into Tables 205Keep Tables Focused 206Use Three Kinds of Tables 207Use Naming Conventions 209Allow Some Redundant Data 210Don’t Squeeze in Everything 211Summary 212CHAPTER 9: USING COMMON DESIGN PATTERNS 215Associations 216Many- to- Many Associations 216Multiple Many- to- Many Associations 216Multiple- Object Associations 218Repeated Attribute Associations 221Reflexive Associations 222One- to- One Reflexive Associations 223One- to- Many Reflexive Associations 224Hierarchical Data 225Hierarchical Data with NoSQL 228Network Data 229Network Data with NoSQL 231Temporal Data 232Effective Dates 232Deleted Objects 233Deciding What to Temporalize 234Logging and Locking 236Audit Trails 236Turnkey Records 237Summary 238CHAPTER 10: AVOIDING COMMON DESIGN PITFALLS 241Lack of Preparation 241Poor Documentation 242Poor Naming Standards 242Thinking Too Small 244Not Planning for Change 245Too Much Normalization 248Insufficient Normalization 248Insufficient Testing 249Performance Anxiety 249Mishmash Tables 250Not Enforcing Constraints 253Obsession with IDs 253Not Defining Natural Keys 256Summary 257PART 3: A DETAILED CASE STUDYCHAPTER 11: DEFINING USER NEEDS AND REQUIREMENTS 263Meet the Customers 263Pick the Customers’ Brains 265Determining What the System Should Do 265Determining How the Project Should Look 267Determining What Data Is Needed for the User Interface 268Determining Where the Data Should Come From 269Determining How the Pieces of Data Are Related 269Determining Performance Needs 271Determining Security Needs 272Determining Data Integrity Needs 273Write Use Cases 275Write the Requirements Document 279Demand Feedback 280Summary 281CHAPTER 12: BUILDING A DATA MODEL 283Semantic Object Modeling 283Building an Initial Semantic Object Model 283Improving the Semantic Object Model 286Entity- Relationship Modeling 289Building an ER Diagram 289Building a Combined ER Diagram 291Improving the Entity- Relationship Diagram 293Relational Modeling 294Putting It All Together 298Summary 299CHAPTER 13: EXTRACTING BUSINESS RULES 303Identifying Business Rules 303Courses 304CustomerCourses 306Customers 307Pets 307Employees 307Orders 307OrderItems 308InventoryItems 308TimeEntries 308Shifts 309Persons 309Phones 309Vendors 309Drawing a New Relational Model 310Summary 310CHAPTER 14: NORMALIZING AND REFINING 313Improving Flexibility 313Verifying First Normal Form 315Verifying Second Normal Form 318Pets 319TimeEntries 320Verifying Third Normal Form 321Summary 323PART 4: EXAMPLE PROGRAMSCHAPTER 15: EXAMPLE OVERVIEW 327Tool Choices 327Jupyter Notebook 329Visual Studio 331Database Adapters 332Packages in Jupyter Notebook 333Packages in Visual Studio 334Program Passwords 336Summary 336CHAPTER 16: MARIADB IN PYTHON 339Install MariaDB 340Run HeidiSQL 340Create the Program 343Install pymysql 344Create the Database 344Define Tables 346Create Data 348Fetch Data 350Summary 352CHAPTER 17: MARIADB IN C# 355Create the Program 355Install MySqlConnector 356Create the Database 356Define Tables 358Create Data 360Fetch Data 364Summary 366CHAPTER 18: POSTGRESQL IN PYTHON 369Install PostgreSQL 370Run pgAdmin 371Design the Database 371Create a User 371Create the Database 373Define the Tables 374Define the customers Table 374Define the orders Table 376Define the order_items Table 377Create the Program 378Install Psycopg 379Connect to the Database 379Delete Old Data 380Create Customer Data 380Create Order Data 382Create Order Item Data 383Close the Connection 384Perform Queries 384Summary 386CHAPTER 19: POSTGRESQL IN C# 389Create the Program 389Install Npgsql 389Connect to the Database 390Delete Old Data 391Create Customer Data 392Create Order Data 393Create Order Item Data 395Display Orders 396Summary 399CHAPTER 20: NEO4J AURADB IN PYTHON 401Install Neo4j AuraDB 402Nodes and Relationships 404Cypher 404Create the Program 405Install the Neo4j Database Adapter 405Action Methods 405delete_all_nodes 406make_node 407make_link 407execute_node_query 408find_path 409Org Chart Methods 410build_org_chart 410query_org_chart 411Main Program 412Summary 414CHAPTER 21: NEO4J AURADB IN C# 417Create the Program 418Install the Neo4j Driver 418Action Methods 419DeleteAllNodes 419MakeNode 420MakeLink 421ExecuteNodeQuery 422FindPath 422Org Chart Methods 423BuildOrgChart 424QueryOrgChart 424Main 426Summary 428CHAPTER 22: MONGODB ATLAS IN PYTHON 431Not Normal but Not Abnormal 432XML, JSON, and BSON 432Install MongoDB Atlas 434Find the Connection Code 436Create the Program 439Install the PyMongo Database Adapter 439Helper Methods 440person_string 440connect_to_db 441delete_old_data 442create_data 442query_data 444Main Program 449Summary 450CHAPTER 23: MONGODB ATLAS IN C# 453Create the Program 454Install the MongoDB Database Adapter 454Helper Methods 454PersonString 455DeleteOldData 456CreateData 457QueryData 458Main Program 462Summary 465CHAPTER 24: APACHE IGNITE IN PYTHON 467Install Apache Ignite 468Start a Node 468Without Persistence 469With Persistence 470Create the Program 470Install the pyignite Database Adapter 471Define the Building Class 471Save Data 471Read Data 473Demonstrate Volatile Data 473Demonstrate Persistent Data 474Summary 474CHAPTER 25: APACHE IGNITE IN C# 477Create the Program 477Install the Ignite Database Adapter 478The Main Program 479The Building Class 480The WriteData Method 480The ReadData Method 482Demonstrate Volatile Data 483Demonstrate Persistent Data 483Summary 483PART 5: ADVANCED TOPICSChapter 26: Introduction to Sql 489Background 491Finding More Information 491Standards 492Multistatement Commands 493Basic Syntax 495Command Overview 495Create Table 498Create Index 503Drop 504Insert 504Select 506SELECT Clause 506FROM Clause 507WHERE Clause 511GROUP BY Clause 511ORDER BY Clause 512Update 513Delete 514Summary 515CHAPTER 27: BUILDING DATABASES WITH SQL SCRIPTS 519Why Bother with Scripts? 519Script Categories 520Database Creation Scripts 520Basic Initialization Scripts 520Data Initialization Scripts 520Cleanup Scripts 521Saving Scripts 521Ordering SQL Commands 522Summary 531CHAPTER 28: DATABASE MAINTENANCE 533Backups 533Data Warehousing 537Repairing the Database 538Compacting the Database 538Performance Tuning 538Summary 542Chapter 29: Database Security 545The Right Level of Security 545Passwords 546Single- Password Databases 546Individual Passwords 546Operating System Passwords 547Good Passwords 547Privileges 548Initial Configuration and Privileges 553Too Much Security 553Physical Security 554Summary 555Appendix A: Exercise Solutions 557Appendix B: Sample Relational Designs 649Glossary 671Index 683
Expert Performance Indexing in Azure SQL and SQL Server 2022
Take a deep dive into perhaps the single most important facet of query performance—indexes—and how to best use them. Newly updated for SQL Server 2022 and Azure SQL, this fourth edition includes new guidance and features related to columnstore indexes, improved and consolidated content on Query Store, deeper content around Intelligent Query Processing, and other updates to help you optimize query execution and make performance improvements to even the most challenging workloads.The book begins with explanations of the types of indexes and how they are stored in a database. Moving further into the book, you will learn how statistics are critical for optimal index usage and how the Index Advisor can assist in reviewing and optimizing index health. This book helps you build a clear understanding of how indexes work, how to implement and use them, and the many options available to tame even the most large and complex workloads.WHAT YOU WILL LEARN* Properly index row store, columnstore, and memory-optimized tables* Make use of Intelligent Query Processing for faster query results* Review statistics to understand indexing choices made by the optimizer* Apply indexing strategies such as covering indexes, included columns, and index intersections* Recognize and remove unnecessary indexes* Design effective indexes for full-text, spatial, and XML data typesWHO THIS BOOK IS FORAzure SQL and SQL Server administrators and developers who are ready to improve the performance of their database environment by thoughtfully building indexes to speed up queries that matter the most and make a difference to the businessEDWARD POLLACK has over 20 years of experience in database and systems administration, architecture, and development, becoming an advocate for designing efficient data structures that can withstand the test of time. He has spoken at many events, such as SQL Saturdays, PASS Data Community Summit, Dativerse, and at many user groups and is the organizer of SQL Saturday Albany. Ed has authored many articles, as well as the following Apress books: Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server Analytics Optimization with Columnstore Indexes in Microsoft SQL Server: Optimizing OLAP Workloads; and a chapter in Expert T-SQL Window Functions in SQL Server. His first patent was issued in 2021, focused on the compression of geographical data for use by analytic systems.In his free time, Ed enjoys video games, sci-fi and fantasy, traveling, and baking. He lives in the sometimes-frozen icescape of Albany, NY, with his wife Theresa and sons Nolan and Oliver, and a mountain of (his) video game plushies that help break the fall when tripping on (their) toys.JASON STRATE is a database architect and administrator with more than 15 years of experience. He has been a recipient of Microsoft's Most Valuable Professional designation for SQL Server since July 2009. His experience includes design and implementation of both OLTP and OLAP solutions, as well as assessment and implementation of SQL Server environments for best practices, performance, and high availability solutions. He is a SQL Server MCITP and participated in the development of Microsoft Certification exams for SQL Server 2008.Jason is actively involved with his local PASS chapter (SQL Server User Group) and serves as its director of program development. He worked with the board to organize the PASSMN SQL Summit 2009 for the local community. He enjoys helping others in the SQL Server community and does this by presenting at technical conferences and user group meetings. Most recently, he has presented at the SSWUG Virtual Conferences, TechFuse, numerous SQL Saturdays, and at PASSMN user group meetings.Jason is a contributing author for the Microsoft whitepaper on "Empowering Enterprise Solutions with SQL Server 2008 Enterprise Edition." He is an active blogger with a focus on SQL Server and related technologies.1. Index Fundamentals2. Index Storage Fundamentals3. Examining Index Contents4. Fragmentation5. Index Metadata and Statistics6. XML Indexes7. Spatial Indexing8. Indexing Memory-Optimized Tables9. Full-Text Indexing10. Indexing Myths and Best Practices11. Index Maintenance12. Indexing Tools13. Indexing Strategies14. Query Strategies15. Monitoring Indexes16. Index Analysis17. Indexing Methodology
Building With Ethereum
Build products on top of Ethereum's new and expansive technological stack.Writing any good web application requires planning, care, and deft technical skills, but Ethereum's execution model presents its own challenges for engineers wishing to build applications on top of its smart contract layer. Building performant and engaging product experiences is one of the most important – and often underappreciated – roles in any company.This book looks at the full product stack needed to build such experiences on top of Ethereum smart contracts, weaving tutorials and case studies through more conversational discussions of the various constraints, trade-offs, and complexities involved in doing so. You’ll learn about the fundamentals of Ethereum from a new perspective, developing a strong understanding of how the Ethereum Virtual Machine (EVM) works and how it affects product engineering, as well as all the pieces of technology that go into decentralized apps (dapps) behind the front end: RPC nodes, wallets, indexers, application hosts, and more. You’ll be exposed to plenty of UI, JavaScript code, and idiomatic ways to bring on-chain data into your front ends. And you’ll be given up-to-date knowledge of the best practices and future possibilities that decentralized computation might offer the product engineer.WHAT YOU WILL LEARN* Understand the EVM and how it works* Gain insight into smart contracts and how apps connect to them* Understand the difference between live data and indexed data* How decentralization affects the UI of applications* Build engaging, tasteful product experiences on top of EthereumWHO THIS BOOK IS FORA confident – mid-level or senior – software engineer or web developer who hasn’t properly branched out into Ethereum; someone who might have scratched the surface, but wants a deeper understanding of the principles behind dapps, and who wants a head start on the hurdles faced while building them.JAMIE RUMBELOW is a software engineer and writer based in London, U.K. Until recently, he was a product engineer at Fei Labs, a major Ethereum protocol, where he built technologies and products at the intersection between the web2 and web3 stacks. He worked as a Founding Engineer and Senior Software Engineer in startups, responsible for training and mentoring as well as writing code. He has worked in the tech industry for over a decade, seeing organizations at varying levels of scale and the ways that teams and technologies get shaped by product decisions. He has also studied philosophy at the graduate level, which has given him the tools to think about computing in a deeper way. Over the past few years, he has built up a set of principles and opinions on what makes for great software and a great engineering culture.CHAPTER 1. INTRODUCTIONWe introduce the core concepts discussed in the book, and situate them with respect to the foundational principles of cryptocurrencies and web3. We discuss decentralisation. We describe the key design decisions of the EVM (Ethereum Virtual Machine) and how they raise some problems for product engineers. We describe the book ahead and what will be covered, chapter by chapter.CHAPTER 2. THE LIFECYCLE OF AN ETHEREUM TRANSACTIONWe discuss the lifecycle of a request on Ethereum, guiding the user through: how is a request initiated by a UI and confirmed by a user; sent to a node, validated, how can UIs display its status, when is a transaction confirmed. We ask: what is a smart contract? We frame smart contracts as APIs. We also set up the following three chapters with the tripartite structure of write, read, and side-effect.CHAPTER 3. WALLETSWe discuss the role of wallets as both stores and signers. We discuss the popular MetaMask model for wallet injection, WalletConnect, EIP-1193, and other attempts to standardise the wallet interface. We explore wallets as identities, and describe approaches to 'logging in' with Ethereum. We explore different attack vectors that integrating wallets might raise.CHAPTER 4. NODES AND INDEXESWe talk about nodes – the programmatic gateway to the blockchain – in more detail: how to connect to them and use them to retrieve information. We discuss the difference between live data and indexed data. We discuss how external RPC nodes allow external function calls with and friends. We discuss ABIs and contract interfaces.CHAPTER 5. EVENTSWe investigate Ethereum's event model, and how to reconstruct a contract's state from the event log. We talk about Bloom filters and how to process many events efficiently.CHAPTER 6. TRANSACTIONSThis chapter builds more on the first chapter, diving into detail about the implementation of transactions. We discuss interfaces for creating, signing, and viewing transactions. We frame transactions theoretically and practically. We discuss the RPC call and its interface. We break down the minutiae of cryptographic signing and nonces, and consider how it affects the UI of applications. We discuss transaction statuses and estimation.CHAPTER 7. ERROR HANDLINGIn this chapter, we discuss the various failure modes of smart contracts and how to build rich, useful user interfaces around them. We consider gas, nonces, and transaction synchronisation. We talk about ways of building error-resilience into your product with input validation. We talk about standardising error messages at the smart contract level.CHAPTER 8. TOOLINGIn this chapter, we investigate the sorts of tools available to the product engineer, drawing on problems faced in the previous chapters. We discuss running manual tests, declarative provisioning of infrastructure, and keeping private keys safe. We also discuss current lacunas and places where existing tooling could be improved.CHAPTER 9. DATA-FIRST APPLICATIONSWe wrap-up the preceding discussion with a more opinionated chapter on a data-first approach to application design. In particular, I'll make the case for single-page applications backed by a data scraper as a strong model for building application infrastructure around smart contracts, tying together the themes of the preceding few chapters.CHAPTER 10. CONCLUSION: SMART CONTRACTS, SMARTER PRODUCTSWe discuss the ways that the surface area of smart contracts rubs against the surface area of web applications, with an emphasis on the more commercial and conceptual. We explore how detaching state from interface allows for more decentralised and censorship-resistant protocols – and how product engineers can profit from this split. We talk about the many ways that thoughtful product engineering can improve the user experience of crypto, and ruminate on the future direction of the ecosystem.Appendix 1: A Common-Sense Crypto-Native ChecklistWe provide a summary of the main questions and action points found in the book, with an easy reference checklist for engineers to work through when building their crypto-native applications.Appendix 2: Resources and BibliographyWe provide one or two pages of QR codes, with links to relevant resources. We provide a more comprehensive, traditional bibliography.
Modern Oracle Database Programming
Level up your skill set to the latest that Oracle Database can offer. This book introduces features that are not well known that can transform your development efforts. You’ll discover built-in functionality that can save you massive amounts of time that otherwise would be spent reinventing the wheel. You’ll find that what used to take a lot of programming some years ago can be done with less code in a more reliable way today. Anyone using Oracle Database without the knowledge in this book is leaving valuable functionality–that their company has paid for–on the table, and this book opens the door to that functionality so that you can deliver reliable and performant solutions faster and more easily than ever.Part I looks at features in SQL and PL/SQL that are underused and not well known. You’ll learn about new join types, pattern matching across rows, Top N pagination (useful in reporting!), qualified expressions, and enhancements to iterators that reduce code complexity and make your logic easier to understand.Part II covers how and when to invoke PL/SQL from SQL while maintaining performance. You'll learn about SQL macro functions for creating reusable SQL fragments, polymorphic table functions with return types determined by incoming argument types, and constructing and parsing JSON documents for data interchange with other systems.Part III introduces a vast array of built-in functionality that Oracle provides that is just waiting to be used. Edition-based redefinition enables zero-downtime application and schema upgrades. Data redaction enables easier compliance with privacy laws and similar regulations by protecting sensitive data from those who have no need to see it. Virtual private databases provide the appearance of giving each user their own database, again helping to secure sensitive data. These features are just a taste of what the book provides. Soon you’ll be improving your skills and wondering why you ever worked so hard to solve problems that Oracle Database already solves for you.WHAT YOU WILL LEARN* Write more powerful code by incorporating underused features in SQL and PL/SQL* Optimize your integration between SQL and PL/SQL for best performance* Take advantage of enhanced set operators, lateral joins, row-based pattern matching, and other advanced features in SQL* Make your code easier to understand through your use of newer PL/SQL features, such as qualified expressions and iterator enhancements* Integrate with web services and external data sources directly from the database* Create and parse JSON documents for easy data exchange and flexible schema designWHO THIS BOOK IS FORAny developer who is writing SQL or PL/SQL, PL/SQL experts who want to level up their knowledge and skills to the latest features that Oracle Database provides, and developers who don’t want to write their own solutions only to find out later that they’ve wasted their time by building something that Oracle Database provides out of the boxALEX NUIJTEN is an independent consultant specializing in Oracle database development with PL/SQL and Oracle Application Express (APEX). Besides his consultancy work, he conducts training classes in APEX, SQL, and PL/SQL. He is a speaker at numerous international conferences, such as ODTUG, Oracle Open World, HrOUG, UKOUG, IOUG, OUGF, BGOUG, NLOUG APEX World, OBUG, and many more. He has received several Best Speaker awards and writes at regular intervals about Oracle Application Express and Oracle database development on his blog "Notes on Oracle." He is co-author of Oracle APEX Best Practices and Real World SQL and PL/SQL. Because of his contributions to the Oracle community, Alex was awarded the Oracle ACE Director membership in August 2010.PATRICK BAREL is a PL/SQL developer for Qualogy in The Netherlands. Besides working with SQL and PL/SQL Developer, he has written different plug-ins for PL/SQL. He publishes articles on his own blog and on the Qualogy blog. He is a speaker at international conferences, such as ODTUG, UKOUG, AUSOUG, NZOUG, IOUG, OUGN, NLOUG, DOUG, HrOUG, and many more. Patrick was awarded the Oracle ACE membership. In 2015, he received the Oracle Developer Choice Award in the PL/SQL Category. In 2019, he was promoted to Oracle ACE Director.IntroductionPART I. THE ADVANCED BASICS1. Underutilized Functionality and Enhancements2. Analytic Functions, Model, and Pivoting3. Joins4 Finding Patterns5. Pagination and Set Operators6. Conditional Compilation7. Iterations and Qualified ExpressionsPART II. MULTIPLE TECHNIQUES AND LANGUAGES8. SQL Macro and Polymorphic Table Functions9. Subquery Factoring, the WITH Clause Explained10. Calling PL/SQL from SQL11. Storing JSON in the Database12. Creating and Parsing JSON in SQL13. Creating and Parsing JSON in PL/SQLPART III. ORACLE-PROVIDED FUNCTIONALITY14. Comparing and Manipulating JSON15. Useful APEX Packages16. Processing Data in the Background17. Introspecting PL/SQL18. See What You Need to See19. Upgrade your Application with Zero Downtime20. Choosing the Right Table
AWS for Public and Private Sectors
Assess, plan, develop, implement, and manage AWS EC2 Instances, Cloud Formation using JSON Template with Bash programming language, and Cloud Watch monitoring. This book helps the public and private sectors comprehend how to assess and evaluate AWS cloud software as a service (SaaS), infrastructure as a service (IaaS), and platform as a service (PaaS).Government and business sector entities are looking for strategies to upgrade on-premises information systems to virtual cloud infrastructure orchestration and automation. You'll gain a step-by-step approach to planning, developing, implementing, and managing cloud infrastructure, services, and platforms that help reduce cost increases, scalability, and improves security. Outline your strategy to research how cloud infrastructure is planned and developed before being deployed and managed by on-premises IT team members. This book also supports cloud services for AWS and helps you understand why supporting and using AWS for cloud services is beneficial both short and long-term.Once you complete this book, you'll be able to make logical decisions regarding AWS use cases for public and private sector entities, including disaster recovery and backup, IT self-service, Web applications, and messaging.WHAT YOU'LL LEARN* Assess different cloud services provided by Amazon* Look at Cloud as a Service (CAAS)* Understand internet protocol, packet switching, authoritative, recursive, and open-flow* Review cloud infrastructure planning methods* Examine Cloud orchestration and automation* Work with the AWS total cost of ownership calculatorWHO THIS BOOK IS FORThis book is aimed at business, government, non-profit organizations, academic institutions, and financial institutions interested in upgrading to AWS cloud architect infrastructure as a primary mode of data transmission, storage, and security at a scalable and economical annual cost.BRADLEY FOWLER has worked in the technology industry since 2012, when he became Webmaster for the American Alliance of Paralegals, Inc. In 2015, Bradley became co-owner of Construction eMarketing a Web site development and eMarketing company that provides services remotely, including Cybersecurity Analysis, Web Page security integration, and cloud computing architecture consulting.Bradley earned a Master of Science in Cloud Computing Architecture from the University of Maryland Global Campus-Cum Laude, where he began working with BalletOnline as the Intern Cloud Architect, and climbed up to become Chief Cloud Architect. Bradley also earned a Master of Public Policy in Cybersecurity Policy from American Public University System-Summa Cum Laude, a Master of Science in Cybersecurity, and a Master of Science in Managing Information Systems in Information Security Management, both from Bellevue University, both Summa Cum Laude. Bradley acquired his Bachelor of Arts in eMarketing from the University of Arizona Global Campus. He is currently completing a Master of Science in Technology Management at University of Arizona Global Campus as well as a Doctor of Management in Information Systems & Technology at University of Phoenix.Chapter I Cloud Services and TechnologiesChapter goal: This chapter enables readers to understand the value of assessing and evaluating cloud services provided by Amazon Web Services (AWS) and Microsoft Azure, prior to making an executive decision to partner with either service provider. Readers will comprehend how to calculate the total cost of ownership for usage of cloud services rendered by both service providers, and acquire knowledge of the advantages and disadvantage of services rendered by both services providers. Readers will also acquire knowledge of applicable laws regarding usage of cloud services in alignment with federal laws and guidelines as well as gain knowledge regarding policy enforcement mechanisms, system monitoring and audit mechanisms, and finally complete discussion questions that help readers comprehend their study of this chapter and the valued components that should be remembered.Sub-topics:1. Total Cost of Ownership2. Functional requirements3. Nonfunctional requirements4. Risk analysis and management guidelines5. Six components of GDPR6. Understand physical security issues7. Critical IT requirements related to data storage8. Potential privacy issues and migration strategiesChapter 2: Network EngineeringChapter goal: This chapter helps readers gain knowledge about Internet protocol and its impact in cloud architecture. Readers will also learn about packet switching, IP addressing, DNS, IP subnetting, IP address classes, CIDR Notation, multiple subnets in a LAN, subnetting proposal, Transport Control Protocol (TCP), transport reliability, TCP sliding windows, software defined networking, networking in the cloud, cloud command line interfaces, and cloud APIs. Having this knowledge helps improve decision making regarding what strategies best serve the needs of an enterprise migrating from an on-premises legacy information system to a cloud infrastructure. By the time readers conclude this chapter, they will understand the meaning of internet protocol, packet switching, authoritative, recursive, and what makes open-flow so popular. Most importantly, readers acquire knowledge about subnetting proposals and their role in supporting enterprises.Subtopics:1. TCP Connections2. SDN Enables BalletOnline Cloud Deployment3. Declarative resource definitions4. AWS Migration Environment and Configure Web ServicesChapter 3: Infrastructure Planning and MigrationChapter goal: This chapter will educate readers about cloud infrastructure planning methods that increase organizational structure that aligns with business acumen and helps readers understand migration prerequisites. This enables a reduction of setbacks arises during the migration from on-premises to cloud infrastructure. Furthermore, readers will be able to effectively assess migration tools and comprehend AWS Application Discovery. Most important, readers will acquire methods that have proven beneficial and provides a return on the initial investment.Sub-topics:1. Cloud premigration considerations2. Cloud migration tool assessment3. AWS Application Discovery Services4. Agentbase options5. Agentless options6. Evaluation of discovery application and infrastructure data7. Migration recommendationsChapter 4: Computing Development and ManagementChapter goal: Readers will gain knowledge about cloud service offering for email and how AWS services help reduce concerns of vulnerability. Readers will also learn about AWS Cloud Watch and how this tool helps capture metrics and reports statistics regarding the consumption for backup and archiving. Additionally, readers will learn about AWS backup and archiving as well as AWS virtual private cloud and the value of relying on VPN (Virtual Private Networks). Furthermore, readers will attain information about AWS S3 buckets and cloud synchronization services.Subtopics:1. Data Backups and Archiving to Cloud Using Cloud Sync Services2. AWS Cloud Watch Monitoring3. AWS Service Catalog4. Cloud operations end-users’ guides5. Cloud operations administrative guides6. LimitationsChapter V Cloud Computing Orchestration and AutomationChapter goals: This chapters prepares readers for the orchestration and automation of AWS cloud services. Readers will also learn about cloud advanced features as well as advanced data solutions in the cloud. Most importantly, readers will acquire knowledge about Symantec Cloud Workload Protection for Storage Overview. Attaining this knowledge will increase readers trust with AWS services and the ability to effectively manage their cloud virtual private infrastructure with security strategies that are impenetrable.Subtopics:1. Monthly cost analysis2. Total costs of ownership analysis3. Use casesa. Web applicationsb. Messagingc. Disaster recovery and backupd. IT service planning4. Return on investment analysisGlossaryIndex