CIS 424 Week 1 Discussion

"SQL Server 2012 and Installation Requirements"  Please respond to the following:

·         Compare and contrast flat-file databases and relational databases and rationalize the key reasons why you would implement one type of database over the other in a production environment. Provide a minimum of two (2) reasons to justify your answer.

 

CIS 424 Week 1 Pre Assessment
uCertify Setup Requirements

·         uCertify Assessments

o    You must use the preset test options for the graded submission of the pre-assessment, quizzes, and post-assessment. 
Note: You are encouraged to submit the results of your first attempt at completing the assessment(s).

uCertify Submission Requirements

1.      Complete the assessment; your results will be displayed.

2.      Select “Share your result” from the results page menu items.

3.      Copy the URL and paste it into the assignment submission area in the Blackboard online course shell.

4.      Summarize, in two to three (2-3) sentences, both your strengths and weaknesses with respect to the topics you covered in the assessment.
Note: The written summary may be submitted in the assignment submission area along with the results URL, or it may be submitted as a separate attachment.

5.      Once you have successfully pasted the results URL and included the assessment summary, you may submit your assignment for grading. 
Note: Failure to submit the results URL into the assignment submission area within the Blackboard online shell will result in 0 points for the assignment. Evidence of purposely skipped answers, incomplete answers, or limited effort is at the instructor’s discretion and may result in partial or incomplete credit for the assignment.

Click here to view grading rubric.

 

CIS 424 Week 2 Discussion

"Installation Requirements"  Please respond to the following:

·         Per the text, there are several requirements to consider when installing a database server. Identify two (2) requirements and explain the manner in which they affect the overall performance of the database server.

·         Suppose upper management has requested that you must run your database with the minimum hardware requirements. Explain your response to upper management.

 

CIS 424 Week 2 Lab Assignment 1

2.1.2  SQL Server Components

2.1.3  Data Access Method

2.1.4  Data Write Method

Help: Review the videos under the “Getting Started” tab of the uCertify lab environment.

Submission Requirements: Submit each set of labs based on the following:

1.      Complete the weekly set of labs described below using the uCertify lab environment.

2.      Submit only those labs identified below. 
Note: Students are encouraged to explore the additional labs and videos offered through the lab environment on an optional / non-graded basis.

3.      To submit a completed set of labs you must export your Study Planner report. To export the report:

o    Select “Open Study Planner” from the uCertify home page.

o    Click the “Submit” button to generate a unique URL.

o    Copy and paste the generated URL into the assignment submission box of the Blackboard online course shell.
Note: The URL will report your cumulative work in uCertify at the moment you generated the URL. Live progress is not tracked through the generated URL. You must generate / submit a new URL each time you submit a set of labs for grading.

                        Once you have successfully pasted the URL into the assignment submission area of the online shell, you may submit the set of labs for grading.

 

CIS 424 Week 3 Discussion

"The SELECT Statement"  Please respond to the following:

·         Read the article titled “Writing SQL Queried: Let Start with the Basics" located at http://technet.microsoft.com/en-us/library/bb264565%28v=sql.90%29.aspx. Define the key elements and uses of the SELECT query statement, and provide an example of its usage. Give your opinion on whether or not you believe it is efficient to use the comparison operators with the SELECT statement. Provide a tool that could make the process more efficient.

 

CIS 424 Week 3 Lab Assignment 2

3.5.1 Retrieving All Records from a Table

3.5.2 Retrieving Selected Records from a Table

3.5.3 Using the DISTINCT Keyword

3.5.4 Using the LIKE Operator

3.5.6 Using the GREATER THAN Relational Operator

3.5.7 Using the IS NOT NULL Condition

3.5.8 Using the IS NULL Condition

3.6.2 Using the MAX() Function

3.6.3 Using the AVG() Function

3.7.1 Deleting a table from a database using T-SQL code

3.9.1 Inserting a Record in a Table of a Database

3.9.2 Using the WHERE Clause in a Table of a Database

3.9.3 Updating a Record in a Table of a Database

3.9.4 Deleting a Record from a Table of a Database

Help: Review the videos under the “Getting Started” tab of the uCertify lab environment.

Submission Requirements: Submit each set of labs based on the following:

1.      Complete the weekly set of labs described below using the uCertify lab environment.

2.      Submit only those labs identified below. 
Note: Students are encouraged to explore the additional labs and videos offered through the lab environment on an optional / non-graded basis.

3.      To submit a completed set of labs you must export your Study Planner report. To export the report:

o    Select “Open Study Planner” from the uCertify home page.

o    Click the “Submit” button to generate a unique URL.

o    Copy and paste the generated URL into the assignment submission box of the Blackboard online course shell.
Note: The URL will report your cumulative work in uCertify at the moment you generated the URL. Live progress is not tracked through the generated URL. You must generate / submit a new URL each time you submit a set of labs for grading.

                        Once you have successfully pasted the URL into the assignment submission area of the online shell, you may submit the set of labs for grading.

Click here to view grading rubric.

 

CIS 424 Week 4 Discussion

"Database Concepts"  Please respond to the following:

·         Per the text, tables are large storage areas that contain specific entity data. A row is considered a record, and each column contains specific attribute data concerning the row. Describe the relationship between the column attribute and the record contained in the row. Then, explain how this information is used to form a relationship with other tables.

·          

CIS 424 Week 4 Assignment 1

Your organization is planning to deploy SQL Server 2012 on two (2) servers as a production database. You have been asked to outline the steps required to implement these severs into the existing network, with the knowledge that 500 users will be connecting to these servers daily. Use the Internet to search for information pertaining to SQL 2012 installation and planning.

Students, please view the "Submit a Clickable Rubric Assignment" video in the Student Center.

Instructors, training on how to grade is within the Instructor Center."

Write a four to five (4-5) page paper in which you:

1.      Create a list of items that your organization should consider prior to the installation of the SQL servers.

2.      Review the available SQL 2012 editions (e.g., Standard, Business, Enterprise, Express, and Web and Developer). Recommend the edition of SQL 2012 that your organization should deploy based on the usage. Justify your response. (Hint: Remember to consider scalability into the decision).

3.      Determine the minimum hardware requirements, and specify the maximum resources necessary to ensure availability and scalability.

4.      Provide a synopsis of any potential installation and configuration issues and suggest a viable approach to mitigate such issues to ensure the success of the installation.

5.      Use at least two (2) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.

Your assignment must follow these formatting requirements:

·         Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.

·         Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

The specific course learning outcomes associated with this assignment are:

·         Describe the features of the Microsoft SQL Server environment.

·         Use technology and information resources to research issues in the MSSQL environment.

·         Write clearly and concisely about introductory Database Administration topics using proper writing mechanics and technical style conventions.

Click here to view grading rubric.

 

 

CIS 424 Week 5 Discussion

"Entity Relationship Diagram"  Please respond to the following:

·         Suggest three (3) ways that an Entity Relationship Diagram (ERD) can be used to simplify the creation and management of a database from the inception to the creation of the database. Justify the means in which your suggestions simplify the process.

 

CIS 424 Week 5 Lab Assessment 3

5.3.1 Preparing the Visio Environment for Entity Relationship Diagramming

5.3.2 Creating the Visio Entity Relationship Diagram

Help: Review the videos under the “Getting Started” tab of the uCertify lab environment.

Submission Requirements: Submit each set of labs based on the following:

1.      Complete the weekly set of labs described below using the uCertify lab environment.

2.      Submit only those labs identified below. 
Note: Students are encouraged to explore the additional labs and videos offered through the lab environment on an optional / non-graded basis.

3.      To submit a completed set of labs you must export your Study Planner report. To export the report:

o    Select “Open Study Planner” from the uCertify home page.

o    Click the “Submit” button to generate a unique URL.

o    Copy and paste the generated URL into the assignment submission box of the Blackboard online course shell.
Note: The URL will report your cumulative work in uCertify at the moment you generated the URL. Live progress is not tracked through the generated URL. You must generate / submit a new URL each time you submit a set of labs for grading.

                        Once you have successfully pasted the URL into the assignment submission area of the online shell, you may submit the set of labs for grading.

Click here to view grading rubric.

 

CIS 424 Week 6 Discussion

"Normalization and Performance"  Please respond to the following:

·         Read the article titled “Introduction to Data Normalization: A Database "Best" Practice,” located at http://agiledata.org/essays/dataNormalization.html. Determine whether first normal form (1NF), second normal form (2NF), or third normal form (3NF) should be the goal when a DBA designs a database. Justify your response.

·         Suppose that you overhear two colleagues debating the issue of performance versus availability. Since they are divided; they have asked you to provide an opinion on which of the two concepts is most important when designing and managing a database. Defend your position with at least three (3) reasons.

 

CIS 424 Week 6 Lab Assessment 4

6.1.1 Normalizing the unnormalized model to the first normal form
6.1.2 Normalizing the first normal form to the second normal form
6.1.3 Normalizing the second normal form to the third normal form

Help: Review the videos under the “Getting Started” tab of the uCertify lab environment.

Submission Requirements: Submit each set of labs based on the following:

1.      Complete the weekly set of labs described below using the uCertify lab environment.

2.      Submit only those labs identified below. 
Note: Students are encouraged to explore the additional labs and videos offered through the lab environment on an optional / non-graded basis.

3.      To submit a completed set of labs you must export your Study Planner report. To export the report:

o    Select “Open Study Planner” from the uCertify home page.

o    Click the “Submit” button to generate a unique URL.

o    Copy and paste the generated URL into the assignment submission box of the Blackboard online course shell.
Note: The URL will report your cumulative work in uCertify at the moment you generated the URL. Live progress is not tracked through the generated URL. You must generate / submit a new URL each time you submit a set of labs for grading.

                        Once you have successfully pasted the URL into the assignment submission area of the online shell, you may submit the set of labs for grading.

Click here to view grading rubric.

 

 

CIS 424 Week 7 Discussion

Filegroups""  Please respond to the following:

·         Describe the purpose of filegroups and examine the key ways it helps with minimizing administration to backups or with multiple databases within an organization. Suppose you managed a server with 200 terabytes of data, determine whether you would use full backup, transaction or file groups. Provide a rationale for your response.

 

CIS 424 Week 7 Lab Assessment 5

7.2.1 Creating multiple filegroups
7.4.1 Creating the Books database in the GUI
7.7.2 Attaching the Books database in the GUI

Help: Review the videos under the “Getting Started” tab of the uCertify lab environment.

Submission Requirements: Submit each set of labs based on the following:

1.      Complete the weekly set of labs described below using the uCertify lab environment.

2.      Submit only those labs identified below. 
Note: Students are encouraged to explore the additional labs and videos offered through the lab environment on an optional / non-graded basis.

3.      To submit a completed set of labs you must export your Study Planner report. To export the report:

o    Select “Open Study Planner” from the uCertify home page.

o    Click the “Submit” button to generate a unique URL.

o    Copy and paste the generated URL into the assignment submission box of the Blackboard online course shell.
Note: The URL will report your cumulative work in uCertify at the moment you generated the URL. Live progress is not tracked through the generated URL. You must generate / submit a new URL each time you submit a set of labs for grading.

                        Once you have successfully pasted the URL into the assignment submission area of the online shell, you may submit the set of labs for grading.

 

CIS 424 Week 8 Discussion

"Advantages of Tables"  Please respond to the following:

Participate in the following activities in order to complete the discussion:

·         Suppose you are a DBA of a 5,000-person organization. Your boss wants to know the advantages of using a partitioned table and the ways it will affect performance of the server, specifically during peak hours. Decide whether or not a vertical partitioned table is more effective than a horizontal table. Justify your response.

 

CIS 424 Week 8 Lab Assessment 6

8.3.1 Assigning collations at the column level

8.4.1 Executing a make table query

8.4.2 Adding a column to a table

8.4.3 Creating columns

8.4.4 Selecting the primary key

8.4.5 Specifying table properties and saving the table

8.4.7 Scripting the table for documentation

Help: Review the videos under the “Getting Started” tab of the uCertify lab environment.

Submission Requirements: Submit each set of labs based on the following:

1.      Complete the weekly set of labs described below using the uCertify lab environment.

2.      Submit only those labs identified below. 
Note: Students are encouraged to explore the additional labs and videos offered through the lab environment on an optional / non-graded basis.

3.      To submit a completed set of labs you must export your Study Planner report. To export the report:

o    Select “Open Study Planner” from the uCertify home page.

o    Click the “Submit” button to generate a unique URL.

o    Copy and paste the generated URL into the assignment submission box of the Blackboard online course shell.
Note: The URL will report your cumulative work in uCertify at the moment you generated the URL. Live progress is not tracked through the generated URL. You must generate / submit a new URL each time you submit a set of labs for grading.

                        Once you have successfully pasted the URL into the assignment submission area of the online shell, you may submit the set of labs for grading.

Click here to view grading rubric.

 

CIS 424 Week 9 Discussion

"Clustered versus Non-clustered Indexes"  Please respond to the following:

·         As a DBA that manages over 25 SQL Servers, one of your responsibilities is to ensure that data can be easily accessed with the help of indexing. Compare and contrast clustered and non-clustered indexes and provide three (3) examples which demonstrate how indexing can be used to improve the overall performance of a query.

 

CIS 424 Week 9 Assessment 7

9.2.1 Setting the primary key

9.2.2 Creating the LastName non-clustered index

9.2.4 Creating an index on a column of a table of a database

9.3.2 Creating the Filtered index

9.4.1 Dropping an index from a column of a table of a database

9.6.1 Creating a view using T-SQL code

Help: Review the videos under the “Getting Started” tab of the uCertify lab environment.

Submission Requirements: Submit each set of labs based on the following:

1.      Complete the weekly set of labs described below using the uCertify lab environment.

2.      Submit only those labs identified below. 
Note: Students are encouraged to explore the additional labs and videos offered through the lab environment on an optional / non-graded basis.

3.      To submit a completed set of labs you must export your Study Planner report. To export the report:

o    Select “Open Study Planner” from the uCertify home page.

o    Click the “Submit” button to generate a unique URL.

o    Copy and paste the generated URL into the assignment submission box of the Blackboard online course shell.
Note: The URL will report your cumulative work in uCertify at the moment you generated the URL. Live progress is not tracked through the generated URL. You must generate / submit a new URL each time you submit a set of labs for grading.

                        Once you have successfully pasted the URL into the assignment submission area of the online shell, you may submit the set of labs for grading.

Click here to view grading rubric.

 

CIS 424 Week 10 Discussion

 

"Triggers and Stored Procedures"  Please respond to the following:

·         SQL has two types of triggers, Data Manipulation Language and Data Definition Language. Read the article titled “DML Triggers in SQL Server 2012,” located at http://www.databasejournal.com/features/mssql/article.php/3837541/DML-Triggers-in-SQL-Server-2008.htm. Next, determine the appropriate use of each type of trigger. Describe a real life situation or scenario that would benefit from using a trigger.

 

CIS 424 Week 10 Assessment 8

10.3.1 Create a trigger

10.3.3 Drop a trigger

Help: Review the videos under the “Getting Started” tab of the uCertify lab environment.

Submission Requirements: Submit each set of labs based on the following:

1.      Complete the weekly set of labs described below using the uCertify lab environment.

2.      Submit only those labs identified below. 
Note: Students are encouraged to explore the additional labs and videos offered through the lab environment on an optional / non-graded basis.

3.      To submit a completed set of labs you must export your Study Planner report. To export the report:

o    Select “Open Study Planner” from the uCertify home page.

o    Click the “Submit” button to generate a unique URL.

o    Copy and paste the generated URL into the assignment submission box of the Blackboard online course shell.
Note: The URL will report your cumulative work in uCertify at the moment you generated the URL. Live progress is not tracked through the generated URL. You must generate / submit a new URL each time you submit a set of labs for grading.

                        Once you have successfully pasted the URL into the assignment submission area of the online shell, you may submit the set of labs for grading.

Click here to view grading rubric.

 

CIS 424 Week 10 Assignment 2

Imagine you work in the IT department of a new company called Web Assets (WA), located in Denver CO. WA builds custom Websites and provides technical support for clients. The Chief Information Officer (CIO) wants you to create a new customer database using Microsoft SQL 2012 that will interface with the company’s Web server, so that any inquiries or potential customer data can be stored and retrieved by the sales force. The company is expecting to expand and offer these same services in Phoenix AZ, and Sacramento CA. The pertinent information required from each potential customer includes:

·         First and Last name

·         Contact Phone Number

·         Contact Email address

·         Description of project

·         Address

Since there will be three (3) sites, the CIO wants to ensure that the database and Website are available for customers 24 / 7 days a week.

Students, please view the "Submit a Clickable Rubric Assignment" video in the Student Center.

Instructors, training on how to grade is within the Instructor Center."

Write a six to eight (6-8) page paper in which you:

1.      Review the available SQL 2012 editions. Recommend the edition which you believe should be installed based on the usage. Justify your recommendation. Note: Keep in mind to consider scalability into the decision.

2.      Suggest the naming convention you would use for the object in the database.

3.      Analyze the potential backup / recovery options. Outline a plan for ensuring that the database meets the 24 / 7 availability.

4.      Provide a SQL script (DDL) to create the tables with their relationships, including data types, primary keys, and foreign keys. Note: You may optionally include constraints.

5.      Use at least two (2) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.

Your assignment must follow these formatting requirements:

·         Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.

·         Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

The specific course learning outcomes associated with this assignment are:

·         Create an MSSQL database solution to solve a proposed business problem.

·         Create databases, tables, views, functions, constraints, and stored procedures.

·         Describe and apply backup and restore procedures in database environments.

·         Implement High Availability methods.

·         Use technology and information resources to research issues in the MSSQL environment.

·         Write clearly and concisely about introductory Database Administration topics using proper writing mechanics and technical style conventions.

 

 

CIS 424 Week 11Discussion

"Course Conclusion"  Please respond to the following:

·         You have just completed ten (10) weeks of a database administration course. Imagine you have been asked to create a one-day training course that highlights the important elements of what you have just learned within the past ten (10) weeks.

·          

o    Create a hierarchy of no more or no less than five (5) of the most important topics that you believe that a one-day course entitled “Database Administration: The Essentials Presented in One Day” should address. Provide a detailed rationale for each of the five (5) topics.