This book covers all basic Structured Query Language (SQL) statements including Data Definition Language, Data Manipulation Language, and Transaction Control statements. This book deals mainly with one of the database objects: Tables. It gives a brief introduction to each category of SQL statements, followed by a set of solved sample questions. A number of practice questions are provided at the end of each topic, with their solutions included at the end of the book. The topics covered in this book include understanding naming rules for table and column names, explanation of different operators and data types apart from explanation of different categories of SQL statements with examples.
This book is suitable for students who are in their first year of under-graduate or graduate studies and are learning SQL for the first time. The software used in this book is Oracle Enterprise Edition.
After reading this book, you should be able to understand different database objects, understand naming rules for tables and column names, state the different data types, understand the significance of Structured Query Language (SQL), understand the various types of SQL statements, describe and work with different Data Definition Language (DDL) statements, describe and work with different Data Manipulation Language (DML) statements, describe and work with different Transaction Control statements and explain how constraints are created at the time of table creation.
Though all the queries mentioned in this book have been tested using the Oracle 11g; these would also work with previous versions of Oracle as most of the queries are basic in nature. Most of the queries should work as such with other database packages such as SQL Server and MySQL; minor modifications may be needed in some queries. Note that Structured Query Language (SQL) is a standard that is implemented by all database packages, so the syntax of all the SQL queries is same in all database packages, with the manufacturers of these packages adding some additional features and options to basic SQL. The free Enterprise Edition of Oracle software is available at the following URL: