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.

SQL 150

SQL Data Science Python Data 150

KDnuggets

JUNE 10, 2024

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

SQL 149

SQL Database Project 149

Data Engineering Podcast

FEBRUARY 4, 2024

Summary Stream processing systems have long been built with a code-first design, adding SQL as a layer on top of the existing framework. There are numerous stream processing engines, near-real-time database engines, streaming SQL systems, etc. Can you describe what RisingWave is and the story behind it?

SQL 173

SQL Data Lake High Quality Data Data Pipeline 173

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 145

SQL Data 145

KDnuggets

JUNE 12, 2024

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

SQL 158

SQL Python Database Data 158

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 149

SQL Database Data Science Data 149

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 144

SQL Datasets Management IT 144

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 144

SQL Data Science Data 144

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 148

SQL Data Management Management Data 148

KDnuggets

AUGUST 12, 2024

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

SQL 149

SQL IT 149

KDnuggets

APRIL 8, 2024

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

SQL 144

SQL Data Science Data 144

KDnuggets

OCTOBER 20, 2023

Want to learn SQL the Harvard way? Start learning today with CS50 SQL, a free course on databases with SQL from Harvard.

SQL 149

SQL Database 149

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 130

SQL Programming Data Warehouse Data 130

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 154

SQL Data Science Certification Data 154

KDnuggets

NOVEMBER 1, 2024

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

SQL 145

SQL 145

KDnuggets

NOVEMBER 12, 2024

In this tutorial, we’ll explore when and how SQL functionality can be integrated within the Pandas framework, as well as its limitations.

SQL 147

SQL Data Analysis Data IT 147

KDnuggets

JANUARY 26, 2024

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

SQL 141

SQL Coding 141

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 131

SQL Data Warehouse Data 131

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 145

SQL 145

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 128

SQL 128

KDnuggets

OCTOBER 12, 2023

SQL is the essential data science language due to its universal database accessibility, efficient data cleaning capabilities, seamless integration with other languages, and requirement for most data science jobs.

Data Science 155

Data Science SQL Database Data 155

KDnuggets

JANUARY 5, 2024

Want to clean your messy data so you can start analyzing it with SQL? Learn how to handle missing values, duplicate records, outliers, and much more.

SQL 144

SQL Data IT 144

KDnuggets

SEPTEMBER 25, 2024

This tutorial introduces the basics of SQL querying with Google BigQuery. While very similar, BigQuery SQL has some syntax differences with standard SQL, some of which will be highlighted along the post. For those familiar with SQL, adapting to BigQuery should be pretty straightforward.

SQL 130

SQL 130

KDnuggets

JANUARY 19, 2024

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

SQL 129

SQL 129

KDnuggets

JANUARY 30, 2024

Complex queries seem intimidating, but this guide gives you insight into how to work more easily with SQL queries.

SQL 138

SQL 138

databricks

MAY 18, 2023

Today, we are thrilled to announce that serverless compute for Databricks SQL is Generally Available on AWS and Azure! Databricks SQL (DB SQL).

SQL 139

SQL AWS 139

KDnuggets

NOVEMBER 2, 2023

Unlock the Power of SQL in Data Visualization: Master the Art of Preparing Data for Impactful Charts and Graphs.

SQL 152

SQL Data 152

Start Data Engineering

MAY 21, 2024

Introduction 2. Enabling Stakeholder data access with RAGs 3.1. Set up 3.1.1. Pre-requisite 3.1.2. Demo 3.1.3. Key terminology 3.2. Loading: Read raw data and convert them into LlamaIndex data structures 3.2.1. Read data from structured and unstructured sources 3.2.2. Transform data into LlamaIndex data structures 3.3.

Accessibility 213

Accessibility Accessible SQL Raw Data 213

KDnuggets

JANUARY 15, 2024

Learn the generic scenarios and techniques of grouping and aggregating data, partitioning and ranking data in SQL, which will be very helpful in reporting requirements.

SQL 148

SQL Aggregated Data Data Science Data 148

databricks

AUGUST 13, 2024

Databricks SQL Serverless is now Generally Available on Google Cloud Platform (GCP)! SQL Serverless is available in 7 GCP regions and 40+ regions across AWS, Azure and GCP.

Google Cloud 131

Google Cloud SQL Cloud AWS 131

KDnuggets

NOVEMBER 20, 2024

Can SQL be used for advanced data manipulation in data science? It sure can with these seven techniques.

Data Science 137

Data Science SQL Data IT 137

KDnuggets

NOVEMBER 8, 2023

This week on KDnuggets: Dive into KDnuggets Back to Basics: Getting Started in 5 Steps series to help you master Python, SQL, Scikit-learn, PyTorch, and Google Cloud Platform. Unlock the Power of SQL in Data Visualization: Master the Art of Preparing Data for Impactful Charts and Graphs. • And much, much more!

Google Cloud 137

Google Cloud SQL Python Cloud 137

databricks

JULY 31, 2024

We’re excited to announce the Public Preview of LakeFlow Connect for SQL Server, Salesforce, and Workday. These ingestion connectors enable simple and efficient.

SQL 135

SQL Data Data Engineer Data Engineering 135

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 119

SQL 119

databricks

JANUARY 18, 2024

This is part 1 of a blog series where we look back at the major areas of progress for Databricks SQL in 2023.

SQL 138

SQL 138

Start Data Engineering

OCTOBER 17, 2024

Introduction Setup SQL tips 1. Handy functions for common data processing scenarios 1.1. Need to filter on WINDOW function without CTE/Subquery use QUALIFY 1.2. Need the first/last row in a partition, use DISTINCT ON 1.3. STRUCT data types are sorted based on their keys from left to right 1.4.

SQL 130

SQL Data Engineer Data Engineering Engineering 130

Seattle Data Guy

FEBRUARY 26, 2024

SQL Server Integration Services (SSIS) comes with a lot of functionality useful for extracting, transforming, and loading data. It can also play important roles in application development and other projects. But SSIS is far from the only platform that can provide these services.

SQL 130

SQL Project Data Consulting 130