Red Rock Research
 
Home/Courses Professionals Coaching Products Case Studies Press Releases Free Stuff Contact Us
TopBarFadeBlock
  • Welcome1
Seminars . Database Designers and Database Administrators
 

Database Designers & Database Administrators

The Database Professional

Typically, database designers and database administrators share the same role in smaller organizations. From a distance, they certainly appear the same. In reality, however, database designers work in more of a linear pattern structuring new database components towards objectives, while database administrators work in more of a circular pattern performing and rechecking batch jobs and ETL processes.  
 

  

The Database Designer

Database design is a linear process. The database designer works with the development team to construct a data-store for the application to persist user and system information. At some point the database design and the associated application is considered “done” and the combined solution moves into the operations support phase of its lifecycle. This transition represents the end of the database designer role, and the solution is handed off to the database administrator to maintain the daily operational performance of the database.
 
Database designers need to be familiar with the following concepts, in this order:
  1. Table construction, data-types
  2. Keys, complex keys, indexes, column constraints
  3. Simple SQL statements: SELECT, INSERT, UPDATE, DELETE
  4. Database normalization
  5. Referential integrity, primary/foreign keys
  6. Basic database role security
  7. Stored procedures, triggers
  8. Transaction processing, trans-isolation
  9. Entity Relationship Diagram (ERD) tool generators like TOAD, etc.
  10. Advanced database role security
  11. Limit use of CURSORS, limit complex joins
  12. Replication, log-shipping (one-way replication), merge (two-way replication)
  13. Physical configuration performance enhancements
  14. Advanced data-warehousing techniques (snowflake/star schemas, Ralph Kimball/Bill Inmon)
  15. Large-scale database shard techniques
     

The Database Administrator

Database administration is a circular process. The database administrator is tasked with maintaining and making minor adjustments to existing systems. In addition to the above list, database administrators should be skilled in the following concepts:
  1. Recovery mode settings, re-indexing
  2. Extract Translate Load (ETL) tools, bulk inserts
  3. Transaction-blocking resolution
  4. Performance tuning, performance monitoring
  5. Re-indexing, reading index fragmentation levels
  6. Job creation and monitoring
  7. Database clustering

Professionals

 

Non-IT Executives

IT Executives

Development Managers
& Directors

Project Managers

Product Managers
& Business Analysts

Quality Assurance

Developers

Database Designers
& Administrators

  

Course Guide

Download our course brochure containing descriptions of our seminar offerings.
  

 
 
RedRock BottomBar
PMP®, CAPM®, PMI-ACP®, PMI-PBA®, PMBOK® are registered trademarks of the Project Management Institute®
CBAP®, CCBA®, BABOK® are registered trademarks of the International Institute of Business Analysis®
ITIL® is a registered trademark of the Cabinet Office in the UK
© 2007-2016 Red Rock Research - Salt Lake City, UT