Course Code:
bspsqljrc
Duration:
14 hours
Course Outline:
Introduction to databases and database concepts
Flat File, Hierarchical and Relational
Query Languages
Relations and Normalization
Basic Normal Forms
Introduction to SQL
DDL, DML and DCL
Creating Tables
Simple Queries (SELECT FROM, WHERE, ORDER BY, DISTINCT)
Aggregate Functions (COUNT, SUM, AVG, MIN, MAX)
Joining Tables (INNER JOIN, OUTER JOIN)
Subqueries