Analytics Vidhya

APRIL 11, 2024

In this blog, we delve into the fundamentals of LlamaIndex, a groundbreaking technology that helps to build applications using LLMs. […] The post Building Natural Language to SQL Applications using LlamaIndex appeared first on Analytics Vidhya.

SQL 327

SQL Analytics Analytics AI 327

databricks

SEPTEMBER 10, 2024

We are excited to share the latest new features and performance improvements that make Databricks SQL simpler, faster and lower cost than ever.

SQL 321

SQL 321

databricks

MAY 18, 2023

Today, we are thrilled to announce that serverless compute for Databricks SQL is Generally Available on AWS and Azure! Databricks SQL (DB SQL).

SQL 349

SQL Azure AWS 349

KDnuggets

JULY 25, 2019

In this blog, let us explore data science and its relationship with SQL. As long as there is ‘data’ in data scientist, Structured Query Language (or see-quel as we call it) will remain an important part of it.

Data Scientist 301

Data Scientist SQL Data Science Database 301

databricks

AUGUST 13, 2024

Databricks SQL Serverless is now Generally Available on Google Cloud Platform (GCP)! SQL Serverless is available in 7 GCP regions and 40+ regions across AWS, Azure and GCP.

SQL 328

SQL Azure AWS 328

Analytics Vidhya

JUNE 27, 2022

Photo by Sebastian Herrmann on Unsplash Introduction As you know from my previous posts, I’ve started a mailing list to promote my blog. The post Combating Data Inconsistencies with SQL appeared first on Analytics Vidhya. In the last post in this series, we designed a way to answer the question of what’s causing folks to […].

SQL 271

SQL Data Science Analytics Analytics 271

databricks

JULY 31, 2024

We’re excited to announce the Public Preview of LakeFlow Connect for SQL Server, Salesforce, and Workday. These ingestion connectors enable simple and efficient.

SQL 338

SQL Data Engineering Data Engineer Data Engineering 338

databricks

NOVEMBER 5, 2024

We’re excited to announce that materialized views (MVs) and streaming tables (STs) are now Generally Available in Databricks SQL on AWS and Azure.

SQL 331

SQL Azure AWS 331

databricks

DECEMBER 4, 2024

Databricks launches two new self-paced trainings to enhance SQL and AI-powered analytics skills The "Get Started with SQL analytics and BI" course covers how to use Databricks SQL for data analysis and Databricks AI/BI Dashboards and Genie spaces Additional courses being developed include "Databricks AI/BI for self-service analytics" and a deep dive (..)

SQL 147

SQL Analytics Analytics Data Analyst 147

databricks

MARCH 29, 2023

Today, we are excited to announce that users can now run SQL queries on Databricks from within Visual Studio Code via a preview.

SQL 306

SQL 306

databricks

NOVEMBER 13, 2023

Today, we introduce the new availability of named arguments for SQL functions. With this feature, you can invoke functions in more flexible ways.

SQL 264

SQL Data Engineering Data Engineer Data Engineering 264

databricks

MARCH 6, 2023

Today, we are excited to announce the public preview of the Databricks SQL Statement Execution API, available on AWS and Azure. You can.

SQL 279

SQL Azure AWS 279

databricks

JANUARY 17, 2023

Since their initial release, SQL user-defined functions have become hugely popular among both Databricks Runtime and Databricks SQL customers. This simple yet powerful.

SQL 246

SQL ML ML Data Science 246

databricks

AUGUST 10, 2023

At this year's Data+AI Summit, Databricks SQL continued to push the boundaries of what a data warehouse can be, leveraging AI across the.

SQL 246

SQL Data Warehouse AI AI 246

databricks

FEBRUARY 21, 2024

We are excited to announce the upcoming general availability of Azure Private Link support for Databricks SQL (DBSQL) Serverless, planned in April 2024.

Azure 317

Azure SQL 317

databricks

JUNE 27, 2023

We are thrilled to announce that materialized views and streaming tables are now publicly available in Databricks SQL on AWS and Azure. Streaming.

SQL 263

SQL Azure AWS 263

databricks

NOVEMBER 7, 2024

We are excited to share the latest features and performance improvements that make Databricks SQL simpler, faster, and more affordable than ever. Databricks.

SQL 227

SQL 227

databricks

JANUARY 19, 2023

Built-in functions extend the power of SQL with specific transformations of values for common needs and use cases. For example, the LOG10 function.

SQL 246

SQL 246

databricks

OCTOBER 13, 2023

Today, we are excited to announce the general availability of the Databricks SQL Statement Execution API on AWS and Azure, with support for.

SQL 263

SQL Azure AWS 263

KDnuggets

FEBRUARY 1, 2024

This blog covers non-technical, Python, SQL, statistics, data analysis, and machine learning questions. Learn about the most common questions asked during data science interviews.

Data Science 351

Data Science SQL Data Analysis Data Analysis 351

databricks

AUGUST 12, 2024

The blog explores data streams from NASA satellites using Apache Kafka and Databricks. It demonstrates ingestion and transformation with Delta Live Tables in SQL and AI/BI-powered analysis of supernova events.

Apache Kafka 290

Apache Kafka SQL AI AI 290

databricks

APRIL 20, 2023

We are excited to announce the general availability of the Databricks SQL Driver for GO. This follows the recent general availability of Databricks.

SQL 246

SQL 246

Towards AI

APRIL 28, 2025

Learn how to filter data efficiently in SQL with powerful techniques and real-world examples for data science.SQL Filtering Techniques for Data Science The WHERE clause is the part of the SELECT statement that is used to list conditions that determine which rows in the table should be included in the result set.

Data Science 86

Data Science SQL Data Scientist Database 86

databricks

APRIL 20, 2023

We are excited to announce the general availability of the Databricks SQL Driver for NodeJS. This follows the recent general availability of Databricks.

SQL 243

SQL 243

Data Science Dojo

JULY 12, 2023

Welcome to the world of databases, where the choice between SQL (Structured Query Language) and NoSQL (Not Only SQL) databases can be a significant decision. In this blog, we’ll explore the defining traits, benefits, use cases, and key factors to consider when choosing between SQL and NoSQL databases.

SQL 195

SQL Database Big Data Big Data 195

databricks

SEPTEMBER 21, 2023

Introduction In this blog post, we'll explore a set of advanced SQL functions available within Apache Spark that leverage the HyperLogLog algorithm, enabling.

SQL 279

SQL Algorithm Data Engineering Data Engineer 279

Pickl AI

OCTOBER 30, 2024

Summary: Dynamic SQL is a powerful feature in SQL Server that enables the construction and execution of SQL queries at runtime. Introduction Dynamic SQL is a powerful programming technique that allows developers to construct and execute SQL statements at runtime. What is Dynamic SQL?

SQL 52

SQL Database Data Science Artificial Intelligence 52

Data Science Dojo

FEBRUARY 1, 2023

Introduction Dedicated SQL pools offer fast and reliable data import and analysis, allowing businesses to access accurate insights while optimizing performance and reducing costs. One way to do this is by pausing and scaling the dedicated SQL pool. SQL pools use resource groups to allocate memory to queries.

Azure 195

Azure SQL Analytics Analytics 195

Pickl AI

NOVEMBER 3, 2024

Summary: Pattern matching in SQL enables users to identify specific sequences of data within databases using various techniques such as the LIKE operator and regular expressions. SQL provides several techniques for pattern matching, enabling users to efficiently query databases and extract meaningful insights.

SQL 52

SQL Database Data Analysis Data Analysis 52

databricks

OCTOBER 2, 2024

Introduction Applying Large Language Models (LLMs) for code generation is becoming increasingly prevalent, as it helps you code faster and smarter. A primary.

SQL 330

SQL Data Engineering Data Engineer Data Engineering 330

Pickl AI

FEBRUARY 2, 2025

Summary: Mastering SQL data types improves database efficiency, query performance, and storage management. Introduction SQL (Structured Query Language) is the foundation of modern data management. Understanding SQL data types is crucial for effective querying, ensuring optimal storage, retrieval speed, and data integrity.

SQL 52

SQL Database Business Intelligence Business Intelligence 52

Data Science Dojo

MARCH 10, 2023

Among the plethora of programming languages , we have SQL. Also known as Structured Query Language, SQL is a programming language widely used for managing data stored in relational databases. In this guide, we will highlight the top basic SQL commands that every developer should be familiar with. What is SQL?

SQL 195

SQL Database 195

Dataversity

OCTOBER 16, 2024

Structured query language (SQL) is one of the most popular programming languages, with nearly 52% of programmers using it in their work. SQL has outlasted many other programming languages due to its stability and reliability.

SQL 52

SQL AI AI ETL 52

databricks

OCTOBER 1, 2024

Introduction Retrieval-augmented generation (RAG) has revolutionized how enterprises harness their unstructured knowledge base using Large Language Models (LLMs), and its potential has far-reaching.

SQL 287

SQL ML ML Data Science 287

IBM Data Science in Practice

JANUARY 2, 2025

Building on the foundation of data fabric and SQL assets discussed in Enhancing Data Fabric with SQL Assets in IBM Knowledge Catalog , this blog explores how organizations can leverage automated microsegment creation to streamline data analysis. Step 4: Press SelectColumn Select the column you want to base segmentation on.

SQL 100

SQL Data Quality Data Profiling Data Preparation 100

Pickl AI

APRIL 8, 2025

Summary:- SQL FULL OUTER JOIN retrieves all records from two tables, even when some dont match. This blog explains its syntax, use cases, troubleshooting, and alternatives with practical examples to help you master this SQL technique. Thats where SQL full outer join comes in! Thats where SQL full outer join comes in!

SQL 52

SQL Data Science Database Data Analysis 52

Pickl AI

MARCH 11, 2025

Summary: SQL regular expression (REGEX) enhance data retrieval by enabling complex pattern matching in MySQL. Learn how REGEX improves efficiency in filtering, validating, and manipulating text-based data within SQL databases. This is where SQL regular expressions (REGEX) become invaluable.

SQL 52

SQL Database Data Science Analytics 52