计算机导论课件（北航）NP2013_Chapter11.pptVIP

* * * Figure 11-38 * * Figure 11-40 * * * Figure 11-42 * Figure 11-43 * * * * * Figure 11-45 * Figure 11-46 * Figure 11-47 * * * Figure 11-50 Figure 11-51 * * * * * * Figure 11-53 * Figure 11-54 * * * Figures 11-56 and 11-57 * * * * * Figure 11-5 * Figure 11-6 * Figure 11-7 * Figure 11-8 * * Figure 11-9 * Figure 11-10 * Figure 11-11 * Figure 11-12 * Figure 11-14 * Figure 11-15 * Figure 11-16 * * * Figure 11-17 * Figure 11-18 * Figure 11-19 * * Figure 11-21 * Figure 11-22 * Figure 11-23 * * Figure 11-24 * Figure 11-25 * Figure 11-26 * Figure 11-27 * Figure 11-28 * * * * * Figure 11-33 Section D: SQL Chapter 11: Databases * SQL Basics Intermediary between the database client software and the database itself Chapter 11: Databases * SQL Basics Chapter 11: Databases * Adding Records Chapter 11: Databases * Searching for Information SELECT Album, AlbumCover FROM Albums WHERE Artist = ‘Jefferson Airplane’ The AND, OR, and NOT Boolean operators are used to perform complex queries The use of parentheses indicates the part of the query to perform first Chapter 11: Databases * Updating Fields UPDATE Albums SET InStock = InStock – 1 WHERE Album = ‘G.I. Blues’ Global updates change the data in more than one record at a time Works only for records with similar characteristics Chapter 11: Databases * Joining Tables Joining tables in SQL allows you to create relationships between tables Chapter 11: Databases * Joining Tables Chapter 11: Databases * Question How does SQL relate to a typical computer user? A. Because search engines like Google are databases, you can use SQL to make advanced searches. B. You can use SQL to get beyond the main menu option on e-commerce sites like the iTunes store. C. You can use SQL to find music at free file sharing sites. D. Knowing how a query language works can help you understand how databases work behind the scenes. Chapter 11: Databases * Answer D Chapter 11: Databases * Section E: Database Securit