DBASESQL - SQL Using dBASE Plus
This course covers ANSI SQL and Local SQL as it is used in dBASE Plus and most database management systems (DBMS). Using dBASE Plus as a tool to model SQL statements, the user is introduced to all of the basic SQL commands, including SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER and DROP. Also covers GROUP BY, JOIN, HAVING, Aggregation, Functions and Expressions.
Covers both DML and DDL aspects of SQL, with lots of hands-on examples. Also covers how SQL is implemented in dBASE, and how to use SQL to perform common client/server programming tasks. Very good SQL primer for dBASE programmers.
"I knew nothing about SQL before this course. Everything I learned was important, even in those areas where I am not likely to be using the information. All dBASE programmers should attend the course. Ted Blue is actively concerned about the student's comprehension of the material presented. He keeps a careful watch on the reaction to the material presented and is quick to bring new emphasis on the subject when necessary.." -- Dwight P. from San Diego, CA
"Attend, it's information you will need to maximize the performance of your programs. [The instrucor was] Outstanding, Clear; precise examples that can be followed and comprehended.." -- James B. from San Diego, CA
"Take it ... an invaluable course it seems to me for the material we will be dealing with.." -- Josh K. from Bismark, ND
"Speaker was well informed and was easy to follow. Class flowed smoothly because instructor
worked in questions to presentation.." -- Deb S. from Bismark, ND
"The material was presented very well. Ted was very receptive of questions during the
presentation. I would recommend others to take this course. I thought the material and presentation was excellent.." -- Betty E. from Bismark, ND
Relational Database Objects
Tables
Columns
Rows/Records
Keys
Primary Keys
Foreign Keys
Indexes
Structured Query Language
Codd's 12 Rules
Data Manipulation Language (DML)
Result Sets
Data Definition Language
Queries with SELECT
Writing Queries with SELECT
Column and Tables Specification
Structure of SELECT Statements
Operators
Arithmetic Operators
Plus (+)
Column Name Aliasing
Using WHERE Clauses
Conditions
Comparison Operators
NULL
Equal (=)
Greater Than (>) and Greater Than or Equal To (>=)
Less Than (<) and Less Than or Equal To (<=)
Inequalities (<> or !=)
Character Operators
Using Functions on Result Sets
Aggregate Functions
COUNT()
SUM()
AVG()
MIN()
MAX()
Arithmetic Functions
ABS()
CEIL() and FLOOR()
COS(), COSH(), SIN(), SINH(), TAN(), and TANH()
EXP()
LN() and LOG()
POWER()
SIGN()
SQRT()
Character Functions
LOWER() and UPPER()
SUBSTR()
Other Character Functions
CHR()
INITCAP()
LPAD() and RPAD()
LTRIM() and RTRIM()
REPLACE()
INSTR()
LENGTH()
Combining Functions
More SELECT Clauses
The ORDER BY Clause
The GROUP BY Clause
The HAVING Clause
Joining Tables
Cartesian Joins
Equi-Joins
Table Name Aliasing
Non-Equi-Joins
Subqueries with Embedded SELECT Statements
Building a Subquery
Using EXISTS, ANY and ALL
Corelated Subqueries
ANY and ALL
Set Operations with IN
Adding Data with INSERT
The INSERT Statement
Adding Rows Using SELECT
Modifying Data with UPDATE
The UPDATE Statement
Removing Data with DELETE
The DELETE Statement
Using Views to Simplify Data
The CREATE VIEW...AS Statement
Creating a View
Displaying a View
View Restrictions
Customizing VIEWS
Setting Column Names in a View
Using a View in a Join
Joining Tables with VIEWs
Removing Views
Implementing Indexes
The CREATE INDEX Statement
Removing INDEX's