Topics for Final


Chapt 3, 4: The Structured Query Language

- Retrieve information from  a table using a Select statement
	- Understand how to use where clauses with compound conditions and compare different data types
	- Understand how to use group by
	- Must be able to join tables
	- compound conditions
- Update Information on a table based on a specific criteria
- Delete records based on a certain criteria
- Insert data into tables.
- Add constraints
- Add a foreign key to a table

Data Definition Language Statements:
- Create a table/ View
- Remove a table / view
- Create a stored procedure with parameters or optional parameters.
	- Use variables within a stored procedure
- Create a trigger to perform logic on a table
- Create an Index on an SQL object
- Create a user defined function

Chapt 5: Database Design: Normalization

- Understand how to diagram functional dependencies.
- Normalize a table to 3rd normal form (3NF).


Chapt 6: Database Design: 

- Information level design, Physical level design
- Creating Cumulative design and user views
- Understand the Database Design Language
- Understand the different type of keys
- Understand ER Diagrams


Chapt 7: DBMS Functions:

- Understand in detail the concurrent update or Lost update problem.
- Understand Two Phase Locking. How would you describe a scenario?
- Exclusive Lock/ Shared Lock
- Understand what is the DB Journal or log file, what it contains, and why is important.
- What are backward recovery and forward recovery? How do you implement each.
- Index creation and what's the purpose of an index.

Chapt 8: Database Administration

- What is the criteria a DBA uses to evaluate a DB and would be the most important to you?
	- Backup and recovery, Cost, Concurrent update, Performance,Security, Documentation....
- What are some of the responsibilities of a DBA?
- Understand the process of Archiving.
- Understand the process of Replication.
- Lifecycle of a Deployment and testing.

Chapt 9: Database Approaches

- Understand the characteristics and fundamentals of a Distributed Database
	- Location Transparency, Fragmentation Transparency, Replication Transparency: What does this mean for 
	  the user?
	- What are the differences of a distributed DBMS and a local DBMS
- DDBMS communications (messages) and how is the communication time computed.
- DDBMS Complex Query Mechanishm / Rollback
- Local / Global Deadlock
- Understand various archicteture paradigms
	- Client Server (2 tier)  architecture
	- Three tier architecture / N- Tier architecture
	- Web architecture 
	- XML: Purpose/ Structure
- NOSQL- Document Oriented Database (MongoDB)
	- What is the structure of Mongo DB
	- Why is it considered an advantage over RDBMS
-Data Warehouse: What's it used for?
-	What makes a warehouse different than a regular transactional DB?
- 	How is the data structured?
- 	What is an OLAP system and what is it used for?
- Object Oriented Databases: 
-	What are the properties of an object oriented database.
-	What is UML? How do you make a class diagram?