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 376

Data Scientist SQL Data Science Python 376

Analytics Vidhya

OCTOBER 10, 2022

Likewise, interviewers are also getting smarter, now, they are no longer interested in knowing what SQL is, what […]. The post Top 10 Interview Queries on SQL appeared first on Analytics Vidhya. Nowadays, everyone is more interested in implementing practical knowledge than notebook theories.

SQL 394

SQL Data Science Analytics Analytics 394

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

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

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

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 374

SQL Database Data Science 374

KDnuggets

JUNE 12, 2024

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

SQL 395

SQL Python Database 395

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

SQL Database 399

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

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

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

OCTOBER 4, 2023

Want to query your pandas dataframes using SQL? Learn how to do so using the Python library Pandasql.

SQL 382

SQL Python 382

KDnuggets

MARCH 6, 2024

Want to become an SQL expert? Check out these free courses to learn and hone your SQL skills for data science.

SQL 361

SQL Data Science 361

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 388

SQL Data Science 388

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

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 318

SQL Database Analytics Analytics 318

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

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

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

KDnuggets

JUNE 26, 2024

Learning SQL in 2024 is essential as it remains the most in-demand skill for data professionals, enabling efficient management and analysis of large datasets.

SQL 360

SQL 360

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 304

SQL Analytics Analytics Python 304

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 305

SQL Database Analytics Analytics 305

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 376

SQL Data Science 376

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

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 314

SQL Database Analytics Analytics 314

KDnuggets

SEPTEMBER 9, 2023

This comprehensive SQL tutorial covers everything from setting up your SQL environment to mastering advanced concepts like joins, subqueries, and optimizing query performance. With step-by-step examples, this guide is perfect for beginners looking to enhance their data management skills.

SQL 371

SQL 371

KDnuggets

AUGUST 12, 2024

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

SQL 372

SQL 372

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

KDnuggets

APRIL 8, 2024

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

SQL 361

SQL Data Science 361

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

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 364

SQL Python Analytics Analytics 364

KDnuggets

MARCH 13, 2024

If you are a data scientist who works with large amounts of data and hasn’t learned SQL yet - now might be the time.

SQL 386

SQL Data Science Data Scientist 386

KDnuggets

NOVEMBER 1, 2024

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

SQL 364

SQL 364

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