Detailed Course Outline
Unit 1 - Creating databases and tables
- • Databases
- • Tables
- • DBSCHEMA, ONCHECK, and ONSTAT
- • Sysmaster
Unit 2 - Altering and deleting databases and tables
- • ALTER
- • Data space reclamation
- • Renaming
- • Dropping
Unit 3 - Creating, altering, and dropping indexes
- • Indexes
- • Sysmaster
- • Forest of trees
Unit 4 - Managing and maintaining indexes
- • Benefits and costs
- • Guidelines
- • Calculating size
Unit 5 - Table and index partitioning
- • Fragmentation
- • Distribution schemes
- • Sysmaster
Unit 6 - Maintaining table and index partitioning
- • ALTER FRAGMENT
Unit 7 - Cost-based query optimizer
- • Access plan
- • Join methods
- • EXPLAIN
- • Scans
Unit 8 - Updating statistics and data distributions
- • UPDATE STATISTICS
- • Distribution information
- • Process
- • Updating statistics
Unit 9 - Managing the optimizer
- • Optimization options
- • Directives
Unit 10 - Referential and entity integrity
- • Integrity
- • Constraints
Unit 11 - Managing constraints
- • Transaction modes
- • Dropping a constraint
Unit 12 - Modes and violations detection
- • Object modes
- • Disabling an object
- • Recording violations
- • Sysmaster
Unit 13 - Concurrency control
- • Isolation
- • Locks
- • Row versioning
Unit 14 - Data security
- • Levels of data security
- • Privileges
- • Roles
Unit 15 - Views
- • Working with views
- • WITH CHECK OPTION
- • Sysmaster
Unit 16 - Introduction to stored procedures
- • Stored procedures
- • Sysmaster
Unit 17 - Triggers
- • Working with triggers
- • Triggers and stored procedures
- • Dropping a trigger
- • Cursors and triggers
- • Triggers and constraint checking
- • Sysmaster
- • Managing triggers
Appendix A - Terminology
- • Terminology
Appendix B - Data types
- • Data types
Appendix C - XML publishing
- • XML publishing
Appendix D - Basic Text Search DataBlade Module
- • BTS DataBlade Module
Appendix E - Node DataBlade Module
- • Node DataBlade Module
Appendix F - Using Global Language Support
- • Using GLS