- Table View
- List View
Pro Microservices in .NET 6: With Examples Using ASP.NET Core 6, MassTransit, and Kubernetes
by Sean Whitesell Rob Richardson Matthew D. GrovesKnow the fundamentals of creating and deploying microservices using .NET 6 and gain insight from prescriptive guidance in this book on the when and why to incorporate them.The microservices architecture is a way of distributing process workloads to independent applications. This distribution allows for the independent applications to scale and evolve separately. It also enables developers to dismantle large applications into smaller, easier-to-maintain, scalable parts. While the return is valuable and the concept straightforward, applying it to an application is far more complicated. Where do you start? How do you find the optimal dividing point for your app, and strategically, how should your app be parceled out into separate services?Pro Microservices in .NET 6 will introduce you to all that and more. The authors get you started with an overview of microservices, .NET 6, event storming, and domain-driven design. You will use that foundational information to build a reference application throughout the book. From there, you will create your first microservice using .NET 6 that you can deploy into Docker and Azure Kubernetes Service. You will also learn about communication styles, decentralizing data, and testing microservices. Finally, you will learn about logging, metrics, tracing, and use that information for debugging. What You Will LearnBuild a foundation of basic microservices architecture design Follow an example of using event storming and domain-driven design to understand the monolithic application modified for microservicesUnderstand, via detailed commands, how Docker is used to containerize applicationsGet an overview of creating microservices from a monolithic application Call microservices using RPC and messaging communication styles with MassTransitComprehend decentralizing data and handling distributed transactionsUse Azure Kubernetes Service to host and scale your microservices Know the methods to make your microservices more robust Discover testing techniques for RPC and messaging communication styles Apply the applications you build for actual use Practice cross-cutting concerns such as logging, metrics, and tracing Who This Book Is ForDevelopers and software architects. Readers should have basic familiarity with Visual Studio and experience with .NET, ASP.NET Core, and C#.
Pro Microsoft HDInsight
by Debarchan SarkarPro Microsoft HDInsight is a complete guide to deploying and using Apache Hadoop on the Microsoft Windows Azure Platforms. The information in this book enables you to process enormous volumes of structured as well as non-structured data easily using HDInsight, which is Microsoft's own distribution of Apache Hadoop. Furthermore, the blend of Infrastructure as a Service (IaaS) and Platform as a Service (PaaS) offerings available through Windows Azure lets you take advantage of Hadoop's processing power without the worry of creating, configuring, maintaining, or managing your own cluster. With the data explosion that is soon to happen, the open source Apache Hadoop Framework is gaining traction, and it benefits from a huge ecosystem that has risen around the core functionalities of the Hadoop distributed file system (HDFS(tm)) and Hadoop Map Reduce. Pro Microsoft HDInsight equips you with the knowledge, confidence, and technique to configure and manage this ecosystem on Windows Azure. The book is an excellent choice for anyone aspiring to be a data scientist or data engineer, putting you a step ahead in the data mining field. Guides you through installation and configuration of an HDInsight cluster on Windows Azure Provides clear examples of configuring and executing Map Reduce jobs Helps you consume data and diagnose errors from the Windows Azure HDInsight Service What you'll learn Create and Manage HDInsight clusters on Windows Azure Understand the different HDInsight services and configuration files Develop and run Map Reduce jobs using . NET and PowerShell Consume data from client applications like Microsoft Excel and Power View Monitor job executions and logs Troubleshoot common problems Who this book is for Pro Microsoft HDInsight: Hadoop on Windows is an excellent choice for developers in the field of business intelligence and predictive analysis who want that extra edge in technology on Microsoft Windows and Windows Azure platforms. The book is for people who love to slice and dice data, and identify trends and patterns through analysis of data to help in creative and intelligent decision making. Table of Contents Introducing HDInsight Understanding Windows Azure HDInsight Service Provisioning Your HDInsight Service Cluster Automating HDInsight Cluster Provisioning Submitting Jobs to Your HDInsight Cluster Exploring the HDInsight Name Node Using Windows Azure HDInsight Emulator Accessing HDInsight over Hive and ODBC Consuming HDInsight from Self-Service BI Tools Integrating HDInsight with SQL Server Integration Services Logging in HDInsight Troubleshooting Cluster Deployments Troubleshooting Job Failures
Pro Microsoft Hyper-V 2019: Practical Guidance And Hands-on Labs
by Andy Syrewicze Richard SiddawaySuccessfully create and manage your Hyper-V environment without any of the marketing fluff. This book's lab-driven, hands-on approach will get you up and running as quickly and efficiently as possible.Virtualization is the cornerstone of today’s data center. As a modern-day IT pro, you are required to manage environments that are in a regular state of flux and increasing in both size and complexity. To keep up, you need practical information in a format that is succinct, yet comprehensive and highly applicable.Pro Hyper-V 2019 breaks down critical and time-saving topics into a series of easy-to-digest chapters, showing you how to perform Hyper-V management tasks using both GUI and PowerShell-based tools. Building on your existing knowledge of Windows Server management, Active Directory, networking, and storage, experts and Microsoft MVPs Syrewicze and Siddaway begin with a foundation of why computing workloads are virtualized. This is followed by chapters covering the range of management tasks associated with virtualized environments, including: managing hosts and guest machines; networking, storage, and high availability (host and guest); disaster recovery and virtual machine migration; and monitoring. What You'll LearnApply practical information to administer your Hyper-V environmentsUnderstand multiple administration styles (GUI, command line, and automation)Written by IT pros for IT pros – just the information you really need without the paddingAdminister and use containersUtilize hands-on labs to learn about storage, networking, and high availability Who This Book Is For IT administrators tasked with implementing Hyper-V environments or migrating from VMware. IT pros joining a team that is responsible for managing Hyper-V and “lone administrators” covering the gamut in smaller organizations will also find this book indispensable.
Pro Microsoft Power BI Administration: Creating a Consistent, Compliant, and Secure Corporate Platform for Business Intelligence
by Michael Johnson Ásgeir GunnarssonManage Power BI within organizations. This book helps you systematize administration as Microsoft shifts Power BI from a self-service tool to an enterprise tool. You will learn best practices for many Power BI administrator tasks. And you will know how to manage artifacts such as reports, users, work spaces, apps, and gateways. The book also provides experience-based guidance on governance, licensing, and managing capacities. Good management includes policies and procedures that can be applied consistently and even automatically across a broad user base. This book provides a strategic road map for the creation and implementation of policies and procedures that support Power BI best practices in enterprises. Effective governance depends not only on good policies, but also on the active and timely monitoring of adherence to those policies. This book helps you evaluate the tools to automate and simplify the most common administrative and monitoring tasks, freeing up administrators to provide greater value to the organization through better user training and awareness initiatives. What You Will LearnRecognize the roles and responsibilities of the Power BI administratorManage users and their work spacesKnow when to consider using Power BI PremiumGovern your Power BI implementation and manage Power BI tenantsCreate an effective security strategy for Power BI in the enterpriseCollaborate and share consistent views of the data across all usersFollow a life cycle management strategy for rollout of dashboards and reportsCreate internal training resources backed up by accurate documentationMonitor Power BI to better understand risks and compliance manage costs, and track implementation Who This Book Is ForIT professionals tasked with maintaining their corporate Power BI environments, Power BI administrators and power users interested in rolling out Power BI more widely in their organizations, and IT governance professionals tasked with ensuring adherence to policies and regulations
Pro Microsoft Power Platform: Solution Building for the Citizen Developer
by Brian Knight Devin Knight Mitchell Pearson Manuel QuintanaBecome a self-sufficient citizen developer by learning the tools within the Microsoft Power Platform and how they can be used together to drive change and multiply your productivity. Learn about PowerApps for building applications, Power Automate for automating business processes across those applications, and Power BI for analyzing results and communicating business intelligence through compelling visuals. By understanding the purpose and capabilities of these tools, you will be able to enhance your organization’s visibility into key areas and make informed business decisions in a timely matter. This book is divided into four parts and begins in Part I by showing you how to build applications through PowerApps. You will learn about screens and controls, application sharing and administration, and how to make your applications accessible from mobile devices such as phones and tablets. Part II is about creating workflows using Power Automate that implement business logic across your applications. Part III brings in dashboards and data analysis, showing you how to connect to a data source, cleanse the data from that source, and drive decision making through interactive reports and storytelling. Part IV brings together all the pieces by showing the integrations that are possible when all three tools are combined into a single solution.What You Will LearnUnderstand the need for the citizen developer in today’s business environmentOrganize and plan the building of line-of-business applications with PowerApps solutions Replace wasteful paper processes with automated applications built in PowerAppsAutomate workflows across processes with Power AutomateCommunicate analytical results through visualizations and storytellingIntegrate PowerApps, Power Automate, and Power BI into solutions that multiply productivityWho This Book Is ForPower users and analysts with strong Excel skills who need a more comprehensive set of tools that can better help them accomplish their vision on projects, those familiar with one of the Power Platform tools who wish to learn how all three can fit together, and those who are seen as as “rogue IT” problem solvers who get things done when others have tried but failed
Pro Microsoft Teams Development: A Hands-on Guide to Building Custom Solutions for the Teams Platform
by Rick Van RousseltLeverage the Microsoft Teams developer platform to integrate and build your apps in Teams.Busy developers will want to integrate it with other applications, both existing and new ones. Use this practical, hands-on guide to get you started building amazing custom solutions on and for Microsoft Teams, the new collaboration workspace in Office 365 and the fastest growing app in Microsoft history. Get ready to learn how to interact with data inside of Teams and how to surface your data on top of Teams, so that it is easily searchable and better supports people in their day-to-day jobs. Teams development expert Rick Van Rousselt starts at the beginning, helping you set up your environment, and takes you step by step through the process. You will begin with low code, simple integrations, and progress in your learning to increasingly more complex, multi-faceted applications that use every aspect of the extension capabilities of Teams. And a bonus for developers is that integrating your own apps into the Teams developer platform is an excellent opportunity for those apps to get more visibility and usage. What You Will Learn Understand the different development extension points and frameworks that are available in the Teams developer platformCreate custom tabs, bots, connectors, messaging extensions, and webhooksSet up your development environment and speed up the development processEnlist best practices and easy wins that will make an application stand out inside the Teams ecosystemExplore advanced scenarios where the integrations of Office 365 meet inside of Microsoft Teams Who This Book Is ForDevelopers (front end, back end, C#, or Node.js) and architects. Readers should be familiar with C# or Node.js and tools such as Visual Studio or Visual Studio Code and have some experience with Microsoft Teams. Beyond that, no further knowledge is required because the book starts at the beginning, setting up a development environment.
Pro MongoDB Development
by Deepak VohraPro MongoDB Development is about MongoDB, a NoSQL database based on the BSON (binary JSON) document model. The book discusses all aspects of using MongoDB in web applications: Java, PHP, Ruby, JavaScript are the most commonly used programming/scripting languages and the book discusses accessing MongoDB database with these languages. The book also discusses using Java EE frameworks Kundera and Spring Data with MongoDB. As NoSQL databases are commonly used with the Hadoop ecosystem the book also discusses using MongoDB with Apache Hive. Migration from other NoSQL databases (Apache Cassandra and Couchbase) and from relational databases (Oracle Database) is also discussed. What You'll Learn:How to use a Java client and MongoDB shellHow to use MongoDB with PHP, Ruby, and Node.js as wellHow to migrate Apache Cassandra tables to MongoDB documents; Couchbase to MongoDB; and transferring data between Oracle and MongoDBHow to use Kundera, Spring Data, and Spring XD with MongoDBHow to load MongoDB data into Oracle Database and integrating MongoDB with Oracle Database in Oracle Data IntegratorAudience:The target audience of the book is NoSQL database developers. Target audience includes Java, PHP and Ruby developers. The book is suitable for an intermediate level course in NoSQL database.
Pro Node.js for Developers
by Colin J. IhrigSince it's creation in 2009, Node. js has grown into a powerful and increasingly popular asynchronous-development framework for creating highly-scalable network applications using JavaScript. Respected companies such as Dow Jones and LinkedIn are among the many organizations to have seen Node's potential and adopted it into their businesses. Pro Node. js for Developers provides a comprehensive guide to this exciting new technology. We introduce you to Node - what it is, why it matters and how to set it up - before diving deeply into the key concepts and APIs that underpin its operation. Building upon your existing JavaScript skills you'll be shown how to use Node. js to build both Web- and Network-based applications, to deal with data sources, capture events and deal with child processes to create robust applications that will work well in a wide range of circumstances. Once you've mastered these skills we'll go further, teaching you more advanced software engineering skills that will give your code a professional edge. You'll learn how to create easily reusable modules that will save you time through code reuse, to log and debug your applications quickly and effectively and to write code that will scale easily and reliably as the demand for your application grows. What you'll learn Install, configure and deploy Node. js apps effectively Understand the Node. js asynchronous programming model in detail Create both web and network-based Node. js applications with ease Learn to work effectively with varied data sources and file types Discover advanced software engineering concepts that will will save you time and promote code reuse Who this book is for This book is for developers who already have a working knowledge of JavaScript and are interested in adopting Node. js into their projects. All other concepts will be introduced from first-principals. Table of Contents Introducing Node. js The Node Module System The Event Loop Events Timers and Scheduling The Command Line Interface Accessing the File System Data Streams Binary Data Creating Child Processes Network Programming HTTP Server Development Connect Connecting to Databases Logging Application Scaling Appendix
Pro NuGet
by Maarten Balliauw Xavier DecosterPro NuGet will give you a solid, practical, understanding of both how to keep your software dependencies under control and what best-practices have been developed within the NuGet community to ensure long-term reliability. Whether you're working entirely with . NET assemblies or also using CSS, HTML and JavaScript files within your applications this book will show you how to manage their requirements smoothly and reliably. As sponsors of the NuGet project Microsoft have led the way in showing how NuGet can be used to great effect; showing how it is now virtually indispensable to anyone working with MVC and the . NET Framework. So don't delay! Learn how to use NuGet effectively today and thank yourself for the time and stress that this powerful free extension will save you. NuGet is an open-source Visual Studio extension that makes it easy to manage libraries, components and configuration files from within your Visual Studio project. As every developer knows, the more complex your application becomes the more chance there is of a dependency conflict arising within the resources upon which you depend. This situation - known as "dependency hell" - used to be an arduous task to unravel and rectify. NuGet changes this situation completely saving you untold time and stress. What you'll learn Understanding how NuGet fits into the big picture of your software development process to save you time and money. How to keep your team working when your project depends on an external resource (such as a web service or cloud) which suddenly becomes unavailable. Whether or not to auto-update NuGet packages within a continuous integration process for maximum reliability and speed. How to combine NuGet with PowerShell to create your own Cmdlets and extend the base toolset in an extremely powerful manner. Evaluate the pros-and-cons of hosting your own NuGet repository. How to incorporate NuGet seamlessly within your continuous integration process. Much much more! Who this book is for This book is perfect for anyone working with Visual Studio and . NET who needs to manage application dependencies of any kind. You should have a basic working knowledge of Visual Studio but all NuGet and PowerShell based techniques will be introduced from first principals. Table of Contents Getting Started Consuming and Managing Packages in a Solution Creating Packages Publishing Packages Hosting Your Own NuGet Server Continuous Package Integration Automated Delivery NuGet Recipes Extending NuGet NuGet as a Protocol Appendix A: Package Manifest Appendix B: NuGet Command Line Reference Appendix C: NuGet Package Manager Console PowerShell Reference Appendix D: NuGet Configuration File Reference
Pro Objective-C
by Keith LeeThe Objective-C programming language continues to grow in popularity and usage because of the power and ease-of-use of the language itself, along with the numerous features that continue to be added to the platform. If you have a basic knowledge of the language and want to further your expertise, Pro Objective-C is the book for you. Pro Objective-C provides an in-depth, comprehensive guide to the language, its runtime, and key API's. It explains the key concepts of Objective-C in a clear, easy to understand manner, and also provides detailed coverage of its more complex features. In addition, the book includes numerous practical examples--code excerpts and complete applications--that demonstrate how to apply in code what you're learning. The book begins with an exploration of Objective-C's basic features and key language elements. After reviewing the basics, it proceeds with an in-depth examination of the Objective-C dynamic programming features and runtime system. Next the book covers the Foundation Framework, the base layer of APIs that can be used for any Objective-C program. Finally, new and advanced features of Objective-C are introduced and shown how they make the Objective-C language even more powerful and expressive. Each topic is covered thoroughly and is packed with the details you need to develop Objective-C code effectively. The most important features are given in-depth treatment, and each chapter contains numerous examples that demonstrate both the power and the subtlety of Objective-C. Start reading Pro Objective-C and begin developing high-quality, professional apps on the OS X and iOS platforms using the Objective-C programming language! What you'll learn Objective-C fundamentals and key language elements Objective-C runtime system Foundation Framework APIs Objective-C advanced language features Xcode Essentials Debugging with LLDB Who this book is for This book is geared towards intermediate to advanced developers who already have some Objective-C experience and want pro-level coverage of the language, including advanced Objective-C features, recent additions to the language, and practical usage of its core frameworks and APIs. It's also great for those developers not familiar with Objective-C that have done some C programming and also understand object-oriented programming concepts. Table of Contents Getting Started Using Classes Objects and Messaging Memory Management The Preprocessor Expert Section - Using ARC Runtime System Runtime Architecture Expert Section - Using the Runtime APIs Foundation Framework General Purpose Classes Foundation Framework System Services Foundation Framework Specialized Services Foundation Functions and Data Types Expert Section - Error Handling Blocks Objective-C Literals Concurrent Programming Key-Value Programming Appendix A: Language Elements Appendix B: Xcode Xposed! Appendix C: Using LLDB
Pro Office 365 Development
by Mark J. Collins Michael MayberryPro Office 365 Development, Second Edition, is a practical, hands-on guide to building applications for the cloud with Office 365. Combine Office 365 features out of the box with custom code to make the most of what this increasingly powerful and flexible platform has to offer. As an Office 365 developer, you have an amazing range of technologies at your fingertips. Build custom SharePoint apps in Visual Studio using HTML5, CSS, and jQuery. Create declarative workflow applications with Visio and SharePoint Designer. Use Access Web Database to publish your data on the web, or write Exchange and Lync applications. All these possibilities and more are covered. You also have unprecedented control and flexibility over how you use these technologies in your applications. With a powerful set of Office 365 APIs, you can now access and integrate Office 365 data directly into your web or native applications, with full control of authentication, authorization and discovery. No prior cloud experience is necessary. Sample projects are designed to bring the reader up-to-speed quickly, with full step-by-step instructions to maximize your success across the whole Office 365 suite. Whether you want to build desktop client applications or browser-only solutions, Pro Office 365 Development will show you how to do it. What you'll learn * Build a public website using the authoring environment provided by Office 365 * Implement declarative workflows in SharePoint * Build your own cloud connector for SharePoint, Exchange and Lync * Develop integrated applications using the new Office 365 APIs Who this book is for Pro Office 365 Development is written for programmers who have experience with Visual Studio and . NET development and want to take the leap into cloud-based solutions. It is ideal for developers making their first foray into collaborative systems such as SharePoint and Exchange, as no prior experience of these technologies is required. Table of Contents Chapter 1: Introducing Office 365 for Developers Chapter 2: Building and Customizing Your Web Presence Chapter 3: Creating SharePoint Apps in Visual Studio 2013 Chapter 4: Creating Declarative Workflows Chapter 5: Building and Publishing a Web Database with Access Chapter 6: Developing Exchange Online Solutions Chapter 7: Developing Lync Applications Chapter 8: Consuming Data With Office 365 APIs Chapter 9: Authentication, Authorization and Discovery Service Chapter 10: Integrating Office 365 Technologies with REST APIs and MVC Appendix A: SharePoint Primer Appendix B: SharePoint Designer Workflow Editor
Pro Office for iPad
by Guy Hart-DavisMicrosoft Office for iPad is here! So learn the tips, tricks, and get around the gotchas in Microsoft Office for iPad with Pro Office for iPad. This book shows you how you can become productive quickly by avoiding those annoyances and confusions and slow-me-downs that can happen when you start using Office with your fingers! How is Office for iPad different from Office on your Mac or PC? Which features do the Office for iPad apps have, which do they lack, and how can you work around their limitations? How can you share your files among the different versions of Office? How quickly can you work without the physical keyboard and keyboard shortcuts you're used to -- and which keyboard shortcuts can you use if you connect a hardware keyboard to your iPad? Whether you plan to write a few letters or your dissertation, run your home office away from home, or use your iPad for daily business, Pro Office for iPad will show you how to get the most out of Word, Excel, and other Office apps on your iPad. Enjoy your new freedom and still be as productive as ever with the skills and techniques you'll learn in Pro Office for iPad. What you'll learn How to avoid those annoyances when you try to use Office on your iPad like you do on your desktop and it won't work the same! Solve or work around tablet-specific Office problems Learn tips, tricks, and techniques for being as productive as possible with Office for iPad, even without a physical keyboard How to move files between your different versions of Office seamlessly! Who this book is for Office users who want to learn how Office for iPad works, including how it works with Office on desktops and laptops via the cloud, and for iPad users who need to learn to incorporate Office for iPad into their work routine. Table of Contents Chapter 1: Up and Running with Office for iPad Chapter 2: Using Common Tools in the Office Apps Chapter 3: Managing Your Office Documents Chapter 4: Getting Up to Speed with Word for iPad Chapter 5: Formatting and Laying Out Your Documents Chapter 6: Revising, Finalizing, and Printing Your Documents Chapter 7: Getting Going with Excel for iPad Chapter 8: Building and Formatting Worksheets Chapter 9: Using Formulas and Functions in Your Worksheets Chapter 10: Creating Effective Charts Chapter 11: Becoming Expert with PowerPoint for iPad Chapter 12: Taking Notes in OneNote
Pro Oracle Database 12c Administration
by Darl KuhnPro Oracle Database 12c Administration is a book focused on results. Author Darl Kuhn draws from a well of experience over a decade deep to lay out real-world techniques that lead to success as an Oracle Database administrator. He gives clear explanations on how to perform critical tasks. He weaves in theory where necessary without bogging you down in unneeded detail. He is not afraid to take a stand on how things should be done. He won't leave you adrift in a sea of choices, showing you three ways to do something and then walking away. Database administration isn't about passing a certified exam, or about pointing-and-clicking your way through a crisis. Database administration is about applying the right solution at the right time, about avoiding risk, about making robust choices that get you home each night in time for dinner with your family. If you have "buck stops here" responsibility for an Oracle database, then Pro Oracle Database 12c Administration is the book you need to help elevate yourself to the level of Professional Oracle Database Administrator. Condenses and organizes the core job of a database administrator into one volume. Takes a results-oriented approach to getting things done. Lays a foundation upon which to build a senior level of expertise
Pro Oracle Database 18c Administration: Manage and Safeguard Your Organization’s Data
by Darl Kuhn Michelle MalcherDatabase administration isn’t about passing a certified exam, or about pointing and clicking your way through a crisis. Database administration is about applying the right solution at the right time, avoiding risk, and making robust choices that get you home each night in time for dinner with your family. This book will help elevate you to the level of Professional Oracle Database Administrator.This book provides information and techniques for keeping an Oracle database stable and running on-premise, and is fully updated to cover Oracle Database 18c. New in this edition is coverage of cloud administration in the Oracle Public Cloud, automation of tasks using the autonomous database features, and data movement with multi-tenant databases. The book covers everything from architecture of the database engine, securing objects and users, strategies for performing maintenance tasks and resolving performance problems, through to backup and recovery. Pro Oracle Database 18c Administration takes a modern approach to database administration. Emphasis is given to automation, which is of growing importance as more databases are being moved into various cloud solutions and database administrators are being required to manage more instances than ever. Focus is given to multi-tenant container architecture and pluggable databases, and the book takes a refreshing, results-oriented approach that helps you get the job done. What You'll LearnUnderstand the differences between managing on-premise and cloud deploymentsTake advantage of new features in 18c while also managing older releasesManage more databases than ever by automating your environmentApply the latest techniques around pluggable databases and containerizationSafeguard your data through good security and backup/recovery practicesTroubleshoot common problemsWho This Book Is ForDatabase architects and administrators who want to level-up to the latest techniques around containerization, automation, and cloud deployment. The book also is appropriate for Oracle professionals desiring to present themselves as being competitive and up-to-date with the latest in the field.
Pro Oracle Database 23ai Administration: Manage and Safeguard Your Organization’s Data
by Darl Kuhn Michelle MalcherMaster Oracle Database administration in both on-premises and cloud environments. This new edition covers the tasks you’ll need to perform to keep your databases tuned and performing, and includes new, important innovations with AI Vector Search, JSON Duality Views, and Select AI. Since Oracle Database 23ai offers a choice of platforms with on-premises and cloud, the book also includes administrative tasks specific to cloud environments, including the Oracle Autonomous Database running in the Oracle Cloud Infrastructure. New in this edition is help for DBAs who are becoming involved in data management, and a look at the idea of a converged database and what that means in handling various data types and workloads. The book covers some of the machine learning features now in Oracle and shows how the same SQL that you know for database administration also helps you with data management tasks. The information in this book helps you to apply the right solution at the right time, mitigating risk and making robust choices that protect your data and avoid midnight phone calls. Data management is increasingly a DBA function, and DBAs are often called upon for help in getting data loaded into analytics environments such as a data lakehouse or a data mesh. This book addresses this fast-growing new role for database administrators and helps you build on your existing knowledge to make the transition into a new skill set that is in high demand. You’ll learn how to look at data optimization from the standpoint of data analysis and machine learning so that you can be seen as a key player in preparing your organization’s data for those type of activities. You’ll know how to pull back information from a combination of relational tables and JSON structures. You’ll become familiar with the tools that Oracle Database provides to make analytics easier and more straightforward. And you’ll learn simpler ways to manage time-based tables that eliminate the need for painfully creating triggers to track the history of row changes over time. This book builds your skills as an Oracle Database administrator with the aim of helping you to be seen as a key player in data management as your organization pivots toward cloud computing and a greater use of machine learning and analytics technologies. What You Will Learn Configure and manage Oracle 23ai databases both on-premises and in the cloud Meet your DBA responsibilities in the Oracle Cloud and with Database Cloud Services Leverage converged database capabilities to manage different workloads, structured and unstructured data Perform administrative tasks for Autonomous Database dedicated environments Perform DBA tasks and effectively use data management tools Migrate from on-premises to the Oracle Cloud Infrastructure Troubleshoot issues with Oracle 23ai databases and quickly solve performance problems Architect cloud, on-premises, hybrid, and multi-cloud database environments Who This Book Is For Oracle database administrators (DBAs) who want to be current with the new features in Oracle Database 23ai. For any DBA who is tasked with managing Oracle databases in cloud, hybrid cloud, and multi-cloud configurations. Also helpful for data architects who are designing analytic solutions in data lake house and data mesh environments.
Pro Oracle Database 23c Administration: Manage and Safeguard Your Organization’s Data
by Darl Kuhn Michelle MalcherMaster Oracle Database administration in both on-premises and cloud environments. This new edition covers the tasks you’ll need to perform to keep your databases stable, tuned, and running. The book also includes administrative tasks specific to cloud environments, including the Oracle Autonomous Database running in the Oracle Cloud Infrastructure. New in this edition is help for DBAs who are becoming involved in data management, and a look at the idea of a converged database and what that means in handling various data types and workloads. The book covers some of the machine learning features now in Oracle and shows how the same SQL that you know for database administration also helps you with data management tasks. The information in this book helps you to apply the right solution at the right time, mitigating risk and making robust choices that protect your data and avoid midnight phone calls.Data management is increasingly a DBA function, and DBAs are often called upon for help in getting data loaded into analytics environments such as a data lakehouse or a data mesh. This book addresses this fast-growing new role for database administrators and helps you build on your existing knowledge to make the transition into a new skill set that is in high demand. You’ll learn how to look at data optimization from the standpoint of data analysis and machine learning so that you can be seen as a key player in preparing your organization’s data for those type of activities. You’ll know how to pull back information from a combination of relational tables and JSON structures. You’ll become familiar with the tools that Oracle Database provides to make analytics easier and more straightforward. And you’ll learn simpler ways to manage time-based tables that eliminate the need for painfully creating triggers to track the history of row changes over time.This book builds your skills as an Oracle Database administrator with the aim of helping you to be seen as a key player in data management as your organization pivots toward cloud computing and a greater use of machine learning and analytics technologies.What You'll LearnConfigure and manage Oracle 23c databases both on-premises and in the cloudMeet your DBA responsibilities in the Oracle Cloud and with Database Cloud ServicesPerform administrative tasks for Autonomous Database dedicated environmentsPerform DBA tasks and effectively use data management tools Migrate from on-premises to the Oracle Cloud InfrastructureTroubleshoot issues with Oracle 23c databases and quickly solve performance problemsArchitect cloud, on-premises, hybrid, and multi-cloud database environments Who This Book Is ForOracle database administrators (DBAs) who want to be current with the new features in Oracle Database 23c. For any DBA who is tasked with managing Oracle databases in cloud, hybrid cloud, and multi-cloud configurations. Also helpful for data architects who are designing analytic solutions in data lakehouse and data mesh environments.
Pro Oracle Fusion Applications
by Tushar ThakkerPro Oracle Fusion Applications is your one-stop source for help with installing Oracle''s Fusion Applications suite in your on-premise environment. It also aids in the monitoring and ongoing administration of your Fusion environment. Author Tushar Thakker is widely known for his writings and expertise on Oracle Fusion Applications, and now he brings his accumulated wisdom to you in the form of this convenient handbook. Provisioning an Oracle Fusion Applications infrastructure is a daunting task. You''ll have to plan a suitable topology and install the required database, an enterprise-wide identity management solution, and the applications themselves--all while working with a wide variety of people who may not always be accustomed to working together. Pro Oracle Fusion Applications provides a path to success that you won''t want to be without. Beyond installation, Pro Oracle Fusion Applications provides excellent guidance on managing, monitoring, diagnostics, and troubleshooting your environment. The book also covers patching, a mundane but essential task that must be done regularly to keep your installation protected and running smoothly. The comprehensive and wide-ranging coverage makes Pro Oracle Fusion Applications an important book for anyone with responsibility for installation and ongoing management of an Oracle Fusion Applications installation. What you''ll learn This book helps you with: Planning the most suitable topology including servers, networking, and storage Installing Oracle Fusion Applications including Identity Management components Understanding the Applications user interface Monitoring, diagnosing, troubleshooting, and patching of all components Managing the Fusion Applications environment on an ongoing basis Who this book is for Pro Oracle Fusion Applications is aimed at application administrators, database administrators, system architects, technical consultants, and others who are involved in the technical aspects of standing up an on-premise installation of Oracle Fusion Applications. Table of Contents 1. Introduction to Oracle Fusion Applications 2. Planning an Oracle Fusion Applications installation 3. Setting up the Hosts for Provisioning 4. Creating Identity Management Database 5. Preparing for Identity Management Provisioning 6. Provisioning Identity Management Environment 7. Post-Provisioning Configuration for Identity Management Nodes 8. Creating Fusion Applications Transaction Database 9. Preparing for Fusion Applications Provisioning 10. Provisioning the Fusion Applications Environment 11. Understanding the Fusion Applications Interface 12. Getting Started with Fusion Application Administration 13. Managing Fusion Applications Security 14. Monitoring of the Fusion Applications Environment 15. Diagnosing and Troubleshooting 16. Patching Fusion Applications Components
Pro Oracle GoldenGate for the DBA
by Bobby CurtisThis book provides a simple approach to learning the Oracle GoldenGate product. This approach provides the in-depth perspective of GoldenGate from an implementer's viewpoint; however, also addresses why the management viewpoint is important as well. Your journey through this book includes and architecture discussion of GoldenGate and the benefits of purchasing GoldenGate from a management perspective. Then the book quickly moves into advanced implementation components associated with GoldenGate. You'll find many use-cases and instructions throughout the book to help with everything from easy to complex GoldenGate implementations. An Oracle GoldenGate implementation generally consists of a group project, involving both business and technical resources. Pro Oracle GoldenGate for the DBA provides the viewpoint from the DBA's vantage point. This approach provides the components of who, what, why, when, and how in defining the implementation and support of a GoldenGate project. The success of most technical projects require the support of multiple resource groups, and Pro Oracle GoldenGate for the DBA supplies the insight for the DBA member to understand the implementation and support process. Takes you through justification, installation, and support. Provides the DBA perspective toward a successful a result. Covers from basic toward increasingly advanced implementations What you'll learn Understand the core architecture of data replication using Oracle GoldenGate Implement a one-way setup of a classic capture and an integrated capture and replication Design, architect and implement a multi-master replication model Perform heterogeneous replication processes between multiple database architectures Replicate unsupported data types using tokens Manage and troubleshoot multiple GoldenGate implementations New features of GoldenGate supported in Oracle 12c Who this book is for Pro Oracle GoldenGate for the DBA is aimed squarely at Oracle database administrators who find themselves involved in GoldenGate integration projects. The book provides the DBA view into such projects, helping database administrators toward successful implementations and solid business results.
Pro Oracle SQL
by Jared Still Karen Morton Kerry Osborne Robyn Sands Riyaj ShamsudeenPro Oracle SQL, Second Editionunlocks the power of SQL in the Oracle database one of the most potent SQL implementations on the market today. To master it requires a multi-pronged approach: learn the language features, learn how and why the language features work, learn the supporting features that Oracle provides to help use the language effectively, and learn to think and work in sets. Karen Morton has updated the content for Oracle version 12c and helps you master powerful aspects of Oracle SQL from the inside-out. You'll learn analytic functions, the MODEL clause, and advanced grouping syntax features thatwill helpin creating good queries for reporting and business intelligence applications. Pro Oracle SQL, Second Editionalso helps you minimize parsing overhead, read execution plans, test for correct results, understand performance management, and exert control over SQL execution in your database. You'll learn when to create indexes, how to verify that they make a difference, how to use SQL Baselines and Profiles to optimize and stabilize SQL execution plans, and much more. You'llalso understandhow SQL is optimized for working in sets, and that the key to getting accurate results lies in making sure that queries ask clear and precise questions. Pro Oracle SQL, Second Editionhelps you work at a truly professional level in the Oracle dialect of SQL. You'll master the language, the tools to work effectively with the language, and the right way to think about a problem in SQL. Endorsed by the OakTable Network, a group of Oracle technologists well-known for their rigorous and scientific approach to Oracle Database performance Comprehensive goes beyond the language with a focus on what you need to know to write successful queries and data manipulation statements. Performance focused teaches you how to measure the performance of your SQL statements and not just the syntax. "
Pro Oracle SQL Development: Best Practices for Writing Advanced Queries
by Jon HellerWrite SQL statements that are more powerful, simpler, and faster using Oracle SQL and its full range of features. This book provides a clearer way of thinking about SQL by building sets, and provides practical advice for using complex features while avoiding anti-patterns that lead to poor performance and wrong results. Relevant theories, real-world best practices, and style guidelines help you get the most out of Oracle SQL.Pro Oracle SQL Development is for anyone who already knows Oracle SQL and is ready to take their skills to the next level. Many developers, analysts, testers, and administrators use Oracle databases frequently, but their queries are limited because they do not have the knowledge, experience, or right environment to help them take full advantage of Oracle’s advanced features. This book will inspire you to achieve more with your Oracle SQL statements through tips for creating your own style for writing simple, yet powerful, SQL. It teaches you how to think about and solve performance problems in Oracle SQL, and covers advanced topics and shows you how to become an Oracle expert.What You'll LearnUnderstand the power of Oracle SQL and where to apply itCreate a database development environment that is simple, scalable, and conducive to learningSolve complex problems that were previously solved in a procedural languageWrite large Oracle SQL statements that are powerful, simple, and fastApply coding styles to make your SQL statements more readableTune large Oracle SQL statements to eliminate and avoid performance problemsWho This Book Is ForDevelopers, testers, analysts, and administrators who want to harness the full power of Oracle SQL to solve their problems as simply and as quickly as possible. For traditional database professionals the book offers new ways of thinking about the language they have used for so long. For modern full stack developers the book explains how a database can be much more than simply a place to store data.
Pro Oracle SQL Development: Best Practices for Writing Advanced Queries
by Jon HellerWrite SQL statements that are more powerful, simpler, and faster using the advanced features of Oracle SQL. This updated second edition includes the newest advanced features: improved data structures (such as more JSON support and more table options), improved automated processes (such as automatic indexing), and improved SQL language extensions (such as polymorphic table functions, SQL macros, and the multilingual engine).Pro Oracle SQL Development is for anyone who already knows Oracle SQL and is ready to take their skills to the next level. This book provides a clearer way of thinking about SQL by building sets, and it provides practical advice for using complex features while avoiding anti-patterns that lead to poor performance and wrong results. Relevant theories, real-world best practices, and style guidelines help you get the most out of Oracle SQL.Many developers, testers, analysts, and administrators use Oracle databases frequently, but their queries are limited because they do not take advantage of Oracle’s advanced features. This book inspires you to achieve more with your Oracle SQL statements by creating your own style for writing simple, yet powerful, SQL. It teaches you how to think about and solve performance problems in Oracle SQL, and it covers enough advanced topics to put you on the path to becoming an Oracle expert.What You'll LearnSolve challenging problems with declarative SQL instead of procedural languagesWrite SQL statements that are large and powerful, but also elegant and fastCreate development environments that are simple, scalable, and conducive to learningVisualize and understand SQL more intuitivelyApply advanced syntax, objects, and architectureAvoid SQL anti-patterns that accumulate technical debtTune SQL statements with multiple strategies that can significantly improve performanceWho This Book Is ForDevelopers, testers, analysts, and administrators who want to harness the full power of Oracle SQL to solve their problems as simply and as quickly as possible; traditional database professionals looking for new ways of thinking about the language they have used for so long; and modern full stack developers who need an explanation of how a database can be much more than simply a place to store data
Pro PHP 8 MVC: Model View Controller Architecture-Driven Application Development
by Christopher PittExamine the building blocks that make any good MVC framework using PHP 8. This book exposes all the considerations that many developers take for granted when using a popular framework, and teaches you how to make this MVC framework your own. You'll quickly get started writing your first bit of framework code, then, you build a variety of examples using aspects of an MVC framework, including a router, a template engine, a database library, a persistence engine (ORM), and a testing framework. In the next section, you'll implement sessions, caches, file systems, queues, logging, and mail. You'll wrap up by building a larger scale sample web application: a sales website for a company that sells rockets. Along the way, this book lays bare all the secret parts of MVC to take with you to apply to your own PHP-based MVC projects. What You Will Learn Build PHP-based web applications using the model view controller (MVC) architecture Write your first bit of framework codeCompare the code you write with how the popular frameworks do the same kinds of things Create various aspects of applications, engines, and other frameworks Wrap up with a sample case study application Who This Book Is For Experienced PHP and web developers. Some prior experience with PHP and web development at least recommended.
Pro PHP and jQuery
by Jason Lengstorf Keith WaldTake advantage of the improved performance and reduced memory requirements of PHP version 7, and learn to utilize the new built-in PHP functions and features such as typed variable enforcement with declare(strict_types=1) and the new available data types, scalar type declarations for function arguments and return statements, constant arrays using define(), argument unpacking with the . . . operator, integer division with intdiv(), the null coalesce operator, the spaceship operator, new exception types, and improvements to existing features. Pro PHP and jQuery, Second Edition is for intermediate level programmers interested in building web applications using jQuery and PHP. Updated for PHP version 7 and the latest version of jQuery, this book teaches some advanced PHP techniques and it shows you how to take your dynamic applications to the next level by adding a JavaScript layer using the jQuery framework and APIs. After reading and using this book, you'll come away having built a fully functional PHP and jQuery web application that you can reapply as a template for your own particular web application. What you'll learn How to use PHP 7 to build a calendar application that allows users to post, view, edit, and delete events How to use jQuery to allow the calendar app to be viewed and edited without requiring page refreshes using built-in Ajax functions How to harness the power and versatility of PHP's object-oriented programming style How to apply the various forms of security available How to use jQuery plug-in development patterns to create modular, reusable jQuery plug-ins. How to employ jQuery effects, including fading elements, generating HTML markup on the fly, and creating modal windows Who this book is for This book is intended for programmers who want to bridge the gap between front- and back-end programming. It does not cover HTML or CSS except where absolutely necessary, and it focuses on taking intermediate PHP developers to the next level while getting comfortable with Ajax and the power of jQuery. Table of Contents 1. Introducing jQuery in PHP 2. Common jQuery Actions and Methods 3. Object-Oriented Programming 4. Build an Events Calendar 5. Add Controls to Create, Edit, and Delete Events 6. Password Protecting Sensitive Actions and Areas 7. Enhancing the User Interface with jQuery 8. Editing the Calendar with Ajax and jQuery 9. Performing Form Validation with Regular Expressions 10. Extending jQuery
Pro Perl Programming: From Professional to Advanced
by William "Bo" RothwellMaster intermediate to advanced techniques of the Perl programming language starting with a focus on regular expressions and some of their advanced features. This book then covers other pro-level features, including formatted output, file handling, and more. Additionally, you'll learn and explore the most useful built-in variables, pragmas, and modules available in the Perl language. Furthermore, you'll work with geometry managers and get a thorough treatment of graphical user interface development using Perl/TK and widgets. Lastly, you’ll cover debugging techniques. Pro Perl Programming is a professional-level reference guide on Perl and includes important aspects of it that you need as a professional programmer. What You Will Learn Program regular expressions including atoms, smartmatch operators, and more Use advanced features such as HiRes Time, slurp() functions, Critic, Tidy and many more functions Handle advanced formatted output such as printf and sprintf Explore useful built-in variables, including status variables, separator variables, and the signal handle variable Explore and use Perl's built-in modules, including the Pragma modules Work with Perl/TK and its widgets-like geometry managers, frames, labels, buttons, check buttons, radio buttons, scrollbars, scales, entries, and menus Who This Book Is For Those with at least some prior experience with Perl programming or have read Beginning Perl Programming by William Rothwell.
Pro Power BI Architecture: Development, Deployment, Sharing, and Security for Microsoft Power BI Solutions
by Reza RadThis book provides detailed guidance around architecting and deploying Power BI reporting solutions, including help and best practices for sharing and security. You’ll find chapters on dataflows, shared datasets, composite model and DirectQuery connections to Power BI datasets, deployment pipelines, XMLA endpoints, and many other important features related to the overall Power BI architecture that are new since the first edition. You will gain an understanding of what functionality each of the Power BI components provide (such as Dataflow, Shared Dataset, Datamart, thin reports, and paginated reports), so that you can make an informed decision about what components to use in your solution. You will get to know the pros and cons of each component, and how they all work together within the larger Power BI architecture. Commonly encountered problems you will learn to handle include content unexpectedly changing while users are in the process of creating reports and building analyses, methods of sharing analyses that don’t cover all the requirements of your business or organization, and inconsistent security models. Detailed examples help you to understand and choose from among the different methods available for sharing and securing Power BI content so that only intended recipients can see it. The knowledge provided in this book will allow you to choose an architecture and deployment model that suits the needs of your organization. It will also help ensure that you do not spend your time maintaining your solution, but on using it for its intended purpose: gaining business value from mining and analyzing your organization’s data. What You Will Learn Architect Power BI solutions that are reliable and easy to maintain Create development templates and structures in support of reusabilitySet up and configure the Power BI gateway as a bridge between on-premises data sources and the Power BI cloud serviceSelect a suitable connection type—Live Connection, DirectQuery, Scheduled Refresh, or Composite Model—for your use caseChoose the right sharing method for how you are using Power BI in your organizationCreate and manage environments for development, testing, and productionSecure your data using row-level and object-level security Save money by choosing the right licensing plan Who This Book Is For Data analysts and developers who are building reporting solutions around Power BI, as well as architects and managers who are responsible for the big picture of how Power BI meshes with an organization’s other systems, including database and data warehouse systems.