SQL Database Definition Language (DDL) Training

Course duration

  • 1 day

Course Benefits

  • Understand the basics of database design.
  • Learn to create a simple database using SQL DDL
  • Learn to create tables, views, and stored procedures using SQL DDL

Course Outline

  1. DDL Overview
    1. Principles of Normalization
  2. Creating and Modifying Tables
    1. Data Types
    2. Creating Tables
      1. NULL Values
      2. Primary Keys
      3. Foreign Keys
    3. Adding and Dropping Columns
    4. Renaming Tables
      1. SQL Server
      2. Oracle and MySQL
    5. Dropping Tables
  3. Views
    1. Creating Views
    2. Dropping Views
    3. Benefits of Views
    4. Creating a View
  4. Stored Procedures
    1. Creating Stored Procedures
    2. Dropping Stored Procedures
    3. Creating a Stored Procedure
    4. Benefits of Stored Procedures

Class Materials

Each student will receive a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this SQL class:

  • Basic SQL
Prerequisite Courses

Courses that can help you meet these prerequisites:

Since its founding in 1995, InterSource has been providing high quality and highly customized training solutions to clients worldwide. With over 500 course titles constantly updated and numerous course customization and creation possibilities, we have the capability to meet your I.T. training needs.
Instructor-led courses are offered via a live Web connection, at client sites throughout Europe, and at our Geneva Training Center.