Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start 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.

DeleteCancel

Make your likes visible on Facebook?

Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.

No, thanks

Gentle Introduction to SQL Using SQLite

Short introduction to SQL built around the SQLite Manager Firefox plugin.
by

Troy Thibodeaux

on 15 November 2016

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Gentle Introduction to SQL Using SQLite

A Gentle Introduction to SQL Using SQLite
"Structured Query Language"
A declarative language
used to query and manage data in a
relational database
management system.
Relational Model
Data joined between relations
(table rows linked by shared data)
Declarative Language
(Pay no attention to that man!)
Keyword Driven
(a few verbs, a few modifiers)
Main Verbs for
Working with Data

SELECT
INSERT
UPDATE
DELETE
Main Verbs for Managing
Database Structure

CREATE (TABLE)
DROP (TABLE)
ALTER (TABLE)
https://github.com/tthibo/
Troy Thibodeaux
Associated Press
tthibodeaux@ap.org
@tthibo
Modifying Keywords
(examples)

FROM
WHERE
GROUP BY
ORDER BY
Full transcript