Overview

Introduction

Introduction to DDL language

This module explores the concepts of DDL language used to create tables, views, indexes and other schema objects. It includes statements that perform the operation of creating a table, deleting a table altering the size of columns, dropping the tables, adding the constraints, etc.

  • Categorizing Main Database Objects
  • Table Structure
  • Data Types for Columns
  • Creating a Simple Table
  • Introduction to Constraints
  • Introduction to Schema Objects

Exercise 1 - Categorizing Main Database Objects

In this exercise, you will learn the following about Introduction to DDL Language:

  • Establishing a Connection to the Database
  • Changing Data Dictionary using Create, Alter and Drop Schema Objects
  • Grant and Revoke Privileges and Roles

Exercise 2 - Table Structure

In this exercise you will learn the following about the Introduction to DDL Language:

  • Table Definition - Rows, Columns, and Additional Aspects

Exercise 3 - Data Types for Columns

In this exercise you will learn the following about Introduction to DDL Language:

  • Understanding the various data types available for columns

Exercise 4 - Creating a Simple Table

In this exercise you will learn the following about Introduction to DDL Language:

  • Creating a basic table using CREATE statement
  • Creating a complex table using CREATE statement
  • Understanding database objects naming rules
  • Understanding namespaces
  • Understanding schema references

Exercise 5 - Introduction to Constraints

In this exercise you will learn the following about Introduction to DDL language:

  • Understanding PRIMARY KEY Constraint
  • Understanding UNIQUE KEY Constraint
  • Understanding NOT NULL Constraint
  • Understanding FOREIGN KEY Constraint
  • Understanding CHECK Constraint

Exercise 6 - Introduction to Schema Objects

In this exercise you will learn the following about Introduction to DDL Language:

  • Understanding Schema Objects

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.