Essential ClassNotes Intro to SQL Server Database System Study Notes, Review Questions and Classroom Discussion Topics 2013 (Paperback)


Information presented in class often contains the core concepts of the course. Yet, students frequently fail to master the skills of classroom notetaking. Our Essential ClassNotes products provide study notes that are specific and concrete. Review questions and classroom discussion topics are also included to make sure students are truly involved in the ideas and information being presented. CONTENT UPDATES2 ABOUT THIS BOOK2 SERVER MANAGEMENT AND ADMINISTRATION3 OVERVIEW3 SERVER LEVEL ROLES4 LOGINS AND CREDENTIALS7 MANAGEMENT STUDIO AND OTHER CONFIGURATION TOOLS11 THE DATABASE ENGINE17 TRANSACTION MODES19 LOCKS, LATCHES AND TRANSACTION ISOLATION LEVELS21 CHAPTER REVIEW QUESTIONS24 DATABASE DESIGN, MANAGEMENT AND ADMINISTRATION26 LOGICAL & PHYSICAL DESIGN26 PERFORMANCE TUNING29 THE SYSTEM DATABASES31 FILES AND FILEGROUPS35 SINGLE USER MODE38 TEMPORARY TABLES AND TABLE VARIABLES39 RESIZING A DATABASE41 MOVING DATABASES42 DETACH AND ATTACH43 CONTAINED DATABASES AND CONTAINED USERS45 BACKUP AND RECOVERY MODELS47 T-SQL STATEMENTS52 SELECT AND THE POSSIBLE OPTIONS54 COMPUTE AND THE POSSIBLE OPTIONS56 FOR AND THE POSSIBLE OPTIONS58 GROUP BY, HAVING AND THE POSSIBLE OPTIONS59 ORDER BY AND THE POSSIBLE OPTIONS60 CHAPTER REVIEW QUESTIONS61

R398

Or split into 4x interest-free payments of 25% on orders over R50
Learn more

Discovery Miles3980
Delivery AdviceShips in 10 - 15 working days


Toggle WishListAdd to wish list
Review this Item

Product Description

Information presented in class often contains the core concepts of the course. Yet, students frequently fail to master the skills of classroom notetaking. Our Essential ClassNotes products provide study notes that are specific and concrete. Review questions and classroom discussion topics are also included to make sure students are truly involved in the ideas and information being presented. CONTENT UPDATES2 ABOUT THIS BOOK2 SERVER MANAGEMENT AND ADMINISTRATION3 OVERVIEW3 SERVER LEVEL ROLES4 LOGINS AND CREDENTIALS7 MANAGEMENT STUDIO AND OTHER CONFIGURATION TOOLS11 THE DATABASE ENGINE17 TRANSACTION MODES19 LOCKS, LATCHES AND TRANSACTION ISOLATION LEVELS21 CHAPTER REVIEW QUESTIONS24 DATABASE DESIGN, MANAGEMENT AND ADMINISTRATION26 LOGICAL & PHYSICAL DESIGN26 PERFORMANCE TUNING29 THE SYSTEM DATABASES31 FILES AND FILEGROUPS35 SINGLE USER MODE38 TEMPORARY TABLES AND TABLE VARIABLES39 RESIZING A DATABASE41 MOVING DATABASES42 DETACH AND ATTACH43 CONTAINED DATABASES AND CONTAINED USERS45 BACKUP AND RECOVERY MODELS47 T-SQL STATEMENTS52 SELECT AND THE POSSIBLE OPTIONS54 COMPUTE AND THE POSSIBLE OPTIONS56 FOR AND THE POSSIBLE OPTIONS58 GROUP BY, HAVING AND THE POSSIBLE OPTIONS59 ORDER BY AND THE POSSIBLE OPTIONS60 CHAPTER REVIEW QUESTIONS61

Customer Reviews

No reviews or ratings yet - be the first to create one!

Product Details

General

Imprint

Createspace Independent Publishing Platform

Country of origin

United States

Release date

March 2013

Availability

Expected to ship within 10 - 15 working days

First published

March 2013

Authors

Dimensions

254 x 203 x 4mm (L x W x T)

Format

Paperback - Trade

Pages

66

ISBN-13

978-1-4827-5078-2

Barcode

9781482750782

Categories

LSN

1-4827-5078-3



Trending On Loot