SQL （Structured Query Language） is a popular computer language that is used by diversegroups such as home computer owners， owners of small businesses， end users in largeorganizations， and programmers。 Although this book uses the SQL implementation in Oracle8 as a vebucle for teaching SQL， the chapter material， examples， and exercises in thisbook are designed to be completed using any soL implementation。A Guide to SQL， Fifth Edition is written for a wide range of teaching levels， includingstudents taking introduaory computer science classes to those students in advanced infor-mation systems classes。This textbook can be used for a stand-alone course on SQL or inconjunction with a database concepts textbook where students are required to learn SQL。The chapters in this textbook should be covered in order。 Students should completethe end-of-chapter exercises and the examples within the chapters for maximum learning。Because the content of Chapter 8 assumes that the reader has had instruction in or experi-ence with at least one programnung language， the instructor should determine whetherstudents will understand the concepts。 Students without a programming background willhave difficulty understanding the topic of embedded SQL。 Instructors can ea8ily omitChapter 8 from the textbook in situations where students are not comfortable with pro-gramming examples。
作者簡(jiǎn)介
暫缺《SQL應(yīng)用教程》作者簡(jiǎn)介
圖書(shū)目錄
Preface 1 Introduction to Database Management Objectives The Premiere Products Database The Henry Books Database Summary Exercises 2 An lntroduction to SQL Objectives Introduction Relational Databases Database Creation SQL Commands Dropping a Table Data Types Nulls Loading a Table with Data Viewing Data in a Table Correcting Errors in the Database Additional Tables Describing a Table Summary Exercises 3 Single-Table Queries Objeaives Introduction Simple Queries Sorting Using Functions Nesting Queries Grouping Nulls Summary Exercises 4 Multiple-Table Queries Objectives Introduction Querying Multiple Tables Using an Alias More Complex Joins Set Operations ALL and ANY Summary Exercises 5 Updating Data Objectives Introduction Commit and Rollback Changing Existing Data in a Table Adding New Rows To An ExistingTable Deleting Existing Rows From A Table Creating a New Table From an ExistingTable Changing a Value in a Column to Null Changing a Table‘s Structure Summary Exercises 6 Database Administration Objectives Introduction Views Security Indexes The System Catalog Integrity in SQL Summary Exercises 7 Reports Objectives Introduction Concatenating Columns Creating and Using Scripts Creating a View for the Report Executing a Select Command Changing Column Headings Changing Column Formats in a Report Adding aTitle to a Report Grouping Data in a Report Including Totals and Subtotals in a Report Sending the Report to a File A Complete Script to Produce the Report Summary Exercises …… 8 Embedded SQL Objectives Introduction Data Division Procedure Division A SQL Reference B “How do l” Reference C Answers to Odd-Numbered Exercises Index
鄂公網(wǎng)安備 42010302001612號(hào) 