What world changes are affecting our perspective on data and databases?
What are some current issues and challenges in the field of databases?
What problems arise with massive, available datastores and why do we care?
What is an object-oriented database?
What are the differences between and OODB and and RDB?
What are some benefits and drawbacks to using an OODB, compared to a RDB?
What is the difference between a database user and an application user?
What are the three main layers of security for database systems?
How does a logical backup differ from a physical backup?
What are some rules of thumb for achieving high performance in a DBMS?
How is a database like a garden?
What are the two main approaches toward system design?
What is load balancing? What is clustering?
What is RAID? What is a SAN?
What is virtualization?
What are some factors that influence your database system design?
Q&A re: transactions, stored procs, triggers.
What is a view?
What is a stored procedure?
What is the difference between a stored procedure and a stored function?
What is a trigger?
How do you implement a stored procedure in MySQL?
What is a transaction?
How do you declare a transaction?
What problems arise with concurrency?
What are two main approaches to concurrency?
What is ACID?
How do you use a database from Python?
What do most platforms share in common regarding database programming?
What are the differences between code generation and metaprogramming, particularly in regard to ORMs?
Why use Hibernate (or any Java ORM)?
What is lazy loading? What is eager loading?
How do you use a database via Perl?
What is a prepared statement?
What is JDO?
What is JPA?
What are some common JPA implementations?
How do you use Hibernate to store objects in a database?
What is a data warehouse?
What are dimensions, facts and star schemas?
How do you use a database via JDBC?
What is a (connected) ResultSet? What is a (disconnected) RowSet?
What is SQL injection?
What are three ways to work with a database via Ruby?
What is ActiveRecord and how do you use it?
What is the DAO pattern?
What is a Data Transfer Object?
What is an ORM layer?
What is an application framework?
What are some common PHP application frameworks for database-driven applications?
What is the DRY principal?
How can you encapsulate common database work in a PHP5 object?
What is the Singleton design pattern?
What is a CHECK constraint and how do you declare one?
What is the most common architecture for database-driven applications?
How do you use a database on the PHP5 platform?
What is a constraint?
What is a foreign key constraint and how do you declare one?
What is a UNIQUEness constraint and how do you create one?
What is an index and how do you create one in MySQL?
What are some common gui tools for working with MySQL?
Why should I be proficient with both a tool and the command line?
In-class midterm review
What is normalization? What's the point?
What is denormalization? What's the point?
What is a correlated subquery?
In-class quiz review
What is an alias?
What is an aggregate function?
What is a subquery?
'task list' database design continued
What is the SQL syntax for a JOIN?
What is the SQL syntax for an OUTER JOIN?
Mandatory project entities/tables
'task list' database design continued
In-class collaborative review of data model, schema
What are some 'rules' when designing a database schema from an ER diagram?
How would you design the database for a 'task list' application (phase 2)?
How would you design the database for a simple 'task list' application?
What are some types of JOINs?
What is relational calculus? Why do we care?
What is a declarative language, as compared to a procedural language?
What is a JOIN?
What MySQL utility allows you to 'export' your database?
Why do we care about relational algebra?
What are the five primary relational operators?
What is the SQL command for creating a table?
Why do we care about relational algebra?
What are the five primary relational operators?
Why is it called a relational database?
What is a relation?
What is a relvar? What is a tuple?
What does NULL mean?
What are some common constraints?
What are the four primary operations on a relation?
What does the EER Model provide?
What is UML?
What mechanisms are used to configure MySQL?
What is in the bin directory?
What are the MySQL commands for:
What is a relationship? A binary relationship? Ternary? Recursive?
What is a constraint?
What are the two primary constraint types?
What is a weak entity?
What are some kinds of attributes?
What is an entity type? What is an entity set?
What is a key?
What is the ER Model?
What is an entity? What is an attribute?
What steps are involved in designing a DB?
What is a data model?
What is a schema?
So... how does it all work? (high-level)
What is a database? What is data?
What is an RDBMS?
Why should one use an RDBMS? Why not?