In This Database Lab Your Assignment Is To Create A Series O
In This Database Lab Your Assignment Is To Create a Series of Queries
In this database lab, your assignment is to create a series of queries by using SQL Server 2008. Before attempting this exercise, be sure you go through the assigned readings. Instructions for the Lab Based on the sample database you are using, download and save one of the worksheets below to your computer for reference. SQL Lab Worksheet (AventureWorks) SQL Lab Worksheet (AventureWorksR2) The instructions take you through your assignment. Follow them carefully!
As required, attach screenshots of your work to the lab document. Submit your completed assignment by following the directions linked below. Please check the Course Calendar for specific due dates. Save your assignment as a Microsoft Word document.
Paper For Above instruction
The purpose of this assignment is to demonstrate proficiency in crafting SQL queries using SQL Server 2008, based on a given sample database. The exercise requires students to follow a structured series of query-building tasks outlined in the provided worksheets, ensuring they can effectively manipulate and retrieve data from the database. Before beginning, students should thoroughly review the assigned readings to understand the necessary concepts and techniques for writing accurate and efficient SQL queries.
Students are instructed to download one of the specified worksheets—either the AventureWorks or AventureWorksR2 sample database—as a reference tool for their tasks. These worksheets contain step-by-step instructions that guide the user through creating various queries. Careful adherence to these instructions is essential for completing the assignment successfully.
Throughout the exercise, students must document their work by capturing screenshots that demonstrate each query's output and correctness. These visual proofs are to be attached to the final lab report, providing evidence that the queries have been executed properly. The submission must be completed through the specified channels, following the provided submission guidelines to ensure compliance with course requirements.
It is important to note that the assignment deadline is specified in the course calendar. Students should verify the due date and plan their work accordingly to avoid last-minute rushing. The final submission must be in Microsoft Word format, containing the written responses, screenshots, and any additional required documentation.
This assignment not only assesses technical proficiency in SQL querying but also emphasizes careful reading, following instructions, and presentation skills. Proper execution and documentation will reflect an understanding of database querying principles, useful for more advanced database management tasks in the future.
References
- Battista, G. (2014). SQL Server 2008 R2 Unleashed. Sams Publishing.
- Gatlin, D. (2010). Beginning SQL Server 2008 Administration. Apress.
- Hernández, M., & García, A. (2012). Practical SQL: A Beginner’s Guide. O'Reilly Media.
- Olson, J. E. (2011). Learning SQL. O'Reilly Media.
- Levenson, P. (2009). Microsoft SQL Server 2008 Bible. Wiley.
- Chapple, M., & Payne, J. (2012). Microsoft SQL Server 2012 Administrative Real-World Skills. Packt Publishing.
- Deitel, P. J. (2008). How to Program. Pearson.
- Rob, P., & Coronel, C. (2007). Database Systems: Design, Implementation, & Management. Cengage Learning.
- Casteel, M. (2014). SQL Server 2008 Query Performance Tuning. Apress.
- Schmidt, C. (2010). Mastering SQL Server 2008. Packt Publishing.