SQLite - NMT Computer Science and Engineering

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 ? Update ALTER TABLE - Update DELETE ? Delete DROP - Delete

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

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

Google Online Preview   Download