Job Ready SQL

Lesson 7Database Management Using DDL

SQL comes in two flavors: data definition language (DDL) and data management language (DML). DDL is used to define and create the database and its structure, including tables, indexes, and relationships between tables. DML is primarily used to manipulate the data stored within that storage. In this lesson, we will look closely at DDL and create a database based on a defined ERD.

Learning Objectives

By the end of this lesson, you will be able to:

• Create and use a database
• Generate a list of available databases in an RDBMS
• Delete an existing database from an RDBMS
• Describe available data types and apply them to fields in a table
• Generate a list of tables in the selected database
• Show the structure of an existing table
• Update a table's structure
• Delete a table from a database
• Generate a script that can be used to rebuild/copy a database structure
• Use foreign keys to define relationships between tables
• Understand referential integrity
• Identify and compare options for deleting or updating values in primary key fields

DATABASE MANAGEMENT

As a new developer, you are not likely to have to manage data at the database level, but it is useful to understand the steps if you choose to work on your own database or in the event you do become a database administrator later.

DDL statements are used to create and manage databases. Regardless of the relational database management system (RDBMS) that will manage the database, a database must be created ...