No Clocks

The book that teaches SQL to developers: Learn to replace thousands of lines of code with simple queries!

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 Welcome to the PostgreSQL Tutorial. The following few chapters are intended to give a simple introduction to PostgreSQL, relational …

Learn PostgreSQL quickly through a practical PostgreSQL tutorial designed for database administrators and application developers.

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.

One common misconception about DataOps is that it is just DevOps applied to data analytics. While a little semantically misleading, the…

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…

Learn how to harness the power of Obsidian to create your connected-thoughts library. Make Obsidian your personal idea engine

Obsidian Publish!

Data engineering makes data more useful and accessible by sourcing & preparing the data to be handled by data scientists. Learn more about the responsibilities.

Top 20 Most Commonly Used Data Engineering Tools 2021

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…

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 is an interesting topic. There are so many different languages, frameworks and other tools that can be used to program. The world of programming

Cut through information overload with this big guide to systematically reorganizing your files, social media, email, apps, passwords, and more.

Find the best data modeling tools available on the market. What they do, and don't do.

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...

Sharing top billing on the list of data science capabilities, machine learning and artificial intelligence are not just buzzwords – many organizations are eag

dbdiagram.io Release Notes and Roadmap. dbdiagram is a quick and simple free tool to help you draw your database relationship diagrams and flow quickly using simple DSL language.

A free, simple, developer-friendly tool to help you create web-based documentation for your database

Quick and simple free tool to help you draw your database relationship diagrams and flow quickly using just keyboard

Introduction

Docker is a containerization tool used for spinning up isolated, reproducible application environments. This page lists all of our Python Docker tutorials.

Learn the step by step process to create a Star Schema in SQL Server with the SQL Server Data Tools, Management Studio and more.

Virtual workshop on June 20 as part of e-Rum 2020 to learn how to build your own interactive visualisation packages.