Analytics Vidhya

JULY 1, 2024

Introduction SQL is easily one of the most important languages in the computer world. It serves as the primary means for communicating with relational databases, where most organizations store crucial data. SQL plays a significant role including analyzing complex data, creating data pipelines, and efficiently managing data warehouses.

SQL 316

SQL Data Warehouse Data Pipeline Database 316

Analytics Vidhya

SEPTEMBER 26, 2023

Introduction The launch of ChatGPT marked an unprecedented moment in the history of AI. With their incredible capabilities, ChatGPT and many other generative AI tools have the potential to change dramatically the way we work. Writing SQL is one task already changing in data science following the AI revolution.

SQL 343

SQL Data Science AI AI 343

Data Science Dojo

APRIL 25, 2023

SQL (Structured Query Language) is an important tool for data scientists. It is a programming language used to manipulate data stored in relational databases. Mastering SQL concepts allows a data scientist to quickly analyze large amounts of data and make decisions based on their findings.

Data Scientist 370

Data Scientist SQL Machine Learning Machine Learning 370

KDnuggets

NOVEMBER 6, 2023

Graph databases are quickly becoming a core part of the analytics toolset for enterprise IT organizations. If you know SQL, you can easily learn Cypher and open up a huge opportunity for data analysis.

Database 332

Database SQL Data Analysis Data Analysis 332

Analytics Vidhya

DECEMBER 12, 2023

Introduction In the rapidly evolving landscape of generative AI, the pivotal role of vector databases has become increasingly apparent. Join us on a journey through the intricacies of […] The post How Do Vector Databases Shape the Future of Generative AI Solutions? appeared first on Analytics Vidhya.

Database 318

Database Artificial Intelligence Artificial Intelligence AI 318

Analytics Vidhya

JANUARY 2, 2024

Introduction SQL (Structured Query Language) is a powerful tool for managing and analyzing data in relational databases. It allows users to retrieve, manipulate, and transform data using a set of standardized commands.

SQL 301

SQL Database Analytics Analytics 301

Analytics Vidhya

FEBRUARY 29, 2024

Introduction In the field of modern data management, two innovative technologies have appeared as game-changers: AI-language models and graph databases. AI language models, shown by new products like OpenAI’s GPT series, have changed the landscape of natural language processing.

Database 290

Database Natural Language Processing AI AI 290

Analytics Vidhya

APRIL 11, 2024

Introduction With the rising advent of large language models and advancements in the field of AI we are witnessing new developments and opportunities in a way we work and interact with digital world around us.

SQL 327

SQL Analytics Analytics AI 327

Flipboard

MARCH 25, 2025

In this post, we present an approach to using natural language processing (NLP) to query an Amazon Aurora PostgreSQL-Compatible Edition database. The solution presented in this post assumes that an organization has an Aurora PostgreSQL database.

Natural Language Processing 165

Natural Language Processing Database Python AI 165

Hacker News

JANUARY 14, 2024

? Chat with your SQL database ?. Accurate Text-to-SQL Generation via LLMs using RAG ?. GitHub - vanna-ai/vanna: ? Chat with your SQL database ?. Accurate Text-to-SQL Generation via LLMs using RAG ?.

SQL 140

SQL Database AI AI 140

Flipboard

MAY 28, 2025

Snowflake has thousands of enterprise customers that use the companys data and AI technologies. Though many issues with generative AI are solved there is still lots of room for improvement. Two such issues are text-to-SQL query and AI inference. SQL is the query language used for databases and it

SQL 168

SQL Database AI AI 168

Hacker News

APRIL 1, 2024

An open-source, high-performance SQL vector database built on ClickHouse. myscale/myscaledb

SQL 139

SQL Database AI AI 139

Flipboard

MAY 19, 2025

Text-to-SQL can automatically transform analytical questions into executable SQL code for enhanced data accessibility and streamlined data exploration, from analyzing sales data and monitoring performance metrics to assessing customer feedback.

SQL 128

SQL Database AI AI 128

Data Science Dojo

OCTOBER 31, 2024

According to Google AI, they work on projects that may not have immediate commercial applications but push the boundaries of AI research. With the continuous growth in AI, demand for remote data science jobs is set to rise. Specialists in this role help organizations ensure compliance with regulations and ethical standards.

Data Science 195

Data Science Data Scientist Machine Learning Machine Learning 195

Analytics Vidhya

DECEMBER 24, 2024

In the rapidly evolving landscape of software development, the intersection of artificial intelligence, data validation, and database management has opened up unprecedented possibilities.

SQL 208

SQL Artificial Intelligence Artificial Intelligence Database 208

KDnuggets

AUGUST 16, 2023

How to Use ChatGPT to Convert Text into a PowerPoint Presentation • Best Python Tools for Building Generative AI Applications Cheat Sheet • Data Scientists Need to Specialize to Survive the Tech Winter • Python Vector Databases and Vector Indexes: Architecting LLM Apps • How To Speed Up SQL Queries Using Indexes [Python Edition]

Python 269

Python Data Scientist SQL Database 269

Flipboard

MAY 28, 2025

Simplifying the UI from the traditional human browser to a conversational AI assistant can enhance the user experience in the clinical research process. Generative AI is a promising next step in the evolutionary process of leading this change. Finally, we present instructions to deploy the service in your own AWS account.

SQL 97

SQL AWS AI AI 97

AWS Machine Learning Blog

APRIL 14, 2025

Generative AI enables us to accomplish more in less time. Text-to-SQL empowers people to explore data and draw insights using natural language, without requiring specialized database knowledge. We also learned that robust error handling is critical when errors occur in the generated SQL query based on users questions.

SQL 91

SQL Database AWS AI 91

Dataconomy

AUGUST 7, 2023

Artificial intelligence is no longer fiction and the role of AI databases has emerged as a cornerstone in driving innovation and progress. An AI database is not merely a repository of information but a dynamic and specialized system meticulously crafted to cater to the intricate demands of AI and ML applications.

Database 168

Database AI AI ML 168

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

Towards AI

APRIL 28, 2025

Author(s): Suraj Jha Originally published on Towards AI. In short, we can say it is used for filtering the database. Similarly, SQL uses Boolean logic to check data against the conditions in the WHERE clause to determine whether each row should be included in the output. Join thousands of data leaders on the AI newsletter.

Data Science 84

Data Science SQL Data Scientist Database 84

AWS Machine Learning Blog

MARCH 18, 2025

SQL is one of the key languages widely used across businesses, and it requires an understanding of databases and table metadata. This can be overwhelming for nontechnical users who lack proficiency in SQL. This application allows users to ask questions in natural language and then generates a SQL query for the users request.

SQL 113

SQL Database AI AI 113

AWS Machine Learning Blog

OCTOBER 24, 2024

Amazon Bedrock Agents helps you accelerate generative AI application development by orchestrating multistep tasks. With the power of AI automation, you can boost productivity and reduce cost. The generative AI–based application builder assistant from this post will help you accomplish tasks through all three tiers.

AWS 100

AWS SQL Database AI 100

Flipboard

MAY 23, 2025

In this post, we describe a solution to integrate generative AI applications with relational databases like Amazon Aurora PostgreSQL-Compatible Edition using RDS Data API (Data API) for simplified database interactions, Amazon Bedrock for AI model access, Amazon Bedrock Agents for task automation and Amazon Bedrock Knowledge Bases for context information (..)

Database 138

Database AI AI SQL 138

Hacker News

APRIL 7, 2025

Databases are key to building almost any production application: you need to persist state for your users (or agents), be able to query it from a number of different clients, and you want it to be fast. Database DX When we first started Outerbase, we saw how complicated databases could be.

Database 181

Database SQL AI AI 181

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

KDnuggets

JUNE 6, 2025

Blog Top Posts About Topics AI Career Advice Computer Vision Data Engineering Data Science Language Models Machine Learning MLOps NLP Programming Python SQL Datasets Events Resources Cheat Sheets Recommendations Tech Briefs Advertise Join Newsletter 5 Error Handling Patterns in Python (Beyond Try-Except) Stop letting errors crash your app.

143

143

Hacker News

MARCH 14, 2025

How Dust's Query Tables agent tool evolved from parsing CSVs to parsing data warehouses, creating a unified SQL interface for AI data analysis.

Data Warehouse 156

Data Warehouse Database SQL Data Analysis 156

insideBIGDATA

JULY 16, 2023

Kinetica, the database for time & space, announced a totally free version of Kinetica Cloud where anyone can sign-up instantly without a credit card to experience Kinetica’s generative AI capabilities to analyze real-time data.

SQL 195

SQL Database AI AI 195

Pickl AI

APRIL 11, 2025

Summary: This tutorial guides you through using SQL’s auto increment feature to automatically generate unique identifiers for database records. It covers syntax, examples, and benefits across various SQL databases like MySQL and SQL Server. This is where Auto Increment in SQL becomes invaluable.

SQL 52

SQL Database Database Administration 52

AWS Machine Learning Blog

NOVEMBER 20, 2024

Whether it’s structured data in databases or unstructured content in document repositories, enterprises often struggle to efficiently query and use this wealth of information. The solution combines data from an Amazon Aurora MySQL-Compatible Edition database and data stored in an Amazon Simple Storage Service (Amazon S3) bucket.

Database 115

Database AWS SQL ETL 115

Data Science Dojo

MARCH 27, 2025

It powers business decisions, drives AI models, and keeps databases running efficiently. Without proper organization, databases become bloated, slow, and unreliable. Essentially, data normalization is a database design technique that structures data efficiently. Think about itdata is everywhere.

Database 195

Database Data Warehouse Machine Learning Machine Learning 195

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

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

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. Why is REGEX Useful in MySQL?

SQL 52

SQL Database Data Science Analytics 52

Pickl AI

APRIL 4, 2025

Summary: The SQL Cheat Sheet provides a handy reference for mastering SQL commands. It covers database creation, querying data using SELECT and WHERE, joins, data manipulation with INSERT and UPDATE, and advanced operations like transactions and constraints. Let’s dive in! Populating it with data. Modifying existing data.

SQL 52

SQL Database Data Scientist 52

insideBIGDATA

DECEMBER 25, 2023

Juan Sequeda, Principal Scientist at data.world, recently published a research paper, "A Benchmark to Understand the Role of Knowledge Graphs on Large Language Model's Accuracy for Question Answering on Enterprise SQL Databases." He and his co-authors benchmarked LLM accuracy in answering questions over real business data.

SQL 243

SQL Database Big Data Big Data 243