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 311

SQL Data Warehouse 311

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 286

SQL Database Analytics Analytics 286

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 317

SQL Database Administration Database Analytics 317

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 266

SQL Analytics Analytics 266

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 290

SQL Analytics Analytics 290

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 290

SQL Database Analytics Analytics 290

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 285

SQL Database Analytics Analytics 285

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 262

SQL Data Analyst Data Scientist Analytics 262

Analytics Vidhya

JULY 29, 2024

Introduction The CONCAT function in Structured Query Language (SQL) connects or concatenates two or more strings into a single string. Furthermore, concatenating strings can be done with the + operator in certain SQL dialects. The […] The post What is CONCAT in SQL? The […] The post What is CONCAT in SQL?

SQL 263

SQL Database Analytics Analytics 263

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 288

SQL Analytics Analytics 288

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 289

SQL Data Scientist Analytics Analytics 289

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 289

SQL Database Analytics Analytics 289

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 315

SQL Database Analytics Analytics 315

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 280

SQL Analytics Analytics Database 280

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 320

SQL 320

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 306

SQL Database 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 317

SQL Database Administration Database Analytics 317

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 259

SQL Database Analytics Analytics 259

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 306

SQL 306

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 242

SQL Analytics Analytics Database 242

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 295

SQL Data Analyst Data Engineering Data Engineer 295

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 287

SQL Database AI AI 287

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 295

SQL Database Analytics Analytics 295

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 278

SQL Database Analytics Analytics 278

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 292

SQL Database Analytics Analytics 292

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 299

SQL Analytics Analytics AI 299

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 315

SQL Database Analytics Analytics 315

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 306

SQL Database Analytics Analytics 306

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 276

SQL Database Analytics Analytics 276

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 277

SQL Database Analytics Analytics 277

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 293

SQL Database Analytics 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 280

SQL Database Analytics Analytics 280

Analytics Vidhya

JANUARY 10, 2024

Introduction The ON clause in SQL needs to be more understood and utilized. It plays a crucial role in SQL joins and can significantly impact the performance and accuracy of your queries. This comprehensive guide delves into the intricacies of […] The post ON Clause in SQL appeared first on Analytics Vidhya.

SQL 278

SQL Analytics Analytics Python 278

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 300

SQL Database Administration Database Analytics 300

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 297

SQL Python Database Analytics 297

KDnuggets

JUNE 10, 2024

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

SQL 339

SQL Database 339

KDnuggets

NOVEMBER 1, 2024

This is a simple guide for lazy people who want to learn SQL with minimal effort.

SQL 319

SQL 319