描述SQL作为关连资.pdfVIP

Chapter 9 Relational Data Retrieval: SQL Fundamentals of Database Management Systems by Mark L. Gillenson, Ph.D. Modified by Walter Chen University of Memphis Dept. of Civil Engineering National Taipei University of Technology Presentation by: Amita Goyal Chin, Ph.D. For classroom teaching purpose Virginia Commonwealth University John Wiley Sons, Inc. Chapter Objectives  Describe SQL as a relational data manipulation language 描述 SQL 作為關連資 料控制語言  Explain that you can create and update relational tables using SQL 可以用 SQL 產生 和更新表格  Write SQL SELECT commands to retrieve relational data using a variety of operators, including GROUP BY, ORDER BY, and the built-in functions of AVG, SUM, MAX, MIN, 9-2 and COUNT Chapter Objectives  Write SQL SELECT commands that join relational tables  Write SQL SELECT subqueries  Describe a strategy for writing SQL SELECT statements  Describe the principles of how a relational query optimizer works 描述關連查詢最佳化 如何運作 9-3 Data Management 資料管  Data Definition 資料定義  Data Manipulation 資料操控 9-4 Data Management: Data Definition  Operationalized with a data definition language (DDL)  Instructs the DBMS software on wha