|
NORTH CENTRAL TEXAS COLLEGE
COURSE SYLLABUS
|
|
|
Course Title:
|
Introduction to Oracle SQL
|
|
Course Prefix & Number:
|
ITSE 1345
|
Section Number:
|
0340
|
Semester/Year:
|
2021 SP
|
|
Semester Credit Hours:
|
3
|
Lecture Hours:
|
32
|
Lab Hours:
|
32
|
|
Course Description (NCTC Catalog):
This is an introduction to the design and creation of relational databases using Oracle. Topics include storing, retrieving, updating, and displaying data using Structured Query Language (SQL).
|
|
Course Prerequisite(s): ITSE 1303 or Proven Basic SQL Knowledge
|
|
Required Course Materials:
Murach, Joel, Murach’s Oracle SQL and PL/SQL for developers, 2nd edition
ISBN: 978-1-890774-80-6
Software: instructions regarding software will be given in class
• Oracle Database Express Edition 12c (a free download)
• Oracle SQL Developer 4.0 or later (a free download)
|
| |
|
|
|
|
|
|
INSTRUCTOR INFORMATION
|
Name of Instructor:
|
Manuel Trevino, Jr.
|
|
Campus/Office Location:
|
IT Career Connection Center, room 102 (Online office Hours are available by appointment using WebEx)
|
|
Telephone Number:
|
940-498-6440 extension 6480 *
|
|
E-mail Address:
|
mtrevino@nctc.edu *
|
|
Name of Chair/Coordinator:
|
Susan Svane
|
|
Office Location:
|
Room 233
|
|
Telephone Number:
|
940-498-6292
|
|
E-mail Address:
|
ssavne@nctc.edu
|
OFFICE HOURS
|
Monday
|
Tuesday
|
Wednesday
|
Thursday
|
Friday
|
|
9:00am to 3:00pm
|
9:00am to 3:00pm
|
9:00am to 3:00pm
|
9:00am to 3:00pm
|
Unavailable
|
| |
|
|
|
|
|
Currently office hours are remote. Email or call for availability
* Instructor Response Time - Please allow 24 hours during the week and 48 hours on the weekend for responses
STUDENT LEARNING OUTCOMES (From Academic Course Guide Manual/Workforce Education Course Manual/NCTC Catalog
|
At the successful completion of this course the student will be able to:
|
|
Write Structured Query Language (SQL) statements using Oracle
|
|
Select and sort data
|
|
Produce reports with SQL*Plus
|
|
Create and manage tables with include constraints
|
|
Create Views and other database objects
|
PROGRAM CAPSTONE REQUIREMENTS
The capstone for the all Information Technology Certificates is a comprehensive program exam with a score of 70% or higher. Exam must be scheduled with the Department Chair upon completion of a certificate.
The capstone requirement for the all Information Technology AAS Degrees is a program specific course directly related to the degree. This course may not be substituted and should be taken the last semester before graduation. You will find more information about the capstone course for your degree in the catalog.
GRADING CRITERIA
|
# of Graded Course Elements
|
Graded Course Elements
|
|
|
Points Contribution to Overall
|
|
Points per Assignment
|
Total Points
|
|
15
|
Discussion Forum Assignments
|
20
|
300
|
17.86%
|
|
14
|
Lab Assignments
|
50
|
700
|
41.67%
|
|
14
|
Quizzes
|
20
|
280
|
16.67%
|
|
4
|
3 Exams & Final Exam (Respondus Monitor Required)
|
100
|
400
|
23.80%
|
|
|
TOTAL
|
|
1680
|
100.00%
|
|
*Students found plagiarizing in an assignment in this course may receive an "F" for the course along with a report turned into the Dean for Scholastic Dishonesty.
|
|
*Students with continued absences and discussion posts that add no value will receive a “0” for the assignment. The class discussion forums and exams will be used to determine regular attendance.
|
|
*Web access during exams is prohibited. The exams will require Respondus Monitoring.
|
|
Total
|
Letter
|
Final %
|
Grading in this course is point driven. The maximum number of points may vary semester to semester.
|
|
Points
|
Grade
|
Labs and Discussion assignments will be graded within one weeks after due date.
|
|
1512 to 1680
|
A
|
90 to 100
|
|
|
1344 to 1511
|
B
|
80 to 89.9
|
|
|
1176 to 1343
|
C
|
70 to 79.9
|
|
|
1008 to 1175
|
D
|
60 to 69.9
|
|
|
< 1007
|
F
|
< 60
|
|
| |
|
|
|
|
|
|
|
COURSE SUBJECT OUTLINE
|
Chapter 1 An introduction to relational databases and SQL
|
• Describe the way a client accesses the database on a server using these terms: application software, data access API, database management system, SQL query, and query results.
• Describe the way a relational database is organized using these terms: tables, columns, rows, cells, primary keys, and foreign keys.
• Identify the three types of relationships that can exist between two tables.
|
|
Chapter 2 How to use Oracle SQL Developer and other tools
|
Describe the function of each of these client tools: the Database Home Page, SQL*Plus, Oracle SQL Developer, and the SQL Reference manual.
|
|
Chapter 7 How to insert, update, and delete data
|
• Describe the use of the COMMIT and ROLLBACK statements when you’re using INSERT, UPDATE, and DELETE statements.
• Explain how to handle null values and default values when coding INSERT and UPDATE statements.
|
|
Chapter 8 How to work with data types and functions
|
• Describe the data that can be stored in any of the character, numeric, date/time, and large object data types.
• Describe how the use of functions can solve the problems associated with (1) sorting string data that contains numeric values, and (2) doing date or time searches
|
|
Chapter 9 How to design a database
|
• Give three criteria for when a column should be indexed.
• Describe referential integrity.
• Explain how Oracle uses declarative referential integrity to prevent deletion, insertion, and update problems.
• Explain how normalizing a database to the third normal form affects database performance.
|
|
Chapter 10 How to create tables, indexes, and sequences
|
• Describe how each of these types of constraints restricts the values that can be stored in a table: not null, unique, primary key, foreign key, and check.
• Describe the difference between a column-level constraint and a table-level constraint.
• Describe the use of an index.
• Describe the use of a sequence.
|
|
Chapter 11 How to create views
|
• Describe a view.
• Describe the benefits of using views.
• Given a view, determine whether it is updatable.
• Describe the effect of the WITH CHECK OPTION clause on an updatable view.
|
|
Chapter 12 How to manage database security
|
• Distinguish between system privileges and object privileges.
• Describe what a user can do when given any of these privileges for an Oracle object: Select, Update, Insert, Delete, and Execute.
• Describe how the tablespace allocation for a user affects what the user can do.
• Distinguish between public and private synonyms.
|
|
Chapter 13 How to write PL/SQL code
|
• Describe the use of a cursor.
• Describe the three types of PL/SQL collections: varrays, nested tables, and associative arrays.
• Describe a predefined exception and the procedure for handling one.
• Describe the scopes of regular variables and bind variables.
• Distinguish between a bind variable and a substitution variable.
|
|
Chapter 14 How to manage transactions and locking
|
• Describe the use of transactions.
• Describe the use of save points.
• Describe the way locking helps prevent concurrency problems.
• Describe the way the transaction isolation level affects concurrency problems and performance.
• Describe a deadlock.
• Describe three techniques that can reduce deadlocks.
|
|
Chapter 15 How to code stored procedures and functions
|
• Explain why a stored procedure executes faster than an equivalent SQL script.
• Describe the difference between passing parameters by position and passing them by name.
• Describe the basic process for validating data within a stored procedure or function.
• Describe the benefits of using packages for stored procedures and functions.
|
|
Chapter 16
How to code triggers
|
• Distinguish between a statement-level trigger and a row-level trigger.
• Describe how a trigger can be used to: enforce data consistency, work with sequences, or make a view updatable.
• Describe the operation of a compound trigger.
• Describe the mutating-table error.
|
|
Chapter 17
How to work with timestamps and intervals
|
- Describe these terms: time zone, session time zone, database time zone.
- Describe these TIMESTAMP data types: TIMESTAMP, TIMESTAMP WITH LOCAL TIME ZONE, and TIMESTAMP WITH TIME ZONE.
Describe these INTERVAL data types: INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND.
|
|
Chapter 18
How to work with large objects
|
• Describe any of the new LOB data types: CLOB, NCLOB, BLOB, and BFILE.
• In general terms, describe the way you use SQL to migrate from the old LOB data types to the new ones.
• In general terms, describe the way you use Java to read the LOB types from a table and to write the LOB types to a table.
• Describe the DBMS_LOB package.
|
Regular and punctual attendance is expected of all students in all classes for which they have registered. All absences are considered to be unauthorized unless the student is absent due to illness or emergencies as determined by the instructor. It is the student responsibility to provide documentation as to the emergency for approval and judgement by the faculty member. Approved college sponsored activities are the only absences for which a student should not be held liable and only when provided by a college official ahead of the absence. Valid reasons for absence, however, do not relieve the student of the responsibility for making up required work. Students will not be allowed to make up an examination missed due to absence unless they have reasons acceptable to the instructor. A student who is compelled to be absent when a test is given should petition the instructor, in advance if possible, for permission to postpone the exam. Student will be dropped from a class by the Registrar upon recommendation of the instructor who feels the student has been justifiably absent or tardy a sufficient number of times to preclude meeting the course’s objectives. Persistent, unjustified absences from classes or laboratories will be considered sufficient cause for College officials to drop a student from the rolls of the College. From Board Policy FC (LOCAL)
Last day to withdraw from a course with a “W” is April 3, 2021.
COVID-19 STATEMENTS
|
Syllabi Statements Spring 2021 - COVID-19 Specific
Conversion of Onsite Classes to Online/Remote Format: North Central Texas College students should be aware that in the event of a college closure due to COVID-19, onsite classes will be converted to an online/remote format. Students should plan ahead to ensure they have access to the computer equipment (either PC, MAC, or tablet), webcam, and internet connectivity to continue their classes in an online/remote format. Please read all your official North Central Texas College student emails as the transition from onsite to online/remote might require a reorganization in your personal situation. Students will be granted a 72-hour transition and grace period. Online classes will continue as scheduled without disruption. Wear a mask, stay safe, and contact your Instructor as the situation arises. These policies and procedures were updated on July 30, 2020 and are subject to change as conditions change.
Face Coverings: Per the North Central Texas College guidance on face coverings on campus, in the instructional setting, faculty and students must wear face coverings, such as masks or face shields. Students without coverings, or those who do not comply with the rules relating to face coverings, will not be able to participate in on-campus classroom activities. To request an exception to this requirement, students should contact the NCTC HR Office of Enrollment Management (ccove@nctc.edu). Failure to comply with the face coverings requirement may result in the Instructor directing the student to leave the classroom. Any student asked to leave the classroom may be referred to the student conduct officer. These policies and procedures were updated on July 30, 2020 and are subject to change.
Temporary COVID-19 Attendance Policy for Face-to-Face Meetings: We are facing an unprecedented situation in which all of us must be flexible and make prudent decisions in the best interest of our families, our campus, and our community. In light of this, North Central Texas College is temporarily establishing the requirement that faculty keep records of student attendance for face-to-face course meetings as well as a documented seating chart. In addition, students who are sick or need to quarantine should not attend classes. Students will not be required to provide formal documentation from a health care provider and will not be penalized for COVID-19 related absences when proper notification to campus health officials is made in accordance with the guidelines stated below.
Faculty will:
- Notify students about important course information and delivery changes through Canvas and campus email.
Students should:
- Provide notification to campus officials (via NCTC Daily Health Check protocol through Canvas) if they have tested positive for COVID-19 or have to quarantine so we can confirm reported absence with instructors, monitor, and assist the campus community.
- Notify instructors in advance of the absence.
- Connect with that class through Webex if the class session is being transmitted in a hybrid fashion.
- Keep up with and/or make up missed classwork or assignments.
- Submit assignments digitally through Canvas or other means as announced by your instructor.
- Work with their instructors to reschedule exams, labs, and other critical academic activities described in the course syllabus.
- Check Canvas and campus email daily to receive important announcements pertaining to the course.
During the spring 2021 semester, faculty with face-to-face meetings will establish assigned seating/work stations to facilitate roll-taking, and, if necessary, contact tracing. Additionally, we ask all members of the College community to be attentive to their health, and safeguard others, by following the CDC’s guideline to “stay home when you are sick.” You should stay home if you have symptoms. More information on what to do if you are sick is available at the CDC’s website.
Additional NCTC information is available at http://www.nctc.edu/coronavirus/index.html
|
DISABILITY SERVICES (Office for Students with Disabilities)
The Office for Students with Disabilities (OSD) provides support services for students with disabilities, students enrolled in technical areas of study, and students who are classified as special populations (i.e. single parents).
Support services for students with disabilities might include appropriate and reasonable accommodations, or they may be in the form of personal counseling, academic counseling, career counseling, etc. Furthermore, OSD Counselors work with students to encourage self-advocacy and promote empowerment. The Counselors also provides resource information, disability-related information, and adaptive technology for students who qualify.
If you feel you have needs for services that the institution provides, please reach out to either Wayne Smith (940) 498-6207 or Yvonne Sandman (940) 668-4321. Alternative students may stop by Room 170 in Corinth or Room 110 in Gainesville.
CORE CURRICULUM FOUNDATIONAL COMPONENT AREA (For classes in the Core)________
o Communication
o Mathematics
o Life and Physical Science
o Language, Philosophy & Culture
o Creative Arts
o American History
o Government/Political Science
o Social and Behavioral Sciences
o Component Area Option
REQUIRED CORE OBJECTIVES (For classes in the Core)
x Critical Thinking
x Communication
x Empirical and Quantitative
x Teamwork
x Personal Responsibility
x Social Responsibility
x Academic General Education Course (from ACGM but not in NCTC Core)
o Academic NCTC Core Curriculum Course
o WECM Course
Students are expected to follow all rules and regulations found in the student handbook and published online.
Scholastic dishonesty shall include, but is not limited to cheating, plagiarism, academic falsification, intellectual property dishonesty, academic dishonesty facilitation and collusion. Faculty members may document and bring charges against a student who is engaged in or is suspected to be engaged in academic dishonesty. See Student Handbook, “Student Rights & Responsibilities: Student Conduct ([FLB(LOCAL)]”.
Consequences for academic dishonesty may include:
- Zero for the work
- Academic suspension
|
QUESTIONS, CONCERNS, or COMPLAINTS
|
Manuel Trevino, Jr
|
|
Office Location:
|
IT Career Connection Center, room 102 (Online office Hours are available by appointment)
|
|
Telephone Number:
|
940 498 6440 x6516
|
|
E-mail Address:
|
mtrevino@nctc.edu
|
|
Name of Chair/Coordinator:
|
Susan Svane
|
|
Office Location:
|
Room 232, Corinth Campus
|
|
Telephone Number:
|
940 498 6292
|
|
E-mail Address:
|
ssavne@nctc.edu
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
STUDENT SUPPORT SERVICES
|
Support Services
Counseling and Testing staff offer a variety of services to current and prospective students, such as College 101, placement testing, academic advising and course registration, transfer assistance, and College Success seminars (Time Management, Study Skills, Test Anxiety, Choosing a Major, Learning Style Strategies, Career Exploration), and much more. http://www.nctc.edu/StudentServices/CounselingTesting.aspx
Student Success offers academic coaching, tutoring, including a Writing Center, a Math Lab, free 24/7 online tutoring through Grade Results and assist new students acclimate to college by providing computer lab services for prospective students. First generation students can also participate in TRIO which offers specialized support services. http://www.nctc.edu/StudentServices/SupportServices.aspx
Financial Aid offers financial resources for students that qualify, visit the financial aid offices for more information. http://www.nctc.edu/FInancialAidHome.aspx
Early Alert and NCTC Cares
The NCTC Early Alert program has been established to assist students who are at risk of failing or withdrawing from a course. Your instructor may refer you to this program if you are missing assignments, failing tests, excessively absent, or have personal circumstances impacting your academic performance. If submitted as an Early Alert you will be notified via your NCTC e-mail address and then contacted by a Counseling and Testing advisor or counselor to discuss possible strategies for completing your course successfully.
The NCTC CARES (Campus Assessment Response Evaluation Services) Team addresses behavior which may be disruptive, harmful or pose a threat to to the health and safety of the NCTC community-such as stalking, harassment, physical or emotional abuse, violent or threatening behavior, or self-harm. As a student, you have the ability to report concerning behavior which could impact your own safety or the safety of another NCTC student. Just click the NCTC CARES Team logo posted on MyNCTC, or send an e-mail to CARESTeam@nctc.edu. As always, if you feel there is an immediate threat to your own safety or welfare (or to another student), please call 911 immediately.
|
|
Tobacco-Free Campus
NCTC restricts the use of all tobacco products including cigarettes, cigars, pipes and smokeless tobacco on campus property.
|
|
NOTICE: Some grades for this course may post in Canvas. Those grades will be correct only relative to the assignments that are graded by instructor. The course average and other numeric computations that show in Canvas may or may not be correct. As college students you should use the above provided format to follow your grade progress. Your final grade is obviously a sum of the ratios of the four component grades. The very best approach is to accumulate as many points as you can as the semester goes along. If you miss an opportunity to earn points for any reason then, those points are lost. Remember to participate in posted assignments during the time frame allowed.
NOTICE: Some assignments required participation on more than one date. Being absent on either date will cause you to NOT get points for the related assignment or activity. Attendance is mandatory. This course operates much like a business with you as the employee who is expected to show up for all work assignments.
|