SQL Database Definition Language (DDL) Training

Goals

• 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

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

To Hire an AMS SQL Subject Matter Expert and Instructor who also teaches this class, call us today at 800-798-3901!