- Table View
- List View
Mastering Perl
by Brian D FoyThis is the third in O'Reilly's series of landmark Perl tutorials, which started with Learning Perl, the bestselling introduction that taught you the basics of Perl syntax, and Intermediate Perl, which taught you how to create re-usable Perl software. Mastering Perl pulls everything together to show you how to bend Perl to your will. It convey's Perl's special models and programming idioms. This book isn't a collection of clever tricks, but a way of thinking about Perl programming so you can integrate the real-life problems of debugging, maintenance, configuration, and other tasks you encounter as a working programmer. The book explains how to: Use advanced regular expressions, including global matches, lookarounds, readable regexes, and regex debugging Avoid common programing problems with secure programming techniques Profile and benchmark Perl to find out where to focus your improvements Wrangle Perl code to make it more presentable and readable See how Perl keeps track of package variables and how you can use that for some powerful tricks Define subroutines on the fly and turn the tables on normal procedural programming. Modify and jury rig modules to fix code without editing the original source Let your users configure your programs without touching the code Learn how you can detect errors Perl doesn't report, and how to tell users about them Let your Perl program talk back to you by using Log4perl Store data for later use in another program, a later run of the same program, or to send them over a network Write programs as modules to get the benefit of Perl's distribution and testing tools Appendices include "brian's Guide to Solving Any Perl Problem" to improve your troubleshooting skills, as well as suggested reading to continue your Perl education. Mastering Perl starts you on your path to becoming the person with the answers, and, failing that, the person who knows how to find the answers or discover the problem.
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 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 finding String alignment Methods of data storage and retrieval (SML and databases) Modeling of networks (graphs and Petri nets) Graphics (Tk) Parallelization Interfacing with other programming languages Statistics (PDL) Protein structure determination Biological 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
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 managers A dissection of the MainLoop, including how to use callbacks and bindings effectively Coverage of the Tix widgets, an extended set of widgets that are a part of the standard Perl/Tk distribution Working with images in Perl/Tk, including bitmaps, pixmaps, photos, and how to compose a compound image type How to create custom mega-widgets in Perl/Tk, both composite and derived Handling interprocess communication with Perl/Tk, both with standard Unix utilities (pipes and sockets) and with the send command designed for direct communication between Tk applications Developing your own Tk widget in the C language Examples of web applications written with Perl/Tk and the LWP library The 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 pfSense
by David ZientaraMaster the art of managing, securing, and monitoring your network using the powerful pfSense 2.3 About This Book * You can always do more to secure your software - so extend and customize your pfSense firewall * Build a high availability security system that's fault tolerant - and capable of blocking any threats * Put the principles of better security into practice - unlock a more stable and reliable firewall Who This Book Is For SysAdmins and security pros - get more from the world's leading firewall with this book. You can always do more to secure your software, so start here. What You Will Learn * Configure pfSense services such as DHCP, Dynamic DNS, captive portal, DNS, NTP and SNMP * Set up a managed switch to work with VLANs * Use pfSense to allow, block and deny traffic * Make use of the traffic shaper to lower and raise the priority of certain types of traffic * Set up and connect to a VPN tunnel with pfSense * Incorporate redundancy and high availability by utilizing load balancing and the Common Address Redundancy Protocol (CARP) * Explore diagnostic tools in pfSense to solve network problems In Detail pfSense has the same reliability and stability as even the most popular commercial firewall offerings on the market - but, like the very best open-source software, it doesn't limit you. You're in control - you can exploit and customize pfSense around your security needs. If you're familiar with pfSense you probably knew that already. This book builds on any knowledge you may already have, and provides you with a clear route to expand your skills and pfSense's capabilities. You'll learn how to customize and configure pfSense to construct a firewall that can protect you from any potential security threats. Find out how to set up a VPN, and build a high-availability system that provides redundancy and fault tolerance - essential when security and software performance are so interdependent. With further guidance on how to use a diverse range of third-party packages - all of which will help you unlock more from pfSense, this book covers everything you need - and more - to get a high-quality, reliable firewall up and running for a fraction of the cost. Style and approach Practical and actionable, tackle some advanced functionalities of pfSense with minimum fuss. We know you don't just want an instruction manual - you want to put the principles of better security into practice. That's exactly why we produced this book.
Mastering pfSense,: Manage, secure, and monitor your on-premise and cloud network with pfSense 2.4, 2nd Edition
by David ZientaraInstall and configure a pfSense router/firewall, and become a pfSense expert in the process.Key FeaturesYou can always do more to secure your software – so extend and customize your pfSense firewallBuild a high availability security system that’s fault-tolerant – and capable of blocking potential threatsPut the principles of better security into practice by implementing examples provided in the textBook DescriptionpfSense has the same reliability and stability as even the most popular commercial firewall offerings on the market – but, like the very best open-source software, it doesn’t limit you. You’re in control – you can exploit and customize pfSense around your security needs.Mastering pfSense - Second Edition, covers features that have long been part of pfSense such as captive portal, VLANs, traffic shaping, VPNs, load balancing, Common Address Redundancy Protocol (CARP), multi-WAN, and routing. It also covers features that have been added with the release of 2.4, such as support for ZFS partitions and OpenVPN 2.4. This book takes into account the fact that, in order to support increased cryptographic loads, pfSense version 2.5 will require a CPU that supports AES-NI. The second edition of this book places more of an emphasis on the practical side of utilizing pfSense than the previous edition, and, as a result, more examples are provided which show in step-by-step fashion how to implement many features.What you will learnConfigure pfSense services such as DHCP, Dynamic DNS, captive portal, DNS, NTP and SNMPSet up a managed switch to work with VLANsUse pfSense to allow, block and deny traffic, and to implement Network Address Translation (NAT)Make use of the traffic shaper to lower and raise the priority of certain types of trafficSet up and connect to a VPN tunnel with pfSenseIncorporate redundancy and high availability by utilizing load balancing and the Common Address Redundancy Protocol (CARP)Explore diagnostic tools in pfSense to solve network problemsWho this book is forThis book is for those with at least an intermediate understanding of networking. Prior knowledge of pfSense would be helpful but is not required.Those who have the resources to set up a pfSense firewall, either in a real or virtual environment, will especially benefit, as they will be able to follow along with the examples in the book.
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 PHP 7
by Branko AjzeleEffective, readable, and robust codes in PHP About This Book • Leverage the newest tools available in PHP 7 to build scalable applications • Embrace serverless architecture and the reactive programming paradigm, which are the latest additions to the PHP ecosystem • Explore dependency injection and implement design patterns to write elegant code Who This Book Is For This book is for intermediate level developers who want to become a master of PHP. Basic knowledge of PHP is required across areas such as basic syntax, types, variables, constants, expressions, operators, control structures, and functions. What You Will Learn • Grasp the current state of PHP language and the PHP standards • Effectively implement logging and error handling during development • Build services through SOAP and REST and Apache Trift • Get to know the benefits of serverless architecture • Understand the basic principles of reactive programming to write asynchronous code • Practically implement several important design patterns • Write efficient code by executing dependency injection • See the working of all magic methods • Handle the command-line area tools and processes • Control the development process with proper debugging and profiling In Detail PHP is a server-side scripting language that is widely used for web development. With this book, you will get a deep understanding of the advanced programming concepts in PHP and how to apply it practically The book starts by unveiling the new features of PHP 7 and walks you through several important standards set by PHP Framework Interop Group (PHP-FIG). You'll see, in detail, the working of all magic methods, and the importance of effective PHP OOP concepts, which will enable you to write effective PHP code. You will find out how to implement design patterns and resolve dependencies to make your code base more elegant and readable. You will also build web services alongside microservices architecture, interact with databases, and work around third-party packages to enrich applications. This book delves into the details of PHP performance optimization. You will learn about serverless architecture and the reactive programming paradigm that found its way in the PHP ecosystem. The book also explores the best ways of testing your code, debugging, tracing, profiling, and deploying your PHP application. By the end of the book, you will be able to create readable, reliable, and robust applications in PHP to meet modern day requirements in the software industry. Style and approach This is a comprehensive, step-by-step practical guide to developing scalable applications using PHP 7.1
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 phpMyAdmin 3.1 for Effective MySQL Management
by Marc DelisleThe book is a step-by-step tutorial for phpMyAdmin explaining and demonstrating the potential of this tool with clear instructions and screenshots. After covering installation and basic features of phpMyAdmin it goes on to show its less well known and generally under-used features and capabilities. phpMyAdmin is a must-have tool for everyone who needs to manage their MySQL databases and tables in an effective manner. This book is a must-read for every serious phpMyAdmin user who would like to use this outstanding application to its full power.
Mastering phpMyAdmin 3.1 for Effective MySQL Management
by Marc DelisleThe book is a step-by-step tutorial for phpMyAdmin explaining and demonstrating the potential of this tool with clear instructions and screenshots. After covering installation and basic features of phpMyAdmin it goes on to show its less well known and generally under-used features and capabilities. phpMyAdmin is a must-have tool for everyone who needs to manage their MySQL databases and tables in an effective manner. This book is a must-read for every serious phpMyAdmin user who would like to use this outstanding application to its full power.
Mastering phpMyAdmin 3.3.x for Effective MySQL Management
by Marc DelisleThis is a step-by-step instructional guide to get you started easily with phpMyAdmin and teach you to manage and perform database functions on your database. You will first be introduced to the interface and then build basic tables and perform both simple and advanced functions on the created database. The book progresses gradually and you will follow it best by reading it sequentially. If you are a developer or system administrator or web designer who wants to manage MySQL databases and tables efficiently, this book is for you. This book assumes you already are well acquainted with MySQL basics. This book is a must-read for every serious phpMyAdmin user who would like to use this outstanding application to its full power.
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, 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.