Syllabus for ITS-231
Database Programming is a database technology course focused on database programming. Topics include the relational data model, structured query language (SQL), data definition language (DDL), data control language (DCL), data manipulation language (DML) commands, database programming, event triggers, stored procedures, query plans, and query optimization techniques.
After completing this course, students should be able to:
CO1 Use SQL commands to restrict and sort data.
CO2 Use single-row functions to manipulate data.
CO3 Report aggregated data using group functions.
CO4 Manipulate and display data from multiple tables.
CO5 Use subqueries to solve complex data manipulation problems.
CO6 Use the set operators to manipulate data.
CO7 Create, manipulate, and manage schema objects.
CO8 Manipulate large data sets.
CO9 Develop and use regular expressions.
CO10 Configure database user access following industry best practices.
CO11 Configure database firewall rules following industry best practices.
CO12 Discuss the concepts behind database auditing and forensics.
You will need the following materials to do the work of the course.
The following uCertify course will serve as the virtual textbook for the course:
uCertify provides interactive online courses that help students prepare for various certification exams. In completing your coursework, you will be using parts of the uCertify course as an interactive textbook with chapters and lessons, quizzes, exercises, and more to aid in learning about topics in database programming.
Access to the uCertify course is provided through the uCertify: 1Z0-047 - Oracle Database SQL Expert link located in the uCertify Assignments section of the course website. When you click the link (LTI connector) for the first time, you will be redirected to a paywall that will ask you for a one-time payment. Once you have made your payment, you will have access to the uCertify course and can navigate to specific chapters and lessons (uCertify uses these designations interchangeably) and all associated activities (quizzes, exercises, assessments, etc.) through the student dashboard.
Database Programming is a three-credit, online course consisting of six modules. Modules include an overview, topics, learning objectives, study materials, and activities. Module titles are listed below.
For your formal work in the course, you are required to participate in online discussion forums, complete written assignments, complete uCertify activities (quizzes and exercises), complete the uCertify Post-Assessment, and complete a final project. See below for details.
Consult the Course Calendar for due dates.
In completing your coursework, you will be using parts of the uCertify course. Access to the uCertify course is found through the link located in the top section of the IAS-231 course website. In addition to studying one or more lessons each week (completing the flashcards, in-lesson quiz items, and exercises), you are required to submit the results of three lesson quizzes located in Modules 1, 2, and 3 to your mentor for grading.
Each uCertify lesson includes a lesson quiz. Access the quiz by going to the uCertify Table of Contents and selecting “Quizzes” for the lesson. To receive credit for the quiz, you must score 100% on the quiz when taken in Test mode. You may initially take the quiz in Learn or Review mode, but to receive credit for this activity, you must ultimately score 100% on the quiz when taken in Test mode.
Lesson quizzes are formative activities. You may take them as many times as necessary. At the end of the test, once you have achieved a score of 100%, share your results by downloading the PDF file and submitting it to the mentor using the appropriate assignment link in Moodle located in Modules 1, 2, and 3.
uCertify includes a Post-Assessment. Access the Post-Assessment by going to the uCertify Table of Contents and selecting “Post-Assessment.” To receive credit for the Post-Assessment, you must achieve a score of 90% or higher when taken in Test mode. You may initially take the Post-Assessment in Learn or Review mode, but to receive credit for this activity, you must ultimately score 90% or higher on the Post-Assessment when taken in Test mode.
You may take the Post-Assessment multiple times, if necessary. At the end of the test, once you have achieved a score of 90% or higher, share your results by downloading the PDF file and submitting it to the mentor using the appropriate assignment link in Moodle located in Module 5.
Database Programming has six graded online discussions. There is also an ungraded but required Introductions Forum in Module 1.
Communication with the mentor and among fellow students is a critical component of online learning. Participation in online discussions involves two distinct activities: an initial response to a discussion question and at least two subsequent comments on a classmate's response. Meaningful participation is relevant to the content, adds value, and advances the discussion. Comments such as "I agree" and "ditto" are not considered value-adding participation. Therefore, when you agree or disagree with a classmate, the reading, or your mentor, state and support your agreement or disagreement.
You will be evaluated on the quality and quantity of your participation, including your use of relevant course information and your awareness of and responses to the postings of your classmates. Remember, these are discussions. Responses and comments should be properly proofread and edited, professional, and respectful.
You are required to complete five written assignments. The written assignments are on a variety of topics associated with the course modules.
The final project consists of two parts: a lab assignment and a research report. The lab assignment serves as a hands-on experience pertaining to the topics covered during this course, while the research report allows you to investigate a database security topic in greater depth.
Note: The database created in the lab assignment of the final project can be created on one of the major cloud platforms (AWS/Azure/Google Cloud) using a free student account. Otherwise, you may utilize any database tool available such as OpenOffice Base, MySQL, or Microsoft Access. Refer to these helpful links below:
Download SQL Server Express
Student/Educational Microsoft Azure Account
Microsoft Azure SQL Server Quick Start
SQL Server Tutorials
OpenOffice (Free Download)
MySQL Install for Windows
Be sure to reference the Final Project area of the course website for full requirements and details. Consult the Course Calendar for due dates.
Your grade in the course will be determined as follows:
To receive credit for the course, you must earn a letter grade of C or better (for an area of study course) or D or better (for a course not in your area of study), based on the weighted average of all assigned course work (e.g., exams, assignments, discussion postings).
To succeed in this course, take the following first steps:
Consider the following study tips for success:
If you copy phrases, sentences, paragraphs, or whole documents word-for-word—or if you paraphrase by changing a word here and there—without identifying the author, or without identifying it as a direct quote, then you are plagiarizing. Please keep in mind that this type of identification applies to Internet sources as well as to print-based sources. Copying and pasting from the Internet, without using quotation marks and without acknowledging sources, constitutes plagiarism. (For information about how to cite Internet sources, see Online Student Handbook > Academic Standards > Citing Sources.)
Examples of Unintentional Plagiarism
When to Quote and When to Paraphrase
Writing Assistance at Smarthinking
Originality Report Checking at Turnitin
Acts of both intentional and unintentional plagiarism violate the Academic Code of Conduct.
Possible sanctions include:
Copyright © 2017 by Thomas Edison State University. All rights reserved.