PostgreSQL

Whether you're managing large datasets or writing your first query, build your SQL skills with this practical guide! Learn the basic elements of relational databases and walk through the syntax, features, and applications of SQL. Then dive into the sublanguages of SQL and apply them for tasks such as modifying tables and querying data. See SQL in action with an example PostgreSQL database and detailed code samples from real-word applications!Highlights:1) Schemas2) Tables3) Views4) Keys5) PostgreSQL6) Data definition language (DDL)7) Data manipulation language (DML)8) Transaction control language (TCL)9) Data query language (DQL)10) Data control language (DCL)11) Entity-relationship diagrams (ERD)

Den leichten Einstieg in SQL und die Modellierung von Daten finden Sie hier! Schritt für Schritt führt Sie Michael Laube in diesem Leitfaden durch die SQL-Kommandos und macht Sie mit allen wichtigen Befehlen vertraut. Auf diesem Fundament aufbauend lernen Sie, wie Sie Ihre Daten richtig modellieren, verknüpfen und bearbeiten. Mithilfe dieser Anleitungen wird die Datenmodellierung mit SQL einfach und unkompliziert: So schaffen Sie Ordnung und sorgen für performante Abfragen.Aus dem Inhalt:- Grundlagen kennenlernen und verstehen- Grundfunktionen der Tabellenabfrage- Zeilen einfügen, ändern und löschen (INSERT, UPDATE und DELETE)- Tabellen mit CREATE TABLE anlegen- Mengenoperationen- Datenbanken modellieren- Datenmodelle optimieren- Datenmodelle in Tabellen überführen- Beziehungen zwischen Tabellen: JOINs- Transaktionen- Skalarfunktionen- Bedingungslogik- Mit Zeit und Datum arbeiten- Spaltenwerte mit GROUP BY gruppieren- Unterabfragen- VIEWS: Abfragen in virtuellen Tabellen speichern- Performance optimieren

Alles zur systemnahen Anwendungsprogrammierung: von den E/A-Funktionen, dem Zugriff auf Systeminformationen über Prozesse, Signale, Interprozesskommunikation und Threads bis hin zu Netzwerkprogrammierung, Datenbanken und GUIs. Für alle, die Programme schreiben wollen und alte Software warten oder portieren müssen. Alle Beispiele sind auch auf dem Raspberry Pi ausführbar. Solide C- und Linux-Kenntnisse werden vorausgesetzt.Aus dem Inhalt:- E/A-Funktionen- Attribute von Dateien und Verzeichnissen- Zugriff auf Systeminformationen- Devices - eine einfache Verbindung zur Hardware- System- und Benutzerdateien- Dämonen, Zombies und Prozesse- Signale- IPC - Interprozesskommunikation- Threads- Netzwerkprogrammierung- Datenbanken (MySQL, PostgreSQL)- GUIs mit GTK+- Werkzeuge für Programmierer

Datenbanken sind das Rückgrat moderner IT-Systeme. Wie Sie sicher mit ihnen arbeiten, zeigt Ihnen Dr. Michael Kofler in diesem umfassenden Handbuch. Sie lernen grundlegende Begriffe und Konzepte kennen, die Sie für gutes Datenbankdesign brauchen, und erfahren, wie Sie Daten modelliere und strukturieren. Ein Schnellkurs in SQL zeigt Ihnen, wie Daten abgefragt und geändert werden, Praxiswissen zur Client-Entwicklung und DBMS-Administration machen Sie fit für den Berufsalltag, Übungen und anschauliche Beispiele helfen Ihnen beim Selbststudium und der Prüfungsvorbereitung.Aus dem Inhalt:- Datenbankmodellierung: vom ER-Modell zum perfekten Schema- Datentypen- Primary Keys, Foreign Keys und referenzielle Integrität- Indizes- Daten mit SQL abfragen und ändern- SQL für Fortgeschrittene: Subqueries, Transaktionen, Rekursion, DDL- Client-Programmierung- Benutzerverwaltung und Access Control- Backups und Logging- Replikation und High Availability- Stored Procedures und Trigger- NoSQL: Datenverarbeitung jenseits relationaler Datenbanken

- Effizienter Einstieg in SQL und relationale Datenbanken- Datenbankabfragen und Grundlagen des professionellen Datenbankmanagements- Alle Beispiele inkl. Besonderheiten für MySQL und PostgreSQL- Inkl. E-BookMit diesem Buch gelingt Ihnen der einfache Einstieg in das Datenbankmanagement mit der Abfragesprache SQL. Alle Grundlagen werden in 14 Kapiteln leicht verständlich anhand von Beispielen erläutert.Der Autor führt Sie Schritt für Schritt in den Einsatz von SQL und die Grundlagen relationaler Datenbanken ein: von der fundamentalen Syntax und den ersten Datenbankabfragen über das Verknüpfen von Tabellen bis hin zur Datenbankerstellung und der Zugriffskontrolle.Alle Beispiele beziehen sich auf eine Beispieldatenbank, die auf der Webseite des Verlags zum Download bereitsteht, und lassen sich leicht auf eigene Anwendungsfälle übertragen. Die Besonderheiten bei der Verwendung von PostgreSQL und MySQL werden bei jedem Beispiel beschrieben.So sind Sie perfekt auf den Einsatz von SQL im professionellen Umfeld vorbereitet.Aus dem Inhalt:- Alle Grundlagen einfach erläutert- SQL-Syntax und Datenbank-Abfragen- Filtern mit Bedingungen- Gruppierung von Daten und Aggregatfunktionen- Verknüpfen von Tabellen und Ergebnissen- Skalarfunktionen und Unterabfragen- Datenbanken erstellen und anpassen- Rechteverwaltung und Zugriffskontrolle- Komplexe SQL-Konzepte - Trigger, Indizes und ViewsZum Download: Beispieldatenbank für die Übungen und alle Lösungen

Welcome to the book "Shrova Mall: A-to-Z e-commerce full-stack application". In this book, I explain how you can create a full-stack e-commerce application using Angular and NestJS.The application provides payment and shipping functionalities by integrating Stripe for payments and Shippo for shipping.To begin, I will show you the application we are going to build and then start by creating the database. Next, I will explain the backend and finally the frontend application.By the end of this book, you will be able to create your online e-commerce store and cover all possible scenarios.Let's get started.

Use the Rust programming language to build fully functional web applications with async Rust to amplify security and boost the performance of your programsKey Features:Work with cutting-edge web techniques such as distroless Rust servers, Terraform, and AWS deploymentGet acquainted with async concepts such as actors and queuing tasks using lower-level frameworks like TokioBuild a full web application in Rust with a database, authentication, and frontendBook Description:Are safety and high performance a big concern for you while developing web applications?With this practical Rust book, you'll discover how you can implement Rust on the web to achieve the desired performance and security as you learn techniques and tooling to build fully operational web apps.In this second edition, you'll get hands-on with implementing emerging Rust web frameworks, including Actix, Rocket, and Hyper. It also features HTTPS configuration on AWS when deploying a web application and introduces you to Terraform for automating the building of web infrastructure on AWS. What's more, this edition also covers advanced async topics. Built on the Tokio async runtime, this explores TCP and framing, implementing async systems with the actor framework, and queuing tasks on Redis to be consumed by a number of worker nodes. Finally, you'll go over best practices for packaging Rust servers in distroless Rust Docker images with database drivers, so your servers are a total size of 50Mb each.By the end of this book, you'll have confidence in your skills to build robust, functional, and scalable web applications from scratch.What You Will Learn:Structure and build scalable Rust web apps by creating a basic to-do list web appManage authentication and databases in Rust web applicationsGet to grips with wrapping web applications in distrolessUnderstand the building blocks of web development such as HTTPS, TCP, and middlewareBuild app infrastructure on AWS using Terraform with databases, servers, load balancers, HTTPS, and URL routingBuild end-to-end tests using PostmanBuild async systems implementing the actor model using TokioWho this book is for:This Rust programming book is for web developers who want to learn and implement Rust to build web applications. Developers familiar with languages such as Python, Ruby, and JS will be able to use this book to build high performant web apps with Rust.Although no prior experience in Rust is necessary, a solid understanding of web development principles, along with basic knowledge of HTML, CSS, and JavaScript, is necessary to get the most out of this book.

With databases lurking in the background of every website, knowing how to manage them with MySQL is a no-brainer. This practical, hands-on introduction teaches readers all they need to know.<BR><BR>MySQL Crash Course is a fast-paced, no-nonsense introduction to relational database development. It’s filled withpractical examples and expert advice that will have you up and running quickly.<BR><BR>You’ll learn the basics of SQL, how to create a database, craft SQL queries to extract data, and work with events,procedures, and functions. You’ll see how to add constraints to tables to enforce rules about permitted data and useindexes to accelerate data retrieval. You’ll even explore how to call MySQL from PHP, Python, and Java.<BR><BR>Three final projects will show you how to build a weather database from scratch, use triggers to prevent errors in anelection database, and use views to protect sensitive data in a salary database.<BR><BR>You’ll also learn how to:<BR><BR>- Query database tables for specific information, order the results, comment SQL code, and deal with null values- Define table columns to hold strings, integers, and dates, and determine what data types to use- Join multiple database tables as well as use temporary tables, common table expressions, derived tables, andsubqueries- Add, change, and remove data from tables, create views based on specific queries, write reusable stored routines, and automate and schedule events<BR>The perfect quick-start resource for database developers, MySQL Crash Course will arm you with the tools you needto build and manage fast, powerful, and secure MySQL-based data storage systems.

Learn the fundamentals of PL/PGSQL, the programming language of PostgreSQL which is most robust Open Source Relational Database. This book provides practical insights into developing database code objects such as functions and procedures, with a focus on effectively handling strings, numbers, and arrays to achieve desired outcomes, and transaction management.The unique approach to handling Triggers in PostgreSQL ensures that both functionality and performance are maintained without compromise. You'll gain proficiency in writing inline/anonymous server-side code within the limitations, along with learning essential debugging and profiling techniques. Additionally, the book delves into statistical analysis of PL/PGSQL code and offers valuable knowledge on managing exceptions while writing code blocks. Finally, you'll explore the installation and configuration of extensions to enhance the performance of stored procedures and functions.What You'll LearnUnderstand the PL/PGSQL conceptsLearn to debug, profile, and optimize PL/PGSQL codeStudy linting PL/PGSQL codeReview transaction management within PL/PGSQL codeWork with developer friendly features like operators, casts, and aggregatorsWho Is This Book ForApp developers, database migration consultants, and database administrators.

Learn the basics of writing SQL scripts. Using Standard SQL as the starting point, this book teaches writing SQL in various popular dialects, including PostgreSQL, MySQL/MariaDB, Microsoft SQL Server, Oracle, and SQLite.The book starts with a general introduction to writing SQL and covers the basic concepts. Author Mark Simon then covers database principles, and how database tables are designed. He teaches you how to filter data using the WHERE clause, and you will work with NULL, numbers, dates, and strings. You will also understand sorting results using the ORDER BY clause, sorting by calculated columns, and limiting the number of results. By the end of the book, you will know how to insert and update data, and summarize data with aggregate functions and groups. Three appendices cover differences between SQL dialects, working with tables, and a crash course in PDO.What You Will LearnFilter, sort, andcalculate dataSummarize data with aggregate functionsModify data with insert, update, and delete statementsStudy design principles in developing a databaseWho This Book Is ForDevelopers and analysts working with SQL, as well as web developers who want a stronger understanding of working with databases

Komprimiertes SQL-Praxiswissen zum Taschenbuchpreis- Kompaktes Nachschlagewerk zu typischen Aufgabenstellungen mit SQL- Deckt Microsoft SQL Server, MySQL, Oracle Database, PostgreSQL und SQLite ab und zeigt nun auch, wie Python und R mit einer relationalen Datenbank verbunden werden- Das Kapitel »Wie mache ich das?« beantwortet häufig gestellte Fragen zu SQL und erleichtert so den EinstiegWenn Sie bei Ihrer täglichen Arbeit als Datenanalyst:in, Data Scientist oder Data Engineer SQL verwenden, ist dieses beliebte Taschenbuch das ideale Nachschlagewerk für Sie. Zahlreiche Beispiele verdeutlichen die Vielschichtigkeit der Sprache. Das Buch beschreibt außerdem wichtige Aspekte von SQL, die in Microsoft SQL Server, MySQL, Oracle Database, PostgreSQL und SQLite zum Einsatz kommen.In dieser aktualisierten Ausgabe zeigt die Autorin Alice Zhao, wie diese Datenbankmanagementsysteme die SQL-Syntax für Abfragen und Änderungen an einer Datenbank implementieren. Sie finden Näheres zu Datentypen und Konvertierungen, zur Syntax regulärer Ausdrücke, zu Fensterfunktionen, Pivoting und Unpivoting und vieles mehr.

Get introduced to Azure Arc-enabled Data Services and the powerful capabilities to deploy and manage local, on-premises, and hybrid cloud data resources using the same centralized management and tooling you get from the Azure cloud. This book shows how you can deploy and manage databases running on SQL Server and Postgres in your corporate data center or any cloud as if they were part of the Azure platform. This second edition has been updated to the latest codebase, allowing you to use this book as your handbook to get started with Azure Arc-enabled Data Services today. Learn how to benefit from Azure's centralized management, the automated rollout of patches and updates, managed backups, and more. This book is the perfect choice for anyone looking for a hybrid or multi-vendor cloud strategy for their data estate. The authors walk you through the possibilities and requirements to get Azure SQL Managed Instance and PostgresSQL Hyperscale deployed outside of Azure, so the services are accessible to companies that cannot move to the cloud or do not want to use the Microsoft cloud exclusively. The technology described in this book will benefit those required to keep sensitive services, such as medical databases, away from the public cloud equally as those who can't move to a public cloud for other reasons such as infrastructure constraints but still want to benefit from the Azure cloud and the centralized management and tooling that it supports.What You Will LearnUnderstand the fundamentals and architecture of Azure Arc-enabled data servicesBuild a multi-cloud strategy based on Azure Data ServicesDeploy Azure Arc-enabled data services on premises or in any cloudDeploy Azure Arc-enabled SQL Managed Instance on premises or in any cloudDeploy Azure Arc-enabled PostgreSQL Hyperscale on premises or in any cloudBackupand Restore your data that is managed by Azure Arc-enabled data servicesManage Azure-enabled data services running outside of AzureMonitor Azure-enabled data services through Grafana and KibanaMonitor Azure-enabled data services running outside of Azure through Azure MonitorWho This Book Is ForDatabase administrators and architects who want to manage on-premises or hybrid cloud data resources from the Microsoft Azure cloud. Especially for those wishing to take advantage of cloud technologies while keeping sensitive data on premises and under physical control.

Analyze data like a pro, even if you’re a beginner.<BR><BR>Practical SQL is an approachable and fast-paced guide to SQL (Structured Query Language), the standard programming language for defining, organizing, and exploring data in relational databases. Anthony DeBarros, a journalist and data analyst, focuses on using SQL to find the story within your data. The examples and code use the open-source database PostgreSQL and its companion pgAdmin interface, and the concepts you learn will apply to most database management systems, including MySQL, Oracle, SQLite, and others.*<BR><BR>You’ll first cover the fundamentals of databases and the SQL language, then build skills by analyzing data from real-world datasets such as US Census demographics, New York City taxi rides, and earthquakes from US Geological Survey. Each chapter includes exercises and examples that teach even those who have never programmed before all the tools necessary to build powerful databases and access information quickly and efficiently.<BR><BR>You’ll learn how to:<BR>- Create databases and related tables using your own data<BR>- Aggregate, sort, and filter data to find patterns<BR>- Use functions for basic math and advanced statistical operations<BR>- Identify errors in data and clean them up<BR>- Analyze spatial data with a geographic information system (PostGIS)<BR>- Create advanced queries and automate tasks<BR><BR>This updated second edition has been thoroughly revised to reflect the latest in SQL features, including additional advanced query techniques for wrangling data. This edition also has two new chapters: an expanded set of instructions on for setting up your system plus a chapter on using PostgreSQL with the popular JSON data interchange format. <BR><BR>Learning SQL doesn’t have to be dry and complicated. Practical SQL delivers clear examples with an easy-to-follow approach to teach you the tools you need to build and manage your own databases.<BR><BR>* Microsoft SQL Server employs a variant of the language called T-SQL, which is not covered by Practical SQL.

You may know SQL basics, but are you taking advantage of its expressive power? This second edition applies a highly practical approach to Structured Query Language (SQL) so you can create and manipulate large stores of data. Based on real-world examples, this updated cookbook provides a framework to help you construct solutions and executable examples in severalflavors of SQL, including Oracle, DB2, SQL Server, MySQL, andPostgreSQL.SQL programmers, analysts, data scientists, database administrators, and even relatively casual SQL users will find SQL Cookbook to be a valuable problem-solving guide for everyday issues. No other resource offers recipes in this unique format to help you tackle nagging day-to-day conundrums with SQL.The second edition includes:- Fully revised recipes that recognize the greater adoption of window functions in SQL implementations- Additional recipes that reflect the widespread adoption of common table expressions (CTEs) for more readable, easier-to-implement solutions- New recipes to make SQL more useful for people who aren't database experts, including data scientists- Expanded solutions for working with numbers and strings- Up-to-date SQL recipes throughout the book to guide you through the basics

This is the official documentation of PostgreSQL version 11.2. The manual is 2,816 pages long, and has been split into three volumes.The volume ISBN numbers are: Volume One 9781680922738, Volume Two 9781680922745 and Volume Three 9781680922752.Volume One covers chapters Chapters 1-36. Volume Two covers Chapters 37-50 & the Reference section. Volume Three covers Chapters 51-70 & the Appendixes.Each volume as the full Preface, Bibliography and Index sections.This book has been written by the PostgreSQL developers and other volunteers in parallel to the development of the PostgreSQL software. It describes all the functionality that the current version of PostgreSQL officially supports.To make the large amount of information about PostgreSQL manageable in printed form, this book is organized in several parts. Each part is targeted at a different class of users, or at users in different stages of their PostgreSQL experience:• Part I is an informal introduction for new users.• Part II documents the SQL query language environment, including data types and functions, as well as user-level performance tuning. Every PostgreSQL user should read this.• Part III describes the installation and administration of the server. Everyone who runs a PostgreSQL server, be it for private use or for others, should read this part.• Part IV describes the programming interfaces for PostgreSQL client programs.• Part V contains information for advanced users about the extensibility capabilities of the server. Topics include user-defined data types and functions.• Part VI contains reference information about SQL commands, client and server programs. This part supports the other parts with structured information sorted by command or program.• Part VII contains assorted information that might be of use to PostgreSQL developers.You may download the original document as a PDF for free from Postgresql.org.

Thinking of migrating to PostgreSQL? This clear, fast-paced introduction helps you understand and use this open source database system. Not only will you learn about the enterprise class features in versions 9.5 to 10, you'll also discover that PostgeSQL is more than a database system—it's an impressive application platform as well.With examples throughout, this book shows you how to achieve tasks that are difficult or impossible in other databases. This third edition covers new features, such as ANSI-SQL constructs found only in proprietary databases until now: foreign data wrapper (FDW) enhancements; new full text functions and operator syntax introduced in version 9.6; XML constructs new in version 10; query parallelization features introduced in 9.6 and enhanced in 10; built-in logical replication introduced in Version 10.e.If you're a current PostgreSQL user, you'll pick up gems you may have missed before.- Learn basic administration tasks such as role management, database creation, backup, and restore- Apply the psql command-line utility and the pgAdmin graphical administration tool- Explore PostgreSQL tables, constraints, and indexes- Learn powerful SQL constructs not generally found in other databases- Use several different languages to write database functions- Tune your queries to run as fast as your hardware will allow- Query external and variegated data sources with foreign data wrappers- Learn how to use built-in replication to replicate data

Paperback

Paperback