Course Syllabus

Department of Business & Technology SYLLABUS for

CET 2433: SQL Implementation

Fall, 2015

CLASS MEETINGS:

 

Location	Bradenton Campus
Day and Time	Thursday Class 6:00 pm - 8:50 pm Bldg 18 room 202 If you can’t make class, please let me know by email so you can get assignments and continue participation.

 

Instructor’s Name:  Kimberly Garnto

Office Number: 6-105

Office Hours: MTWR 8:30AM – 6pm;

Telephone: 941.752-5276

Email Address:  garntok@scf.edu

 

COURSE DESCRIPTION:

This course presents the fundamentals of relational databases, and understanding the objects that make up a database. It develops the skills needed to use SQL Server to create and manipulate a database and access and maintain data integrity. This course provides students with the knowledge and skills to implement a Microsoft SQL Server 2012 database. The course focuses on teaching individuals how to use SQL Server 2012 product features and tools related to implementing and maintaining a database. This is a tentative course outline, and may be slightly modified as we go along.

PERFORMANCE STANDARDS:

At the successful completion of this course, the student should be able to:

Understand the history and usefulness of relational databases

• Create databases and database files.
• Create data types and tables.
• Plan, create, and optimize indexes.
• Implement data integrity in Microsoft SQL Server 2012 databases by using constraints.
• Implement data integrity in Microsoft SQL Server 2012 databases by using triggers.
• Implement views.
• Implement stored procedures.
• Implement functions.
• Implement managed code in the database.
• Manage transactions and locks.

TEXT AND SOFTWARE:

This class uses the SCF Canvas Learning Management System (LMS) for all instructions and other class activities. This includes schedules, the submission of assignments, Quizzes, and email for communications.

Our main textbook is “Microsoft SQL Server 2012 – Step by Step”. An additional ebook has been uploaded to the Canvas System is “Introducing Microsoft SQL Server 2012”.

We will be installing Microsoft SQL Server 2012, which can be downloaded from the MSDNAA site.

WITHDRAWAL POLICY:

In accordance with the State College of Florida policy as stated in the college catalog, students may withdraw from any course or all courses without academic penalty with a grade of WF by the withdrawal deadline as listed in the State College of Florida academic calendar. This date for this semester is noted in the class meeting schedule at the beginning of this document.

The student must take responsibility for initiating the withdrawal procedure. Students are strongly encouraged to talk with their instructors first before taking any withdrawal action. In addition, students should note that faculty may also withdraw students for violating policies, procedures, or conditions of the class, as outlined in individual class syllabi, and such action could affect financial aid eligibility.

TEACHING METHODS:

1. Reading Assignments: All required readings are from the assigned text. See the

Class Assignment Schedule for the reading assignments.

2. Lectures and Discussions: Important material will be covered in the first class. Students should plan to take careful notes as not all material can be found in the texts or readings.

3. Quizzes: There is a Quiz most weeks covering the Reading Assignments or PowerPoint presentations to be completed by midnight, Sunday of each week. The Quizzes are open book and are completed outside of class using Canvas. Each Quiz is graded with points that contribute to your Final Grade.

 4. Attendance: Please note that attendance is taken in order to comply and that failure to attend the first class could mean withdrawal from the class.

5. Midterm and Final Exam: The objective of this class is to prepare the Student to successfully complete the examination for Implementing Microsoft SQL Server. A midterm and Final is used to assess the Students readiness and to point out areas for additional study. The Midterm covers the First Half of the class work, and the Final covers the last half. Both carry points that contribute to the Final Grade.

All assignments and quizzes are completed outside of class and submitted using the Canvas LMS. Each assignment is due at midnight Sunday of the class week as per the Schedule of Assignments. IF YOU MISS A QUIZ YOU CAN NOT MAKE IT UP SO DO NOT ASK

 

GRADING POLICY:

 

The following is used for the calculation of the Final Grade:

Category	Number of Units	Points Each	Total Points	Percent of Final Grade
Quizzes	14	25	350	35%
Class Participation (Assignments)	1	Varied	200	20%
Database Design Project	1	250	250	25%
Midterm Project	1	100	100	10%
Final Exam	1	100	100	10%
Totals			1000	100%

 

 

Final Grades are determined points earned as a percentage of total points.

Grade	Percent	Minimum Points for Grade
A	90%	900
B	80%	800
C	70%	700
D	60%	600

 

 

ADDITIONAL COURSE POLICIES:

Communication: Additional questions and correspondence should be submitted to the Instructor by phone or Canvas email. Please proofread all emails and run spell-check, write professionally, and include a meaningful Subject Line. The Instructor can be contacted either before or after each class session for private consultation. Students are required to communicate via email with their Instructor using Canvas or their SCF email address.

Academic Dishonesty: Plagiarism is the use of ideas, facts, opinions, illustrative material, data, direct or indirect wording of another scholar and/or writer—professional or student—without giving proper credit. Expulsion, suspension, or any lesser penalty may be imposed for plagiarism. For more information refer to the "Academic Dishonesty" policy in the University Undergraduate Catalog. For this class, it is permissible to assist classmates in general discussions of computing techniques. General advice and interaction are encouraged. Each person, however, must develop his or her own solutions to the assigned projects, assignments, and tasks. In other words, students may not "work together" on graded assignments.

Need for Assistance: If you have any condition, such as a physical or learning disability, which will make it difficult for you to carry out the work as outlined, or which will require academic accommodations, please notify the Instructor as soon as possible.

Academic Calendar: Students should take responsibility for initiating the withdrawal procedure, but are encouraged to talk to the Instructor before taking withdrawal action. In addition, students should note that the Instructor may also withdraw students for non- attendance and failure to complete assignments on a consistent basis.

Incomplete Policy: Students will not be given an incomplete grade in the course without sound reason and documented evidence as described in the Student Handbook. In any case, for a student to receive an incomplete, he or she must be passing and must have completed a significant portion of the course.

Plagiarism: Plagiarism is not tolerated. Students are expected to complete their own work, and copying another student’s work may result in a zero point grade for both students.

Standards of Conduct: Students are expected to abide by all SCF Student Handbook guidelines.

Disability Resource Center Information: SCF has a Disability Resource Center (DRC) to assist students. To request academic accommodations due to a disability, please contact the DRC at 752-5295 in Bradenton or 408-1448 in Venice, or by email at DRC@scf.edu. If you have already requested academic accommodations through the DRC for this course, please meet with your Instructor to discuss your specific needs.

Program Director information: If a student encounters a problem in the course, they should work with the professor to resolve it. If the student needs help and the professor is unable to help or is unavailable, contact:

Program Director - Stephanie Cook 941-752-5281 Bradenton 941-408-1300, ext. 61471 Venice cooks@scf.edu

Tentative Schedule – Subject to Change

		CALENDAR OF ASSIGNEMENTS
Week 1: Introduction to Databases	Introduction of SQL and databases What is a Database? Database Objects	Assignment: Due 8/30 @11:55 pm   Outside Class Assignment: 1.      No assignment or Quiz
Week 2: Introduction to Relational Databases	NO CLASS!   The History of SQL Server and relational databases Relational database history The evolution of SQL Server SQL Server and ANSI standards	Assignment: Due 9/6 @11:55 pm   Outside Class Assignment: 1.      Read Chapter 1 – Getting Started Microsoft SQL Server 2012 (Pages 3-8) 2.      PowerPoint Presentation (SQL Introduction) 3.      Quiz: (25 Pts)
Week 3: Installation	Installing and configuring SQL Server Pre-installation steps Installing SQL Server Configuring the run-time SQL Server system Patching SQL Server - Service packs	Assignment: Due 9/13 @11:55 pm   1.      Read Chapter 2 – Installing, Configuring and Upgrading SQL Server 2012 2.      Quiz (25 Pts)
Week 4: Navigating	Using SQL Server Tools Understanding SQL Server Tools and Utilities Introducing SQL Server Management Studio (SSMS) Introducing SQL Server Configuration Manager	Assignment: Due 9/20 @11:55 pm   1.      Read Chapter 3 – Using SQL Server 2012 & Chapter 4 – Designing SQL Server Databases 2.      PowerPoint Presentation - Navigation 3.      Quiz (25 Pts)
Week 5: Data Types and Databases	Introducing Data Types ·        Built in Data Types ·        Formatting and Converting Data Types ·        Understanding how SQL Server Organizes data Using Databases ·        Planning your Database ·        Understanding Data Structures ·        Creating and Configuring Databases	Assignment: Due 9/27 @11:55 pm   1.      Read Chapter 5 (pages 40-58) – Creating your first Table 2.      PowerPoint Presentation – Data Types 3.      Quiz (25 Pts)
Week 6: Tables and Views	Using Tables ·        Creating Tables ·        Partitioning Tables Using Views ·        Understanding Views ·        Creating Views ·        Modifying data through a view	Assignment: Due 10/4 @11:55 pm   1.      Read Chapter 5 (pages 58-64) – Creating your first Table 2.      PowerPoint Presentation – Querying the Database 3.      Quiz (25 Pts)
Week 6: Constraints, Stored Procedures and Functions	Restricting the Data ·        Introducing Constraints ·        Introducing Primary Keys ·        Introducing Foreign Keys Using Stored Procedures ·        Introducing Stored Procedures ·        Introducing CLR Procedures ·        Processing Stored Procedures Introducing Functions ·        Understanding Functions ·        Creating Functions ·        Understanding deterministic and Nondeterministic functions	Assignment: Due 10/11 @11:55 pm   1.      Read Chapter 5 (pages 64-71) – Creating your first Table 2.      PowerPoint Presentation – Data Integrity 3.      Quiz (25 Pts)
Week 7: Midterm Summary	Overall Summary ·        Work on Midterm Project	Assignment: Due 10/18 @11:55 pm   1.      Midterm Project
Week 8: Querying the Database	Data Manipulation Language ·        The Select Statement ·        Using Joins ·        Using aliases ·        Using Distinct and NULL	Assignment: Due 10/25 @11:55 pm   1.      Read Chapter 10 - The SELECT Statement 2.      PowerPoint Presentation – Querying the Database 3.      Quiz (25 Pts)
Week 9: Permissions, logins, roles and credentials	Guarding your Data ·        Understanding Security ·        Understanding Permissions ·        Creating Logins, Roles	Assignment: Due 11/01 @11:55 pm   1.      Read Chapter 25 – Understanding Security 2.      PowerPoint Presentation – Securing your Database 3.      Quiz (25 Pts)
Week 10: Backup and Restore	Understanding Recovery Overview of SQL Server backup & recovery Incremental backups Restoring a SQL Server database Standby database overview Shipping SQL Server log files to standby databases	Assignment: Due 11/08 @11:55 pm   1.      Read Chapter 20 – Backup 2.      PowerPoint Presentation – Backing Up the Database 3.      Quiz (25 Pts)
Week 11: Stored Procedures and Triggers	Using Triggers ·        Introducing Triggers ·        Understanding DDL Triggers ·        Understanding Trigger Recursion and Nesting	Assignment: Due 11/15 @11:55 pm   1.      Read Chapters 16, 17 & 18 2.      PowerPoint Presentation – Stored Procedures, Functions and Triggers 3.      Quiz (25 Pts)
Week 12: Replication	SQL Server database Replication Microsoft replication architectures Creating a replication topology Configuring SQL Server replication	Assignment: Due 11/22 @11:55 pm   1.      Read Chapter 19 – Replication 2.      Quiz (25 Pts)
Week 13:	Thanksgiving Break – No Class
Week 14: Transactions and Locks and Moving Data	Using Transactions ·        Understanding Transactions ·        Understanding Locks ·        Using Data Manipulation Language (DML) Queries ·        Introducing Error Handling Moving Data ·        Understanding the tools available ·        Using the import/export wizard ·        Copying Databases ·        Introducing XML	Assignment: Due 12/6 @11:55 pm   1.      Quiz (25 Pts)
Week 15: Maintaining, Automating, Monitoring and Optimizing SQL Server	Administrative Activities ·        Maintaining Indexes ·        Understanding Automation Basics ·        Configure Database Mail ·        Creating Scheduled Jobs & Alerts ·        Using Performance Monitor ·        Monitoring with SQL Server Profiler
Final Week: Database Design Project	Discuss and work on your database design projects	Assignment: Due 12/10 @11:55 pm   1.      Database Design Project
FINAL EXAM		Final : Due 12/10 @11:55 pm