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

Overview

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 UPDATES 2
ABOUT THIS BOOK 2
SERVER MANAGEMENT AND ADMINISTRATION 3
OVERVIEW 3
SERVER LEVEL ROLES 4
LOGINS AND CREDENTIALS 7
MANAGEMENT STUDIO AND OTHER CONFIGURATION TOOLS 11
THE DATABASE ENGINE 17
TRANSACTION MODES 19
LOCKS, LATCHES AND TRANSACTION ISOLATION LEVELS 21
CHAPTER REVIEW QUESTIONS 24
DATABASE DESIGN, MANAGEMENT AND ADMINISTRATION 26
LOGICAL & PHYSICAL DESIGN 26
PERFORMANCE TUNING 29
THE SYSTEM DATABASES 31
FILES AND FILEGROUPS 35
SINGLE USER MODE 38
TEMPORARY TABLES AND TABLE VARIABLES 39
RESIZING A DATABASE 41
MOVING DATABASES 42
DETACH AND ATTACH 43
CONTAINED DATABASES AND CONTAINED USERS 45
BACKUP AND RECOVERY MODELS 47
T-SQL STATEMENTS 52
SELECT AND THE POSSIBLE OPTIONS 54
COMPUTE AND THE POSSIBLE OPTIONS 56
FOR AND THE POSSIBLE OPTIONS 58
GROUP BY, HAVING AND THE POSSIBLE OPTIONS 59
ORDER BY AND THE POSSIBLE OPTIONS 60
CHAPTER REVIEW QUESTIONS 61

Read More