SQL Database Definition Language (DDL) Training

IT/Networking/Server/Operating Systems
Schedules
Optional
  IT Online Library (1 Year Subscription - $1595.00)
Quantity
If quantity is more than 1, Please add all Attendees' Names /Voucher #/ Learning Credit below separated with a comma. If not specified, we will contact you prior to the class start date. Special Instructions
Overview

In this DDL training class, you will learn to the basic principles of normalization and to create and modify database tables, views and stored procedures using SQL. Syntax will be shown in SQL Server, Oracle, and MySQL.

 

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

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 in our Live Online and our Onsite classes receives 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:

  • Introduction to SQL Training

Course Setup
  • Live Online: Course Setup | WebEx Setup