Getting
Started
- Relational Database Concepts
- The role of SQL
- ANSI 89 & 92 standards
Recap on SQL SELECT Statements
- SELECT statement syntax
- WHERE clause
- Single row functions
- Joining Tables
- ORDER BY clause
- GROUP BY clause
- Aggregate functions
SQL Scripts
- Parameterised queries
- Producing more readable output
- Creating script files
Data Manipulation Language
- INSERT statements
- UPDATE statements
- DELETE statements
- Merging tables
Transaction control
- Principles of transaction processing
- Read Consistency, implicit and explicit locking
- COMMIT
|
Managing Tables
- Viewing the definition of tables
- Creating tables
- Oracle data types
- Altering table definition
- Dropping, re-naming and truncating tables
- Table and column constraints
- The role of Indexes
- Public and Private Synonyms
Managing Views
- Creating a view
- Selecting data using a view
- Update, Insert and Delete through views
- Dropping views
- Altering view definition
- Inline views
Controlling user access to data
- Users, Roles and privileges
- Granting and revoking privileges
- Using synonyms to ease data access
Advanced SELECT statements
- Using set operators
- Controlling the order of rows
- Extensions to GROUP BY clause
- Advanced sub-queries
- Correlated sub-queries
Database Tuning
- Application tuning – Explain plan
- The database balance tri-cotomy
|
