Analytics Vidhya

FEBRUARY 2, 2023

Introduction SQL injection is an attack in which a malicious user can insert arbitrary SQL code into a web application’s query, allowing them to gain unauthorized access to a database. It occurs when user input is […] The post SQL Injection: The Cyber Attack Hiding in Your Database appeared first on Analytics Vidhya.

Database 204

Database SQL Coding Accessible 204

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

Confessions of a Data Guy

MAY 7, 2023

I mean you have a problem if you could use Polars Python, and you find yourself using […] The post Polars – Laziness and SQL Context. It’s gotten so bad, I’ve started to use it in my Rust code on the side, Polars that is. appeared first on Confessions of a Data Guy.

SQL 182

SQL Python Coding IT 182

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 122

SQL Data 122

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

Confessions of a Data Guy

FEBRUARY 21, 2024

New SQL Practice Problems I’m trying something new. SQL Practice Problems. stars later […] The post New SQL Practice Problems appeared first on Confessions of a Data Guy. stars later […] The post New SQL Practice Problems appeared first on Confessions of a Data Guy. So I came up with a solution.

SQL 100

SQL Data Engineering Data Engineer Engineering 100

Striim

NOVEMBER 19, 2024

SQL2Fabric Mirroring is a new fully managed service offered by Striim to mirror on premise SQL Databases. It’s a collaborative service between Striim and Microsoft based on Fabric Open Mirroring that enables real-time data replication from on-premise SQL Server databases to Azure Fabric OneLake. Establish a secure connection (e.g.,

SQL 52

SQL Database Data Warehouse Data Pipeline 52

Waitingforcode

APRIL 15, 2023

But this term also applies to other modules including Apache Spark SQL, so batch processing! - journey with Apache Spark I've met the "checkpointing" world in the context of Structured Streaming mostly.

SQL 130

SQL Process 130

KDnuggets

NOVEMBER 1, 2024

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

SQL 127

SQL 127

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 138

SQL Data Science Python Data 138

KDnuggets

JUNE 10, 2024

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

SQL 135

SQL Database Project 135

KDnuggets

NOVEMBER 20, 2024

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

Data Science 82

Data Science SQL Data IT 82

databricks

NOVEMBER 7, 2024

We are excited to share the latest features and performance improvements that make Databricks SQL simpler, faster, and more affordable than ever. Databricks.

SQL 76

SQL 76

databricks

NOVEMBER 5, 2024

We’re excited to announce that materialized views (MVs) and streaming tables (STs) are now Generally Available in Databricks SQL on AWS and Azure.

SQL 114

SQL AWS Engineering 114

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 93

SQL 93

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 123

Google Cloud SQL Cloud AWS 123

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 140

SQL Database Data Science Data 140

Hevo

DECEMBER 27, 2023

Integrating APIs with SQL Server not only streamlines data flow but also enhances the functionality and versatility of SQL Server, providing a dynamic platform for real-time data updates and interactions.

SQL 98

SQL Data Data Integration 98

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 119

SQL Programming Data Warehouse Data 119

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.

NoSQL 160

NoSQL SQL Database Design Database 160

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 149

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

SQL Datasets Management IT 110

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 141

SQL Database 141

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

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 131

SQL Data Data Engineering Data Engineer 131

KDnuggets

JUNE 12, 2024

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

SQL 139

SQL Python Database Data 139

KDnuggets

AUGUST 12, 2024

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

SQL 128

SQL IT 128

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 108

SQL Programming Language Programming Data 108

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 154

SQL Data Science Data Engineering 154

Confessions of a Data Guy

DECEMBER 29, 2023

The post SQL Bad, Reddit Mad appeared first on Confessions of a Data Guy.

SQL 100

SQL Data Data Engineering Data Engineer 100

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 148

SQL Data Science Data 148

Cloudera

FEBRUARY 21, 2023

SQL Stream Builder (SSB) is a versatile platform for data analytics using SQL as a part of Cloudera Streaming Analytics, built on top of Apache Flink. It enables users to easily write, run, and manage real-time continuous SQL queries on stream data and a smooth user experience.

SQL 110

SQL Kafka Raw Data Data 110

KDnuggets

JUNE 27, 2022

If your raw data is in a SQL-based data lake, why spend the time and money to export the data into a new platform for data prep?

Data Preparation 160

Data Preparation SQL Raw Data Data Lake 160

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 116

SQL Data Management Management Data 116

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 159

SQL Database Coding IT 159

KDnuggets

APRIL 5, 2022

In this article, we’ll go over SQL window functions and how to use them when writing SQL queries.

SQL 140

SQL 140

Confessions of a Data Guy

DECEMBER 21, 2023

Thinking about and contemplating life and data engineering … something flitted across my […] The post Datafusion SQL CLI – Look Ma, I made a new ETL tool. A few days ago I was lying by the river next to a fire, with the cold air blowing on my face and the eagles soaring above. appeared first on Confessions of a Data Guy.

ETL Tools 113

ETL Tools SQL Data Engineering Data Engineer 113