hoffer_mdbm9e_IM_07

hoffer_mdbm9e_IM_07 - 38 Modern Database Management, Ninth...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
38 Modern Database Management, Ninth Edition Chapter 7 Introduction to SQL Chapter Overview This chapter describes in detail what has become the standard query language for relational database management systems, SQL. Although SQL is illustrated in this chapter primarily through the Oracle10g SQL*Plus version (MySQL and Microsoft Access SQL are also shown), SQL is a portable language that is available on all classes of computers and with many different DBMSs. This chapter introduces SQL, DDL, and DML. Single table queries are covered in this chapter, and multiple-table queries are covered in Chapter 8. Several chapters contain important prerequisite material for this chapter. Chapter 5 introduces the relational model and provides much of the background for this chapter. The discussion in Chapter 6 on indexes is also important because choosing primary and secondary key indexes is one of the few, but crucial, internal database design choices for users of relational systems. Chapter Objectives Specific student learning objectives are included at the beginning of the chapter. From an instructor’s point of view, the objectives of this chapter are to: 1. Explain SQL and show the basic operators so that the student can anticipate the capabilities of particular SQL-based systems. 2. Provide a historical perspective of the development of SQL and its continuing development. This perspective illustrates the benefits and risks of adopting a standard query language. 3. Show that SQL, although a standard and a high-level language, does have some flaws, and that SQL must evolve to include additional features. 4. Explain and illustrate the power of relational views for simplifying relational database processing. 5. Illustrate data definition language (DDL) commands for creating tables and views as well as modifying and dropping tables. 6. Provide examples of single table SQL queries. 7. Provide some examples of the use of functions within SQL queries. 8. Show how to establish referential integrity using SQL. 9. Illustrate the use of the group by and order by clauses. Key Terms Base table Data manipulation language (DML) Relational DBMS (RDBMS) Catalog Data control language (DCL) Dynamic view Scalar aggregate Materialized view Schema Data definition language (DDL) Referential integrity Vector aggregate Virtual table
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
39 Modern Database Management, Ninth Edition Classroom Ideas 1. Depending on how you choose to sequence the chapters of this book, you may want to begin lecturing on this chapter by reviewing normalization principles and discussing why one might want to implement a fully normalized database. See the section “Denormalization” in Chapter 6 for background on this topic. The point is to emphasize the difference between logical and physical database designs. 2.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 31

hoffer_mdbm9e_IM_07 - 38 Modern Database Management, Ninth...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online