O'Reilly logo

Hello, Android, 4th Edition by Ed Burnette

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SQL 101

If you’ve used Oracle, SQL Server, MySQL, DB2, or other database engines, then SQL should be old hat to you. You can skip this section and go to Hello, Database. For the rest of you, here’s a quick refresher.

To use a SQL database, you submit SQL statements and get back results. There are three main types of SQL statements: DDL, Modification, and Query.

DDL Statements

A database file can have any number of tables. A table consists of rows, and each row has a certain number of columns. Each column of the table has a name and a data type (text string, number, and so forth). You define these tables and column names by first running Data Definition Language (DDL) statements. Here’s a statement that creates a table with three columns:

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required