Database Design and Programming with SQL

Oracle

Database Design and Programming with SQL

(Including Theory, Hands On Practical, Exam Prep)

[enroll_button]

Investment

1500 (LKR)

Campus

Colombo Campus

Level

Professional Certificate

Duration

12 Weeks

This course engages students to implement database models by creating physical databases using SQL. Students will learn basic SQL
syntax and the rules for constructing valid SQL statements to generate report-like output. Demonstrations and hands-on practice
reinforce the fundamental concepts.

Introduction

SELECT and WHERE

WHERE, ORDER BY, and Intro to Functions

Single Row Functions Part I

Single Row Functions Part II

JOINs Part I

JOINs Part II

Group Functions Part I

Group Functions Part II

Subqueries

Ensuring Quality Queries Part I

DML

DDL

Constraints

Views

Sequences and Synonyms

Privileges and Regular Expressions

TCL

Final Project and Exam Review

Ensuring Quality Queries Part II

Oracle