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.
Beginning SQL / / Paul Wilton and John W. Colby
| Beginning SQL / / 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) |
| ISBN |
9786610253463
9781280253461 1280253460 9780764596322 0764596322 |
| 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 |
| Altri titoli varianti | SQL |
| Record Nr. | UNINA-9910960359803321 |
Wilton Paul <1969->
|
||
| Indianapolis, IN, : Wiley, c2005 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Best damn Exchange, SQL and IIS book period [[electronic resource] /] / Conrad H. Agramont ... [et al.]
| Best damn Exchange, SQL and IIS book period [[electronic resource] /] / Conrad H. Agramont ... [et al.] |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Burlington, MA, : Syngress |
| Descrizione fisica | 1 online resource (1223 p.) |
| Disciplina |
005.446
005.71376 |
| Altri autori (Persone) | AgramontConrad H |
| Soggetto topico | Client/server computing |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-281-10011-0
9786611100117 0-08-055688-4 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Front Cover; The Best Damn Exchange, SQL and IIS Book Period; Copyright Page; Technical Editors; Contributing Authors; Contents; Chapter 1: Introducing Exchange Server 2007; Introduction; What Is Exchange Server 2007?; Exchange 2007 Themes; IT Pro Situation; Info Worker Situation; Organization wide Situation; Architectural Goals with Exchange Server 2007; Scalability; Role-Based Deployment and Server Roles; Mailbox Server Role; Client Access Server Role; Hub Transport Server Role; Unified Messaging Server Role; Auto Attendant; Call Answering; Fax Receiving; Subscriber Access
Edge Transport Server Role New Management Approach; EMC Console; Console Tree; Work Pane; Result Pane; Action Pane; Four New Work Centers; Organization Configuration Work Station; Exchange Server Best Practices Analyzer; Database Recovery Management; Database Troubleshooter; Mail Flow Troubleshooter; Message Tracking; Queue Viewer; Performance Monitor; Performance Troubleshooter; New Wizards; Exposed CMDlet Code; EMS; HA Improvements; LCR; CCR; Exchange Server 2007 Services; Exchange Server Permissions; Exchange Organization Administrators Group; Exchange Recipient Administrators Group Exchange Server Administrators Exchange View-Only Administrators Group; 64-Bit Support Only; Active Directory-Based Routing Topology; De-emphasized Features; Discontinued Features; Architecture Features; Recipient-related Features; Mobile Features; Outlook Web Access Features; Public Folder Features; Protocol Features; Connector Features; HA Features; Exchange 5.5-related Features; APIs and Development Features; Tools and Management Features; Summary; Chapter 2: Installing Exchange Server 2007; Introduction; Exchange 2007 Server Editions and CAL Types; Standard Edition; Enterprise Edition Exchange Server 2007 Client Access Licensing Standard CAL; Enterprise CAL; Exchange 2007 Prerequisites; Hardware Requirements; Processor; Memory; Disk Space; Drives; Software Requirements; Operating System; File Format; Software Required; Required Windows Components; Mailbox Server; Client Access Server; Hub Transport Server; Edge Transport Server; Unified Messaging Server; Server Requirements; Active Directory Requirements; Preparing the Active Directory Schema; Preparing the Active Directory; Preparing Any Additional Active Directory Domains in a Forest Installing Exchange 2007 Using the Setup Wizard Installing Exchange 2007 Using Unattended Setup; Verifying the Installation of Exchange Server 2007; Licensing an Exchange 2007 Server; Finalizing Deployment of Exchange Server 2007; Adding and Removing Exchange 2007 Server Roles; Uninstalling Exchange Server 2007; Summary; Solutions Fast Track; Frequently Asked Questions; Chapter 3: Managing Recipients in Exchange 2007; Introduction; Managing Recipients Using the Exchange 2007 Management Console; Managing Mailboxes; Creating a User Mailbox; Manipulating Mailboxes in Exchange 2007 Moving a Mailbox |
| Altri titoli varianti |
Exchange
SQL IIS |
| Record Nr. | UNINA-9910451166003321 |
| Burlington, MA, : Syngress | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Best damn Exchange, SQL and IIS book period [[electronic resource] /] / Conrad H. Agramont ... [et al.]
| Best damn Exchange, SQL and IIS book period [[electronic resource] /] / Conrad H. Agramont ... [et al.] |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Burlington, MA, : Syngress |
| Descrizione fisica | 1 online resource (1223 p.) |
| Disciplina |
005.446
005.71376 |
| Altri autori (Persone) | AgramontConrad H |
| Soggetto topico | Client/server computing |
| ISBN |
1-281-10011-0
9786611100117 0-08-055688-4 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Front Cover; The Best Damn Exchange, SQL and IIS Book Period; Copyright Page; Technical Editors; Contributing Authors; Contents; Chapter 1: Introducing Exchange Server 2007; Introduction; What Is Exchange Server 2007?; Exchange 2007 Themes; IT Pro Situation; Info Worker Situation; Organization wide Situation; Architectural Goals with Exchange Server 2007; Scalability; Role-Based Deployment and Server Roles; Mailbox Server Role; Client Access Server Role; Hub Transport Server Role; Unified Messaging Server Role; Auto Attendant; Call Answering; Fax Receiving; Subscriber Access
Edge Transport Server Role New Management Approach; EMC Console; Console Tree; Work Pane; Result Pane; Action Pane; Four New Work Centers; Organization Configuration Work Station; Exchange Server Best Practices Analyzer; Database Recovery Management; Database Troubleshooter; Mail Flow Troubleshooter; Message Tracking; Queue Viewer; Performance Monitor; Performance Troubleshooter; New Wizards; Exposed CMDlet Code; EMS; HA Improvements; LCR; CCR; Exchange Server 2007 Services; Exchange Server Permissions; Exchange Organization Administrators Group; Exchange Recipient Administrators Group Exchange Server Administrators Exchange View-Only Administrators Group; 64-Bit Support Only; Active Directory-Based Routing Topology; De-emphasized Features; Discontinued Features; Architecture Features; Recipient-related Features; Mobile Features; Outlook Web Access Features; Public Folder Features; Protocol Features; Connector Features; HA Features; Exchange 5.5-related Features; APIs and Development Features; Tools and Management Features; Summary; Chapter 2: Installing Exchange Server 2007; Introduction; Exchange 2007 Server Editions and CAL Types; Standard Edition; Enterprise Edition Exchange Server 2007 Client Access Licensing Standard CAL; Enterprise CAL; Exchange 2007 Prerequisites; Hardware Requirements; Processor; Memory; Disk Space; Drives; Software Requirements; Operating System; File Format; Software Required; Required Windows Components; Mailbox Server; Client Access Server; Hub Transport Server; Edge Transport Server; Unified Messaging Server; Server Requirements; Active Directory Requirements; Preparing the Active Directory Schema; Preparing the Active Directory; Preparing Any Additional Active Directory Domains in a Forest Installing Exchange 2007 Using the Setup Wizard Installing Exchange 2007 Using Unattended Setup; Verifying the Installation of Exchange Server 2007; Licensing an Exchange 2007 Server; Finalizing Deployment of Exchange Server 2007; Adding and Removing Exchange 2007 Server Roles; Uninstalling Exchange Server 2007; Summary; Solutions Fast Track; Frequently Asked Questions; Chapter 3: Managing Recipients in Exchange 2007; Introduction; Managing Recipients Using the Exchange 2007 Management Console; Managing Mailboxes; Creating a User Mailbox; Manipulating Mailboxes in Exchange 2007 Moving a Mailbox |
| Altri titoli varianti |
Exchange
SQL IIS |
| Record Nr. | UNINA-9910784712903321 |
| Burlington, MA, : Syngress | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||