Scribd
Upload
9 views11 pages

Understanding Database Types and SQL

A database is an organized data store that enables faster retrieval and minimizes redundancy for efficient storage and consistency. Database management systems (DBMS) facilitate the creation and management of databases, utilizing query languages like SQL. The document also discusses various database types, including NoSQL databases, which cater to large volumes of complex data and have gained prevalence due to the demand for big data management.

Uploaded by

Paweł S
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
9 views11 pages

Understanding Database Types and SQL

A database is an organized data store that enables faster retrieval and minimizes redundancy for efficient storage and consistency. Database management systems (DBMS) facilitate the creation and management of databases, utilizing query languages like SQL. The document also discusses various database types, including NoSQL databases, which cater to large volumes of complex data and have gained prevalence due to the demand for big data management.

Uploaded by

Paweł S
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd

What Is a Database?

• A database is an organized store of data for:


• Faster retrieval of data

• Databases usually store data in a way that


minimizes redundancy to achieve:
• More efficient data storage
• Reduced data inconsistency

• Query languages provide a standardized


way to access the data in a database
• A database management system (DBMS) is
the software with which you can create and
manage databases
Relational Database Fundamentals
Tables in Relational Databases
Introduction to Normalization
Data Warehouses
Online Analytical Processing Databases
Hierarchical Databases
Column-Oriented Databases
NoSQL Databases

• NoSQL databases:
• Do not use the relational data model
• Offer better performance than relational databases
for very large volumes of complex data
• Some NoSQL databases lack key relational features

• Increasing prevalence of NoSQL databases:


• The need to store and manage big data
• Greater availability of scale-out technologies

• Types of NoSQL databases include:


• Document-oriented databases
• Object-oriented databases
Structured Query Language

• SQL is a standard language for use with


relational databases
• SQL standards are maintained by ANSI and
ISO
• Proprietary RDBMS systems have their own
extensions of SQL, such as Transact-SQL
• Subsets of SQL include:
• Data Definition Language (DDL)
• Data Manipulation Language (DML)
• Data Control Language (DCL)
Transact-SQL Queries

You might also like