Introduction to
Database
Management
01 - Definitions of Data and data base
02 - Major components of data
03 -Importance of database /Use of
database
04 - Basic Requisites of Data
05 - Importance of database
security and encryption
Data Visualization
Analyzing data
01 - Definitions of Data and
enables informed
database decision-making
Data- refers to raw information that
consists of basic facts and figures. Facts
and statistics collected together for
reference or analysis
Database- a structured collection of data
that is stored electronically
01 - Major components of
data (software)
Data
Database engine
Database schema
Database access language
Query processor
Metadata
01 - Major components of
data (hardware)
Storage devices
Memory (RAM)
Processor (CPU)
Network components
Data
important informations eg.
name, age, location, gender
Data is the most important component of any
database. It is the stored information that the
systems within an organization interact with
and manage. Data in a database is organized in
a way that allows for easy access,
manipulation, and analysis, supporting various
business operations and decision-making
processes
Database
engine
MongoDB (for NoSQL
databases)
Amazon Aurora
Google Cloud Spanner
A database engine is the underlying software
that enables the database to operate
effectively and carry out its intended functions.
Database
schema
Doesn’t contain the data,
but simply facilitates
database design per your
organization’s needs.
A database schema defines the structure and
constraints of your database. In terms of
relational databases, it specifies the tables, the
fields within each table, and the relationships
between them. It’s a model of how your data
will look. The schema doesn’t contain any data
itself
Database
access language
It refers to the language you can use to write
queries and commands to interact with
databases. SQL is the most prevalent language,
but variants like MySQL and Presto also exist.
Query processor
As the name suggests, a query processor
processes your database queries in executable
form.
Metadata
“data about data”
data that describes other data, such as the
author, creation date, or file size of a document
Importance of
database / Use of
Data analysis helps uncover valuable
database insights from complex datasets
Analyzing data
enables informed
decision-making
Data
Data visualization simplifies Visualization
the communication of
analysis findings Decision making
03 - Data Visualization
Data 1 Data 2 Data 3
50
40
30
20
10
0
project 1 project 2 project 3 Element 4 Element 5
03 - Data Visualization
water cement
20% 20%
Lorem ipsum dolor sit amet, consectetur
adipiscing elit, sed do eiusmod tempor
incididunt ut labore et dolore magna
aliqua. Ut enim ad minim veniam, quis sand
20%
rsb
20%
nostrud exercitation ullamco laboris nisi ut
aliquip ex ea commodo consequat. Duis
aute irure dolor in reprehenderit in gravel
voluptate velit esse cillum dolore eu fugiat 20%
nulla pariatur. Excepteur sint occaecat
cupidatat non proident, sunt in culpa qui
officia deserunt mollit anim id est laborum
Lorem ipsum dolor sit amet,
consectetur adipiscing elit, sed do
eiusmod tempor incididunt ut labore
et dolore magna aliqua. Ut enim ad
minim veniam, quis nostrud
exercitation ullamco laboris nisi ut
aliquip ex ea commodo consequat.
Duis aute irure dolor in
reprehenderit in voluptate velit esse
cillum dolore eu fugiat nulla pariatur.
Data analysis allows
for identifying
trends and patterns
04 - Conclusions within datasets.
Basic Requisites of
Data
accuracy
completeness
consistency
relevance
timeliness
accessibility
security
Importance of
database security
and encryption
the process of using a
cryptographic algorithm to
scramble sensitive information
within a spreadsheet file, making it
unreadable without the correct
decryption key, typically requiring
a password to access the data
04 - Conclusions
Creates an easier
Data analysis facilitates
way to interpret and predictive modeling and
create a sound and forecasting
effective decision
Data analysis helps in Data
identifying outliers or
anomalies in the data
Visualization
