Can someone show me what the screenshots should be? For this hands-on project, y
ID: 3661394 • Letter: C
Question
Can someone show me what the screenshots should be?
For this hands-on project, you will use the SQL Server named instance SQLSERVERCSU that you created for the Module 1 Critical Thinking Assignment. The objective of this assignment is to configure and test client/server connectivity using a variety of network protocols that are supported by SQL Server 2012. Document your work by taking a screen shot at the end of each step.
Begin by ensuring that the Shared Memory and TCP/IP protocols are enabled for your instance using the SQL Server Configuration Manager. Configure the TCP/IP server listener to use the static TCP port 1433.
Use SQLCMD to test connecting to the SQLSERVERCSU named instance using Shared Memory.
Use SQLCMD to test connecting to the SQLSERVERCSU TCP/IP listener on TCP port 1433. Use the 127.0.0.1 loopback address to simulate the network.
Troubleshoot any failures in Steps 2 and 3. For each failure, document the steps that were taken to diagnose and resolve each issue; then, reflect on this process and any difficulty that you experienced when carrying out these tasks in a one page report, which follows the CSU-Global Guide to Writing and APA Requirements.
After you have completed this Critical Thinking Assignment, submit one MS Word document that contains three screenshots and the written report. Your first screenshot should document your configuration of the TCP/IP server listener to use the static TCP port 1433; the second screenshot should document the connection test using shared memory; and the third screenshot should document your use of the SQLCMD to test connecting to the SQLSERVERCSU TCP/IP listener on TCP port 1433, while using the 127.0.0.1 loopback address to simulate the network. The minimum number of screenshots that should be included is three; however, if you feel like you need to include more than that, you’re welcome to do so. Insert all of the screenshots into one MS Word document, label each of them clearly, and include the one page report below the screenshots; then upload this single MS Word document to the assignment page.
Explanation / Answer
1. ITS410: Database Management Credit Hours: 3 Contact Hours: This is a 3-credit course, offered in accelerated format. This means that 16 weeks of material is covered in 8 weeks. The exact number of hours per week that you can expect to spend on each course will vary based upon the weekly coursework, as well as your study style and preferences. You should plan to spend 10-25 hours per week in each course reading material, interacting on the discussion boards, writing papers, completing projects, and doing research. Course Description and Outcomes Course Description: This course teaches students to design, implement, and use database management systems. Students will gain a working knowledge of available software packages, concepts of query languages, software integration services, and security considerations. The course has components consistent with materials used for the preparation of certification exam 70-462: Course Overview: This course provides database administrators and other newcomers to SQL Server 2012 with the knowledge and skills needed to install, configure, secure, and maintain Microsoft SQL Server 2012 databases and servers, and to apply updates and changes from the last version of SQL Server, including new technologies added to the application. This training also provides an in-depth understanding of the issues most commonly encountered by Microsoft Support on various topics discussed in the modules, along with their current status, solutions, and workarounds. The goal of this course is to provide students, as future IT professionals and managers, with detailed knowledge of, and hands-on simulated experience with, database management systems and SQL Server 2012. Students will gain a firm understanding of how to manage and maintain databases, as well as hone the skills needed to make effective decisions as database administrators. Course Learning Outcomes: 1. Install, configure and deploy a Microsoft SQL Server 2012. 2. Create and manage Microsoft SQL Server 2012 Databases. 3. Explain the process of SQL database performance monitoring and optimization. 4. Describe best practices for SQL Server security. 5. Summarize the backup and recovery process of SQL Server databases.
2.
Begin by ensuring that the Shared Memory and TCP/IP protocols are enabled for your instance using the SQL Server Configuration Manager. Configure the TCP/IP server listener to use the static TCP port 1433. 2. Use SQLCMD to test connecting to the SQLSERVERCSU named instance using Shared Memory. 3. Use SQLCMD to test connecting to the SQLSERVERCSU TCP/IP listener on TCP port 1433. Use the 127.0.0.1 loopback address to simulate the network. 4. Troubleshoot any failures in Steps 2 and 3. For each failure, document the steps that were taken to diagnose and resolve each issue; then, reflect on this process and any difficulty that you experienced when carrying out these tasks in a 300-word report, which follows the CSU-Global Guide to Writing and APA Requirements. After you have completed this Critical Thinking Assignment, submit one MS Word document that contains three screenshots and the written report. Your first screenshot should document your configuration of the TCP/IP server listener to use the static TCP port 1433; the second screenshot should document the connection test using shared memory; and the third screenshot should document your use of the SQLCMD to test connecting to the SQLSERVERCSU TCP/IP listener on TCP port 1433, while using the 127.0.0.1 loopback address to simulate the network. The minimum number of screenshots that should be included is three; however, if you feel like you need to include more than that, you re welcome to do so. Insert all of the screenshots into one MS Word document, label each of them clearly, and include the 300-word report below the screenshots; then upload this single MS Word document to the assignment page. Module 3 Critical Thinking: Creating databases and tables using SQL Server 2012 (80) For this Critical Thinking Assignment, you will use the SQL Server named instance SQLSERVERCSU that you created in the Module 1 Critical Thinking Assignment. The objectives of this activity are to configure two new user databases, and to create new tables and a foreign key relationship. 1. Use SQL Server Management Studio to connect to the SQLSERVERCSU instance. Create a new user database with the name HandsOnOne using the New Database dialog box from Object Explorer. Use the default database settings with the following exceptions: a. Data file initial size: 40 MB b. Log file initial size: 15 MB c. Autogrowth enabled with 15 MB in file growth d. Unlimited maximum file size 2. Use Object Explorer to generate a CREATE DATABASE script from the HandsOnOne database in a new Query Editor window. Change the name of the database in the SQL script to HandsOnTwo and modify the data file initial size to 35 MB. Execute the SQL script to create the database named HandsOnTwo. 3. Using either Object Explorer or Query Editor, set the recovery mode for the HandsOnOne database to full. Set the recovery mode for the HandsOnTwo database to simple. Document this step by taking a screenshot of the options page in the database properties window for each database. 4. Using Object Explorer or by running a SQL command in the Query Editor window rename the HandsOnTwo database to HandsOnTwo_Delete. 5. Execute a SQL command to DROP the HandsOnTwo_Delete database.
3. Using Object Explorer, create a new table named Customer with the following column names, associated data types, and constraints: Column name Data type Constraint CustomerID int Primary key CustomerName nvarchar(40) Not null CustomerAddressID int Not null Take a screenshot of the Table Designer window to document this step. 7. Using Query Editor, construct and execute a SQL command to create a new table named Address with the following column names, associated data types, and constraints: Column name Data type Constraint AddressID int Primary key Street nvarchar(50) Not null City nvarchar(40) Not null State char(2) Not null ZipCode nvarchar(10) Not null After executing the SQL command, document this step by taking a screenshot of the Query Editor window to show that the query completed successfully. 8. Using Object Explorer, create a foreign key relationship between the Customer and Address tables. The AddressID of the Address table is the primary key, and the CustomerAddressID of the Customer table is the foreign key. After creating the key, view the dependencies of the Address table in Object Explorer and take a screenshot to document this step. 9. Reflect on what worked well and which steps you struggled with in a 200-word paper that follows the CSU-Global Guide to Writing and APA Requirements. Combine the four appropriately labeled screenshots and the writing assignment into a single MS Word document, and upload it to the assignment page. Module 4 Critical Thinking: Querying Databases (70)
4.
This Critical Thinking Assignment requires you to use the SQL Server instance named SQLSERVERCSU and the HandsOnOne database and tables that you created in Modules 1 and 3, respectively. The objective of this activity is to hone your skills at manipulating data using SQL DML statements. Use Query Editor throughout this exercise. 1. Construct and execute INSERT statements to add the sample data in the following tables to the Customer and Address tables in the HandsOnOne database: Additional Sample Data for Customer Table CustomerID CustomerName CustomerAddressID 1 Western Supply Co. 2 2 Jake Harper 4 3 Elizabeth Harper 1 4 Abacus Consulting 3 Additional Sample Data for the Address Table AddressID Street City State Zip Code 1 2400 Broadway 2 320 21st Street 3 439 Skyline Blvd 4 56 Park Avenue New York NY 11201 Atlanta GA 30322 Seattle WA 98101 Dallas TX 75201 2. Construct and execute a query to list all customers with their corresponding cities and states. The list should be sorted in ascending numerical order by ZIP code, followed by customer name alphabetically. 3. Construct and execute a SQL query to count the number of customers in each state. The list should be ordered by the number of customers in descending order, then by state code in ascending order. Take a screenshot of the Query Editor after you have executed this SQL command to show that it was completed successfully. 4. Construct and execute a SQL query to list the full names of all customers who have Harper in their name. Take a screenshot of the Query Editor after you have executed this SQL command to show that it was completed successfully. 5. Your final step in this assignment is to compose a 300-word report that outlines your experience completing this assignment. Which task was the most difficult for you? Which was the easiest? Your repost should follow CSU-Global Guide to Writing and APA Requirements.
5.
After you have completed this Critical Thinking Assignment, submit one MS Word document that contains the three screenshots and the written report. Insert all of the screenshots into the document, label each of them clearly, and include the 300-word report below the screenshots; then upload this single MS Word document in the assignment page. Module 5 Critical Thinking: Managing Users and Permissions (70) For this Critical Thinking Assignment, you will use the SQL Server instance named SQLSERVERCSU and the HandsOnOne database and tables that you created in previous Critical Thinking Assignments. The objective of this project is to practice creating a new SQL Server login, granting and testing server-level and database-level permissions, and enabling or disabling the login. 1. Create a new Windows user account called WinCSU1. 2. Create a new SQL Server login that uses Windows authentication and is mapped to the Windows user WinCSU1. Ensure that the SQL Server login is enabled and granted permission to connect to the SQLSERVERCSU instance. 3. Map the new SQL Server login to a new database user on the HandsOnOne database. Grant the database user the db_datareader role. 4. Test the new SQL Server login by logging on to your computer using the new Windows user account, WinCSU1, which you created in Step 1, and use SQL Server Management Studio to connect to the SQLSERVERCSU instance using Windows integrated authentication. In Object Explorer, confirm that you are able to browse the folders within the HandsOnOne database, but not the AdventureWorks2012 database. 5. You will now test that the database user has read access to all tables in the HandsOnOne database. In SQL Server Management Studio, log on as the WinCSU1 user and open a new Query Editor window. Write a SELECT statement to query all rows in the Customer and Address tables. Document this step by taking a screenshot of the Query Editor window after successfully executing the query. 6. You will now test that the database user does not have INSERT permission to add records to the tables in the HandsOnOne database. Write a SELECT statement to INSERT a new record in the Address table. Document this step by taking a screenshot of the Query Editor window after attempting to execute the query. 7. You will now test that the database user does not have permission to delete records from the tables in the HandsOnOne database. Write a DELETE statement to delete a record from the Customer table. Document this step by taking a screenshot of the Query Editor window after attempting to execute the query. 8. Close SQL Server Management Studio and log off of your computer. Log back on using your usual administrator account and disable the WinCSU1 SQL Server login and the associated WinCSU1 Windows account. 9. Your final step is to compose a 300-word report that outlines your experience completing this assignment. Which task was the most difficult for you? Which was the easiest? Your report should follow the CSU- Global Guide to Writing and APA Requirements.
6.
After you have completed this Critical Thinking Assignment, submit one MS Word document that contains the three screenshots and the written report. Insert all of the screenshots into the document, label each of them carefully, and include the 300-word report below the screenshots; then upload this single MS Word document to the assignment page. Module 8 Portfolio Project: Microsoft SQL Server 2012 Proposal (350 Points) ESL Inc. is a large company that has been using a series of spreadsheets, access databases, and manual records to keep track of the majority of the organization s internal and customer data. They have grown significantly over the years and are now looking to you to provide a comprehensive solution for all their data storage needs. While they are willing to hire staff to maintain whatever system you propose, they have an expectation that data will be able to be mined and made useful for various areas within the company. For this portfolio project, you will create a proposal that addresses the organization s needs by recommending the use of Microsoft SQL Server 2012. This project will require you to reflect on and use knowledge gained not only in Module 8, but also in all of the previous module lectures and reading assignments. I. Overview (1 page): Provide a brief abstract in narrative form of the contents of this proposal. II. Proposal (5-7 pages): Describe what type of SQL Server you recommend, your suggestion for installing it, and the minimum system requirements. Describe how you would ensure data security. Explain how you would monitor the performance of the database. Describe what type of backup plan you would recommend for the proposed SQL Server. Identify which process/tool you would use to integrate the new SQL database with their existing systems and how you would use this process/tool. Explain the biggest risk to the proposed system and how you would address this risk. III. Conclusion (1 page): After laying out your proposal, describe the three main reasons why you would recommend SQL Server 2012 as the solution for ESL, Inc. IV. Reference Page (1 Page): Your proposal should include five references from credible sources; these sources may include the course textbook or recommended readings. The CSU-Global Library is a good place to find these sources. Your APA-formatted proposal should be 8-10 pages in length, not including the title and reference page(s). Please follow the CSU-Global Guide to Writing and APA Requirements. Course Grading
7. 9 20% Discussion Participation 10% Mastery Exercises 35% Critical Thinking Activities 35% Final Portfolio Paper Grading Scale and Policies A 95.0 100 A- 90.0 94.9 B+ 86.7 89.9 B 83.3 86.6 B- 80.0 83.2 C+ 75.0 79.9 C 70.0 74.9 D 60.0 69.9 F 59.9 or below In-Classroom Policies For information on late work and incomplete grade policies, please refer to our In-Classroom Student Policies and Guidelines or the Academic Catalog for comprehensive documentation of CSU-Global institutional policies. Academic Integrity Students must assume responsibility for maintaining honesty in all work submitted for credit and in any other work designated by the instructor of the course. Academic dishonesty includes cheating, fabrication, facilitating academic dishonesty, plagiarism, reusing /re-purposing your own work (see CSU-Global Guide to Writing and APA Requirements for percentage of repurposed work that can be used in an assignment), unauthorized possession of academic materials, and unauthorized collaboration. The CSU-Global Library provides information on how students can avoid plagiarism by understanding what it is and how to use the Library and Internet resources.