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 113

SQL Datasets Management IT 113

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

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

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

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

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

JUNE 12, 2024

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

SQL 148

SQL Python Database Data 148

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 135

SQL Database Data Science Data 135

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

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

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

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 134

SQL Database 134

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 96

SQL Programming Data Warehouse Data 96

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 139

SQL Data 139

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 118

SQL Data Management Management Data 118

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 122

SQL Data Science Data 122

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

APRIL 8, 2024

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

SQL 125

SQL Data Science Data 125

Hevo

JULY 3, 2024

Databricks SQL is an efficient platform for querying and analyzing large datasets. Its SQL editor, interactive dashboards, and robust BI tool integration features can help you streamline data exploration and reporting.

SQL 52

SQL BI Datasets Management 52

Start Data Engineering

JULY 1, 2024

Introduction 2. Code is an interface to the execution engine 3. How to choose the execution engine and the coding interface 3.1. Chose execution engine based on your workload 3.1.1. Types of execution engine 3.1.2. Criteria to chose your execution engine 3.2. Chose coding interface for people who will maintain the pipeline 3.2.1.

SQL 130

SQL Python Coding Engineering 130

KDnuggets

OCTOBER 4, 2023

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

SQL 127

SQL Python 127

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 143

Data Science SQL Database Data 143

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 147

SQL Data Science Data Engineering 147

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 124

SQL 124

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 137

SQL Data Science Data 137

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

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

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 130

SQL Data Science Certification Data 130

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 158

SQL Database Coding IT 158

Knowledge Hut

APRIL 24, 2024

To understand SQL, you must first understand DBMS (database management systems) and databases in general. If interested in joining some training, learn more about SQL through MySQL Training. Below is the comprehensive version of SQL cheat sheet for interview for quick revision. Let’s get into this.

SQL 52

SQL MySQL Database Relational Database 52

KDnuggets

APRIL 25, 2023

And how to use this amazing tool to enhance our SQL skills.

SQL 160

SQL 160

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.

Accessible 214

Accessible Accessibility SQL Raw Data 214

KDnuggets

APRIL 5, 2022

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

SQL 129

SQL 129

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 90

SQL 90

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 109

Google Cloud SQL Python Cloud 109