|
| Database Seminars |
Designing for Performance
• Transactional vs. Query Tables
• Indexing
• Denormalization
• Row Column Layout
• Table Partitioning
• Addressing Data Contention
• Storage Considerations
Other Design Issues
• Selecting Database or Database Management System Software
• Operating Environment Considerations
• Referential Integrity Enforcement and Implications
Constructing the Database
• Creating the Database Objects
- The Schema
- Creating Tables, Indexes, Constraints and Views
- Using SYNONYMs
- Using Table and Column COMMENTs
• Creating ROLEs and GRANTing Privileges
• Managing Database Objects
- Dropping Tables, Indexes and Views
- Revoking Privileges
- ALTERing Tables, Indexes and Views
- Enabling and Disabling Constraints
• Backup and Recovery Planning
Populating the Database
• Creating and Manipulating Data
- INSERT
- UPDATE
- DELETE
- TRUNCATE
• Controlling transactions
- COMMIT
- ROLLBACK
- SAVEPOINT
• Data Loading Utilities
Basic SQL Queries
• Displaying Table Structures
• SELECTing Column Data FROM a Table
• SELECT DISTINCT values
• COUNTing rows
• Restricting Rows Using the WHERE Clause
• Using Operators
- Logical
- Mathematical
- Comparison
- Concatenation
• Sorting Results Using ORDER BY
• Joining Multiple tables
Manipulating and Summarizing Results
• Using Row Functions
• Using Column Functions
• Handling NULLs
• Aggregating Results Using GROUP BY
• Restricting Groups with the HAVING Clause
Advanced Query Techniques
• Outer Joins
• Set processing: UNION, MINUS and INTERSECT
• Subqueries
• Tips for Developing Complex SQL Queries
|
|
