2. Getting Started: Overview

What is a Database? (2 answers)

1. A collection of data

2. A method for accessing and manipulating that data

A program that does the talking or networking between our App and our Database.

Database Management System (DBMS)

True or False: MySQL / SQLite / Oracle Database are databases where the data is stored.

False: They are Database Management Systems but not actually databases. However, people will refer to them as databases interchangeably.

A structured set of computerized data with an accessible interface.

Database

What does SQL stand for?

Structured Query Language

What is SQL?

The language we use to "talk" to our databases

Translate the following code into MySQL.

Find All Users Who Are 18 or Older

Select * From Users Where Age >= 18;

What makes databases (DBMS) unique?

The features they offer (not the SQL language itself).

Create a database using command line name cat_app

create database cat_app;

Write command line to use cat_app database.

use cat_app

Using the command line, get a description of the database named cats_app.

desc cats_app;

What is MySQL?

A database management system.