Module: SQL in a server environment

Introduction to SQL on servers.

Learning Outcomes

Be able to write a program that interacts with a DBMS server

You understand client-server computing in the context of DBMSs
You understand how a host programming language environment interacts with the SQL environment
You are proficient in writing Java programs that interacts with a DBMS server via the JDBC API.

Readings

Chapter 9: SQL in a server environment

Introduction to SQL servers

50 pages

SQL Server

Basics of networking, three tier architecture

Lecture Notes

SQL in a server (Part 2)

ODBC, JDBC, Stored Procedures, UDFs

Lecture Notes

JDBC & JSF

JDBC & JSF

Documentation & Examples

Experiential Learning

Exercise 9

How does an app talk to a DB?

JDBC example

Sample code to run JDBC

HW3: Web App

Program a simple web application

Assignment 3