Thursday, October 2, 2014

If You Could Teach a Course on Database Design, What Would You Cover?

I am teaching an introduction to database design course next year and I have sketched out the course below.  I would love to hear from other database professionals to find out what you feel should be included in a first course.

Outline of Course

1. Currently popular RDBMS implementations (oracle, sql server, MySQL) and how each is typically used.

2. Tables and datatypes.

3. What does "relational" mean?

4. Querying - selects, updates, deletes.

5. Normalization and why it's useful.

6. Transactions and isolation levels.

7. Programming - stored procedures, triggers, functions, cursors.

8. Database engine optimization, query plans, indexes.

9. Oltp vs olap - how highly transactional systems dictate different database design then systems that are primarily for reporting.

10.  Advanced topics - big data, BI, no sql, data visualization.


About the Author:
Noah Meyer, aka The SQL Fix-It Guy, is a Denver-based database developer, trainer and coach and has spent the past two decades helping leading organizations (banks, hospitals, energy companies and government agencies) improve their reporting capabilities by fixing and fine-tuning their customized software implementations. 

No comments :

Post a Comment