Creating Tables and Indexes

Let us go through the details related to creating tables and indexes. We will also talk about how columns, constraints etc while going through the details related to tables and indexes.

  • DDL - Data Definition Language

  • Overview of Data Types

  • Adding or Modifying Columns

  • Different Types of Constraints

  • Managing Constraints

  • Indexes on Tables

  • Indexes for Constraints

  • Overview of Sequences

  • Truncating Tables

  • Dropping Tables

  • Exercise - Managing Database Objects

Here are the key objectives of this section:

  • How to create and manage tables?

  • Get in depth understanding about columns and commonly used data types

  • What are different types of constraints and how they are managed?

  • What are indexes and how they are relevant to Prmary Key, Unique and Foreign Key constraints?

  • What is a Sequence and how sequences are used to populate Surrogate Keys?

  • Self evaluate whether one understood all the key aspects of managing tables and constraints.

Exercises - Basic SQL Queries DDL – Data Definition Language