Programming with SQL
Course Description
Introduction
Introduction to Oracle DB and SQL
Relational Database Technology
Anatomy of a SQL Statement
Entities and Attributes
Conceptual and Physical Models
Entities, Instances, Attributes, and Identifiers
Entity Relationship Modeling and ERDs
SELECT and WHERE
Columns, Characters, and Rows
Limit Rows Selected
Comparison Operators
WHERE, ORDER BY, and Intro to Functions
Logical Comparisons and Precedence Rules
Sorting Rows
Introduction to Functions
Single Row Functions
Case and Character Manipulation
Number Functions
Date Functions
Conversion Functions
NULL Functions
Conditional Expressions
JOINs
Cross Joins and Natural Joins
Join Clauses
Inner versus Outer Joins
Self-Joins and Hierarchical Queries
Oracle Equijoin and Cartesian Product
Oracle Nonequijoins and Outer Joins
Group Functions
Group Functions
Oracle Nonequijoins and Outer Joins
Using Group By and Having Clauses
Using Rollup and Cube Operations, and Grouping Sets
Using Set Operators
Subqueries
Fundamentals of Subqueries
Single-Row Subqueries
Multiple-Row Subqueries
Correlated Subqueries
DML and DDL Commands
INSERT Statements
Updating Column Values and Deleting Rows
DEFAULT Values, MERGE, and Multi-Table Inserts
Creating Tables
Using Data Types
Modifying a Table
Constraints
Intro to Constraints; NOT NULL and UNIQUE Constraints
PRIMARY KEY, FOREIGN KEY, and CHECK Constraints
Managing Constraints
Views, Sequences and Synonyms
Creating Views
DML Operations and Views
Managing Views
Working With Sequences
Indexes and Synonyms
Privileges and Regular Expressions
Controlling User Access
Creating and Revoking Object Privileges
Regular Expressions