Info
- Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.
8th International Conference on Database Systems for Advanced Applications
| 8th International Conference on Database Systems for Advanced Applications |
| Pubbl/distr/stampa | [Place of publication not identified], : IEEE Computer Society Press, 2003 |
| Disciplina | 005.75/65 |
| Soggetto topico |
Engineering & Applied Sciences
Computer Science |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNISA-996205947803316 |
| [Place of publication not identified], : IEEE Computer Society Press, 2003 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. di Salerno | ||
| ||
8th International Conference on Database Systems for Advanced Applications
| 8th International Conference on Database Systems for Advanced Applications |
| Pubbl/distr/stampa | [Place of publication not identified], : IEEE Computer Society Press, 2003 |
| Disciplina | 005.75/65 |
| Soggetto topico |
Engineering & Applied Sciences
Computer Science |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910872559203321 |
| [Place of publication not identified], : IEEE Computer Society Press, 2003 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Access 2003 VBA programmer's reference [[electronic resource] /] / Patricia Cardoza ... [et al.]
| Access 2003 VBA programmer's reference [[electronic resource] /] / Patricia Cardoza ... [et al.] |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Hoboken, NJ, : Wiley, c2004 |
| Descrizione fisica | 1 online resource (982 p.) |
| Disciplina | 005.75/65 |
| Altri autori (Persone) | CardozaPatricia |
| Collana | Programmer to programmer |
| Soggetto topico | Database management |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-280-28681-4
9786610286812 0-7645-7166-4 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
About the Authors; Acknowledgments; Foreword; Introduction; Chapter 1: Introduction to Microsoft Access; Why Use Microsoft Access?; Is Access the Only Database I'll Ever Need?; Microsoft Access; MSDE; SQL Server; Automating Microsoft Access Without VBA Code; The Database Wizard; Creating a Switchboard for Your Database; Begin at the Beginning; Create a Switchboard through the Switchboard Manager; Add and Configure Controls Using Wizards; Building Automation into Your Project; Using Expression Builder; Using the Macro Builder; Using the Code Builder; Summary; Chapter 2: Access, VBA, and Macros
VBA within Access Writing Code within Modules; VBA versus Macros in Access; Macros in Access 2003; Advantages to Using VBA over Macros; Summary; Chapter 3: New Features in Access 2003; Easy Upgrading; Database Structure and Management; Find Object Dependencies; Form/Report Error Checking; Propagate Field Properties; Customize SQL Font; Get Context-Sensitive SQL Help; Backup Database/Project; Sorting Option on Lookup Wizard; Copy and Paste Linked Table as Local Table; Notable Mention; New Wizards and Builders and Managers; A Wizard for Every Occasion; Available Builders; Managers Changes to Jet Service Pack 8; Security and Related Features; What Is Macro Security? And Why Are We Talking about Macros?; Digital Signatures; Expression Sandbox; End-User Enhancements; Pivot Charts; Windows XP Theming; Templates; Smart Tags; Auto Correct Options Buttons; Better Accessibility; XML and Access; Relating XML to HTML; The Advantages of XML; Using Access 2003 with SharePoint Services; Export Information to a SharePoint Server; Import Information From a SharePoint Server; Access Developer Extensions; The Property Scanner; The Custom Startup Wizard; The Package Wizard; Summary Chapter 4: VBA Basics VBA Objects; Objects; Methods; Events; Variables and VBA Syntax; Variables; Other VBA Structures; Comments; Line Continuation; Constants; Enums; Summary; Chapter 5: Using the VBA Editor; Anatomy of the VBA Editor; Your Access Database and VBA Project-Better Together; Using the Object Browser; Testing and Debugging VBA Code; Summary; Chapter 6: Using DAO to Access Data; Direct Access Objects; Why Use DAO?; Referring to DAO Objects; Default Collection Items; The DBEngine Object; The Workspaces Collection; The Errors Collection; The Databases Collection The Connections Collection DAO Object Properties; DAO Property Types; Creating Schema Objects with DAO; Managing Jet Security with DAO; Creating Security Objects; Managing Users and Groups; Managing Passwords; Managing Permissions; Data Access with DAO; Working with Query Defs; Working with Record sets; Filtering and Ordering Record sets; Navigating Record sets; Bookmarks and Record set Clones; Finding Records; Working with Record sets; Summary; Chapter 7: Using ADO to Access Data; Ambiguous References; Referring to ADO Objects; Default Collection Items; Connecting to a Data Source Specifying a Cursor Location |
| Record Nr. | UNINA-9910455765703321 |
| Hoboken, NJ, : Wiley, c2004 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Access 2003 VBA programmer's reference [[electronic resource] /] / Patricia Cardoza ... [et al.]
| Access 2003 VBA programmer's reference [[electronic resource] /] / Patricia Cardoza ... [et al.] |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Hoboken, NJ, : Wiley, c2004 |
| Descrizione fisica | 1 online resource (982 p.) |
| Disciplina | 005.75/65 |
| Altri autori (Persone) | CardozaPatricia |
| Collana | Programmer to programmer |
| Soggetto topico | Database management |
| ISBN |
1-280-28681-4
9786610286812 0-7645-7166-4 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
About the Authors; Acknowledgments; Foreword; Introduction; Chapter 1: Introduction to Microsoft Access; Why Use Microsoft Access?; Is Access the Only Database I'll Ever Need?; Microsoft Access; MSDE; SQL Server; Automating Microsoft Access Without VBA Code; The Database Wizard; Creating a Switchboard for Your Database; Begin at the Beginning; Create a Switchboard through the Switchboard Manager; Add and Configure Controls Using Wizards; Building Automation into Your Project; Using Expression Builder; Using the Macro Builder; Using the Code Builder; Summary; Chapter 2: Access, VBA, and Macros
VBA within Access Writing Code within Modules; VBA versus Macros in Access; Macros in Access 2003; Advantages to Using VBA over Macros; Summary; Chapter 3: New Features in Access 2003; Easy Upgrading; Database Structure and Management; Find Object Dependencies; Form/Report Error Checking; Propagate Field Properties; Customize SQL Font; Get Context-Sensitive SQL Help; Backup Database/Project; Sorting Option on Lookup Wizard; Copy and Paste Linked Table as Local Table; Notable Mention; New Wizards and Builders and Managers; A Wizard for Every Occasion; Available Builders; Managers Changes to Jet Service Pack 8; Security and Related Features; What Is Macro Security? And Why Are We Talking about Macros?; Digital Signatures; Expression Sandbox; End-User Enhancements; Pivot Charts; Windows XP Theming; Templates; Smart Tags; Auto Correct Options Buttons; Better Accessibility; XML and Access; Relating XML to HTML; The Advantages of XML; Using Access 2003 with SharePoint Services; Export Information to a SharePoint Server; Import Information From a SharePoint Server; Access Developer Extensions; The Property Scanner; The Custom Startup Wizard; The Package Wizard; Summary Chapter 4: VBA Basics VBA Objects; Objects; Methods; Events; Variables and VBA Syntax; Variables; Other VBA Structures; Comments; Line Continuation; Constants; Enums; Summary; Chapter 5: Using the VBA Editor; Anatomy of the VBA Editor; Your Access Database and VBA Project-Better Together; Using the Object Browser; Testing and Debugging VBA Code; Summary; Chapter 6: Using DAO to Access Data; Direct Access Objects; Why Use DAO?; Referring to DAO Objects; Default Collection Items; The DBEngine Object; The Workspaces Collection; The Errors Collection; The Databases Collection The Connections Collection DAO Object Properties; DAO Property Types; Creating Schema Objects with DAO; Managing Jet Security with DAO; Creating Security Objects; Managing Users and Groups; Managing Passwords; Managing Permissions; Data Access with DAO; Working with Query Defs; Working with Record sets; Filtering and Ordering Record sets; Navigating Record sets; Bookmarks and Record set Clones; Finding Records; Working with Record sets; Summary; Chapter 7: Using ADO to Access Data; Ambiguous References; Referring to ADO Objects; Default Collection Items; Connecting to a Data Source Specifying a Cursor Location |
| Record Nr. | UNINA-9910780447003321 |
| Hoboken, NJ, : Wiley, c2004 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Access 2003 VBA programmer's reference / / Patricia Cardoza ... [et al.]
| Access 2003 VBA programmer's reference / / Patricia Cardoza ... [et al.] |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Hoboken, NJ, : Wiley, c2004 |
| Descrizione fisica | 1 online resource (982 p.) |
| Disciplina | 005.75/65 |
| Altri autori (Persone) | CardozaPatricia |
| Collana | Programmer to programmer |
| Soggetto topico | Database management |
| ISBN |
1-280-28681-4
9786610286812 0-7645-7166-4 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
About the Authors; Acknowledgments; Foreword; Introduction; Chapter 1: Introduction to Microsoft Access; Why Use Microsoft Access?; Is Access the Only Database I'll Ever Need?; Microsoft Access; MSDE; SQL Server; Automating Microsoft Access Without VBA Code; The Database Wizard; Creating a Switchboard for Your Database; Begin at the Beginning; Create a Switchboard through the Switchboard Manager; Add and Configure Controls Using Wizards; Building Automation into Your Project; Using Expression Builder; Using the Macro Builder; Using the Code Builder; Summary; Chapter 2: Access, VBA, and Macros
VBA within Access Writing Code within Modules; VBA versus Macros in Access; Macros in Access 2003; Advantages to Using VBA over Macros; Summary; Chapter 3: New Features in Access 2003; Easy Upgrading; Database Structure and Management; Find Object Dependencies; Form/Report Error Checking; Propagate Field Properties; Customize SQL Font; Get Context-Sensitive SQL Help; Backup Database/Project; Sorting Option on Lookup Wizard; Copy and Paste Linked Table as Local Table; Notable Mention; New Wizards and Builders and Managers; A Wizard for Every Occasion; Available Builders; Managers Changes to Jet Service Pack 8; Security and Related Features; What Is Macro Security? And Why Are We Talking about Macros?; Digital Signatures; Expression Sandbox; End-User Enhancements; Pivot Charts; Windows XP Theming; Templates; Smart Tags; Auto Correct Options Buttons; Better Accessibility; XML and Access; Relating XML to HTML; The Advantages of XML; Using Access 2003 with SharePoint Services; Export Information to a SharePoint Server; Import Information From a SharePoint Server; Access Developer Extensions; The Property Scanner; The Custom Startup Wizard; The Package Wizard; Summary Chapter 4: VBA Basics VBA Objects; Objects; Methods; Events; Variables and VBA Syntax; Variables; Other VBA Structures; Comments; Line Continuation; Constants; Enums; Summary; Chapter 5: Using the VBA Editor; Anatomy of the VBA Editor; Your Access Database and VBA Project-Better Together; Using the Object Browser; Testing and Debugging VBA Code; Summary; Chapter 6: Using DAO to Access Data; Direct Access Objects; Why Use DAO?; Referring to DAO Objects; Default Collection Items; The DBEngine Object; The Workspaces Collection; The Errors Collection; The Databases Collection The Connections Collection DAO Object Properties; DAO Property Types; Creating Schema Objects with DAO; Managing Jet Security with DAO; Creating Security Objects; Managing Users and Groups; Managing Passwords; Managing Permissions; Data Access with DAO; Working with Query Defs; Working with Record sets; Filtering and Ordering Record sets; Navigating Record sets; Bookmarks and Record set Clones; Finding Records; Working with Record sets; Summary; Chapter 7: Using ADO to Access Data; Ambiguous References; Referring to ADO Objects; Default Collection Items; Connecting to a Data Source Specifying a Cursor Location |
| Record Nr. | UNINA-9910814853903321 |
| Hoboken, NJ, : Wiley, c2004 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Administration solutions for DB2 UDB for z/OS [[electronic resource] /] / Paolo Bruni ... [et al.]
| Administration solutions for DB2 UDB for z/OS [[electronic resource] /] / Paolo Bruni ... [et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | San Jose, CA, : IBM Corp., International Technical Support Organization, c2005 |
| Descrizione fisica | xxiv, 325 p. : ill |
| Disciplina | 005.75/65 |
| Altri autori (Persone) | BruniPaolo.4aut |
| Collana | Redbooks |
| Soggetto topico | Database management |
| Soggetto genere / forma | Electronic books. |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910450111403321 |
| San Jose, CA, : IBM Corp., International Technical Support Organization, c2005 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Administration solutions for DB2 UDB for z/OS [[electronic resource] /] / Paolo Bruni ... [et al.]
| Administration solutions for DB2 UDB for z/OS [[electronic resource] /] / Paolo Bruni ... [et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | San Jose, CA, : IBM Corp., International Technical Support Organization, c2005 |
| Descrizione fisica | xxiv, 325 p. : ill |
| Disciplina | 005.75/65 |
| Altri autori (Persone) | BruniPaolo.4aut |
| Collana | Redbooks |
| Soggetto topico | Database management |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910783529403321 |
| San Jose, CA, : IBM Corp., International Technical Support Organization, c2005 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Administration solutions for DB2 UDB for z/OS / / Paolo Bruni ... [et al.]
| Administration solutions for DB2 UDB for z/OS / / Paolo Bruni ... [et al.] |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | San Jose, CA, : IBM Corp., International Technical Support Organization, c2005 |
| Descrizione fisica | xxiv, 325 p. : ill |
| Disciplina | 005.75/65 |
| Altri autori (Persone) | BruniPaolo.4aut |
| Collana | Redbooks |
| Soggetto topico | Database management |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Front cover -- Contents -- Figures -- Tables -- Examples -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Chapter 1. Introduction -- 1.1 DB2 DB/Tools today -- 1.2 Contents of this redbook -- Chapter 2. DB2 DB/WORKBENCH, DB2 Administration Tool and DB2 Object Restore -- 2.1 Overview -- 2.2 DB2 DB/WORKBENCH summary of relevant functions -- 2.3 Comparison between tools -- 2.3.1 Extract architecture -- 2.3.2 Catalog navigation -- 2.3.3 Revoke impact report -- 2.3.4 Drop impact report -- 2.3.5 DSNZPARM information -- 2.3.6 Estimate size information -- 2.3.7 Create new objects -- 2.3.8 Housekeeping -- 2.3.9 Customize your DB2 Administration Tool parameters -- 2.3.10 Display subsystem select -- 2.3.11 Global Commands -- 2.3.12 Utilities -- 2.3.13 Macros -- 2.3.14 RI Map -- 2.3.15 Accum Member -- 2.3.16 Migrate -- 2.3.17 DO Command -- 2.3.18 ? Command -- 2.3.19 Explain -- 2.3.20 Performance Queries -- 2.3.21 Work statement list -- 2.3.22 LISTDEFs and Templates -- 2.3.23 Showing index columns -- 2.4 DB2 Object Restore Tool -- 2.4.1 Building the versioning repository -- 2.4.2 How to restore a dropped object -- 2.5 Comparison summary -- Chapter 3. DB2 DB/QUICKCHANGE and DB2 Administration Tool -- 3.1 Overview -- 3.2 DB2 DB/QUICKCHANGE - Summary of relevant functions -- 3.3 Alter Database -- 3.3.1 DB2 DB/QUICKCHANGE - Alter Database -- 3.3.2 DB2 Administration Tool - Alter Database -- 3.4 Alter Tablespace -- 3.4.1 DB2 DB/QUICKCHANGE - Alter Table space -- 3.4.2 DB2 Administration Tool - Alter Table space -- 3.5 Alter Index -- 3.5.1 DB2 DB/QUICKCHANGE - Alter Index -- 3.5.2 DB2 Administration Tool - Alter Index -- 3.6 Alter Table -- 3.6.1 DB2 DB/QUICKCHANGE - Alter Table -- 3.6.2 DB2 Administration Tool - Alter Table -- 3.7 Migrate Database.
3.7.1 DB2 DB/QUICKCHANGE - Migrate Database -- 3.7.2 DB2 Administration Tool - Migrate Database -- 3.8 Comparing Manage and Save Sessions to the Work Statement Lists -- 3.8.1 DB2 DB/QUICKCHANGE - Manage and Save Sessions -- 3.8.2 DB2 Administration Tool - Manage Work Statement Lists -- 3.9 DB2 DB/QUICKCHANGE and DB2 Administration Tool functional mapping -- Chapter 4. DB2 DB/QUICKCOMPARE and DB2 Object Comparison Tool -- 4.1 Overview -- 4.2 DB2 DB/QUICKCOMPARE summary of relevant functions -- 4.3 The differences in detail -- 4.3.1 Dependencies -- 4.3.2 Term definitions -- 4.3.3 Processing -- 4.4 Implementing changes with DB2 Object Comparison Tool -- 4.4.1 Step 1: Specify a compare source -- 4.4.2 Step 2: Specify a compare target -- 4.4.3 Step 3: Specify compare masks -- 4.4.4 Step 4: Specify fields to ignore -- 4.4.5 Step 5: Generate a compare job -- 4.4.6 Analyze compare reports -- 4.4.7 Run the work statement list -- 4.5 Save, manage and restore dialogs -- 4.6 Cross-reference of functions -- 4.7 Summary -- Chapter 5. DB2 DB/SMU and DB2 Automation Tool -- 5.1 Overview -- 5.2 DB2 DB/SMU function summary -- 5.3 DB2 Automation Tool function summary -- 5.3.1 Function cross-reference -- 5.4 Comparison between utility processes -- 5.4.1 ISPF interface -- 5.4.2 Object profiles -- 5.4.3 Utility profiles -- 5.4.4 Exception profiles -- 5.4.5 Job profiles -- 5.4.6 Data set manager -- 5.4.7 Data page display -- 5.4.8 Disaster recovery -- 5.5 DB2 Automation Tool operational scenario -- 5.5.1 Step 1: Create object profile -- 5.5.2 Step 2: Create utility profile -- 5.5.3 Step 3: Create exception profile (optional) -- 5.5.4 Step 4: Create job profile -- 5.5.5 Step 5: Build job -- 5.5.6 Managing profiles -- 5.5.7 Quick Build -- 5.6 Comparison summary -- 5.7 DB2 Automation Tool for z/OS V2.2 highlights -- Chapter 6. Using DB2 Tools with DB2 UDB for z/OS Version 8. 6.1 Current status -- 6.2 DB2 Administration Tool -- 6.2.1 Support for long names -- 6.2.2 DDL and GEN commands -- 6.2.3 Viewing extracted SQL for packages and plans -- 6.2.4 Alter table enhancements -- 6.2.5 Alter and add partitions -- 6.2.6 Rotate partitions -- 6.2.7 Materialized query tables -- 6.2.8 Sequence objects -- 6.3 DB2 Object Comparison Tool -- 6.3.1 Alter Table Alter Column -- 6.3.2 Alter a partitioned table -- Appendix A. Sample work statement list -- Appendix B. Working with a copy of DB2 system catalog -- B.1 ADBCUST job - 1 step -- B.2 ADBCATVT job - 2 step -- B.3 DDLBNDxx job - 3 step -- B.4 CPYRUNxx job - 4 step -- B.5 Run ALIBNDxx for distributed system -- Appendix C. Current maintenance -- C.1 Maintenance for DB2 administration tools -- Appendix D. Sample JCL for a Restore Job -- Abbreviations and acronyms -- Related publications -- IBM Redbooks -- Other publications -- Online resources -- How to get IBM Redbooks -- Help from IBM -- Index -- Back cover. |
| Record Nr. | UNINA-9910816215403321 |
| San Jose, CA, : IBM Corp., International Technical Support Organization, c2005 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Advanced SQL, 1999 [electronic resource] : understanding object-relational and other advanced features / Jim Melton
| Advanced SQL, 1999 [electronic resource] : understanding object-relational and other advanced features / Jim Melton |
| Autore | Melton, Jim, 1946- |
| Pubbl/distr/stampa | Amsterdam ; Boston, Mass. : Morgan Kaufmann Pub., c2003. |
| Descrizione fisica | xxviii, 563 p. : ill. ; 24 cm. |
| Disciplina | 005.75/65 |
| Collana | The Morgan Kaufmann series in data management systems |
| Soggetto topico |
SQL (Computer program language)
Object-oriented programming (Computer science) Relational databases |
| Soggetto genere / forma | Electronic books. |
| ISBN |
9781558606777
1558606777 |
| Formato | Risorse elettroniche  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | Introduction to SQL:1999. User-Defined Types. Typed Tables. Routines and Routine Invocation. Foreign Servers and Foreign-Data Wrappers. Datalinks. OLAP. SQL/OLB and SQL/JRT. SQL/XML. SQL Multimedia and Application Package. A Look To The Future. Appendix: An SQL:1999 Example Using UDTs. The SQL:1999 Annexes. Relevant Standards Bodies. Status Codes. The SQL Standardization Process. |
| Record Nr. | UNISALENTO-991003248429707536 |
Melton, Jim, 1946-
|
||
| Amsterdam ; Boston, Mass. : Morgan Kaufmann Pub., c2003. | ||
| Risorse elettroniche | ||
| Lo trovi qui: Univ. del Salento | ||
| ||
Beginning SQL [[electronic resource] /] / Paul Wilton and John W. Colby
| Beginning SQL [[electronic resource] /] / Paul Wilton and John W. Colby |
| Autore | Wilton Paul <1969-> |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Indianapolis, IN, : Wiley, c2005 |
| Descrizione fisica | 1 online resource (521 p.) |
| Disciplina | 005.75/65 |
| Altri autori (Persone) | ColbyJohn W. <1954-> |
| Collana | Wrox beginning guides. |
| Soggetto topico | SQL (Computer program language) |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-280-25346-0
9786610253463 0-7645-9632-2 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| 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 |
| Record Nr. | UNINA-9910457711903321 |
|
Wilton Paul <1969->
|
||
| Indianapolis, IN, : Wiley, c2005 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
