shaalaa.com | Introduction
Series 1: playing of 7
to track your progress
Structured Query Language
- General Concepts Data Types SQL COMMANDS SQL functions
- Data Types: NUMBER/DECIMAL,CHARACTER/VARCHAR/VARCHAR2, DATE;
- SQL COMMANDS: CREATE TABLE, DROP TABLE, ALTER TABLE, UPDATE ....SET...., INSERT, DELETE; SELECT, DISTINCT, FROM, WHERE, IN, BETWEEN, GROUP BY, HAVING, ORDER BY; SQL funct ons: SUM ( ), AVG ( ), COUNT ( ), MAX ( ) AND MIN ( ); Obtaining results (SELECT query) from 2 tables using equi-join, Cartesian product and Union
Note: Implementation of the above mentioned commands could be done on any SQL supported software on one or two tables.