ABSTRACT

SQL statements are divided into three main groups: Data Definition Language (DDL), Data Manipulation Language (DML) and Data Control Language (DCL).

This chapter presents the different ways to create tables: using GUI and using SQL statements for the Oracle, SQL Server and MySQL. All the tables that used for this book are created in SQL statements. The chapter goes on to present SQL DDL statements in changing database structures. By the end of the chapter readers will see how to use SQL statements to create tables and modify database structures.