Send the link below via email or IMCopy
Present to your audienceStart remote presentation
- Invited audience members will follow you as you navigate and present
- People invited to a presentation do not need a Prezi account
- This link expires 10 minutes after you close the presentation
- A maximum of 30 users can follow your presentation
- Learn more about this feature in our knowledge base article
Do you really want to delete this prezi?
Neither you, nor the coeditors you shared it with will be able to recover it again.
Make your likes visible on Facebook?
You can change this under Settings & Account at any time.
Transcript of Databases
Who has used a database?
SQL = Structured Query Language
Used to interact with the database tables
Insert, Update, Delete, Retrieve info
"Hey database, give me a list of all the people who like cake"
Programmers build graphical interfaces so you can just click buttons instead of writing code. Easy!
Web or desktop based, often an android/iphone app .
database table structures
, and sell them/give them away so other people can use them.
Especially useful for things which are often done. E.g.:
Posts (author, post content, date)
Comments (author, comment, date)
And in our industry?
Built to manage museums collections
Built to manage herbaria collections
Packages containing tables for
biological research collections
These configurable packages
can save a lot of time
However if it's nowhere near what you want, there is no point in trying to force things.
These are called
Database/Content Management Systems
Sometimes you need more flexibility
You're not reinventing the wheel, but it's more flexible...
... But more work to configure
select * from
food = "cake"
Easier than copying, but still a bit hard...
select * from
How to link
these 2 tables to easily retrieve the info we want?
The hard way:
There's also a mixture of CMS/DBMS & framework:
Remember: You are aiming to save time, effort & money while not compromising too much on your requirements
When making technology decisions, remember:
Database (joined up excel tables) + User interface
Excellent if you can find one to save time!
The bottom line:
Record of plants found on walks