Student will be able to;

• Describe the fundamental elements of relational database management systems.
• Explain basic database concepts, including the structure and operation of the relational data model.
• Construct simple and moderately advanced database queries using Structured Query Language (SQL).
• Explain and successfully apply logical database design principles, including E-R diagrams and database normalization.
• Design and implement a small database project using Oracle.
• Explain the role of the database administrator

Topics to covered;

Introduction to Databases

Terminologies

Database Environment

The Relational Model & Relational Algebra

SQL: Data Manipulation and Data Definition

Entity-Relationship Modeling

Enhanced Entity Relationship Modeling

Normalization

Database installation and development environment

Controlling User Access

Changing your passwords

Privileges

Creating users

Granting System Privileges

Creating and Granting Privileges to a Role

Granting Object Privileges

Revoking Object Privileges

Writing SQL Statements

Arithmetic Expressions

Comparison Operators

Data Definition Language

Create and Manage Tables

Create statement

Drop statement

Alter statement

Rename statement

Referential integrity statements

DESCRIBE command

Sequences

Creating a sequence

Using a Sequence

Data Manipulation statement

Insert statement

Update statement

Delete statement

Indexes

Creating an Index

Creating a Synonym for an Object

Retrieving Data Using the SQL SELECT Statement

Basic SELECT statement

Arithmetic expressions and NULL values in the SELECT statement

Column Aliases

Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword

Restricting and Sorting Data

Sorting rows using the ORDER BY clause

Using Single-Row Functions to Customize Output

Using Conversion Functions and Conditional Expressions

General Functions

Reporting Aggregated Data Using the Group Functions

Creating Groups of Data

Restricting Group Results

Restricting Group Results with the HAVING Clause

Advanced Database techniques (Displaying Data from Multiple Tables)

Join statements

Types of Joins

Qualifying Ambiguous Column Names

Applying Additional Conditions to a Join

Returning Records with No Direct Match with Outer Joins

Using Subqueries to Solve Queries

Single-Row Subqueries

Using Group Functions in a Subquery

The HAVING Clause with Subqueries

Multiple-Row Subqueries

Using the ANY Operator in Multiple-Row Subqueries

Creating Views

Retrieving Data from a View

Creating a Complex View

Rules for Performing DML Operations on a View

Introduction to PL/SQL

PL/SQL Block Structure

Create an Anonymous Block

Declaring PL/SQL Variables

Types of Variables

SQL Functions in PL/SQL

Using Sequences in PL/SQL Expressions

Data Type Conversion

Interacting with the Oracle Database Server

SELECT Statements in PL/SQL

Retrieving Data in PL/SQL

Using PL/SQL to Manipulate Data

SQL Cursor

Writing Control Structures

Controlling Flow of Execution

IF Statement

CASE Expressions

Iterative Control: LOOP Statements

Basic Loops

WHILE Loops

FOR Loops

Handling Exceptions

Procedures and Functions

Packages

Database Triggers

Online Instructor led hands on training with supervised labs /Online Sessions / Project

Fundamentals of Database Systems - Ramez Elmasri & Navathe 

Database System Concepts, Fourth Edition - Silberschatz

Oracle Database 11g SQL - The McGraw-Hill Companies, Jason Priceo2. Oracle Database 11g DBA Handbook - The McGraw-Hill Companies, Bob Bryla & Kevin Loney

Database Systems - Thomas Connolly, Carolyn Begg

Links:

http://www.w3schools.com

https://www.tutorialspoint.com/dbms/index.htm

Kindly Dowload and install oracle xe on your laptops. Download the lecture slides in the document section