¿Ü±¹µµ¼
ÄÄÇ»ÅÍ
ÀÎÅͳÝ/À¥ °³¹ß
2013³â 9¿ù 9ÀÏ ÀÌÈÄ ´©Àû¼öÄ¡ÀÔ´Ï´Ù.
Á¤°¡ |
38,000¿ø |
---|
30,400¿ø (20%ÇÒÀÎ)
920P (3%Àû¸³)
ÇÒÀÎÇýÅÃ | |
---|---|
Àû¸³ÇýÅà |
|
|
|
Ãß°¡ÇýÅÃ |
|
À̺¥Æ®/±âȹÀü
¿¬°üµµ¼
»óÇ°±Ç
ÀÌ»óÇ°ÀÇ ºÐ·ù
¸ñÂ÷
Acknowledgments | p. xix |
Introduction | p. xxi |
SQL Server: Basic Concepts | |
Database Systems and SQL Server | p. 3 |
Database Systems: An Overview | p. 6 |
Relational Database Systems | p. 9 |
SQL: A Relational Database Language | p. 12 |
Database Design | p. 14 |
Conclusion | p. 20 |
Overview of Microsoft SQL Server | p. 20 |
Exercises | p. 21 |
SQL Server Management Studio | p. 23 |
The SQL Server Program Group and Books Online | p. 24 |
Introduction to SQL Server Management Studio | p. 25 |
Conclusion | p. 44 |
Exercises | p. 44 |
Transact-SQL Language | |
SQL Components | p. 49 |
SQL's Basic Objects | p. 50 |
Data Types | p. 53 |
Predicates | p. 59 |
Aggregate Functions | p. 60 |
Scalar Functions | p. 60 |
Scalar Operators | p. 67 |
Null Values | p. 69 |
Conclusion | p. 70 |
Exercises | p. 71 |
Data Definition Language | p. 73 |
Creating Database Objects | p. 74 |
Modifying Database Objects | p. 98 |
Removing Database Objects | p. 105 |
Conclusion | p. 106 |
Exercises | p. 106 |
Simple Queries | p. 111 |
Select Statement: A Basic Form | p. 112 |
Where Clause | p. 114 |
Simple Subqueries | p. 131 |
Group by Clause | p. 139 |
Aggregate Functions | p. 141 |
Having Clause | p. 149 |
Order by Clause | p. 150 |
Select Statement and Identity Property | p. 152 |
Set Operators | p. 154 |
Case Expressions | p. 159 |
Compute Clause | p. 161 |
Temporary Tables | p. 164 |
Computed Columns | p. 165 |
Conclusion | p. 166 |
Exercises | p. 166 |
Complex Queries | p. 169 |
Join Operator | p. 170 |
Correlated Subqueries | p. 187 |
Should You Use Join or Subqueries? | p. 193 |
Common Table Expressions | p. 195 |
Conclusion | p. 202 |
Exercises | p. 203 |
Modification of a Table's Contents | p. 205 |
Insert Statement | p. 206 |
Update Statement | p. 210 |
Delete Statement | p. 213 |
Conclusion | p. 215 |
Exercises | p. 216 |
Stored Procedures and User-Defined Functions | p. 217 |
SQL Extensions | p. 218 |
Stored Procedures | p. 225 |
User-Defined Functions | p. 237 |
Conclusion | p. 243 |
Exercises | p. 243 |
Indices and Query Optimization | p. 245 |
Indices | p. 246 |
General Criteria to Improve Efficiency | p. 260 |
Query Optimizer | p. 265 |
The DBCC Command and Indices | p. 278 |
Conclusion | p. 280 |
Exercises | p. 280 |
Views | p. 283 |
DDL Statements and Views | p. 284 |
DML Statements and Views | p. 291 |
Indexed Views | p. 298 |
Conclusion | p. 305 |
Exercises | p. 305 |
System Catalog | p. 307 |
System Tables | p. 308 |
Catalog Views | p. 311 |
Querying Catalog Views | p. 313 |
Other Ways to Access System Information | p. 315 |
Conclusion | p. 323 |
Exercises | p. 324 |
SQL Server Security | p. 325 |
Authentication | p. 326 |
Schema | p. 332 |
Database Security | p. 336 |
Roles | p. 340 |
Authorization | p. 351 |
Views and Data Access | p. 359 |
Stored Procedures and Data Access | p. 360 |
Conclusion | p. 361 |
Exercises | p. 362 |
Triggers | p. 365 |
Introduction | p. 366 |
How Triggers Work | p. 366 |
Triggers and CLR | p. 376 |
The OUTPUT Clause | p. 381 |
Modifying Trigger's Structure | p. 383 |
Conclusion | p. 383 |
Exercises | p. 384 |
Transactions | p. 385 |
Introduction | p. 386 |
Transact-SQL Statements and Transactions | p. 387 |
Locking | p. 391 |
Isolation Levels | p. 397 |
Deadlock | p. 401 |
Conclusion | p. 402 |
Exercises | p. 402 |
SQL Server System Environment | p. 405 |
Disk Storage | p. 406 |
System Databases | p. 410 |
Utilities | p. 411 |
Instances of SQL Server | p. 416 |
Unicode | p. 418 |
SQL Server Architecture | p. 419 |
Conclusion | p. 423 |
Exercises | p. 423 |
SQL Server: System Administration | |
Overview of System Administration | p. 427 |
Administration Tools | p. 428 |
System Administrator | p. 431 |
Conclusion | p. 432 |
Planning the Installation and Installing SQL Server | p. 433 |
Planning the Installation | p. 434 |
Installing SQL Server | p. 437 |
Configuring SQL Server After Installation | p. 445 |
Starting and Stopping an Instance of SQL Server | p. 446 |
Conclusion | p. 448 |
Managing Databases and Database Files | p. 449 |
Managing Filegroups | p. 450 |
Managing Databases | p. 452 |
Managing Transaction Logs | p. 458 |
Conclusion | p. 459 |
Exercises | p. 459 |
Managing Security | p. 461 |
Introduction | p. 462 |
Database Security Permissions | p. 465 |
Managing Permissions | p. 468 |
Conclusion | p. 471 |
Exercises | p. 471 |
Backup and Recovery | p. 473 |
Introduction | p. 474 |
Backup | p. 475 |
Performing Backup | p. 478 |
Recovery | p. 491 |
Conclusion | p. 504 |
Exercises | p. 504 |
Automating System Administration Tasks | p. 507 |
Introduction | p. 508 |
SQL Server Agent | p. 509 |
Creating Jobs and Operators | p. 510 |
Alerts | p. 517 |
Conclusion | p. 524 |
Exercises | p. 525 |
Performance and Tuning | p. 527 |
Introduction | p. 528 |
Factors that Affect Performance | p. 529 |
Monitoring Tools | p. 538 |
Choose the Right Tool | p. 548 |
Data Partitioning | p. 557 |
Introduction | p. 558 |
Steps for Creating Partitioned Tables | p. 559 |
Guidelines for Partitioning Tables and Indices | p. 566 |
Conclusion | p. 566 |
Data Replication | p. 569 |
Distributed Data | p. 570 |
SQL Server Replication-An Overview | p. 572 |
Managing Replication | p. 580 |
Conclusion | p. 584 |
Exercises | p. 585 |
Microsoft Analysis Services | |
Data Warehousing: An Introduction | p. 589 |
Online Transaction Processing vs. Data Warehousing | p. 590 |
Data Warehouses and Data Marts | p. 592 |
Data Warehouse Design | p. 595 |
Cubes and Storage Modes | p. 598 |
Aggregation | p. 600 |
Data Access | p. 602 |
Conclusion | p. 603 |
Exercises | p. 603 |
Microsoft Analysis Services | p. 605 |
BI Development Studio | p. 607 |
Analysis Services and Cubes | p. 612 |
Conclusion | p. 619 |
Business Intelligence and SQL | p. 621 |
OLAP Extensions in Transact-SQL | p. 622 |
Conclusion | p. 637 |
Microsoft Reporting Services | p. 639 |
Introduction | p. 640 |
Creating Reports | p. 642 |
Processing and Managing Reports | p. 652 |
Accessing and Delivering Reports | p. 653 |
Conclusion | p. 656 |
Exercises | p. 656 |
XML Support | |
Overview of XML | p. 659 |
World Wide Web | p. 660 |
XML and Related Languages | p. 661 |
Document Type Definitions | p. 665 |
Conclusion | p. 668 |
SQL Server 2005 and XML | p. 669 |
Storing XML in Relational Databases | p. 670 |
The XML Data Type | p. 671 |
Constructing XML Documents Using the For XML Clause | p. 678 |
XML Query Languages | p. 685 |
Conclusion | p. 686 |
Index | p. 687 |
Table of Contents provided by Ingram. All Rights Reserved. |
ÀúÀÚ¼Ò°³
»ý³â¿ùÀÏ | - |
---|
ÇØ´çÀÛ°¡¿¡ ´ëÇÑ ¼Ò°³°¡ ¾ø½À´Ï´Ù.
ÁÖ°£·©Å·
´õº¸±â»óÇ°Á¤º¸Á¦°ø°í½Ã
À̺¥Æ® ±âȹÀü
ÄÄÇ»ÅÍ ºÐ¾ß¿¡¼ ¸¹Àº ȸ¿øÀÌ ±¸¸ÅÇÑ Ã¥
ÆǸÅÀÚÁ¤º¸
»óÈ£ |
(ÁÖ)±³º¸¹®°í |
---|---|
´ëÇ¥ÀÚ¸í |
¾Èº´Çö |
»ç¾÷ÀÚµî·Ï¹øÈ£ |
102-81-11670 |
¿¬¶ôó |
1544-1900 |
ÀüÀÚ¿ìÆíÁÖ¼Ò |
callcenter@kyobobook.co.kr |
Åë½ÅÆǸž÷½Å°í¹øÈ£ |
01-0653 |
¿µ¾÷¼ÒÀçÁö |
¼¿ïƯº°½Ã Á¾·Î±¸ Á¾·Î 1(Á¾·Î1°¡,±³º¸ºôµù) |
±³È¯/ȯºÒ
¹ÝÇ°/±³È¯ ¹æ¹ý |
¡®¸¶ÀÌÆäÀÌÁö > Ãë¼Ò/¹ÝÇ°/±³È¯/ȯºÒ¡¯ ¿¡¼ ½Åû ¶Ç´Â 1:1 ¹®ÀÇ °Ô½ÃÆÇ ¹× °í°´¼¾ÅÍ(1577-2555)¿¡¼ ½Åû °¡´É |
---|---|
¹ÝÇ°/±³È¯°¡´É ±â°£ |
º¯½É ¹ÝÇ°ÀÇ °æ¿ì Ãâ°í¿Ï·á ÈÄ 6ÀÏ(¿µ¾÷ÀÏ ±âÁØ) À̳»±îÁö¸¸ °¡´É |
¹ÝÇ°/±³È¯ ºñ¿ë |
º¯½É ȤÀº ±¸¸ÅÂø¿À·Î ÀÎÇÑ ¹ÝÇ°/±³È¯Àº ¹Ý¼Û·á °í°´ ºÎ´ã |
¹ÝÇ°/±³È¯ ºÒ°¡ »çÀ¯ |
·¼ÒºñÀÚÀÇ Ã¥ÀÓ ÀÖ´Â »çÀ¯·Î »óÇ° µîÀÌ ¼Õ½Ç ¶Ç´Â ÈÑ¼ÕµÈ °æ¿ì ·¼ÒºñÀÚÀÇ »ç¿ë, Æ÷Àå °³ºÀ¿¡ ÀÇÇØ »óÇ° µîÀÇ °¡Ä¡°¡ ÇöÀúÈ÷ °¨¼ÒÇÑ °æ¿ì ·º¹Á¦°¡ °¡´ÉÇÑ »óÇ° µîÀÇ Æ÷ÀåÀ» ÈѼÕÇÑ °æ¿ì ·½Ã°£ÀÇ °æ°ú¿¡ ÀÇÇØ ÀçÆǸŰ¡ °ï¶õÇÑ Á¤µµ·Î °¡Ä¡°¡ ÇöÀúÈ÷ °¨¼ÒÇÑ °æ¿ì ·ÀüÀÚ»ó°Å·¡ µî¿¡¼ÀÇ ¼ÒºñÀÚº¸È£¿¡ °üÇÑ ¹ý·üÀÌ Á¤ÇÏ´Â ¼ÒºñÀÚ Ã»¾àöȸ Á¦ÇÑ ³»¿ë¿¡ ÇØ´çµÇ´Â °æ¿ì |
»óÇ° Ç°Àý |
°ø±Þ»ç(ÃâÆÇ»ç) Àç°í »çÁ¤¿¡ ÀÇÇØ Ç°Àý/Áö¿¬µÉ ¼ö ÀÖÀ½ |
¼ÒºñÀÚ ÇÇÇغ¸»ó |
·»óÇ°ÀÇ ºÒ·®¿¡ ÀÇÇÑ ±³È¯, A/S, ȯºÒ, Ç°Áúº¸Áõ ¹× ÇÇÇغ¸»ó µî¿¡ °üÇÑ »çÇ×Àº¼ÒºñÀÚºÐÀïÇØ°á ±âÁØ (°øÁ¤°Å·¡À§¿øȸ °í½Ã)¿¡ ÁØÇÏ¿© ó¸®µÊ ·´ë±Ý ȯºÒ ¹× ȯºÒÁö¿¬¿¡ µû¸¥ ¹è»ó±Ý Áö±Þ Á¶°Ç, ÀýÂ÷ µîÀº ÀüÀÚ»ó°Å·¡ µî¿¡¼ÀǼҺñÀÚ º¸È£¿¡ °üÇÑ ¹ý·ü¿¡ µû¶ó ó¸®ÇÔ |
(ÁÖ)ÀÎÅÍÆÄÅ©Ä¿¸Ó½º´Â ȸ¿ø´ÔµéÀÇ ¾ÈÀü°Å·¡¸¦ À§ÇØ ±¸¸Å±Ý¾×, °áÁ¦¼ö´Ü¿¡ »ó°ü¾øÀÌ (ÁÖ)ÀÎÅÍÆÄÅ©Ä¿¸Ó½º¸¦ ÅëÇÑ ¸ðµç °Å·¡¿¡ ´ëÇÏ¿©
(ÁÖ)KGÀ̴Ͻýº°¡ Á¦°øÇÏ´Â ±¸¸Å¾ÈÀü¼ºñ½º¸¦ Àû¿ëÇÏ°í ÀÖ½À´Ï´Ù.
¹è¼Û¾È³»
±³º¸¹®°í »óÇ°Àº Åùè·Î ¹è¼ÛµÇ¸ç, Ãâ°í¿Ï·á 1~2Àϳ» »óÇ°À» ¹Þ¾Æ º¸½Ç ¼ö ÀÖ½À´Ï´Ù.
Ãâ°í°¡´É ½Ã°£ÀÌ ¼·Î ´Ù¸¥ »óÇ°À» ÇÔ²² ÁÖ¹®ÇÒ °æ¿ì Ãâ°í°¡´É ½Ã°£ÀÌ °¡Àå ±ä »óÇ°À» ±âÁØÀ¸·Î ¹è¼ÛµË´Ï´Ù.
±ººÎ´ë, ±³µµ¼Ò µî ƯÁ¤±â°üÀº ¿ìü±¹ Åù踸 ¹è¼Û°¡´ÉÇÕ´Ï´Ù.
¹è¼Ûºñ´Â ¾÷ü ¹è¼Ûºñ Á¤Ã¥¿¡ µû¸¨´Ï´Ù.