learn database design with mysql - chapter 1 - what is a database
TRANSCRIPT
DATABASE DESIGN USING MYSQL
What is A Database?
WHAT IS A DATABASE?
A database is an
ordered collection of data
The word “Database” can be quite vague. People tend to
clump a combination of 3 things when referring to a database
• The Data
• The Database Management System
• Database Application
DATABASE MANAGEMENT SYSTEMS (DBMS)
A “DBMS” is Software that is designed to model data and provide interaction with a user
• Data is normally stored in one or more files
• Data is usually stored in tables
• Tables contain rows and columns much like a
spreadsheet
• Data can be cross referenced among tables. This
functionality is used in “Relational Databases”
such as MySQL
POPULAR DBMS’S
• MySQL
• PostgreSQL
• SQLite
• Microsoft SQL
Server
• Oracle
• SAP
• FoxPro
• dBASE
• MariaDB
SIMPLE EXAMPLE
id first_name last_name email
1 Brad Traversy [email protected]
2 John Doe [email protected]
3 Jane Doe [email protected]
Here is an example of a very simple table inside of a database
Database Name: MyStore
Table Name: Users
Columns/Fields: id, first_name, last_name, email
Rows/Records: 3 Users
INTERACTING WITH A DATABASE
Some common functions when working with a database…
• Define• Create• Select
• Query• Update• Delete
WHAT IS SQL?
SQL (Structured Query Language) is a special
purpose programming language that allows
developers to interact with the data in a database
• Based on relational algebra and tuple
relational calculus
• Data definition and data manipulation
language
• Perform CRUD (Create, Read, Update, Delete)
COMMON DATABASE MODELS
• Relational Database
(MySQL)
• Object Oriented Database
• Object Relational Database
• Distributed Database
• NoSQL Database
(MongoDB)
• Multimedia Database
• Flat Database
• Network Database
• Hierarchical Database
THAT’S IT!