Beyond the first course in database
design and application:
Much more experience with design
and ER modeling
some fairly complex models
…and especially with fine tuning.
More experience with stored
procedures and triggers
when triggers can be helpful and
when they can be a problem
Greater knowledge of T
Greater knowledge of .NET classes
An internship if possible
We just touched on concurrency,
locks, and transactions.
O much more there
especially determining how to define
Also transaction properties (ACID)
Data warehousing (never even
covered in class)
Data mining: use of sophisticated
statistical and mathematical
techniques to perform what
analyses, to make predictions, and to
facilitate decision making.
For example, data mining techniques
can analyze past cell phone usage
and predict which
ustomers are likely
to switch to a competing phone
Retail application. If something is on sale, can you
increase the price of something else to help offset
the price reduction
? And actually come out ahead?
Data mining can help understand consumer buying
Security: there is a class framework
devoted solely to setting up security.
Other databases? It can’t hurt.
Oracle, MySQL, IBM’s DB2
Backup and recovery processes
MUST NOT LOSE DATA