- Table View
- List View
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 Michelle Malcher Darl KuhnDatabase 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 Michelle Malcher Darl KuhnMaster 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 Michelle Malcher Darl KuhnMaster 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 Karen Morton Kerry Osborne Robyn Sands Riyaj Shamsudeen Jared StillPro 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 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 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 Power BI Architecture: Sharing, Security, and Deployment Options for Microsoft Power BI Solutions
by Reza RadArchitect and deploy a Power BI solution. This book will help you understand the many available options and choose the best combination for hosting, developing, sharing, and deploying a Power BI solution within your organization.Pro Power BI Architecture provides detailed examples and explains the different methods available for sharing and securing Power BI content so that only intended recipients can see it. Commonly encountered problems you will learn to handle include content unexpectedly changing while users are in the process of creating reports and building analysis, methods of sharing analyses that don’t cover all the requirements of your business or organization, and inconsistent security models.The knowledge provided in this book will allow you to choose an architecture and deployment model that suits the needs of your organization, ensuring that you do not spend your time maintaining your solution but on using it for its intended purpose and gaining business value from mining and analyzing your organization’s data. What You'll LearnArchitect and administer enterprise-level Power BI solutionsChoose the right sharing method for your Power BI solutionCreate and manage environments for development, testing, and productionImplement row level security in multiple ways to secure your dataSave money by choosing the right licensing planSelect a suitable connection type—Live Connection, DirectQuery, or Scheduled Refresh—for your use caseSet up a Power BI gateway to bridge between on-premises data sources and the Power BI cloud serviceWho This Book Is ForData analysts, developers, architects, and managers who want to leverage Power BI for their reporting solution
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.
Pro Power BI Dashboard Creation: Building Elegant and Interactive Dashboards with Visually Arresting Analytics
by Adam AspinProduce high-quality, visually attractive analysis quickly and effectively with Microsoft’s key BI tool. This book teaches analysts, managers, power users, and developers how to harness the power of Microsoft’s self-service business intelligence flagship product to deliver compelling and interactive insight with remarkable ease. It then shows you the essential techniques needed to go from source data to dashboards that seize your audience’s attention and provide them with clear and accurate information. As well as producing elegant and visually arresting output, you learn how to enhance the user experience through adding polished interactivity. This book shows you how to make interactive dashboards that allow you to guide users through the meaning of the data that they are exploring. Drill down features are also covered that allow you and your audience to dig deeper and uncover new insights by exploring anomalous and interesting data points.Reading this book builds your skills around creating meaningful and elegant dashboards using a range of compelling visuals. It shows you how to apply simple techniques to convert data into business insight. The book covers tablet and smartphone layouts for delivering business value in today’s highly mobile world. You’ll learn about formatting for effect to make your data tell its story, and you’ll be a master at creating visually arresting output on multiple devices that grabs attention, builds influence, and drives change. What You Will LearnProduce designer output that will astound your bosses and peersMake new insights as you chop and tweak your data as never beforeCreate high-quality analyses in record timeCreate interdependent charts, maps, and tablesDeliver visually stunning informationDrill down through data to provide unique understandingsOutshine competing products and enhance existing skillsAdapt your dashboard delivery to mobile devicesWho This Book Is ForFor any Power BI user who wants to strengthen their ability to deliver compelling analytics via Microsoft’s widely adopted analytics platform. For those new to Power BI who want to learn the full extent of what the platform is capable of. For power users such as BI analysts, data architects, IT managers, accountants, and C-suite members who want to drive change in their organizations.
Pro Power BI Desktop
by Adam AspinThis book shows how to deliver eye-catching Business Intelligence with Microsoft Power BI Desktop. You can now take data from virtually any source and use it to produce stunning dashboards and compelling reports that will seize your audience's attention. Slice and dice the data with remarkable ease then add metrics and KPIs to project the insights that create your competitive advantage. Make raw data into clear, accurate, and interactive information with Microsoft's free self-service business intelligence tool. Pro Power BI Desktop will help you to push your BI delivery to the next level. You'll learn to create great-looking visualizations and let your audience have fun by interacting with the elegant and visually arresting output that you can now deliver. You can choose from a wide range of built-in and third-party visualization types so that your message is always enhanced. You'll be able to deliver those results on the PC, on tablets, on smartphones, as well as share results via the cloud. Finally, this book helps you save time by preparing the underlying data correctly without needing an IT department to prepare it for you. Power BI Desktop will let your analyses speak for themselves. Simple techniques to make data into insight. Polished interactive dashboards to deliver attention-grabbing information. Visually arresting output on multiple devices grab the reader's attention. What you'll learn Produce designer output to astound your bosses and peers. Share business intelligence in the cloud Deliver visually stunning charts, maps, and tables. Make them interactive too! Find new insights as you chop and tweak your data as never before. Adapt delivery to mobile devices such as phones and tablets. Who this book is for Pro Power BI Desktop is written for any user who is comfortable in Microsoft Office. Everyone from CEOs and Business Intelligence developers through to power users and IT managers can use this book to outshine the competition by producing 21st Century business intelligence visualizations and reporting on a variety of devices from a variety of data sources. All of this is possible through leveraging your existing skill set with the same, common Microsoft tools you already use in your daily work.
Pro Power BI Desktop
by Adam AspinThis book shows how to deliver eye-catching Business Intelligence with Microsoft Power BI Desktop. You can now take data from virtually any source and use it to produce stunning dashboards and compelling reports that will seize your audience's attention. Slice and dice the data with remarkable ease then add metrics and KPIs to project the insights that create your competitive advantage. Make raw data into clear, accurate, and interactive information with Microsoft's free self-service business intelligence tool. Pro Power BI Desktop will help you to push your BI delivery to the next level. You'll learn to create great-looking visualizations and let your audience have fun by interacting with the elegant and visually arresting output that you can now deliver. You can choose from a wide range of built-in and third-party visualization types so that your message is always enhanced. You'll be able to deliver those results on the PC, on tablets, on smartphones, as well as share results via the cloud. Finally, this book helps you save time by preparing the underlying data correctly without needing an IT department to prepare it for you. Power BI Desktop will let your analyses speak for themselves. Simple techniques to make data into insight. Polished interactive dashboards to deliver attention-grabbing information. Visually arresting output on multiple devices grab the reader's attention. What You Will Learn Produce designer output to astound your bosses and peers. Share business intelligence in the cloud Deliver visually stunning charts, maps, and tables. Make them interactive too! Find new insights as you chop and tweak your data as never before. Adapt delivery to mobile devices such as phones and tablets. Audience Pro Power BI Desktop is written for any user who is comfortable in Microsoft Office. Everyone from CEOs and Business Intelligence developers through to power users and IT managers can use this book to outshine the competition by producing 21st Century business intelligence visualizations and reporting on a variety of devices from a variety of data sources. All of this is possible through leveraging your existing skill set with the same, common Microsoft tools you already use in your daily work.
Pro Power BI Desktop: Self-Service Analytics and Data Visualization for the Power User
by Adam AspinDeliver eye-catching and insightful business intelligence with Microsoft Power BI Desktop. This new edition has been updated to cover all the latest features of Microsoft’s continually evolving visualization product. New in this edition is help with storytelling—adapted to PCs, tablets, and smartphones—and the building of a data narrative. You will find coverage of templates and JSON style sheets, data model annotations, and the use of composite data sources. Also provided is an introduction to incorporating Python visuals and the much awaited Decomposition Tree visual.Pro Power BI Desktop shows you how to use source data to produce stunning dashboards and compelling reports that you mold into a data narrative to seize your audience’s attention. Slice and dice the data with remarkable ease and then add metrics and KPIs to project the insights that create your competitive advantage. Convert raw data into clear, accurate, and interactive information with Microsoft’s free self-service BI tool.This book shows you how to choose from a wide range of built-in and third-party visualization types so that your message is always enhanced. You will be able to deliver those results on PCs, tablets, and smartphones, as well as share results via the cloud. The book helps you save time by preparing the underlying data correctly without needing an IT department to prepare it for you. What You Will LearnDeliver attention-grabbing information, turning data into insightFind new insights as you chop and tweak your data as never beforeBuild a data narrative through interactive reports with drill-through and cross-page slicingMash up data from multiple sources into a cleansed and coherent data modelBuild interdependent charts, maps, and tables to deliver visually stunning informationCreate dashboards that help in monitoring key performance indicators of your businessAdapt delivery to mobile devices such as phones and tabletsWho This Book Is ForPower users who are ready to step up to the big leagues by going beyond what Microsoft Excel by itself can offer. The book also is for line-of-business managers who are starved for actionable data needed to make decisions about their business. And the book is for BI analysts looking for an easy-to-use tool to analyze data and share results with C-suite colleagues they support.
Pro Power BI Theme Creation: JSON Stylesheets for Automated Dashboard Formatting
by Adam AspinUse JSON theme files to standardize the look of Power BI dashboards and reports. This book shows how you can create theme files using the Power BI Desktop application to define high-level formatting attributes for dashboards as well as how to tailor detailed formatting specifications for individual dashboard elements in JSON files. Standardize the look of your dashboards and apply formatting consistently over all your reports. The techniques in this book provide you with tight control over the presentation of all aspects of the Power BI dashboards and reports that you create. Power BI theme files use JSON (JavaScript Object Notation) as their structure, so the book includes a brief introduction to JSON as well as how it applies to Power BI themes. The book further includes a complete reference to all the current formatting definitions and JSON structures that are at your disposal for creating JSON theme files. Finally, the book includes dozens of theme files, from the simple to the most complex, that you can adopt and adapt to suit your own requirements. What You Will LearnProduce designer output without manually formatting every individual visual in a Power BI dashboardStandardize presentation for families of dashboard typesSwitch presentation styles in a couple of clicksSave dozens, or hundreds, of hours laboriously formatting dashboardsDefine enterprise-wide presentation standardsRetroactively apply standard styles to existing dashboardsWho This Book Is ForPower BI users who want to save time by defining standardized formatting for their dashboards and reports, IT professionals who want to create corporate standards of dashboard presentation, and marketing and communication specialists who want to set organizational standards for dashboard delivery
Pro Power BI Theme Creation: JSON Stylesheets for Automated Dashboard Formatting
by Adam AspinUse JSON theme files to standardize the look of Power BI dashboards and reports. This book shows how you can create theme files using the Power BI Desktop application to define high-level formatting attributes for dashboards as well as how to tailor detailed formatting specifications for individual dashboard elements in JSON files. Standardize the look of your dashboards and apply formatting consistently over all your reports. The techniques in this book provide you with tight control over the presentation of all aspects of the Power BI dashboards and reports that you create. Power BI theme files use JSON (JavaScript Object Notation) as their structure, so the book includes a brief introduction to JSON as well as how it applies to Power BI themes. The book further includes a complete reference to all the current formatting definitions and JSON structures that are at your disposal for creating JSON theme files up to the May 2023 release of Power BI Desktop. Finally, the book includes dozens of theme files, from the simple to the most complex, that you can adopt and adapt to suit your own requirements. What You Will Learn Produce designer output without manually formatting every individual visual in a Power BI dashboardStandardize presentation for families of dashboard typesSwitch presentation styles in a couple of clicksSave dozens, or hundreds, of hours laboriously formatting dashboardsDefine enterprise-wide presentation standardsRetroactively apply standard styles to existing dashboards Who This Book Is For Power BI users who want to save time by defining standardized formatting for their dashboards and reports, IT professionals who want to create corporate standards of dashboard presentation, and marketing and communication specialists who want to set organizational standards for dashboard delivery.
Pro PowerShell Desired State Configuration: Using Windows Powershell Dsc And Dsc Core
by Ravikanth ChagantiUse Windows PowerShell Desired State Configuration (DSC) to configure your infrastructure on-premises and in the cloud. In an environment where changes and deployments are happening all the time, DSC makes the necessary adjustments to the system so you don’t have to. Pro PowerShell Desired State Configuration shows you how.PowerShell Desired State Configuration (DSC) is a powerful configuration management platform that makes it easier than ever to perform configuration management of your infrastructure, whether on-premises or in the cloud. With Pro PowerShell Desired State Configuration, Ravikanth Chaganti revises and significantly expands his previous edition, bringing you a complete in-depth reference for applying this evolving technology in your day-to-day work.What’s new in this edition?Get up-to-date, in-depth guidance on DSC in the data centerUnderstand the central role that DSC plays in DevOps todayIntegrate DSC into build and release management toolsLearn to think and act like a developer when automating your configuration management, creating a testable, robust process that you can use again and againFind out why and how DSC has an important role to play in public and private cloud deploymentsApply DSC in the cloud with Microsoft Azure or Amazon Web Services or Google Cloud PlatformWho This Book Is ForIT administrators, developers and DevOps engineers working in Windows-based data center environments. With a little prior PowerShell scripting experience, this book can be used as an in-depth reference to creating, customizing, and extending DSC in Windows. IT administrators with limited scripting experience will also find this book a useful overview of what DSC offers and how to use DSC resources to automate configuration management and deployment.
Pro Powershell for Amazon Web Services
by Brian BeachPro PowerShell for Amazon Web Services is written specifically for Windows professionals who already know PowerShell and want to learn to host Windows workloads in the Amazon Elastic Cloud Compute (EC2) cloud service. The cloud offers information technology workers significant cost savings and agility unimaginable even just a few years ago. Tasks that traditionally took weeks of work, costing thousands of dollars, can be completed in minutes for a fraction of a penny. This book is a resource for using Microsoft's powerful scripting language, PowerShell, to create, host, manage, and administer workloads using a service widely recognized as the industry leader in cloud computing. Inside, find scripts to create and manage virtual machines, provision storage, configure networks with agility, and more--all using your preferred Windows scripting language. Use your PowerShell knowledge to harness the power of Amazon EC2 today! What you'll learn Create, manage, and terminate Windows servers in the cloud Manage storage options including backup and recovery Configure a virtual network including subnets and route tables Secure your servers using security groups and access control lists Use Auto Scaling to respond to changing conditions Deploy SQL Server using Relational Database Service Use Simple Storage Service (S3) to reliably store and archive data Control access to resources using Identity and Access Management (IAM) Who this book is for Pro PowerShell for Amazon Web Services is for the intermediate to advanced Windows professional who is ready to make the leap to the Amazon cloud. Table of Contents Chapter 1 AWS Architecture Overview Chapter 2 Getting Started Chapter 3 Basic Instance Management Chapter 4 Elastic Block Storage Chapter 5 Virtual Private Cloud Chapter 6 Advanced Instance Management Chapter 7 Amazon Machine Images Chapter 8 Monitoring and High Availability Chapter 9 Relational Database Service Chapter 10 Simple Storage Service Chapter 11 Identity and Access Management Chapter 12 Glossary of Terms Chapter 13 Metadata URL Structure Chapter 14 List of Filters by EC2 Command Chapter 15 List of API Methods by Command Chapter 16 CloudWatch Metrics and Dimensions Chapter 17 SQL Server RDS Parameters
Pro PowerShell for Amazon Web Services: Devops For The Aws Cloud
by Brian Beach Steven Armentrout Rodney Bozo Emmanuel TsourisAmazon Web Services (AWS) is the leading public cloud platform. In this book you will learn to use Microsoft PowerShell to create, host, manage, and administer workloads using Amazon Web Services. You will learn how to create virtual machines, provision storage, configure networks, and more—all using your preferred Windows scripting language. CIOs everywhere are leading their organizations to the cloud, but there are few books available to help. This book focuses on moving Microsoft Windows workloads to the cloud using technologies familiar to enterprise Microsoft-based professionals. The completely revised and expanded Pro PowerShell for Amazon Web Services is written specifically for Windows professionals who already know PowerShell and want to learn to host Windows workloads on Amazon Web Services. The cloud offers information technology workers significant cost savings and agility unimaginable even just a few years ago. Tasks that traditionally took weeks of work, costing thousands of dollars, can be completed in minutes for a fraction of a penny. New chapters in this second edition cover: AWS Lambda, Amazon WorkSpaces, Amazon AppStream 2.0, AWS Directory Service, Amazon WorkDocs, and AWS System Manager.What You'll LearnCreate and manage Windows servers on Elastic Compute Cloud (EC2)Configure and secure networks with Virtual Private Cloud (VPC)Leverage autoscaling to adjust resources as load changesDeploy and manage SQL Server using the Relational Database Service (RDS)Manage virtual desktops using WorkSpaces and AppStreamLeverage AWS Systems Manager to manage Windows at scale Who This Book Is ForWindows professionals who want to learn more about Amazon Web Services, with a focus on running Windows workloads and automated management at scale using PowerShell tools for AWS. The book assumes you have knowledge of Windows and PowerShell, but are new to AWS.
Pro PowerShell for Database Developers
by Bryan CafferkyPro PowerShell for Database Developers helps you master PowerShell application development by continuing where other books leave off. There are no "Hello World" functions here, just real-world examples that get down to business. Develop and deploy database and ETL applications in a reusable framework. Read from any data source and write to any destination. Integrate PowerShell with SQL Server. Pro PowerShell for Database Developers shows how to dive into the PowerShell environment and customize it to your needs. Learn about CmdletBinding and its use in extending functions with powerful new features. Also learn to package functions into libraries called modules that are loaded automatically on demand. PowerShell is about automation and getting work done when you're not around to perform it. To that end you'll see how to schedule PowerShell applications using SQL Agent and the scheduled job cmdlets. And for when you are around to run automated processes in person, you'll learn to add a Windows GUI to your applications to give them that professional polish. Other exciting topics include: Creating objects with custom methods and properties and extending them with PowerShell-style inheritance. Implementing function polymorphism using parameter sets. Using PowerShell as an ETL tool surpassing even SSIS. Creating distributed, interruptible, and multithreaded programs using PowerShell's workflow engine and the . Net Windows Workflow Foundation. All these topics are explained using real-world examples encapsulated into modules you can immediately put to use in your organization. You'll reap even more as you come to grips with all that PowerShell can do. Begin the journey toward deep expertise and amazing productivity. Buy and read Pro PowerShell for Database Developers today. What you'll learn Develop professional, reliable, extensible, and flexible code. Customize the PowerShell environment and language to your needs. Code using advanced features such as COM and . NET objects. Write complete applications involving database access and GUIs, all in PowerShell. Run PowerShell as a stand-alone ETL tool, and also to manage ETL process flow. Access the Windows Workflow API for writing multi-threaded applications in PowerShell. Who this book is for Pro PowerShell for Database Developers is for . NET and other developers using PowerShell in connection with database-backed applications, and especially with the sort of databases commonly found in enterprise environments. If you're wondering what all the PowerShell hype is about, if you're wanting to get serious about using PowerShell well beyond writing trivial scripts, then Pro PowerShell for Database Developers is the book to read. Table of Contents Introduction 1. Grasping PowerShell Basics 2. Introducing the Language 3. Learning Advanced Features 4. Writing Simple Scripts 5. Creating Reusable Code 6. Extending PowerShell 7. Accessing SQL Server 8. Customizing the PowerShell Environment 9. Augmenting ETL Processes 10. PowerShell Application Configurations, Development Best Practices and Application Deployment 11. PowerShell versus SSIS 12. PowerShell Jobs 13. Multi-threading with Wndows Workflow
Pro PowerShell for Microsoft Azure
by Sherif TalaatThis book is written for Windows professionals who are familiar with PowerShell and want to learn to build, operate, and administer their Windows workloads in the Microsoft cloud. Pro PowerShell for Microsoft Azure is packed with practical examples and scripts, with easy-to-follow explanations for a wide range of day-to-day needs and essential administration tasks. Author Sherif Talaat begins by explaining the fundamental concepts behind the Microsoft Azure platform and how to get started configuring it through PowerShell. Readers will find out how to deploy, configure and manage the various components of the Azure platform, from storage and virtual networks to Azure Web Apps, HDInsight clusters and the Azure SQL Database. Workload automation, scheduling and resource management are covered in depth to help build efficiency in everyday tasks, and administrators will gain full control over Azure identity and access rights using Azure Active Directory and Rights Management Services. Put your PowerShell skills to good use and ensure that your applications and data are available anywhere at any time, with Pro PowerShell for Microsoft Azure. What you'll learn Create and manage virtual networks and VPNs using PowerShell. Configure and maintain Azure Storage accounts, blobs, and containers. Provision and manage a redundant Windows or Linux server. Deploy and configure your applications in the cloud using Microsoft Azure Web Apps. Provision Apache Hadoop clusters in the cloud using Azure HDInsight. Deploy, configure and manage a Microsoft Azure SQL Database. Protect and secure identities and resources with Azure Active Directory and Azure Rights Management Services. Who this book is for This is book is for the intermediate to advanced Windows professional who is ready to make the leap to the cloud. Table of Contents Chapter 1: Azure Architecture Overview Chapter 2: Getting Started with Azure PowerShell Chapter 3: Managing and Maintaining Azure Storage Chapter 4: Virtual Machines Deployment and Management Chapter 5: Virtual Networking Configuration Chapter 6: Deploying Azure Web Apps Chapter 7: Azure SQL Database Chapter 8: Azure Automation Chapter 9: Azure RemoteApp Chapter 10: Azure Identity and Access Chapter 11: Azure Rights Management Service Chapter 12: Building and Managing Azure HDInsight Clusters