SQL Programming: Data Handling Techniques


Overview/Description
To demonstrate the use of SQL in defining database structures and controlling data security

Target Audience
Programmers working in a relational database environment, database administrators, and database designers

Prerequisites
The courses SQL Programming: Database Queries and Relational Principles; programming experience is not absolutely necessary

Expected Duration
4 Hours

Objectives:

SQL Programming: Data Handling Techniques

  • To demonstrate the INSERT, UPDATE, and DELETE commands of the data manipulation language (DML) of SQL
  • To show how SQL can be embedded in a procedural language
  • To demonstrate the data definition language (DDL) of SQL
  • To explain the data control language (DCL) of SQL

  • Course Number: SQLPDHT