Analytics Vidhya

MAY 28, 2022

Introduction on SQL Server Before going to our main concept, we must first learn about what are functions and then study the details of scalar functions in SQL Server. Function in SQL Server is a set of T-SQL statements that are used to […]. This article was published as a part of the Data Science Blogathon.

SQL 396

SQL Data Science Analytics Analytics 396

Analytics Vidhya

JUNE 25, 2024

Introduction If you are someone who handles databases at work, I’m sure you use SQL a lot. Doesn’t SQL make it a breeze to work with and edit the contents of large databases?

SQL 315

SQL Data Analyst Database Data Scientist 315

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

JUNE 3, 2022

Introduction to SQL Clauses SQL clauses like HAVING and WHERE both serve to filter data based on a set of conditions. The difference between the functionality of HAVING and WHERE as SQL clauses are generally asked for in SQL interview questions. In this article, […].

SQL 357

SQL Data Science Analytics Analytics 357

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

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 328

SQL Database Analytics Analytics 328

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

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

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

Analytics Vidhya

MAY 29, 2022

Introduction on SQL Join The data required for a data-analysis task usually comes from multiple sources. SQL JOINs are the tools to bring this data together. SQL JOIN is the best tool to combine data from multiple resources! The post 3 Most Frequently Asked SQL Join Interview Questions? In this article, I am […].

SQL 370

SQL Data Analysis Data Analysis Data Science 370

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? Further in […] The post What are the SQL Alternate Keys? appeared first on Analytics Vidhya. 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 4, 2022

Introduction on SQL Server SQL Server is an RDBMS developed and maintained by Microsoft. Triggers are used in SQL Server to respond to an event in the database server. The post Understanding DML Triggers in SQL Server appeared first on Analytics Vidhya. A trigger is a […].

SQL 348

SQL Database Data Science Analytics 348

Analytics Vidhya

JANUARY 13, 2022

HQL or Hive Query Language is a simple yet powerful SQL like querying language which provides the users with the ability to perform data analytics on big datasets. Owing to its syntax similarity to SQL, HQL has been widely adopted among data engineers and can be learned quickly by people new to the world of […].

Analytics 352

Analytics Analytics SQL Data Engineering 352

Analytics Vidhya

MAY 22, 2021

The post How to Fetch Data using API and SQL databases! appeared first on Analytics Vidhya. ArticleVideo Book This article was published as a part of the Data Science Blogathon Introduction Getting complete and high-performance data is not always the case.

SQL 400

SQL Database Data Science Analytics 400

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. […] The post Understanding SQL INTERSECT Operator appeared first on Analytics Vidhya.

SQL 302

SQL Analytics Analytics 302

Analytics Vidhya

NOVEMBER 29, 2021

SQL stands for Structured Query Language which is used to deal with Relational Databases to query from and manipulate databases. The post A Complete Beginner-Friendly Guide to SQL for Data Science appeared first on Analytics Vidhya. This article was published as a part of the Data Science Blogathon.

Data Science 393

Data Science SQL Database Analytics 393

KDnuggets

JULY 15, 2022

Machine learning, big data analytics or AI may steal the headlines, but if you want to hone a smart, strategic skill that can elevate your career, look no further than SQL.

SQL 399

SQL Big Data Analytics Big Data Analytics Big Data 399

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 301

SQL Data Analyst Data Scientist Analytics 301

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

MAY 14, 2022

Introduction to SQL SQL stands for the Structure Query Language. SQL became a standard of the […]. The post An Introduction to SQL Commands for Beginners appeared first on Analytics Vidhya. It was developed in the year 1970 at IBM.

SQL 348

SQL Database Data Science Analytics 348

Analytics Vidhya

MAY 22, 2022

Introduction on Aggregate functions in SQL Before going to our main concept, we must first learn- What are function and type? Function in SQL is a set of SQL statements that performs a specific task. SQL provides a variety of functions which are […].

SQL 361

SQL Data Science Analytics Analytics 361

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

JUNE 28, 2022

Introduction SQL stands for Structured Query Language. SQL skills are highly preferred and required as it’s used by many organizations in a large variety of software applications. The post 20 SQL Coding Interview Questions appeared first on Analytics Vidhya. So as a […].

SQL 337

SQL Data Science Database Analytics 337

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? appeared first on Analytics Vidhya. Learning Objectives What are TCL Commands?

SQL 328

SQL Database Administration Database Analytics 328

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

Analytics Vidhya

MAY 30, 2022

Introduction SQL, Structured Query Language, is a query language. SQL gets used by data scientists, analysts, web developers, and other tech geeks for data […]. The post One with SQL-Joins, Procedures, and Function appeared first on Analytics Vidhya.

SQL 351

SQL Data Scientist Database Data Science 351

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

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

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 152

SQL Database Python AI 152

KDnuggets

JULY 26, 2022

The 5 hardest things Josh Berry, a 15 year analytics professional, experienced while switching from Python to SQL. Offering examples, SQL code, and a resource to customize the SQL to your own project.

SQL 351

SQL Python Analytics Analytics 351

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 314

SQL Database Analytics Analytics 314

Analytics Vidhya

JULY 30, 2022

And stored data in these databases can be accessed by a query language called “sequel” or SQL. The post A brief introduction to SQL Alchemy appeared first on Analytics Vidhya. Introduction The structured data we generally deal with gets stored in a tabular format in relational databases. But, it is […].

SQL 348

SQL Database Data Science Analytics 348

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

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