Guidelines for Retrieving Data Efficiently

illegal for non-trainer use

Introduction

Lesson Objectives

In this lesson, you will see how to retrieve data from a relational database.

This lesson shows how to use the SELECT statement to retrieve data from a database. The lesson also shows how to filter data by using the WHERE clause, and describes performance considerations that affect retrieving data.

After completing this lesson, you will be able to:

■ Describe the structure of relational databases.

■ Retrieve data from a database by using the SELECT statement.

■ Filter data by using search conditions with the WHERE clause.

■ Describe performance considerations that affect retrieving data.

0 0

Post a comment