Scribd
Upload
29 views2 pages

Course Descriptions: Book Website

This course provides an introduction to database systems from a user/developer perspective, covering topics such as querying with SQL and relational algebra, designing database schemas with ER/UML diagrams, normalization, and programming with database APIs. Students will learn how to construct database-driven applications and work with current database technologies. The course also introduces database application development using Java and Oracle database, covering concepts like the relational model, SQL, PL/SQL, and database indexing, transactions, and concurrency control.

Uploaded by

Vladd Diaz Khann
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
29 views2 pages

Course Descriptions: Book Website

This course provides an introduction to database systems from a user/developer perspective, covering topics such as querying with SQL and relational algebra, designing database schemas with ER/UML diagrams, normalization, and programming with database APIs. Students will learn how to construct database-driven applications and work with current database technologies. The course also introduces database application development using Java and Oracle database, covering concepts like the relational model, SQL, PL/SQL, and database indexing, transactions, and concurrency control.

Uploaded by

Vladd Diaz Khann
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Course Descriptions

This course provides an introduction to Database systems from user/developer perspective:


querying using SQL and relational algebra, design database schemas using ER/UML diagrams,
normalization, and programming using database APIs. Construction of database-driven
applications (e.g., websites, e-commerce) and experience with current database technologies.
We will cover the following topics:
- Database Introductions, Basic Concepts
- Database System Concepts and Architecture
- Relational Model
- Relation Algebra
- SQL
- Database Application Development: JAVA
- Data Modelling Using the Entity-Relationship (ER) Model
- Transform ER Schema to Relational Schema
- PL/SQL
- Views, Stored Procedures, Triggers
- Database Application Development: JAVA
- Introduction to Indexing
- Introduction to Transaction and Locking
- Introduction to Concurrent Control
- Other topics: Distributed Databases, Column stores vs. Row stores, NoSQL

Textbooks:
Required:
Database System Concepts (Sixth Edition) by Avi Silberschatz, Henry F. Korth, S.
Sudarshan book website.(link is external)

Recommended:

 Database Management Systems, (Third Edition), by Raghu Ramakrishnan and


Johannes Gehrke. McGraw Hill, 2003 book website(link is external).
 Oracle Database 11g SQL and PL/SQL: A Brief Primer. download/pdf(link is
external)
 ORACLE 10g PROGRAMMING A Primer. Rajshekhar Sunderraman. book
website(link is external)

Topics covered:

Course goals:
Database systems from user/developer perspective: querying using SQL and relational
algebra, design database schemas using ER/UML diagrams, normalization, and
programming using database APIs. Construction of database-driven applications (e.g.,
websites, e-ecommerce) and experience with current database technologies.

Attendance policy:
Attendance to all meetings of the class is mandatory.

Topics covered:
This course also introduces database application development using Java and Oracle
database. We will cover the following topics:
- Database Introductions, Basic Concepts
- Database System Concepts and Architecture
- Relational Model
- Relation Algebra
- SQL
- Database Application Development: JAVA
- Data Modelling Using the Entity-Relationship (ER) Model
- Transform ER Schema to Relational Schema
- PL/SQL
- Views, Stored Procedures, Triggers
- Database Application Development: JAVA
- Introduction to Indexing
- Introduction to Transaction and Locking
- Introduction to Concurrent Control
- Other topics: Distributed Databases, Column stores vs. Row stores, NoSQL

You might also like