Database Tutorial

Course Tutorial Site

Reading

without comments

Week 5: Reading

After completing Week 4, you should be prepared to read the following four web pages. Each of these web pages may have links and you’re encouraged to look at, as well as read the related web pages.

SQL Joins

Written by michaelmclaughlin

August 11th, 2018 at 3:27 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