|
This page
indexes the various SQL scripts presented in the SQL202 Introduction
to SQL Using Microsoft SQL Server 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.
Module 2
Joins
Covers inner
joins, cross joins and outer joins.
Subqueries
Uncorrelated,
Negative and Correlated.
Unions
Grouping
and Aggregates
Module 3
Views
Indexes
Modifying
data
Modifying
Data structures
Submit the form below to be notified of new SQL scripts or PowerPoint slides.
We are looking for referrals. Click below to learn more about cash
payments for referrals.
Learn more about this course.
 |
