SQL Database Programming (T-SQL and PL/SQL)


You are here: [SQL Database Programming (T-SQL and PL/SQL) Syllabus]

Printable Version

SQL Database Programming (T-SQL and PL/SQL): Course Syllabus Spring 2018

Class 1: Thursday, March 01, 2018
  • Introduction to Oracle/SQL Server Database Programming
    • SQL and Database Programming
    • Structure of Database Programs
    • Differences between Oracle and SQL Server
    • Graphical Database Management Tools
Class 2: Thursday, March 08, 2018
  • Quiz 1(closed book)
  • Language Fundamentals of PL/SQL and T-SQL
    • Structure of Programming Code
    • Basic Language Components
    • Datatypes
    • Datatype Conversion
    • Built-in Functions, System Functions
Homework 1 Due Date/Time: Wednesday, March 14, 2018 (Noon)

Class 3: Thursday, March 15, 2018
  • Quiz 2(closed book)
  • Declaring Variables/Constant
    • Variable Declaration Statement
    • Variable Assignment Statement
    • Constants, Default Values, NOT NULL constraint
  • Flow Control Structures
    • Decision Structures
    • Loop Structures
  • Exception Handling
    • Introduction to Exception Handling
    • Basic Exception Handling
    • Programmer-Defined Exceptions
    • Built-In Error Functions
Homework 2 Due Date/Time: Wednesday, March 21, 2018 (Noon)

Class 4: Thursday, March 22, 2018
  • Quiz 3(closed book)
  • Stored Functions
    • Introduction to Functions
    • Writing Basic Functions
    • Integration of Functions and SQL
    • Advanced Functions
Homework 3 Due Date/Time: Wednesday, March 28, 2018 (Noon)

Class 5: Thursday, March 29, 2018
  • Quiz 4(closed book)
  • Stored Procedures
    • Introduction to Stored Procedures
    • Basic Stored Procedures
    • Parameters
    • Overloading Procedures
Homework 4 Due Date/Time: Wednesday, April 18, 2018 (Noon)

Class 6: Thursday, April 19, 2018
  • Quiz 5(closed book)
  • Using Declarative SQL in Procedural SQL
    • DML in Procedural SQL
    • Transaction Management
    • Autonomous Transactions
Homework 5 Due Date/Time: Wednesday, April 25, 2018 (Noon)

Class 7: Thursday, April 26, 2018
  • Quiz 6(closed book)
  • Database Triggers
    • Overview of Triggers
    • DML Trigger Concepts
    • Basic DML Triggers
    • Advanced DML Triggers
    • INSTEAD OF Triggers
Homework 6 Due Date/Time: Wednesday, May 02, 2018 (Noon)

Class 8: Thursday, May 03, 2018
  • Quiz 7(closed book)
  • Cursors
    • Cursor Basics
    • Cursor Parameters
    • Cursor Variables
    • Data Updates Using Cursors
  • Dynamic SQL
    • Overview of Dynamic SQL
    • Basic Dynamic SQL
Homework 7 Due Date/Time: Wednesday, May 09, 2018 (Noon)

Class 9: Thursday, May 10, 2018
  • Quiz 8(closed book)
  • Advanced Dynamic SQL
    • Parameterized Dynamic SQL
    • Dynamic Data Pivoting
    • SQL Injection
  • Advanced Exception Handling
    • Unhandled Exceptions
    • Continue Past Exceptions
    • Exceptions and Transactions
Final Take-Home Exam Due Date/Time: Thursday, May 17, 2018 (before Class)
Class 10: Thursday, May 17, 2018
  • Advanced Topics
    • Optimistic/Pessimistic Concurrency Models
    • Sending E-mail
    • Other Advanced Topics
Grading:
Best 6 out of 8 Quizzes
Best 5 out of 7 Homework assignments
Weighting of Grades:
Quizzes: 50%
Homework 25%
Take-Home Final 25%