Skip to main content
Side panel
Courses
Programs
Help
Getting Started
Discussion Forums
Help Center & FAQ
Search
Close
Search
Toggle search input
Log in or Sign up
Courses
Programs
Help
Getting Started
Discussion Forums
Help Center & FAQ
CS410: Advanced Databases
Announcements
Sections
Course Introduction
Unit 1: Advanced SQL
Unit 2: Stored Procedures and Triggers
Unit 3: Query Optimization
Unit 4: Concurrency and Recovery
Unit 5: Database System Architectures
Unit 6: Data Warehousing
Unit 7: Object-Oriented and Object-Relational Databases
Unit 8: XML and Databases
Final Exam
Resources
Activities
Forums
Quizzes
Home
My programs
CS410: Advanced Databases
Home
Courses
(hidden)
CS410: Advanced Databases
Announcements
Search forums
Search forums
Back to course 'CS410: Advanced Databases'
Announcements
General news and announcements
(No announcements have been posted yet.)
Jump to...
Jump to...
Course Syllabus
Course Terms of Use
Unit 1 Learning Outcomes
Gonzaga University: Shawn Bowers' "Relational Algebra and Complex SQL"
Gonzaga University: Shawn Bowers' "Relational Algebra and Complex SQL"
TutorialsPoint: "SQL SELF JOINS"
TutorialsPoint: "SQL FULL JOINS"
Tom Jewett's "Database Design with UML and SQL: Union and Minus"
Gonzaga University: Shawn Bowers' "Complex SQL"
TutorialsPoint: "SQL HAVING Clause"
Tom Jewett's "Database Design with UML and SQL: SQL Technique: Views and Indexes"
Unit 2 Learning Outcomes
College of San Mateo: Bob Timlin's "Prepared Statements and Store Procedures and Functions"
MySQL 5.1 Reference Manual: "Stored Procedures and the Grant Table"
MySQL 5.1 Reference Manual: "Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()"
Nguyen Kim Anh's "Structured Query Language"
w3resource: "SQL Constraints"
Oracle Community Wiki: "Triggers Tutorial"
Oracle Community Wiki: "Trigger Development Example"
Unit 3 Learning Outcomes
Indian Institute of Technology Bangalore: S. Srinath's "Query Processing and Optimization I"
Indian Institute of Technology Bangalore: S. Srinath's "Query Processing and Optimization II"
Indian Institute of Technology Bangalore: S. Srinath's "Query Processing and Optimization III"
Gonzaga University: Shawn Bowers' "Query Optimization"
Unit 4 Learning Outcomes
Avi Silberschatz's "Database System Concepts: Transactions"
University of the Pacific: Michael Doherty's "Transactions and Serializability"
Carnegie Mellon University: Gregory Kesden's "Serialization"
Avi Silberschatz's "Database System Concepts: Concurrency Control"
Avi Silberschatz's "Database System Concepts: Recovery System"
Unit 5 Learning Outcomes
Avi Silberschatz's "Database System Concepts: Database System Architectures"
Avi Silberschatz's "Database System Concepts: Parallel Databases"
Avi Silberschatz's "Database System Concepts: Distributed Databases"
Massachusetts Institute of Technology: Stuart Madnick's "Distributed Homogeneous Databases"
Massachusetts Institute of Technology: Stuart Madnick's "Distributed Heterogeneous Databases"
Indian Institute of Technology Madras: D. Janakiram's "Concurrency Control for Distributed Transaction"
Free University of Bozen-Bolzano: Johann Gamper's "Distributed Query Processing"
Unit 6 Learning Outcomes
University of Zurich: Michael Böhlen's "Data Warehousing"
University of Zurich: Michael Böhlen's "SQL OLAP extensions"
University of Zurich: Michael Böhlen's "Generalized Multi-Dimensional Join"
Unit 7 Learning Outcomes
University of Alberta: Osmar Zaïane's "Object-Oriented Databases"
Indian Institute of Technology Bangalore: S. Srinath's "Object Oriented Databases I"
University of California, Santa Cruz: M. Keller's "Object-Relational Databases"
Indian Institute of Technology Bangalore: S. Srinath's "Object Oriented Databases II"
Unit 8 Learning Outcomes
Duke University: Jun Yang's "XML Basics"
Indian Institute of Technology Kharagpur: S. Srinath's "Extensible Markup Language (XML)"
Duke University: Jun Yang's "XPath, XQuery"
Duke University: Jun Yang's "XSLT"
Indian Institute of Technology Bangalore: S. Srinath's "XML Databases"
CS410: Certificate Final Exam
CS410: Proctored Final Exam
Next