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

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

KDnuggets

JANUARY 13, 2023

Looking to level up your SQL skills? Here's a list of the best platforms to practice SQL, ace your SQL interviews, and land your dream data role.

SQL 370

SQL 370

Analytics Vidhya

JULY 5, 2022

Introduction This article shows how you can create and manage a Cloud SQL Database on Google Cloud Platform and further connect that database to any web application. The post Managing SQL Database on Google Cloud appeared first on Analytics Vidhya. This tutorial shows how you can join that database with a Django Application.

SQL 390

SQL Database Data Science Analytics 390

KDnuggets

MAY 5, 2022

The free book is a combination of SQL cheat sheets and practical database examples. It provided bite-size information about every SQL function and attribute with coding samples.

SQL 398

SQL Database 398

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

JUNE 10, 2024

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

SQL 362

SQL Database 362

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 366

Data Scientist SQL Data Science Python 366

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

KDnuggets

JUNE 12, 2024

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

SQL 387

SQL Python Database 387

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

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 345

SQL 345

KDnuggets

DECEMBER 6, 2022

SQL is the essential language for developers, engineers, and data professionals. Intermediate knowledge in SQL gives you an edge in your data science career.

SQL 385

SQL Data Science 385

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? 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

KDnuggets

JUNE 28, 2022

Preparing for the SQL job interview can be overwhelming enough. Be smart and focus on preparing the SQL questions that appear most often at the job interview. You don’t need someone telling you that you need to know everything on top of that!

SQL 400

SQL 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. In essence, INTERSECT joins two tables and yields a result set that contains the intersection (common records) of the two tables.

SQL 302

SQL Analytics Analytics 302

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

KDnuggets

AUGUST 3, 2022

Want to get started with SQL? Check out the latest cheatsheet from KDnuggets to get up to speed on the basics of one of the most popular, useful, and in-demand languages in the world of data science.

SQL 367

SQL Data Science 367

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

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

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

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

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 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

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

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 313

SQL Database Analytics Analytics 313

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

KDnuggets

AUGUST 12, 2024

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

SQL 354

SQL 354

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 364

SQL Database Data Science 364

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

KDnuggets

APRIL 8, 2024

Start by learning SQL with these free courses. Are you looking to make a career in data science?

SQL 341

SQL Data Science 341