EBookClubs

Read Books & Download eBooks Full Online

EBookClubs

Read Books & Download eBooks Full Online

Book Mastering Hibernate

    Book Details:
  • Author : Ramin Rad
  • Publisher : Packt Publishing Ltd
  • Release : 2016-05-16
  • ISBN : 178528875X
  • Pages : 204 pages

Download or read book Mastering Hibernate written by Ramin Rad and published by Packt Publishing Ltd. This book was released on 2016-05-16 with total page 204 pages. Available in PDF, EPUB and Kindle. Book excerpt: Learn how to correctly utilize the most popular Object-Relational Mapping tool for your Enterprise application About This Book Understand the internals of Hibernate and its architecture, and how it manages Entities, Events, Versioning, Filters, and Cache Observe how Hibernate bridges the gap between object-oriented concepts and relational models Discover how Hibernate can address architectural concerns such as Transaction, Database Multi-tenancy, Clustering, and Database Shards Who This Book Is For Mastering Hibernate is intended for those who are already using or considering using Hibernate as the solution to address the problem of Object Relational Mapping. If you are already using Hibernate, this book will help you understand the internals and become a power user of Hibernate. What You Will Learn Understand the internals of a Hibernate session and how Entities are managed Declare better mapping between entity classes and database tables Manage entity associations and collections Fetch data not just by entity ID, but also using HQL, Criteria Objects, Filters, and Native SQL Observe the first and second level caches and find out how to manage them Collect statistics and metrics data for further observation Make your application work with multi-tenant databases In Detail Hibernate has been so successful since its inception that it even influenced the Java Enterprise Edition specification in that the Java Persistence API was dramatically changed to do it the Hibernate way. Hibernate is the tool that solves the complex problem of Object Relational Mapping. It can be used in both Java Enterprise applications as well as .Net applications. Additionally, it can be used for both SQL and NoSQL data stores. Some developers learn the basics of Hibernate and hit the ground quickly. But when demands go beyond the basics, they take a reactive approach instead of learning the fundamentals and core concepts. However, the secret to success for any good developer is knowing and understanding the tools at your disposal. It's time to learn about your tool to use it better This book first explores the internals of Hibernate by discussing what occurs inside a Hibernate session and how Entities are managed. Then, we cover core topics such as mapping, querying, caching, and we demonstrate how to use a wide range of very useful annotations. Additionally, you will learn how to create event listeners or interceptors utilizing the improved architecture in the latest version of Hibernate. Style and approach This book takes a close look at the core topics, and helps you understand the complex topics by showing you examples and giving you in-depth discussions.

Book Mastering Java

    Book Details:
  • Author : Cybellium Ltd
  • Publisher : Cybellium Ltd
  • Release : 2023-09-06
  • ISBN :
  • Pages : 320 pages

Download or read book Mastering Java written by Cybellium Ltd and published by Cybellium Ltd. This book was released on 2023-09-06 with total page 320 pages. Available in PDF, EPUB and Kindle. Book excerpt: Cybellium Ltd is dedicated to empowering individuals and organizations with the knowledge and skills they need to navigate the ever-evolving computer science landscape securely and learn only the latest information available on any subject in the category of computer science including: - Information Technology (IT) - Cyber Security - Information Security - Big Data - Artificial Intelligence (AI) - Engineering - Robotics - Standards and compliance Our mission is to be at the forefront of computer science education, offering a wide and comprehensive range of resources, including books, courses, classes and training programs, tailored to meet the diverse needs of any subject in computer science. Visit https://www.cybellium.com for more books.

Book Mastering Java and Advanced Software Development

Download or read book Mastering Java and Advanced Software Development written by Aditya Pratap Bhuyan and published by Aditya Pratap Bhuyan. This book was released on 2024-07-25 with total page 515 pages. Available in PDF, EPUB and Kindle. Book excerpt: "Mastering Java and Advanced Software Development: A Comprehensive Guide to Technical Interview Preparation" is your ultimate resource for excelling in software development interviews and advancing your career. Covering a wide range of topics including Java programming, J2EE, Spring, Spring Boot, cloud technologies, SDLC, project management, software engineering, configuration management, Java optimization, memory management, data structures, algorithms, databases (RDBMS, SQL, NoSQL), database architecture, and Java security, this book provides detailed questions and answers to help you master the core concepts and advanced practices essential for modern software development. Equip yourself with the knowledge and confidence to tackle technical interviews and build robust, scalable applications.

Book Mastering Java EE Development with WildFly

Download or read book Mastering Java EE Development with WildFly written by Luca Stancapiano and published by Packt Publishing Ltd. This book was released on 2017-06-20 with total page 455 pages. Available in PDF, EPUB and Kindle. Book excerpt: Your one stop solution to create highly scalable enterprise grade Java applications with WildFly. About This Book Master Java EE development with the latest WildFly 10 application server. Integrate with JSF and JMS and use efficient load balancing techniques to create real-time apps Integrate your backend JavaScript code seamlessly into Java applications Who This Book Is For If you are a Java developer with at least basic knowledge of Java EE, then this book is for you. No previous knowledge of WildFly is required. What You Will Learn Configure the development environment along with native and cloud installation of WildFly Write a DB schema and the relative entities and how to use the relationships between the entities Analyze with examples all the java annotations to manage the EJB and the configuration to get better performances Write different REST services through the EJB Implement Web sockets 1.0 and know why and when use the web sockets Work with Active MQ and write JMS clients to manage the authentication and authorization in the clients Configure the mail server through the wildfly console Learn how and when to use a new feature JAX-RS 2.0, which is the asynchronous call through REST Use the new JSF features of Wildfly 10 such as Mojarra 2.2, JSF 2.2, Richfaces 4.5 In Detail Packed with rich assets and APIs, Wildfly 10 allows you to create state-of-the-art Java applications. This book will help you take your understanding of Java EE to the next level by creating distributed Java applications using Wildfly. The book begins by showing how to get started with a native installation of WildFly and it ends with a cloud installation. After setting up the development environment, you will implement and work with different WildFly features, such as implementing JavaServer Pages. You will also learn how you can use clustering so that your apps can handle a high volume of data traffic. You will also work with enterprise JavaBeans, solve issues related to failover, and implement Java Message Service integration. Moving ahead, you will be working with Java Naming and Directory Interface, Java Transaction API, and use ActiveMQ for message relay and message querying. This book will also show you how you can use your existing backend JavaScript code in your application. By the end of the book, you'll have gained the knowledge to implement the latest Wildfly features in your Java applications. Style and approach Each part of this book shows you how to use different features of WildFly 10 to create enterprise grade Java applications as easily as possible.

Book Hibernate Quickly

    Book Details:
  • Author : Patrick Peak
  • Publisher : Manning Publications
  • Release : 2005
  • ISBN :
  • Pages : 464 pages

Download or read book Hibernate Quickly written by Patrick Peak and published by Manning Publications. This book was released on 2005 with total page 464 pages. Available in PDF, EPUB and Kindle. Book excerpt: Hibernate Quickly is a companion volume to Manning's Hibernate in Action which is a focused and comprehensive book on the subject written by the project founders. The current book aims to give readers the 20% of information they need 80% of the time. It uses the pages saved to orient the reader within the Hibernate "ecosystem": the peripheral technologies and techniques typically used with Hibernate. This is the book readers are likely to turn to if they want to get up and running quickly. Examples are developed incrementally to demonstrate Hibernate concepts and to show how Hibernate works with the other common development tools and frameworks such as XDoclet, Struts, WebWork, Spring, and Tapestry. Covers the newest version, Hibernate 3. Purchase of the print book comes with an offer of a free PDF eBook from Manning. Also available is all code from the book.

Book Mastering Java Persistence API  JPA

Download or read book Mastering Java Persistence API JPA written by Nisha Parameswaran Kurur and published by BPB Publications. This book was released on 2022-03-12 with total page 261 pages. Available in PDF, EPUB and Kindle. Book excerpt: Filled with sample case study, exercises, commonly faced issues/solutions, and important interview questions, this book is surely going to help developers to expand their skills in JPA. KEY FEATURES ● Covers every JPA capability with detailed examples. ● Explanation of popular JPA providers in detail as well as sample JPA code. ● Includes solutions geared toward developers, interview questions, and expert advice. DESCRIPTION 'Mastering Java Persistence API' is geared towards experiencing the functioning of JPA and the extent of its use in Java SE and Java EE applications. While the book's primary objective is to develop competence in JPA, it also takes a simpler approach to refresh readers on basic database management system concepts and how to design simple JPA applications. The book begins with the ideas like ORM, EJB CMP, and the difficulties associated with data conversion from a database to an application and vice versa are handled spontaneously. The book discusses Table, Row, Column, Cell, and various forms of Relationships and progress sequentially through the JPA concepts. It also discusses database processes such as identity generation, sequencing, locking, querying, persisting, caching, and transaction management in detail and emphasizes how JPA handles them. Further, the book covers the architecture and setup of two of the most extensively used JPA provider implementations (Hibernate and EclipseLink) in detail. Additionally, this book includes sample functioning code for connecting to a MySQL database. Each JPA functionality is illustrated with a code snippet, making it easier to modify these features as the application develops. This book teaches both beginners and seasoned professionals how to integrate JPA concepts in their employment through numerous problems and answers spanning each of the topics. WHAT YOU WILL LEARN ● Refresh your knowledge of relational database management system concepts in an object-oriented approach. ● Using JPA, you can create a table, row, column, key, query, data type, etc. ● Prepare for your first JPA project by working through the Mavenized Sample working code. ● Identify various ways for object-oriented representation of relationships. ● Acquire proficiency in various approaches for storing, caching, and transaction management. ● Discover the inner workings of JPA providers, Hibernate, and EclipseLink, as well as their architecture. WHO THIS BOOK IS FOR This book is aimed at Java developers who wish to master JPA and develop JPA-based applications enthusiastically. To get the most out of this book, you should have a basic familiarity with Java programming. TABLE OF CONTENTS 1. Java Persistence API and Object-Relational Mapping 2. Tables – Attributes and Embeddable Objects 3. Operations – Identity, Sequencing and Locking 4. Relationships – Types and Strategies 5. Query Infrastructure 6. Entity Manager – Persisting, Caching, and Transaction 7. Hibernate and EclipseLink 8. Appendix Part 1: JPA Advanced Topics 9. Appendix Part 2: Sample JPA Application and Questions

Book Java Persistence with Hibernate

Download or read book Java Persistence with Hibernate written by Gary Gregory and published by Simon and Schuster. This book was released on 2015-10-27 with total page 1053 pages. Available in PDF, EPUB and Kindle. Book excerpt: Summary Java Persistence with Hibernate, Second Edition explores Hibernate by developing an application that ties together hundreds of individual examples. In this revised edition, authors Christian Bauer, Gavin King, and Gary Gregory cover Hibernate 5 in detail with the Java Persistence 2.1 standard (JSR 338). All examples have been updated for the latest Hibernate and Java EE specification versions. About the Technology Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications. Persistence—the ability of data to outlive an instance of a program—is central to modern applications. Hibernate, the most popular Java persistence tool, offers automatic and transparent object/relational mapping, making it a snap to work with SQL databases in Java applications. About the Book Java Persistence with Hibernate, Second Edition explores Hibernate by developing an application that ties together hundreds of individual examples. You'll immediately dig into the rich programming model of Hibernate, working through mappings, queries, fetching strategies, transactions, conversations, caching, and more. Along the way you'll find a well-illustrated discussion of best practices in database design and optimization techniques. In this revised edition, authors Christian Bauer, Gavin King, and Gary Gregory cover Hibernate 5 in detail with the Java Persistence 2.1 standard (JSR 338). All examples have been updated for the latest Hibernate and Java EE specification versions. What's Inside Object/relational mapping concepts Efficient database application design Comprehensive Hibernate and Java Persistence reference Integration of Java Persistence with EJB, CDI, JSF, and JAX-RS * Unmatched breadth and depth About the Reader The book assumes a working knowledge of Java. About the Authors Christian Bauer is a member of the Hibernate developer team and a trainer and consultant. Gavin King is the founder of the Hibernate project and a member of the Java Persistence expert group (JSR 220). Gary Gregory is a principal software engineer working on application servers and legacy integration. Table of Contents PART 1 GETTING STARTED WITH ORM Understanding object/relational persistence Starting a project Domain models and metadata PART 2 MAPPING STRATEGIES Mapping persistent classes Mapping value types Mapping inheritance Mapping collections and entity associations Advanced entity association mappings Complex and legacy schemas PART 3 TRANSACTIONAL DATA PROCESSING Managing data Transactions and concurrency Fetch plans, strategies, and profiles Filtering data PART 4 WRITING QUERIES Creating and executing queries The query languages Advanced query options Customizing SQL

Book Mastering Spring 5 0

    Book Details:
  • Author : Ranga Rao Karanam
  • Publisher : Packt Publishing Ltd
  • Release : 2017-06-28
  • ISBN : 1787122336
  • Pages : 488 pages

Download or read book Mastering Spring 5 0 written by Ranga Rao Karanam and published by Packt Publishing Ltd. This book was released on 2017-06-28 with total page 488 pages. Available in PDF, EPUB and Kindle. Book excerpt: Develop cloud native applications with microservices using Spring Boot, Spring Cloud, and Spring Cloud Data Flow About This Book Explore the new features and components in Spring Evolve towards micro services and cloud native applications Gain powerful insights into advanced concepts of Spring and Spring Boot to develop applications more effectively Understand the basics of Kotlin and use it to develop a quick service with Spring Boot Who This Book Is For This book is for an experienced Java developer who knows the basics of Spring, and wants to learn how to use Spring Boot to build applications and deploy them to the cloud. What You Will Learn Explore the new features in Spring Framework 5.0 Build microservices with Spring Boot Get to know the advanced features of Spring Boot in order to effectively develop and monitor applications Use Spring Cloud to deploy and manage applications on the Cloud Understand Spring Data and Spring Cloud Data Flow Understand the basics of reactive programming Get to know the best practices when developing applications with the Spring Framework Create a new project using Kotlin and implement a couple of basic services with unit and integration testing In Detail Spring 5.0 is due to arrive with a myriad of new and exciting features that will change the way we've used the framework so far. This book will show you this evolution—from solving the problems of testable applications to building distributed applications on the cloud. The book begins with an insight into the new features in Spring 5.0 and shows you how to build an application using Spring MVC. You will realize how application architectures have evolved from monoliths to those built around microservices. You will then get a thorough understanding of how to build and extend microservices using Spring Boot. You will also understand how to build and deploy Cloud-Native microservices with Spring Cloud. The advanced features of Spring Boot will be illustrated through powerful examples. We will be introduced to a JVM language that's quickly gaining popularity - Kotlin. Also, we will discuss how to set up a Kotlin project in Eclipse. By the end of the book, you will be equipped with the knowledge and best practices required to develop microservices with the Spring Framework. Style and approach This book follows an end-to-end tutorial approach with lots of examples and sample applications, covering the major building blocks of the Spring framework.

Book Mastering in Windows 10 Operating System Volume I And Volume II

Download or read book Mastering in Windows 10 Operating System Volume I And Volume II written by Lalit Mali and published by Notion Press. This book was released on 2017-04-25 with total page 488 pages. Available in PDF, EPUB and Kindle. Book excerpt: Mastering in Windows 10 Operating System is a guide that helps all dedicated windows users in exploring everything about the modern Windows 10 Operating System. It teaches you - Fundamentals of modern computers.- Basic computer system, journey of windows from its born to todays. - installing & configure window 10 operating system.- To explore all window 10 modern tile apps via Windows.- To configure and customize all Windows settings, services and control.- Windows apps, system tools, PC settings, accessories apps, control panel. - Windows 10 trick and tips, shortcut keys launch with run.- Window registry, modify, edit registry control & know more about it.- Configure group policy including computer system and user configuration. - Explore each & every window 10 group policy one by one in this book.

Book Mastering Windows XP Home Edition

Download or read book Mastering Windows XP Home Edition written by Guy Hart-Davis and published by John Wiley & Sons. This book was released on 2006-10-11 with total page 1173 pages. Available in PDF, EPUB and Kindle. Book excerpt: Windows XP Home Edition is Microsoft's next generation operating system for home users. Unlike Windows 95/98/Me, Windows XP Home Edition is based on the same code as Windows NT/2000, a more reliable and powerful system. Windows XP Home Edition makes it easier for families to set-up and switch between individual, personalized accounts, search for particular files and customize the way they manage files and folders. Other exciting features include Internet Explorer 6, the Photo Printing Wizard, and Windows Media Player 8, which includes DVD playback and CD burning utilities. Advanced features include a Network Setup Wizard, and Internet Connection Sharing and Firewall support.

Book Mastering jBPM6

    Book Details:
  • Author : Simone Fiorini
  • Publisher : Packt Publishing Ltd
  • Release : 2015-06-25
  • ISBN : 1783289589
  • Pages : 326 pages

Download or read book Mastering jBPM6 written by Simone Fiorini and published by Packt Publishing Ltd. This book was released on 2015-06-25 with total page 326 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book provides a complete understanding of the jBPM technology stack. It starts with an introduction to the world of business process management systems, the problem domain addressed by jBPM, explores the main use cases that can be addressed by business process management systems, and illustrates the main design patterns. It takes you through the details of the architecture and available out-of-the-box provisions for customizing, extending, and integrating the features of jBPM to meet the requirements of your application. Moreover, this book will empower you with the knowledge to integrate jBPM with enterprise architecture, debug through the source code of jBPM, and utilize the flexibility provided by a heavily modular system. Finally, it introduces you to the provisions available for a jBPM-based application to put the non-functional characteristics of the system, which are of great importance when we deploy our application in production. The book helps you in putting the knowledge at work by providing you with a lot of ready to use examples, both basic and advanced ones.

Book Mastering GeoServer

    Book Details:
  • Author : Colin Henderson
  • Publisher : Packt Publishing Ltd
  • Release : 2014-11-25
  • ISBN : 1783287705
  • Pages : 590 pages

Download or read book Mastering GeoServer written by Colin Henderson and published by Packt Publishing Ltd. This book was released on 2014-11-25 with total page 590 pages. Available in PDF, EPUB and Kindle. Book excerpt: If you are a GIS professional who intends to explore advanced techniques and get more out of GeoServer deployment rather than simply delivering good looking maps, then this book is for you.

Book Mastering Information Technology for CXC CSEC CAPE

Download or read book Mastering Information Technology for CXC CSEC CAPE written by and published by Dennis Adonis. This book was released on with total page 217 pages. Available in PDF, EPUB and Kindle. Book excerpt:

Book Mastering PostgreSQL 13

    Book Details:
  • Author : Hans-Jürgen Schönig
  • Publisher : Packt Publishing Ltd
  • Release : 2020-11-13
  • ISBN : 1800565429
  • Pages : 463 pages

Download or read book Mastering PostgreSQL 13 written by Hans-Jürgen Schönig and published by Packt Publishing Ltd. This book was released on 2020-11-13 with total page 463 pages. Available in PDF, EPUB and Kindle. Book excerpt: Explore expert techniques such as advanced indexing and high availability to build scalable, reliable, and fault-tolerant database applications using PostgreSQL 13 Key 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 Description Thanks 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 for This 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.

Book Mastering PostgreSQL 12

    Book Details:
  • Author : Hans-Jürgen Schönig
  • Publisher : Packt Publishing Ltd
  • Release : 2019-11-29
  • ISBN : 1838985271
  • Pages : 455 pages

Download or read book Mastering PostgreSQL 12 written by Hans-Jürgen Schönig and published by Packt Publishing Ltd. This book was released on 2019-11-29 with total page 455 pages. Available in PDF, EPUB and Kindle. Book excerpt: Master PostgreSQL 12 features such as advanced indexing, high availability, monitoring, and much more to efficiently manage and maintain your database Key FeaturesGrasp advanced PostgreSQL 12 concepts with real-world examples and sample datasetsExplore query parallelism, data replication, database administration, and moreExtend PostgreSQL functionalities to suit your organization’s needs with minimal effortBook 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 learnUnderstand the advanced SQL functions in PostgreSQL 12Use indexing features in PostgreSQL to fine-tune the performance of queriesWork with stored procedures and manage backup and recoveryMaster replication and failover techniques to reduce data lossReplicate PostgreSQL database systems to create backups and to scale your databaseManage and improve the security of your server to protect your dataTroubleshoot your PostgreSQL instance for solutions to common and not-so-common problemsWho 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.

Book Mastering PostgreSQL 11

    Book Details:
  • Author : Hans-Jürgen Schönig
  • Publisher : Packt Publishing Ltd
  • Release : 2018-10-30
  • ISBN : 178953917X
  • Pages : 435 pages

Download or read book Mastering PostgreSQL 11 written by Hans-Jürgen Schönig and published by Packt Publishing Ltd. This book was released on 2018-10-30 with total page 435 pages. Available in PDF, EPUB and Kindle. Book excerpt: Master the capabilities of PostgreSQL 11 to efficiently manage and maintain your database Key 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 Description This 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 for This 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.

Book Mastering PostgreSQL 10

    Book Details:
  • Author : Hans-Jürgen Schönig
  • Publisher : Packt Publishing Ltd
  • Release : 2018-01-31
  • ISBN : 1788470532
  • Pages : 417 pages

Download or read book Mastering PostgreSQL 10 written by Hans-Jürgen Schönig and published by Packt Publishing Ltd. This book was released on 2018-01-31 with total page 417 pages. Available in PDF, EPUB and Kindle. Book excerpt: Master 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 hassle Who 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.