Muutke küpsiste eelistusi

Guide to SQL 10th edition [Pehme köide]

3.67/5 (71 hinnangut Goodreads-ist)
(e-conn (Chief Information Officer)), (Grand Valley State University), (Gaston College),
  • Formaat: Paperback / softback, 320 pages, kõrgus x laius x paksus: 16x182x226 mm, kaal: 544 g
  • Ilmumisaeg: 04-Aug-2020
  • Kirjastus: Course Technology Inc
  • ISBN-10: 0357361687
  • ISBN-13: 9780357361689
Teised raamatud teemal:
  • Pehme köide
  • Hind: 62,71 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Tavahind: 78,39 €
  • Säästad 20%
  • Raamatu kohalejõudmiseks kirjastusest kulub orienteeruvalt 2-4 nädalat
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Tellimisaeg 2-4 nädalat
  • Lisa soovinimekirja
Guide to SQL 10th editionSuurem pilt
  • Formaat: Paperback / softback, 320 pages, kõrgus x laius x paksus: 16x182x226 mm, kaal: 544 g
  • Ilmumisaeg: 04-Aug-2020
  • Kirjastus: Course Technology Inc
  • ISBN-10: 0357361687
  • ISBN-13: 9780357361689
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780357361689.html
Märksõnad:
Master today's SQL programming principles and learn how to most effectively apply your SQL skills with Shellman/Afyouni/Pratt/Last's A GUIDE TO SQL, Tenth Edition. This edition's leading approach combines straightforward instruction and extensive hands-on exercises with a strong foundation and emphasis on today's actual business applications. This edition introduces basic SQL commands in the context of an intriguing, ongoing case in which a business uses SQL to manage orders, items, customers and sales reps.

This edition emphasizes how to apply fundamental principles and strengthen your programming practices, regardless of the database environment. You work with examples from the latest versions of MySQL, the world's most popular open source, free database, as well as Oracle® and Microsoft® SQL Server. In addition, MindTap digital learning solution is available to help you strengthen your SQL skills.
Preface ix
Module 1 Introduction to KimTay Pet Supplies and StayWell Student
Accommodation Databases
1(1)
Introduction
1(1)
What Is a Database?
1(1)
The KimTay Pet Supplies Database
2(6)
StayWell Student Accommodation Database
8(4)
Module Summary
12(1)
Key Term
12(1)
Case Exercises
12(3)
KimTay Pet Supplies
12(1)
StayWell Student Accommodation
13(2)
Module 2 Database Design Fundamentals
15(36)
Introduction
15(1)
Database Concepts
16(4)
Relational Databases
16(1)
Entities, Attributes, and Relationships
17(3)
Functional Dependence
20(3)
Primary Keys
23(2)
Database Design
25(8)
Design Method
25(1)
Database Design Requirements
26(1)
Database Design Process Example
27(6)
Normalization
33(10)
First Normal Form
33(2)
Second Normal Form
35(3)
Third Normal Form
38(5)
Diagrams for Database Design
43(2)
Module Summary
45(1)
Key Terms
46(1)
Review Questions
46(1)
Case Exercises
47(4)
KimTay Pet Supplies
47(1)
StayWell Student Accommodation
48(3)
Module 3 Creating Tables
51(46)
Introduction
51(1)
Creating and Running SQL Commands
52(5)
Using MySQL Workbench
52(2)
Entering Commands
54(3)
Creating a Database
57(3)
Changing the Default Database
59(1)
Creating a Table
60(7)
Correcting Errors in SQL Commands
65(1)
Dropping a Table
66(1)
Using Data Types
67(1)
Using Nulls
68(1)
Adding Rows to a Table
69(5)
The INSERT Command
69(4)
Inserting a Row that Contains Nulls
73(1)
Viewing Table Data
74(2)
Correcting Errors in a Table
76(3)
Saving SQL Commands
79(4)
Creating the Remaining Database Tables
83(5)
Describing a Table
88(4)
Module Summary
92(1)
Key Terms
92(1)
Review Questions
92(1)
Case Exercises
93(4)
KimTay Pet Supplies
94(1)
StayWell Student Accommodation
94(3)
Module 4 Single-Table Queries
97(38)
Introduction
97(1)
Constructing Simple Queries
97(14)
Retrieving Certain Columns and All Rows
98(1)
Retrieving All Columns and All Rows
99(1)
Using a WHERE Clause
100(2)
Using Compound Conditions
102(3)
Using the BETWEEN Operator
105(2)
Using Computed Columns
107(2)
Using the LIKE Operator
109(2)
Using the IN Operator
111(1)
Sorting
111(2)
Using the ORDER BY Clause
112(1)
Additional Sorting Options
112(1)
Using Functions
113(6)
Using the COUNT Function
114(1)
Using the SUM Function
115(1)
Using the AVG, MAX, and MIN Functions
115(2)
Using the DISTINCT Operator
117(2)
Nesting Queries
119(4)
Subqueries
121(2)
Grouping
123(5)
Using the GROUP BY Clause
124(1)
Using a HAVING Clause
125(1)
HAVING vs. WHERE
126(2)
Nulls
128(1)
Summary of SQL Clauses, Functions, and Operators
129(1)
Module Summary
130(1)
Key Terms
131(1)
Review Questions
131(1)
Case Exercises
132(3)
KimTay Pet Supplies
132(1)
StayWell Student Accommodation
133(2)
Module 5 Multiple-Table Queries
135(38)
Introduction
135(1)
Querying Multiple Tables
135(4)
Joining Two Tables
135(4)
Comparing Joins, IN, and EXISTS
139(14)
Using the IN Operator
139(1)
Using the EXISTS Operator
140(2)
Using a Subquery Within a Subquery
142(2)
A Comprehensive Example
144(1)
Using an Alias
145(1)
Joining a Table to Itself
146(2)
Using a Self-Join on a Primary Key Column
148(2)
Joining Several Tables
150(3)
Set Operations
153(6)
ALL and ANY
159(3)
Special Operations
162(5)
Inner Join
162(1)
Outer Join
163(2)
Product
165(2)
Module Summary
167(1)
Key Terms
168(1)
Review Questions
168(1)
Case Exercises
169(4)
KimTay Pet Supplies
169(1)
StayWell Student Accommodation
170(3)
Module 6 Updating Data
173(28)
Introduction
173(1)
Creating a New Table from an Existing Table
173(3)
Changing Existing Data in a Table
176(3)
Adding New Rows to an Existing Table
179(1)
Autocommit, Commit, and Rollback
180(3)
Transactions
183(1)
Changing and Deleting Existing Rows
184(3)
Executing a Rollback
186(1)
Changing a Value in a Column to Null
187(2)
Changing a Table's Structure
189(7)
Making Complex Changes
196(1)
Dropping a Table
196(1)
Module Summary
197(1)
Key Terms
197(1)
Review Questions
197(1)
Case Exercises
198(3)
KimTay Pet Supplies
198(1)
StayWell Student Accommodation
199(2)
Module 7 Database Administration
201(38)
Introduction
201(1)
Creating and using Views
201(9)
Using a View to Update Data
210(6)
Updating Row-and-Column Subset Views
210(2)
Updating Views Involving Joins
212(4)
Updating Views Involving Statistics
216(1)
Dropping a View
216(1)
Security
217(2)
Indexes
219(6)
Creating an Index
222(1)
Dropping an Index
223(2)
Creating Unique Indexes
225(1)
System Catalog
225(4)
Update of the System Catalog
228(1)
Integrity Constraints in SQL
229(4)
Module Summary
233(1)
Key Terms
233(1)
Review Questions
234(1)
Case Exercises
235(4)
KimTay Pet Supplies
235(2)
StayWell Student Accommodation
237(2)
Module 8 Functions, Procedures, and Triggers
239(1)
Introduction
239(1)
Using SQL in a Programming Environment
239(1)
Using Functions
240(8)
Character Functions
241(1)
Number Functions
242(1)
Working with Dates
243(5)
Concatenating Columns
248(4)
Stored Procedures Using MySQL
252(3)
Retrieving a Single Row and Column
253(2)
Error Handling
255(4)
Using Update Procedures
259(3)
Changing Data with a Procedure
259(1)
Deleting Data with a Procedure
260(2)
Selecting Multiple Rows with a Procedure
262(6)
Using a Cursor
262(1)
Opening a Cursor
263(1)
Fetching Rows from a Cursor
263(2)
Closing a Cursor
265(1)
Writing a Complete Procedure Using a Cursor
265(1)
Using More Complex Cursors
265(3)
Advantages of Cursors
268(1)
Using PL/SQL in Oracle
268(4)
Error Handling in PL/SQL
270(1)
Writing a Complete Procedure Using a Cursor in PL/SQL
271(1)
Using T-SQL in SQL Server
272(3)
Retrieving a Single Row and Column in T-SQL
272(1)
Changing Data with a Stored Procedure in T-SQL
273(1)
Deleting Data with a Stored Procedure in T-SQL
273(1)
Using a Cursor in T-SQL
274(1)
Using More Complex Cursors in T-SQL
275(1)
Using a Trigger
275(7)
Module Summary
282(1)
Key Terms
283(1)
Review Questions
283(1)
Case Exercises
284(1)
KimTay Pet Supplies
284(2)
StayWell Student Accommodation
286
Appendix A SQL Reference
1(14)
Aliases
1(1)
Alter Table
1(1)
Column or Expression List (SELECT Clause)
2(1)
Computed Columns
2(1)
The Distinct Operator
2(1)
Functions
3(1)
Commit
3(1)
Conditions
3(3)
Simple Conditions
3(1)
Compound Conditions
4(1)
Between Conditions
4(1)
Like Conditions
4(1)
In Conditions
4(1)
Exists Conditions
5(1)
All and any
5(1)
Create Index
6(1)
Create Table
6(1)
Create View
6(1)
Data Types
7(1)
Delete Rows
8(1)
Describe
8(1)
Drop Index
8(1)
Drop Table
9(1)
Drop View
9(1)
Grant
9(1)
Insert Into (Query)
10(1)
Insert Into (Values)
10(1)
Integrity
10(1)
Revoke
11(1)
Rollback
11(1)
Select
12(1)
Subqueries
13(1)
Union, Intersect, And Minus
13(1)
Update
14(1)
Appendix B How Do I Reference
15(4)
Appendix C The 10 Commandments of Writing Queries
19
Index 1
Dr. Mark Shellman is an instructor and the Chair of the Information Technology Department at Gaston College in Dallas, North Carolina. Dr. Mark, as his students refer to him, prides himself on being student-centered and loves learning himself. His favorite subjects in the information technology realm include databases and programming languages. Dr. Mark has been teaching information technology for more than thirty years and has co-authored several texts in the New Perspectives Series on Microsoft® Access databases. Dr. Hassan Afyouni has been working in the information technology field for more than thirty years. He is a database expert, Oracle® specialist, an enterprise architect, technical advisor and educator. He has been an instructor for several colleges and universities in Canada, the United States and Lebanon. He is a respected author of several leading books in the database field. Philip J. Pratt is Professor Emeritus of Mathematics and Computer Science at Grand Valley State University, where he taught for 33 years. His teaching interests include database management, systems analysis, complex analysis and discrete mathematics. He has authored more than 75 textbooks and has co-authored three levels of Microsoft® Office Access books for the popular Shelly Cashman Series, in addition to the popular A GUIDE TO SQL. Mary Z. Last has taught computer information systems since 1984. She retired from the University of Mary Hardin-Baylor, Belton, Texas, where she was an associate professor and the Director of the Center for Effectiveness in Learning and Teaching. Ms. Last is actively involved in the Computing Educator's Oral History Project that encourages young women to pursue careers in math and science. She has been a contributing author to the Shelly Cashman Series since 1992. She also authors many instructor resources for leading database texts.