SQL Database Definition Language (DDL) Training

  4.6 out of 5 - Read Testimonials

In this DDL training class, you will learn 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:

Preparing for Class

Training for your Team

Length: 1 Day
  • Private Class for your Team
  • Online or On-location
  • Customizable
  • Expert Instructors

Training for Yourself

$395.00 or 1 vouchers

Upcoming Classes

  • See More Classes

Please select a class.
  • Live Online Training
  • For Individuals
  • Expert Instructors
  • Guaranteed to Run
  • 100% Free Re-take Option
  • 1-minute Video

What people say about our training

Thank you. This class extended my knowledge of the SQL Database language.
Christine Vivar
Tharperobbins
Very informative and the instructor's willingness to discuss real world issues was invaluable.
Mike Funck
PerkinElmer Canada
I am happy I took this course. The materials were easy to use and the instructor made it easier for me to understand. This is a good way to take SQL classes or any other database classes. Thank you.
Antoinette Arriola
CFHC
The Webucator class for DDL was extremely helpful and the instructor did an excellent job with explaining key concepts.
Tarun Reddy
NA

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

61,095

Students who have taken Instructor-led Training

11,722

Organizations who trust Webucator for their Instructor-led training needs

100%

Satisfaction guarantee and retake option

9.11

Students rated our SQL Database Definition Language (DDL) Training trainers 9.11 out of 10 based on 20 reviews

Contact Us or call 1-877-932-8228