Database Management Systems
 Signin
Home | Syllabus |Assignments | SQL Tutorial | SQL Learn | Quick SQL | Downloads | Handouts | MY Page | Contact


Syllabus


Textbook: Fundamentals of Database Systems (4th Edition)

Hardcover: 960 pages
Publisher: Addison-Wesley Publishing; 4th edition
ISBN: 0805317554

The Syllabus is only tentative and might change as the class progresses

 

Week Topic
1

Introduction to databases

  • Relational Databases
  • Object Databases
  • Basic SQL
  • Data types
  • Operators
2

Advanced Queries

  • Joins
  • Built-in Functions
  • Improving Query Performance
  • Group by
  • Stored Procedures
3

Views, Catalogs and Integrity

  • Creating tables
  • Verifying Integrity
  • Creating Views
  • Database Catalog
4

ER Model and Normalization

  • ER Model
  • Normal forms
5

Security, Backup and Recovery

  • Creating users
  • Encrypting traffic
  • Backup of the database
  • Recovery
6

Popular Databases and differences

  • Oracle
  • SQL Server
  • DB2




©Copyright 2009 Gavi Narra