Course Syllabus

Department of Business & Technology SYLLABUS for

CET 2433: SQL Implementation

Fall, 2015






Bradenton Campus

Day and Time



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




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.


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.


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.


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.


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.

  1. 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.

  1. 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




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





Number of









Percent of

Final Grade






Class Participation (Assignments)





Database Design Project





Midterm Project





Final Exam










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







Minimum Points for Grade
















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 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

Tentative Schedule – Subject to Change




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



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 : Due 12/10 @11:55 pm


Course Summary:

Date Details Due