Object and Data Labs
  Certificates   Free Newsletter   What's New   Contact
              Sitemap
Main Areas
Onsite Training
Courses
Class Schedule
Registration
Tuition Discounts
Technology Library
Our Instructors
Our Customers
Why Object & Data Labs?

Hot New Courses:
XML: A Comprehensive Introduction
Disaster Recovery Planning

How students rate us

Free Newsletter
Visit our technology library and sign up to receive the latest word in technology from industry specialist.

Certification Available
Visit our certification page to see how you can be on the fast track to certification in advanced technologies.
  Home > Courses > Course Descriptions > Course Details Print Page
Course Description

Advanced SQL Techniques for AnalystsHands-On Course

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

 

  Home | Courses | Class Schedule | Registration | About Us | Contact Call us TOLL FREE at 1-888-230-9052
Copyright 2003-2013, Object & Data Labs All Object & Data Labs Courses are certified courses with UC Berkeley & UCSC extension 

Website by Howard Pugh Web Design
Website maintained by Ann T. Comey