- Table View
- List View
Mastering PHP Design Patterns
by Junade AliDevelop robust and reusable code using a multitude of design patterns for PHP 7 About This Book * Learn about advanced design patterns in PHP 7 * Understand enhanced architectural patterns * Learn to implement reusable design patterns to address common recurring problems Who This Book Is For This book is for PHP developers who wish to have better organization structure over their code through learning common methodologies to solve architectural problems against a backdrop of learning new functionality in PHP 7. What You Will Learn * Recognize recurring problems in your code with Anti-Patterns * Uncover object creation mechanisms using Creational Patterns * Use Structural design patterns to easily access your code * Address common issues encountered when linking objects using the splObserver classes in PHP 7 * Achieve a common style of coding with Architectural Patterns * Write reusable code for common MVC frameworks such as Zend, Laravel, and Symfony * Get to know the best practices associated with design patterns when used with PHP 7 In Detail Design patterns are a clever way to solve common architectural issues that arise during software development. With an increase in demand for enhanced programming techniques and the versatile nature of PHP, a deep understanding of PHP design patterns is critical to achieve efficiency while coding. This comprehensive guide will show you how to achieve better organization structure over your code through learning common methodologies to solve architectural problems. You'll also learn about the new functionalities that PHP 7 has to offer. Starting with a brief introduction to design patterns, you quickly dive deep into the three main architectural patterns: Creational, Behavioral, and Structural popularly known as the Gang of Four patterns. Over the course of the book, you will get a deep understanding of object creation mechanisms, advanced techniques that address issues concerned with linking objects together, and improved methods to access your code. You will also learn about Anti-Patterns and the best methodologies to adopt when building a PHP 7 application. With a concluding chapter on best practices, this book is a complete guide that will equip you to utilize design patterns in PHP 7 to achieve maximum productivity, ensuring an enhanced software development experience. Style and approach The book covers advanced design patterns in detail in PHP 7 with the help of rich code-based examples.
Mastering Palo Alto Networks: Build, configure, and deploy network solutions for your infrastructure using features of PAN-OS, 2nd Edition
by Tom Piens aka 'reaper' Kim Wens aka 'kiwi'Deploy and manage industry-leading PAN-OS 10.x solutions to secure your users and infrastructureKey FeaturesUnderstand how to optimally use PAN-OS featuresBuild firewall solutions to safeguard local, cloud, and mobile networksProtect your infrastructure and users by implementing robust threat prevention solutionsBook DescriptionPalo Alto Networks' integrated platform makes it easy to manage network and cloud security along with endpoint protection and a wide range of security services.This book is an end-to-end guide to configure firewalls and deploy them in your network infrastructure. You will see how to quickly set up, configure and understand the technology, and troubleshoot any issues that may occur. This book will serve as your go-to reference for everything from setting up to troubleshooting complex issues. You will learn your way around the web interface and command-line structure, understand how the technology works so you can confidently predict the expected behavior, and successfully troubleshoot any anomalies you may encounter. Finally, you will see how to deploy firewalls in a cloud environment, and special or unique considerations when setting them to protect resources.By the end of this book, for your configuration setup you will instinctively know how to approach challenges, find the resources you need, and solve most issues efficiently.What you will learnExplore your way around the web interface and command lineDiscover the core technologies and see how to maximize your potential in your networkIdentify best practices and important considerations when configuring a security policyConnect to a freshly booted appliance or VM via a web interface or command-line interfaceGet your firewall up and running with a rudimentary but rigid configurationGain insight into encrypted sessions by setting up SSL decryptionTroubleshoot common issues, and deep-dive into flow analyticsConfigure the GlobalProtect VPN for remote workers as well as site-to-site VPNWho this book is forThe book is for network and security professionals, and administrators who want to bring in the power of Palo Alto Networks and firewalls to secure their networks. Engineers should have a good grasp of networking and routing protocols, basic knowledge of stateful or next-generation firewalls is helpful but not required.
Mastering Palo Alto Networks: Deploy and manage industry-leading PAN-OS 10.x solutions to secure your users and infrastructure
by Tom PiensSet up next-generation firewalls from Palo Alto Networks and get to grips with configuring and troubleshooting using the PAN-OS platformKey FeaturesUnderstand how to optimally use PAN-OS featuresBuild firewall solutions to safeguard local, cloud, and mobile networksProtect your infrastructure and users by implementing robust threat prevention solutionsBook DescriptionTo safeguard against security threats, it is crucial to ensure that your organization is effectively secured across networks, mobile devices, and the cloud. Palo Alto Networks' integrated platform makes it easy to manage network and cloud security along with endpoint protection and a wide range of security services. With this book, you'll understand Palo Alto Networks and learn how to implement essential techniques, right from deploying firewalls through to advanced troubleshooting.The book starts by showing you how to set up and configure the Palo Alto Networks firewall, helping you to understand the technology and appreciate the simple, yet powerful, PAN-OS platform. Once you've explored the web interface and command-line structure, you'll be able to predict expected behavior and troubleshoot anomalies with confidence. You'll learn why and how to create strong security policies and discover how the firewall protects against encrypted threats. In addition to this, you'll get to grips with identifying users and controlling access to your network with user IDs and even prioritize traffic using quality of service (QoS). The book will show you how to enable special modes on the firewall for shared environments and extend security capabilities to smaller locations.By the end of this network security book, you'll be well-versed with advanced troubleshooting techniques and best practices recommended by an experienced security engineer and Palo Alto Networks expert.What you will learnPerform administrative tasks using the web interface and command-line interface (CLI)Explore the core technologies that will help you boost your network securityDiscover best practices and considerations for configuring security policiesRun and interpret troubleshooting and debugging commandsManage firewalls through Panorama to reduce administrative workloadsProtect your network from malicious traffic via threat preventionWho this book is forThis book is for network engineers, network security analysts, and security professionals who want to understand and deploy Palo Alto Networks in their infrastructure. Anyone looking for in-depth knowledge of Palo Alto Network technologies, including those who currently use Palo Alto Network products, will find this book useful. Intermediate-level network administration knowledge is necessary to get started with this cybersecurity book.
Mastering Palo Alto Networks: The complete journey to firewall mastery from setup to advanced security
by Tom Piens 'reaper'Unlock the full potential of Palo Alto Networks firewalls with expert insights and hands-on strategies for mastering next-gen securityKey FeaturesMaster Palo Alto Networks firewalls with hands-on labs and expert guidanceStay up to date with the latest features, including cloud and security enhancementsLearn how to set up and leverage Strata Cloud ManagerPurchase of the print or Kindle book includes a free PDF eBookBook DescriptionMastering Palo Alto Networks is the ultimate guide for anyone looking to become proficient in configuring and managing Palo Alto firewalls. Written by a seasoned security consultant and author with 25 years of expertise in network security, this book provides a comprehensive approach to mastering Palo Alto Networks’ firewalls. If you’ve struggled with managing firewall policies, setting up VPNs, or integrating cloud security, this book will provide clear solutions. You’ll get to grips with the fundamentals, and go through the entire process step by step—from initial setup to advanced configurations, gaining a solid understanding of both on-premise and cloud-based security solutions. Packed with practical examples and expert tips, chapters show you how to deploy and optimize firewall policies, secure your network, and troubleshoot issues effectively. With a focus on real-world applications, this guide covers essential topics like traffic management, threat prevention, VPN setup, and integration with Prisma Access for cloud security. By the end of this book, you’ll have the confidence and expertise to manage even the most complex network security environments, making this a must-have resource for anyone working with Palo Alto Networks.What you will learnSet up and configure Palo Alto firewalls from scratchManage firewall policies for secure network trafficImplement VPNs and remote access solutionsOptimize firewall performance and security settingsUse threat prevention and traffic filtering featuresTroubleshoot common firewall issues effectivelyIntegrate Palo Alto firewalls with cloud servicesConfigure Strata Cloud Manager for network security managementWho this book is forThis book is perfect for network security professionals, IT administrators, and engineers looking to master Palo Alto firewalls. Whether you’re new to network security or aiming to deepen your expertise, this guide will help you overcome configuration challenges and optimize security. Basic networking knowledge is required, but no prior experience with Palo Alto is necessary.
Mastering Parallel Programming with R
by Terence Sloan Eilidh Troup Simon R. Chapple Thorsten ForsterMaster the robust features of R parallel programming to accelerate your data science computations About This Book * Create R programs that exploit the computational capability of your cloud platforms and computers to the fullest * Become an expert in writing the most efficient and highest performance parallel algorithms in R * Get to grips with the concept of parallelism to accelerate your existing R programs Who This Book Is For This book is for R programmers who want to step beyond its inherent single-threaded and restricted memory limitations and learn how to implement highly accelerated and scalable algorithms that are a necessity for the performant processing of Big Data. No previous knowledge of parallelism is required. This book also provides for the more advanced technical programmer seeking to go beyond high level parallel frameworks. What You Will Learn * Create and structure efficient load-balanced parallel computation in R, using R's built-in parallel package * Deploy and utilize cloud-based parallel infrastructure from R, including launching a distributed computation on Hadoop running on Amazon Web Services (AWS) * Get accustomed to parallel efficiency, and apply simple techniques to benchmark, measure speed and target improvement in your own code * Develop complex parallel processing algorithms with the standard Message Passing Interface (MPI) using RMPI, pbdMPI, and SPRINT packages * Build and extend a parallel R package (SPRINT) with your own MPI-based routines * Implement accelerated numerical functions in R utilizing the vector processing capability of your Graphics Processing Unit (GPU) with OpenCL * Understand parallel programming pitfalls, such as deadlock and numerical instability, and the approaches to handle and avoid them * Build a task farm master-worker, spatial grid, and hybrid parallel R programs In Detail R is one of the most popular programming languages used in data science. Applying R to big data and complex analytic tasks requires the harnessing of scalable compute resources. Mastering Parallel Programming with R presents a comprehensive and practical treatise on how to build highly scalable and efficient algorithms in R. It will teach you a variety of parallelization techniques, from simple use of R's built-in parallel package versions of lapply(), to high-level AWS cloud-based Hadoop and Apache Spark frameworks. It will also teach you low level scalable parallel programming using RMPI and pbdMPI for message passing, applicable to clusters and supercomputers, and how to exploit thousand-fold simple processor GPUs through ROpenCL. By the end of the book, you will understand the factors that influence parallel efficiency, including assessing code performance and implementing load balancing; pitfalls to avoid, including deadlock and numerical instability issues; how to structure your code and data for the most appropriate type of parallelism for your problem domain; and how to extract the maximum performance from your R code running on a variety of computer systems. Style and approach This book leads you chapter by chapter from the easy to more complex forms of parallelism. The author's insights are presented through clear practical examples applied to a range of different problems, with comprehensive reference information for each of the R packages employed. The book can be read from start to finish, or by dipping in chapter by chapter, as each chapter describes a specific parallel approach and technology, so can be read as a standalone.
Mastering Perl for Bioinformatics: Perl Programming for Bioinformatics
by James TisdallHistorically, programming hasn't been considered a critical skill for biologists. But now, with access to vast amounts of biological data contained in public databases, programming skills are increasingly in strong demand in biology research and development. Perl, with its highly developed capacities in string handling, text processing, networking, and rapid prototyping, has emerged as the programming language of choice for biological data analysis.Mastering Perl for Bioinformatics covers the core Perl language and many of its module extensions, presenting them in the context of biological data and problems of pressing interest to the biological community. This book, along with Beginning Perl for Bioinformatics, forms a basic course in Perl programming. This second volume finishes the basic Perl tutorial material (references, complex data structures, object-oriented programming, use of modules--all presented in a biological context) and presents some advanced topics of considerable interest in bioinformatics.The range of topics covered in Mastering Perl for Bioinformatics prepares the reader for enduring and emerging developments in critical areas of bioinformatics programming such as:Gene findingString alignmentMethods of data storage and retrieval (SML and databases)Modeling of networks (graphs and Petri nets)Graphics (Tk)ParallelizationInterfacing with other programming languagesStatistics (PDL)Protein structure determinationBiological models of computation (DNA Computers)Biologists and computer scientists who have conquered the basics of Perl and are ready to move even further in their mastery of this versatile language will appreciate the author's well-balanced approach to applying Perl's analytical abilities to the field of bioinformatics. Full of practical examples and real-world biological problem solving, this book is a must for any reader wanting to move beyond beginner level Perl in bioinformatics.
Mastering Perl/Tk: Graphical User Interfaces in Perl
by Stephen Lidie Nancy WalshPerl/Tk is the marriage of the Tk graphical toolkit with Perl, the powerful programming language used primarily for system administration, web programming, and database manipulation. With Perl/Tk, you can build Perl programs with an attractive, intuitive GUI interface with all the power of Perl behind it.Mastering Perl/Tk is the "bible" of Perl/Tk: It's not only a great book for getting started, but the best reference for learning the techniques of experienced Perl/Tk programmers. The first half of the book contains the basics on how to use Perl/Tk, and then branches out into advanced applications with a series of extensive program examples. The result is a book accessible for novices, and invaluable for experienced programmers ready to learn the next step in the elegant and effective use of Perl/Tk. The book includes:An introduction to each of the basic Perl/Tk widgets and geometry managersA dissection of the MainLoop, including how to use callbacks and bindings effectivelyCoverage of the Tix widgets, an extended set of widgets that are a part of the standard Perl/Tk distributionWorking with images in Perl/Tk, including bitmaps, pixmaps, photos, and how to compose a compound image typeHow to create custom mega-widgets in Perl/Tk, both composite and derivedHandling interprocess communication with Perl/Tk, both with standard Unix utilities (pipes and sockets) and with the send command designed for direct communication between Tk applicationsDeveloping your own Tk widget in the C languageExamples of web applications written with Perl/Tk and the LWP libraryThe book also includes appendices on installing Perl/Tk, a complete quick-reference for each standard widget, and listings of all the extended examples in the book.Nancy Walsh is the author of Learning Perl/Tk, and Steve Lidie wrote the Perl/Tk Pocket Reference as well as a series of Perl/Tk articles in The Perl Journal. Together, they have written Mastering Perl/Tk to be the definitive guide to Perl/Tk.
Mastering Perl: A Beginner's Guide (Mastering Computer Science)
by Sufyan Bin UzayrMastering Perl helps readers to learn the Perl programming language with real-world examples. High-level, interpreted, and multipurpose, Perl’s roots are in text manipulation. It is used for UI development in system administration, networking, and other fields, borrowing heavily from C and Shell scripts. Among programmers, Perl is also known as "Pathologically Eclectic Rubbish Lister" or "Practically Everything Really Likable." Since Perl’s inception, it has mostly been used for text processing, namely the extraction of data from text files and its subsequent transformation into other formats. In addition to being interoperable with HTML, XML, and other markup languages, Perl provides cross-platform compatibility. It is Open Source, meaning it is free to use and licensed under both the Artistic and GNU General Public Licenses (GPL). With Mastering Perl, learning Perl becomes a charm and will help readers undoubtedly advance their careers.
Mastering Perl: Creating Professional Programs with Perl
by Brian D FoyTake the next step toward Perl mastery with advanced concepts that make coding easier, maintenance simpler, and execution faster. Mastering Perl isn't a collection of clever tricks, but a way of thinking about Perl programming for solving debugging, configuration, and many other real-world problems you’ll encounter as a working programmer.The third in O’Reilly’s series of landmark Perl tutorials (after Learning Perl and Intermediate Perl), this fully upated edition pulls everything together and helps you bend Perl to your will.Explore advanced regular expressions featuresAvoid common problems when writing secure programsProfile and benchmark Perl programs to see where they need workWrangle Perl code to make it more presentable and readableUnderstand how Perl keeps track of package variablesDefine subroutines on the flyJury-rig modules to fix code without editing the original sourceUse bit operations and bit vectors to store large data efficientlyLearn how to detect errors that Perl doesn’t reportDive into logging, data persistence, and the magic of tied variables
Mastering PhoneGap Mobile Application Development
by Kerri ShottsTake your PhoneGap experience to the next level and create engaging real-world applications About This Book * Create a useful PhoneGap workflow for larger projects in order to simplify and manage the development process * Use third-party plugins, IndexedDB, and SQLite for PhoneGap to develop large-scale, data-driven, and highly accessible applications * A pragmatic guide to construct top-notch large-scale applications using PhoneGap Who This Book Is For If you have created simple applications using PhoneGap in the past and now want to take your workflow and apps to the next level, this book will help you reach your goals. You should have a good working knowledge of HTML, CSS, and JavaScript, and prior experience with PhoneGap. What You Will Learn * Construct build workflows that simplify complex application development * Integrate the next version of JavaScript to simplify your code * Create accessible hybrid applications * Persist and query data using third-party database plugins * Create your own PhoneGap plugins for your unique use cases * Create icons and splash screens suitable for submission to app stores * Publish your app to the Google Play and Apple iTunes stores In Detail PhoneGap is a useful and flexible tool that enables you to create complex hybrid applications for mobile platforms. In addition to the core technology, there is a large and vibrant community that creates third-party plugins that can take your app to the next level. This book will guide you through the process of creating a complex data-driven hybrid mobile application using PhoneGap, web technologies, and third-party plugins. A good foundation is critical, so you will learn how to create a useful workflow to make development easier. From there, the next version of JavaScript (ES6) and the CSS pre-processor SASS are introduced as a way to simplify creating the look of the mobile application. Responsive design techniques are also covered, including the flexbox layout module. As many apps are data-driven, you'll build an application throughout the course of the book that relies upon IndexedDB and SQLite. You'll also download additional content and address how to handle in-app purchases. Furthermore, you'll build your own customized plugins for your particular use case. When the app is complete, the book will guide you through the steps necessary to submit your app to the Google Play and Apple iTunes stores. Style and approach This book is a step-by-step guide, in which the concepts covered are explained with the help of hands-on examples
Mastering Photoshop Layers
by Juergen GulbinsPhotoshop's layers are arguably the most powerful aspect of the software's user interface and are the key to successful image editing in Photoshop. Layers allow for both global and local adjustments to images and can be used to create a number of special effects. Best of all, layers allow for nondestructive editing of your original image. New Photoshop users often see layers as too complicated, and they miss out on the program's full potential. This book will remove the confusion factor by providing an in-depth introduction to layers. Clear, step-by-step instructions and illustrations help the reader quickly master the tools that are relevant for photographers. In this book you will learn about: Working with and building multiple layers Blending layers and which Options to use Using layers to enhance and retouch your images Creating and using layer masks Creating luminosity and saturation layer masks Using Smart Objects and Smart Filters Advanced layer techniques Time-saving shortcuts, tips, and tricks
Mastering Play Framework for Scala
by Shiti SaxenaThis book is intended for those developers who are keen to master the internal workings of Play Framework to effectively build and deploy web-related apps.
Mastering PostCSS for Web Design
by Alex LibbyExplore the power of PostCSS to write highly performing, modular, and modern CSS code for your web pages About This Book * Incorporate cutting-edge styles in your web pages with PostCSS * Simplify the process of writing CSS to a great extent using PostCSS shortcuts, fallbacks, and pack plugins * This in-depth, step-by-step guide will help you master PostCSS, to create amazing and responsive web designs Who This Book Is For This book is ideal for web developers and designers who are comfortable with HTML5 and CSS and now want to master PostCSS for web design. Web designers who have been using SASS or Less and now want to adopt PostCSS would also find this book useful. What You Will Learn * Add mixin and variable support to PostCSS along with conditional support * Explore the different ways of nesting code such as BEM and standard nesting within PostCSS * Optimize media queries built with PostCSS to get the best performance * Add dynamic styling elements such as images, fonts, grids, and SVG and retina support using existing preprocessors as well as PostCSS * Get familiar with using plugins, and extend PostCSS with the API * Build a fully working custom preprocessor and test it on different sites such as WordPress * Write a custom syntax in PostCSS while still using pre-built syntaxes such as Less, SASS, or Stylus * Provide support for future CSS such as CSS4 using current CSS3 classes In Detail PostCSS is a tool that has quickly emerged as the future of existing preprocessors such as SASS and Less, mainly because of its power, speed, and ease of use. This comprehensive guide offers in-depth guidance on incorporating cutting-edge styles into your web page and at the same time maintaining the performance and maintainability of your code. The book will show how you can take advantage of PostCSS to simplify the entire process of stylesheet authoring. It covers various techniques to add dynamic and modern styling features to your web pages. As the book progresses, you will learn how to make CSS code more maintainable by taking advantage of the modular architecture of PostCSS. By the end of this book, you would have mastered the art of adding modern CSS effects to web pages by authoring high performing, maintainable stylesheets. Style and approach This comprehensive book provides in-depth guidance on how to build a PostCSS powered responsive site from scratch. Following a step-by-step approach, you will learn how to add modern styles to web pages. It also contains several tips and best practices on how you can optimize your sites by writing high performing code in PostCSS.
Mastering PostGIS
by Dominik Mikiewicz Michal Mackiewicz Tomasz NyczWrite efficient GIS applications using PostGIS - from data creation to data consumption About This Book • Learn how you can use PostGIS for spatial data analysis and manipulation • Optimize your queries and build custom functionalities for your GIS application • A comprehensive guide with hands-on examples to help you master PostGIS with ease Who This Book Is For If you are a GIS developer or analyst who wants to master PostGIS to build efficient, scalable GIS applications, this book is for you. If you want to conduct advanced analysis of spatial data, this book will also help you. The book assumes that you have a working installation of PostGIS in place, and have working experience with PostgreSQL. What You Will Learn • Refresh your knowledge of the PostGIS concepts and spatial databases • Solve spatial problems with the use of SQL in real-world scenarios • Practical walkthroughs of application development examples using Postgis, GeoServer and OpenLayers. • Extract, transform and load your spatial data • Expose data directly or through web services. • Consume your data in both desktop and web clients In Detail PostGIS is open source extension onf PostgreSQL object-relational database system that allows GIS objects to be stored and allows querying for information and location services. The aim of this book is to help you master the functionalities offered by PostGIS- from data creation, analysis and output, to ETL and live edits. The book begins with an overview of the key concepts related to spatial database systems and how it applies to Spatial RMDS. You will learn to load different formats into your Postgres instance, investigate the spatial nature of your raster data, and finally export it using built-in functionalities or 3th party tools for backup or representational purposes. Through the course of this book, you will be presented with many examples on how to interact with the database using JavaScript and Node.js. Sample web-based applications interacting with backend PostGIS will also be presented throughout the book, so you can get comfortable with the modern ways of consuming and modifying your spatial data. Style and approach This book is a comprehensive guide covering all the concepts you need to master PostGIS. Packed with hands-on examples, tips and tricks, even the most advanced concepts are explained in a very easy-to-follow manner. Every chapter in the book does not only focus on how each task is performed, but also why.
Mastering PostgreSQL 10: Expert Techniques On Postgresql 10 Development And Administration
by Hans-Jürgen Schönig<P><P>Master the capabilities of PostgreSQL 10 to efficiently manage and maintain your database <P><P>Key Features <P><P>Your one-stop guide to mastering advanced concepts in PostgreSQL 10 with ease <P><P>Master query optimization, replication, and high availability with PostgreSQL <P><P>Extend the functionalities of your PostgreSQL instance to suit your organizational needs with minimal effort <P><P>Book Description <P><P>PostgreSQL is an open source database used for handling large datasets (big data) and as a JSON document database. This book highlights the newly introduced features in PostgreSQL 10, and shows you how you can build better PostgreSQL applications, and administer your PostgreSQL database more efficiently. We begin by explaining advanced database design concepts in PostgreSQL 10, along with indexing and query optimization. You will also see how to work with event triggers and perform concurrent transactions and table partitioning, along with exploring SQL and server tuning. We will walk you through implementing advanced administrative tasks such as server maintenance and monitoring, replication, recovery, high availability, and much more. You will understand common and not-so-common troubleshooting problems and how you can overcome them. By the end of this book, you will have an expert-level command of advanced database functionalities and will be able to implement advanced administrative tasks with PostgreSQL 10. <P><P>What you will learn <P><P>Get to grips with the advanced features of PostgreSQL 10 and handle advanced SQL <P><P>Make use of the indexing features in PostgreSQL and fine-tune the performance of your queries <P><P>Work with stored procedures and manage backup and recovery <P><P>Master replication and failover techniques <P><P>Troubleshoot your PostgreSQL instance for solutions to common and not-so-common problems <P><P>Learn how to migrate your database from MySQL and Oracle to <P><P>PostgreSQL without any hassle <P><P>Who This Book Is For <P><P>If you are a PostgreSQL data architect or an administrator and want to understand how to implement advanced functionalities and master complex administrative tasks with PostgreSQL 10, then this book is perfect for you. Prior experience of administrating a PostgreSQL database and a working knowledge of SQL are required to make the best use of this book.
Mastering PostgreSQL 10: Expert techniques on PostgreSQL 10 development and administration
by Hans-Jürgen SchönigMaster the capabilities of PostgreSQL 10 to efficiently manage and maintain your database Key Features Your one-stop guide to mastering advanced concepts in PostgreSQL 10 with ease Master query optimization, replication, and high availability with PostgreSQL Extend the functionalities of your PostgreSQL instance to suit your organizational needs with minimal effort Book Description PostgreSQL is an open source database used for handling large datasets (big data) and as a JSON document database. This book highlights the newly introduced features in PostgreSQL 10, and shows you how you can build better PostgreSQL applications, and administer your PostgreSQL database more efficiently. We begin by explaining advanced database design concepts in PostgreSQL 10, along with indexing and query optimization. You will also see how to work with event triggers and perform concurrent transactions and table partitioning, along with exploring SQL and server tuning. We will walk you through implementing advanced administrative tasks such as server maintenance and monitoring, replication, recovery, high availability, and much more. You will understand common and not-so-common troubleshooting problems and how you can overcome them. By the end of this book, you will have an expert-level command of advanced database functionalities and will be able to implement advanced administrative tasks with PostgreSQL 10. What you will learn Get to grips with the advanced features of PostgreSQL 10 and handle advanced SQL Make use of the indexing features in PostgreSQL and fine-tune the performance of your queries Work with stored procedures and manage backup and recovery Master replication and failover techniques Troubleshoot your PostgreSQL instance for solutions to common and not-so-common problems Learn how to migrate your database from MySQL and Oracle to PostgreSQL without any hassleWho this book is for If you are a PostgreSQL data architect or an administrator and want to understand how to implement advanced functionalities and master complex administrative tasks with PostgreSQL 10, then this book is perfect for you. Prior experience of administrating a PostgreSQL database and a working knowledge of SQL are required to make the best use of this book.
Mastering PostgreSQL 11: Expert techniques to build scalable, reliable, and fault-tolerant database applications, 2nd Edition
by Hans-Jürgen SchönigMaster the capabilities of PostgreSQL 11 to efficiently manage and maintain your databaseKey FeaturesMaster advanced concepts of PostgreSQL 11 with real-world datasets and examplesExplore query parallelism, data replication, and database performance while working with larger datasetsExtend the functionalities of your PostgreSQL instance to suit your organization’s needs with minimal effortBook DescriptionThis second edition of Mastering PostgreSQL 11 helps you build dynamic database solutions for enterprise applications using the latest release of PostgreSQL, which enables database analysts to design both the physical and technical aspects of the system architecture with ease.This book begins with an introduction to the newly released features in PostgreSQL 11 to help you build efficient and fault-tolerant PostgreSQL applications. You’ll examine all of the advanced aspects of PostgreSQL in detail, including logical replication, database clusters, performance tuning, monitoring, and user management. You will also work with the PostgreSQL optimizer, configuring PostgreSQL for high speed, and see how to move from Oracle to PostgreSQL. As you progress through the chapters, you will cover transactions, locking, indexes, and optimizing queries to improve performance. Additionally, you’ll learn to manage network security and explore backups and replications, while understanding the useful extensions of PostgreSQL so that you can optimize the speed and performance of large databases. By the end of this book, you will be able to use your database to its utmost capacity by implementing advanced administrative tasks with ease.What you will learnGet to grips with advanced PostgreSQL 11 features and SQL functionsMake use of the indexing features in PostgreSQL and fine-tune the performance of your queriesWork with stored procedures and manage backup and recoveryMaster replication and failover techniquesTroubleshoot your PostgreSQL instance for solutions to common and not-so-common problemsPerform database migration from MySQL and Oracle to PostgreSQL with easeWho this book is forThis book is for data and database professionals wanting to implement advanced functionalities and master complex administrative tasks with PostgreSQL 11. Prior experience of database administration with PostgreSQL database will aid in understanding the concepts covered in this book.
Mastering PostgreSQL 12: Advanced techniques to build and administer scalable and reliable PostgreSQL database applications, 3rd Edition
by Hans-Jurgen SchonigMaster PostgreSQL 12 features such as advanced indexing, high availability, monitoring, and much more to efficiently manage and maintain your database Key Features Grasp advanced PostgreSQL 12 concepts with real-world examples and sample datasets Explore query parallelism, data replication, database administration, and more Extend PostgreSQL functionalities to suit your organization's needs with minimal effort Book Description Thanks to its reliability, robustness, and high performance, PostgreSQL has become the most advanced open source database on the market. This third edition of Mastering PostgreSQL helps you build dynamic database solutions for enterprise applications using the latest release of PostgreSQL, which enables database analysts to design both physical and technical aspects of system architecture with ease. Starting with an introduction to the newly released features in PostgreSQL 12, this book will help you build efficient and fault-tolerant PostgreSQL applications. You'll thoroughly examine the advanced features of PostgreSQL, including logical replication, database clusters, performance tuning, monitoring, and user management. You'll also work with the PostgreSQL optimizer, configure PostgreSQL for high speed, and understand how to move from Oracle to PostgreSQL. As you progress through the chapters, you'll cover transactions, locking, indexes, and how to optimize queries for improved performance. Additionally, you'll learn how to manage network security and explore backups and replications while understanding useful PostgreSQL extensions to help you in optimizing the performance of large databases. By the end of this PostgreSQL book, you'll be able to get the most out of your database by implementing advanced administrative tasks effortlessly. What you will learn Understand the advanced SQL functions in PostgreSQL 12 Use indexing features in PostgreSQL to fine-tune the performance of queries Work with stored procedures and manage backup and recovery Master replication and failover techniques to reduce data loss Replicate PostgreSQL database systems to create backups and to scale your database Manage and improve the security of your server to protect your data Troubleshoot your PostgreSQL instance for solutions to common and not-so-common problems Who this book is for This book is for PostgreSQL developers and administrators and database professionals who want to implement advanced functionalities and master complex administrative tasks with PostgreSQL 12. Prior exposure to PostgreSQL as well as familiarity with the basics of database administration is expected.
Mastering PostgreSQL 13: Build, administer, and maintain database applications efficiently with PostgreSQL 13, 4th Edition
by Hans-Jurgen SchonigExplore expert techniques such as advanced indexing and high availability to build scalable, reliable, and fault-tolerant database applications using PostgreSQL 13Key FeaturesMaster advanced PostgreSQL 13 concepts with the help of real-world datasets and examplesLeverage PostgreSQL's indexing features to fine-tune the performance of your queriesExtend PostgreSQL's functionalities to suit your organization's needs with minimal effortBook DescriptionThanks to its reliability, robustness, and high performance, PostgreSQL has become one of the most advanced open source databases on the market. This updated fourth edition will help you understand PostgreSQL administration and how to build dynamic database solutions for enterprise apps with the latest release of PostgreSQL, including designing both physical and technical aspects of the system architecture with ease.Starting with an introduction to the new features in PostgreSQL 13, this book will guide you in building efficient and fault-tolerant PostgreSQL apps. You'll explore advanced PostgreSQL features, such as logical replication, database clusters, performance tuning, advanced indexing, monitoring, and user management, to manage and maintain your database. You'll then work with the PostgreSQL optimizer, configure PostgreSQL for high speed, and move from Oracle to PostgreSQL. The book also covers transactions, locking, and indexes, and shows you how to improve performance with query optimization. You'll also focus on how to manage network security and work with backups and replication while exploring useful PostgreSQL extensions that optimize the performance of large databases.By the end of this PostgreSQL book, you'll be able to get the most out of your database by executing advanced administrative tasks.What you will learnGet well versed with advanced SQL functions in PostgreSQL 13Get to grips with administrative tasks such as log file management and monitoringWork with stored procedures and manage backup and recoveryEmploy replication and failover techniques to reduce data lossPerform database migration from Oracle to PostgreSQL with easeReplicate PostgreSQL database systems to create backups and scale your databaseManage and improve server security to protect your dataTroubleshoot your PostgreSQL instance to find solutions to common and not-so-common problemsWho this book is forThis database administration book is for PostgreSQL developers and database administrators and professionals who want to implement advanced functionalities and master complex administrative tasks with PostgreSQL 13. Prior experience in PostgreSQL and familiarity with the basics of database administration will assist with understanding key concepts covered in the book.
Mastering PostgreSQL 15: Advanced techniques to build and manage scalable, reliable, and fault-tolerant database applications, 5th Edition
by Hans-Jurgen SchonigMaster the capabilities of PostgreSQL 15 to efficiently administer and maintain your database.Purchase of the print or Kindle book includes a free PDF eBook.Key FeaturesUsing real world examples, get to grips with expert PostgreSQL 15 conceptsExplore performance improvement, database replication, data replication, database administration, and moreExtend PostgreSQL's functionalities to suit your organization's needs with minimal effortBook DescriptionStarting with an introduction to the newly released features of PostgreSQL 15, this updated fifth edition will help you get to grips with PostgreSQL administration and how to build dynamic database solutions for enterprise apps, including designing both physical and technical aspects of the system.You'll explore advanced PostgreSQL features, such as logical replication, database clusters, advanced indexing, and user management to manage and maintain your database. You'll then work with the PostgreSQL optimizer, configure PostgreSQL for high speed, and move from Oracle to PostgreSQL. Among the other skills that the book will help you build, you'll cover transactions, handling recursions, working with JSON and JSONB data, and setting up a Patroni cluster. It will show you how to improve performance with query optimization. You'll also focus on managing network security and work with backups and replication while exploring useful PostgreSQL extensions that optimize the performance of large databases.By the end of this PostgreSQL book, you'll be able to use your database to its utmost capacity by implementing advanced administrative tasks with ease.What you will learnMake use of the indexing features in PostgreSQL and fine-tune the performance of your queriesWork with stored procedures and manage backup and recoveryGet the hang of replication and failover techniquesImprove the security of your database server and handle encryption effectivelyTroubleshoot your PostgreSQL instance for solutions to common and not-so-common problemsPerform database migration from Oracle to PostgreSQL with easeWho this book is forThis database administration book is for PostgreSQL developers, database administrators, and professionals who want to implement advanced functionalities and master complex administrative tasks with PostgreSQL 15. Prior experience in PostgreSQL and familiarity with the basics of database administration will assist with understanding key concepts covered in the book.
Mastering PostgreSQL 9.6
by Hans-Jurgen SchonigMaster the capabilities of PostgreSQL 9.6 to efficiently manage and maintain your database About This Book • Your one-stop guide to mastering the advanced concepts in PostgreSQL with ease • Master query optimization, replication, and high availability with PostgreSQL • Extend the functionalities of PostgreSQL to suit your organizational needs with minimum effort Who This Book Is For If you are a PostgreSQL data architect or an administrator who wants to understand how to implement advanced functionalities and master complex administrative tasks with PostgreSQL, then this book is perfect for you. Prior experience of administrating a PostgreSQL database and a working knowledge of SQL is required to make the best use of this book. What You Will Learn • Get to grips with the advanced features of PostgreSQL 9.6 and handle advanced SQL • Make use of the indexing features in PostgreSQL and fine-tune the performance of your queries • Work with the stored procedures and manage backup and recovery • Master the replication and failover techniques • Troubleshoot your PostgreSQL instance for solutions to the common and not-so-common problems • Learn how to migrate your database from MySQL and Oracle to PostgreSQL without any hassle In Detail PostgreSQL is an open source database used for handling large datasets (Big Data) and as a JSON document database. It also has applications in the software and web domains. This book will enable you to build better PostgreSQL applications and administer databases more efficiently. We begin by explaining the advanced database design concepts in PostgreSQL 9.6, along with indexing and query optimization. You will also see how to work with event triggers and perform concurrent transactions and table partitioning, along with exploring SQL and server tuning. We will walk you through implementing advanced administrative tasks such as server maintenance and monitoring, replication, recovery and high availability, and much more. You will understand the common and not-so-common troubleshooting problems and how you can overcome them. By the end of this book, you will have an expert-level command of the advanced database functionalities and will be able to implement advanced administrative tasks with PostgreSQL. Style and Approach This book is a comprehensive guide covering all the concepts you need to master PostgreSQL. Packed with hands-on examples, tips and tricks, even the most advanced concepts are explained in a very easy-to-follow manner. Every chapter in the book does not only focus on how each task is performed, but also why.
Mastering PowerCLI
by Sajal DebnathMaster PowerCLI to automate all aspects of VMware environments About This Book * Leverage PowerCLI to perform administration tasks in a more effective and efficient way * Escape from daily tedious and repetitive tasks by unleashing the full potential of your creative side through scripting * Master the intricate workings of PowerShell and PowerCLI through easy and real-life examples Who This Book Is For If you are a system administrator with working knowledge of PowerShell and PowerCLI who wants to perform quick and easy scripting but at the same time achieve complex results and write production grade scripts, then this book is for you. What You Will Learn * Use GitHub for collaboration and Pester to automate unit tests * Write advanced reusable functions and dynamic variables and learn about error handling in PowerShell * Automate ESXi host installation using Auto-Deploy, host profile, and host image * Implement security best practices in a vSphere data center * Manage SRM, vCloud Air, and vRealize Operations environments * Access and utilize vSphere APIs to manage advanced aspects of vSphere and work with .NET view objects * Utilize REST APIs to manage vRealize Automation environments * Create a Windows GUI through the use of PowerShell and Sapien PrimalForms CE In Detail Have you ever wished that every morning you could automatically get a report with all the relevant information about your datacenter in exactly the same format you want? Or whether you could automate that boring, exhausting task? What if some crucial task needs to be performed on a regular basis without any error? PowerCLI scripts do all that and much more for VMware environments. It is built on top of the popular Windows PowerShell, with which you can automate server tasks and reduce manual input, allowing you to focus on more important tasks. This book will help you to achieve your goals by starting with a short refresher on PowerShell and PowerCLI and then covering the nuances of advanced functions and reusable scripts. Next you will learn how to build a vSphere-powered virtualized datacenter using PowerCLI while managing different aspects of the environment including automated installation, network, and storage. You will then manage different logical constructs of vSphere environment and different aspects of a virtual machine. Later, you will implement the best practices for a security implementation in vSphere Environment through PowerCLI before discovering how to manage other VMware environments such as SRM, vCloud Director and vCloud Air through PowerCLI. You will also learn to manage vSphere environments using advanced properties by accessing vSphere API and REST APIs through PowerCLI. Finally, you will build a Windows GUI application using PowerShell followed by a couple of sample scripts for reporting and managing vSphere environments with detailed explanations of the scripts. By the end of the book, you will have the required in-depth knowledge to master the art of PowerCLI scripting. Style and approach In this book, every topic is explained in a very easy-to-follow fashion with real-life, simple examples so that you get an idea of not only the topic but also the context in which it should be used or where it can be best utilized.
Mastering PowerShell Scripting: Automate and manage your environment using PowerShell 7.1
by Chris DentThis complete guide takes you on a tour of PowerShell from the basics to its advanced functionality, helping you automate your tedious and time-consuming system admin tasksKey FeaturesAutomate complex tasks, manipulate data, and secure your environmentWork with dual code for PowerShell 7 and Windows PowerShell to maintain compatibility with older versionsSee PowerShell in action, from learning the fundamentals to creating classes, scripts, and modulesBook DescriptionPowerShell scripts offer a convenient way to automate various tasks, but working with them can be daunting. Mastering PowerShell Scripting takes away the fear and helps you navigate through PowerShell's capabilities.This extensively revised edition includes new chapters on debugging and troubleshooting and creating GUIs (online chapter). Learn the new features of PowerShell 7.1 by working with parameters, objects, and .NET classes from within PowerShell 7.1. This comprehensive guide starts with the basics before moving on to advanced topics, including asynchronous processing, desired state configuration, using more complex scripts and filters, debugging issues, and error-handling techniques. Explore how to efficiently manage substantial amounts of data and interact with other services using PowerShell 7.1. This book will help you to make the most of PowerShell's automation features, using different methods to parse data, manipulate regular expressions, and work with Windows Management Instrumentation (WMI).What you will learnOptimize code with functions, switches, and looping structuresTest and debug your scripts as well as raising and catching errorsWork with objects and operators to test and manipulate dataParse and manipulate different data typesUse jobs, runspaces, and runspace pools to run code asynchronouslyWrite .NET classes with ease within PowerShellCreate and implement regular expressions in PowerShell scriptsMake use of advanced techniques to define and restrict the behavior of parametersWho this book is forThis book is for system administrators who want to automate and speed up their processes using PowerShell and Windows PowerShell. You’ll need to know the basics of operating systems, but beginners with no prior experience with PowerShell will have no trouble following along.
Mastering PowerShell Scripting: Automate and manage your environment using PowerShell 7.1, 4th Edition
by Chris DentGrasp advanced PowerShell 7.1 functionalities for effective automation of your environmentKey FeaturesSee PowerShell in action, from learning the fundamentals to creating classes, scripts, and modulesWork with dual code for PowerShell 7 and Windows PowerShellAutomate complex tasks, manipulate data, and secure your environmentBook DescriptionPowerShell scripts offer a convenient way to automate various tasks. This comprehensive guide starts with the basics before moving on to advanced topics to help you become a PowerShell 7.1 expert. This extensively revised edition includes two new chapters on debugging and troubleshooting and creating GUIs. Learn the new features of PowerShell 7.1 by working with parameters, objects, and .NET classes from within PowerShell 7.1. As you work through the chapters, you'll see how to efficiently manage substantial amounts of data and interact with other services using PowerShell 7.1. Make the most of PowerShell's automation features, using different methods to parse data, manipulate regular expressions, and work with Windows Management Instrumentation (WMI). Advanced topics include asynchronous processing, desired state configuration, using more complex scripts and filters, debugging issues, and error-handling techniques. By the end of this PowerShell book, you will be an expert in scripting with PowerShell 7.1.What you will learnOptimize code with functions, switches, and looping structuresWork with objects and operators to test and manipulate dataParse and manipulate different data typesCreate scripts and functions using PowerShellUse jobs, runspaces, and runspace pools to run code asynchronouslyWrite .NET classes with ease within PowerShellCreate and implement regular expressions in PowerShell scriptsMake use of advanced techniques to define and restrict the behavior of parametersWho this book is forThis book is aimed at beginners who want to understand the basics as well as experienced system administrators looking to extend their knowledge.Prior knowledge of PowerShell is beneficial but not essential to get the most value from this book. Some familiarity with operating systems would be useful, but not essential.
Mastering PowerShell Scripting: Automate repetitive tasks and simplify complex administrative tasks using PowerShell
by Chris DentUse PowerShell to save time and reduce the potential for human error by writing scripts that automate the execution of tasks Purchase of the print or Kindle book includes a free PDF eBook.Key FeaturesPractical guide to using PowerShell as a programming language for automation and scriptingInsights into leveraging PowerShell’s built-in features for efficient day-to-day automationStrategies for automating complex tasks, managing data, and strengthening environment securityBook DescriptionMastering PowerShell Scripting, Fifth Edition, is your comprehensive guide to harnessing PowerShell’s full potential. This edition introduces new chapters on debugging, troubleshooting, and creating GUIs while covering the latest enhancements in PowerShell 7.3, including parameters, objects, and .NET classes. The book takes you from foundational concepts to advanced techniques, covering asynchronous processing, desired state configuration, and managing large datasets. You'll explore PowerShell’s automation features, error-handling strategies, and integration with external services. Additionally, this guide provides practical insights into working with regular expressions, Windows Management Instrumentation, and complex scripting methods. By the end of this book, you’ll have the skills to efficiently automate tasks, troubleshoot scripts, and leverage PowerShell’s advanced capabilities for real-world scenarios.What you will learnCreate scripts that run across systems for automationExtend PowerShell by integrating it with other languagesUse PowerShell's command-line interface for efficient operationsDevelop reusable scripts and functions to streamline tasksApply PowerShell for administration, automation, and data processingIntegrate with .NET, COM, and WMI for advanced functionalityWork with XML, JSON, and CSV for structured data handlingBuild custom modules and cmdlets to enhance scriptingWho this book is forThis book is for system administrators who want to automate and speed up their processes using PowerShell and Windows PowerShell. You'll need to know the basics of operating systems, but beginners with no prior experience with PowerShell will have no trouble following along.