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.
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
Principles of Normalization
Creating and Modifying Tables
Adding and Dropping Columns
Oracle and MySQL
Benefits of Views
Creating a View
Creating Stored Procedures
Dropping Stored Procedures
Creating a Stored Procedure
Benefits of Stored Procedures
Each student will receive a comprehensive set of materials, including course notes and all the class examples.
Experience in the following is required for this SQL class:
Courses that can help you meet these prerequisites: