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 274

SQL Database Analytics Analytics 274

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 279

SQL Analytics Analytics 279

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 220

SQL Data Warehouse 220

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 252

SQL Analytics Analytics 252

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 308

SQL Database Administration Database Analytics 308

Analytics Vidhya

SEPTEMBER 24, 2024

This is exactly how nested queries in […] The post Nested Queries in SQL appeared first on Analytics Vidhya. To find the right answer, you may need to first look at the smaller books, then use that information to find the larger one.

SQL 229

SQL Analytics Analytics Database 229

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 249

SQL Data Analyst Data Scientist Analytics 249

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 272

SQL Database Analytics Analytics 272

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 279

SQL Database Analytics Analytics 279

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 289

SQL 289

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 278

SQL Data Scientist Analytics Analytics 278

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 276

SQL Analytics Analytics 276

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 278

SQL Database Analytics Analytics 278

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 303

SQL Database Analytics Analytics 303

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 275

SQL Database AI AI 275

Analytics Vidhya

JULY 10, 2024

Introduction Ever felt like your SQL queries could use a bit of a readability boost? Enter SQL aliases. This article will discuss all the use cases of alias clauses, like renaming columns and tables and […] The post How to Use Aliases in SQL? appeared first on Analytics Vidhya.

SQL 270

SQL Analytics Analytics Database 270

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 292

SQL 292

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 307

SQL Database Administration Database Analytics 307

Analytics Vidhya

AUGUST 5, 2024

While people think about an efficient and robust building’s design when they hear an architect’s plan, a schema in SQL is a blueprint into how data in a database will be arranged. It gives the specification on how the data […] The post What is Schema in SQL? appeared first on Analytics Vidhya.

SQL 246

SQL Database Analytics Analytics 246

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 296

SQL Database Analytics Analytics 296

KDnuggets

SEPTEMBER 25, 2024

This tutorial introduces the basics of SQL querying with Google BigQuery. While very similar, BigQuery SQL has some syntax differences with standard SQL, some of which will be highlighted along the post. For those familiar with SQL, adapting to BigQuery should be pretty straightforward.

SQL 221

SQL 221

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 283

SQL Data Analyst Data Engineer Data Engineering 283

Analytics Vidhya

JUNE 21, 2024

Introduction An extensive explanation of SQL Data Manipulation Language (DML) commands is given in this article. DML commands are essential for managing and changing data in databases.

SQL 285

SQL Database Analytics Analytics 285

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 280

SQL Database Analytics Analytics 280

Analytics Vidhya

SEPTEMBER 26, 2024

Understanding how to effectively handle NULL values […] The post Handling NULL Values in SQL appeared first on Analytics Vidhya. Imagine you’re analyzing a sales database, and some entries lack customer feedback or order quantities.

SQL 212

SQL Database Analytics Analytics 212

Analytics Vidhya

JANUARY 17, 2024

Introduction Structured Query Language (SQL) is a powerful tool for managing and manipulating relational databases. In this blog post, we’ll delve into the intricacies of the SQL DATEDIFF function, exploring its syntax, use cases, and […] The post SQL DATEDIFF function appeared first on Analytics Vidhya.

SQL 265

SQL Database Analytics Analytics 265

Analytics Vidhya

JULY 5, 2024

SQL’s DESCRIBE (or DESC in some database systems) command gives you to become a data detective, peering into the internal makeup of your tables and extracting valuable information. DESCRIBE is a non-destructive statement used to […] The post SQL DESCRIBE: Unveiling the Secrets of Your Tables appeared first on Analytics Vidhya.

SQL 310

SQL Database Analytics Analytics 310

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 287

SQL Analytics Analytics AI 287

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 267

SQL Database Analytics Analytics 267

KDnuggets

JUNE 10, 2024

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

SQL 323

SQL Database 323

Analytics Vidhya

JUNE 13, 2024

This guide explains what `DENSE_RANK()` is, how it operates, and when to use it effectively […] The post Understanding DENSE_RANK in SQL appeared first on Analytics Vidhya. One ranking function called `DENSE_RANK()` is useful because it assigns ranks to rows without leaving any empty spaces or gaps.

SQL 282

SQL Database Analytics Analytics 282

Analytics Vidhya

JANUARY 17, 2024

Introduction Structured Query Language (SQL) is the backbone of relational database management systems, empowering users to interact with and retrieve information from databases. This is where the ORDER BY clause in SQL […] The post ORDER BY Clause in SQL appeared first on Analytics Vidhya.

SQL 296

SQL Database Analytics Analytics 296

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 330

Data Scientist SQL Data Science Python 330

Analytics Vidhya

JANUARY 16, 2024

Introduction Structured Query Language (SQL) is a cornerstone in database management, offering robust functions to manipulate and retrieve data. Among these functions, the COALESCE function in SQL emerges as a powerful tool for handling NULL values efficiently.

SQL 263

SQL Database Analytics Analytics 263

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 288

SQL Python Database Analytics 288

Analytics Vidhya

JUNE 23, 2024

Introduction Data Control Language (DCL) commands are fundamental in SQL for managing access and permissions within the database. Overview Applications of DCL Commands Let’s start […] The post What are SQL DCL(Data Control Language) Commands? appeared first on Analytics Vidhya.

SQL 293

SQL Database Administration Database Analytics 293

Analytics Vidhya

JANUARY 17, 2024

Introduction Structured Query Language (SQL) is the cornerstone of database management, enabling users to interact with and manipulate data efficiently. One of the fundamental functions in SQL is COUNT, a powerful tool that provides valuable insights into the size of datasets.

SQL 267

SQL Database Analytics Analytics 267