Profile

e-Catalog

Contact

Search

Cart

SQL Programming: Database Queries

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

Course Aim

To demonstrate the use of SQL in data retrieval

Learning Objectives

Categorize SQL into three component languages and indicate the functions of each. Use the SELECT command to retrieve data. Use the built-in functions available in SQL to refine database queries. Retrieve data from two or more tables, using joins and subqueries.

Topics Covered

Introduction to SQL - SQL - what is it? - SQL standards - DDL - DCL - DML - SQL language constructs DML: The SELECT command - DML - Using the SELECT command - Predicates - Expressions and connectives DML: Refining queries - Built-in functions - Grouping rows - Ordering rows DML: Multi-table queries - Joins - Outer joins - The subquery method