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. We can use this to steal sensitive information or make unauthorized changes to the data stored in the database.

Database 204

Database SQL Coding Accessible 204

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 108

SQL Data Science Data 108

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 128

SQL Database Data Science Data 128

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 115

SQL Data Science Certification Data 115

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

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

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 130

Data Science SQL Database Data 130

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 111

SQL Programming Data Warehouse Data 111

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 145

SQL Data Science Data Engineering 145

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. What is a data transformation?

SQL 107

SQL Kafka Raw Data Data 107

Hevo

MARCH 28, 2024

Data is your business’s lifeblood. Analyzing business data can help you gain insights to generate reports and create a strategic business plan. If you have large datasets in JSON format, consider migrating them to SQL Server. SQL Server enhances data analysis through its orderly storage structure.

SQL 52

SQL Data Integration Datasets Data Analysis 52

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 96

SQL Data IT 96

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

NOVEMBER 2, 2023

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

SQL 117

SQL Data 117

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. appeared first on Confessions of a Data Guy.

ETL Tools 113

ETL Tools SQL Data Engineering Data Engineer 113

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 104

SQL Aggregated Data Data Science Data 104

Hevo

MARCH 28, 2024

NetSuite is a cloud-based data management tool, while SQL Server is a high-powered relational database management system. If you are trying to optimize your data management procedures by integrating data from NetSuite to SQL Server, you are in the right place.

SQL 52

SQL Relational Database Data Database 52

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 100

Data Storage SQL Data 100

KDnuggets

JULY 15, 2022

Machine learning, big data analytics or AI may steal the headlines, but if you want to hone a smart, strategic skill that can elevate your career, look no further than SQL.

SQL 157

SQL Big Data Machine Learning Data Analytics 157

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 137

SQL Data 137

Hevo

MARCH 28, 2024

Today’s business landscape is becoming increasingly dependent on data. You need to harness the right tools to simplify the data in your databases and unlock its potential. Migrating data from BigQuery to SQL Server is a powerful data integration method.

SQL 52

SQL Data Integration Database Data 52

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 94

Google Cloud SQL Python Cloud 94

KDnuggets

JANUARY 19, 2023

In this article, we will discuss use cases and methods for using ETL (Extract, Transform, Load) and ELT (Extract, Load, Transform) processes along with SQL to integrate data from various sources.

SQL 119

SQL Data Integration Data Process 119

Start Data Engineering

OCTOBER 22, 2021

SQL skills 2.1. Data modeling 2.1.1. Data storage 2.2. Data transformation 2.2.1. Data pipeline 2.4. Data analytics 3. Introduction SQL is the bread and butter of data engineering. Introduction 2. Gathering requirements 2.1.2. Exploration 2.1.3. Modeling 2.1.4. Transformation types 2.2.1.1.

SQL 130

SQL Data Engineering Data Engineer Engineering 130

KDnuggets

NOVEMBER 23, 2021

Sure, we all make mistakes -- which can be a bit more painful when we are trying to get hired -- so check out these typical errors applicants make while answering SQL questions during data science interviews.

SQL 158

SQL Data Science Data 158

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 103

SQL Data Management Management Data 103

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 138

SQL Data IT 138

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

NOVEMBER 18, 2022

The post explains all the key elements of SQL that you must know as a data science practitioner.

SQL 155

SQL Data Science Data 155

KDnuggets

NOVEMBER 13, 2023

This week, we delve into the vital world of Databases, SQL, Data Management, and Statistical Concepts in Data Science. Welcome back to Week 2 of KDnuggets’ "Back to Basics" series.

Database 100

Database SQL Data Management Management 100

Hevo

APRIL 5, 2024

Data migration between different platforms is critical to consider when generating multiple organizational strategies. One such migration involves transferring data from a cloud-based data warehousing service environment to a relational database management system.

SQL 40

SQL Relational Database Data Database 40

KDnuggets

FEBRUARY 24, 2023

This article will discuss SQL visualization, its role in augmenting the modern-day data engineer, and five categories of SQL visualization tools.

SQL 88

SQL Data Engineering Data Engineer Engineering 88

Hevo

APRIL 26, 2024

Microsoft SQL Server is commonly used to manage controls/permissions, backup, recovery, and data migration — but it may not be the best option for you. Through this blog post, we will be listing out the top 10 SQL Server alternatives for you to consider while investigating the best fit.

SQL 52

SQL Management IT Data 52

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 136

SQL Data Science Data 136

KDnuggets

JANUARY 16, 2023

In this article, we will discuss the benefits of using SQL with a data lake and how it can help organizations unlock the full potential of their data.

Data Lake 108

Data Lake SQL Data IT 108

KDnuggets

OCTOBER 20, 2022

Learn SQL commands for filtering, string operations, alias, joining tables, if-else statements, and grouping.

SQL 134

SQL Data Science Data 134