Mariadb And Postgresql Crash Course

Mariadb And Postgresql Crash Course Book in PDF, ePub and Kindle version is available to download in english. Read online anytime anywhere directly from your device. Click on the download button below to get a free pdf file of Mariadb And Postgresql Crash Course book. This book definitely worth reading, it is an incredibly well-written.

MariaDB And PostgreSQL Crash Course

Vivian Siahaan,Rismon Hasiholan Sianipar
MariaDB And PostgreSQL Crash Course Book PDF

Author : Vivian Siahaan,Rismon Hasiholan Sianipar
Publisher : SPARTA PUBLISHING
Page : 534 pages
File Size : 51,6 Mb
Release : 2019-11-13
Category : Computers
ISBN : 8210379456XXX

Get Book

MariaDB And PostgreSQL Crash Course by Vivian Siahaan,Rismon Hasiholan Sianipar Pdf

In this book, you will create two MariaDB and PostgreSQL driven projects using PyQt. The step-by-step guide in this book is expected to help the reader's confidence to become a programmer who can solve database programming problems. A progressive project is provided to demonstrate how to apply the concepts of MariaDB and PostgreSQL using Python. In second chapter, you will learn PyQt that consists of a number of Python bindings for cross-platform applications that combine all the strengths of Qt and Python. By using PyQt, you can include all Qt libraries in Python code, so you can write GUI applications in Python. In other words, you can use PyQt to access all the features provided by Qt through Python code. Because PyQt depends on the Qt libraries at run time, you need to install PyQt. In third chapter, you will learn: How to create the initial three tables project in the School database: Teacher, Class, and Subject tables; How to create database configuration files; How to create a Python GUI for inserting and editing tables; How to create a Python GUI to join and query the three tables. In fourth chapter, you will learn how to: Create a main form to connect all forms; Create a project will add three more tables to the school database: Student, Parent, and Tuition tables; Create a Python GUI for inserting and editing tables; Create a Python GUI to join and query over the three tables. In this chapter, you will join the six classes, Teacher, TClass, Subject, Student, Parent, and Tuition and make queries over those tables. In chapter five, you will create dan configure PotgreSQL database. In this chapter, you will create Suspect table in crime database. This table has eleven columns: suspect_id (primary key), suspect_name, birth_date, case_date, report_date, suspect_ status, arrest_date, mother_name, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for this table. In chapter six, you will create a table with the name Feature_Extraction, which has eight columns: feature_id (primary key), suspect_id (foreign key), feature1, feature2, feature3, feature4, feature5, and feature6. The six fields (except keys) will have a VARCHAR data type (200). You will also create GUI to display, edit, insert, and delete for this table. In chapter seven, you will create two tables, Police and Investigator. The Police table has six columns: police_id (primary key), province, city, address, telephone, and photo. The Investigator table has eight columns: investigator_id (primary key), investigator_name, rank, birth_date, gender, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for both tables. In chapter eight, you will create two tables, Victim and Case_File. The Victim table has nine columns: victim_id (primary key), victim_name, crime_type, birth_date, crime_date, gender, address, telephone, and photo. The Case_File table has seven columns: case_file_id (primary key), suspect_id (foreign key), police_id (foreign key), investigator_id (foreign key), victim_id (foreign key), status, and description. You will create GUI to display, edit, insert, and delete for both tables as well.

MariaDB Crash Course

Ben Forta
MariaDB Crash Course Book PDF

Author : Ben Forta
Publisher : Addison-Wesley Professional
Page : 370 pages
File Size : 51,8 Mb
Release : 2011-08-29
Category : Computers
ISBN : 9780132842358

Get Book

MariaDB Crash Course by Ben Forta Pdf

MariaDB is a database server that offers drop-in replacement functionality for MySQL. Built by some of the original authors of MySQL, with assistance from the broader community of free and open source software developers, MariaDB offers a rich set of feature enhancements to MySQL, including alternate storage engines, server optimizations, and patches. MariaDB Crash Course teaches you all you need to know to be immediately productive with MariaDB. Master trainer Ben Forta introduces all the essentials through a series of quick, easy-to-follow, hands-on lessons. Instead of belaboring database theory and relational design, Forta focuses on teaching solutions for the majority of users who simply want to interact with data. Learn how to: Retrieve and sort data Filter data using comparisons, regular expressions, and full text search Join relational data Create and alter tables Insert, update, and delete data Leverage the power of stored procedures and triggers Use views and cursors Manage transactional processing Create user accounts and manage security via access control

Learn Any Programming Language Easily

S Muzammil
Learn Any Programming Language Easily Book PDF

Author : S Muzammil
Publisher : S Muzammil
Page : 19 pages
File Size : 48,8 Mb
Release : 2023-12-27
Category : Computers
ISBN : 8210379456XXX

Get Book

Learn Any Programming Language Easily by S Muzammil Pdf

This book is a crash course on how to learn any programming language easily. If you are a beginner in programming or you are planning to learn programming but don’t know the basics. This book will help you to learn the basics of programming language in a short time without wasting your time. I have explained everything short and simple so that you can learn programming faster. If you complete this book, you may get knowledge on how programming works and it will the foundation for you programming learning journey This book contains answers for, What is Programming Language? What does FrontEnd programming language do? What does a backend programming language do? What is Database? What are servers? How do every Digital products work? What is variables Different types of data What is Conditional Statement What is For loop What is For Each What is While loop How to learn any programming language easily on your own?

MS Access And SQL Server Crash Course

Vivian Siahaan,Rismon Hasiholan Sianipar
MS Access And SQL Server Crash Course Book PDF

Author : Vivian Siahaan,Rismon Hasiholan Sianipar
Publisher : SPARTA PUBLISHING
Page : 545 pages
File Size : 54,9 Mb
Release : 2019-11-13
Category : Computers
ISBN : 8210379456XXX

Get Book

MS Access And SQL Server Crash Course by Vivian Siahaan,Rismon Hasiholan Sianipar Pdf

This book covers microsoft acces and SQL Server based GUI programming using pyqt. Intentionally designed for various levels of interest and ability of learners, this book is suitable for students, engineers, and even researchers in a variety of disciplines. No advanced programming experience is needed, and only a few school-level programming skill are needed. In the first chapter, you will learn to use several widgets in PyQt5: Display a welcome message; Use the Radio Button widget; Grouping radio buttons; Displays options in the form of a check box; and Display two groups of check boxes. In chapter two, you will learn to use the following topics: Using Signal / Slot Editor; Copy and place text from one Line Edit widget to another; Convert data types and make a simple calculator; Use the Spin Box widget; Use scrollbars and sliders; Using the Widget List; Select a number of list items from one Widget List and display them on another Widget List widget; Add items to the Widget List; Perform operations on the Widget List; Use the Combo Box widget; Displays data selected by the user from the Calendar Widget; Creating a hotel reservation application; and Display tabular data using Table Widgets. In third chapter, you will learn: How to create the initial three tables project in the School database: Teacher, Class, and Subject tables; How to create database configuration files; How to create a Python GUI for inserting and editing tables; How to create a Python GUI to join and query the three tables. In fourth chapter, you will learn how to: Create a main form to connect all forms; Create a project will add three more tables to the school database: Student, Parent, and Tuition tables; Create a Python GUI for inserting and editing tables; Create a Python GUI to join and query over the three tables. In chapter five, you will join the six classes, Teacher, TClass, Subject, Student, Parent, and Tuition and make queries over those tables. In chapter six, you will create dan configure database. In this chapter, you will create Suspect table in crime database. This table has eleven columns: suspect_id (primary key), suspect_name, birth_date, case_date, report_date, suspect_ status, arrest_date, mother_name, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for this table. In chapter seven, you will create a table with the name Feature_Extraction, which has eight columns: feature_id (primary key), suspect_id (foreign key), feature1, feature2, feature3, feature4, feature5, and feature6. The six fields (except keys) will have VARBINARY(MAX) data type. You will also create GUI to display, edit, insert, and delete for this table. In chapter eight, you will create two tables, Police and Investigator. The Police table has six columns: police_id (primary key), province, city, address, telephone, and photo. The Investigator table has eight columns: investigator_id (primary key), investigator_name, rank, birth_date, gender, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for both tables. In the last chapter, you will create two tables, Victim and Case_File. The Victim table has nine columns: victim_id (primary key), victim_name, crime_type, birth_date, crime_date, gender, address, telephone, and photo. The Case_File table has seven columns: case_file_id (primary key), suspect_id (foreign key), police_id (foreign key), investigator_id (foreign key), victim_id (foreign key), status, and description. You will create GUI to display, edit, insert, and delete for both tables as well.

Access Database Crash Course

Vivian Siahaan
Access Database Crash Course Book PDF

Author : Vivian Siahaan
Publisher : SPARTA PUBLISHING
Page : 546 pages
File Size : 46,8 Mb
Release : 2019-10-12
Category : Computers
ISBN : 8210379456XXX

Get Book

Access Database Crash Course by Vivian Siahaan Pdf

This book is a access database crash course which overs microsoft acces-based GUI programming using Python. In chapter one, you will learn to use several widgets in PyQt5: Display a welcome message; Use the Radio Button widget; Grouping radio buttons; Displays options in the form of a check box; and Display two groups of check boxes. In chapter two, you will learn to use the following topics: Using Signal / Slot Editor; Copy and place text from one Line Edit widget to another; Convert data types and make a simple calculator; Use the Spin Box widget; Use scrollbars and sliders; Using the Widget List; Select a number of list items from one Widget List and display them on another Widget List widget; Add items to the Widget List; Perform operations on the Widget List; Use the Combo Box widget; Displays data selected by the user from the Calendar Widget; Creating a hotel reservation application; and Display tabular data using Table Widgets. In chapter three, you will learn: How to create the initial three tables project in the School database: Teacher, Class, and Subject tables; How to create database configuration files; How to create a Python GUI for inserting and editing tables; How to create a Python GUI to join and query the three tables. In chapter four, you will learn how to: Create a main form to connect all forms; Create a project will add three more tables to the school database: Student, Parent, and Tuition tables; Create a Python GUI for inserting and editing tables; Create a Python GUI to join and query over the three tables. In chapter five, you will join the six classes, Teacher, TClass, Subject, Student, Parent, and Tuition and make queries over those tables. In chapter six, you will create dan configure database. In this chapter, you will create Suspect table in crime database. This table has eleven columns: suspect_id (primary key), suspect_name, birth_date, case_date, report_date, suspect_ status, arrest_date, mother_name, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for this table. In chapter seven, you will create a table with the name Feature_Extraction, which has eight columns: feature_id (primary key), suspect_id (foreign key), feature1, feature2, feature3, feature4, feature5, and feature6. The six fields (except keys) will have LONGBINARY data type. You will also create GUI to display, edit, insert, and delete for this table. In chapter eight, you will create two tables, Police and Investigator. The Police table has six columns: police_id (primary key), province, city, address, telephone, and photo. The Investigator table has eight columns: investigator_id (primary key), investigator_name, rank, birth_date, gender, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for both tables. In the last chapter, you will create two tables, Victim and Case_File. The Victim table has nine columns: victim_id (primary key), victim_name, crime_type, birth_date, crime_date, gender, address, telephone, and photo. The Case_File table has seven columns: case_file_id (primary key), suspect_id (foreign key), police_id (foreign key), investigator_id (foreign key), victim_id (foreign key), status, and description. You will create GUI to display, edit, insert, and delete for both tables as well.

Learn Python in One Week

Vivian Siahaan,Rismon Hasiholan Sianipar
Learn Python in One Week Book PDF

Author : Vivian Siahaan,Rismon Hasiholan Sianipar
Publisher : BALIGE Publishing
Page : 542 pages
File Size : 42,8 Mb
Release : 2019-11-17
Category : Computers
ISBN : 8210379456XXX

Get Book

Learn Python in One Week by Vivian Siahaan,Rismon Hasiholan Sianipar Pdf

This book is the ultimate beginners’ crash course to Python programming, as it will help you learn enough about the language in as little as 1 week. Complex concepts in developing database-driven projects are broken down into easy steps to ensure that you can easily master the Python language even if you have never coded before. The best way to learn Python is by doing it. This book covers microsoft acces and SQLite based GUI programming using pyqt. Intentionally designed for various levels of interest and ability of learners, this book is suitable for those who are completely newbies with Python, those who have basic information of this programming language, and those who already have the knowledge but perhaps they want to master it well. In the first chapter, you will learn to use several widgets in PyQt5: Display a welcome message; Use the Radio Button widget; Grouping radio buttons; Displays options in the form of a check box; and Display two groups of check boxes. In chapter two, you will learn to use the following topics: Using Signal / Slot Editor; Copy and place text from one Line Edit widget to another; Convert data types and make a simple calculator; Use the Spin Box widget; Use scrollbars and sliders; Using the Widget List; Select a number of list items from one Widget List and display them on another Widget List widget; Add items to the Widget List; Perform operations on the Widget List; Use the Combo Box widget; Displays data selected by the user from the Calendar Widget; Creating a hotel reservation application; and Display tabular data using Table Widgets. In third chapter, you will learn: How to create the initial three tables project in the School database: Teacher, Class, and Subject tables; How to create database configuration files; How to create a Python GUI for inserting and editing tables; How to create a Python GUI to join and query the three tables. In fourth chapter, you will learn how to: Create a main form to connect all forms; Create a project will add three more tables to the school database: Student, Parent, and Tuition tables; Create a Python GUI for inserting and editing tables; Create a Python GUI to join and query over the three tables. In chapter five, you will join the six classes, Teacher, TClass, Subject, Student, Parent, and Tuition and make queries over those tables. In chapter six, you will create dan configure database. In this chapter, you will create Suspect table in crime database. This table has eleven columns: suspect_id (primary key), suspect_name, birth_date, case_date, report_date, suspect_ status, arrest_date, mother_name, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for this table. In chapter seven, you will create a table with the name Feature_Extraction, which has eight columns: feature_id (primary key), suspect_id (foreign key), feature1, feature2, feature3, feature4, feature5, and feature6. The six fields (except keys) will have VARBINARY(MAX) data type. You will also create GUI to display, edit, insert, and delete for this table. In chapter eight, you will create two tables, Police and Investigator. The Police table has six columns: police_id (primary key), province, city, address, telephone, and photo. The Investigator table has eight columns: investigator_id (primary key), investigator_name, rank, birth_date, gender, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for both tables. In the last chapter, you will create two tables, Victim and Case_File. The Victim table has nine columns: victim_id (primary key), victim_name, crime_type, birth_date, crime_date, gender, address, telephone, and photo. The Case_File table has seven columns: case_file_id (primary key), suspect_id (foreign key), police_id (foreign key), investigator_id (foreign key), victim_id (foreign key), status, and description. You will create GUI to display, edit, insert, and delete for both tables as well.

Open Source Library Systems

Robert Wilson,James Mitchell
Open Source Library Systems Book PDF

Author : Robert Wilson,James Mitchell
Publisher : Rowman & Littlefield
Page : 175 pages
File Size : 41,8 Mb
Release : 2021-09-11
Category : Language Arts & Disciplines
ISBN : 9781538141403

Get Book

Open Source Library Systems by Robert Wilson,James Mitchell Pdf

Knowing about the open source alternative to integrated library systems and being able to make accurate comparisons can save a library tens to hundreds of thousands of dollars a year while more closely matching the library’s functional needs.

Learning MySQL

Saied M.M. Tahaghoghi,Hugh E. Williams
Learning MySQL Book PDF

Author : Saied M.M. Tahaghoghi,Hugh E. Williams
Publisher : "O'Reilly Media, Inc."
Page : 620 pages
File Size : 53,7 Mb
Release : 2007-11-28
Category : Computers
ISBN : 9780596008642

Get Book

Learning MySQL by Saied M.M. Tahaghoghi,Hugh E. Williams Pdf

Presents instructions on using MySQL, covering such topics as installation, querying, user management, security, and backups and recovery.

Learning PostgreSQL

Salahaldin Juba,Achim Vannahme,Andrey Volkov
Learning PostgreSQL Book PDF

Author : Salahaldin Juba,Achim Vannahme,Andrey Volkov
Publisher : Packt Publishing Ltd
Page : 464 pages
File Size : 47,7 Mb
Release : 2015-11-30
Category : Computers
ISBN : 9781783989195

Get Book

Learning PostgreSQL by Salahaldin Juba,Achim Vannahme,Andrey Volkov Pdf

Create, develop and manage relational databases in real world applications using PostgreSQL About This Book Learn about the PostgreSQL development life cycle including its testing and refactoring Build productive database solutions and use them in Java applications A comprehensive guide to learn about SQL, PostgreSQL procedural language and PL/pgSQL Who This Book Is For If you are a student, database developer or an administrator, interested in developing and maintaining a PostgreSQL database, then this book is for you. No knowledge of database programming or administration is necessary. What You Will Learn Learn concepts of data modelling and relation algebra Install and set up PostgreSQL database server and client software Implement data structures in PostgreSQL Manipulate data in the database using SQL Implement data processing logic in the database with stored functions, triggers and views Test database solutions and assess the performance Integrate database with Java applications Detailed knowledge of the main PostgreSQL building objects, most used extensions Practice database development life cycle including analysis, modelling, (documentation), testing, bug fixes and refactoring In Detail PostgreSQL is one of the most powerful and easy to use database management systems. It has strong support from the community and is being actively developed with a new release every year. PostgreSQL supports the most advanced features included in SQL standards. Also it provides NoSQL capabilities, and very rich data types and extensions. All that makes PostgreSQL a very attractive solution in various kinds of software systems. The book starts with the introduction of relational databases with PostegreSQL. It then moves on to covering data definition language (DDL) with emphasis on PostgreSQL and common DDL commands supported by ANSI SQL. You will then learn the data manipulation language (DML), and advanced topics like locking and multi version concurrency control (MVCC). This will give you a very robust background to tune and troubleshoot your application. The book then covers the implementation of data models in the database such as creating tables, setting up integrity constraints, building indexes, defining views and other schema objects. Next, it will give you an overview about the NoSQL capabilities of PostgreSQL along with Hstore, XML, Json and arrays. Finally by the end of the book, you'll learn to use the JDBC driver and manipulate data objects in the Hibernate framework. Style and approach An easy-to-follow guide to learn programming build applications with PostgreSQL, and manage a PostgreSQL database instance.

Learning SQL

Alan Beaulieu
Learning SQL Book PDF

Author : Alan Beaulieu
Publisher : O'Reilly Media
Page : 338 pages
File Size : 48,8 Mb
Release : 2009-04-11
Category : Computers
ISBN : 9780596551070

Get Book

Learning SQL by Alan Beaulieu Pdf

Updated for the latest database management systems -- including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 -- this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals. Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations and annotated examples. Exercises at the end of each chapter let you practice the skills you learn. With this book, you will: Move quickly through SQL basics and learn several advanced features Use SQL data statements to generate, manipulate, and retrieve data Create database objects, such as tables, indexes, and constraints, using SQL schema statements Learn how data sets interact with queries, and understand the importance of subqueries Convert and manipulate data with SQL's built-in functions, and use conditional logic in data statements Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly learn how to put the power and flexibility of this language to work.

Trino: The Definitive Guide

Matt Fuller,Manfred Moser,Martin Traverso
Trino The Definitive Guide Book PDF

Author : Matt Fuller,Manfred Moser,Martin Traverso
Publisher : "O'Reilly Media, Inc."
Page : 310 pages
File Size : 43,6 Mb
Release : 2021-04-14
Category : Computers
ISBN : 9781098107680

Get Book

Trino: The Definitive Guide by Matt Fuller,Manfred Moser,Martin Traverso Pdf

Perform fast interactive analytics against different data sources using the Trino high-performance distributed SQL query engine. With this practical guide, you'll learn how to conduct analytics on data where it lives, whether it's Hive, Cassandra, a relational database, or a proprietary data store. Analysts, software engineers, and production engineers will learn how to manage, use, and even develop with Trino. Initially developed by Facebook, open source Trino is now used by Netflix, Airbnb, LinkedIn, Twitter, Uber, and many other companies. Matt Fuller, Manfred Moser, and Martin Traverso show you how a single Trino query can combine data from multiple sources to allow for analytics across your entire organization. Get started: Explore Trino's use cases and learn about tools that will help you connect to Trino and query data Go deeper: Learn Trino's internal workings, including how to connect to and query data sources with support for SQL statements, operators, functions, and more Put Trino in production: Secure Trino, monitor workloads, tune queries, and connect more applications; learn how other organizations apply Trino

PostgreSQL 11 Administration Cookbook

Simon Riggs,Gianni Ciolli,Sudheer Kumar Meesala
PostgreSQL 11 Administration Cookbook Book PDF

Author : Simon Riggs,Gianni Ciolli,Sudheer Kumar Meesala
Publisher : Packt Publishing Ltd
Page : 589 pages
File Size : 48,8 Mb
Release : 2019-05-03
Category : Computers
ISBN : 9781789536225

Get Book

PostgreSQL 11 Administration Cookbook by Simon Riggs,Gianni Ciolli,Sudheer Kumar Meesala Pdf

A practical guide to administer, monitor and replicate your PostgreSQL 11 database Key FeaturesStudy and apply the newly introduced features in PostgreSQL 11Tackle any problem in PostgreSQL 11 administration and managementCatch up on expert techniques for monitoring, fine-tuning, and securing your databaseBook Description PostgreSQL is a powerful, open source database management system with an enviable reputation for high performance and stability. With many new features in its arsenal, PostgreSQL 11 allows you to scale up your PostgreSQL infrastructure. This book takes a step-by-step, recipe-based approach to effective PostgreSQL administration. The book will introduce you to new features such as logical replication, native table partitioning, additional query parallelism, and much more to help you to understand and control, crash recovery and plan backups. You will learn how to tackle a variety of problems and pain points for any database administrator such as creating tables, managing views, improving performance, and securing your database. As you make steady progress, the book will draw attention to important topics such as monitoring roles, backup, and recovery of your PostgreSQL 11 database to help you understand roles and produce a summary of log files, ensuring high availability, concurrency, and replication. By the end of this book, you will have the necessary knowledge to manage your PostgreSQL 11 database efficiently. What you will learnTroubleshoot open source PostgreSQL version 11 on various platformsDeploy best practices for planning and designing live databasesSelect and implement robust backup and recovery techniques in PostgreSQL 11Use pgAdmin or OmniDB to perform database administrator (DBA) tasksAdopt efficient replication and high availability techniques in PostgreSQLImprove the performance of your PostgreSQL solutionWho this book is for This book is designed for database administrators, data architects, database developers, or anyone with an interest in planning and running live production databases using PostgreSQL 11. It is also ideal if you’re looking for hands-on solutions to any problem associated with PostgreSQL 11 administration. Some experience with handling PostgreSQL databases will be beneficial

Mastering PostgreSQL 13

Hans-Jürgen Schönig
Mastering PostgreSQL 13 Book PDF

Author : Hans-Jürgen Schönig
Publisher : Packt Publishing Ltd
Page : 463 pages
File Size : 52,8 Mb
Release : 2020-11-13
Category : Computers
ISBN : 9781800565425

Get Book

Mastering PostgreSQL 13 by Hans-Jürgen Schönig Pdf

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.

Expert MySQL

Charles Bell
Expert MySQL Book PDF

Author : Charles Bell
Publisher : Apress
Page : 601 pages
File Size : 55,5 Mb
Release : 2007-04-01
Category : Computers
ISBN : 9781430203469

Get Book

Expert MySQL by Charles Bell Pdf

MySQL remains one of the hottest open source database technologies. As the database has evolved into a product competitive with proprietary counterparts like Oracle and IBM DB2, MySQL has found favor with large scale corporate users who require high-powered features and performance. Expert MySQL is the first book to delve deep into the MySQL architecture, showing users how to make the most of the database through creation of custom storage handlers, optimization of MySQL's query execution, and use of the embedded server product. This book will interest users deploying MySQL in high-traffic environments and in situations requiring minimal resource allocation.

MariaDB High Performance

Pierre MAVRO
MariaDB High Performance Book PDF

Author : Pierre MAVRO
Publisher : Packt Publishing Ltd
Page : 298 pages
File Size : 45,6 Mb
Release : 2014-09-23
Category : Computers
ISBN : 9781783981618

Get Book

MariaDB High Performance by Pierre MAVRO Pdf

This book is aimed at system administrators/architects or DBAs who want to learn more about how to grow their current infrastructure to support larger traffic. Before beginning with this book, we expect you to be well-practiced with MySQL/MariaDB for common usage. You will be able to get a grasp quickly if you are comfortable with learning and building large infrastructures for MariaDB using Linux.