KDnuggets

SEPTEMBER 16, 2022

Get up to speed on SQL and relational databases with this free video course.

SQL 135

SQL Database Relational Database 135

Analytics Vidhya

FEBRUARY 28, 2023

Introduction Structured Query Language is a powerful language to manage and manipulate data stored in databases. SQL is widely used in the field of data science and is considered an essential skill to have if you work with data.

SQL 223

SQL Relational Database Data Science Database 223

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 102

Database SQL Data Management Management 102

Analytics Vidhya

MARCH 2, 2023

Introduction Data normalization is the process of building a database according to what is known as a canonical form, where the final product is a relational database with no data redundancy. More specifically, normalization involves organizing data according to attributes assigned as part of a larger data model.

Database 221

Database Relational Database Building Process 221

Data Engineering Podcast

AUGUST 27, 2023

In the era of the cloud most developers rely on hosted services to manage their databases, but what if you are a cloud service? RudderStack Profiles takes the SaaS guesswork and SQL grunt work out of building complete customer profiles so you can quickly ship actionable, enriched data to every downstream team. Why Postgres?

Database 130

Database Building PostgreSQL BI 130

KDnuggets

SEPTEMBER 13, 2023

Getting Started with SQL in 5 Steps • Introduction to Databases in Data Science • Time 100 AI: The Most Influential?

Data Science 132

Data Science SQL Database Data 132

KDnuggets

JULY 13, 2023

Learn about Indexing in SQL and how you can increase the retrieval speed of the SELECT queries and WHERE clauses.

SQL 83

SQL Database 83

Confluent

NOVEMBER 3, 2021

SQL has proven to be an invaluable asset for most software engineers building software applications. Yet, the world as we know it has changed dramatically since SQL was created in […].

SQL 130

SQL Database Process Software Engineer 130

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

Knowledge Hut

APRIL 23, 2024

We live in a data-driven culture where familiarity with databases is crucial. Database management is crucial for businesses of all sizes to guarantee that their data is complete, safe, and easily available when needed. There will likely be a greater need for database specialists' skills in 2024.

Database 52

Database Management Relational Database SQL 52

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 133

Data Science SQL Database Data 133

Hevo

MAY 29, 2023

Modern organizations need database vendors that provide easy and cost-effective solutions with support for mission-critical needs. Of the two most popular Database Management Systems, MS SQL Server is a superior alternative to IBM Db2.

Database 52

Database SQL Systems Management 52

Knowledge Hut

MARCH 27, 2024

Think of a database as a smart, organized library that stores and manages information efficiently. In simpler terms, a database is where information is neatly stored, like books on shelves, while data structures are the behind-the-scenes helpers, ensuring data is well-organized and easy to find. What is a Database?

Database 52

Database Algorithm Relational Database PostgreSQL 52

KDnuggets

SEPTEMBER 21, 2022

7 Machine Learning Portfolio Projects to Boost the Resume • Free SQL and Database Course • Top 5 Bookmarks Every Data Analyst Should Have • 7 Steps to Mastering Python for Data Science • 5 Concepts You Should Know About Gradient Descent and Cost Function.

Portfolio 108

Portfolio Machine Learning SQL Database 108

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 157

SQL Database Coding IT 157

KDnuggets

NOVEMBER 6, 2023

Graph databases are quickly becoming a core part of the analytics toolset for enterprise IT organizations. If you know SQL, you can easily learn Cypher and open up a huge opportunity for data analysis.

Database 96

Database Data Analysis SQL Data 96

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

OCTOBER 4, 2022

Among the four big NoSQL database types, key-value stores are probably the most popular ones due to their simplicity and fast performance. Let’s further explore how key-value stores work and what are their practical uses.

Database 158

Database NoSQL SQL 158

Hevo

MARCH 28, 2024

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 Server gives you control over storage procedures, query optimization, and user-defined functions, providing a […]

SQL 52

SQL Data Integration Database Data 52

Monte Carlo

MAY 9, 2023

But the reality is, transactional databases remain incredibly popular even in analytics use cases. That’s why we’re excited to announce the Monte Carlo data observability platform now integrates with Postgres , MySQL , and Microsoft SQL Server databases.

MySQL 52

MySQL Database SQL Relational Database 52

KDnuggets

FEBRUARY 1, 2022

If the idea of being able to link with SQL databases and define, manipulate, and query using Python sounds appealing, check out the SQLModel library.

SQL 146

SQL Python Database 146

Knowledge Hut

MARCH 20, 2024

There are database management teams with experts handling different affairs. The ones heading these teams are the database administrators. So, if you are wondering how do i become a database administrator, you are at the right place. Who is a Database Administrator, and What Do They Do?

Database 52

Database Database-centric Computer Science Certification 52

Cloudyard

JANUARY 29, 2023

Read Time: 1 Minute, 32 Second During this post we will discuss about the Exception handling in snowflake via sql scripting. We know Oracle has great list of predefined exceptions, which are raised when any database rule is violated. Snowflake Scripting raises an exception if an error occurs while executing a statement.

SQL 98

SQL Database Coding Building 98

Data Engineering Podcast

DECEMBER 11, 2022

Managing the operational concerns for your database can be complex and expensive, especially if you need to scale to large volumes of data, high traffic, or geographically distributed usage. No more shipping and praying, you can now know exactly what will change in your database! or any other destination you choose.

Database 100

Database MySQL Data Lake MongoDB 100

KDnuggets

SEPTEMBER 8, 2023

Understand the relevance of databases in data science. Also learn the fundamentals of relational databases, NoSQL database categories, and more.

Database 105

Database Data Science NoSQL Relational Database 105

Edureka

MAY 23, 2023

SQL Alchemy is a powerful and popular Python library that provides an Object-Relational Mapping (ORM) tool for working with relational databases. It serves as a bridge between Python and various database management systems, allowing developers to interact with databases using Python code.

SQL 52

SQL Relational Database Python NoSQL 52

Knowledge Hut

DECEMBER 28, 2023

If you're in the world of database management, you're likely already familiar with SQL - the powerful programming language that's used to manage and manipulate data. Among the most popular data management tools is SQL or Structured Query Language. What are SQL Tools?

SQL 52

SQL MySQL PostgreSQL Database 52

Hevo

APRIL 5, 2024

One such migration involves transferring data from a cloud-based data warehousing service environment to a relational database management system. Amazon Redshift SQL Server Integration can give organizations an edge, allowing them to conduct enhanced analysis and reporting through custom report application […]

SQL 40

SQL Relational Database Data Database 40

Monte Carlo

MARCH 6, 2024

If you’ve been keeping track of our integrations page you might have noticed Monte Carlo is adding support for different databases faster than a nested loop server crash. By the end of 2023, we added Azure SQL database to the list as well as enterprise databases such as Oracle DB , SAP HANA and Teradata.

Database 52

Database MySQL Data Warehouse AWS 52

Cloudera

JANUARY 19, 2024

As described in our recent blog post , an SQL AI Assistant has been integrated into Hue with the capability to leverage the power of large language models (LLMs) for a number of SQL tasks. This is a real game-changer for data analysts on all levels and will make SQL development faster, easier, and less error-prone.

SQL 71

SQL Data Warehouse AWS Architecture 71

Data Engineering Podcast

AUGUST 6, 2021

The trouble is that the data is usually spread across a wide and shifting array of systems, from databases to dashboards. Castor is building a data discovery platform aimed at solving this problem, allowing you to search for and document details about everything from a database column to a business intelligence dashboard.

Database 100

Database BI SQL Business Intelligence 100

Knowledge Hut

NOVEMBER 22, 2023

MySQL Database Administrators makes Netflix binging, booking an Uber ride, and shopping on Amazon possible. As the world becomes digital, the demand for proficient database administrators also increases as almost every other application generates and accumulates data. Who is a MySQL Database Administrator?

MySQL 52

MySQL Database Banking Recruitment 52

Cloudera

FEBRUARY 9, 2021

Cloudera Operational Database is now available in three different form-factors in Cloudera Data Platform (CDP). . If you are new to Cloudera Operational Database, see this blog post. In this blog post, we’ll look at both Apache HBase and Apache Phoenix concepts relevant to developing applications for Cloudera Operational Database.

Database 101

Database Java Data Ingestion SQL 101

Hevo

DECEMBER 23, 2023

The concept behind the PostgreSQL Dump Import approach is to create a text file containing SQL commands that, when sent back to the server, will reconstruct the database in the same state as it was when the dump was performed. For this, PostgreSQL provides the pg_dump utility function.

PostgreSQL 52

PostgreSQL Database SQL Utilities 52

Knowledge Hut

NOVEMBER 22, 2023

Today, the entire world is influenced by data, and that's where the unafraid database administrator (DBA) comes in for the rescue. Sure, the database administrator salary must be handsome. Who is a Database Administrator? As IT professionals, DBAs oversee database updates, security, storage, and troubleshooting.

Database 52

Database Banking MySQL Consulting 52

Monte Carlo

NOVEMBER 28, 2023

One of the increasingly common infiltration points is when data is being synced across databases. This typically occurs when data teams want to move data from a transactional, on-premise, or staging database into the raw layer of their analytical data warehouse, lake or lakehouse. Here’s how it works. 1% between source and target.”

Database 59

Database Data Warehouse Machine Learning Data 59

Data Engineering Podcast

OCTOBER 23, 2022

Summary The database market has seen unprecedented activity in recent years, with new options addressing a variety of needs being introduced on a nearly constant basis. Despite that, there are a handful of databases that continue to be adopted due to their proven reliability and robust features.

Database 100

Database MySQL Cloud MongoDB 100