MySQL
Why Databases Are Awesome
MySQL
What Is A Database?
MySQL
What Is A Database?
Why Do They Matter?
What Is A Database?
1. A collection of data
A Phone Book!
Andrews, Archie - (949)345-2222
Cooper, Betty - (212)246-9846
Flanders, Ned - (415)987-3451
Jones, Jughead - (415)888-3777
Lodge, Veronica - (714)332-0981
Snow, Jon - (949)621-1908
Stark, Ned - (310)119-6501
Find Ned Flanders' Phone Number
Find People With First Name "Ned"
Find All Phone Numbers With Area Code 415
Find All People Who Have a 3-letter First Name
A Quick Example
What Is A Database?
1. A collection of data
2. A method for accessing and manipulating that data
Andrews, Archie - (949)345-2222
Cooper, Betty - (212)246-9846
Flanders, Ned - (415)987-3451
Jones, Jughead - (415)888-3777
Lodge, Veronica - (714)332-0981
Snow, Jon - (949)621-1908
Stark, Ned - (310)119-6501
Find Ned Flanders' Phone Number
Find People With First Name "Ned"
Find All Phone Numbers With Area Code 415
Find All People Who Have a 3-letter First Name
A Quick Example
Database Management System
Database
Vs.
Database
DBMS
Your App
"Database"
Database
DBMS
PostgreSQL
MySQL
SQLite
Oracle Database
What Is A Database?
A structured set of computerized data with an accessible interface
Why Do They Matter?
Well...why does data matter?
Data
Is
Knowledge
Data
Is
Money
You've probably heard of big data....
It's ok if you haven't!
Data has always played an important role in industries
But now, data itself is a huge booming industry!
Why MySQL?
Some Popular Databases
- MongoDB
- Oracle
- MySQL
- SQLite
- PostgreSQL
- MaxDB
- Firebird
- Redis
Some Popular Databases
- MongoDB
- Oracle
- MySQL
- SQLite
- PostgreSQL
- MaxDB
- Firebird
- Redis
MySQL
vs.
SQL
Let's Start With SQL
Structured Query Language
SQL is the language we use to "talk" to our databases
"Find All Users"
"Find All Users Who Are 18 Years Old"
"Add A New User With Username 'JumboJim'"
Delete Every Single User!
A Quick Preview!
SELECT * FROM Users WHERE Age >= 18;
Find All Users Who Are 18 Or Older
Working With MySQL Is Primarily Writing SQL
- MySQL
- SQLite
- PostgreSQL
- Oracle
- Many Others
Relational Databases
All Use SQL
}
MySQL
SELECT * FROM Users WHERE Age >= 18;
PostgreSQL
SELECT * FROM Users WHERE Age >= 18;
There Are Slight Differences In Syntax
Which We'll Talk About In This Course!
Two Takeaways
1. Once you learn SQL, it's pretty easy to switch to another DB that uses SQL
2. What makes databases (DBMS) unique are the features they offer, not the language
Some Code
SELECT * FROM animals;
SELECT species, status FROM animals;
MySQL 2.0: Intro to MySQL
By Colt Steele
