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

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