{"id":395,"date":"2013-05-08T04:03:39","date_gmt":"2013-05-08T04:03:39","guid":{"rendered":"http:\/\/examreview.net\/wp\/?p=395"},"modified":"2013-05-08T04:03:39","modified_gmt":"2013-05-08T04:03:39","slug":"intro-to-sql-server-database","status":"publish","type":"post","link":"http:\/\/examreview.net\/wp\/?p=395","title":{"rendered":"Intro to SQL Server Database"},"content":{"rendered":"<p><strong>Essential ClassNotes Intro to SQL Server Database System Study Notes, Review Questions and Classroom Discussion Topics 2013<\/strong><\/p>\n<p>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.\u00a0<br \/>\n\u00a0<br \/>\n\u00a0<br \/>\nCONTENT UPDATES\u00a02<br \/>\nABOUT THIS BOOK\u00a02<br \/>\nSERVER MANAGEMENT AND ADMINISTRATION\u00a03<br \/>\nOVERVIEW\u00a03<br \/>\nSERVER LEVEL ROLES\u00a04<br \/>\nLOGINS AND CREDENTIALS\u00a07<br \/>\nMANAGEMENT STUDIO AND OTHER CONFIGURATION TOOLS\u00a011<br \/>\nTHE DATABASE ENGINE\u00a017<br \/>\nTRANSACTION MODES\u00a019<br \/>\nLOCKS, LATCHES AND TRANSACTION ISOLATION LEVELS\u00a021<br \/>\nCHAPTER REVIEW QUESTIONS\u00a024<br \/>\nDATABASE DESIGN, MANAGEMENT AND ADMINISTRATION\u00a026<br \/>\nLOGICAL &amp; PHYSICAL DESIGN\u00a026<br \/>\nPERFORMANCE TUNING\u00a029<br \/>\nTHE SYSTEM DATABASES\u00a031<br \/>\nFILES AND FILEGROUPS\u00a035<br \/>\nSINGLE USER MODE\u00a038<br \/>\nTEMPORARY TABLES AND TABLE VARIABLES\u00a039<br \/>\nRESIZING A DATABASE\u00a041<br \/>\nMOVING DATABASES\u00a042<br \/>\nDETACH AND ATTACH\u00a043<br \/>\nCONTAINED DATABASES AND CONTAINED USERS\u00a045<br \/>\nBACKUP AND RECOVERY MODELS\u00a047<br \/>\nT-SQL STATEMENTS\u00a052<br \/>\nSELECT AND THE POSSIBLE OPTIONS\u00a054<br \/>\nCOMPUTE AND THE POSSIBLE OPTIONS\u00a056<br \/>\nFOR AND THE POSSIBLE OPTIONS\u00a058<br \/>\nGROUP BY, HAVING AND THE POSSIBLE OPTIONS\u00a059<br \/>\nORDER BY AND THE POSSIBLE OPTIONS\u00a060<br \/>\nCHAPTER REVIEW QUESTIONS\u00a061<\/p>\n<p>CreateSpace eStore: <a href=\"https:\/\/www.createspace.com\/4204234\">https:\/\/www.createspace.com\/4204234<\/a><\/p>\n<p><a href=\"http:\/\/examreview.net\/wp\/wp-content\/uploads\/2013\/05\/largeprint.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-173\" alt=\"largeprint\" src=\"http:\/\/examreview.net\/wp\/wp-content\/uploads\/2013\/05\/largeprint.png\" width=\"133\" height=\"37\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Essential ClassNotes Intro to SQL Server Database System Study Notes, Review Questions and Classroom Discussion Topics 2013 Information presented in&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[226,224],"tags":[242,243,184,241],"class_list":["post-395","post","type-post","status-publish","format-standard","hentry","category-computer-general","category-essential-classnotes","tag-db-design","tag-rdbms","tag-sql-server","tag-tsql","wpcat-226-id","wpcat-224-id"],"_links":{"self":[{"href":"http:\/\/examreview.net\/wp\/index.php?rest_route=\/wp\/v2\/posts\/395"}],"collection":[{"href":"http:\/\/examreview.net\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/examreview.net\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/examreview.net\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/examreview.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=395"}],"version-history":[{"count":0,"href":"http:\/\/examreview.net\/wp\/index.php?rest_route=\/wp\/v2\/posts\/395\/revisions"}],"wp:attachment":[{"href":"http:\/\/examreview.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=395"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/examreview.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=395"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/examreview.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=395"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}