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
- DDL Overview
- Principles of Normalization
- Creating and Modifying Tables
- Data Types
- Creating Tables
- NULL Values
- Primary Keys
- Foreign Keys
- Adding and Dropping Columns
- Renaming Tables
- SQL Server
- Oracle and MySQL
- Dropping Tables
- Views
- Creating Views
- Dropping Views
- Benefits of Views
- Creating a View
- Stored Procedures
- Creating Stored Procedures
- Dropping Stored Procedures
- Creating a Stored Procedure
- Benefits of Stored Procedures
Class Materials
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:
- Basic SQL
Courses that can help you meet these prerequisites:
Instructor-led courses are offered via a live Web connection, at client sites throughout Europe, and at our Geneva Training Center.