SQL - Data Engineering Digest

How to Normalize Relational Databases With SQL Code?

Analytics Vidhya

FEBRUARY 27, 2023

So, we are […] The post How to Normalize Relational Databases With SQL Code? If a corrupted, unorganized, or redundant database is used, the results of the analysis may become inconsistent and highly misleading. appeared first on Analytics Vidhya.

Relational Database

Relational Database SQL Database Coding

Step-by-Step Roadmap to Learn SQL in 2023

Analytics Vidhya

FEBRUARY 28, 2023

SQL is widely used in the field of data science and is considered an essential skill to have if you work with data. After being introduced in the 70s, it has become the standard querying language for relational databases. […] The post Step-by-Step Roadmap to Learn SQL in 2023 appeared first on Analytics Vidhya.

SQL

SQL Relational Database Data Science Database

SQL Injection: The Cyber Attack Hiding in Your Database

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.

SQL

SQL Database Coding Data

Polars – Laziness and SQL Context.

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

SQL Python Coding Data

Spark SQL checkpoints

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

SQL Process

Getting Started with SQL in 5 Steps

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

SQL Data Management Data Management

Acing the Data Engineering SQL Interview

Medium Data Engineering

SEPTEMBER 11, 2023

During an SQL coding screen in a data engineer interview, you can typically expect to be presented with real-world scenarios or problems… Continue reading on Medium »

Data Engineering

Data Engineering Data Engineer SQL Engineering

Data Engineering Fundamentals: SQL, Python, PySpark

Medium Data Engineering

OCTOBER 2, 2023

As part of this course, you will learn all the Data Engineering Essentials related to building Data Pipelines using SQL, Python as Hadoop… Continue reading on Medium »

Data Engineering

Data Engineering Data Engineer SQL Python

7 Best Platforms to Practice SQL

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

SQL Data

SQL Challenge

Medium Data Engineering

SEPTEMBER 19, 2023

- `order_id` (int) - `order_date` (date) - `product_id` (int) - `quantity_sold` (int) - `revenue` (decimal) Your task is to write an SQL query that calculates the monthly total revenue and the…

SQL

SQL Data Engineering Data Engineer Data Science

Announcing the General Availability of Databricks SQL Serverless !

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

SQL AWS

SQL vs NoSQL: 7 Key Takeaways

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

NoSQL SQL Database Design Database

SQL Interviews Preparations Material Resources

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

SQL Programming Language Programming Data

SQL Streambuilder Data Transformations

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

SQL Kafka Data Raw Data

SQL JOINS

Medium Data Engineering

SEPTEMBER 4, 2023

SQL query writing involves working with multiple tables at a time to fetch and analyze the data and get the desire output. Continue reading on Medium »

SQL

SQL Data Data Engineering Data Engineer

What’s new with Databricks SQL?

databricks

AUGUST 10, 2023

At this year's Data+AI Summit, Databricks SQL continued to push the boundaries of what a data warehouse can be, leveraging AI across the.

SQL

SQL Data Warehouse Data

4 Useful Intermediate SQL Queries for Data Science

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

SQL Data Science Data Engineering

Using SQL to Understand Data Science Career Trends

KDnuggets

SEPTEMBER 25, 2023

Reveal the Secrets of the Data Science Job Market with SQL.

SQL

SQL Data Science Data

??????????? ???? SQL ??? ????-?????????

Medium Data Engineering

AUGUST 10, 2023

Дата-инженер контролирует и анализирует большие наборы данных (..)

SQL

SQL Programming Data Analysis Data Engineering

PostgreSQL on Google Cloud SQL to SQL Server: 2 Easy Methods to Load Data

Hevo

SEPTEMBER 22, 2023

Migrating data from Google Cloud PostgreSQL to SQL Server is a strategic move that addresses various business needs. Firstly, this migration enables seamless integration within the Microsoft ecosystem, facilitating efficient data sharing and management across platforms.

PostgreSQL

PostgreSQL SQL Google Cloud Cloud

Optimizing Data Storage: Exploring Data Types and Normalization in SQL

KDnuggets

SEPTEMBER 22, 2023

Learn about the data types and normalization techniques in SQL, which will be very helpful for optimizing your data storage.

Data Storage

Data Storage SQL Data

Using ChatGPT to Learn SQL

KDnuggets

APRIL 25, 2023

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

SQL

Exploring SQL Statement Execution with Databricks REST API

Medium Data Engineering

OCTOBER 1, 2023

During the past week, there was a need to explore the execution of SQL statements on Databricks through the API to facilitate data… Continue reading on Medium »

SQL

SQL Data Data Analysis Data Engineering

How to Optimize SQL Queries for Faster Data Retrieval

KDnuggets

JUNE 12, 2023

Today, we’ll talk about why SQL query optimization is important and which techniques can be used to optimize it.

SQL

SQL Data IT

What Are DDL Commands in SQL?

U-Next

MARCH 12, 2023

Introduction SQL stands for Structured Query Language and is used to store, alter, and retrieve data from a database server. DDL commands in SQL define database objects. When we save information in a database, we must construct tables and describe their layout. This article will cover the most important DDL commands in SQL.

SQL

SQL Database Datasets Data

Exciting SQL Trick: Old vs. New Code!

Medium Data Engineering

SEPTEMBER 15, 2023

Are you ready to level up your SQL skills? Today, I want to share a powerful SQL trick that showcases the evolution of code and the magic of modern SQL! ? The Challenge: Suppose we have a table…

SQL

SQL Coding Data Engineering Data Engineer

SQL Notes for Professionals: The Free eBook Review

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

SQL Database Coding IT

Data Preparation with SQL Cheatsheet

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?

SQL

SQL Data Preparation Data Lake Raw Data

SQL for Data Analysis

Medium Data Engineering

AUGUST 22, 2023

SQL (Structured Query Language) merupakan bahasa pemrograman untuk menyimpan dan memproses informasi dalam database relasional. Database… Continue reading on Medium »

SQL

SQL Data Analysis Data Database

Mastering SQL: Your guide to Database Domination What is SQL?

Medium Data Engineering

JULY 10, 2023

What is SQL? SQL (Structured Query Language) is a programming language designed for managing and manipulating relational databases. It provides a standardized way to interact with databases, enabling…

SQL

SQL Database Relational Database Programming Language

“The Power of SQL in Driving Business Success”

U-Next

MARCH 8, 2023

For more than 40 years, relational databases have been managed and modified using the programming language SQL (Structured Query Language). Efficient Data Management: The capacity of SQL to effectively manage vast amounts of data is one of its greatest advantages.

SQL

SQL Relational Database Database Data Analysis

SQL Date functions

Medium Data Engineering

AUGUST 26, 2023

In SQL, date functions are used to manipulate and work with date and time values stored in the database. Continue reading on Medium »

SQL

SQL Database PostgreSQL MySQL

Getting Started with SQL Cheatsheet

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

SQL Data Science Data

SQL Interview Patterns You Must Know for Data Engineers

Medium Data Engineering

SEPTEMBER 30, 2023

SQL interview questions often diverge from typical daily tasks, focusing on deeper comprehension and mastery of the language’s intricacies… Continue reading on Medium »

SQL

SQL Data Engineering Data Engineer Engineering

Understanding Trino Architecture: Unleashing the Power of Distributed SQL Queries

Medium Data Engineering

SEPTEMBER 30, 2023

Trino is a distributed SQL query engine designed for high-performance, ad-hoc analytics, and data federation Continue reading on Medium »

SQL

SQL Architecture Engineering Data

24 SQL Questions You Might See on Your Next Interview

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

The 5 Hardest Things to Do in SQL

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

SQL Python Coding Project

New SQL Capabilities in Snowflake ??

Medium Data Engineering

JULY 29, 2023

Snowflake has introduced innovative SQL techniques that will significantly simplify tasks for coders. Over the past three decades, SQL has… Continue reading on Medium »

SQL

SQL Data Engineering Data Engineer Data Science

Your Guide to Flink SQL: An In-Depth Exploration

Confluent

SEPTEMBER 12, 2023

Get an in-depth introduction to Flink SQL. Learn how it relates to other APIs, its built-in functions and operations, which queries to try first, and see syntax examples.

SQL

SQL IT

ChatGPT Prompts for SQL

Medium Data Engineering

JULY 20, 2023

Useful prompts to speed up development and improve efficiency of SQL queries Continue reading on Artificial Corner »

SQL

SQL Data Engineering Data Engineer Data Science

SQL 101

Medium Data Engineering

APRIL 1, 2023

Looking to learn SQL and wondering how to get started? In this blog post, I’ll walk you through the basics of SQL commands. and their… Continue reading on Medium »

SQL

SQL Data Engineering Data Engineer Engineering

Getting Started with PySpark, Kafka, SQL, and AI

Medium Data Engineering

SEPTEMBER 17, 2023

How to run SQL queries over Kafka in seconds? With PySpark, we get a system to run ad-hoc analysis locally and any SQL queries to explore… Continue reading on Conduktor »

Kafka

Kafka SQL Systems Data Engineering

Top 5 SQL Interview Questions With Implementation

Top 5 SQL Interview Questions

Trending Sources

How to Normalize Relational Databases With SQL Code?

Step-by-Step Roadmap to Learn SQL in 2023

SQL Injection: The Cyber Attack Hiding in Your Database

Polars – Laziness and SQL Context.

Spark SQL checkpoints

Getting Started with SQL in 5 Steps

Acing the Data Engineering SQL Interview

Data Engineering Fundamentals: SQL, Python, PySpark

7 Best Platforms to Practice SQL

SQL Challenge

Announcing the General Availability of Databricks SQL Serverless !

SQL vs NoSQL: 7 Key Takeaways

SQL Interviews Preparations Material Resources

SQL Streambuilder Data Transformations

SQL JOINS

What’s new with Databricks SQL?

4 Useful Intermediate SQL Queries for Data Science

Using SQL to Understand Data Science Career Trends

??????????? ???? SQL ??? ????-?????????

PostgreSQL on Google Cloud SQL to SQL Server: 2 Easy Methods to Load Data

Optimizing Data Storage: Exploring Data Types and Normalization in SQL

Using ChatGPT to Learn SQL

Exploring SQL Statement Execution with Databricks REST API

How to Optimize SQL Queries for Faster Data Retrieval

What Are DDL Commands in SQL?

Exciting SQL Trick: Old vs. New Code!

SQL Notes for Professionals: The Free eBook Review

Data Preparation with SQL Cheatsheet

SQL for Data Analysis

Mastering SQL: Your guide to Database Domination What is SQL?

“The Power of SQL in Driving Business Success”

SQL Date functions

Getting Started with SQL Cheatsheet

SQL Interview Patterns You Must Know for Data Engineers

Understanding Trino Architecture: Unleashing the Power of Distributed SQL Queries

24 SQL Questions You Might See on Your Next Interview

The 5 Hardest Things to Do in SQL

New SQL Capabilities in Snowflake ??

Your Guide to Flink SQL: An In-Depth Exploration

ChatGPT Prompts for SQL

SQL 101

Getting Started with PySpark, Kafka, SQL, and AI

Stay Connected