(r3) CSC210SylS2022 < CenterForComputing

Tags: view all tags
%INCLUDE{CSC210ForSyllabus}%

---++ Details
   * Professor: Dr. Cathy Bareiss
   * Office SB 031
   * Class Time: MW 9:00-9:50
   * Class Location: S 025 or zoom
   * Textbook: 
      1. <u>Oracle SQL: A Beginner's Tutorial, Second Edition</u> by Djoni Darmawikarta.  ISBN: 9781771970303
      1. <u>SQL Primer: An Accelerated Introduction to SQL Basics</u> by Rahul Batra.  ISBN: 9781484235751
      1. <u>Practical SQL:  A Beginner's Guide to Storytelling with Data</u> by Anthony DeBarros.  ISBN: 9781593278274
      1. <u>SQL: A Beginner's Guide, Fourth Edition</u> by Andrew Oppel
      1. <u>Introduction to SQL and PL/SQL</u> by Sharad Maheshwari.  ISBN: 9780071842594
   * Resources:  All the <u>Oracle Database 12c - Introduction to SQL</u> courses found on !SkillSoft of the learning center of ACM
      1. First one:  Oracle Database 12c - Introduction to SQL: SQL*Plus and SELECT statement

---++ Course Content
---+++ Policies
   * [[AcceptableWork][Integrity]]
   * [[LatePolicy][Late Work]]

---+++ Assignments
---++++Homework Assignments
   1. [[CSC210S2022SyllabusHome1][ Simple SQL]]
   1. [[CSC210S2022SyllabusHome2][ Aggregation and joins]]
   1. [[CSC210S2022SyllabusHome3][ Nested and advanced SQL]]

---++++Lab Assignments
   1. [[CSC210S2022SyllabusLab1][ Simple SQL]]
   1. [[CSC210S2022SyllabusLab2][ Aggregation and joins]]
   1. [[CSC210S2022SyllabusLab3][ Nested and advanced SQL]]
   1. [[CSC210S2022SyllabusLab4][ ER Diagramming]]


---+++ Grades
   * Homework, etc. is worth 10% of the final grade
   * Programs are worth 40% of the final grade
   * Exams are worth 50% of the final grade with the cumulative final being worth twice a normal exam
   * Grade scale
      * 93% &lt;= average &lt;= 100% -&gt; A
      * 90% &lt;= average &lt; 93% -&gt; A-
      * 87% &lt;= average &lt; 90% -&gt; B+
      * 83% &lt;= average &lt; 87% -&gt; B
      * 80% &lt;= average &lt; 83% -&gt; B-
      * 77% &lt;= average &lt; 80% -&gt; C+
      * 73% &lt;= average &lt; 77% -&gt; C
      * 70% &lt;= average &lt; 73% -&gt; C-
      * 67% &lt;= average &lt; 70% -&gt; D+
      * 63% &lt;= average &lt; 67% -&gt; D
      * 60% &lt;= average &lt; 63% -&gt; D-
      * 0% &lt;= average &lt; 60% -&gt; F

---+++ Tentative Schedule
| *Monday* 	|  *Wednesday* 	| *Friday* 	|
| Jan 10: 		|  Jan 12:			| Jan. 14:	Introduction to Database		|
| Jan 17: Introduction to SQL 	| Jan 19:	Introduction to SQL		| Jan. 21:	Database and in class work		|
| Jan 24: Joins<br>Homework 1 due		|  Jan 26:	Joins		| Jan. 28: Joins<br>Lab 1 due			|
| Jan 31: in class work		|  Feb 2: nested queries			| Feb. 4:Exam 1			|
| Feb 7: nested queries<br>Homework 2 due 		|  Feb 9: Sets		| Feb. 11: In class work			|
| Feb 14: SQL reports<br>Lab 2 due		|  Feb 16:	 Security		| Feb. 18:	Privacy<br>Homework 3 due		|
| Feb 21: SQL		|  Feb 23: Current topic			| Feb. 25:	<br>Lab 3 due		|
| Feb 28: 		|  Mar 2: Exam 2			| Mar. 4: Class cancelled<br>SIGCSE		|
| Mar 7: <br>Spring Break	| Mar 9:<br>Spring Break	| Mar. 11:<br>Spring Break	|
| Mar 14: ER diagrams		| Mar 16: ER Diagrams		| Mar. 18: ER Diagrams			|
| Mar 21: ER Diagrams<br>Homework 4 due		| Mar 23: Constraints			| Mar. 25:	Views, etc.		|
| Mar 28: In class work		| Mar 30: Normalization<br>Lab 4 (ER lab) Due			| Apr. 1: Normalization			|
| Apr 4: Exam 3		| Apr. 6: Normalization			| Apr. 8: Transaction processing			|
| Apr 11: Transaction processing		| Apr. 13: Transaction processing			| Apr. 15:<br>Easter Break	|
| Apr 18: Advanced database		| Apr. 20: Exam 4			| Apr. 22: Advanced databases			|
| Apr 25: Indexes		| Apr. 27:	Indexes		| Apr. 29:			|
| Apr 2:		|  Apr. 4:			| Apr. 6:			|
%INCLUDE{CampusPolicies2021}%
Topic revision: r3 - 2021-12-06 - cathybareiss