Database Tutorial

Course Tutorial Site

Articles

without comments

Week 7: Articles

The articles for this week focus on aggregation and the CASE operator. Aggregation adds, counts, and finds the minimum or maximum number of in a set of rows. More or less, aggregation collapses a set of rows into a single row.

Articles

Written by michaelmclaughlin

August 11th, 2018 at 3:43 pm

Posted in

My Technical Blog

Tutorial Pages

Week 1 – Summary
- Reading
- Articles
  - SELECT Statement
- Tutorials
- Lab
- Quiz Review
Week 2 – Summary
- Reading
- Articles
  - DDL Commands
    - CREATE
    - ALTER
    - DROP
    - RENAME
    - TRUNCATE
    - COMMENT
  - Constraints
    - NOT NULL
    - CHECK
    - UNIQUE
    - PRIMARY KEY
    - FOREIGN KEY
- Tutorials
- Lab
- Quiz Review
Week 3 – Summary
- Reading
- Articles
- Tutorials
  - Independent Insert
  - Dependent Insert
- Lab
- Quiz Review
Week 4 – Summary
- Reading
  - Video Store Model
  - Dependencies
- Articles
  - Mandatory Relations
  - Optional Relations
- Tutorials
  - Chained Insert
- Lab
- Quiz Review
Week 5 – Summary
- Reading
  - SQL Joins
- Articles
  - Two Table Joins
  - Three Table Joins
    - Inner Join
    - Self Join
- Tutorials
  - Discover Relations
- Lab
- Quiz Review
Week 6 – Summary
- Reading
  - Table Maintenance
- Articles
  - UPDATE
- Tutorials
- Lab
- Quiz Review
Week 7 – Summary
- Reading
  - Fabrication
    - Literal Fabrication
    - Data Fabrication
  - Set Operators
    - INTERSECT
    - MINUS
    - UNION
    - UNION ALL
- Articles
  - Aggregation
  - CASE Operator
- Tutorials
  - Selective Aggregation
- Lab
- Quiz Review
Week 8 – Summary
- Reading
  - Troubleshooting
- Articles
- Tutorials
  - Data Diagnostics
- Lab
- Quiz Review
Week 9 – Summary
- Reading
  - Thick Databases
  - Stored Programs
- Articles
  - External Tables
  - Indexes
- Tutorials
  - Distinct Operator
  - Date Data Types
- Lab
- Quiz Review
Week 10 – Summary
- Reading
  - Runtime Tables
- Articles
  - Mapping Joins
  - Translating Joins
- Tutorials
  - WITH Clause
  - Embedded Query
- Lab
- Quiz Review
Week 11 – Summary
- Reading
  - Transaction Management
  - ETL Process
- Articles
  - MERGE
- Tutorials
  - MERGE Use Case
- Lab
- Quiz Review
Week 12 – Summary
- Reading
  - Data Transformations
- Articles
  - Selective Aggregation
- Tutorials
  - SQL Reporting
- Lab
- Quiz Review
Week 13 – Summary
- Reading
  - LAMP Architecture
- Articles
  - LAMP Stack
- Tutorials
  - PHP Tutorial
  - PHP Functions
- Lab
- Quiz Review
Week 14 – Summary
- Reading
  - Oracle APEX
- Articles
  - XDB Server
- Tutorials
  - Configure XDB
  - XDB Web Pages
- Lab
- Quiz Review
CIT 225 : Lab Instructions
- CIT225: Lab 1 Instructions
- CIT225: Lab 2 Instructions
- CIT225: Lab 3 Instructions
- CIT225: Lab 4 Instructions
- CIT225 : Lab 5 Instructions
- CIT225 : Lab 6 Instructions
- CIT 225 Lab 10 Instructions
CIT 325 : Lab Instructions
- CIT325: Lab 1 Instructions
- CIT325: Lab 2.1 Instructions
- CIT325: Lab 2.2 Instructions
- CIT325: Lab 3 Instructions
- CIT325: Lab 4 Instructions
- CIT325: Lab 5 Instructions
- CIT325: Lab 6 Instructions
- CIT325: Lab 7 Instructions
- CIT325: Lab 8 Instructions
- CIT325: Lab 9 Instructions
- CIT325: Lab 10 Instructions
- CIT325: Lab 11 Instructions
- CIT325: Lab 12 Instructions
- CIT 325 : Final Project
CIT 225 : Supporting Articles
- WHERE Clause
CIT 325 : Supporting Articles
- Writing a Procedure
About Me
Obsolete Lesson Materials
- Lesson #1: Installations
  - 1 – Intro to Databases
    - A – APEX Create Table
    - D – Modeling in UML
- Lesson Obsolete
- Old Constraints
- Old Lab 2
- Old Lab 5
- Old Lab 6
- Old MySQL Mapping
- Old Oracle Lab 4
- Original ER
- Describe Tables
- Extended ER
- Rerunnable Script
- Describe Foreign Keys
- Information Engineering
- CREATE Statement
- ALTER Statement
- MySQL Data Catalog
- DROP Statement
- Oracle Data Catalog
- Configure Oracle 10g XE
- Lab #1: MySQL Monitor
- RENAME Statement
- Install Oracle 10g XE
- TRUNCATE Statement
- COMMENT Statement
- Configure MySQL 5.1
- Install MySQL 5.1
- Lab #2 : MySQL Tables
- Oracle and Java
- MySQL and Java
- Lab #2 : Create Tables
How to Browse Pages
Privacy Policy
Terms of Service
Lesson #2: Tables
- 1 – Database Constraints
- 2 – DDL Statements
- Lab #2 : Oracle Tables
- Exam #2 : Review Notes
Lesson #3: Modeling Data
- 1 – Data Modeling
- 1 – Normalization
  - Visio Tutorial Movie
- 2 – Inserting Data
- Lab #3 : Inserting Data
- Exam #3 : Review Notes
Lesson #4: Inserting Data
- Single Table Query
- Transaction Management
- Lab #4 : Insert Patterns
- Lab #4 : MySQL Inserts
- Exam #4 : Review Notes
Lesson #5: Querying Data
- Multiple Table Query
- Inline Views
- SQL Functions
- SQL Concatenation
- SQL Date Math
- Lab #5 : Oracle SQL Joins
- Lab #5 : MySQL SQL Joins
- Exam #5 : Review Notes
Lesson #6: Integration
- Subqueries
- Correlated Subqueries
- Insert Query Results
- Data Type Conversions
- Common Lookup Table
- Conditional Logic
- Data Fabrication
- UPDATE Statement
- Using Indexes
- Lab #6: Oracle
- Lab #6: MySQL
- Lab #7: Oracle
- Lab #7: MySQL
- Lab #8: Oracle
- Lab #8: MySQL
- Exam #6 : Review Notes
Lesson #7: Aggregation
- Aggregation
- Intermediate Aggregation
- Oracle External Tables
- MySQL CSV Upload
- MERGE Statement
- Import Transaction Units
- Lab #9: Oracle
- Lab #9: MySQL
- Lab #10: Oracle
- Lab #10: MySQL
- Lab #11: Oracle
- Lab #11: MySQL
Lesson #8: Transformations
- Advanced Aggregation
- Basic Transformations
- Hierarchical Queries
- SQL Statement Tuning
- Lab #12: Oracle
- Lab #12: MySQL
Lesson 9: LAMP
- Client-Server Architecture
- LAMP Architecture
- Basic PHP Tutorial
- PHP Function Tutorial
- MySQL and PHP
- Oracle and PHP
- Zend Server Installation
- Lab #13 : LAMP

Blogroll