SQL
A query language
for requesting information from Relational Databases (RDBMS) such
as Microsoft Access, Oracle, Sybase, IBM-DB2 and Microsoft SQL Server.
During the
sessions you will connect to an Oracle Server with an SQL Net client
using the Windows interface. You will write SQL scripts to retrieve
data from these tables, using SQL commands. You will also join separate
tables together and make "joins" to retrieve information.
Syllabus
Database Theory
Introduction to relational databases management systems (RDBMS)
RDBMS Theory and principles
Primary Keys and Foreign Keys
Data integrity and Referential Integrity
Entity Relationship Modelling ERM, Schema
Retrieving Data from the Database
SELECT statement and DML (Data Manipulation Language) commandset
Single Row Functions
Displaying Data from multiple tables
Joins and types of joins
Group Functions and Agregation in SQL
Subqueries, nested subqueries
Overview of Data Modelling and Database Design
Manipulating Data UPDATE, INSERT and DELETE clauses
Creating Views, Indexes and Sequences
