learn database design with mysql - chapter 1 - what is a database

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 brad@something.com

2 John Doe john@something.com

3 Jane Doe Jane@something.com

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!