SQL Programming: Database Queries

Overview/Description
To demonstrate the use of SQL in data retrieval

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

Prerequisites
The course Relational Principles, though not a strict prerequisite, would be beneficial; programming experience is not absolutely necessary

Expected Duration
4 hours

Objectives:

SQL Programming: Database Queries

  • To introduce SQL and its components, and to explain SQL standards
  • To describe the DML (data manipulation language) and to examine the usage of the SELECT command
  • To examine the additional clauses and functions available for use with the SELECT statement
  • To explain how data from two or more tables can be accessed for a query


    • Course Number: SQLPDQ