|
 Course
Outline
SQL basics and beyond
- Overview of Relational algebra and SQL
- Referential integrity and data manipulation
- Defining and using views
- Fancy joins like full outer joins, union and tjoins
- In depth look at sub queries and co-related sub queries
- The real power of self joins
- Handling numeric, temporal, and NULL data
- Impact of grouping functions like sum, max, min, count and
avg and clauses like GROUP By and HAVING on performance
- Table Pivoting and Folding using characteristic functions
- Relational division
Role of SQL in statistical analysis
- Introduction to statistics
- Use of SQL in statistical analysis through aggregates, mode
and median calculations, cumulative percentages and rankings,
Standard deviation and variances
- Detecting central tendencies
- Region calculations
- Use of subsets
- Array structures in SQL
- Using SQL for matrix operations
Graph and Tree representations in SQL
- Tree and graph structures, tree traversals
- Node and edge representations
- Graph and path enumerations
SQL Optimization
- Query tuning and optimization issues
- Index selection
- Implication of characteristic functions on optimization
- Optimizing Unions, GROUP BY, HAVING & FROM clauses
- Way of optimizing negations like NOT IN and NOT EXISTS
- UNIQUE constraints and its impact on performance
- Use of temporary tables for optimization
Hands-on
Assignments
The key concepts taught will be immediately followed up by the
hands-on assignments in the lab to facilitate ease of understanding.
The lab assignments are based on Oracle and SQL Server environments.
Recommended
Readings
- SQL for smarties : Advanced SQL Programming by Joe Celko -
Morgan Kaufmann, 1995
- The practical SQL handbook : using SQL by Judith Bowman, Sandra
Emerson and Marcy Darnovsky, 1995
Back to Course Description Onsite Training
Class Schedule
Registration
|
