. Define Relational
Database Management System (RDB MS)
. Identify the need for data models
. Create an entity-relationship model
. Map an entity-relationship model
. Map an entity-relationship diagram to tables in an RDBMS
. Convert an unnormalised database to a normalized form.
. Identify an use different types of queries
. Create queries using wildcards, order by, top and distinct
. Use group by, compute and compute by clause
. Use functions and different type of joins |
. Create subqueries using
modified and unmodified operators
. Create tables and constraints
. Create clustered rules and defaults
. Create clustered and non-clustered index
. Use the index tuning wizard
. Create views and batches
. Create stored procedures and triggers
. Create transactions
. Use cursors to display formatted output
. Understand the concept of locking
. Use enterprise manager
. Identify various replication models |
