SQLite

SQLite

CSE373

Outline

Introduction to SQL

SQLite

SQLite Shell

SQLite From A Program

An example in Java

Conclusions

SQL

Quick Introduction To SQL

The Structured Query Language (SQL) is a programming

language designed to interact with relational databases

The SQL anagram can be pronounced either S-Q-L or sequel

SQL is designed to work with databases that are composed of

tables

The columns are data typed fields

The rows are instances of data

Relationships can be established between the columns of tables

The formal description of the names and structure of the

tables in a database is called a schema

Often the schema is the series of SQL statements that create the tables,

relationships and constraints

Quick Introduction To SQL

There are four basic functions of any storage system (CRUD)

Create

Read

Update

Delete

The statements in SQL that support CRUD are:

CREATE TABLE - Create

INSERT - Create

SELECT - Read

UPDATE ¨C Update

ALTER TABLE - Update

DELETE ¨C Delete

DROP - Delete

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download