Database Articles

Sorted By: Most Recent
Terence Shin Terence Shin
Updated on December 10, 2024

10 Advanced SQL Concepts to Know (With Examples)

Learn these 10 advanced SQL concepts to take your SQL skills to the next level.

Image: Shutterstock / Built In
Giorgos Myrianthous Giorgos Myrianthous
Updated on December 09, 2024

Fact Table vs. Dimension Table: What’s the Difference?

A fact table contains the primary keys to a referenced dimension table, and the dimension table contains the descriptive information. They make up the key components in star schema.

Image: Shutterstock / Built In
Manuel Silverio Manuel Silverio
Updated on November 07, 2024

What Is Data Warehousing?

Data warehousing provides access to information for supporting business intelligence activities. Data warehouses are digital environments for data storage.

Image: Shutterstock / Built In
Chris Dowsett Chris Dowsett
Updated on November 07, 2024

What Is a Database?

A database is a systematic way of storing information so data can be accessed, analyzed, transformed, updated and moved with efficiency.

Image: Shutterstock / Built In
Dilip Kumar Patairya Dilip Kumar Patairya
Updated on November 07, 2024

Star Schema vs. Snowflake Schema Explained

Star schema and snowflake schema are two methods for arranging data in a warehouse. Learn the key differences and which is right for your organization.

Image: Shutterstock / Built In
Farah Kim Farah Kim
Updated on November 04, 2024

What Is Entity Resolution? Why Should Businesses Care?

Entity resolution is a time-consuming but vital step both for compliance and for generating useful insights. Fortunately, our expert shows you an easier way to conduct this step.

Image: Shutterstock / Built In
Alyssa Schroer Alyssa Schroer
Updated on October 30, 2024

Big Data in Business: 24 Examples to Know

These big data in business companies specialize in analytics and insights for marketing, retail and other industries.

Image: Shutterstock / Built In
Nikita Nikitins Nikita Nikitins
Updated on September 04, 2024

Code First Approach vs. Database First Approach: Which Is Best?

Code first and database first are two approaches to developing a database to work in Entity Framework. Learn which one is best for you.

Image: Shutterstock / Built In
Jenny Lyons-Cunha Jenny Lyons-Cunha
Updated on August 22, 2024

What Is Data Mapping?

It’s the first step in cultivating an accurate and secure data management system.

Image: Shutterstock
Brooke Becher Brooke Becher
Updated on August 22, 2024

13 Types of Databases to Know

Not all databases are built alike. These data storage systems vary based on the type of information it’s storing as well as a user’s intent.

Image: Shutterstock