1 Preparation: Reading(s) Chapter 1: Planning and Installing SQL Server 2012 Agenda– Review Course Lab procedures Review of Server 2012 The instructor will provide the machines used for this course, however you wish you can setup your own install following the directions on page xix - xxiv Laboratory Experiment – Due January 24 Complete Exercises 1-2 found on page 21-23, and exercises 1 -5 on page 45-51. Submit a screen shot of each completed lab in a single word document and submit to Blackboard. Complete all of the “Practice exercises” on page 55 2 Preparation: Reading(s) Chapter 2: Configuring and Managing SQL Server Instances Laboratory Experiment – Due January 31 Complete Exercises 1-3 found on page 77 and exercises 1 -3 on page 95-96. Submit a screen shot of each completed lab in a single word document and submit to Blackboard. Complete all of the “Practice exercises” on page 99 3 Preparation: Reading(s) Chapter 3: Configuring SQL Server 2012 Components Laboratory Experiment – Due February 7 Complete Exercises 1-2 found on page 122 – 123 and exercises 1 -3 on page 145 - 146. Submit a screen shot of each completed lab in a single word document and submit to Blackboard. Complete Case Scenario 2 on page 351 4 Preparation: Reading(s) Chapter 4: Migrating, Importing and Exporting Laboratory Experiment – Due February 14 Complete Exercises 1-2 found on page 171 – 172 and exercises 1 -2 on page 183 - 184. Submit a screen shot of each completed lab in a single word document and submit to Blackboard. Complete all of the “Practice exercises” on page 187 5 Preparation: Reading(s)
Chapter 5: SQL Server Logins, Roles and Users Laboratory Experiment – Due February 21 Complete Exercises 1-3 on page 205 – 206 and exercises 1 -3 on page 220. Submit a screen shot of each completed lab in a single word document and submit to Blackboard. Complete Case Scenario 2 on page 223 Complete the “Practice Exercise 1 and 2” on page 224 6 Preparation: Reading(s) Chapter 6: Securing SQL Server 2012 Laboratory Experiment – Due February 28 Complete Exercises 1-2 found on page 238; exercises 1 on page 247 and exercise 1-3 on page 269 -270. Submit a screen shot of each completed lab in a single word document and submit to Blackboard. Complete all of the “Practice exercises” on page 273 QUIZ 7 Preparation: Reading(s) Chapter 7: Mirroring and Replication Laboratory Experiment – Due March 6 Complete Exercises 1-4 found on page 295 - 297 and exercises 1 -4 on page 318 – 320. Submit a screen shot of each completed lab in a single word document and submit to Blackboard. Complete all of the “Practice exercises” on page 323 8 Preparation: Reading(s) Chapter 8: Clustering and AlwaysOn Laboratory Experiment – Due March 13 Complete Exercises 1-5 found on page 341 - 343 and exercises 1 -4 on page 361-364. Submit a screen shot of each completed lab in a single word document and submit to Blackboard. Complete all of the “Practice exercises” on page 366 9 Preparation: Reading(s) Chapter 9: Troubleshooting SQL Server 2012 Laboratory Experiment – Due March 27 Complete Exercises 1 found on page 376, exercises 1 -2 on page 386-387, exercise 1 on page 393, exercise 1 on page 401 and exercise 1 on page 407. Submit a screen shot of each completed lab in a single word document and submit to Blackboard.