
113
Chapter 4
Database Development and
Management with SQL
Objectives
◾ Get started with SQL
◾ Create database objects with SQL
◾ Manage database objects with SQL
◾ Control database object privileges with SQL
4.1 Introduction
In this chapter, SQL, a commonly used database development tool, will be introduced. You will
learn some often-used SQL commands and use them to create and manage database objects. You
will use SQL to create database objects such as tables, constraints, users, and roles. You will learn
how to modify the database structure and data content with SQL commands.
4.2 Structured Query Language
As shown in the previous chapter, you c ...