|
This page
indexes the various SQL scripts presented in the SQL212 Introduction
to SQL Using Oracle course. They are more or less in the same order
as we cover them in a class. The course topics are loosely drawn from
Jan Harrington's SQL Clearly Explained text along with various other
sources. You should have downloaded and installed the starter
scripts based on the same text to follow along.
The course is
three modules of 1/2 day each. It is intended for beginning SQL
programmers, analysts, power users and others who need to query SQL
data. It is not aimed at certification prep although it can be a good
basis for further study.
Module 1
Database
Design
Entity
Relationship diagram (ERD) of the bookstore database used in this course.
Basic
data retrieval
Basics of SQL data retrieval using the SELECT
statement with and without filter conditions.
Special
Operators
Like, in, is null and between.
Select
Finishing touches
Removing duplicates, sorting, top values
Module 2
Joins
Covers inner
joins, cross joins and outer joins.
Subqueries
Uncorrelated,
negative and correlated.
Unions
Union operator.
Calculations
and Aggregates
Calculated
fields, concatenation, group by, having, SQL aggregate functions.
Module 3
Modifying
data
Insert,
update and delete statements.
Views
Indexes
Modifying
Data structures
Submit the form below to be notified of new tutorials, scripts and
PowerPoint slides. We are working on an intermediate course which
will more or less follow the same outline.
Learn more about this course.
 |
