Microsoft SQL Server to IBM DB2 UDB conversion guide [[electronic resource] /] / Whei-Jen Chen ... [et al.] |
Edizione | [1st ed.] |
Pubbl/distr/stampa | San Jose, CA, : IBM Corp., International Technical Support Organization, 2005 |
Descrizione fisica | xxviii, 524 p. : ill |
Disciplina | 005.75/85 |
Collana | Redbooks |
Soggetto topico |
Database management
Software maintenance |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Record Nr. | UNINA-9910816468603321 |
San Jose, CA, : IBM Corp., International Technical Support Organization, 2005 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Modernizing IBM eserver iSeries application data access [[electronic resource] ] : a roadmap cornerstone |
Edizione | [1st ed.] |
Pubbl/distr/stampa | Rochester, MN, : IBM, International Technical Support Organization, 2005 |
Descrizione fisica | xii, 262 p. : ill |
Disciplina | 005.75/85 |
Collana | IBM redbooks |
Soggetto topico |
Database management
IBM computers |
Soggetto genere / forma | Electronic books. |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Record Nr. | UNINA-9910449701203321 |
Rochester, MN, : IBM, International Technical Support Organization, 2005 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Modernizing IBM eserver iSeries application data access [[electronic resource] ] : a roadmap cornerstone |
Edizione | [1st ed.] |
Pubbl/distr/stampa | Rochester, MN, : IBM, International Technical Support Organization, 2005 |
Descrizione fisica | xii, 262 p. : ill |
Disciplina | 005.75/85 |
Collana | IBM redbooks |
Soggetto topico |
Database management
IBM computers |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Record Nr. | UNINA-9910783562903321 |
Rochester, MN, : IBM, International Technical Support Organization, 2005 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Modernizing IBM eserver iSeries application data access [[electronic resource] ] : a roadmap cornerstone |
Edizione | [1st ed.] |
Pubbl/distr/stampa | Rochester, MN, : IBM, International Technical Support Organization, 2005 |
Descrizione fisica | xii, 262 p. : ill |
Disciplina | 005.75/85 |
Collana | IBM redbooks |
Soggetto topico |
Database management
IBM computers |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Record Nr. | UNINA-9910823732403321 |
Rochester, MN, : IBM, International Technical Support Organization, 2005 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
OCA/OCP [[electronic resource] ] : introduction to Oracle9i SQL : study guide / / Chip Dawes, Biju Thomas |
Autore | Dawes Chip |
Edizione | [1st ed.] |
Pubbl/distr/stampa | San Francisco, CA, : Sybex, 2002 |
Descrizione fisica | 1 online resource (611 p.) |
Disciplina | 005.75/85 |
Altri autori (Persone) | ThomasBiju |
Soggetto topico |
Electronic data processing personnel - Certification
Database management - Examinations SQL (Computer program language) |
Soggetto genere / forma | Electronic books. |
ISBN |
1-280-65252-7
9786610652525 0-585-47721-3 0-7821-5250-3 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
OCA/OCP: Introduction to Oracle9i SQL; Acknowledgments; Contents at a Glance; Contents; Introduction; Why Become an Oracle Certified Professional?; What Does This Book Cover?; How to Contact the Authors; Assessment Test; Answers to Assessment Test; Chapter 1: Basic SQL SELECT Statements; SQL Fundamentals; Writing Simple Queries; Other Operators; Sorting Rows; Using Expressions; Summary; Exam Essentials; Key Terms; Commands Used in This Chapter; Review Questions; Answers to Review Questions; Chapter 2: SQL*Plus Overview; SQL*Plus Fundamentals; Producing More Readable Output
Accepting Values at RuntimeUsing iSQL*Plus; Summary; Exam Essentials; Key Terms; Commands Used in This Chapter; Review Questions; Answers to Review Questions; Chapter 3: Single-Row Functions; Single-Row Function Fundamentals; NULLs and Single-Row Functions; Using Single-Row Character Functions; Using Single-Row Numeric Functions; Using Single-Row Date Functions; Using Single-Row Conversion Functions; Using Other Single-Row Functions; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 4: Aggregating Data And Group Functions; Group Function Fundamentals Using Group FunctionsNesting Functions; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 5: Joins and Subqueries; Multiple-Table Queries; Subqueries; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 6: Modifying Data; Using DML Statements; Inserting into Multiple Tables; Updating Rows in a Table; Merging Rows into a Table; Deleting Rows from a Table; Truncating a Table; Selecting Rows; Locking a Table; Understanding Transaction Control; Summary; Exam Essentials; Key Terms; Review Questions Answers to Review QuestionsChapter 7: Managing Tables and Constraints; Database Objects Review; Built-in Datatypes; Creating Tables; Modifying Tables; Managing Constraints; Creating Constraints; Dropping Constraints; Enabling and Disabling Constraints; Deferring Constraint Checks; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 8: Managing Views; Creating and Modifying Views; Using Views; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 9: Other Database Objects; Creating and Managing Sequences Creating and Managing SynonymsCreating and Managing Indexes; Calling Stored Programs; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 10: User Access and Security; Creating and Modifying User Accounts; Creating and Using Roles; Granting and Revoking Privileges; Managing User Groups with Profiles; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Index |
Record Nr. | UNINA-9910455215803321 |
Dawes Chip
![]() |
||
San Francisco, CA, : Sybex, 2002 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
OCA/OCP [[electronic resource] ] : introduction to Oracle9i SQL : study guide / / Chip Dawes, Biju Thomas |
Autore | Dawes Chip |
Edizione | [1st ed.] |
Pubbl/distr/stampa | San Francisco, CA, : Sybex, 2002 |
Descrizione fisica | 1 online resource (611 p.) |
Disciplina | 005.75/85 |
Altri autori (Persone) | ThomasBiju |
Soggetto topico |
Electronic data processing personnel - Certification
Database management - Examinations SQL (Computer program language) |
ISBN |
1-280-65252-7
9786610652525 0-585-47721-3 0-7821-5250-3 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
OCA/OCP: Introduction to Oracle9i SQL; Acknowledgments; Contents at a Glance; Contents; Introduction; Why Become an Oracle Certified Professional?; What Does This Book Cover?; How to Contact the Authors; Assessment Test; Answers to Assessment Test; Chapter 1: Basic SQL SELECT Statements; SQL Fundamentals; Writing Simple Queries; Other Operators; Sorting Rows; Using Expressions; Summary; Exam Essentials; Key Terms; Commands Used in This Chapter; Review Questions; Answers to Review Questions; Chapter 2: SQL*Plus Overview; SQL*Plus Fundamentals; Producing More Readable Output
Accepting Values at RuntimeUsing iSQL*Plus; Summary; Exam Essentials; Key Terms; Commands Used in This Chapter; Review Questions; Answers to Review Questions; Chapter 3: Single-Row Functions; Single-Row Function Fundamentals; NULLs and Single-Row Functions; Using Single-Row Character Functions; Using Single-Row Numeric Functions; Using Single-Row Date Functions; Using Single-Row Conversion Functions; Using Other Single-Row Functions; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 4: Aggregating Data And Group Functions; Group Function Fundamentals Using Group FunctionsNesting Functions; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 5: Joins and Subqueries; Multiple-Table Queries; Subqueries; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 6: Modifying Data; Using DML Statements; Inserting into Multiple Tables; Updating Rows in a Table; Merging Rows into a Table; Deleting Rows from a Table; Truncating a Table; Selecting Rows; Locking a Table; Understanding Transaction Control; Summary; Exam Essentials; Key Terms; Review Questions Answers to Review QuestionsChapter 7: Managing Tables and Constraints; Database Objects Review; Built-in Datatypes; Creating Tables; Modifying Tables; Managing Constraints; Creating Constraints; Dropping Constraints; Enabling and Disabling Constraints; Deferring Constraint Checks; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 8: Managing Views; Creating and Modifying Views; Using Views; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 9: Other Database Objects; Creating and Managing Sequences Creating and Managing SynonymsCreating and Managing Indexes; Calling Stored Programs; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 10: User Access and Security; Creating and Modifying User Accounts; Creating and Using Roles; Granting and Revoking Privileges; Managing User Groups with Profiles; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Index |
Record Nr. | UNINA-9910778843903321 |
Dawes Chip
![]() |
||
San Francisco, CA, : Sybex, 2002 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
OCA/OCP [[electronic resource] ] : introduction to Oracle9i SQL : study guide / / Chip Dawes, Biju Thomas |
Autore | Dawes Chip |
Edizione | [1st ed.] |
Pubbl/distr/stampa | San Francisco, CA, : Sybex, 2002 |
Descrizione fisica | 1 online resource (611 p.) |
Disciplina | 005.75/85 |
Altri autori (Persone) | ThomasBiju |
Soggetto topico |
Electronic data processing personnel - Certification
Database management - Examinations SQL (Computer program language) |
ISBN |
1-280-65252-7
9786610652525 0-585-47721-3 0-7821-5250-3 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
OCA/OCP: Introduction to Oracle9i SQL; Acknowledgments; Contents at a Glance; Contents; Introduction; Why Become an Oracle Certified Professional?; What Does This Book Cover?; How to Contact the Authors; Assessment Test; Answers to Assessment Test; Chapter 1: Basic SQL SELECT Statements; SQL Fundamentals; Writing Simple Queries; Other Operators; Sorting Rows; Using Expressions; Summary; Exam Essentials; Key Terms; Commands Used in This Chapter; Review Questions; Answers to Review Questions; Chapter 2: SQL*Plus Overview; SQL*Plus Fundamentals; Producing More Readable Output
Accepting Values at RuntimeUsing iSQL*Plus; Summary; Exam Essentials; Key Terms; Commands Used in This Chapter; Review Questions; Answers to Review Questions; Chapter 3: Single-Row Functions; Single-Row Function Fundamentals; NULLs and Single-Row Functions; Using Single-Row Character Functions; Using Single-Row Numeric Functions; Using Single-Row Date Functions; Using Single-Row Conversion Functions; Using Other Single-Row Functions; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 4: Aggregating Data And Group Functions; Group Function Fundamentals Using Group FunctionsNesting Functions; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 5: Joins and Subqueries; Multiple-Table Queries; Subqueries; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 6: Modifying Data; Using DML Statements; Inserting into Multiple Tables; Updating Rows in a Table; Merging Rows into a Table; Deleting Rows from a Table; Truncating a Table; Selecting Rows; Locking a Table; Understanding Transaction Control; Summary; Exam Essentials; Key Terms; Review Questions Answers to Review QuestionsChapter 7: Managing Tables and Constraints; Database Objects Review; Built-in Datatypes; Creating Tables; Modifying Tables; Managing Constraints; Creating Constraints; Dropping Constraints; Enabling and Disabling Constraints; Deferring Constraint Checks; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 8: Managing Views; Creating and Modifying Views; Using Views; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 9: Other Database Objects; Creating and Managing Sequences Creating and Managing SynonymsCreating and Managing Indexes; Calling Stored Programs; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 10: User Access and Security; Creating and Modifying User Accounts; Creating and Using Roles; Granting and Revoking Privileges; Managing User Groups with Profiles; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Index |
Record Nr. | UNINA-9910821802303321 |
Dawes Chip
![]() |
||
San Francisco, CA, : Sybex, 2002 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Oracle 10g/11g data and database management utilities [[electronic resource] ] : master twelve must-use utilities to optimize the efficiency, management, and performance of your daily database task / / Hector R. Madrid |
Autore | Madrid Hector R |
Pubbl/distr/stampa | Birmingham, U.K., : Packt Publishing Ltd., 2009 |
Descrizione fisica | 1 online resource (432 p.) |
Disciplina | 005.75/85 |
Collana | From technologies to solutions |
Soggetto topico |
Database management
Relational databases |
Soggetto genere / forma | Electronic books. |
ISBN |
1-282-17234-4
1-84719-629-2 9786612172342 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; Table of Contents; Preface; Chapter 1: Data Pump; Data Pump features; Data Pump architecture; Setting up the practical scenarios; Data Pump export; Data Pump export modes; A simple Data Pump export session; Data Pump export filtering operations; Use of parameter file; Retrieve original data; Data Pump export space estimation; Dump file multiplexing; Transporting data among different versions; Data Pump export interactive mode; Data Pump restart capability; Getting information about the export job; Data Pump import; Remap function; Data Pump import network mode
Improving performance with Data PumpWorking with the Data Pump API; Data Pump 11g new features; Compression; Encrypted dump file sets; Enhancements for Data Pump External Tables; Single partition transportable for Oracle Data Pump; Overwrite dump files; XML Datatypes; Summary; Chapter 2: SQL*Loader; SQL*Loader basics; Preparing the demo environment; Our first simple load; The SQL*Loader log file; Fixed record size format load; Variable record size format load; Stream record format load; Specifying a particular character set; Load on the fly; Direct path versus Conventional path load Direct path load prosDirect path load cons; Loading Large Objects (LOBs); Loading multimedia files; Resumable load; Parallel load; General performance booster tips; Summary; Chapter 3: External Tables; The External Table basics; Let's setup the environment; A basic External Table; Creating External Table metadata, the easy way; Unloading data to External Tables; Inter-version compatibility; Data transformation with External Tables; Extending the alert.log analysis with External Tables; Reading the listener.log from the database; Mapping XML files as External Tables Dynamically changing the external referenceOracle 11g External Table enhancements; Summary; Chapter 4: Recovery Manager Advanced Techniques; Recovery Manager basics; Getting started with a Recovery Manager session; Format masks used by recovery manager; What happens in a user-managed online backup?; Myths related to the online backup method; Configuring a multiplexed backup; Configuring the RMAN recovery catalog; A simple backup session; Backup compression; Fast backup compression; Improving data set compression with the ZLIB algorithm (11g only) Faster backups through intra-file parallel backup and restore operations (11g only)Block media recovery; Backup duration and throttling; Database cloning; Database cloning procedure; Database cloning on the fly (11g only); Inter-platform database migration; Migrate to and from an ASM environment; General backup advices; Summary; Chapter 5: Recovery Manager Restore and Recovery Techniques; Oracle database recovery; Instance failure; Media failure; Complete recovery; Incomplete recovery; Loss of data files; Queries used to diagnose data files; Loss of a non-critical datafile Loss of a temporary datafile |
Record Nr. | UNINA-9910456640303321 |
Madrid Hector R
![]() |
||
Birmingham, U.K., : Packt Publishing Ltd., 2009 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Oracle 10g/11g data and database management utilities [[electronic resource] ] : master twelve must-use utilities to optimize the efficiency, management, and performance of your daily database task / / Hector R. Madrid |
Autore | Madrid Hector R |
Pubbl/distr/stampa | Birmingham, U.K., : Packt Publishing Ltd., 2009 |
Descrizione fisica | 1 online resource (432 p.) |
Disciplina | 005.75/85 |
Collana | From technologies to solutions |
Soggetto topico |
Database management
Relational databases |
ISBN |
1-282-17234-4
1-84719-629-2 9786612172342 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; Table of Contents; Preface; Chapter 1: Data Pump; Data Pump features; Data Pump architecture; Setting up the practical scenarios; Data Pump export; Data Pump export modes; A simple Data Pump export session; Data Pump export filtering operations; Use of parameter file; Retrieve original data; Data Pump export space estimation; Dump file multiplexing; Transporting data among different versions; Data Pump export interactive mode; Data Pump restart capability; Getting information about the export job; Data Pump import; Remap function; Data Pump import network mode
Improving performance with Data PumpWorking with the Data Pump API; Data Pump 11g new features; Compression; Encrypted dump file sets; Enhancements for Data Pump External Tables; Single partition transportable for Oracle Data Pump; Overwrite dump files; XML Datatypes; Summary; Chapter 2: SQL*Loader; SQL*Loader basics; Preparing the demo environment; Our first simple load; The SQL*Loader log file; Fixed record size format load; Variable record size format load; Stream record format load; Specifying a particular character set; Load on the fly; Direct path versus Conventional path load Direct path load prosDirect path load cons; Loading Large Objects (LOBs); Loading multimedia files; Resumable load; Parallel load; General performance booster tips; Summary; Chapter 3: External Tables; The External Table basics; Let's setup the environment; A basic External Table; Creating External Table metadata, the easy way; Unloading data to External Tables; Inter-version compatibility; Data transformation with External Tables; Extending the alert.log analysis with External Tables; Reading the listener.log from the database; Mapping XML files as External Tables Dynamically changing the external referenceOracle 11g External Table enhancements; Summary; Chapter 4: Recovery Manager Advanced Techniques; Recovery Manager basics; Getting started with a Recovery Manager session; Format masks used by recovery manager; What happens in a user-managed online backup?; Myths related to the online backup method; Configuring a multiplexed backup; Configuring the RMAN recovery catalog; A simple backup session; Backup compression; Fast backup compression; Improving data set compression with the ZLIB algorithm (11g only) Faster backups through intra-file parallel backup and restore operations (11g only)Block media recovery; Backup duration and throttling; Database cloning; Database cloning procedure; Database cloning on the fly (11g only); Inter-platform database migration; Migrate to and from an ASM environment; General backup advices; Summary; Chapter 5: Recovery Manager Restore and Recovery Techniques; Oracle database recovery; Instance failure; Media failure; Complete recovery; Incomplete recovery; Loss of data files; Queries used to diagnose data files; Loss of a non-critical datafile Loss of a temporary datafile |
Record Nr. | UNINA-9910780786603321 |
Madrid Hector R
![]() |
||
Birmingham, U.K., : Packt Publishing Ltd., 2009 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Oracle 10g/11g data and database management utilities : master twelve must-use utilities to optimize the efficiency, management, and performance of your daily database task / / Hector R. Madrid |
Autore | Madrid Hector R |
Edizione | [1st ed.] |
Pubbl/distr/stampa | Birmingham, U.K., : Packt Publishing Ltd., 2009 |
Descrizione fisica | 1 online resource (432 p.) |
Disciplina | 005.75/85 |
Collana | From technologies to solutions |
Soggetto topico |
Database management
Relational databases |
ISBN |
1-282-17234-4
1-84719-629-2 9786612172342 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; Table of Contents; Preface; Chapter 1: Data Pump; Data Pump features; Data Pump architecture; Setting up the practical scenarios; Data Pump export; Data Pump export modes; A simple Data Pump export session; Data Pump export filtering operations; Use of parameter file; Retrieve original data; Data Pump export space estimation; Dump file multiplexing; Transporting data among different versions; Data Pump export interactive mode; Data Pump restart capability; Getting information about the export job; Data Pump import; Remap function; Data Pump import network mode
Improving performance with Data PumpWorking with the Data Pump API; Data Pump 11g new features; Compression; Encrypted dump file sets; Enhancements for Data Pump External Tables; Single partition transportable for Oracle Data Pump; Overwrite dump files; XML Datatypes; Summary; Chapter 2: SQL*Loader; SQL*Loader basics; Preparing the demo environment; Our first simple load; The SQL*Loader log file; Fixed record size format load; Variable record size format load; Stream record format load; Specifying a particular character set; Load on the fly; Direct path versus Conventional path load Direct path load prosDirect path load cons; Loading Large Objects (LOBs); Loading multimedia files; Resumable load; Parallel load; General performance booster tips; Summary; Chapter 3: External Tables; The External Table basics; Let's setup the environment; A basic External Table; Creating External Table metadata, the easy way; Unloading data to External Tables; Inter-version compatibility; Data transformation with External Tables; Extending the alert.log analysis with External Tables; Reading the listener.log from the database; Mapping XML files as External Tables Dynamically changing the external referenceOracle 11g External Table enhancements; Summary; Chapter 4: Recovery Manager Advanced Techniques; Recovery Manager basics; Getting started with a Recovery Manager session; Format masks used by recovery manager; What happens in a user-managed online backup?; Myths related to the online backup method; Configuring a multiplexed backup; Configuring the RMAN recovery catalog; A simple backup session; Backup compression; Fast backup compression; Improving data set compression with the ZLIB algorithm (11g only) Faster backups through intra-file parallel backup and restore operations (11g only)Block media recovery; Backup duration and throttling; Database cloning; Database cloning procedure; Database cloning on the fly (11g only); Inter-platform database migration; Migrate to and from an ASM environment; General backup advices; Summary; Chapter 5: Recovery Manager Restore and Recovery Techniques; Oracle database recovery; Instance failure; Media failure; Complete recovery; Incomplete recovery; Loss of data files; Queries used to diagnose data files; Loss of a non-critical datafile Loss of a temporary datafile |
Record Nr. | UNINA-9910818343603321 |
Madrid Hector R
![]() |
||
Birmingham, U.K., : Packt Publishing Ltd., 2009 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|