This note
explains the following topics: Basic Sql Statements, Restricting and Sorting,
Join Statements, Multiple Column Subqueries, isqlPlus, Types of Sql Functions,
Character Functions, Number Functions, Single Row Numeric Functions, Row
Functions, Subqueries, Conversion Functions, Union, Alter Table and Create
Table.
Author(s): Technology Promotion Center, Ankara, TR
This note covers the following topics:
Multiple simultaneous changes to data, Uses of Databases, Ways to Use SQL, Some
Relational Database Concepts ,Variable Types, CREATE TABLE statement, Entering
observations into a table, Comparison Operators, Updating a Table , The SELECT
statement, Selecting based on Summaries, Subqueries, Making Tables from Queries,
SELECT with multiple tables.