PL/SQL Programming With Oracle
Course Contents Listing

Class Overview Register


Foundations
  1. Scales and Measurements
  2. Encoding Schemes
  3. Data Types
  4. Reasonable Data
  5. Rounding
  6. Reports vs Queries
  7. History of SQL
Normalization and Modeling
  1. Data Modeling
  2. Keys and Identifiers
  3. Normal Forms 1
  4. Normal Forms 2
  5. Data Redundancy
SQL Programming Tricks
  1. Joins
  2. Views
  3. Hierarchies
  4. Extrema functions
  5. Indexes
  6. Aggregate Functions
  7. Insert, Update, Delete
SQL Programming Tricks / Newer SQL
  1. Auxiliary Tables
  2. Case
  3. Windows Clause
  4. Groups, Rollups and Cubes
  5. Merge
  6. Advanced Constraints
Misc. SQL and RDBMS Topics
  1. EmbeddedSQL
  2. Data Warehousing
  3. Fix the Leak
  4. Temporal Data
  5. Data Control Language

 



    Copyright © SQLUniversity.net