Introduction to database management:
Saved in:
| Format: | Book |
|---|---|
| Language: | English |
| Published: |
Hoboken, NJ
Wiley
2008
|
| Series: | Wiley pathways
|
| Subjects: | |
| Online Access: | Inhaltsverzeichnis |
| Item Description: | Angekündigt u.d.T.: Introduction to databases |
| Physical Description: | XXV, 478 S. Ill., graph. Darst. |
| ISBN: | 9780470101865 |
Staff View
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV022273455 | ||
| 003 | DE-604 | ||
| 005 | 20071121 | ||
| 007 | t | ||
| 008 | 070215s2008 ad|| |||| 00||| eng d | ||
| 020 | |a 9780470101865 |9 978-0-470-10186-5 | ||
| 035 | |a (OCoLC)127103536 | ||
| 035 | |a (DE-599)BVBBV022273455 | ||
| 040 | |a DE-604 |b ger |e rakwb | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-703 |a DE-20 | ||
| 050 | 0 | |a QA76.9.D3 | |
| 082 | 0 | |a 005.74 |2 22 | |
| 084 | |a ST 270 |0 (DE-625)143638: |2 rvk | ||
| 245 | 1 | 0 | |a Introduction to database management |c Mark L. Gillenson ... |
| 246 | 1 | 3 | |a Introduction to databases |
| 246 | 1 | 3 | |a Database management |
| 264 | 1 | |a Hoboken, NJ |b Wiley |c 2008 | |
| 300 | |a XXV, 478 S. |b Ill., graph. Darst. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 490 | 0 | |a Wiley pathways | |
| 500 | |a Angekündigt u.d.T.: Introduction to databases | ||
| 650 | 4 | |a Database management | |
| 650 | 0 | 7 | |a Datenbankverwaltung |0 (DE-588)4389357-0 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a Datenbankverwaltung |0 (DE-588)4389357-0 |D s |
| 689 | 0 | |5 DE-604 | |
| 700 | 1 | |a Gillenson, Mark L. |e Sonstige |4 oth | |
| 856 | 4 | 2 | |m HBZ Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=015483882&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-015483882 | ||
Record in the Search Index
| _version_ | 1804136278770319360 |
|---|---|
| adam_text | 1 Introduction to Data and Data Management
1.1 Identifying Business Data 2
1.2 Identifying Human Data Sources 4
1.3 Installing SQL Server 2005 Evaluation Edition 5
1.4 Learning About SQL Server Management Studio 12
1.5 Identifying Key Management Areas 19
2 Introducing Databases and Database Management Systems
2.1 Comparing Database Models 21
2.2 Identifying DBMS Architecture and Components 23
2.3 Reviewing Server Hardware Resources 24
2.4 Investigating SQL Server Databases 32
2.5 Identifying Application Requirements 35
3 Data Modeling
3.1 Understanding Data Modeling Concepts 39
3.2 Recognizing Entities, Attributes, and Identifiers 40
3.3 Recognizing Relationships and Business Rules 42
3.4 Reading an ERD 45
3.5 Creating an ERD 47
3.6 Viewing Basic Database Objects 50
V
4 Designing a Database
4.1 Understanding Key Concepts 59
4.2 Converting Relationships 60
4.3 Reviewing a Normalized Database 65
4.4 Recognizing Normalization Errors 69
4.5 Normalizing Data 73
5 Implementing a Database
5.1 Understanding Terms and Concepts 78
5.2 Identifying Solution Requirements 79
5.3 Creating a Database 84
5.4 Creating Tables, Part 1 88
5.5 Setting Table Constraints 91
5.6 Creating Tables, Part 2 96
6 Understanding the SQL Language
6.1 Understanding Terms and Concepts 102
6.2 Identifying Help Resources 104
6.3 Comparing Command Environments 111
6.4 Using the SELECT Command 116
6.5 Using DDL Commands 121
6.6 Using DML Commands 126
7 Data Access and Manipulation
7.1 Understanding Data Access 132
7.2 Retrieving Data 133
7.3 Using Advanced Data Retrieval 138
7.4 Using Batches and Scripts 141
7.5 Recognizing and Correcting Syntax Errors 144
8 Improving Data Access
8.1 Understanding Database Monitoring and Optimization 149
8.2 Investigating Resources and Configuration Settings 151
8.3 Monitoring Performance 163
8.4 Recognizing Bottlenecks 172
8.5 Using Indexes and Views 175
8.6 Using Procedures and Functions 179
9 Database Administration
9.1 Understanding Administration 184
9.2 Understanding Roles and Responsibilities 186
9.3 Matching Life Cycle Requirements 188
9.4 Resolving Administration Issues 190
9.5 Managing As Needed and Periodic Tasks 196
vii
10 Transactions and Locking
10.1 Understanding Transactions and Locking 210
10.2 Understanding Transaction Types 212
10.3 Understanding Transaction Isolation and Locking 219
10.4 Using Transactions 226
10.5 Monitoring Transactions and Clearing Blocked Transactions....231
11 Data Access and Security
11.1 Understanding Data Access and Security 236
11.2 Designing for Access and Security 238
11.3 Understanding Your Security Environment 242
11.4 Managing Security Principals 249
11.5 Managing Permissions 255
11.6 Managing Backups 263
12 Supporting Database Applications
12.1 Understanding Data Configurations 267
12.2 Designing Data Environments 269
12.3 Working in a Distributed Environment 277
12.4 Using Distributed Queries 284
12.5 Using Replication 291
12.6 Understanding Data Issues 299
|
| adam_txt |
1 Introduction to Data and Data Management
1.1 Identifying Business Data 2
1.2 Identifying Human Data Sources 4
1.3 Installing SQL Server 2005 Evaluation Edition 5
1.4 Learning About SQL Server Management Studio 12
1.5 Identifying Key Management Areas 19
2 Introducing Databases and Database Management Systems
2.1 Comparing Database Models 21
2.2 Identifying DBMS Architecture and Components 23
2.3 Reviewing Server Hardware Resources 24
2.4 Investigating SQL Server Databases 32
2.5 Identifying Application Requirements 35
3 Data Modeling
3.1 Understanding Data Modeling Concepts 39
3.2 Recognizing Entities, Attributes, and Identifiers 40
3.3 Recognizing Relationships and Business Rules 42
3.4 Reading an ERD 45
3.5 Creating an ERD 47
3.6 Viewing Basic Database Objects 50
V
4 Designing a Database
4.1 Understanding Key Concepts 59
4.2 Converting Relationships 60
4.3 Reviewing a Normalized Database 65
4.4 Recognizing Normalization Errors 69
4.5 Normalizing Data 73
5 Implementing a Database
5.1 Understanding Terms and Concepts 78
5.2 Identifying Solution Requirements 79
5.3 Creating a Database 84
5.4 Creating Tables, Part 1 88
5.5 Setting Table Constraints 91
5.6 Creating Tables, Part 2 96
6 Understanding the SQL Language
6.1 Understanding Terms and Concepts 102
6.2 Identifying Help Resources 104
6.3 Comparing Command Environments 111
6.4 Using the SELECT Command 116
6.5 Using DDL Commands 121
6.6 Using DML Commands 126
7 Data Access and Manipulation
7.1 Understanding Data Access 132
7.2 Retrieving Data 133
7.3 Using Advanced Data Retrieval 138
7.4 Using Batches and Scripts 141
7.5 Recognizing and Correcting Syntax Errors 144
8 Improving Data Access
8.1 Understanding Database Monitoring and Optimization 149
8.2 Investigating Resources and Configuration Settings 151
8.3 Monitoring Performance 163
8.4 Recognizing Bottlenecks 172
8.5 Using Indexes and Views 175
8.6 Using Procedures and Functions 179
9 Database Administration
9.1 Understanding Administration 184
9.2 Understanding Roles and Responsibilities 186
9.3 Matching Life Cycle Requirements 188
9.4 Resolving Administration Issues 190
9.5 Managing "As Needed" and Periodic Tasks 196
vii
10 Transactions and Locking
10.1 Understanding Transactions and Locking 210
10.2 Understanding Transaction Types 212
10.3 Understanding Transaction Isolation and Locking 219
10.4 Using Transactions 226
10.5 Monitoring Transactions and Clearing Blocked Transactions.231
11 Data Access and Security
11.1 Understanding Data Access and Security 236
11.2 Designing for Access and Security 238
11.3 Understanding Your Security Environment 242
11.4 Managing Security Principals 249
11.5 Managing Permissions 255
11.6 Managing Backups 263
12 Supporting Database Applications
12.1 Understanding Data Configurations 267
12.2 Designing Data Environments 269
12.3 Working in a Distributed Environment 277
12.4 Using Distributed Queries 284
12.5 Using Replication 291
12.6 Understanding Data Issues 299 |
| any_adam_object | 1 |
| any_adam_object_boolean | 1 |
| building | Verbundindex |
| bvnumber | BV022273455 |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.9.D3 |
| callnumber-search | QA76.9.D3 |
| callnumber-sort | QA 276.9 D3 |
| callnumber-subject | QA - Mathematics |
| classification_rvk | ST 270 |
| ctrlnum | (OCoLC)127103536 (DE-599)BVBBV022273455 |
| dewey-full | 005.74 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.74 |
| dewey-search | 005.74 |
| dewey-sort | 15.74 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| discipline_str_mv | Informatik |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01432nam a2200397 c 4500</leader><controlfield tag="001">BV022273455</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20071121 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">070215s2008 ad|| |||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780470101865</subfield><subfield code="9">978-0-470-10186-5</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)127103536</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV022273455</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rakwb</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-703</subfield><subfield code="a">DE-20</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">QA76.9.D3</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.74</subfield><subfield code="2">22</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 270</subfield><subfield code="0">(DE-625)143638:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Introduction to database management</subfield><subfield code="c">Mark L. Gillenson ...</subfield></datafield><datafield tag="246" ind1="1" ind2="3"><subfield code="a">Introduction to databases</subfield></datafield><datafield tag="246" ind1="1" ind2="3"><subfield code="a">Database management</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Hoboken, NJ</subfield><subfield code="b">Wiley</subfield><subfield code="c">2008</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XXV, 478 S.</subfield><subfield code="b">Ill., graph. Darst.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="0" ind2=" "><subfield code="a">Wiley pathways</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Angekündigt u.d.T.: Introduction to databases</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Database management</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Datenbankverwaltung</subfield><subfield code="0">(DE-588)4389357-0</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Datenbankverwaltung</subfield><subfield code="0">(DE-588)4389357-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Gillenson, Mark L.</subfield><subfield code="e">Sonstige</subfield><subfield code="4">oth</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HBZ Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=015483882&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-015483882</subfield></datafield></record></collection> |
| id | DE-604.BV022273455 |
| illustrated | Illustrated |
| index_date | 2024-07-02T16:46:52Z |
| indexdate | 2024-07-09T20:53:52Z |
| institution | BVB |
| isbn | 9780470101865 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-015483882 |
| oclc_num | 127103536 |
| open_access_boolean | |
| owner | DE-703 DE-20 |
| owner_facet | DE-703 DE-20 |
| physical | XXV, 478 S. Ill., graph. Darst. |
| publishDate | 2008 |
| publishDateSearch | 2008 |
| publishDateSort | 2008 |
| publisher | Wiley |
| record_format | marc |
| series2 | Wiley pathways |
| spelling | Introduction to database management Mark L. Gillenson ... Introduction to databases Database management Hoboken, NJ Wiley 2008 XXV, 478 S. Ill., graph. Darst. txt rdacontent n rdamedia nc rdacarrier Wiley pathways Angekündigt u.d.T.: Introduction to databases Datenbankverwaltung (DE-588)4389357-0 gnd rswk-swf Datenbankverwaltung (DE-588)4389357-0 s DE-604 Gillenson, Mark L. Sonstige oth HBZ Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=015483882&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Introduction to database management Database management Datenbankverwaltung (DE-588)4389357-0 gnd |
| subject_GND | (DE-588)4389357-0 |
| title | Introduction to database management |
| title_alt | Introduction to databases Database management |
| title_auth | Introduction to database management |
| title_exact_search | Introduction to database management |
| title_exact_search_txtP | Introduction to database management |
| title_full | Introduction to database management Mark L. Gillenson ... |
| title_fullStr | Introduction to database management Mark L. Gillenson ... |
| title_full_unstemmed | Introduction to database management Mark L. Gillenson ... |
| title_short | Introduction to database management |
| title_sort | introduction to database management |
| topic | Database management Datenbankverwaltung (DE-588)4389357-0 gnd |
| topic_facet | Database management Datenbankverwaltung |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=015483882&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT gillensonmarkl introductiontodatabasemanagement AT gillensonmarkl introductiontodatabases AT gillensonmarkl databasemanagement |