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