#sql Development Tutorials & Tips | Roast Dev

100daysofcode 100daysofdevops 100pay 10mistakes 10yearworkanniversary 11 11labs 11tly 11ty 127001

Shrinking Smallfile Tablespaces in Oracle 23ai(23.7)

As you may know, starting from Oracle 23ai, we can shrink permanent tablespaces. However, that was limited to bigfile tablespaces, and shrinking smallfile tablespaces was not possible. Although, by de...

13.03.2025 0 Read More

Getting Started with SQL DISTINCT

SQL DISTINCT is an essential feature for eliminating duplicate rows in query results. This article offers a quick overview and examples to help you incorporate it into your queries efficiently. ...

13.03.2025 0 Read More

Why Every Data Analyst Needs To Know SQL: A Beginner's Guide

Why Every Data Analyst Needs To Know SQL: A Beginner's Guide Introduction Transitioning into data analytics can feel overwhelming, especially when coming from a different career fiel...

13.03.2025 0 Read More

Data Redaction and View Enhancements – Oracle 23ai(23.6)

Oracle 23.6 introduces new capabilities in Data Redaction, one of which is Data Redaction support at the view level. In previous versions, attempting to access a redacted column in a view resulted in ...

13.03.2025 0 Read More

Game-Changing Guide to SQL for SEO Optimization

SQL for SEO is like a recipe book for culinary fans. Just like a thick recipe book that provides stepwise instructions on how to cook your favorite meals, SQL delivers structured information from diff...

13.03.2025 0 Read More

Oracle 23ai - Staging Table Feature

As you may know, using staging tables is a common practice in Data Warehouse environments, primarily during the data loading process into the Warehouse Database. Typically, raw data received from sour...

13.03.2025 0 Read More

What is SQL? A Simple Introduction to Structured Query Language

What is SQL? SQL (Structured Query Language) is a programming language used to interact with databases. It allows you to create, read, update, and delete data (CRUD operations) in a database. With SQL...

14.03.2025 0 Read More

The DuckDB Local UI

The DuckDB Local UI DuckDB introduces a local UI starting from version 1.2.1. The UI is a web page served by a HTTP server running on localhost.Key points: • Local Web Interface: Runs queries locall...

14.03.2025 0 Read More

𝗛𝗼𝘄 𝘁𝗼 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗶𝗰𝗮𝗹𝗹𝘆 𝗨𝗽𝗱𝗮𝘁𝗲 𝗦𝗽𝗲𝗻𝘁 𝗔𝗺𝗼𝘂𝗻𝘁 𝗶𝗻 𝗕𝘂𝗱𝗴𝗲𝘁 𝗨𝘀𝗶𝗻𝗴 𝗧𝗿𝗶𝗴𝗴𝗲𝗿𝘀 𝗶𝗻 𝗦𝗤𝗟 𝗦𝗲𝗿𝘃𝗲𝗿

...

14.03.2025 0 Read More

Aplicação 397x mais rápida com desnormalização

Quando trabalhamos com bancos de dados relacionais, é comum nos depararmos com situações onde precisamos contar registros relacionados em uma tabela.Primeiramente vamos considerar as seguintes tabe...

14.03.2025 0 Read More

Shrinking Smallfile Tablespaces in Oracle 23ai(23.7)

Getting Started with SQL DISTINCT

Why Every Data Analyst Needs To Know SQL: A Beginner's Guide

Data Redaction and View Enhancements – Oracle 23ai(23.6)

Game-Changing Guide to SQL for SEO Optimization

Oracle 23ai - Staging Table Feature

What is SQL? A Simple Introduction to Structured Query Language

The DuckDB Local UI

𝗛𝗼𝘄 𝘁𝗼 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗶𝗰𝗮𝗹𝗹𝘆 𝗨𝗽𝗱𝗮𝘁𝗲 𝗦𝗽𝗲𝗻𝘁 𝗔𝗺𝗼𝘂𝗻𝘁 𝗶𝗻 𝗕𝘂𝗱𝗴𝗲𝘁 𝗨𝘀𝗶𝗻𝗴 𝗧𝗿𝗶𝗴𝗴𝗲𝗿𝘀 𝗶𝗻 𝗦𝗤𝗟 𝗦𝗲𝗿𝘃𝗲𝗿

Aplicação 397x mais rápida com desnormalização

#reading

#popular