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 338

SQL Database Data Science 338

KDnuggets

APRIL 8, 2024

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

SQL 303

SQL Data Science 303

Analytics Vidhya

JANUARY 18, 2024

Welcome to the SQL Mastery Quiz, where we unravel the complexities of databases and dive deep into the language that empowers data-driven applications – Structured Query Language (SQL)! SQL is the key to unlocking the secrets stored within databases in this digital arena, where data reigns supreme.

SQL 313

SQL Database AI AI 313

Analytics Vidhya

DECEMBER 23, 2023

Introduction Structured Query Language (SQL) is a powerful tool for managing and manipulating relational databases. Whether you are a budding data scientist, a web developer, or someone looking to enhance your database skills, practicing SQL is essential. So, are you a beginner in SQL looking to enhance your skills?

SQL 292

SQL Data Scientist Database Analytics 292

Analytics Vidhya

DECEMBER 21, 2023

Introduction SQL remains the cornerstone of data manipulation and analysis in the digital age. Whether you’re a budding data analyst, a seasoned database administrator, or a developer looking to refine your querying abilities, practicing SQL is pivotal. But where does one turn to refine their SQL skills?

SQL 305

SQL Database Administration Data Analyst Database 305

Analytics Vidhya

FEBRUARY 8, 2024

Introduction In the rapidly evolving field of Natural Language Processing (NLP), one of the most intriguing challenges is converting natural language queries into SQL statements, known as Text2SQL.

SQL 294

SQL Natural Language Processing Data Analysis Data Analysis 294

Analytics Vidhya

JANUARY 10, 2024

Introduction SQL, a robust language for managing relational databases, boasts a compelling feature known as the WITH clause. This blog post will delve into the WITH clause in SQL, unraveling its effective usage to enhance […] The post 5 Easy Ways to Use SQL WITH Clause appeared first on Analytics Vidhya.

SQL 292

SQL Database Analytics Analytics 292

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 302

SQL Data Science 302

databricks

MARCH 29, 2024

Today, we are excited to announce the general availability of Databricks Notebooks on SQL warehouses. Databricks SQL warehouses are SQL-optimized compute that provide.

SQL 259

SQL 259

Analytics Vidhya

OCTOBER 12, 2022

This brings up databases, and SQL and PL/SQL stand […]. The post SQL and PL/SQL – An Unmissable Comparison appeared first on Analytics Vidhya. Data is getting significant and gaining more traction by the day. Hence it is required to store such a large amount of data carefully.

SQL 322

SQL Database Data Science Analytics 322

databricks

JANUARY 31, 2024

Welcome to the blog series covering product advancements in 2023 for Databricks SQL, the serverless data warehouse from Databricks. This is part 2.

SQL 279

SQL Data Warehouse 279

Analytics Vidhya

JANUARY 16, 2024

This is where the SQL LIKE operator comes in handy. Also Read: SQL: A Full […] The post Master the SQL LIKE Operator to Filter Rows in Your Database appeared first on Analytics Vidhya. Introduction Searching for specific patterns within the data is often necessary when working with databases.

SQL 294

SQL Database Analytics Analytics 294

Analytics Vidhya

DECEMBER 6, 2023

Introduction Structured Query Language (SQL) is the backbone of relational database management systems. As we step into 2024, the demand for SQL proficiency continues to rise across various industries, emphasizing the need for professionals to master its concepts thoroughly.

SQL 295

SQL Database Analytics Analytics 295

Analytics Vidhya

JANUARY 2, 2024

Introduction When it comes to working with databases, two commonly used approaches are SQL and Object-Relational Mapping (ORM). In this article, we will explore the disparities between SQL and ORM, understand their basics, and […] The post What Is the Difference Between SQL and Object Relational Mapping?

SQL 288

SQL Database Analytics Analytics 288

Analytics Vidhya

JULY 29, 2022

Introduction SQL?—?A SQL helps […]. The post SQL Commands for Data Science appeared first on Analytics Vidhya. This article was published as a part of the Data Science Blogathon. A structured query language is a must-know tool for everyone working with datasets.

SQL 392

SQL Data Science Database Analytics 392

Analytics Vidhya

SEPTEMBER 26, 2023

Writing SQL is one task already changing in data science following the AI revolution. We will provide an illustrative example of […] The post Crafting Complex SQL Queries with Generative AI Assistance appeared first on Analytics Vidhya.

SQL 329

SQL AI AI Data Science 329

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 320

SQL Data Science Data Scientist 320

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 291

SQL 291

KDnuggets

FEBRUARY 6, 2024

This article introduced you to the world of ranking functions in SQL. We will cover the basics of how they work, how they're used, and how to avoid common pitfalls.

SQL 308

SQL 308

KDnuggets

SEPTEMBER 5, 2022

People assume that NoSQL is a counterpart to SQL. Instead, it’s a different type of database designed for use-cases where SQL is not ideal. The differences between the two are many, although some are so crucial that they define both databases at their cores.

SQL 400

SQL Database 400

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 348

SQL 348

Machine Learning Mastery

MARCH 1, 2024

In the realm of data analysis, SQL stands as a mighty tool, renowned for its robust capabilities in managing and querying databases. This exploration delves into […] The post Beyond SQL: Transforming Real Estate Data into Actionable Insights with Pandas appeared first on MachineLearningMastery.com.

SQL 251

SQL Data Scientist Database Data Analysis 251

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. This article was published as a part of the Data Science Blogathon.

SQL 345

SQL Data Science Analytics Analytics 345

Analytics Vidhya

JULY 15, 2023

Introduction SQL (Structured Query Language) is a powerful data analysis and manipulation tool, playing a crucial role in drawing valuable insights from large datasets in data science. To enhance SQL skills and gain practical experience, real-world projects are essential.

Data Analysis 271

Data Analysis Data Analysis SQL Data Science 271

Analytics Vidhya

MARCH 7, 2023

CTE is one of the most powerful tools of SQL (Structured Query Language), and it also helps to clean the data. It is the concept of SQL (Structured Query Language) used to simplify coding and help to get the result as quickly as possible.

SQL 305

SQL Analytics Analytics Big Data 305

Analytics Vidhya

APRIL 23, 2022

Introduction In this article, we will be looking for a very common yet very important topic i.e. SQL also pronounced as Ess-cue-ell. So this time I’ll be answering some of the factual questions about SQL which every beginner needs to know before getting […].

SQL 399

SQL Data Engineering Data Engineer Data Engineering 399

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 381

SQL Data Science Analytics Analytics 381

Analytics Vidhya

JANUARY 2, 2024

Introduction SQL (Structured Query Language) is a powerful tool for managing and analyzing data in relational databases. It allows users to retrieve, manipulate, and transform data using a set of standardized commands.

SQL 279

SQL Database Analytics Analytics 279

KDnuggets

FEBRUARY 21, 2023

SQL is a must-known programming language for data people, and many modern jobs have SQL as a prerequisite. Here are material collections to prepare for your SQL interview.

SQL 271

SQL 271

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 368

SQL Data Science 368

KDnuggets

OCTOBER 4, 2023

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

SQL 313

SQL Python 313

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 388

SQL Database Data Science Analytics 388

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. This article was published as a part of the Data Science Blogathon.

SQL 335

SQL Database Data Science Analytics 335

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

KDnuggets

JANUARY 19, 2024

Want to refresh your SQL skills? Bookmark these useful cheat sheets covering SQL basics, joins, window functions, and more.

SQL 227

SQL 227

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. This article was published as a part of the Data Science Blogathon.

SQL 323

SQL Database Data Science Analytics 323

KDnuggets

JANUARY 26, 2024

Learn how to write SQL queries that are not just code but clear, modular, and reusable work.

SQL 300

SQL 300