Community Guide to PostgreSQL GUI Tools - PostgreSQL wiki

Development
Basics of Gitflow Workflow for SQL Database Projects
This tip is focused on the concepts of using Git Workflow with SQL Database Projects.
PostgreSQL Exercises
Become a Data Engineer on a Shoestring (aka The Best Free Courses and Learning Resources) - Data Engineering Coding Bootcamp — Pipeline Data Engineering Academy
I was tinkering with the idea of finding the right way to help others to identify the resources that give you bang for the buck when it comes to upskilling yourself in data engineering… and this is what I came up with. The best data engineering courses, learning materials, data engineering training.
THE DATA ENGINEERING COOKBOOK
Introduction
Migrate SQL Server to Amazon Aurora PostgreSQL using best practices and lessons learned from the field | Amazon Web Services
Many organizations are benefiting from the performance gains and ease of administration of the Amazon Aurora database platform. The idea of breaking free from commercial licenses, backup administration, and data center maintenance is always a welcome thought. But where to begin, and how complex is the journey to migrate from SQL Server to Amazon Aurora […]
Everything you need to know about Postgres stored procedures and functions
This article reviews the differences between stored procedures and functions in Postgres and the types of functionality they provide.
How to write effective Stored Procedures in PostgreSQL | Packt Hub
In this article, we explain the concept of Stored Procedures, and how to write them effectively in PostgreSQL 9.6. PostgreSQL is an open source database
The Art of PostgreSQL
The book that teaches SQL to developers: Learn to replace thousands of lines of code with simple queries!
The Art of PostgreSQL
The book that teaches SQL to developers: Learn to replace thousands of lines of code with simple queries!
SQL and Business Logic
Business logic is supposed to be the part of the application where you
deal with customer or user facing decisions and computations. It is often
argued that this part should be well separated from the rest of the
technical infrastructure of your code. Of course, SQL and relational
database design is meant to support your business cases (or user stories),
so then we can ask ourselves if SQL should be part of your business logic
implementation. Or actually, how much of your business logic should be SQL?
Part I. Tutorial
Part I. Tutorial Welcome to the PostgreSQL Tutorial. The following few chapters are intended to give a simple introduction to PostgreSQL, relational …
PostgreSQL SQL Tricks
PostgreSQL Tutorial - Learn PostgreSQL from Scratch
Learn PostgreSQL quickly through a practical PostgreSQL tutorial designed for database administrators and application developers.
Postgres Guide
We here are very big fans of Postgres as a database and believe it is often the best database for the job. For many though, working with and maintaining Postgres involves a steep learning curve. This guide is designed as an aid for beginners and experienced users to find specific tips and explore tools available within Postgres.
If you want to take the quick & painless approach instead, there are great services available for Postgres hosting.
DataOps is NOT Just DevOps for Data
One common misconception about DataOps is that it is just DevOps applied to data analytics. While a little semantically misleading, the…
Stream Your Database Changes with Change Data Capture
Nobody wants to look at a dashboard or make decisions with yesterday’s data. We live in a world where real-time information is a…
A Beginner's Guide to Obsidian - Work Life Win Repeat
Learn how to harness the power of Obsidian to create your connected-thoughts library. Make Obsidian your personal idea engine
Data Engineering Wiki
Obsidian Publish!
What Is Data Engineering? Responsibilities & Tools
Data engineering makes data more useful and accessible by sourcing & preparing the data to be handled by data scientists. Learn more about the responsibilities.
The Top 20 Data Engineering Tools Used by Growing Tech Companies
Top 20 Most Commonly Used Data Engineering Tools 2021
What is a (Data) Lakehouse?
Evolution of Data Warehouse Architecture (Pic source: Databricks) With the evolution of scalable cloud technology and exponential growth of digital technologies, the preferred Data Warehouse (DW) a…
The Enterprise Big Data Lake
Chapter 1. Introduction to Data Lakes Data-driven decision making is changing how we work and live. From data science, machine learning, and advanced analytics to real-time dashboards, decision makers are … - Selection from The Enterprise Big Data Lake [Book]
Programming Terminology: Glossary of Programming Terms
Programming is an interesting topic. There are so many different languages, frameworks and other tools that can be used to program. The world of programming
Introduction To The ETL Framework - Documents
Benchmark - top 5 data modeling tools
Find the best data modeling tools available on the market. What they do, and don't do.
Image in Shinydashboard Header
Powershell: Your first internal PSScript repository
Setting up a basic internal repository for scripts and modules is surprisingly simple. I had no idea how easy this was for the longest time. If you are looking for ways to distribute your modules to others in your team, then you should consider this approach. Index Index Pre-requirements PowerShellGet...
Data Engineering and Its Main Concepts: Explaining the Data Pipeline, Data Warehouse, and Data Engineer Role
Sharing top billing on the list of data science capabilities, machine learning and artificial intelligence are not just buzzwords – many organizations are eag
Big Data with R - Exercise book | _main.utf8.md