Skip to content
No results
We use cookies to ensure that we give you the best experience on our website.

# Category sql

all about SQL

- sql, SQL language

## Gudu SQLFlow direct data flow introduction

In this article, we’ll introduce some of the SQL elements that generate direct dataflows, which are the main archetypes of production dataflows. 1、Select Example statement: The data for the target column “eName” comes from the scott.emp.empName column, so we have…

- han yu
- May 26, 2022

- sql, SQL language, SQL skills

## Introduction to where-group-by clause in Gudu SQLFlow indirect data flow

In this article, we will introduce where-group-by clauses in Gudu SQLFlow indirect data flow. 1. column in the where clause Some columns in the source table in the WHERE clause do not affect the target columns, but are critical to…

- han yu
- May 25, 2022

- sql, SQL language

## How to Get Data Lineage by Analyzing Oracle’s SQL Statements and Stored Procedures?

An important foundational work in data governance is to analyze the data lineage in an organization. With complete data lineage, we can use it for data traceability, table and column change impact analysis, data compliance certification, data quality inspection, and more.…

- han yu
- May 23, 2022

- sql, SQL language

## Introduction to Gudu SQLFlow Indirect Data Flow and Pseudo Columns

Gudu SQLFlow Indirect Data Flow & Pseudo Columns Introduction This article describes some of the SQL elements that generate indirect data flow. Indirect data flow is typically generated by columns used in where clauses, group by clauses, aggregate functions, etc. To…

- han yu
- May 21, 2022

- sql, SQL language

## Introduction to Gudu SQLFlow Data Flow Generation

Gudu SQLFlow Data Flow Generation As one of the most popular data lineage tools, Gudu SQLFlow is a tool that automatically discovers data flow by analyzing SQL scripts. It shows the flow of data between tables/views and columns in a data…

- han yu
- May 20, 2022

- sql, SQL language, SQL skills

## Gudu SQLFlow : a professional and easy-to-use data lineage tool

Gudu SQLFlow With the development and popularization of big data technology, data governance and data quality have become more and more important for many organisations. Data lineage analysis has emerged and become increasingly popular in the industry and Gudu SQLFlow…

- han yu
- May 18, 2022

- sql, SQL language, SQL skills

## How to use grabit to analyze the data lineage in mysql database?

Grabit is a helper tool for collecting SQL scripts and stored procedures from various sources such as databases, revision systems like GitHub, bitbucket, and filesystems, and pushes them to SQLFlow server for analysis and generating metadata and data lineage. Grabit official…

- han yu
- May 16, 2022

- formatting, sql, wordpress

## How to add syntax colored and well formatted SQL in your wordpress blog

People always post SQL code into blogs and forums need a tool to help them to prepare dull monochrome, badly-formatted SQL code for HTML-based publication in a nice clean style. SQL Pretty Printer is able to output HTML in both…

- admin
- October 4, 2011

- formatting, sql

## Case (Capitalization) in SQL statement

When format SQL query, capitalization refers to the way in which SQL token should or should not be capitalized in your code. For example, some developers prefer to make all reserved keys uppercase, others prefer lowercase, and some mix and…

- admin
- September 29, 2011

- best practices, sql

## A list of SQL best practices

Here are some SQL programming guidelines and best practices we collected, keeping quality, performance and maintainability in mind. This list is not complete at this moment, and will be constantly updated. Do not use SELECT * in your queries. Always…

- admin
- September 27, 2011