SQL Server Essentials for Oracle DBAs: (09) Schema Management
- Posted: Dec 28, 2012 at 9:10 AM
- 2,519 Views
Module 9 provides the administrative aspect of schema objects described in Module 4. The discussion covers planning, creation and maintenance of many key schema objects. Choices in terms of table and index types, column types, and storage greatly influence the database growth, scalability, performance and maintainability.
- [06:15] - Referential integrity via constraints
- [12:08] - Managing triggers
- [19:18] - Managing indexes
- [34:25] - Managing views
Full course outline:
- Mod 01: Database and Instance
- Mod 02: Database Architecture
- Mod 03a: Instance Architecture Part 1
- Mod 03b: Instance Architecture Part 2
- Mod 04: Data Objects
- Mod 05: Data Access
- Mod 06: Data Protection
- Mod 07: Basic Administration
- Mod 08: Server Management
- Mod 09: Schema Management
- Mod 10: Database Security
- Mod 11: Data Movement
- Mod 12: Backup and Recovery
- Mod 13: Performance Tuning
- Mod 14: Scalability and High Availability
- Mod 15: Monitoring
Comments Closed
Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation,
please create a new thread in our Forums,
or
Contact Us and let us know.
Follow the Discussion
Oops, something didn't work.
What does this mean?
Following an item on Channel 9 allows you to watch for new content and comments that you are interested in. You need to be signed in to Channel 9 to use this feature.What does this mean?
Following an item on Channel 9 allows you to watch for new content and comments that you are interested in and view them all on your notifications page.sign up for email notifications?