Analytics Vidhya

JULY 2, 2024

Introduction Structured Query Language (SQL) is the foundation of managing and manipulating relational databases. One of the most powerful features in SQL is the use of views. It is a must-have skill for not just data analysts, but basically anyone working with […] The post What Are Views in SQL?

SQL 336

SQL Data Analyst Database Analytics 336

Analytics Vidhya

JULY 8, 2024

Tools like Structured Query Language (SQL) help you do this efficiently. In this […] The post Difference Between SQL Commit and SQL Rollback appeared first on Analytics Vidhya. It offers an array of built-in commands that can handle transactions, ensuring data integrity and consistency.

SQL 303

SQL Database Analytics Analytics 303

Analytics Vidhya

JUNE 21, 2024

Introduction SQL is a go to tool when working with data, and so is important for anybody working with data. SQL has a wide range of functions for creating, manipulating, and managing databases, making it all so easy.

SQL 303

SQL Database Analytics Analytics 303

KDnuggets

JULY 31, 2024

If you work in data, you’ll write SQL queries all the time. So how do you write efficient SQL queries that are optimized for performance? This tutorial will help you with just that.

SQL 322

SQL 322

Analytics Vidhya

JUNE 11, 2024

Introduction Stored procedures are a crucial part of SQL databases. They consist of prepared SQL code that you can save and reuse. This article […] The post Stored Procedure in SQL appeared first on Analytics Vidhya. This article […] The post Stored Procedure in SQL appeared first on Analytics Vidhya.

SQL 318

SQL Database Analytics Analytics 318

Flipboard

APRIL 24, 2025

Recent advances in generative AI have led to the rapid evolution of natural language to SQL (NL2SQL) technology, which uses pre-trained large language models (LLMs) and natural language to generate database queries in the moment.

SQL 152

SQL Database AWS ML 152

Analytics Vidhya

JULY 17, 2024

As a data engineer working on […] The post Conditional Aggregation in SQL appeared first on Analytics Vidhya. This skill helps distill complex information into meaningful insights, driving informed decisions across various industries like finance, healthcare, retail, and technology.

SQL 317

SQL Data Analyst Data Engineering Data Engineering 317

Analytics Vidhya

AUGUST 5, 2024

Gather ranking functions of SQL which are […] The post Rank Function in SQL appeared first on Analytics Vidhya. Again, since there are thousands of transactions and numerous factors to consider, the task of sorting and ranking the data through traditional simple methods is a hectic.

SQL 291

SQL Analytics Analytics Database 291

Analytics Vidhya

AUGUST 8, 2024

Introduction Think about it like you’re solving a puzzle where each of those SQL queries is a part of the image and you are trying to get the complete picture out of it. Here are the practices described in this guide that teach you how to read and write SQL queries.

SQL 306

SQL Analytics Analytics 306

Analytics Vidhya

JUNE 3, 2024

Introduction In SQL and database management, efficiently querying and retrieving data is paramount. Unlike basic string functions, CONTAINS enables complex queries and patterns, making it a powerful asset for developers and database administrators. […] The post What is CONTAINS in SQL? appeared first on Analytics Vidhya.

SQL 328

SQL Database Administration Database Analytics 328

databricks

OCTOBER 14, 2024

Over the last few years, we've seen tremendous growth and adoption of Databricks SQL , our intelligent data warehouse purpose-built on the Data.

SQL 326

SQL Data Warehouse 326

KDnuggets

JUNE 12, 2024

A simple tutorial on how to connect to databases, execute SQL queries, and analyze and visualize data.

SQL 378

SQL Python Database 378

Analytics Vidhya

JULY 3, 2024

Introduction Keys are an important part of SQL, and the primary, foreign, and candidate keys hold a significant value. Further in […] The post What are the SQL Alternate Keys? The alternate key holds are crucial, yet we often overlook their importance. Intriguing right?

SQL 335

SQL Database Analytics Analytics 335

Analytics Vidhya

JUNE 21, 2024

Introduction ALTER command is one of the most important SQL functions to know for database manipulation and management. In addition, ALTER TABLE […] The post SQL ALTER TABLE Statement appeared first on Analytics Vidhya. We’ll look at different ways to use the ALTER command to highlight its flexibility.

SQL 316

SQL Database Analytics Analytics 316

Analytics Vidhya

JUNE 26, 2024

Introduction An essential tool for data manipulation is the SQL INTERSECT. Overview What is SQL INTERSECT? […] The post Understanding SQL INTERSECT Operator appeared first on Analytics Vidhya. In essence, INTERSECT joins two tables and yields a result set that contains the intersection (common records) of the two tables.

SQL 301

SQL Analytics Analytics 301

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 318

SQL 318

Analytics Vidhya

JUNE 25, 2024

Introduction SQL is an important tool that every data scientist and data analyst should know. Its UNION statement allows you to combine the results of two or more SQL SELECT statements. We will delve into the basics of UNION and explore different […] The post Introduction to SQL Union appeared first on Analytics Vidhya.

SQL 300

SQL Data Analyst Data Scientist Analytics 300

KDnuggets

MAY 31, 2024

SQL seems like a data science underdog compared to Python and R. However, it’s far from it. I’ll show you here how you can use it as a data scientist.

Data Scientist 344

Data Scientist SQL Data Science Python 344

KDnuggets

JUNE 10, 2024

Learn SQL and databases through free courses, tutorials, tools, guides, books, practice exercises, projects, awesome lists, and other resources.

SQL 340

SQL Database 340

Analytics Vidhya

MARCH 26, 2025

By converting natural language queries into optimized SQL commands, the toolbox eliminates the complexities of SQL, making data retrieval more intuitive and accessible for both developers and non-technical users.

SQL 144

SQL Database Python AI 144

Analytics Vidhya

MAY 1, 2024

Introduction Ever feel stuck when reports demand complex SQL queries? Here’s the perfect solution: combining classic SQL skills with the power of AI assistants like ChatGPT and Gemini. Let’s explore 15 examples of using ChatGPT for SQL!

SQL 318

SQL Analytics Analytics AI 318

Analytics Vidhya

JUNE 10, 2024

Introduction In SQL, comparison operators are crucial for querying databases. The SQL Not Equal operator is one of the most used. Whether […] The post Understanding SQL Not Equal Operator appeared first on Analytics Vidhya. They help compare values and filter data based on conditions.

SQL 306

SQL Database Analytics Analytics 306

Analytics Vidhya

JULY 4, 2024

Introduction An index is a unique lookup table in SQL databases that the database search engine can use to expedite data retrieval. See an index as a book’s reference guide; it […] The post What are SQL Indexes? appeared first on Analytics Vidhya.

SQL 306

SQL Database Analytics Analytics 306

KDnuggets

AUGUST 12, 2024

Today, we’re looking for five quality resources that will teach you advanced SQL and do it for free.

SQL 331

SQL 331

KDnuggets

MARCH 5, 2024

Looking to learn SQL and databases to level up your data science skills? Learn SQL, database internals, and much more with these free university courses.

SQL 342

SQL Database Data Science 342

Analytics Vidhya

JUNE 13, 2024

In SQL, you work […] The post ROW_NUMBER() Function in SQL appeared first on Analytics Vidhya. The ROW_NUMBER function is similar to appending numbers to the list for each item in the order you jotted them down. This means you can refer to individual entries by their digit instead of going through them again.

SQL 306

SQL Analytics Analytics 306

Analytics Vidhya

JULY 7, 2024

Introduction TCL (Transaction Control Language) commands are crucial in SQL overseeing changes enacted by DML (Data Manipulation Language) statements. TCL […] The post What are the TCL Commands in SQL? This article explores the main TCL commands, their functions, and their practical uses. appeared first on Analytics Vidhya.

SQL 328

SQL Database Administration Database Analytics 328

Analytics Vidhya

JUNE 18, 2024

SQL can help! In this article, we’ll explore how to use SQL queries like JOIN, UNION, etc. Overview Let’s dive […] The post 11 Ways to Merge Tables in SQL appeared first on Analytics Vidhya. Introduction Ever wonder how to get a complete picture of your company from different databases?

SQL 318

SQL Database Analytics Analytics 318

Analytics Vidhya

JUNE 20, 2024

Introduction SQL is an essential tool to know for anybody working with data. In this article, we are going to see one of the fundamentals of SQL, the SELECT statement. It comes with a range of functions that make querying in databases, a breeze.

SQL 317

SQL Database Analytics Analytics 317

Analytics Vidhya

JULY 4, 2024

Introduction If you are a data scientist or analyst, data formatting in SQL is a crucial skill to know. The FORMAT() function in the SQL server helps you customize the appearance of dates, times, numbers, […] The post What is FORMAT() Function in SQL? appeared first on Analytics Vidhya.

SQL 306

SQL Data Scientist Analytics Analytics 306

Analytics Vidhya

JULY 3, 2024

Structured Query Language (SQL) has a function to help you with this. The SQL GRANT command lets you assign specific permissions to different users. This allows you to control how they interact with the […] The post What is Grant Command in SQL? appeared first on Analytics Vidhya.

SQL 306

SQL Database Analytics Analytics 306

Analytics Vidhya

MARCH 8, 2024

Introduction Proficiency with databases and SQL is essential for many job choices in today’s tech-driven world, from ambitious software engineers to fledgling data professionals. These courses offer […] The post Top 5 University Courses to Learn Databases and SQL appeared first on Analytics Vidhya.

SQL 329

SQL Database Analytics Analytics 329

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 326

SQL Azure AWS 326

Analytics Vidhya

AUGUST 1, 2024

One swears by SQL, arguing that its structured queries and robust data management are the backbone of their database. The other is a Python enthusiast, convinced that its versatility and powerful libraries […] The post SQL vs Python: Which Language is Right for You? appeared first on Analytics Vidhya.

SQL 306

SQL Python Database Analytics 306

Analytics Vidhya

SEPTEMBER 18, 2024

Imagine the possibilities – no more complex SQL queries or digging through spreadsheets. Well, with the power of LangChain and its new SQL toolkit, that’s exactly what you can do! Introduction Have you ever wished you could simply chat with your database, asking questions in plain language and getting instant, relevant answers?

SQL 306

SQL Database AI AI 306

Analytics Vidhya

AUGUST 1, 2024

Introduction In Data management, SQL is your trusty sidekick, ready to adapt and evolve alongside your business needs. This article will walk you through the ins and outs of adding columns to an existing table […] The post How to Add a Column in SQL? Ever found yourself needing to tweak your database setup on the fly?

SQL 291

SQL Database Analytics Analytics 291

databricks

MAY 28, 2025

This release brings significant advancements across the board from SQL Apache Spark 4.0 marks a major milestone in the evolution of the Spark analytics engine.

SQL 342

SQL Analytics Analytics 342