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

Currently no courses scheduled for this term.

Class 1

  • 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

  • Language Fundamentals of PL/SQL and T-SQL
    • Structure of Programming Code
    • Basic Language Components
    • Datatypes
    • Datatype Conversion
    • Built-in Functions, System Functions

Class 3

  • 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

Class 4

  • Stored Functions
    • Introduction to Functions
    • Writing Basic Functions
    • Integration of Functions and SQL
    • Advanced Functions

Class 5

  • Stored Procedures
    • Introduction to Stored Procedures
    • Basic Stored Procedures
    • Parameters
    • Overloading Procedures

Class 6

  • Using Declarative SQL in Procedural SQL
    • DML in Procedural SQL
    • Transaction Management
    • Autonomous Transactions

Class 7

  • Database Triggers
    • Overview of Triggers
    • DML Trigger Concepts
    • Basic DML Triggers
    • Advanced DML Triggers
    • INSTEAD OF Triggers

Class 8

  • Cursors
    • Cursor Basics
    • Cursor Parameters
    • Cursor Variables
    • Data Updates Using Cursors
  • Dynamic SQL
    • Overview of Dynamic SQL
    • Basic Dynamic SQL

Class 9

  • Advanced Dynamic SQL
    • Parameterized Dynamic SQL
    • Dynamic Data Pivoting
    • SQL Injection
  • Advanced Exception Handling
    • Unhandled Exceptions
    • Continue Past Exceptions
    • Exceptions and Transactions

Class 10

  • Advanced Topics
    • Optimistic/Pessimistic Concurrency Models
    • Sending E-mail
    • Other Advanced Topics