Advanced Database Design and SQL

PT2583
Training Summary
This is an intensive course that is designed to get students quickly using all of the basics of Structured Query Language (SQL), as well as Relational Database Design techniques. This course will showcase Entity Relationship Modeling, Normalization, and Data Integrity. Students will learn how to create database tables and execute queries using SQL's Data Definition Language (DDL) and Data Manipulation Language (DML).
Prerequisites
Students taking this course should have knowledge of basic relational database concepts. They should also have experience with an SQL interface, such as TSO/ISPF or one of the Windows based interfaces, to be able to code and test SQL statements
Duration
2 Day/Lecture & Lab
Audience
This course is designed for application programmers and programmer analysts who will be using SQL statements to manipulate Relational Database tables.
Course Topics
DB2 Concepts and Terminology::The Application Design Process::DB2 Table Design::Basic and Advanced SQL::Referential Integrity Overview Data Definition

Related Scheduled Courses