| |
|
|
|
|
|
|
|
|
1. |
Record Nr. |
UNINA9911093640503321 |
|
|
Autore |
Wilton Paul <1969-> |
|
|
Titolo |
Beginning SQL / / Paul Wilton and John W. Colby |
|
|
|
|
|
Pubbl/distr/stampa |
|
|
Indianapolis, IN, : Wiley, c2005 |
|
|
|
|
|
|
|
ISBN |
|
9786610253463 |
9781280253461 |
1280253460 |
9780764596322 |
0764596322 |
|
|
|
|
|
|
|
|
Edizione |
[1st edition] |
|
|
|
|
|
Descrizione fisica |
|
1 online resource (521 p.) |
|
|
|
|
|
|
Collana |
|
|
|
|
|
|
Altri autori (Persone) |
|
|
|
|
|
|
Disciplina |
|
|
|
|
|
|
Soggetti |
|
SQL (Computer program language) |
|
|
|
|
|
|
Lingua di pubblicazione |
|
|
|
|
|
|
Formato |
Materiale a stampa |
|
|
|
|
|
Livello bibliografico |
Monografia |
|
|
|
|
|
Note generali |
|
"Programmer to programmer"--Cover. |
|
|
|
|
|
|
Nota di contenuto |
|
Beginning SQL; About the Authors; Credits; Contents; Acknowledgments; Introduction; Who This Book Is For; What This Book Covers; How This Book Is Structured; What You Need to Use This Book; Conventions; Source Code; Errata; p2p. wrox. com; Chapter 1: Introduction to SQL; A Brief History of Databases; Structured Query Language (SQL); Database Creation; Creating, Altering, and Deleting Tables; Good Database Design; Creating the Example Database; Summary; Exercises; Chapter 2: Entering Information; Inserting New Data; Inserting Data into the Case Study Database; Updating Data; Deleting Data |
SummaryExercises; Chapter 3: Extracting Information; The SELECT Statement; Logical Operators and Operator Precedence; Ordering Results with ORDER BY; Selecting Data from More Than One Table; Introducing NULL Data; Summary; Exercises; Chapter 4: Advanced Database Design; Normalization; Ensuring Data Validity with Constraints; Speeding Up Results with Indexes; Summary; Exercises; Chapter 5: Manipulating Data; Understanding SQL Arithmetic; Introducing String Functions; Converting Different Data Types; Re-examining NULL; Using INSERT INTO with the SELECT Statement; Summary; Exercises |
|
|
|
|
|
|
|
|
|
|
|
Chapter 6: Grouping and Aggregating DataGrouping Results; Summarizing and Aggregating Data; Using the HAVING Clause with GROUP BY Statements; Summary; Exercises; Chapter 7: Selecting Data from Different Tables; Joins Revisited; Combining Results Sets with the UNION Operator; Summary; Exercises; Chapter 8: Queries within Queries; Subquery Terminology; Subqueries in a SELECT List; Subqueries in the WHERE Clause; Operators in Subqueries; Correlated Subquery; Subqueries Used with Other Statements; Summary; Exercises; Chapter 9: Advanced Queries; Updating the Database; Tackling Difficult Queries |
Top Tips for Efficient QueriesSummary; Exercises; Chapter 10: Views; Introducing Views; Summary; Exercises; Chapter 11: Transactions; Introducing Transactions; Transaction Logs; Locks; Isolation Levels; Problem Examples; Revisiting the Example Code; Summary; Exercises; Chapter 12: SQL Security; Security Concepts; Summary; Exercises; Chapter 13: Database Tuning; Tuning Hardware; Tuning SQL; Tuning Tips; Summary; Exercises; Appendix A: Exercise Answers; Chapter 1; Chapter 2; Chapter 3; Chapter 4; Chapter 5; Chapter 6; Chapter 7; Chapter 8; Chapter 9; Chapter 10; Chapter 11; Chapter 12 |
Chapter 13Appendix B: Setting Up and Using the Five Database Systems; Installing and Using MySQL Version 4.1; Installing and Using IBM DB2; Installing and Using Microsoft Access XP; Installing and Using Microsoft SQL Server 2000; Installing and Using Oracle 10g; Appendix C: Initial Data Setup; Category Table; MemberDetails Table; Location Table; FavCategory Table; Films Table; Attendance Table; Index |
|
|
|
|
|
|
Sommario/riassunto |
|
Taking readers through the basics of the language, right up to some more advanced topics, this book is a practical, hands-on resource and aims to keep the reader involved at all timesFocuses on the SQL standard and is loaded with detailed examples and code; each chapter includes practice exercises that readers can challenge themselves with before looking at the sample solutions in the appendixPaul Wilton is a successful Wrox ""Beginning"" book author and is an ideal author to write for those who want a firm grasp of standard SQL before learning the details specific to a particu |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2. |
Record Nr. |
UNINA9911101099303321 |
|
|
Titolo |
E-commerce and the digital economy / / Michael J. Shaw, editor |
|
|
|
|
|
Pubbl/distr/stampa |
|
|
Armonk, NY : , : M.E. Sharpe, , 2006 |
|
|
|
|
|
|
|
ISBN |
|
1-317-47269-1 |
1-138-68131-8 |
1-315-70505-2 |
0-7656-2007-3 |
9781315705057 |
|
|
|
|
|
|
|
|
Edizione |
[1st ed.] |
|
|
|
|
|
Descrizione fisica |
|
1 online resource (328 p.) |
|
|
|
|
|
|
Collana |
|
Advances in management information systems ; ; v. 4 |
|
|
|
|
|
|
Altri autori (Persone) |
|
|
|
|
|
|
Disciplina |
|
|
|
|
|
|
Soggetti |
|
Electronic commerce |
Commerce - Data processing |
|
|
|
|
|
|
|
|
Lingua di pubblicazione |
|
|
|
|
|
|
Formato |
Materiale a stampa |
|
|
|
|
|
Livello bibliografico |
Monografia |
|
|
|
|
|
Note generali |
|
First published 2006 by M.E. Sharpe. |
|
|
|
|
|
|
Nota di bibliografia |
|
Includes bibliographical references and index. |
|
|
|
|
|
|
Nota di contenuto |
|
CONTENTS; SERIES EDITOR'S INTRODUCTION; REFERENCES; ACKNOWLEDGMENTS; E-COMMERCE AND THE DIGITAL ECONOMY AN INTRODUCTION; PROLOGUE; THE TECHNOLOGY ENABLER; ORGANIZATIONAL TRANSFORMATIONS; PROCESS/SUPPLY CHAIN TRANSFORMATIONS; CHANNEL MANAGEMENT; B2B OPPORTUNITIES; VALUE PROPOSITIONS AND JUSTIFICATION; UBIQUITOUS COMMERCE; OPEN AND DYNAMIC ENTERPRISES; OVERVIEW OF THE ORGANIZATION OF THIS VOLUME; PART I INFORMATION TECHNOLOGY STANDARDS AND THE TRANSFORMATIONS OF INDUSTRY STRUCTURE |
CHAPTER 1 MEASURING THE BUSINESS BENEFITS OF WEB-BASED INTERORGANIZATIONAL SYSTEMS A CO-ADOPTION MODEL FOR STANDARDS DEVELOPMENTCHAPTER 2 IMPACT OF STANDARDIZATION ON BUSINESS-TO-BUSINESS COLLABORATION; CHAPTER 3 THE IMPACT OF B2B ELECTRONIC COMMERCE TECHNOLOGY, PROCESSES, AND ORGANIZATION CHANGES A CASE STUDY IN THE PERSONAL COMPUTER INDUSTRY; CHAPTER 4 THE STANDARDIZATION GAP AN ECONOMIC FRAMEWORK FOR NETWORK ANALYSIS; PART II EMPHASIS ON CONSUMERS AND CUSTOMIZATION; CHAPTER 5 EXTENDING CUSTOMERS' ROLES IN E-COMMERCE 75 CHAPTER 5 EXTENDING |
|
|
|
|
|
|
|
|
|
|
|
CUSTOMERS' ROLES IN E-COMMERCE PROMISES, CHALLENGES |
CHAPTER 6 HUMAN FACTORS AND E-COMMERCECHAPTER 7 BUNDLING AND UNBUNDLING OF ELECTRONIC CONTENT; CHAPTER 8 CURRENT AND FUTURE INSIGHTS FROM ONLINE AUCTIONS A RESEARCH FRAMEWORK; PART III MANAGEMENT OF MOBILE AND INFORMATION TECHNOLOGY INFRASTRUCTURE; CHAPTER 9 PEER-TO-PEER TECHNOLOGIES FOR BUSINESS-TO-BUSINESS APPLICATIONS; CHAPTER 10 TOPOGRAPHICAL LEVERAGING OF SHARABLE SERVICES THE CONCEPT OF CAPACITY PROVISION NETWORKS; CHAPTER 11 MOBILE COMMERCE A VALUE SYSTEM PERSPECTIVE; CHAPTER 12 EXPLAINING THE SUCCESS OF NTT DOCOMO'S I-MODE THE CONCEPT OF VALUE SCOPE MANAGEMENT |
PART IV TRUST, SECURITY, AND LEGAL ISSUESCHAPTER 13 TRUST IN ONLINE CONSUMER EXCHANGES EMERGING CONCEPTUAL AND THEORETICAL TRENDS; CHAPTER 14 SPOTTING LEMONS IN THE PKI MARKET ENGENDERING TRUST BY SIGNALING QUALITY; CHAPTER 15 PRIVATE LAW ON THE INTERNET THE PERFORMANCE OF THE ICANN/UDRP SYSTEM; ABOUT THE EDITOR AND CONTRIBUTORS; SERIES EDITOR; INDEX |
|
|
|
|
|
|
Sommario/riassunto |
|
Divided into four parts, this book offers a state-of-the-art survey of information systems research on electronic commerce. It provides the framework for understanding the business trends, emerging opportunities, and barriers to overcome in the rapid developments taking place in electronic business and the digital economy. |
|
|
|
|
|
|
|
| |