|
PART I | KNOW THY DATABASE |
|
SECTION: | Creating Robust Metadata |
|
Topic 1: | Thinking about design |
|
Topic 2: | Creating a concrete foundation |
|
Topic 3: | Designing for database replication |
|
Topic 4: | Using domains and datatypes |
|
Topic 5: | Creating data for international databases |
|
Topic 6: | Building intelligence with constraints and triggers |
|
Topic 7: | Manipulating data with stored procedures |
|
Topic 8: | Controlling access with SQL privileges |
|
Topic 9: | Optimizing data access with indexes |
|
Topic 10: | Extending the server with UDFs |
|
Topic 11: | Communicating with the client: Events and Exceptions |
|
Topic 12: | Importing and exporting text records using external files |
|
SECTION: | Runtime Issues |
|
Topic 1: | Optimizing the server platform |
|
Sub-Topic (1a): | Windows |
|
Sub-Topic (1b): | Linux |
|
Sub-Topic (1c): | Solaris |
|
Sub-Topic (1d): | **nix |
|
Sub-Topic (1e): | Novell Netware |
|
Topic 2: | Configuring and testing the network |
|
Sub-Topic 2(a): | TCP/IP |
|
Sub-Topic 2(b): | Windows Networking |
|
Sub-Topic 2(c): | IPX/SPX |
|
Sub-Topic 2(d): | Mixed protocols |
|
Topic 3: | Understanding InterBase system tables |
|
Topic 4: | Securing the server |
|
Topic 5: | Encrypting a client/server system |
|
Topic 6: | Performing database maintenance |
|
Topic 7: | Using the Services API |
|
Topic 8: | Testing under load |
|
SECTION: | Troubleshooting InterBase Clients and Servers |
|
Topic 1: | Determining a cause for a problem |
|
Topic 2: | Diagnosing error reports |
|
Sub-Topic 2(a): | Errors in interbase.log |
|
Sub-Topic 2(b): | Errors from the database (Events, Exceptions, BDE, IBObjects) |
|
Topic 3: | Diagnosing installation problems |
|
Topic 4: | Diagnosing performance problems |
|
Topic 5: | Diagnosing crash and corruption problems |
|
Topic 6: | Diagnosing memory leaks |
|
Topic 7: | Diagnosing network problems |
|
SECTION: | Deploying InterBase Applications |
|
Topic 1: | Distributing & licensing |
|
Topic 2: | Installing & uninstalling |
|
Topic 3: | Updating after deployment |
|
SECTION: | The Way InterBase Works |
|
Topic 1: | The on-disk structure and BLR |
|
Topic 2: | The Y-valve |
|
Topic 3: | The Lock manager |
|
Topic 4: | Versioning and multi-generational architecture |
|
Topic 5: | Transactions |
|
Topic 6: | Classic vs Superserver |
|
Topic 7: | The life of a SQL request |
|
Topic 8: | Internals of the Active Database |
|
Topic 9: | What Sweeps and Backups do |
|
|
PART II | WRITING CLIENT APPLICATIONS |
|
SECTION: | Understanding client/server methodology |
|
Topic 1: | No details |
|
SECTION: | The InterBase API |
|
Topic 1: | No details |
 |
